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

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

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

COURSE OBJECTIVES

• 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

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