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

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Power BI Training 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 Certification Course?

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

Power BI Prerequisites

There are no prerequisites for this 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 Certification 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 Online 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 enormous 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, which 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)

Business Objects Reporting​ Course Outline

This Business Objects Introduction Reporter course explores the following topics:

Module 1: Business Objects Environment

  • Documents
  • Reports and Blocks
  • Classes and Objects
  • Report Formatting
  • Adding New Reports to a Document           

Module 2: User Interface

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

Module 3: Universe Designer IDT/ UDT

  • Key Difference Between UDT/IDT
  • Information Design Tool (IDT)
  • Benefits of IDT
  • CMS
  • Software Admin
  • Security
  • Database Structure
  • Publications

Module 4: Opening and Retrieving Documents

  • Opening, Saving, and Closing Documents
  • Create Element Link
  • Sharing Documents

Module 5: Modifying Reports and Analysing Data

  • Creating Sections in Reports
  • Adding New Reports to a Document
  • Resizing Columns and Rows
  • Report Formatting
  • Formatting Cells
  • Adding and Formatting Breaks

Module 6: Creating and Editing Queries

  • Understanding Queries
  • Creating a Query
  • Editing Queries
  • Rename a Query
  • Delete a Query
  • Duplicate a Query
  • Nested Query Filters
  • Working with Multiple Queries

Module 7: Presentation Styles

  • Tables, Crosstabs, and Table Templates
  • Charts
  • Formatting Blocks, Pages, and Breaks
  • Adding Image
  • Using Headers and Footers

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

In this Business Objects Reporting Training course, there are no formal prerequisites.

Audience

This Business Objects Reporting Training course is designed for anyone who wants to gain in-depth knowledge about business objects and is interested in constructing reports using the program.

Business Objects Reporting Course Overview

Business Objects is a programme that allows individuals to present, analyse, and share information with other users. Business Objects enables individuals to generate queries and create reports. This platform is the main access point to share, store, design, and publish reports to analyse the different products. Business Objects gives various benefits to organisations, such as allowing them to apply additional tools as needed and reducing the need to join together other solutions that can occur in a user-unfriendly system. Adding Business Objects Reporting as a skill in learners' profiles will surely help them climb the ladder of success in terms of value and career opportunities with highly reputed jobs and upgraded salaries.

Our 1-day Business Objects Reporting Training course aims to provide delegates with comprehensive knowledge of business objects. During this course, delegates will learn about how to create the universe using the Universe Design Tool (UDT). They will also learn to disseminate and collate valuable information for employees to make crucial decisions. Our highly professional trainer with years of experience in teaching such courses will conduct this training course and help you get a complete understanding of it.

Course Objectives

  • To build the connections with the data sources
  • To open and retrieve documents to safe data
  • To know how to add new reports to a document 
  • To work with multiple queries to fetch data from the database
  • To extract data from multiple sources while building a universe
  • To get familiar with the universe designer and universe design tool 

After attending this training course, delegates will be able to provide solution that specifies in reporting and analytical business intelligence. They will also be able to modify reports and analyse data properly without facing any issues.

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)

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 incredibly 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)

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 Prerequisites

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's 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 (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)

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 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 (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

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)

Tableau Desktop Training Course Outline

 

Module 1: Introduction to Tableau

  • What is Tableau?
  • Features
  • Environmental Setup

 Module 2: Get Started

  • Steps in Creating Tableau Data Analysis Report
  • Navigation
  • Design Flow
  • File Types
  • Data Types
  • Show Me
  • Data Terminology

Module 3: Data Sources

  • Types of Data Sources
  • Custom Data View
  • Extracting Data
  • Fields Operations
  • Editing Metadata
  • Data Joining
  • Data Blending

Module 4: Worksheets

  • Add and Rename
  • Save and Delete
  • Reorder Worksheet
  • Paged Workbook

Module 5: Calculations

  • Operators
  • Functions
  • Calculations
    • Numeric
    • String
    • Date
    • Table
  • LOD Expressions

Module 6: Sort and Filters

  • Basic Sorting
  • Basic Filters
  • Filters
    • Quick
    • Context
    • Condition
  • Top Filters
  • Filter Operations

Module 7: Tableau Charts

  • Chart
    • Bar
    • Line
    • Pie
  • Crosstab
  • Scatter Plot
  • Bubble Chart
  • Bullet Graph
  • Box Plot
  • Tree Map
  • Bump Chart
  • Gantt Chart
  • Histogram
  • Motion Charts
  • Waterfall Charts

