Interactive online course with mentors
Power BI for Analysts Course: Modeling, DAX & Dashboards
Move from simple reports to modern, scalable, decision-oriented analytics solutions.
- No unnecessary theory, applied to real-world scenarios
- 12 hours of LIVE training with mentors
- Bonus extra session: Applying Artificial Intelligence in Real Projects
Start date
Septembrie
Duration
6 weeks • 12 hours of training with mentors
Schedule
Tuesdays, 18:30–20:30
Format
Online, interactive, with mentors
Bonus
1 session: Applying Artificial Intelligence in Real Projects
Why take the Power BI course
- No unnecessary theory, applied to real-world scenarios.
- It helps you move from simple reports to modern, scalable, decision-oriented analytics solutions.
- It's aimed at intermediate-level people who already work with data or have used Power BI and want to strengthen their skills and deliver enterprise-level analytics solutions.
Recommended: basic SQL knowledge, a general understanding of fact and dimension concepts, plus minimal experience with data (Excel, reports, databases or Power BI).
What you get after completing the Power BI course
Essential practical skills
- You'll learn how to turn raw data into clear, interactive, decision-oriented reports and dashboards.
- You'll know how to build scalable data models, so reports stay functional and useful over time.
- You'll gain the ability to define relevant business metrics and robust KPIs, using DAX correctly and predictably.
- You'll learn to present information in a logical, convincing way for managers and non-technical stakeholders, supporting business decisions.
- The focus is on best practices and understanding the “why” behind every technical decision, so you can build robust solutions, not just reports that “look good.”
Skills needed in BI and Analytics projects
- You'll be able to deliver professional, production-ready analytics solutions.
- You'll gain a complete perspective on how business reports are designed, developed and delivered.
- You'll be able to apply what you've learned in real projects, meeting quality, performance and maintenance standards.
- You'll understand every technical decision and be able to build robust solutions.
- By the end of the course you'll have not only stronger technical skills, but also a professional BI mindset.
What will you learn in the Power BI for Analysts course?
6
modules
36
topics
01Module 1: Power BI Fundamentals & Analytics Mindset
- Goal: Understand how Power BI works under the hood and how it fits into a modern data stack.
- Power BI ecosystem: Desktop, Service, Gateway
- Import vs DirectQuery vs Live connection
- Power BI vs SQL vs Excel – roles and trade-offs
- Intro to VertiPaq engine (conceptual)
02Module 2: Data Preparation with Power Query (ETL Best Practices)
- Goal: Build clean, reusable, and performant datasets.
- Power Query vs DAX – separation of concerns
- Applied Steps & query folding
- Data types and performance impact
- Merge vs Append
- Naming conventions & ETL best practices
03Module 3: Data Modeling for Analytics
- Goal: Build scalable and maintainable data models.
- Star schema vs Snowflake
- Fact tables & Dimension tables
- Granularity
- Cardinality & relationship direction
- Active vs Inactive relationships
04Module 4: DAX Fundamentals
- Goal: Understand DAX logic instead of memorizing formulas.
- Measures vs Calculated Columns
- Row context vs Filter context
- CALCULATE – the core of DAX
- Variables (VAR)
- Debugging DAX
05Module 5: Business DAX & Time Intelligence
- Goal: Build real-world KPIs used in business reporting.
- CALCULATE with FILTER
- ALL / ALLEXCEPT
- Building a proper Date table
- YTD, MTD, YoY
- Rolling periods (e.g. Rolling 12 Months)
06Module 6: Data Visualization, UX & Delivery
- Goal: Create dashboards that are clear, interactive, and production-ready.
- Choosing the right visual
- Data storytelling principles
- Drill-down & Drill-through
- Tooltips, Bookmarks, Buttons
- Publishing to Power BI Service
- Refresh, sharing & RLS (overview)
Get a complete Power BI training package, with all the benefits included
- 12 hours of LIVE training and step-by-step guidance from mentors
- 6 technical modules focused on the requirements of major IT employers
- Bonus extra session: Applying Artificial Intelligence in Real Projects
- A 100% free knowledge assessment test before you start the course
- Lifetime access to the Informal School of IT community, where you get discounts, free invitations to top IT conferences, and other benefits
Upon completing the course you get a Diploma issued by Educație Informală SA, recognized by employers.
Everything is included in the price of the Power BI for Analysts course
Total course price239€
Recommended
Full payment
299 €
Payment with 5% discount
5% discount
If you enroll together with a friend, you both get a 5% discount off the total course price. Both of you should mention it in the enrollment form's Notes field: [full name of the friend you're enrolling with].
BCR Study UP education credit
Courses at the Informal School of IT are eligible for Study UP financing. No income required at the time of assessment, no co-borrower, no collateral.
Your investment in education: risk-free. You don't have to pay anything now. All you need to do is fill in the enrollment form. Afterwards, you get a free initial assessment of your knowledge level, to make sure this course is right for you and your goals.
Payment is made only after signing the enrollment contract, once you decide you want to move forward. It's simple, transparent, and with no upfront financial obligations. Our goal is for YOU to reach your goals.
Who mentors you step by step in this course
Bogdan Bindea
Software Engineer @ Bosch · Teaching Assistant @ Technical University of Cluj-Napoca
Who takes the Power BI for Analysts course
Analysts and professionals who work with data
- Data Analysts
- Business Analysts
- Financial / Controlling Analysts
People who use data in their daily work and want to:
- move from static reports to interactive dashboards
- properly understand data modeling and DAX measures
- deliver clear reports for decision-makers
Professionals who use Excel
- Advanced Excel users
- People who build recurring reports in Excel
The course helps with:
- migrating from Excel to Power BI
- automating and standardizing reports
- working with larger volumes of data
Professionals in BI and Data roles (junior – mid)
- BI Analysts / BI Developers
- Reporting Specialists
- Data professionals just starting out
For those who:
- have basic experience with Power BI
- want to strengthen their modeling and DAX skills
- want to understand performance best practices
Professionals with SQL experience
- SQL Developers
- Data Engineers (junior / mid)
The course is ideal for those who:
- know SQL and database structure
- want to understand how data is consumed in Power BI
- want to build efficient analytics models
What benefits the Power BI course from the Informal School of IT brings you
- You turn data into clear results, which helps you create reports that support business decisions.
- You build scalable, efficient BI solutions, using data models and DAX for robust reports that are easy to integrate into the business.
- You present results in a structured, convincing way, so your dashboards and reports are easy for managers and non-technical stakeholders to understand.
- You gain an efficient way of working that helps you make informed technical decisions, based on the best practices you've learned.
- You follow a progressively structured, practice-focused program that helps you integrate everything you've learned directly into your projects.
- You learn directly from experienced mentors, applying step by step the methods and practices used at major companies.
- You're ready to actively contribute to Business Intelligence or Analytics projects, gaining a competitive edge.
- You gain a complete perspective on how modern business reports are designed and delivered, working in a structured, results-oriented way, in real contexts.
Our graduates work at the biggest IT companies
Power BI for Analysts: Modeling, DAX & Dashboards
Enroll in the course
Your investment in education: risk-free. You don't have to pay anything now. All you need to do is fill in the enrollment form. Afterwards, you get a free initial assessment of your knowledge level, to make sure this course is right for you and your goals.
Payment is made only after signing the enrollment contract, once you decide you want to move forward. It's simple, transparent, and with no upfront financial obligations. Our goal is for YOU to reach your goals.
- 1Fill in the form — it takes a minute, no payment.
- 2A counsellor calls you: free initial assessment and career advice.
- 3Sign the contract and pay in full or in interest-free instalments.
Power BI for Analysts: Modeling, DAX & Dashboards