Strategic Business Intelligence

Course Info

Length: 1 Week

City: Kuala Lumpur

Type: In Classroom

Available Dates

  • Jan-20-2025

    Kuala Lumpur

  • Feb-17-2025

    Kuala Lumpur

  • Mar-17-2025

    Kuala Lumpur

  • Apr-21-2025

    Kuala Lumpur

  • May-19-2025

    Kuala Lumpur

  • June-16-2025

    Kuala Lumpur

  • July-21-2025

    Kuala Lumpur

  • Aug-18-2025

    Kuala Lumpur

  • Sep-15-2025

    Kuala Lumpur

  • Oct-20-2025

    Kuala Lumpur

  • Nov-17-2025

    Kuala Lumpur

  • Dec-15-2025

    Kuala Lumpur

Dates in Other Venues

  • Oct-07-2024

    Dubai

  • Oct-07-2024

    Barcelona

  • Oct-28-2024

    Paris

  • Oct-28-2024

    Singapore

  • Nov-04-2024

    Dubai

  • Nov-04-2024

    Barcelona

  • Nov-25-2024

    Singapore

  • Nov-25-2024

    Paris

  • Dec-02-2024

    Dubai

  • Dec-02-2024

    Barcelona

  • Dec-23-2024

    Barcelona

  • Dec-23-2024

    Singapore

  • Dec-30-2024

    Paris

  • Dec-30-2024

    Dubai

  • Jan-06-2025

    Amsterdam

  • Jan-06-2025

    London

  • Jan-13-2025

    Dubai

  • Jan-13-2025

    Barcelona

  • Jan-20-2025

    Istanbul

  • Jan-27-2025

    Singapore

  • Jan-27-2025

    Paris

  • Feb-03-2025

    Amsterdam

  • Feb-03-2025

    London

  • Feb-10-2025

    Barcelona

  • Feb-10-2025

    Dubai

  • Feb-17-2025

    Istanbul

  • Feb-24-2025

    Singapore

  • Feb-24-2025

    Paris

  • Mar-03-2025

    London

  • Mar-03-2025

    Amsterdam

  • Mar-10-2025

    Dubai

  • Mar-10-2025

    Barcelona

  • Mar-17-2025

    Istanbul

  • Mar-24-2025

    Paris

  • Mar-24-2025

    Singapore

  • Apr-07-2025

    Amsterdam

  • Apr-07-2025

    London

  • Apr-14-2025

    Dubai

  • Apr-14-2025

    Barcelona

  • Apr-21-2025

    Istanbul

  • Apr-28-2025

    Singapore

  • Apr-28-2025

    Paris

  • May-05-2025

    Amsterdam

  • May-05-2025

    London

  • May-12-2025

    Dubai

  • May-12-2025

    Barcelona

  • May-19-2025

    Istanbul

  • May-26-2025

    Paris

  • May-26-2025

    Singapore

  • June-02-2025

    London

  • June-02-2025

    Amsterdam

  • June-09-2025

    Dubai

  • June-09-2025

    Barcelona

  • June-16-2025

    Istanbul

  • June-23-2025

    Singapore

  • June-30-2025

    London

  • June-30-2025

    Paris

  • June-30-2025

    Amsterdam

  • July-07-2025

    London

  • July-07-2025

    Amsterdam

  • July-14-2025

    Dubai

  • July-14-2025

    Barcelona

  • July-21-2025

    Istanbul

  • July-28-2025

    Singapore

  • July-28-2025

    Paris

  • Aug-04-2025

    London

  • Aug-04-2025

    Amsterdam

  • Aug-11-2025

    Barcelona

  • Aug-11-2025

    Dubai

  • Aug-18-2025

    Istanbul

  • Aug-25-2025

    Paris

  • Aug-25-2025

    Singapore

  • Sep-01-2025

    Amsterdam

  • Sep-01-2025

    London

  • Sep-08-2025

    Dubai

  • Sep-08-2025

    Barcelona

  • Sep-15-2025

    Istanbul

  • Sep-22-2025

    Singapore

  • Sep-29-2025

    Paris

  • Sep-29-2025

    London

  • Sep-29-2025

    Amsterdam

  • Oct-06-2025

    Amsterdam

  • Oct-06-2025

    London

  • Oct-13-2025

    Barcelona

  • Oct-13-2025

    Dubai

  • Oct-20-2025

    Istanbul

  • Oct-27-2025

    Paris

  • Oct-27-2025

    Singapore

  • Nov-03-2025

    Amsterdam

  • Nov-03-2025

    London

  • Nov-10-2025

    Dubai

  • Nov-10-2025

    Barcelona

  • Nov-17-2025

    Istanbul

  • Nov-24-2025

    Singapore

  • Nov-24-2025

    Paris

  • Dec-01-2025

    London

  • Dec-01-2025

    Amsterdam

  • Dec-08-2025

    Dubai

  • Dec-08-2025

    Barcelona

  • Dec-15-2025

    Istanbul

  • Dec-22-2025

    Singapore

  • Dec-29-2025

    London

  • Dec-29-2025

    Amsterdam

  • Dec-29-2025

    Paris

Course Details

Course Outline

5 days course

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

Course Video