close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Business Intelligence Reporting courses

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Power BI Course Outline

Introduction to Power BI

  • What is Power BI?
  • The Power BI service
  • Power BI Report Server
  • Power BI Desktop
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Natural Language Queries

​​Data Sources

  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Managing Data Relationships
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Configuring Data for Q&A
  • Creating Content Packs
  • Creating a Group

Shaping and Combining Data

  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data

Modelling Data

  • What are the Relationships?
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • What is DAX?
  • Syntax
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures

Interactive Data Visualisations

  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualisations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Service Settings
  • Desktop Settings
  • Dashboard and Report Settings

Enquire Now to Get Free Advice from The Knowledge Academy Microsoft Power BI Training Experts!

Show moredown

Who should attend this Microsoft Power BI Training Course?

The course is designed for users that have a desire to work effectively with data to create visually appealing reports or dashboards.

Prerequisites

There are no prerequisites for this Power BI Course - it is open and accessible to all individuals that wish to enhance their knowledge of Power BI. 

Microsoft Power BI Training Course Overview

The Knowledge Academy is Globally Recognised as the Market Leader in providing Microsoft Power Bi Training. Our "Microsoft Power BI Experts” comprises of over 251 leading Industry Experts who on average have more than 5 years of industry recognised teaching experience. Our instructors have developed a unique teaching style to help aspiring Learners to master the art of managing data and creating powerful dashboards to make intelligent business decisions. Our Award-Winning Power BI Training Course Instructor will guide you step by step on gaining Power Bi Skills. All the topics and units are broken down in an easy to learn manner, making the course extremely enjoyable and our friendly instructors delight all our learners to use Power BI successfully.

Learn how to turn data into powerful insights that direct and drive informed business decisions - giving your business the edge over competitors. By taking our Microsoft Power BI training course, anyone can become a competent data analyst. 

The user-friendly Power BI reporting application has been designed to help users, of all experiential levels, produce insightful data analysis - hence our interactive and highly engaging BI training course helps candidates across departments communicate performance-related data in a visually understandable manner. 

The Microsoft Power BI tool allows you to extract, analyse and comprehend large quantities of data - helping to ensure that you can present data in a logical manner and make informed business decisions. The Microsoft Power BI is the most user-friendly report-based analytical tools, that is transforming the way that businesses read their performance data.

Driving ad-hoc analysis and promoting the creation of personalised data dashboards, learning how to utilise the Power BI enhances an individual’s and business’s potential. During this extensive and interactive one-day Power BI course, candidates will learn how to publish reports directly onto the Power BI Report Server - enabling colleagues and stakeholders to appreciate the insightful data analysis from their phones, tablets, and laptops. Additionally, the flexibility of the Power BI Suite is demonstrated by the ability to unify your organisation's data by uploading and sharing information on Cloud-based platforms - our engaging trainers will show you how to share your data analysis with stakeholders on the Cloud too.

Enquire Now to Get Free Advice from The Knowledge Academy Microsoft Power BI Training Experts!

Show moredown

What’s Included in this Microsoft Power BI Training?

  • The Knowledge Academy’s Microsoft Power BI Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Crystal Reports Masterclass Outline

This course will cover the following:

Overview

  • Explore Crystal Reports  
  • Reports and Databases
  • Use Crystal Reports Help  
  • Customise the Report Settings

Working with Reports

  • Create a Report  
  • Modify a Report  
  • Display Specific Report Data  
  • Work with Report Sections

Using Formulas in Reports

  • Create a Formula  
  • Edit a Formula  
  • Filter Data Using a Formula  
  • Work with Advanced Formulas and Functions  
  • Handle Null Values

Building Parameterised Reports

  • Create a Parameter Field  
  • Use a Range Parameter in a Report  
  • Create a Prompt

Grouping Report Data

  • Group Report Data  
  • Modify a Group Report  
  • Group Using Parameters  
  • Create a Parameterised Top N Report

Enhancing a Report

  • Format a Report  
  • Insert Objects in a Report  
  • Suppress Report Sections  
  • Use Report Templates

Creating a Report from Excel Data

  • Create a Report Based on Excel Data  
  • Modify a Report Generated from Excel Data  
  • Update Data in a Report Based on Excel Data

Distributing Data

  • Export Data  
  • Create Mailing Labels

Show moredown

Who should attend this Crystal Reports Training

This course is designed for professionals who require output from a database and would like to develop their skills in using Crystal Reports to do so.

Prerequisites

There are no formal prerequisites for enrolling on this Crystal Reports Masterclass. However, delegates should be familiar with the basic functions of Microsoft Windows and have an understanding of basic database concepts.

