Dimensional Data Modeling at SQL Sat South Florida 2024

Date/Time
Date(s) - June 29, 2024
All Day

Location
NSU - Nova Southeastern University

Categories


REGISTER HERE

Exciting news! SQL Saturday South Florida 2024 is back and  we will be participating again ! Founder Cecilia Brusatori will be presenting “Dimensional Data Modeling 101”

 

SQL Saturday is a training event for SQL Server and data professionals who want to learn how to elevate their careers to the next level.

FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their skill set in Business Intelligence, Analytics, and SQL Server.

Session: Dimensional Data Modeling 101

Power BI works at its best when Data Model is based on Star Schemas achieved applying Dimensional Data Modeling practices. In my experience as a Data Consultant and a Trainer, I find that one of the biggest struggles Power BI Professionals face, is having a bad Data Model design, which then leads to: bad performance, incorrect results displaying, complex (sometimes considered impossible) DAX calculations to be used, and a Data Model that ends up not being clear nor scalable.

If you are completely new or just starting with Dimensional Data Modeling for Power BI, this session is for you! We will focus on basic concepts and terminologies, building a Star Schema Design from scratch and finally applying the Design using Power BI Desktop and Power Query.