Advanced Data Modeling
- Start: Mar 24, 2025 9:00 AM EDT
- End: Mar 24, 2025 5:00 PM EDT
- Cost: $745.00
- Instructor: Angelica Choo Quan
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
Event description
Welcome to our Advanced Power BI Data Modeling Bootcamp, an intensive day class designed to elevate your data modeling skills to new heights. In this immersive full-day learning experience, you'll delve deeper than ever before into the world of Power BI and Data Modeling. Our expert instructors will guide you through advanced data modeling techniques, transforming raw data into a meaningful scheme. You'll master the intricacies of relationships, DAX (Data Analysis Expressions) functions for modeling which will enable you to create dynamic and interactive dashboards. Through hands-on exercises and a real-world case studies, you'll gain advanced knowledge in optimizing data models for performance and efficiency. Collaborative learning environments and peer interactions will enhance your problem-solving skills, ensuring you leave equipped with the expertise to tackle complex business challenges confidently. Join us on this transformative journey and unlock the full potential of your data modeling capabilities.
Prerequisites
This class is targeted for advanced power users or end-users looking to enhance their skills in Power BI and in general Data Modeling. Because this class is focused on self-service end-user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have an intermediate understanding of database terminology such as tables, views, columns, rows, etc.
System Requirements
- Windows 10, Windows 7, Windows 8
- Microsoft Power BI Desktop requires Internet Explorer 10 or greater
- Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
- Power BI Desktop [https://aka.ms/pbiSingleInstaller](https://aka.ms/pbiSingleInstaller)
Course Outline:
- Module 01- Conceptual Modeling
- Building a Conceptual Data Modeling
- Module 02 – Fact and Dimensional Modeling on Raw Form-Data
- Advanced Column Transformations for proper Data Model Creation
- Module 03 – Navigating Direct-Query Connections
- Direct-Query through SQL Data Source Connection
- Dual Connections and Import Connections
- Module 04 – Building the Aggregate Table
- Enhancing Model Performance through Aggregate Tables
- Module 05 – Understanding Relationships
- Directional Filtering and Cardinality Crackdown
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Advanced Data Modeling (Mar 24, 2025 – 3/24/25) | $745.00 | |
Add an event to your calendar
Instructor – Angelica Choo Quan
Shortly after graduating from the University of Florida in 2012, Angelica moved to Jacksonville and began her career as a high school Biology teacher. As a trainer at Pragmatic Works, her primary goal is to help individuals feel more comfortable and confident using Power BI. While not in the office, she enjoys traveling around the city of Jax to check out local eateries, live music events, and performing arts.