Excel Power Business Intelligence (Power BI) For Productivity

Introduction

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

Audience

Pre-requisites

• 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

Key Content

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