Module 8: Tableau Advanced

  • Dashboard
  • Formatting
  • Forecasting
  • Trend Lines

Show moredown

Prerequisites

There are no formal prerequisites for attending this Tableau Desktop Training course.

Audience

This Tableau Desktop Training course is suitable for anyone who wants to build interactive dashboards and perform data visualisation. 

Tableau Desktop Training Course Overview

Tableau is an excellent business intelligence and data visualisation application for analysing and reporting enormous amounts of data. Tableau Desktop assists in creating dashboards, reports, and stories using different graphs and charts. It enables the combination of relational, semi-structured, and unstructured data sources in real time, using it without having to pay exorbitant upfront integration costs. This training will enable learners to address complex business problems by visualising the relevant data, exploring different views, and even combining multiple databases effortlessly. Pursuing knowledge and skills in Tableau Desktop will help individuals to advance their careers in analytics and gain skills to claim higher designations in globally recognised organisations.

The Knowledge Academy’s 1-day Tableau Desktop Training course provides delegates with a comprehensive knowledge of Tableau software and how to visualise relevant data using it. During this training, delegates will learn about Tableau data sources to read the data from different sources while analysing the data. They will also learn about Tableau charts representing the data and outcomes derived after analysis for making informed business decisions. Our highly skilled and professional instructors, with years of teaching experience, will conduct this training through their remarkable methods.

Course Objectives

  • To create a calculation field and use a numeric function
  • To Display your data on a map to spot trends and patterns
  • To inject advanced analytics and predictions at different levels
  • To make better business decisions and get real-time results
  • To explore data geographically to review sales and profits
  • To combine and clean your data without writing code 

At the end of this training course, delegates will be able to create a good story and dashboard by analysing data over diverse dimensions, periods, and measures. They will also be able to improve sales and profitability for the company's product lines using its business intelligence capabilities.

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)

DAX Training​ Course Outline

Module 1: What is DAX?

  • Introduction to DAX
  • Data Types and Operators
  • Calculated Columns and Measures
  • Evaluation Contexts –
  • CALCULATE Function

Module 2: DAX Variables and Formatting

  • DAX Variables
  • Formatting DAX Code
  • Debugging Errors in DAX Code

Module 3: Building Data Models

  • Introduction to Data Modelling
  • Data Modelling Concepts in DAX
  • Getting Data into Data Model
  • Extending Data Model

Module 4: Working with DAX in Power BI, Excel, and SSAS

  • Working with DAX in
  • Power BI Desktop
  • Excel Power Pivot
  • SSAS Tabular

Module 5: Progressive DAX Syntax and Functions

  • Breaking Down DAX Syntax
  • Dealing with Relationships
  • Looking at DAX Functions
  • Introduction to Aggregation Functions
  • Functions for Parent-Child Hierarchies

Module 6: Table Functions

  • Introducing Table Functions
  • Looking at Table Manipulation Functions

Module 7: Date, Time, and Time Intelligence Functions

  • Introduction to Date and Time Functions
  • Date and Time Functions
  • Building a Date Table
  • Looking at Time Intelligence Functions
  • Making Data More Intelligent Over Time

Module 8: Filter Functions

  • Introduction to Filter Functions
  • Filtering Data with Filter Functions

Module 9: Optimising Data Model

  • Introducing the VertiPaq Engine
  • Understanding Data Model
  • Simplifying Data Model

Module 10: Optimising DAX Queries

  • Introduction to the DAX Calculation Engines
  • Monitoring Performance with DAX Studio
  • SQL Server Profiler
  • Power BI Performance Analyser

Show moredown

Prerequisites

There are no formal prerequisites to attend this DAX Training course.

Audience

This 1-Day DAX Training course is ideal for anyone who wants to gain in-depth knowledge of Data Analysis Expressions (DAX). However, this course will be more beneficial for professionals working in Data Analysis and Analytics profession.

DAX Training​ Course Overview

Data Analysis Expressions (DAX) is a formula language used to determine custom calculations for calculated columns and measures. It is specifically used for the handling of data models through the use of formulas and expressions. DAX is used in many Microsoft Products, including Microsoft Analysis Services, Microsoft Power BI, and Microsoft Power Pivot for Excel. DAX helps its users to enhance their data research capabilities and become more productive. The use of DAX helps organisations to gain benefits like improved performance, readability, simplifies the debugging process, and reduces complexity. Learning DAX will help individuals enhance their data analysis skills and gain more opportunities to work on lucrative jobs roles in prominent organisations.

