Copyright © 2025 Intellus Design, All rights reserved. Created by Intellus Prime
Target Audience: Aspiring Data Analysts, BI Analysts, and Reporting Analysts.
Objective: Equip learners with the skills to transform raw data into insightful, interactive reports using Power BI, and support data-driven decision-making in a business environment.
Skills Covered: Data modeling, dashboard creation, DAX (Data Analysis Expressions), visualization techniques, and project implementation.
High Demand: Power BI is highly sought after in data-driven roles.
User-Friendly: Designed for both technical and non-technical users.
Career Growth: Prepares for roles like Data Analyst, BI Developer, etc.
Integration: Works seamlessly with Microsoft tools and third-party apps.
Cost-Effective: Powerful and affordable analytics solution.
| Day(s) | Topics | Details |
|---|---|---|
| Day 1–3 | Introduction, Installation, Architecture | Power BI basics, installation, and system architecture |
| Day 4–6 | Power BI Views, Power Query Editor, Data Extraction | Report/Data/Model Views; transforming data |
| Day 7–8 | Merge Queries | Types of joins: Right/Left/Inner/Full |
| Day 9–12 | Star Schema, Data Modeling, Relationships, Cardinality | Fact-dimension model, creating relationships |
| Day 13–17 | Visualization Techniques | Charts, tables, matrix, slicers, map visuals |
| Day 18–22 | Filters, Drill-through, Bookmarks, Buttons | Report customization and navigation |
| Day 23–24 | Dashboards | HR and Customer Analytics dashboards |
| Day 25–35 | DAX (Data Analysis Expressions) | Aggregate, Text, Date, Logical, Counting, Info functions |
| Day 36 | Report vs Dashboard | Key differences explained |
| Day 37–40 | Projects | Static & dynamic DAX-based projects, including a live project with Intellus Direct/Prime |
Project 1: DAX with static data.
Project 2: DAX with dynamic data using SQL.
Live Project: Real-time application in collaboration with Intellus.
Provided for further reading and reinforcement, especially for visualizations and DAX functions.
Hands-on approach with progressive learning from basic to advanced.
Industry-relevant tools and skills.
Strong emphasis on practical application via projects.
Incorporates official learning resources for reinforcement.
Copyright © 2025 Intellus Design, All rights reserved. Created by Intellus Prime