What you’ll learn

Understanding Microsoft Business Intelligence Service

• What is Microsoft PowerBI service and the related products
• PowerBI vs Excel's Business Intelligence tools

Managing External Data

• Overview of external source types
• Importing heterogeneous data sources
• Linking or adding Excel Tables

Merging and combining data

• Merge Queries
• Append Queries
• Combine Files

Shaping and transforming data

• Splitting and merging columns
• Removing columns and rows
• Replacing data

Data model and tables relationship

• Working with multiple tables
• Tables relationship and linking
• Using Query Editor to import data
• Creating connections to data sources
• Creating relationships (auto detect and manual)

Introduction to Data Analysis Expression Language (DAX)

• Calculation in DAX
• DAX Data Types and DAX Operators
• Custom columns and measures
• Working with DAX functions

Working with reports

• Query Editor Introduction
• Adding Column
• Text Transformations
• Grouping data
• Number Column Calculations
• Date and Time Calculations

Designing and generating dashboards

• Power BI Desktop Visualizations
• Guidelines to format Visuals in Power BI Desktop
• KPI, Built-in Charts and Graphs in Power BI
• Custom sorting, Filtering, and categorization
• Working with matrix and table
• Visual level filters
• Page level filters
• Report level filters