Crystal Reports Masterclass Overview

This one-day Crystal Reports Masterclass provides delegates with tips and tricks on how to optimise their use of Crystal Reports through specific techniques and features. Crystal Reports is a Business Intelligence Application, used by professionals to design and create business reports quickly and easily from almost any data source, including Microsoft Excel, Oracle and SQL databases, and Business Objects. Reporting tools are required by organisations to access data and create tailored reports, as often database programmes alone do not facilitate these requirements. Furthermore, Crystal Reports provides additional benefits for businesses, as this highly useful tool enables its users to share their unique business reports with important stakeholders.

The principal objective of this Crystal Reports training course is to provide every delegate with the vital information needed to make the most of this essential report writing application. A selection of the most pivotal tips and tricks will be taught, allowing delegates to add value to their reports, making them more relevant, and increasing their usefulness when assessing information. By the completion of this training course, candidates will have been taught the skills necessary to create dynamic, interactive business reports. This will then allow the reader to assess information efficiently and make informed decisions.

Show moredown

What’s Included in this Crystal Reports Training?

  • The Knowledge Academy’s Crystal Reports Masterclass Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Cognos BI Reporting Course Outline

The 1-day Cognos BI Reporting course will give delegates the understanding and awareness of the advanced analytical platform.

The following topics will be taught during this course:

Cognos BI Reporting Fundamentals

  • Types of Data
  • Data Processes
  • Business Intelligence
  • Reporting Fundamentals
  • Objects

 

Creating OLAP connections

 

Report Components

  • Business Insight Advanced Interface
  • Toolbox Tab
  • Source Tab
  • Toolbar and Menu

 

Creating Reports

  • Active Report
  • Summarisation Function
  • Filter Reports
  • Combined Filters
  • Custom Filters
  • External Data

 

Creating Charts

  • Column Charts
  • Line Charts
  • Scatter Charts
  • Pie Charts
  • Pareto Charts
  • XML Specification
  • Chart Colours

Show moredown

Who should attend this Cognos BI Training Course?

The Cognos BI Reporting qualification has been designed for:

  • Company Executives
  • Power Users
  • Managers
  • Business Analysts

Prerequisites

There are no prerequisites for taking this course but it is recommended that delegates research and understand the Cognos tool.

Cognos BI Reporting Course Overview

Cognos BI (Business Intelligence) is a web-based reporting and analytic tool. The application is used to create user-friendly reports which can be shared with the business in XML or PDF format.

Cognos delivers a large variety of components to provide an adaptable reporting atmosphere that can be used for any type of industry. This advanced tool allows both analysts and business executives to summarize and organise data in different templates so that it is easier to view for both users.

Show moredown

What’s Included in this Cognos BI Training Course

  • The Knowledge Academy’s Cognos BI Reporting Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Business Objects Reporting​ Course Outline

This Business Objects Introduction Reporter course explores the following topics:

The Business Objects Environment:

  • Documents
  • Reports
  • Blocks
  • Universes, Classes, and Objects
  • Data Providers
  • The Training Course Universe

The User Interface:

  • Toolbars and Menus
  • Help
  • The Report Manager
  • The Status Bar

Opening and Retrieving Documents:

  • Opening, Saving, and Closing Documents
  • Retrieving Documents
  • Sharing Documents

Modifying Reports and Analysing Data:

  • Editing Blocks to Manipulate Data
  • Adding Blocks to an Existing Report
  • Master/Detail Reports
  • Adding New Reports to a Document

Creating and Editing Queries:

  • Using the Query Panel
  • Editing Queries
  • Building Queries
  • Running Queries
  • Saving Queries

Restricting Data with Conditions:

  • Simple Conditions
  • User Defined Single Value Conditions
  • Pre-Defined Conditions

Using Functions:

  • Filtering Data
  • Sorting Data
  • Ranking Data
  • Using Alerts
  • Inserting Simple Calculations

Presentation Styles:

  • Tables, Crosstabs, and Charts
  • Using/Applying Templates
  • Formatting Blocks, Pages, and Breaks
  • Special Fields
  • Using Headers and Footers
  • Adding Logos and Pictures
  • Creating Templates

Show moredown

Who should attend this Business Objects Reporting Training Course?

This Business Objects Introduction Reporter training course is designed for those who have no or little experience in Business Objects, and are interested in constructing reports using the program.

Prerequisites

There are no prerequisites, so anyone can attend. 

Business Objects Reporting Course Overview

With Introduction Reporter training, delegates will learn how to devise and develop reports using Business Objects. Delegates will gain an understanding of what it takes to create reports using the Business Objects program.