This 1-day DAX Training course covers all the essential topics by which delegates can become fully familiar with the Data Analysis Expressions (DAX). During this training, delegates will learn about data types and operators, formatting DAX code, progressive DAX syntax and functions, etc. They will also learn about debugging errors in DAX code, DAX functions, date and time functions, working with percentiles, etc. Our highly professional trainer with years of experience in teaching such courses will conduct this course and help delegates get a complete understanding of using DAX.

This training will cover various essential topics, such as:  

  • Extending data model
  • Dealing with relationships
  • Building a date table
  • Simplifying data model
  • SQL server profiler
  • SSAS tabular

After attending this DAX Training course, delegates will be able to work with DAX patterns and optimise the data model. They will also be able to monitor performance with DAX studio and efficiently optimise DAX queries.

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 Modelling
  • 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-premises
    • 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 several 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)

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)

Course Outline

Module 1: Introduction to Grafana?

  • Grafana OSS
  • Getting Started with
    • Grafana
    • Grafana and InfluxDB
    • Grafana and Prometheus
  • Exemplars
  • Intro to Time Series
  • Time Series Dimensions
  • Histograms and Heatmaps

Module 2: Best Practices

  • Best Practices for Creating and Managing Dashboards
  • Common Observability Strategies
  • Dashboard Management Maturity Level

Module 3: Authentication

  • Grafana Authentication
  • Auth Proxy
  • JWT Authentication
  • LDAP Authentication
  • Enhanced LDAP Integration
  • OAuth Authentication
  • Google OAuth2 Authentication
  • Azure AD OAuth2 Authentication
  • GitHub and GitLab OAuth2 Authentication
  • Okta OAuth2 Authentication
  • SAML Authentication
  • Team Sync

Module 4: Installation

  • Requirements
  • Install on Debian/Ubuntu
  • Install on RPM-based Linux
  • Install on Windows and macOS
  • Run Grafana Docker Image
  • Deploy Grafana on Kubernetes
  • Upgrade Grafana
  • Restart Grafana

Module 5: Administration

  • View Servers and Configuration
  • Configure Grafana Docker Image
  • Grafana CLI
  • Security and Provisioning
  • Jaeger Instrumentation
  • Set Up Grafana for High Availability

Module 6: Manage Users

  • Server and Org Admin Tasks
  • Manage Teams and User Account Tasks

Module 7: Image Rendering

  • Monitoring the Image Renderer
  • Troubleshooting

Module 8: Troubleshooting

  • Troubleshoot Dashboards
  • Enable Diagnostics
  • Troubleshoot Queries

Show moredown

Prerequisites

There are no formal prerequisites to attend this Grafana Training course. 

Audience

This Grafana Training course is ideal for anyone who wants to build Grafana skills. 

Course Overview

Grafana is open-source analytics and monitoring solution for every database. It provides a plethora of features with various visualisation options for viewing and understanding the data quickly. Grafana enables individuals to consume data from various data sources by querying and visualising it in customisable charts for quick study. Studying Grafana Training course helps individuals to effectively build Grafana skills. It allows organisations to monitor log analytics and infrastructure, primarily boosting their operational efficiency. Adding Grafana as a skill into your profile will certainly help you to undertake tremendous job opportunities.

This 1-day Grafana Training course covers all the essential topics by which delegates will become thoroughly familiar with the Grafana. During this training, they will learn about how to render an image. They will also learn about exemplars, time series, histograms and heatmaps, OAuth authentication, Google OAuth2 authentication, Azure AD OAuth2 authentication, GitHub and GitLab OAuth2 authentication, and many more topics. Our highly professional trainer with years of experience in teaching such courses will conduct this training course and will help you get a complete understanding of Grafana.

This training will cover various essential topics, such as: 

  • Time series dimensions
  • LDAP authentication
  • SAML authentication
  • Run Grafana docker image
  • Upgrade Grafana
  • Jaeger instrumentation

After attending this Grafana Training course, delegates will be able to install Grafana on Ubuntu, RPM-based Linux, Windows and macOS. They will also be able to set up Grafana for high availability and configure the Grafana docker image.

If delegates want to acquire more knowledge about business intelligence solutions, they can choose courses like Microsoft Power BI Training, Crystal Reports Masterclass, Cognos BI Reporting, Business Objects Reporting, Business Objects Web Intelligence Reporter Course, and more from our Business Intelligence Reporting section.

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 01344203999 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!

Business Intelligence Reporting FAQs

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 the United Kingdom starts from £.

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

Looking for more information on Business Intelligence Reporting