Power Bi

Course Overview

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.

Description

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.

Course Objectives

By the end of the Power BI course, you will:

  1. Connect data from Excel, SQL Server, and Web APIs
  2. Clean, transform, and shape data using Power Query Editor
  3. Build dynamic dashboards with slicers, filters, and custom visuals
  4. Use DAX to create calculated columns, measures, and KPIs
  5. Create relationships between tables using Star Schema modeling
  6. Publish reports to Power BI Service and schedule data refreshes
  7. Design executive-level dashboards for real-time monitoring
  8. Add your dashboard projects to your resume and portfolio

Prerequisites

- No coding knowledge required.
- Basic Excel skills are helpful (functions, pivot tables, charts).
- Familiarity with business operations or KPIs is a plus.

Course Curriculum

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

  • Introduction to Python
  • Data Preprocessing
  • Python Packages
  • Pandas: Series, DataFrames
  • Numpy: Arrays, Memory, Matrices

  • What is a Database?
  • Types of Databases
  • DBMS vs RDBMS
  • DBMS Architecture
  • Normalization & Denormalization
  • Installing PostgreSQL
  • Database Models
  • DBMS Language
Who can learn this course

Power BI is ideal for:

  • Working professionals in finance, HR, marketing, sales, or operations
  • MIS executives, reporting analysts, or dashboard designers
  • Non-tech users transitioning into analytics or BI roles
  • Students pursuing careers in data and business analytics
  • Managers and team leads who want better control over their data

Training Features
Comprehensive Curriculum

Master web development with a full-stack curriculum covering front-end, back-end, databases, and more.

...

Hands-On Projects

Apply skills to real-world projects for practical experience and enhanced learning.

...

Expert Instructors

Learn from industry experts for insights and guidance in full-stack development.

...

Job Placement Assistance

Access job placement assistance for career support and employer connections.

...

Certification upon Completion

Receive a recognized certification validating your full-stack development skills.

...

24/7 Support

Access round-the-clock support for immediate assistance, ensuring a seamless learning journey.

...