cross

BIGGEST CHRISTMAS SALE !

red-starWHO WILL BE FUNDING THE COURSE?

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

Module 1: Introduction to Power BI

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

Module 2: ​​Data Sources

  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • Power BI Data Model
  • Managing Data Relationships
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Creating a Group

Module 3: Shaping and Combining Data

  • Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Combining Data

Module 4: Modelling Data

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

Module 5: Interactive Data Visualisations

  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualisations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Report Settings
  • Desktop 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 Training Course?

The Microsoft Power BI Certification Training is a comprehensive course designed to equip participants with the skills and knowledge needed to effectively use Microsoft Power BI, a powerful business intelligence and data visualisation tool. The course is especially useful for:

  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Managers
  • Information Technology (IT) Professionals
  • Team Leaders
  • Visualisation Specialists

Prerequisites of the Microsoft Power BI Certification Training Course

There are no formal prerequisites for the Microsoft Power BI Certification Training. However, a basic understanding of business analytics and Data Visualisation can be beneficial.

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 Certification Training Course

  • World-class Training Sessions from Experienced Instructors
  • Microsoft Power BI Certification Training Certificate
  • Digital Delegate Pack

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

  • Introduction
  • 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 Query
  • Rename a Query
  • Delete a Query
  • Duplicate a Query
  • Nested Query Filters
  • Working with Multiple Queries

Module 7: Presentation Styles

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

Show moredown

Who should attend this Business Objects Reporting Course?  

The Business Objects Reporting Course is ideal for professionals seeking to enhance their skills in data analysis and reporting using the Business Objects platform. This course can benefit a wide range of professionals, including: 

  • Business Analysts 
  • Data Analysts 
  • Financial Analysts 
  • Project Managers 
  • Reporting Specialists 
  • Business Intelligence Professionals 
  • Data Scientists 

Prerequisites of the Business Objects Reporting Course

There are no formal prerequisites for this Business Objects Reporting Course.

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 Course?

  • World-Class Training Sessions from Experienced Instructors    
  • Business Objects Reporting Certificate 
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Crystal Reports Masterclass Outline

Module 1: Overview

  • Crystal Reports
  • Reports and Databases
  • Use Crystal Reports Help
  • Crystal Report Settings

Module 2: Working with Reports

  • Create a Report
  • Modify a Report
  • Work with Report Sections

Module 3: Using Formulas in Reports

  • Create a Formula
  • Edit a Formula
  • Filter Data Using a Formula
  • Handle Null Values

Module 4: Building Parameterised Reports

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

Module 5: Grouping Report Data

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

Module 6: Enhancing a Report

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

Module 7: Distributing Data

  • Export Data

Show moredown

Who should attend this Crystal Reports Masterclass?

The Crystal Reports Masterclass is a comprehensive course designed to provide participants with advanced skills in using Crystal Reports, a powerful business intelligence tool for designing and generating interactive reports from various data sources. This course is useful for the following professionals:

  • Business Analysts
  • Report Designers
  • Data Analysts
  • Information Technology (IT) Professionals
  • Managers
  • Team Leaders
  • Business Intelligence Professionals

Prerequisites of the Crystal Reports Masterclass

There are no formal prerequisites for the Crystal Reports Masterclass. However, a basic understanding of business analytics and Crystal Reports can be beneficial.

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 Masterclass

  • World-class Training Sessions from Experienced Instructors
  • Crystal Reports Masterclass Certificate
  • Digital Delegate Pack

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:

 

Module 1: Cognos BI Reporting Fundamentals

  • Types of Data
  • Data Processing
    • Introduction and Stages of Data Processing
  • Business Intelligence
    • Introduction and Trends in Business Intelligence
    • Business Intelligence Advantages
  • Reporting Fundamentals
  • Report Objects
    • Objects
    • Objects as Containers
    • Locking and Unlocking Objects
    • Hierarchy of Objects

Module 2: Creating a Dashboard or Story

  • General Workflow Steps to Create a View

Module 3: Report Components

  • Toolbox Tab
  • Source Tab
  • Toolbar and Menu
    • On-Demand Toolbar
    • Navigation Menu
  • User Interface

Module 4: Creating Reports

  • Introduction to Active Report
  • Two Types of Objects
    • Active Report Controls
    • Active Report Variables
  • Summary Functions
  • Combined Filters
  • Custom Filters
  • External Data

Module 5: Creating Charts

  • Column Charts
  • Line Charts
  • Scatter Charts
  • Pie Charts
  • Column-Line Charts
  • XML Specification
  • Access Permissions

Show moredown

Who should attend this Cognos BI Reporting Training Course?

The Cognos BI Reporting is a comprehensive training course designed to provide participants with the skills and knowledge needed to effectively use Cognos Business Intelligence (BI) for creating insightful and interactive reports and dashboards. The course is suitable for the following professionals:

  • Business Analysts
  • Report Designers
  • Data Analysts
  • Managers
  • Information Technology Professionals
  • Data Scientists
  • Team Leaders

Prerequisites of the Cognos BI Reporting Training Course

There are no formal prerequisites for the Cognos BI Reporting Training. However, a basic understanding of business analytics and report making can be beneficial.

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 Reporting Training Course

  • World-class Training Sessions from Experienced Instructors
  • Cognos BI Reporting Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

QlikView Training Course Outline

 

Module 1: Introduction to QlikView

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

Module 2: Scripting

  • Opening Script Editor
    • Edit Script Icon
    • Using Keyboard Shortcut
  • Features of QlikView Script Editor

Module 3: Making Queries in QlikView

  • LOAD Statement

Module 4: Sheets

  • Sheet Properties
  • Creating Sheet Objects

Module 5: Boxes

  • List Box
    • Creating List Box
  • Multi Box
    • Association between Sheet Objects
  • Statistics Box
  • Table Box
  • Input Box

Module 6: Charts

  • Bar and Pie Charts
  • More Chart Types

Module 7: Pivot and Straight Tables

  • Pivot Tables
  • Straight Tables

Module 8: Objects

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

Module 9: Document, User Preferences and Reload

  • Document
  • User Preferences
  • Reload

Module 10: Creating a Document

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

Module 11: Advance Features

  • Data Association
  • Load Inline
  • Field Groups
  • Handling Cross-tables
  • And-Mode in a List Box
  • Semantic Links
  • Number Formats
  • Access Restriction

Show moredown

Who should attend this QlikView Training Course?

The QlikView Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use QlikView, a powerful data visualisation and business intelligence platform. This course is useful for the following professionals:

  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Researchers
  • Information Technology Professionals
  • Managers
  • Business Intelligence Specialists

Prerequisites of the QlikView Training Course

There are no formal prerequisites for the QlikView Training. However, a basic understanding of business analytics and data science can 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?

  • World-Class Training Sessions from Experienced Instructors
  • QlikView Training Certificate
  • Digital Delegate Pack

 

Show moredown

Online Instructor-led (2 days)

Classroom (2 days)

Online Self-paced (16 hours)

MicroStrategy 10 Training Course Outline

Module 1: Introduction to MicroStrategy

  • What is MicroStrategy?
  • MicroStrategy Architecture
    • Storing Information
    • Indexing Data
    • Processing Data
    • Administering MicroStrategy Web and Mobile
  • Desktop
    • Content Panel
    • Dataset Panel
    • Editor Panel
    • Filter Panel
    • Properties Panel
    • Visualisations
  • Installation
    • Steps to Install MicroStrategy Desktop

Module 2: MicroStrategy Objects, Dashboards and Office

  • MicroStrategy Objects
    • Overview
    • Objects Used on Reports
    • Object Groups
  • MicroStrategy Dashboard
    • Overview
    • Steps to Create a Dashboard
    • Steps to Save Dashboard

Module 3: New Features of MicroStrategy 10

  • Features of MicroStrategy 10
  • What Does MicroStrategy Workstation Allow to Administrators and Developers?

Module 4: MicroStrategy Reporting

  • What is MicroStrategy Reporting
  • Components of a Report
  • Report Types
  • Hierarchy Reporting

Module 5: Formatting a Report

  • What is Formatting a Report?
  • Ideas for Formatting
  • Formatting a Combined Grid and Graph Report
  • Formatting a Graph Report
  • Viewing a Graph Report
  • Understanding a Graph Report
  • Formatting Numeric Data in a Report
  • Formatting Groups of Report Rows or Columns
  • Keeping Row and Column Names Visible

Module 6: Analysing Data

  • Introduction to Analysing Data
  • Analysing Data in a Visualisation
  • Steps to Analyse the Data
  • Steps to Export Data
  • Exported Data in the PDF Format
  • Steps to Hide Title Bar

Module 7: Filters, Drilling, and Hierarchies

  • Filters
  • Add a Filter to the Filters Panel
  • Hierarchies
  • Drilling Using Hierarchies

Module 8: Refreshing Data and Answering Report Prompts

  • Refreshing Data
  • Answering Report Prompts

Module 9: Creating a Query for Analysis

  • Business Query
  • Existing Reports
  • Suitable Report Objects
  • How MicroStrategy Project Reflects Data Source?
  • Natural Language Queries

Module 10: Creating Quick Queries and Objects for Designers

  • Report Designer Role
  • Data Source
  • MicroStrategy Project

Show moredown

Who should attend this MicroStrategy 10 Training Course?

The MicroStrategy 10 Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use MicroStrategy 10, a powerful business intelligence and analytics platform. The MicroStrategy 10 Training is particularly well-suited for:

  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Managers
  • Information Technology Professionals
  • Team Leaders
  • Business Intelligence Specialists

Prerequisites of the MicroStrategy 10 Training Course

There are no formal prerequisites for the MicroStrategy 10 Training. However, a basic understanding of business analytics and report making can be beneficial.

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 10 Training Course

  • World-class Training Sessions from Experienced Instructors
  • MicroStrategy 10 Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Minitab Training Outline

Module 1: Introduction to Minitab

  • What is Minitab?
  • Use of Minitab
  • Minitab User Interface
  • Projects and Worksheets
  • Data Types
  • Examine a Worksheets

Module 2: Preparing a Worksheet

  • Open Worksheet, Excel File and Text File
  • Combine the Data into one Worksheet
  • Move and Rename a Column
  • Recode the Data
  • Insert and Name a New Data Column
  • Assign a Formula to a Column 

Module 3: Graphing Data

  • Create, Interpret, and Edit Histograms
  • Create and Interpret Scatterplots with Minitab Assistant
  • Arrange Multiple Graphs on a Single Page
  • Save a Project

Module 4: Analysing Data

  • Display Descriptive Statistics and Interpret the Results
  • Compare Two or More Means
  • Use Minitab’s Project Manager

Module 5: Assessing Quality

  • Introduction to Assessing Quality
  • Create and Interpret Control Charts
  • Add Time/Date Labels to a Control Chart
  • Perform and Interpret a Capability Analysis

Module 6: 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

Module 7: Using Session Commands

  • Enable and Enter Session Commands
  • Copy Session Commands
  • Create and Run an Exec File

Module 8: Generating a Report

  • Introduction
  • Create a New Report
  • Add Rows and Annotations to a Report
  • Rename the Report
  • Send Graphs and Tables to a Report
  • Rearrange the Items in your Report
  • Resize Graphs in the Report

Module 9: Customising Minitab

  • Change Default Options for Graphs
  • Create a Custom 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?