Delegates will delve into a Business Objects setting and will become familiar with the user interface, launching and retrieving documents, editing reports, and analysing data. Other subjects examined in the Introduction Reporter training course include query formulation and refinement, limiting data through the use of conditions, functions, and presentation types. Business Objects Introduction Reporter is a one-day training course, and there is no examination. 

Show moredown

What’s Included in this Business Objects Reporting​ Training Course?

  • The Knowledge Academy’s Business Objects Reporting Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Business Objects Web Intelligence Reporter Course Outline

Business Objects Web Intelligence Reporter explores the following topics:

The Web Intelligence Launch Pad:

  • Customising User Preferences
  • Folders and Categories
  • Opening Documents in the Reading View
  • Opening Documents in the Java Enabled Design View

Working in the Java Enabled Design View:

  • Documents
  • Reports
  • Blocks (Vertical Tables, Horizontal Tables, Cross Tables, Charts, and Forms)
  • Universes, Classes, and Objects
  • The Training Course Universe

The User Interface:

  • Toolbars and Menus
  • Help
  • The Data/Properties Panel
  • The Status Bar

Opening and Sharing Documents:

  • Opening, Saving, and Closing Documents
  • Retrieving Documents from Inbox and Public Folders
  • Sharing Documents with Others
  • Scheduling Documents to Run and Distribute Automatically

Modifying Reports and Analysing Data:

  • Editing Blocks to Manipulate Data
  • Adding Blocks to an Existing Report
  • Creating Sections in Reports
  • Adding and Formatting Breaks
  • Adding New Reports to a Document

Formatting Documents:

  • Borders and Shading
  • Adding Headers and Footers
  • Adding Pictures and Logos
  • Setting Cell, Table, Section, and Page Properties
  • Controlling Page Breaks in Printed Output
  • Special Fields

Creating and Editing Queries:

  • Understanding Queries
  • Editing Queries
  • Building and Running a New Query

Restricting Data with Query Filters:

  • Simple Query Filters
  • User Defined Single Value Query Filters
  • Pre-Defined Query Filters
  • Using Query Prompts

Using Functions:

  • Filtering Data
  • Sorting Data
  • Ranking Data
  • Grouping Data Values
  • Setting Conditions (Alerters)
  • Inserting Simple Calculations

Creating Formulas and Variables:

  • Adding a Formula to a Block
  • Understanding the Difference Between a Formula and a Variable
  • Defining a Formula as a Variable
  • The v_ Convention for Naming Variables

Show moredown

Who should attend this Business Intelligence Training Course?

This Web Intelligence Reporter course is suitable for designers who need to access and investigate collaborative information using InfoView and Web Intelligence.

Prerequisites

There are no prior requirements for this training course, so anyone can attend. 

Business Objects Web Intelligence Reporter Course Overview

This Web Intelligence Reporter training course provides delegates with the relevant knowledge and abilities to query, access, analyse and share information using Business Objects. Delegates will learn how to create strong queries and present clear, coherent reports.

This Web Intelligence Reporter training course is delivered via instructors in a classroom ambience. Areas covered include Web Intelligence, the Java design view, the user interface, and working with documents. Also, delegates will acquire knowledge of queries, using functions, and generating formulas and variables.

On course completion, delegates will be able to effectively manage personal and shared files so that any data can be accessed at any time. They will also be able to produce their own reports using Business Objects. The duration of this Web Intelligence Reporter course is one day, and there are no exams. 

Show moredown

What’s Included in this Business Intelligence Training Course?

  • The Knowledge Academy’s Business Objects Web Intelligence Reporter Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments
 

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Business Objects Desktop Intelligence Advanced Reporter Course Outline

This Business Objects Desktop Intelligence Advanced Reporter Course is comprised of the following subjects:

Editing Reports:

  • Editing Blocks
  • Applying and Formatting Filters
  • Applying and Formatting Sorts

Formatting Reports:

  • Creating and Using Templates
  • Page Formatting Options
  • Formatting Tables and Sections
  • Adding Page Breaks
  • Formatting Charts
  • Aligning Cells and Blocks

Restricting Data with Conditions:

  • Multi-Value Conditions
  • Using Logical Operators (AND/OR)
  • Pre-Defined Conditions
  • Prompted Condition Queries
  • Using Wildcards in Queries
  • Displaying Prompt Criteria in Reports
  • Creating Subqueries
  • Combine Queries (Union, Intersect, and Minus)

