Microsoft Power BI Desktop In-company / Bespoke

Introduction to Power BI

• Power BI Jargon explained
• A quick look at Power BI Desktop
• A quick look at the Power BI service
• Helpful resources

Power BI and Excel

• Introduction to using Excel data in Power BI
• Upload Excel data to Power BI
• Import Power View and Power Pivot to Power BI

Getting started with Power BI Desktop

• Overview of Power BI Desktop
• Accessing Help and Helpful resources
• Connect to data sources in Power BI Desktop

Shaping and Transforming Data with Query Editor

• Introduction to the Query Editor
• Data Sources Power BI Desktop can Connect to
• Introduction to Steps and M code
• Combining Data Using Merge and Append Queries
• Data Type Properties
• Working with Delimiters
• Clean and transform your data with the Query Editor
• Text Specific Transformation Tools
• Number Specific Transformation Tools
• Date Specific Transformation Tools
• Split and Merge columns
• Creating an Index Column
• Adding Conditional Columns
• Columns From Examples
• Grouping and Aggregating data
• Pivoting and Unpivoting
• Using filters

Modeling the data

• Introduction to modeling your data
• How to manage your data relationships
• Create calculated columns
• Optimizing data models
• Create calculated measures
• Show Values As and Quick Measures
• Create calculated tables
• Explore your time-based data
• Introduction to DAX
• DAX calculation types
• DAX functions

Visualizations

• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Modify colors in charts and visuals
• Shapes, text boxes, and images
• Page layout and formatting
• Group interactions among visualizations
• Visual hierarchies and drill-down
• Using custom visualizations
• Create a KPI Visualization
• Geo-Data and Maps

Reports, Publishing and Sharing

• Introduction to the Power BI service
• Quick insights in Power BI
• Create and configure a dashboard
• Ask questions of your data with natural language
• Create custom Q&A suggestions
• Share dashboards with your organization
• Introduction to content packs, security, and groups
• Publish Power BI Desktop reports
• Print and export dashboards and reports
• Create groups in Power BI
• Use content packs
• Update content packs
• Publish to web