The Minitab Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use Minitab, a powerful statistical software used for data analysis and quality improvement. This course is useful for the following professionals:

  • Quality Professionals
  • Data Analysts
  • Data Scientists
  • Researchers
  • Six Sigma Practitioners
  • Academic Researchers
  • Market Analysts

Prerequisites of the Minitab Training Course

There are no formal prerequisites for the Minitab Training. However, a basic understanding of data analytics and statistical analysis can be beneficial.

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

  • World-class Training Sessions from Experienced Instructors
  • Minitab Training Certificate
  • Digital Delegate Pack

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:

Module 1: Web Intelligence Launch Pad

  • Opening Documents in the Reading View
  • Folders and Categories

Module 2: Working in the Java Enabled Design View

  • Documents
  • Reports
  • Blocks (Vertical Tables, Horizontal Tables, Cross Tables, Charts, and Forms)
  • Universe Pane, Classes, and Objects

Module 3: User Interface

  • Toolbars and Menus
  • Data Panel
  • Help

Module 4: 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

Module 5: 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

Module 6: Formatting Documents

  • Borders and Shading
  • Adding Headers and Footers
  • Adding Pictures and Logos
  • Inserting a Page Break
  • Formatting Rules

Module 7: Creating and Editing Queries

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

Module 8: Restricting Data with Query Filters

  • Nested Query Filters
  • Query Filters
  • Predefined Query Filters
  • Query Prompts

Module 9: Using Functions

  • Filtering Data
  • Sorting Data
  • Ranking Data
  • Grouping Columns
  • Inserting Simple Calculations

Module 10: Creating Formulas and Variables

  • Adding a Formula to a Block
  • Defining a Formula as a Variable

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?

  • World-Class Training Sessions from Experienced Instructors
  • Business Objects Web Intelligence Reporter Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Business Objects Desktop Intelligence Advanced Reporter Course Outline

Module 1: Introduction to Desktop Intelligence

  • What is Desktop Intelligence?
  • Where does the Data Come From?
  • Presenting and Analysing Data
  • Sharing Information
  • Security
  • Keeping a Document's Data Up-To-Date
  • Demo Materials and Samples
  • Upgrading from Earlier Versions of Desktop Intelligence
  • Repository
  • Folders and Categories

Module 2: Introduction to Accessing Data with Desktop Intelligence

  • What Data Sources are Available?
  • How do you Access Data Sources?
  • Restrictive Connections
  • Workflows for Accessing Data
  • Using the Repository
  • Managing Categories
  • Importing from the Repository
  • Retrieving Different Instances of a Given Document
  • Sending Documents from Desktop Intelligence

Module 3: Combining Data from Different Sources

  • Which Data Providers can you Combine in One Report?
  • Displaying Data from Separate Data Providers
  • Prompts and Linking
  • Linking Data Providers
  • What Situations Require to Link Data Providers?
  • Deleting the Link between Data Provider

Module 4: Managing Data Providers

  • Overview
  • Renaming Data Providers
  • Why Rename Data Providers?
  • Getting Statistics on Data Providers
  • To Get Statistics on Data Providers
  • Purging and Deleting Data Providers
  • To Purge or Delete a Data Provider
  • Using Data Providers Efficiently

Module 5: Slice and Dice Mode

  • Working in Slice-and-Dice mode
  • To Display the Slice and Dice Panel
  • Working with Master/Detail Reports in Slice and Dice Mode
  • Positioning Data Horizontally in Slice-and-Dice Mode
  • Working with Crosstabs and 3-D Matrix Charts
  • Displaying and Removing Data in Slice-and-Dice Mode
  • Deleting, Renaming, and Resetting Blocks in Slice and Dice Mode
  • To Transform Blocks in Slice-and-Dice Mode
  • Applying Further Modifications in Slice and Dice Mode

Module 6: Using and Customising Lists of Values

  • What is a List of Values?
  • How are Lists of Values Created?
  • Customising Lists of Values in Desktop Intelligence
  • Editing Lists of Values
  • To Assign Personal Data from a Text and Excel

Module 7: Formulas, Local Variables, and Functions

  • Formulas
  • Displaying the Formula Bar and Editor
  • Local Variables
  • Transforming a Formula into a Local Variable
  • Creating Local Variables by Grouping Values
  • Inserting Local Variables and Formulas in a Report
  • Aggregate Function Equivalents
  • Numeric Function Equivalents
  • Character Function Equivalents
  • Date Function Equivalents

Module 8: Desktop Intelligence and Visual Basic for Applications

  • What is a Macro?
  • What is an Add-In?
  • Using Macros
  • To Run a Macro
  • Using Add-Ins
  • Exchanging Add-Ins with Other Users
  • Converting Scripts to Macros
  • To Convert a Script
  • Using the Visual Basic Editor

Show moredown

Who should attend this Business Objects Desktop Intelligence Advanced Reporter Course?

This Business Objects Desktop Intelligence Advanced Reporter Course is designed for individuals who possess a solid foundation in using Business Objects Desktop Intelligence for reporting purposes and are looking to enhance their skills further. This course can benefit a wide range of professionals, including: 

  • Business Intelligence Professionals 
  • Financial Analysts 
  • Marketing Managers 
  • Human Resources Managers 
  • Project Managers 
  • Data Scientists 
  • Database Administrators 

Prerequisites of the Business Objects Desktop Intelligence Advanced Reporter Course

There are no formal prerequisites for this Business Objects Desktop Intelligence Advanced Reporter 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 Objects Desktop Intelligence Advanced Reporter Course?

  • World-Class Training Sessions from Experienced Instructors    
  • Business Objects Desktop Intelligence Advanced Reporter Certificate 
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Pentaho BI Training Course Outline

