Introduction to Power BI Training
The Power BI Course is designed to introduce complete beginners to the world of data analysis and visualization using Microsoft Power BI. Whether you're a student, a professional looking to upskill, or someone interested in the world of data analysis, this course is a perfect starting point.
Power BI Training
Course Overview
It discusses in depth the industry- recognized steps from raw data to detailed analysis via five main stages:
- Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
- Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
- Creating and extending a comprehensive data model with DAX
- Visualizing data in Power BI desktop using built-in tools
- Sharing and collaborating with the Power BI service or Power BI server
Course Outline
- Chapter 1: Power BI Overview
- Visual analysis and visual analytics
- Power BI Infrastructure
- Loading Data
- Introduction to Power BI Desktop
- Hands-On Exercise 1.1 Loading and Visualizing data
- Chapter 2: Transforming Data
- Using Power Query to clean, transform and load data
- Profiling your data
- Resolve data quality issues
- Apply user-friendly names to Queries, tables, and columns
- Import data from an Excel formatted report
- Hands-On Exercise 2.1 Transforming Data with Power Query
- Hands-On Exercise 2.2 Appending, Merging, and Combining Queries
- Chapter 3: Creating a Data Model
- Understand the role of the Data Model in Power BI
- Create table relationships
- Understand Cardinality and Cross Filtering
- Discuss Star and Snowflake schema
- Create a Date Dimension
- Build a Data Model from multiple Data sources
- Hands-On Exercise 3.1 Creating a Data Model
- Chapter 4: Visualizing your Data
- Discuss Report settings
- Choosing the right visualizations
- Creating, formatting, and styling your reports
- Using Hierarchies and Drilldown
- Utilizing Slicers and Filters
- Adding Custom Visualizations
- Hands-On Exercise 4.1 Creating Reports Part 1
- Hands-On Exercise 4.2 Creating Reports Part 2
- Hands-On Exercise 4.3 Creating Reports Part 3
- Chapter 5: Introduction to DAX, Calculated Columns and Measures
- Gain an Introduction to DAX
- Differentiate between Calculated Columns and Measures
- Create Calculated Columns
- Create Measures
- Understand Filter and Row context
- Understand the power of the Calculate function
- Hands-on Exercise 5.1 Introduction to DAX
- Optional Hands-on Exercise 5.2 Intermediate Level DAX
- Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)
- Discuss the Power BI Service and Power BI Server
- Understand the main components of the Power BI Service
- Publish a Power BI Project to the Power BI Service
- Share Reports
- Build and Share Dashboards
- Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service
Intended Audience
- BI and reporting professionals
- Data analysts
- Data professionals
Prerequisites
There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.
Follow-On Courses
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Data Analytics & Databases training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, Introduction to Power BI Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
The Power BI Course is designed to introduce complete beginners to the world of data analysis and visualization using Microsoft Power BI. Whether you're a student, a professional looking to upskill, or someone interested in the world of data analysis, this course is a perfect starting point. Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners; the course is hands-on with virtual labs and a learn-by-doing methodology.
Course Objectives
Once I've completed the course, I'll have hands-on, job-ready skills in data analytics & databases that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in data analytics & databases. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/introduction-to-power-bi/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.