Microsoft Power BI

Power BI is the hot topic application in the Microsoft ecosphere, but not many people know what it is, or what it does.  Learn what makes Power BI tick, and how you can use it right out of the gate.

There’s no time like the present for getting your hands dirty and creating a Power BI Dashboard. Power BI has one of the steepest learning curves, but you’ll walk away with a clear understanding of where to begin.

Power BI gets its power from its ability to shape and visualize data. This class will introduce to you to different methods for importing data and it will set the best practices for your future work.

Power Query is one of two sister programs that works alongside Power BI to build dashboards. Power Query specializes in getting data from a variety of sources and then cleaning it up for you to use in your dashboards.

Power BI uses a second sister program called the Data Model to build Measures and KPIs, which are aggregate values based on your data. You’ll learn how to mold your data to get the value you need out of it.

What you might have called a chart or a graph in Microsoft Excel you’ll learn to call a visualization in Power BI. This program takes those charts to a whole new level and adds in exciting features like interactive infographics.

Nothing ever comes “off the rack” exactly the way you want it, and you’ll see that visualizations are no different. In this module we’ll look at how to customize the out of the box, and find the hidden tools that add polish to your Dashboard.

If math is not your strong suit then DAX can be a little bit challenging when you first encounter it. The concepts are really simple when you remember that DAX is designed to work with Tables of Data, columns and rows, and allows you to extract information using functions like Filter.

Special note to training coordinators: While this topic can be taught virtually and in shorter time lengths, it is highly recommended that you schedule this topic as 4-hour in-person training due to the complexity of the subject matter.

Two Different Modalities, Three Different Time Lengths