6 Hour Live Training on Let’s Get Running with Microsoft Power BI Desktop
-
Training TypeLive Training
-
CategoryMS Excel
-
Duration6 Hours
-
Rating4.9/5
Course Introduction
About the Course
Why would you want to learn Microsoft Power BI? It’s a business intelligence application that bridges the gap between the traditional database and IT silos and the business and financial analysis performed by wider departments across the organization. Using Power BI enables this wider audience to do their own analysis of data. But to get there, they need to figure out the best ways to query the necessary datasets using ETL frameworks, and then perform additional calculations and create new queries in the semantic layer by leveraging the Power Query Editor. If you’ve never heard of Power Query, it’s not only immensely useful in Power BI, but you can take these skills and even the queries and transfer them directly into your work in Excel, which you can’t do with applications like Tableau. Once you load the data, you can create dashboards and reports to analyze and present visual representations of these datasets. Examples of these elements include leveraging various visual types that best illustrate data trends to monitor, analyze, and make decisions with this data. Over three sessions of two hours apiece, this training will cover the skills you need to get update a running with Power BI and leave you wanting to learn more about even more ways you can leverage the application.
Course Objective
Getting the data using the Power Query Editor
Analyzing data and creating calculations initially in tables
Exploring visualization options and their formatting
Who is the Target Audience?
Introductory Power BI students
Basic Knowledge:
None required to start with, but a bit of even Excel knowledge helps!
Available Batches
| 24 May 2021 | Mon - Wed (3 Day) | 01:00 PM - 03:00 PM (ET) |
Pricing
-
Introducing Power BI capabilities
Overviewing Power BI components
Exploring the ETL framework
Working with different data types
Extracting data from data sources
Exploring transformation options
Changing data types
Adding columns to data tables
Grouping and aggregating by dimensions
Unpivoting data tables
Loading data into Power BI
-
Overviewing the Data, Model, and Report parts of the Power BI interface
Joining data tables together to create schemas in the Model view
Filtering in the Data view
Introducing the Power BI canvas in the Report view
Exploring the Fields and Visualizations panels and the top ribbon
Creating table and matrix visuals
Changing formatting for data fields
Determining aggregations to use
Adding card visuals
Analyzing KPI metrics
Creating quick measure calculations
-
Exploring different visual types
Determining questions that business users will potentially ask
Analyzing how to answer these questions with visual solutions
Changing visual types
Swapping out fields in visual
Adding filters to visuals, pages, and reports
Placing visuals impactfully
Exploring some visualization best practices
Interacting and changing views between visuals
Sharing your work