Module 1: Pentaho Data Integration

  • Pentaho Data Integration and Pentaho BI Suite
  • Introducing Pentaho Data Integration
  • Using PDI in Real-World Scenarios
  • Loading Data Warehouses or Data Marts
  • Integrating Data
  • Data Cleansing
  • Migrating Information
  • Exporting Data Integrating PDI Along with Other Pentaho Tools

Module 2: Introducing Transformations

  • Basics About Transformations
  • Designing a Transformation
  • Designing and Previewing Transformations
  • Running Transformations in an Interactive Fashion
  • Understanding PDI Data and Metadata
  • Handling Errors

Module 3: Creating Basic Task Flows

  • Introducing Jobs
  • Designing and Running Jobs
  • Enriching your Work by Sending an Email
  • Understanding and Changing the Flow of Execution
  • Managing Files

Module 4: Reading and Writing Files

  • Reading and Writing Files
  • Learning to Read all Kind of File
  • Describing the Incoming Field
  • Reading the Most Common Kinds of Sources
  • Outputting Data to Files
  • Describing the Content of the Output File
  • Working with Big Data and Cloud Sources

Module 5: Manipulating PDI Data and Metadata

  • Working with Strings
  • Operating with Dates
  • Working with Complex Structures
  • Parsing XML Structures with PDI
  • Parsing JSON Structures

Module 6: Controlling the Flow of Data

  • Filtering Rows Upon Conditions
  • Splitting Streams Unconditionally
  • Splitting the Stream Based on Conditions

Module 7: Loading Data Marts with PDI

  • Introducing Dimensional Modelling
  • Loading Dimensions with Data
  • Loading a Time Dimension
  • Loading Fact Tables
  • Translating the Business Keys into Surrogate Key
  • Loading a Snapshot Fact Table

Module 8: Best Practices for Designing and Deploying a PDI Project

  • Setting Up a New Project
  • Best Practices to Design Jobs and Transformations
  • Maximising the Performance
  • Deploying the Project in Different Environments

 

Show moredown

Who should attend this Pentaho BI Training Course?

The Pentaho BI Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use Pentaho Business Intelligence (BI) tools for data integration, analytics, and reporting. This course is useful for the following professionals:

  • Business Managers
  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Data Engineers
  • Information technology Professionals
  • Business Intelligence Professionals

Prerequisites of the Pentaho BI Training Course

There are no formal prerequisites for the Pentaho BI Training. However, a basic understanding of business intelligence and data analysis can be beneficial.

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

What’s included in this Pentaho BI Training Course

  • World-class Training Sessions from Experienced Instructors
  • Pentaho BI Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Balanced Business Scorecard Training Course Outline

Module 1: Why Use a Balanced Scorecard?

  • What is Balanced Scorecard?
  • Why Use a Balanced Scorecard?

Module 2: Cause and Effect

  • Cause
  • Effect

Module 3: Four Perspectives of a Balanced Scorecard

  • Financial Perspective
  • Customer Perspective
  • Internal Process Perspective
  • Learning and Growth Perspective

Module 4: Strategic Themes

  • Strategic Themes Overview

Module 5: Translating Strategy into Operational Objectives

  • What is Strategy Map?
  • How Does Strategy Mapping Help an Organisation?
  • Alignment of Strategy Maps with Balanced Business Scorecard

Module 6: Measurement and Target Setting

  • Measurement
  • Target Setting

Module 7: Aligning the Organisation to the Strategy

  • Overview
  • Five Fundamental Steps

Module 8: Business Unit, Functional, Support, and Personal Scorecards

  • Cascading a Balanced Scorecard
  • Cascading Strategy

Module 9: Balanced Scorecard Development Process

  • Build Purpose Statement
  • Design Change Agenda
  • Make a Map
  • Create Great Measures
  • Launch Some Initiatives

Module 10: Balanced Scorecard Implementation

  • Overview
  • Big Mistake that People make when Implementing

Module 11: Managing for Results with a Balanced Scorecard

  • Results-Based Management (RBM)
  • Balanced Scorecard and RBM have in Common Elements

Module 12: Aligning Incentive Schemes

  • What is Aligning Incentive Schemes?
  • Objectives and Priorities

Module 13: Aligning Budget/Resource Planning

  • Overview
  • Continuous Learning Process
  • Advantages

Module 14: Balanced Scorecard and the Management of Change

  • Change Management
  • Goal of Managing Change
  • Case Study

Show moredown

Who should attend this Balanced Business Scorecard Training Course?

The Balanced Business Scorecard Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively create, implement, and manage a Balanced Scorecard, a strategic performance management framework that aligns business goals and measures performance across various dimensions. This course is useful for the following professionals:

  • Business Managers
  • Business Consultants
  • Strategic Planners
  • Executives
  • Managers
  • Performance Analysts
  • Business Intelligence Professionals

Prerequisites of the Balanced Business Scorecard Training Course

There are no formal prerequisites for the Balanced Business Scorecard Training. However, a basic understanding of strategic planning and performance assessment can be beneficial.

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

What’s included in this Balanced Business Scorecard Training Course

  • World-class Training Sessions from Experienced Instructors
  • Balanced Business Scorecard Training Certificate
  • Digital Delegate Pack

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?
  • Environment Setup of Tableau
  • Get Started with Tableau
  • Tableau Design Flow
  • Tableau File and Data Types
  • Data Visualisation

Module 2: Tableau Architecture

  • Overview
  • Components of the Tableau Architecture

Module 3: Tableau Data Sources

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

Module 4: Tableau Worksheets

  • Adding Worksheet
  • Renaming Worksheet
  • Save and Delete Worksheet
  • Paged Workbook

Module 5: Tableau Calculations

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

Module 6: Tableau Sort and Filters

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

Module 7: Tableau Charts

  • Charts to Visualise Data

Module 8: Advanced Features of Tableau

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

Show moredown

Who should attend this Tableau Desktop Training Course?

