Posts filed under Data Modeling

(Livestream Replay) How to Aggregate Large Datasets in Power BI - with Tristan Malherbe

In this session, Tristan Malherbe (Microsoft Data Platform MVP) will show you how you can leverage Power BI aggregations to analyze big volumes of data in Power BI. Tristan will illustrate the power of Aggregations with the famous New York City Taxi dataset.

GUEST BIO 👤

Tristan Malherbe is the Founder of Data Pulse and a Microsoft Data Platform MVP since 2017. He is also the co-founder and current co-leader of the French Power BI User Group in France (Club Power BI). His favorite topics are: advanced data modelling, DAX, Data Visualization & performance tuning.

RELATED CONTENT 🔗

Tristan's LinkedIn
Tristan's Twitter
Tristan's YouTube

Posted on November 2, 2021 by Reid Havens and filed under Livestreams, Data Modeling and tagged Aggregations Large Datasets Data Modeling.

Implementing Different Date Table Hierarchy Types in Power BI

Video by: Reid Havens

Learn about two primary Hierarchy types you can implement on a Date Table in Power BI. I consider it a best practice to include dependent and independent date hierarchies, which can impact how users want to navigate the hierarchy controls in visuals.

Posted on August 31, 2021 by Reid Havens and filed under Beginner, Data Modeling and tagged Visualizations Date Table Hierarchies.

Creating a Composite Model Against a Power BI Dataset

Video by: Reid Havens

Learn how to create a composite model against a Power BI dataset, also known as (DirectQuery for Power BI datasets and Azure Analysis Services) or DQFPBIDAAS for short. 😅

Composite Models against a Power BI Dataset allows you to import tables from other data sources and combine it with your Power BI dataset.

RELATED CONTENT 🔗

Splitting a Report & Model
DirectQuery for Power BI datasets and Azure Analysis Services

Posted on July 27, 2021 by Reid Havens and filed under Power BI, Intermediate, Data Modeling and tagged Golden Dataset Composite Models Direct Query Data Modeling.

(Livestream Replay) All About DAX.do - with Marco Russo

DAX.do is an online service to play with DAX using just a web browser. DAX.do is mainly a learning tool, but it is also a way to share DAX code and quickly test a DAX expression with a standard sample model (Contoso). If you have any questions about DAX.do, or want to know more about why it exists and the architecture behind it, join this live session with Marco Russo, one of the DAX.do authors. In preparation for the live event, you can also watch the DAX.do – Behind the scenes video at the link below!

RELATED CONTENT 🔗

DAX.do Video
SQLBI Website
Marco's Twitter

Posted on June 24, 2021 by Reid Havens and filed under Livestreams, Performance/Optimization, DAX, Data Modeling and tagged Intermediate DAX Relationships Best Practices.