Course Outline
Module 1: Fundamentals
- Course structure and content
- Download: project files
- Introduction to the course project
- Important information about the course
Module 2: Getting Started with Power BI
- Overview of Power BI Desktop and its components
- Download, installation, and desktop settings
- Key settings and options
- Power BI Service and mobile app
Module 3: Connecting and modeling data in Power BI Desktop
- Data connectors in Power BI Desktop
- Query Editor (Power Query)
- Importing data from Excel and CSV
- Basic table transformations in Power BI Desktop
- Working with text tools
- Working with numeric tools
- Working with date and time tools
- Creating conditional and index columns
- Data grouping and aggregation
- Pivoting and unpivoting in Power BI
- Merging data in Power Query
- Appending data in Power Query
- Importing from a folder
- Modifying data sources and refreshing data
Module 4: Establishing relationships between tables and data models in Power BI Desktop
- Understanding Data Models
- Date and dimension tables
- Creating relationships between tables
- Managing and editing table relationships
- Relationship cardinality and filter flow
- Connecting multiple data tables
Module 5: Analyzing data with DAX calculations in Power BI
- Introduction to DAX (Data Analysis Expressions) + syntax
- DAX basics: Calculated columns
- DAX basics: Measures
- Filter context of measures
- DAX function categories
- Date and time functions
Module 6: Data visualization in Power BI
- Introduction to Report view
- Adding visuals in Power BI
- Visual formatting options
- Filtering options
- Exploring data with the Matrix visual
- Filtering data using slicers
- Displaying values using Card and KPI visuals
- Editing interactions between reports
Module 7: Power BI Service and integration with Teams
- Publishing reports from Power BI Desktop to Power BI Service
- Creating dashboards from published reports
- Sharing options with team members using Microsoft Teams
- Sharing and collaboration in Power BI Service
- Data export: Excel, PowerPoint, PDF
Requirements
Power BI Desktop 64-bit
Power BI Service or Power Pro license for module 7.
Testimonials (7)
The opportunity to learn new things The structure and how this training went.
VLAD DUMITRU-SORIN - Curs Public
Course - Power BI Basic
His ability to bring PowerBi technicity to something simple
Swann Dalbard - Curs Public
Course - Power BI Basic
It was an interactive course, with lots of useful information to help us create a report in Power BI from scratch. It managed to cover a lot of information from several "modules" of this complex application in a relatively short time (2 days). The trainer was very responsive and helped us resolve any issues that arose during the day in our reports. For me, this was the first online course with a trainer that I participated in, and I am surprised by the patience and professionalism he showed.
Catalina Vlad - Curs Public
Course - Power BI Basic
I liked the most that we can actually did in parallel the steps and this is the best way to learn something, by doing. Also, every time we had a question the trainer answered and provided the solution and also some tips & tricks. That was really great training!
Ana-Maria Sarboiu - Curs Public
Course - Power BI Basic
To understand the basic of Power BI.
Diana Netoiu - Curs Public
Course - Power BI Basic
I really liked how clearly and well‑structured the information was presented. The trainer made complex topics easy to understand
ioana popa - Curs Public
Course - Power BI Basic
availability and trainer support in solving everyone issues