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.
Training at a glance
Level
Beginner
Duration
3 Days
Experience
0 year: Power BI Dashboard
Average Salary
$109,029
Labs
Yes
Level
Beginner
Duration
3 Days
Experience
0 year: Power BI Dashboard
Average Salary
$109,029
Labs
Yes
Training Details
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
- Visual analysis and visual analytics
- Power BI Infrastructure
- Loading Data
- Introduction to Power BI Desktop
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
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
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
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
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
- BI and reporting professionals
- Data analysts
- Data professionals
There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.
Upcoming Classes
We offer more than just Microsoft Training
Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.
Strategic Planning & Project Management
From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
IT & Cybersecurity
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Leadership & Management
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.