Using Multiple Data Providers:

  • Understanding Data Providers
  • Multiple Queries from a Single Universe
  • Naming and Using Data Providers
  • Querying Multiple Universes in a Single Document
  • Using Personal Data Files (e.g. Microsoft Excel Spreadsheets) as Data Sources
  • Synchronising Data Providers by Linking
  • Numeric Data Format Issues

Defining and Using Variables:

  • Creating Variables
  • Resetting Calculations Across Breaks
  • If/Then/Else Variables
  • The Group Function
  • Creating a Variable Using the Group Function
  • Understanding Calculation Contexts

Using Slice and Dice:

  • Slice and Dice View
  • Converting Tables to Crosstabs
  • Converting Table Blocks to Charts
  • Adding Breaks, Totals, Filters, and Other Functions

Drilling:

  • Understanding Hierarchies
  • Setting the Scope of Analysis
  • Pre-Defined Hierarchies
  • Drilling on Single and Multiple Hierarchies
  • Creating Custom Hierarchies
  • Drilling on Charts
  • Displaying Drill Information
  • Saving Snapshots

Exporting Data for Use in Other Applications:

  • Exporting Data from a Block
  • Exporting Data from a Data Provider

Show moredown

Who should attend this Business Intelligence Training Course?

This training course is designed for those who have been introduced to Business Objects, and are wishing to expand their knowledge.

Prerequisites

There are no formal prerequisites for attending this course.

Business Objects Desktop Intelligence Advanced Reporter Course Overview

This Business Objects Desktop Intelligence Advanced Reporter training course teaches delegates some clear, practical techniques that will boost productivity with Business Objects. This course is the next step after the Business Objects introductory certification, as it expands on knowledge acquired at this beginner’s level.

Nevertheless, during the Desktop Intelligence Advanced Reporter training, elements from the introduction course are revisited in order to refresh delegate understanding. Topics covered within this one-day training course include the refinement and formatting of reports, using conditions to restrict data, multiple data providers, and the use of variables. Likewise, delegates will also learn about the technique of slice and dice, drilling, and exporting data.

Show moredown

What’s Included in this Business Intelligence Training Course?

  • The Knowledge Academy’s Business Objects Desktop Intelligence Advanced Reporter Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

Show moredown

Online Instructor-led (2 days)

Classroom (2 days)

Online Self-paced (16 hours)

MicroStrategy 10 Training Course Outline

  • Introduction to MicroStrategy – Architecture, Component, Developer, Desktop, Configuration and Connectivity with Database
  • MicroStrategy Objects, Dashboards and Office
  • New Features of MicroStrategy 10
  • MicroStrategy Reporting
  • Formatting a Report
  • Analysing Data
  • Filters, Drilling and Hierarchies
  • Refreshing Data and Answering Report Prompts
  • Creating a Query for Analysis
  • Creating Quick Queries and Objects for Designers

Show moredown

Who should attend this MicroStrategy Training Course?

This training course is designed for those individuals who wish to create, read, write, and modify BI Reports and dashboards using MicroStrategy Desktop. It will be beneficial for people who wish to become a Data Analyst or a Data Scientist.

MicroStrategy Prerequisites

It is recommended that the delegates should possess some basic knowledge of SQL, relational database (Oracle), data analysis and a basic understanding of computer programming terminologies for this course.

MicroStrategy 10 Training Course Overview

MicroStrategy is an enterprise BI (Business Intelligence) and OLAP (On-line Analytical Processing) software vendor, which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files, and Hadoop distributions. It supports scorecards, dashboards, ad hoc queries, automated report distribution, and highly formatted reports.

MicroStrategy 10 is a leading Data Visualisation platform in the market. This MicroStrategy 10 Training course will assist the delegates in creating, monitoring, and scheduling the BI reports and dashboards processes. Delegates will learn to design schema objects by using the Architect design tool.

MicroStrategy is the largest independent BI organisation. The average salary for a “MicroStrategy” ranges from $80,000 (per year for a Data Analyst) - $145, 000 (per year for a Senior Architect) annually.

Show moredown

What's Included in this MicroStrategy Training Course?

  • The Knowledge Academy’s MicroStrategy 10 Training Manual
  • Experienced Instructor
  • Completion Certificate
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

