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:
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.
In this introduction we discuss the different topics and modules that we will be covering in the course. Different topics include Loading data, creating tables and reports, creating visualizations, developing dashboards and sharing data through the PowerBI cloud solution.
In this lesson we will learn how to access and use the PowerBI interface. The PowerBI Interface consists of functions to upload or access data, create reports and create dashboards.
In this lesson we learn how to load data into the PowerBI Desktop. We review the different types of data that can be loaded and also the methods and processes for loading data.
In this lesson you will learn to summarize your data using Cards and Gauges. These visualization options are powerful for displaying key metric data and key performance indicator calculations.
In this lesson you will learn to analyze your data using Tables and Matrix visualizations. Tables and Matrixes make it easy to aggregate your data and provide quick summaries. Different methods of aggregation such as Sum, Average, Count, Distinct Count, MIn and Max are also shown.
In this lesson you will learn how to use Slicers to easily filter your data. Slicers are text or category items that can easily filter your data. For example you may have a list of different branches in your company and then want to filter your reports to display one branch at a time.
In this lesson you will learn to filter data in reports using page filters. Page allow conditions such as Start With, Contains, Is Greater Than and Before and After Dates.
In this lesson we will review how to create tables, key metrics and filters in this practical activity
In this lesson you will learn how to create clustered column and bar graphs. Clustered Column and Bar graphs are ideal for displaying data when you want to know which is the largest item or which is the smallest item or how much bigger one item is then another.
In this lesson we will review the stacked bar and column graph. The stacked column and bar graph places each series on top of each other and displays the aggregated total.
In this lesson you will learn the power of cross filtering between Column and Bar graphs.
In this lesson you will learn how to create line charts to display trends. Displaying and analyzing how data changes over time is a powerful method of analysis that provides input into forecasting.
In this lesson we will learn how to create Pie charts in PowerBI. Pie charts are useful for showing the percentage that item contributes to the whole or the 100%
In this lesson we will learn how to create area graphs. Area graphs are useful when you want to see how data changes over time and also see how the magnitude of the data changes over time.
In this lesson you will learn how to create a Treemap visualizations. TreeMap is another method of visualizing your data to understand which items contribute the most or the least to the total.
In this lesson you will learn to create relationships between different tables of data. Relationships allow the creation of reports using fields from different tables such as lookup fields. For example you may have a Product ID in your main table, but want to know what the Product Name is. Relationships are used to join the two tables.
In this lesson you will learn how to analyze and create reports using relationships between more than one table of data.
In this lesson you will learn about the power of calculated measures to create powerful key metrics and key performance indicator calculations.
In this lesson you will learn how to create Sum, Count, Distinct Count, Average, Min and Max calculations in PowerBI.
In this lesson you will learn how to create an interactive dashboard that can be uploaded to the PowerBI cloud.
In this lesson you will learn how to load your dashboard into the cloud.
In this lesson you will learn the Edit Query interface and how to load data
In this lesson you will learn how to transform and correct data errors in PowerBI
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.
Ian has been training learners on these powerful technologies for a number of years making it easy for the business user to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.