The Tableau Desktop Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use Tableau Desktop, a powerful data visualisation and business intelligence tool. This course is useful for the following professionals:

  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Information Technology Professionals
  • Managers
  • Team Leaders
  • Business Intelligence Specialists

Prerequisites of the Tableau Desktop Training Course

There are no formal prerequisites for the Tableau Desktop Training. However, a basic understanding of business analytics and data science can be beneficial.

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

What’s included in this Tableau Desktop Training Course

  • World-class Training Sessions from Experienced Instructors
  • Tableau Desktop Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

DAX Training​ Course Outline

Module 1: Introduction to DAX

  • What is DAX?
  • Syntax
  • Data Types and Operators
  • Evaluation Contexts
  • Functions
  • Calculated Columns
  • Calculated Tables
  • Measures

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

Module 4: Power BI Desktop and SSAS

  • Power BI Desktop
  • 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

  • Introduction to Table Functions
  • Looking at Table Manipulation Functions

Module 7: Date, Time, and Time Intelligence Functions

  • Introduction to Date and Time Functions
  • Building a Date Table
  • Looking at Time Intelligence Functions

Module 8: Optimising Data Model

  • Introducing the VertiPaq Engine
  • Simplifying Data Model

Module 9: Optimising DAX Queries

  • Introduction to the DAX Calculation Engines
  • Capturing Power BI Queries Using DAX Studio
  • Power BI Performance Analyser

Show moredown

Who should attend this DAX Training Course?

The DAX Training is a comprehensive course designed to provide delegates with the skills and knowledge needed to effectively use Data Analysis Expressions (DAX), a powerful formula language used in various Microsoft BI tools, including Power BI, Excel, and SQL Server Analysis Services. This DAX Course is useful for the following professionals:

  • Excel Power Users
  • Business Intelligence Developers
  • Data Analysts
  • Data Scientists
  • Financial Analysts
  • Information Technology Professionals
  • Business Intelligence Professionals

Prerequisites of the DAX Training Course

There are no formal prerequisites for the DAX Training. However, a basic understanding of data analysis and formula languages can be beneficial.

DAX Training Course Overview

DAX Training, or Data Analysis Expressions Training, is a crucial course in today's data-driven world. DAX is a formula language employed to perform custom calculations in data models, playing a pivotal role in Microsoft products like Analysis Services, Power BI, and Power Pivot for Excel. Mastering DAX via DAX Courses is essential for professionals in data analysis and modelling, as it significantly enhances data research capabilities.

Professionals across various industries must recognise the importance of DAX Training. Analysts, Data Scientists, Business Intelligence Experts, and Data Modelers can gain a competitive edge in their careers by mastering DAX. DAX Certifications open up lucrative opportunities, making it essential for those aiming to excel in prominent organisations. The ability to handle data models efficiently and perform custom calculations sets professionals apart in the data analysis landscape.

The Knowledge Academy's 1-day DAX Training Course is designed to provide delegates with a comprehensive understanding of Data Analysis Expressions (DAX). It covers essential topics like data types, operators, DAX code formatting, syntax, and functions. Delegates will also learn to debug errors in DAX code, utilise DAX functions, work with date and time functions, and more. This training is a stepping stone for professionals to enhance their data analysis skills and attain DAX Certification, thereby unlocking a world of opportunities.

Course Objectives:

  • To comprehend the essentials of Data Analysis Expressions (DAX) and its applications
  • To acquire proficiency in creating and optimising DAX formulas for data analysis
  • To develop effective debugging techniques for identifying and resolving DAX code errors
  • To explore the practical applications of DAX functions in data manipulation
  • To enhance skills in managing data relationships and optimising data models with DAX

To build date tables and strengthen data analysis capabilities effectivelyUpon completing this DAX Training, delegates will gain a comprehensive understanding of data modeling and analysis, making them more proficient in their roles. This expertise will open doors to more career opportunities in data-driven industries, offering a competitive advantage in today's job market.

Show moredown

What’s included in this DAX Training Course

  • World-class Training Sessions from Experienced Instructors
  • DAX Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft BI Training​ Course Outline

Module 1: Introduction to Power BI

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

Module 2: ​​Data Sources

  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • Power BI Data Model
  • Managing Data Relationships
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Creating a Group

Module 3: Shaping and Combining Data

  • Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Combining Data

Module 4: Modelling Data

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

Module 5: Interactive Data Visualisations

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

Show moredown

Who should attend this Microsoft BI Training Course?

The Microsoft BI Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use Microsoft Business Intelligence (BI) tools for data analysis, reporting, and visualisation. This course is useful for the following professionals:

  • Business Managers
  • Business Analysts
  • Data Analysts
  • Data Scientists
  • Managers
  • Information Technology Professionals
  • Business Intelligence Professionals

Prerequisites of the Microsoft BI Training Course

There are no formal prerequisites for the Microsoft BI Training. However, a basic understanding of business intelligence and report making can be beneficial.

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

What’s included in this Microsoft BI Training Course

  • World-class Training Sessions from Experienced Instructors
  • Microsoft BI Training Certificate
  • Digital Delegate Pack

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

Module 1: Introduction to Hadoop and Pig

  • Hadoop
  • Hadoop Distributed File System
  • System Architecture
  • Apache Pig Architecture
  • Components of Pig
  • Pig Execution Modes
  • Working of Pig

Module 2: Hive

  • Overview
  • Hive Architecture
  • Components of Hive
  • Working of Hive
  • Experimentation with Hive

Module 3: Exploring HDFS and MapReduce

  • What is HDFS (Hadoop Distributed File System)?
  • Objectives of HDFS
  • Exporting Data from HDFS to Local Machine
  • Setting the HDFS Block Size for a Specific File in a Cluster
  • Importing Data from Another Hadoop Cluster
  • Saving Compressed Data on HDFS
  • What is MapReduce?
  • Components of MapReduce
  • Advantages of MapReduce

