MICROSOFT POWER BI

Basic Topics

• Introduction
• Project Setup - Installation
• How Power BI works
• Connecting Power BI Desktop to the Source Files
• Query Editor Walkthrough
• Removing Blank Rows & Fixing Format Errors
• Saving the Project
• Duplicates vs References
• Appending Queries
• Splitting Columns & Extracting Data
• Basic Column Interactions
• Data Modelling Theory
• Creating the Table
• Working with Indexes
• The Formula Bar
• Merging Queries
• Loading Data Into the Data Model
• Creating Line Charts
• Understanding Relationships
• Formatting Numbers in Charts
• Understanding Interactions
• Hierarchies & Drill-Down
• Sorting Axis Values
• Formatting Visuals & Applying Report Themes
• Reports, Map Visual & Default Summarization
• The Data Category
• Applying Filters to Visuals
• Understanding Slicers
• Creating Tables
• Working with DAX ("Data Analytics Expressions")
• Sorting Weekdays with Calculated Columns
• Fixing the Calculation
• Introducing Measures
• Working with Quick Measures
• Publish
• Share
• Subscription Types
• Dashboards Realtime Project

Advanced Topics

• Advanced DAX Functions and Measures
• Time Intelligence in DAX
• Row-level Security (RLS)
• Using Parameters and What-if Analysis
• Drillthrough and Tooltips
• Bookmarks and Button Navigation
• Data Refresh and Gateway Configuration
• Creating Custom Visuals
• Performance Optimization
• Power BI with SQL and DirectQuery

CONTACT US