Contact Info

Microsoft Excel Power BI

Microsoft Excel Power BI

  • OVERVIEW

  • LEARNING OUTCOME

  • TRAINING METHOD

Self-service business intelligence (BI)—you have heard the hype, seen the sales demos, and are ready to give it a try. Now what? You have probably checked out a few web sites for examples, given them a try, and learned a thing or two, but you are probably still left wondering how all the pieces fit together and how you go about creating a complete solution. If so, this training is for you. It takes you step by step through the process of analyzing data using the tools that are at the core of Microsoft’s self-service BI offering: Power Query, Power Pivot, and Power BI.

This training will enable candidates to:

  • Work with Power BI Desktop
  • Import Data into Power BI
  • Perform Data Cleaning with Power Query
  • Create the Data Model
  • Create Interactive Dashboard with Power BI Desktop

Hands on session
We will conduct per and post test to evaluate the participant learning curve.
The report will be submitted to the Learning & Development Department.

 

Training Course Outline

Module 1: Introducing Power BI Desktop

  • What is Power BI Desktop
  • Difference between Excel and Power BI
  • Installing Power BI
  • Setting Up the Power BI Environment

Module 2: Importing Data into Power query

  • Importing Data from Relational Databases
  • Importing Data from Text Files

Module 3: Data transformation with Power Query

  • Discovering and Importing Data
  • Transforming, Cleansing, and Filtering Data
  • Merging and Shaping Data
  • Grouping and Aggregating Data
  • Inserting Calculated Columns

Module 4: Creating the Data Model

  • What Is a Data Model?
  • Creating Table Relations
  • Creating a Star Schema
  • Understanding When to De-normalize the Data
  • Creating Linked Tables
  • Creating Hierarchies
  • Making a User-Friendly Model

Module 5: Creating Calculations with DAX

  • Creating simple DAX calculated column
  • Create measures.
  • Know the difference between measures and calculated column.

Module 6: Creating Reports and Dashboard

  • Creating Tables and Matrices
  • Constructing Bar, Column, and Pie Charts
  • Building Line and Scatter Charts
  • Creating Map-Based Visualizations
  • Linking Visualizations in Power BI
  • Drilling Through Visualizations

Course Info

  • No. Of Days: 2 Days
  • Language:English
  • Prerequisites:

    Participants with knowledge of Excel Formulas and functions will be an advantage.

  • Training materials:

    Printed Notes and exercises file 

Enquire Now

If you are project engineers, graduate students, school leavers, planners or designers who are looking for any of the above training courses, Six Sigma Synergy is the best choice!

Quick links

Useful Links

Connect

C-18-06, 3 two square, Block C, 6th floor, Jalan 19/1, 46300 Petaling Jaya, Selangor, Malaysia

© Copyrights , Six Sigma Synergy. All Rights Reserved.
Developed By Techno Vibes

Trams & Condition Privacy Policy Contact Us