6 Hour Live Training on Microsoft Power BI Desktop
Training TypeLive Training
About the Course
Many people think Power BI is for advanced developers. In truth, Power BI was created by combining the best features from Microsoft Excel, Access, SQL and other related technologies. Moreover, Power BI fills in the capability gaps that exist across these technologies, streamlining the process from data to insights. In this session, we’ll transition from what you know about these technologies and show you how Power BI solves the same problems more efficiently. To give you a true understanding of what Power BI can do, we’ll use Power Query to query data, Power BI’s data model to connect datasets, and Power BI’s report view to create compelling dashboards and data visualizations.
Using case studies that bring together multiple capabilities at once, expert Jordan Goldmeier shows you how to easily create measures to find SUM, COUNT, MAX, and more with a click of a button; make the best use of the mysterious filter context; and use Power BI’s DAX language to power your data visualizations. You’ll also get tips on which Power BI experts to follow to gain the knowledge that will transform you into an expert at your workplace.
How to start using Power BI right away to build reports from data in your workplace
How Power BI can save you time and effort
The importance of data visualization in storytelling and how Power BI can help you to accomplish this task
How to use measures to easily model things like year-over-year cash flows and the total counts of transaction per region
The CALCULATE() function (You’ll probably end up using it for most measures you want to calculate.)
How the filter context controls how data flows your report—and how you can make of this data flow.
Connect multiple data sources into a relational data model
Identify where and how Power BI can be best used in your organization to solve pressing data issues
Create multiple reports in Power BI to tell a story of your company’s performance
Create a measure on the fly to solve the vast majority of business problems
Keep your measures organized so that you know what they do and how they work
Quickly create time intelligence reports with things like year-over-year comparisons, saving you hours as compared to how you might do it in Excel
Who is the Target Audience?
Business professionals, from junior level to middle manager in the fields of consulting, finance, banking, energy, and retail. They are likely familiar with Microsoft Excel (and use it often in their jobs) even if they aren’t experts at it. They usually have the following titles: business analyst, IT analyst, financial analyst, project manager, program manager, consultant, and business intelligence analyst to name a few.
None required to start with, but a bit of even Excel knowledge helps!
|12 Aug 2021||Thu- Fri (2 Day)||01:00 PM - 04:00 PM (Eastern Time)|
|15 Sep 2021||Wed - Thu (2 Day)||01:00 PM - 04:00 PM (Eastern Time)|
Class Introduction / Course Outcomes
- What is Power BI Desktop?
- Demo 1: First Report
- Formatting the data with Power Query, Creating a Power BI Report using, Map Visualization, Slicers, Bar / Column Visuals
- Introduction to the Data Model
- Demo 2: Connecting Datasets
- Power Query Connections, Data Models, Filter Context
- Demo 3: Visualizations provided by Power BI
- Best Practices, Maps, Slicers, Matrix / Table, Tree Maps, Column / Bar / Area Charts, Geographic Visuals, Custom
- What is DAX?
- Implied vs Explicit Measures
- Demo 4: Calculated Columns
- Best Practices, CALCULATE, SUMX, RELATED, VAR/RETURN, Keeping Organized
- Demo 5: YoY and MoM Analysis Dashboard
- Best Practices, SAMEPERIODLASTYEAR, PARALLELPERIOD