Ήσ°ω΄Η³ΎΜύ
$250 β $995
Class Requirements
Before attending, please ensure the following:
Are your usual pie charts getting yawns in meetings? Power BI, like its competitor Tableau, is Microsoftβs software for building sophisticated βdata visualizationsβ: elegant and often interactive graphical representations of your data β beyond what you can find in Excel or even Crystal Reports. In this class weβll show you how to navigate the software so you can build and publish the kind of data-based reports that will get the office talking.
Prepping Data. After weβve shown you the basic navigation and main areas of Power BI, weβll cover how to import your data and clean it up. You can get data from multiple sources: Excel, SQL Server, XML and online services like Azure and Google Analytics. You can even combine tables from different sources by designating βjoinβ relationships between them. Along the way weβll show you how to set cleanup rules for any messiness in your imported data.
Different Visualizations. Once your data is ready, youβll learn how to create stunning visualizations from it: bubble charts, heat maps, geographic shape maps, and more. Youβll learn how to publish them as standalone documents to bring to your next meeting.
Extending Data. In addition to simple data cleanup, Power BI offers tools to shape and combine data, including Power Query and Data Analysis Expressions (DAX), a toolkit of functions and formulas to return calculated values. This lets you incorporate key business summary data into your visualizations.
Publishing Options. Once your visualization is perfected, you can share it with others online by posting it to Office 365 or the Power BI mobile app. Youβll also learn how to embed reports into web pages, or post them to SharePoint or MS Teams. Finally, weβll show you how to build interactive dashboard reports to combine your different data visualizations.
Module 1:
Getting Started with Power BI
Module 2:
Preparing & Transforming Data with Power Query
Thank you so much for this training. Joe was a great instructor - very knowledgeable and very easy to follow along with. I specifically appreciated how much he related the application of various tools to real world scenarios when we posed questions to him.
Mo was a great instructor! He really listened to the needs of the class and worked hard to answer all questions fully and with great examples.
Good foundation for all the main/basic functions. Power BI is less daunting. Better understanding of what it can do and what it's compatible with. Mo did a great job with the pacing and explanation of the course material. He was very helpful in answering specific questions that catered to each of our current professional positions.