Module 4: Executing Data Flows with Pig

  • What is Apache Pig?
  • Why do We Need Apache Pig?
  • Connecting to the Pig Console and Pig Execution Options
  • Using Pig to Interactively Filter the Dataset
  • Grouping, Subsetting, and Aggregating Data Using Pig

Module 5: Manipulating Data with Hive

  • How Hive Organise the Data?
  • How Does Apache Hive Software Work?
  • What are the Different Data Types Used by Apache Hive?

Module 6: Extract Business Value with HiveQL

  • What is Business Value?
  • What is HiveQL?
  • HiveQL Built-in Operators

Module 7: Real-Time Access to Hadoop Based Data Lake

  • Introduction to Hadoop-Based Data Lake
  • Proposed High-Level Approach
  • Hadoop-Based Data Processing
  • Business Scenario

Show moredown

Who should attend this Pig and Hive Training for Extracting Business Data?

The Pig and Hive Training for Extracting Business Data is a comprehensive course designed to equip participants with the skills and knowledge needed to effectively use Pig and Hive, two powerful tools in the Hadoop ecosystem, for extracting, transforming, and analysing business data. This course is useful for the following professionals:

  • Business Analysts
  • Data Analysts
  • Data Engineers
  • Information Technology Professionals
  • Managers
  • Database Administrators
  • Business Intelligence Professionals

Prerequisites of the Pig and Hive Training for Extracting Business Data

There are no formal prerequisites for the Pig and Hive Training for Extracting Business Data. However, a basic understanding of data extraction and Hadoop can be beneficial.

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

What’s included in this Pig and Hive Training for Extracting Business Data

  • World-class Training Sessions from Experienced Instructors
  • Pig and Hive Training for Extracting Business Data Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Grafana Training Course Outline

Module 1: Introduction to Grafana

  • What is Grafana?
  • Features of Grafana
    • Dashboard Templating
    • Provisioning
    • Annotations
    • Monitoring
    • Custom Plugins
    • Alerting and Alert Hooks
    • Permission and Teams
    • SQL Data Sources
  • Install Grafana OSS

Module 2: Grafana with InfluxDB and Prometheus

  • Grafana with InfluxDB
  • Grafana and Prometheus

Module 3: Best Practices

  • Common Observability Strategies
  • Dashboard Management Maturity Level
  • Exemplars
  • Intro to Time Series
  • Build a Grafana Query
  • Build a Prometheus Query in Grafana
  • How to Connect Grafana with MySQL?

Module 4: Organisation and Dashboard Management

  • Create an Organisation
  • Manage Organisations
    • Delete an Organisation
    • Edit an Organisation
  • Creating Dashboard
  • User Management
    • View User Details
    • User Information
    • Permissions
    • Organisations
    • Sessions

Module 5: Template and Variables

  • Templates and Variables
  • Variable Syntax
  • Add a Query Variable

Show moredown

Who should attend this Grafana Training Course?

The Grafana Training is a comprehensive course designed to provide participants with the skills and knowledge needed to effectively use Grafana, a powerful open-source platform for data visualisation, monitoring, and analytics. This course is useful for the following professionals:

  • Business Managers
  • Business Analysts
  • DevOps Engineers
  • Data Scientists
  • System Administrators
  • Information Technology Professionals
  • Business Intelligence Professionals

Prerequisites of the Grafana Training Course

There are no formal prerequisites for the Grafana Training. However, a basic understanding of business intelligence and report making can be beneficial.  

Grafana Training Course Overview

Grafana is a free and open-source data visualisation and analytics tool that assists in studying, analysing, and monitoring data over a period of time, technically called time-series analytics. It provides a highly customisable and interactive dashboarding interface for visualising and gaining insights from data. Studying this training helps individuals connect to different data sources seamlessly, consolidating and visualising data from multiple systems in a unified dashboard. This training allows organisations to monitor log analytics and infrastructure, primarily boosting their operational efficiency. Pursuing this training helps individuals get equipped with the Grafana skills and techniques to enhance their career opportunities and increase their earnings.

This 1-day Grafana Training course covers all of the essential topics that will allow delegates to become thoroughly acquainted with Grafana. During this training, they will learn about how to manage organisations and user permissions with Grafana. They will also learn how to transform metrics into meaningful visualisations and store time series data like metrics. 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 Grafana.

Course Objectives

  • To learn how to search and query data among large volumes of logs
  • To get deep knowledge about how to install and set up Grafana OSS
  • To explore the best practises for observability and dashboard management
  • To attain knowledge of how to create meaningful data graphs and visualisations
  • To understand how to connect Grafana with MySQL for data visualisation
  • To implement templates and variables in Grafana dashboards

After attending this training course, delegates will be able to identify query traces that demonstrate significant latency over a specific period of time. 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

What’s included in this Grafana Training Course

  • World-class Training Sessions from Experienced Instructors
  • Grafana Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Classroom (2 days)

Online Self-paced (16 hours)

JasperReports Training Course Outline

Module 1: Introduction to JasperReports

  • Overview
  • Report Template
  • Troubles in Report Development

Module 2: Getting Started

  • Installing iReport
  • Creating Your First Report
  • Using the Sample Database
  • Using the Report Wizard

Module 3: Basic Notions od JasperReports

  • Report Life Cycle
  • Data Sources and Print Formats
  • Expressions
  • Using Java as a Language for Expressions
  • Using Groovy as a Language for Expressions
  • Using JavaScript as a Language for Expressions

Module 4: Report Structure

  • Bands
  • Working with Bands

Module 5: Reports Elements

  • Working with
    • Elements
    • Images
    • Text
  • Other Elements
  • Adding Custom Components and Generic Elements

