The Power BI course at Arbor Academy is designed for professionals and students aiming to develop data visualization and reporting skills. It focuses on using Power BI Desktop and Power BI Service to transform raw data into meaningful business insights. Whether you're in finance, sales, HR, or IT, this course helps you build powerful dashboards and reports that support decision-making in real time.
Power BI is one of the most in-demand tools for data-driven roles today. This course teaches you to connect various data sources, clean and shape data using Power Query, build data models using DAX (Data Analysis Expressions), and design fully interactive dashboards and KPIs.
The course is focused on practical implementation, not just theory. You’ll work with datasets from sales, HR, finance, and operations domains. You will also learn how to publish reports to the Power BI Cloud Service and share insights via apps, workspaces, and secure permissions. Ideal for those who want to grow in analytics or reporting without learning to code.
By the end of the Power BI course, you will:
- No coding knowledge required.
- Basic Excel skills are helpful (functions, pivot tables, charts).
- Familiarity with business operations or KPIs is a plus.
Power BI Overview & Setup
What is Power BI?
Overview of Power BI
Architecture of Power BI
Power BI Plans
Installation and Introduction
Data Transformation in Power BI Desktop
Importing Data
Data Types in Power BI
Basic Transformations
Managing Query Groups
Splitting Columns
Changing Data Types
Working with Dates
Removing and Reordering Columns
Conditional Columns
Custom Columns
Connecting to Files in a Folder
Merge Queries
Query Dependency View
Transforming Less Structured Data
Query Parameters
Column Profiling
Query Performance Analytics
Data Modeling
Data Cardinality and Data Relationships
Creating and Managing Hierarchies
Calculated Tables
DAX (Data Analysis Expressions)
What is DAX?
How to Write DAX
Types of Functions in DAX
Creating Calculated Measures
DAX Applications
Visualizing Your Data
Pie and Doughnut Charts
Treemap
Combo Chart (Bar with Line)
Filters (Including TopN)
Slicer
Focus Mode and See Data
Table and Matrix
Gauge, Card, and KPI
Coloring Charts
Shapes, Textboxes, and Images
Gridlines and Snap to Grid
Custom Power BI Visuals
Tooltips and Drilldown
Advanced Visualization
Page Layout and Formatting
Visual Relationship
Maps
Python and R Integration
Analytics Pane
Bookmarks and Navigation
Selection Pane
Power BI Dashboards and Sharing
Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Dashboard Settings
Q&A and Featured Questions
Sharing a Dashboard
In-Focus Mode
Row-Level Security
Summary
Power BI is ideal for: