Powerful Reports and Dashboards with Microsoft Power BI

Course details

---- Update October 2017 -----

Microsoft Power BI is continually evolving.  We have added the following new lessons to address the new features that Power BI have added in recent months:

• Using the new Table and Matrix visualizations
• Creating Drill through between different sheets.  For example you could be reviewing a list of Products and want to select one Product to view a summary of this product
• Themes - Learn how to add new Power BI Themes from the Community Theme Gallery
• Changes in  Custom Visuals - We look at how to easily add Custom Visualizations from the new Microsoft Office Store
• Creating Apps - Learn how to easily share your dashboards and reports using Power BI apps and App workspaces
• Relative Date Filters - In this lesson we show how to easily create a dashboard displaying Microsoft stock data.  Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters
• Quick Measures - Learn how to easily create and use Quick Measures.  Calculate averages across categories or Year to Date totals on tables.
• Ribbon Chart - Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

-----------------------------------------

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.

The course covers the following topics:

• Introduction to Power BI and how to signup
• How to create your first online report and dashboard
• How to download the Power BI Desktop Designer
• Loading, transforming and filtering data in Power BI
• Creating tables and reports
• Learning how to use the wide range of graphs and visualizations
• Creating relationships between tables of data
• Creating powerful calculations, key metrics and key performance indicators
• Creating interactive dashboards
• Publishing dashboards to Power BI

In this course we use a step by step video based approach to show you how to create reports, analyze data and develop interactive dashboards. The videos are extremely easy to follow and data is provided so you can follow the instructions at the same time.