Module 6: Fields, Parameters, and Variables

  • Working with
    • Fields
    • Parameters
    • Variables
  • Evaluating Elements During Report Generation

Module 7: Bands and Groups

  • Modifying Bands
  • Working with Groups
  • Other Group Options

Module 8: Fonts and Styles

  • Working with Fonts
  • Using TrueType Fonts
  • Using the Fonts Extensions
  • Character Encoding
  • Use of Unicode Characters
  • Working with Styles
  • Creating Style Conditions
  • Referencing Styles in External Property Sheets

Module 9: Templates

  • Template Structure Overview
  • Groups
  • Column Header
  • Detail Band
  • Creating a New Template
  • Installing and Using the Template

Module 10: Data Sources and Query Executers

  • How a JasperReports Data Source Works
  • Understanding Data Sources and Connections in iReport
  • Working with JDBC Connection
  • Understand the JRDataSource Interface
  • Data Source Types
  • Importing and Exporting Data Sources
  • Create Custom Languages and Query Executers

Module 11: Lists, Tables, and Branches

  • Lists
  • Tables
  • Creating a Tables
  • Tables Structure
  • Editing the Table Layout
  • Working with Columns
  • Working with Barcodes
  • Barbeque Component
  • Barcode4J Component

Module 12: Subdatasets

  • Creating a Subdataset
  • Dataset Runs

Module 13: Internalisation

  • Overview
  • Using a Resource Bundle Base Name
  • Retrieving Localised Strings
  • Formatting Messages
  • Generating a Report Using a Specific Locale and Time Zone
  • Report Fonts
  • Default Fonts and Inheritance

Show moredown

Who should attend this JasperReports Training Course?

The JasperReports Training Course is designed for individuals who want to learn how to create, customise, and manage reports using the JasperReports library, a popular open-source reporting tool. A variety of professionals can benefit from this course, such as:

  • Business Analysts
  • Data Analysts
  • Technical Consultants
  • Software Architects
  • Java Programmers
  • System Administrators
  • Aspiring Developers

Prerequisites of the JasperReports Training Course

There are no formal prerequisites for this JasperReports Training Course.

JasperReports Training Course Overview

JasperReports is an open-source reporting library that enables users to produce pixel-perfect reports that can be printed or exported in various file types, including PDF, HTML, and XLS. The purpose of JasperReports is to generate dynamic content for Java-enabled applications. This training teaches learners about report generation performance and delivery to users and enables the use of data from multiple sources for a single report. This training assists organisations in supplying data in different ways. Holding skills in this training course can help individuals gain quick and prominent professional growth and expand career opportunities in their work field.

In this 2-day JasperReports Training course, delegates will gain in-depth knowledge about listing the names of the specific fields. They will learn about applying report styles to control text properties in a report template. They will also understand how to execute and export the report into the desired format. Additionally, they will acquire the skills to create charts and sub-reports, including configuring chart properties, datasets, and plot types. Our highly skilled professionals with years of teaching experience will conduct this training and equip delegates with the concepts of JasperReports.

Course Objectives

  • To obtain knowledge about creating multiple data sources to transfer data
  • To learn about how to create a JRXML and preview the XML report template
  • To change the core logic of the report if the business logic changes
  • To learn about how to achieve customisation using scriptlets
  • To understand how to implement reports in the report structure
  • To get in-depth knowledge about the usage of parameters and variables

After completing this training, delegates will be able to export various formats of reports with watermarks applied over the main image. They will also be able to utilise data from multiple data sources in a single report and an embedded reporting server to create and execute reports.

Show moredown

What’s included in this JasperReports Training Course?

  • World-Class Training Sessions from Experienced Instructors 
  • JasperReports Training Certificate  
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Flowchart Mapping Masterclass Course Outline

Module 1: Basics of Process Map

  • Introduction
  • What is a Process Map?
  • Benefits of using Process Maps
  • Business Process Modelling Tools
  • Cross-Functional and Deployed Diagrams
  • Detailed Flowchart
  • Process Analysis
  • Analysing Process Maps

Module 2: Introduction to Business Process Mapping

  • What is Business Process Mapping?
  • What are the Tasks in the Process?
  • What is the Difference Between Mapping and Modeling?
  • Needs of Business Process Mapping
  • Benefits of Business Process Mapping
  • How to Create a Process Map?
  • Best Practices for Business Process Mapping
  • Types Business Process Mapping
  • How Can I Start Using Business Process Mapping?

Module 3: Business Process Mapping Techniques and Tools

  • SIPOC Diagrams
  • BPMN Process Maps
  • UML Diagrams
  • VSM (Value Stream Mapping)
  • IPO (Input-Process-Output) Model
  • GUT Priority Matrix

Module 4: Steps to Create a Business Process Map

  • Identify the Problem
  • Brainstorm Activities Involved
  • Figure Out Boundaries
  • Determine and Sequence the Steps
  • Draw Basic Flowchart Symbols
  • Finalise the Process Flowchart

Module 5: Process Mapping Symbols and Notation

  • Process and Operation Symbols
  • Branching and Control of Flow Symbols
  • Input and Output Symbols
  • File and Information Storage Symbols
  • Data Processing Symbols
  • Process Mapping Symbols Tip

 

 

Show moredown

Who Should Attend the Flowchart Mapping Masterclass?

The Flowchart Mapping Masterclass is designed for professionals seeking to enhance their skills in creating and analysing Flowcharts to improve processes and communication within their organisations. This course will benefit the following professionals:

  • Process Improvement Managers
  • Business Analysts
  • Project Managers
  • Operations Managers
  • Quality Assurance Professionals
  • Supply Chain Managers
  • Lean Six Sigma Practitioners
  • Continuous Improvement Specialists

