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

Creating data models

• Knowing different kinds of joins
• Normalization
• Creating connections to data sources
• Editing table properties
• Defining data Tables
• Knowing data types
• Creating relationships (auto detect and manual)

Working with Query Editor

• Importing Excel, csv, text, Access and data from SQL server
• Creating tables
• Diagram view vs. data view
• Transformation GUI
• Row transformations
• Column transformations
• Text Transformations
• Adding and removing columns or rows

Working with filters

• Slicer for labels
• Slicer for Date information
• Visual level filters
• Page level filters
• Report level filters

Power BI Dashboards and Data Visualizations

• Power BI Desktop visualization
• Formatting visuals in Power BI Desktop
• Waterfall chart, donut chart, scatter chart
• cluster column chart and line and area chart
• sorting and advanced sorting
• Funnel, KPIs, card, multi-rows card, guage
• Working with matrix and report
• Rows / Columns / Values settings
• Adding buttons, images and bookmarks to dashboards
• Adding images