MiniTab Training Outline

  • Introduction on MiniTab
    • What is MiniTab
    • Use of MiniTab
    • Minitab User Interface
    • Projects and Worksheets
    • Data Types
    • Examine a Worksheet
  • Graphing Data
    • Create, Interpret, and Edit Histograms
    • Create and Interpret Scatterplots with Minitab Assistant
    • Arrange Multiple Graphs on a Single Page
    • Save a Project
  • Analysing Data
    • Display Descriptive Statistics and Interpret the Results
    • Compare Two or More Means
    • Use Minitab’s Project Manager
  • Assessing Quality
    • Introduction to Assessing Quality
    • Create and Interpret Control Charts
    • Update a Control Charts
    • Add Time/Date Labels to a Control Chart
    • Perform and Interpret a Capability Analysis
  • Designing an Experiment
    • Overview
    • Create a Factorial Design
    • View Design and Enter Data in the Worksheet
    • Analyse a Design and Interpret the Results
    • Use of Stored Model
  • Using Session Commands
    • Enable and Enter Session Commands
    • Perform Analysis using Session Commands
    • Re-execute a Series of Commands
    • Create and Run an Exec File
  • Generating a Report
    • Add a Graph to the ReportPad
    • Add Session Window Output to the ReportPad 
    • Edit and Save a Report
    • Copy the ReportPad Contents to a Word Processor
    • Send Output to Microsoft PowerPoint
  • Preparing a Worksheet
    • Learn to Open Worksheet, Excel File and Text File
    • Combine the Data into one Worksheet
    • Move and Rename a Column
    • Record the Data
    • Insert and Name a New Data Column
    • Assign a Formula to a Column
  • Customising MiniTab
    • Change Default Options for Graphs
    • Create a Customer Toolbar
    • Add Commands to a Custom Toolbar
    • Assign Shortcut Keys for a Menu Command
    • Restore Minitab’s Default Options

Show moredown

Who should attend this MiniTab Training Course?

Individuals looking to learn data analysis using MiniTab can attend this course. It is well suited for:

  • Quality System Managers
  • Analysts
  • Quality Engineers

MiniTab Prerequisites

No prerequisites are required for this course.

MiniTab Training Overview

Minitab is a statistical analysis software that allows the user to create, control and restructure data, generate a variety of graphs from simple charts to detailed diagrams and perform comprehensive statistical analysis. This software helps you to find the appropriate solutions to your business problems.

This MiniTab Training will provide you with a complete understanding of MiniTab Software. Delegates will learn to explore data with graphs, conduct statistical analyses, use session commands, generate a report and prepare worksheets.

Show moredown

What's included in this MiniTab Training Course?

  • The Knowledge Academy’s MiniTab Training Manual
  • Experienced Instructor
  • Completion Certificate
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

QlikView Training Course Outline

Introduction to QlikView

  • What is BI?
  • Introduction to Visualisation
  • Types and Tools of BI
  • What is QlikView
  • QlikView Architecture
  • QlikView Installation
  • Starting QlikView
  • Opening and Saving a Document
  • Closing a Document

Scripting

Making Queries in QlikView

Sheets

Boxes

  • List and Statistics Boxes
  • Multi, Table, and Input Boxes

Charts

  • Bar and Pie Charts
  • More Chart Types

Pivot and Straight Tables

Objects

  • Button, Text and Line/Arrow Objects
  • Slider, Current Selection, and Bookmark Objects

Document, User Preferences and Reload

Creating a Document

  • Loading Data into QlikView
  • Associate Data from Many Tables
  • Concatenate Tables
  • Link External Information to a Document
  • Loading Additional Files

Advance Features

  • Other Associations
  • Load Inline
  • Field Groups and Cyclic Display
  • Handling Cross Tables
  • And-Mode in a List Box
  • Semantic Links
  • Number Formats
  • Access Restriction

Show moredown

Who should attend this QlikView Training Course?

This course is designed for individuals who wish to gain expertise in creating, writing and modifying BI Reports using QlikView. It is beneficial for:

  • Data Scientist
  • Business Analysts
  • BI /ETL/DW Professionals
  • Statisticians and Analysts

Graduates who wish to build a career in data visualisation and discovery

QlikView Prerequsities

No prerequisites are required for this course. However, some basic knowledge of any programming language and SQL would be beneficial.

 

 

QlikView Training Course Overview

QlikView is one of the leading Business Intelligence discovery platforms for turning data into knowledge. It allows people to develop relevant data visualisation applications for business users quickly.

This QlikView Training course will help you to master in Data Visualisation using QlikView. Delegates will learn to present the retrieved data in the form of highly interactive charts and graphs. In this training, you will also gain expertise in managing and controlling the QlikView reports, dashboards and QlikView data modelling.

Show moredown

What's included in this QlikView Training Course?

  • The Knowledge Academy’s QlikView Training Manual
  • Experienced Instructor
  • Completion Certificate
  • Refreshments

 

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Tableau Training Course Outline

Introduction to Tableau

  • What is Tableau?
  • Environment Setup of Tableau
  • Get Started with Tableau
  • Tableau Design Flow
  • Tableau File and Data Types
  • Data Visualisation

