by Ian LittleJohn | Released January 2018 | ISBN: None

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free - all you need to do is sign up! In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses powerful drag and drop capabilities that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop. This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful PowerBI Desktop Designer. Show and hide more Publisher Resources Download Example Code

1. Promo 00:02:14
2. Introduction
   • Introduction to PowerBI 00:02:14
   • Signing up for PowerBI 00:06:45
3. The Power BI Desktop Designer
   • Download the Power BI Desktop Designer 00:10:32
4. Creating Reports in Power BI Desktop
   • Introduction to Reports in Power BI 00:10:30
   • Answers to Tables and Metrics Practical Activity 00:04:40
   • Table Styles, Formatting and Conditional Formatting 00:05:59
   • Changing the Method of Aggregation 00:07:29
   • Challenge 2 Completed 00:06:15
   • Tables and Cards 00:09:39
   • The Quick Calc Option 00:03:39
   • Filtering Data - Using Slicers 00:07:41
   • Filtering Data - Visual Filters 00:08:16
   • Filtering Data - Page Filters 00:02:17
   • New Feature - New Tables and Matrix Visualizations 00:05:19
   • New Feature - DrillThrough Filter 00:04:27
   • New Feature - Quick Measures 00:09:30
5. Graphs and Visualizations
   • Column Graphs 00:11:36
   • Stacked and 100% Graphs 00:08:34
   • Graph Options 00:06:21
   • Trend Analysis Graphs 00:07:49
   • Additional Graphs 00:13:57
   • Scatterplots 00:07:12
   • Bubbleplots 00:04:43
   • New Feature - Ribbon Chart 00:05:40
6. Interactive Dashboards
   • Creating Interactive Dashboards 00:12:02
   • Publishing Dashboards 00:01:55
   • Pinning and Q & A 00:05:56
   • Sharing Dashboards 00:02:40
   • Power BI on Mobile 00:04:41
   • New Feature - Themes 00:06:09
   • New Feature - Change in Custom Visuals 00:04:00
   • New Feature - Creating Power BI Apps 00:13:19
   • New Feature - Relative Filters Part 1 00:12:54
   • New Feature - Relative Filters Part 2 00:09:35
7. DAX Formulas
   • DAX Formulas 00:06:10
   • Time Intelligence 00:10:36
   • Formatting Dates 00:05:01
   • Date Master Tables 00:07:43
8. DAX Measures
   • Introduction to DAX Measures 00:11:14
   • The Calculate Formula 00:08:05
9. Relationships
   • Creating and Managing Relationships in Power BI 00:03:41
   • Using Custom Visualizations in Power BI 00:04:12
   • Using the Related Formula 00:02:19
10. Enhancing Power BI
    • Transforming Data with Power BI 00:09:48
    • Aggregating Data 00:05:00
11. Analyze Data with Excel
    • Introduction to Analyze Power BI Data with Excel 00:04:21
    • Creating Measures for Excel Analysis 00:03:33
    • Additional Measures for Excel 00:08:06
12. Conclusiom
    • Conclusion 00:00:40
Show and hide more