#powerbi #pavanlalwani #datamodelling

Use Coupon Code "FLAT50" for a discount on the new Power BI Specialization course

https://learn.pavanlalwani.com/course...

In this mindbending video, prepare to journey into the realm of data modelling within Power BI. The presenter unveils the magical art of creating interdimensional bridges between data tables, allowing them to communicate and collaborate in ways you've never imagined. ✨ This enchanting process utilizes the mystical Power Pivot and the incantations of DAX (Data Analysis Expressions) to weave together these data tapestries.

Venturing into their personal chronicle, the presenter recalls the initial trepidation triggered by the enigmatic term "data modelling." However, they quickly unravel the mystery, revealing it to be a simple concept. It's like orchestrating a grand symphony where various tables, whether born from the same data galaxy or disparate sources, unite to create harmonious insights.

The video transitions into a cosmic dance between Power Pivot in Power BI and its earlier manifestation in Excel. Over the epochs of 1213 years, Power Pivot lay dormant in Excel's catacombs, awaiting its grand awakening in the age of Power BI. ⏳

Behold as the presenter guides you through an arcane ritual, showcasing the magic within Excel. With Power Pivot as their wand, they conjure relationships between data tables without ever breaching the veil of the files or altering data sources. Like a wizard's incantation, the common columns forge unbreakable bonds between tables. The presenter then unravels a scrying technique called a pivot table to unveil insights from this ethereal connection.

Emerging from the mystical realm of Excel, the presenter ushers us into the boundless universe of Power BI. Power Pivot's essence intertwines with the very fabric of Power BI, making the two inseparable. In this extraordinary convergence, Power Query and Power Pivot intertwine, unveiling an alchemical fusion.

Witness as the presenter invokes their conjuring once more, this time within Power BI. They summon three distinct entities – Excel files and CSV files – and harness their energies into the realm of Power BI. Without opening the files or altering their essence, the presenter forges connections between tables like cosmic ley lines. These interactions birth an astonishing visualization within the report view, a testament to the power of these arcane arts.

As the tale draws to a close, the presenter illuminates the extraordinary familiarity between Power Pivot's incarnations. A hidden lineage unites Excel's ancient incarnation with Power BI's modern manifestation, a secret lineage unveiled. The presenter leaves you with an enchanting truth: data modelling is a voyage that defies complexity, inviting you to unlock its wonders for a new era of data analysis.

Introduction to Data Modeling in Power BI
0:00 Introduction
0:16 Data Modeling Concept
1:49 Exploring Power Pivot in Excel
3:57 Discovering Data Modeling in Excel
6:12 Applying Data Modeling to Multiple Data Sources
8:19 Transitioning to Power BI
8:56 Using Power Pivot in Power BI
10:07 Understanding Data Views in Power BI
12:06 Creating Relationships in Power BI
13:50 Harnessing the Power of Data Model Relationships
14:34 Simplifying Complex Tasks with Data Modeling
16:19 Comparing Power Pivot in Excel and Power BI
18:04 Embracing the Magic of Data Modeling
18:49 Conclusion and Takeaways