Tableau Architecture

Tableau Data Sources

  • Custom Data View
  • Extracting Data
  • Fields Operations
  • Editing Metadata
  • Data Joining and Blending

Tableau Worksheets

Tableau Calculations

Tableau Sort and Filters

  • Basic Sorting and Filters
  • Quick Filters
  • Context Filters
  • Condition Filters
  • Top FiltersFilter Operations

Tableau Charts

Advanced Features of Tableau

  • Tableau Dashboard
  • Tableau Formatting
  • Tableau Forecasting
  • Tableau Trend Lines

Show moredown

Who Should Attend?

This course is intended for all individuals who wish to gain expertise in designing and managing business intelligence reports using Tableau. This course is suitable for:

  • Business Intelligence Manager
  • Data Analysts and Data Scientists
  • Project Managers
  • Business Analysts and Testing Professionals

 

Prerequisites

There are no formal prerequisites for this course. However, basic knowledge of computer programming terminologies and SQL would be an added advantage.

Tableau Training Course Overview

Tableau is a popular business intelligence tool used to create a wide range of different data visualisations to help provide actionable insights. Tableau can extract data sources from any database including Oracle and Amazon Web Services. It allows data blending and real time collaboration and is used by academic researchers, businesses, and government organisations for visual data analysis.

This 1-day Tableau training course features detailed study of Tableau architecture, graphs, reports, filters, charts and more. Concepts covered include data blending, data joining and LOD expressions. Delegates will also learn how to build interactive dashboards and trend lines.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Pig and Hive Training for Extracting Business Data Course Outline

Introduction to the Hadoop Ecosystem

  • Define Hadoop
  • Hadoop Components
  • Hadoop Architecture

Working with HDFS and MapReduce

  • Storing Data in HDFS
  • Parallel Processing with MapReduce
  • Automating Data Transfer

Executing Data Flows with Pig

  • Overview of Apache Pig
  • Structure Unstructured Data

Performing ETL with Pig

  • Transform Data with Relational Operators
  • Filter Data with Pig

Manipulating Data with Hive

  • Leveraging Business Advantages of Hive
  • Organise Data in Hive Data Warehouse
  • Design Data Layout

Extract Business value with HiveQL

  • Perform Joins on Unstructured Data
  • Pushing HiveQL to the Limit
  • Deploy Hive in Production
  • Streamline Storage Management with HCatalog

Interacting with Hadoop Data in Real-Time

  • Low-Latency Queries with Impala
  • Leverage Tez Execution Engine to Improve Performance
  • Reduce Data Access Time with Spark SQL

Show moredown

Prerequisites

There are no prerequisites for attending this course. However, a basic knowledge of databases and SQL will be useful.

Audience

Anyone interested in learning how to leverage Pig and Hive for big data can attend this course.

Pig and Hive Training for Extracting Business Data Course Overview

This Pig and Hive for Extracting Business Data course is designed to equip delegates with the knowledge of how to leverage Pig and Hive for big data to prepare and analyse large data sets on Hadoop for taking business decisions. Delegates will get an understanding of how to increase productivity by evading low-level Java coding characteristics of MapReduce and start extracting business value rapidly for competitive advantage.

During this 1-day training, delegates will learn how to store data in HDFS and automate data transfer. Delegates will gain a comprehensive knowledge of how to perform ETL with Pig and manipulate data with Hive. In addition, they will learn how to deploy a Hive in production. Delegates will acquire knowledge of how to streamline storage management with HCatalog. Post completion of this training, delegates will be able to perform low-latency queries with Impala and reduce data access time with Spark SQL.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Balanced Business Scorecard Training Course Outline

  • Why Use a Balanced Scorecard?
  • Cause and Effect
  • 4 Perspectives of a Balanced Scorecard
  • Strategic Themes
  • Translating Strategy into Operational Objectives – Strategy Maps
  • Measurement and Target Setting
  • Aligning the Organisation to the Strategy
  • The Business Unit, Functional, Support and Personal Scorecards
  • The Balanced Scorecard Development Process
  • Balanced Scorecard Implementation
  • Managing for Results with a Balanced Scorecard
  • Aligning Incentive Schemes
  • Aligning Budget/Resource Planning
  • Balanced Scorecard and the Management of Change

Show moredown

Prerequisites

There are no formal prerequisites to attend this course.

Audience

This course is intended for those who want to gain basic knowledge of a balanced business scorecard. It is more suitable for:

  • Executives
  • Project Managers
  • Functional Managers

Balanced Business Scorecard Training Course Overview

