In this introductory Fabric Data Warehouses course you’ll learn how these specialized data systems bring together information from different sources, allowing organizations to make more confident business decisions. Along the way, you’ll gain insight into why data warehouses are essential for dealing with large amounts of data, as well as how they help streamline analytics and reporting tasks. By the end of the course, you’ll be equipped with a high-level understanding of the core principles behind setting up and managing a Fabric Data Warehouse. We’ll talk through how data moves in and out of these systems, the key roles and responsibilities involved, and best practices for ensuring smooth operations. Whether you’re new to data warehousing or looking for a friendly introduction, this course will give you a solid overview of the building blocks needed to excel in today’s data-driven environments.
Overview
COURSE DIFFICULTY
COURSE DURATION
5h 13m
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
Apply time intelligence functions for date-based analysis
Build interactive dashboards and reports in Power BI
BI Developers, Data Analysts, Data Engineers, Excel Power Users
None
01. What you need to get started - Intermediate Power BI
02. Getting Started
03. Transforming Data (Appending Queries)
04. Transforming Data (Combine Files)
05. Transforming Data (Merging Queries)
06. Transforming Data (Writing Basic M)
07. Transforming Data (Parameters and Templates)
08. Transforming Data (Usability Features)
09. Transforming Data (Direct Query)
10. Creating the Data Model
11. Creating Calculated Columns and Tables (Navigation Functions)
12. Creating Calculated Columns and Tables (Calculated Tables)
13. Creating Calculated Measures (Time intelligence Functions)
14. Additional Model Enhancements
15. Advanced Visual Options
16. Creating Interactive Reports (Power BI AI Capabilities)
17. Creating Interactive Reports (Data Storytelling)
18. Using the Power BI Service (Subscriptions and Alerts)
19. Using the Power BI Service (Excel Integration)
20. Using the Power BI Service (Export and Embed Options)
21. Using the Power BI Service (Dataflows and Datamarts)
22. Using the Power BI Service (Paginated Reports)
23. Using the Power BI Service (Data Modeling in the Service)
24. Refreshing the Data
25. Class Outro
26. Transforming Data (More Query Parameters)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
Apply time intelligence functions for date-based analysis
Build interactive dashboards and reports in Power BI
WHO SHOULD ATTEND
BI Developers, Data Analysts, Data Engineers, Excel Power Users
PREREQUISITES
None
COURSE OUTLINE
01. What you need to get started - Intermediate Power BI
02. Getting Started
03. Transforming Data (Appending Queries)
04. Transforming Data (Combine Files)
05. Transforming Data (Merging Queries)
06. Transforming Data (Writing Basic M)
07. Transforming Data (Parameters and Templates)
08. Transforming Data (Usability Features)
09. Transforming Data (Direct Query)
10. Creating the Data Model
11. Creating Calculated Columns and Tables (Navigation Functions)
12. Creating Calculated Columns and Tables (Calculated Tables)
13. Creating Calculated Measures (Time intelligence Functions)
14. Additional Model Enhancements
15. Advanced Visual Options
16. Creating Interactive Reports (Power BI AI Capabilities)
17. Creating Interactive Reports (Data Storytelling)
18. Using the Power BI Service (Subscriptions and Alerts)
19. Using the Power BI Service (Excel Integration)
20. Using the Power BI Service (Export and Embed Options)
21. Using the Power BI Service (Dataflows and Datamarts)
22. Using the Power BI Service (Paginated Reports)
23. Using the Power BI Service (Data Modeling in the Service)
24. Refreshing the Data
25. Class Outro
26. Transforming Data (More Query Parameters)