Prerequisites of the Flowchart Mapping Masterclass

There are no formal prerequisites to attend the Flowchart Mapping Masterclass. However, a basic knowledge of business process management would be beneficial. 

Flowchart Mapping Masterclass Course Overview

A process map is a planning and management tool that visually describes workflow. It provides insight into a process, assist teams in brainstorming process improvement ideas, improve communication, and document the process. The purpose of process mapping is to assist individuals in improving business efficiency. Individuals can use process mapping to break down a process, leading to additional improvements in efficiency and productivity. This Flowchart Mapping Masterclass course allows them to understand how to easily apply knowledge and skills of process mapping in their work environment effectively. Pursuing this training course will help individuals excel in highly reputed jobs and upgraded salaries.

In this 1-day Flowchart Mapping Masterclass training course, delegates will gain in-depth knowledge about business process mapping best practices. During this training, delegates will learn various concepts such as basics of process map, benefits, business process modelling tool, types of business process modelling, data processing symbols, process mapping symbols tip, steps to create a business process map, etc. Our highly professional trainer with years of experience in such courses will conduct this training and help delegates to gain a comprehensive understanding of business process mapping.

This training will cover various essential topics, such as: 

  • What is a process map?
  • Business process mapping
  • Needs of business process mapping
  • UML diagrams
  • Create a business process map

At the end of this training, delegates will be able to identify the basic and advanced process mapping symbols and notation. They will also be able to apply tools and business process mapping in an organisation successfully.

Show moredown

What’s included in this Flowchart Mapping Masterclass?

  • World-Class Training Sessions from Experienced Instructors
  • Flowchart Mapping Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Qlik Sense Training Course Outline

Module 1: Introduction to Qlik Sense

  • What is Qlik Sense?
  • What can You Do in Qlik Sense?
  • How does Qlik Sense Work?
  • How can You Deploy Qlik Sense?
  • How to Manage and Monitor Qlik Sense Sites?
  • Extend Qlik Sense and Adapt it for Your Own Purposes

Module 2: Introducing Qlik Sense Installation Guide

  • System Requirements for Qlik Sense
  • Supported Browsers in Qlik Sense
  • Related Documentation
  • Support Services
  • What is included in a Qlik Sense Installation?

Module 3: Planning the Qlik Sense Deployment

  • Architecture
  • Deployment
  • Setup Workflow

Module 4: Installing Qlik Sense

  • Installation Prerequisites
  • Obtaining the Qlik Sense Setup File
  • Performing a Quick Installation
  • Performing a Custom Installation

Module 5: Setting up a Qlik Sense installation

  • Connecting Qlik Sense to Your User Directory
  • Assigning Licenses to Users
  • How Qlik Sense Uses HTTPS and Certificates?
  • Creating and Opening Apps
  • Working with Streams, Apps, and Publishing
  • Managing Licenses
  • Managing User Access

Module 6: Maintaining Qlik Sense

  • Modifying Qlik Sense
  • Repairing Qlik Sense
  • Uninstalling Qlik Sense

Module 7: Upgrading Qlik Sense

  • Upgrade Prerequisites
  • Performing a Quick Major Upgrade
  • Performing a Custom Major Upgrade
  • Performing a Minor Upgrade

Module 8: Silent operations

  • Installation
  • Modify
  • Repair
  • Uninstall
  • Major Upgrade
  • Minor Upgrade

Show moredown

Who should attend this Qlik Sense Training Course?

The Qlik Sense Training Course introduces professionals to the world of data visualisation, analytics, and Business Intelligence (BI) using the Qlik Sense platform. This course can help a lot of professionals and some of them include:

  • Data Analysts
  • Data Scientists
  • Data Visualisation Designers
  • Data Engineers
  • IT Managers
  • Business Analysts
  • Solution Architects
  • Database Administrators

Prerequisites of the Qlik Sense Training Course

There are no formal prerequisites for attending the Qlik Sense Training Course.

Qlik Sense Training Course Overview

Qlik Sense is a leading cloud analytics platform that offers leading analytics capabilities to users required for visualisation and creating dashboards, mobile analytics, natural language analytics, custom, and embedded analytics, reporting, and alerting. It provides more visualisation features than QlikView as Qlik Sense has comparatively more graphics. Qlik Sense has great flexibility as it carries completely independent operations such as visualisation and analysis.

It is also useful to integrate massive data files from various sources and helps in creating visualised and interactive apps and dashboards. Qlik Sense is compatible with desktops, tablets, laptops, mobile phones, etc., and helps organisations and professionals create and analyse the applications more easily. Pursuing this Qlik Sense Training will help individuals to climb up the ladder of success and get more advanced career opportunities.

In this 1-day Qlik Sense Training Course, delegates will learn about the Qlik Sense architecture and its functioning. They will also learn about the fundamentals of deployment and various functions supported by the Qlik Sense software. Delegates will also learn about the functions supported by QlikView and work on Qlik Sense with other apps. Our highly skilled tutors will conduct this Qlik Course and help delegates to become more practised and skilful at using Qlik Sense and its functions.

Course Objectives:

  • To attain in-depth knowledge about Qlik Sense
  • To gain an understanding of the basics of deployment
  • To learn about various functions of Qlik Sense
  • To become familiar with Qlik Sense software and its working
  • To come in touch with the difference between Qlik Sense and Qlik View

After completing this Qlik Sense Training Course, delegates will be able to create applications and various dashboard sheets. They will also be able to use Qlik Sense software smoothly for various purposes.

Show moredown

What’s included in this Qlik Sense Training Course?

  • World-Class Training Sessions from Experienced Instructors
  • Qlik Sense Certificate
  • Digital Delegate Pack

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

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 for Business Intelligence Reporting.
The price for Business Intelligence Reporting certification in the United Kingdom starts from £1295.

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