The Balanced Scorecard is a strategic performance tool used to keep tracking the execution of functions. It is a framework to help the business to clarify their vision, strategy, and translate them into operational objectives that drive both performance and behaviour. The financial, customer, process, and infrastructure are the four perspectives of the balanced scorecard.

This 1-day Balanced Business Scorecard training course provides delegates with an in-depth understanding of the structure, process and challenges of building, implementing and using a Balanced Business Scorecard to improve the performance. In this course, delegates will learn about various essential topics such as strategic themes, perspectives of the balanced scorecard, business unit, functional, support and personal scorecards, balanced scorecard and the management of change, and aligning the organisation to the different kind of strategies.

After attending this training, delegates will understand the balanced scorecard, which is a management system that uses measurement to respond to internal processes and external outcomes to improve strategic performance and working results.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft BI Training​ Course Outline

Overview of BI

  • What is BI?
  • Understand the Concept of Data Modeling
  • Data Analysis
  • Data Cleaning
  • Data Transformation
  • Data Representation

Overview of ETL

  • Introduction to ETL
  • Steps involved:
    • Extract
    • Transform
    • Load

Work with Connection Managers

  • Introduction to Connection Managers
  • Logical Representation of a Connection
  • Various Types of Connection Managers
  • How to Load Faster with OLE DB
  • Comparing the Performance of OLE DB and ADO.net
  • Work with Excel Connection Managers
  • Learn about Bulk Insert
  • Identify the Problems

Data Transformations

  • Introduction to Data Transformation
  • Convert Data from One Format to Another
  • Explain the Concepts of Character Map
  • Data and Copy Column Transformation
  • Import and Export Column transformation
  • Script and OLEDB Command Transformation
  • What is Row Sampling?
  • Aggregate and Sort Transformation
  • Percentage and Row Sampling

Advance Data Transformation

  • Pivot and UnPivot Transformation
  • Audit and Row Count Transformation
  • Working with Split and Join Transformation
  • Studying Lookup and Cache Transformation
  • Integrating with Azure Analysis Services
  • Elastic nature of MSBI to integrate with the Azure cloud service
  • Scale-out Deployment Option for MSBI
  • Data Types
    • On-premise
    • Cloud
  • Working with Cloud-borne Data Sources and Query Analysis
  • Scaling out the SSIS Package
  • Deploying for Tighter Windows
  • Working with a Larger Amount of Data Sources
  • SQL Server vNext for enhancing SQL Server Features
  • Development Languages

Slowly Changing Dimensions

  • Understanding Data that Gradually Changes Over Time
  • Understand the Process of How New Data is Written Over Old Data
  • Understand three Types of SCDs
    • Type1
    • Type2
    • Type3
  • Differences

Overview of Fuzzy Look-up Transformation and Lookup and Term Extraction

  • Understanding how Fuzzy Lookup Transformation Varies from Lookup Transformation
  • The Concept of Fuzzy matching

Concepts of Logging and Configuration

  • Learning about Error Rows Configuration
  • Package Logging
  • Defining Package Configuration
  • Understanding Constraints and Event Handlers

Show moredown

Prerequisites

No formal prerequisites are required to attend this course.

Audience

  • Data Analysts
  • Software Architects
  • ETL Developers
  • Business Intelligence Professionals

Microsoft BI Training​ Course Overview

In this 1-day Microsoft BI Certification course, delegates will gain an essential knowledge and skills required to work with Microsoft Business Intelligence stack. Starting from Microsoft BI introduction, delegates will be introduced to the concepts of transformations, connecting managers, data warehousing, ETL solutions and other operations. After this delegate shifts towards advanced topics such as ETL, work and various types of Connection Managers, Data Transformations, advance Data Transformation, the concept of Fuzzy matching and Logging and Configuration will be taught to the delegates.

After mastering all the Microsoft BI concepts, delegates will be able to work as a business intelligence or reporting engineer and to design and deploy BI solutions that distribute more data to more people across the organisation.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Pentaho BI Training Course Outline

Introduction to Pentaho Tool

  • Pentaho User Console
  • Overview of Pentaho Business Intelligence and Analytics Tools
  • Database Dimensional Modelling
  • Using Star Schema for Querying Large Data Sets
  • Understanding Fact Tables and Dimensions Tables
  • Snowflake Schema
  • Principles of Slowly Changing Dimensions
  • Knowledge of How High Availability is Supported for the DI Server and BA Server
  • Managing Pentaho Artifacts
  • Knowledge of Big Data Solution Architectures

