Power BI The Data Model
This virtual course is designed to introduce participants to the gain further understanding in POWER BI by Understanding the Data Model, and how it relates to effective analysis in Power BI. Included in this course are Data Normalisation concepts, Purpose of Dimension and Fact Tables, Use of Primary and Foreign Keys, and Creating Table Relationships, then adding Visual from related tables.
Snapshot
Duration: 90 minute
Level: Intermediate
Pre-requisites: It is strongly recommended that the student first attend the Power BI Fundamentals course, it will also be advantageous to have a good understanding of Excel Charts and the Basic Functions (SUM, AVERAGE)
Software Requirements: Ensure that Power BI Desktop be installed on your computer, and updated to the latest version. For further information please go to: https://powerbi.microsoft.com/en-au/desktop/
Subjects covered
- Overview of the Data Model in Power BI
- Data Normalisation
- Dimension vs Fact Tables
- Using Primary and Foreign Keys
- Create & Manage Table Relationships
- Star & Snowflake Schemas
- Hiding Table Fields
- Create Visuals from Related Tables
- Create Simple Calculations in Power BI
Upcoming Sessions
| Date | Time (AEDT) | Location | Available Spaces | Cost | ||
| 7 May 2024 | 09:30 am - 11:00 am | Online | 5 | $195.00 | ||
| 15 May 2024 | 02:30 pm - 04:00 pm | Online | 5 | $195.00 | ||
| 5 June 2024 | 12:00 pm - 01:30 pm | Online | 5 | $195.00 | ||
| 17 June 2024 | 09:30 am - 11:00 am | Online | 5 | $195.00 |
Need a scalable, cost-effective solution to team training?
Try our Live Virtual Class Subscription. Access over 60 different training modules from just $10 per seat! Try it free for one month for you and one employee.