Excel Power Business Intelligence (Power BI) For Productivity
Excel Power Business Intelligence (Power BI) For Productivity MICROSOFT OFFICE TRAINING Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd


Course Duration: 2 Days


This course provides you the knowledge and skills that you need to analyze data with Power Business Intelligence to maximize your productivity in workplace.


This course is suitable for professionals who need to analyze data by utlizing Power BI, technically proficient business users.


  • Basic knowledge of Microsoft Windows operating system and it's core functionality
  • Basic knowledge of data warehouse scheme topology (including star and snowflakes schemas)
  • Some exposure to basic programming concepts 
  • An awareness of key business priorities
  • Familiar with Microsoft Excel


  • Able to describe key features of self-service business intelligence solutions
  • Describe Power BI and it's data source
  • Model, shape and combine data
  • Describe Power BI Data Visualizations


Module 1: Introduction to Self-Service Business Intelligence Solutions

  • Introduction to Business Intelligence
  • Introduction to Data Analysis
  • Introduction to Data Visualization
  • Overview of Self-Service Business Intelligence
  • Microsoft Tools for Self-Service Business Intelligence

Module 2: Introducing Power Business Intelligence

  • Power Business Intelligence
  • Power Business Intelligence Service
  • Power Business Intelligence Mobile Apps

Module 3: Power BI Data

  • Using Excel as a Power BI Data Source
  • Using Databases as Power BI Data Source
  • The Power BI Service

Module 4: Shaping and Combining Data

  • Power BI Desktop Queries
  • Shaping data
  • Combining data

Module 5: Modelling Data

  • Relationships
  • DAX Queries
  • Calculations and measures

Module 6: Interactive Data Visualizations

  • Creating Power BI Reports
  • Managing a Power BI Solutions

Please leave your enquiry here, we will reply as soon as possible.

*only support gif, jpeg, jpg, png, pdf
Switch To Desktop Version