Introduction to Pentaho BI Suite

  • Describe Pentaho
  • Pentaho BI (CE vs EE)
  • Pentaho Data Integration (PDI)
  • Pentaho Report Designer (PRD)
  • Pentaho Metadata Editor (PME)
  • Pentaho Schema Workbench (PSW)
  • Dashboard Capabilities

Data Architecture

  • Designing Data Models for Reporting
  • Pentaho Support for Predictive Analytics
  • Design a Streamlined Data Refinery (SDR) Solution for a Client

Clustering in Pentaho

  • Understanding the Basics of Clustering in Pentaho Data Integration
  • Creating a Database Connection
  • Moving a CSV File Input to Table Output and Microsoft Excel Output
  • Moving from Excel to Data Grid and Log

Pentaho Report Designer - Basic

  • PRD Layout
  • Understanding its Basic Features
  • Designing a Basic Report Containing Graphical Chart
  • Conditional Formatting
  • Studying the PRPT File Format
  • Building a Basic Report in PDF Report

Pentaho Report Designer – Advanced

  • Working with Group
  • Group Header
  • Group Footer
  • Data Source Connection
  • Query Designer
  • API Based Reporting
  • Passing Parameter
  • Using Formula
  • Designing Report with Subreport

Pentaho Data Integration Development

  • Create an ETL Job
  • Knowledge of the Pentaho Data Integration (PDI) Steps
  • Explain the PDI Steps to Create an ETL Transformation
  • Explain the Use of Property Files

Pentaho Data Integration – Introduction

  • Define Extract, Transform, Load (ETL) Concepts
  • PDI GUI Layout
  • Repository
  • Wizard
  • Marketplace
  • Supported Data Types for Connectivity

Pentaho Data Integration – Transformation

  • What is Transformation?
  • Variable
  • Step
  • Hop
  • Steps for various Input and Output
  • Steps for Transformation
  • Scripting
  • Steps for Big Data
  • Integration with Hadoop HDFS and NoSQL MongoDB
  • PDI and Map Reduce

Pentaho Data Integration – Job and More

  • Introduction to PDI-Job
  • Integrating Report
  • Entries
  • Job Orchestration
  • Logging
  • Understanding Repository
  • Database Repository
  • File-Based Repository
  • Example with Job Containing Multiple Entries

Pentaho BA Server and USER Console

  • Pentaho Business Analytics
  • User Console Navigation
  • JPivot
  • Analysis Tools
  • Using Data Sources
  • Integrating Report on BI

Security

  • Securing Data
  • Integrating User Security with Other Enterprise Systems
  • Extending BA Server Content Security
  • Pentaho’s Support for Multi-Tenancy
  • Using Kerberos with Pentaho

Show moredown

Prerequisites

The delegates are expected to have:

  • Knowledge of basic database concepts
  • Familiarity with IT terms
  • Understanding of any one programming language
  • Knowledge of Data warehouse concepts

Audience

This course is suitable for:

  • Business Analyst, BI Developer, Data Scientist, DW Programmer, Solution Architect
  • Mainframe and Testing Professionals
  • Those who want to take up a career in Business Intelligence and Data Analytics

Pentaho BI Training​ Course Overview

Pentaho is an open-source platform to build a BI solution. It provides ETL (Extract, Transform, Load), reporting and data integration capabilities. This course teaches the essential knowledge and skills required to use Pentaho Business Intelligence (BI) Suite effectively.

In this 2-day Pentaho BI training course, delegates will gain an in-depth knowledge of Pentaho tools and their features. This training focuses on both technical and non-technical Business Intelligence practitioners. They will understand how an individual can integrate Pentaho BI suite with big data stack like Hadoop and HDFS. This training program will be delivered by Certified Pentaho BI Professionals.

At the end of this certification, delegates will understand the advanced concepts of Pentaho, various product offerings, use of Pentaho report designer to design and publish custom reports and features of reporting as well as the ETL concepts, PDI features, transformation, file formats for KJB and KTR and Pentaho BA Server.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +64 800 446148 or Enquire.

Package deals

Our training experts have compiled a range of course packages to compliment a variety of categories in order to help fast track your career. The packages consist of the best possible qualifications in each industry and allows you to purchase multiple courses at a discounted rate.

Swipe for more. Don’t miss out!

What our customers are saying

Frequently asked questions

FAQ's

Our Business Intelligence courses are available across the world in thousands of locations.
As our courses are introductory, there are no prerequisites.
No, they are our own courses. We have specially designed our courses to cover the software reporting features most vital to businesses.
The Knowledge Academy is the Leading global training provider in the world for Business Intelligence Reporting.
The price for Business Intelligence Reporting certification in New Zealand starts from NZD695.

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

Looking for more information on Business Intelligence Reporting