Course Outline
Module 1: Foundations
- Course structure and content
- Download: project files
- Introduction to the course project
- Key course information
Module 2: Overview of Microsoft Power BI
- Introducing Power BI Desktop and its components
- Downloading, installing, and configuring Power BI Desktop
- Essential settings and options
- Power BI Service and the mobile application
Module 3: Data Connection and Modeling in Microsoft Power BI Desktop
- Data connector types in Power BI Desktop
- Query Editor (Power Query)
- Importing data from Excel and CSV
- Basic table transformations in Power BI Desktop
- Utilizing TEXT type tools
- Utilizing NUMERIC type tools
- Working with DATE and TIME functions
- Creating conditional and index-based 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 Table Relationships and Data Models in Power BI Desktop
- Understanding the Data Model
- DATE type tables and DIMENSION type tables
- Creating relationships between tables
- Managing and editing table relationships
- Relationship cardinality and filter direction
- Connecting multiple DATA type tables
Module 5: Data Analysis Using DAX in Power BI
- Introduction to DAX (Data Analysis Expressions) and syntax
- DAX basics – Calculated Columns
- DAX basics – Measures
- Understanding measure filter context
- Categories of DAX functions
- Date and Time functions
Module 6: Data Visualization in Power BI
- Introduction to "Report" Mode
- Adding visuals to Power BI
- Visual formatting options
- Filtering capabilities
- Data exploration using the Matrix visual
- Data filtering with Slicers
- Displaying values with Card and KPI visuals
- Configuring interactions between report visuals
Module 7: Power BI Service and Microsoft Teams Integration
- Publishing reports from Power BI Desktop to Power BI Service
- Building dashboards from published reports
- Sharing options with team members via Microsoft Teams
- Collaboration and sharing in Power BI Service
- Exporting data to Excel, PowerPoint, and PDF
Requirements
Power BI Desktop 64-bit
A Power BI Service or Power BI Pro license is required for Module 7.
Testimonials (7)
That it takes time and practice to get accustomed to the new information. Now I also have a better idea on what to request, as I have understood the logics behind the end product.
Cosmin-Alexandru Zerfas - DARWIN TECHNOLOGIES
Course - Power BI Basic
The most valuable takeaway was gaining a better understanding of Power Query, data modeling, DAX basics, and learning how these components work together to build Power BI reports.
Horozova Olga - Unicredit
Course - Power BI Basic
Understanding data model and how to create measure.
Daniela Beres - Unicredit
Course - Power BI Basic
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!
