10 Million Rows of data Analyzed using Excel's Data Model
Wyn Hopkins
Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views
The Excel Data Model (also referred to as Power Pivot) can handle millions of rows of data and can replace the need for millions of LOOKUP formulas
Content:
00:00 Intro
00:42 Using Power Query to Consolidate files from a Folder
03:40 Changing Data Types to reduce the file size and improve performance
05:40 Recommend 64 Bit Excel
05:50 The Data Model and creating relationships - avoiding100 Million Formulas!
07:00 Creating a Pivot Table / Pivot Chart
07:45 Adding a Slicer
08:06 Presenting the data in a 3D Map / Globe visual.
Here's a link to the files I used
Subscribe to our YouTube Channel
Connect with me on
LinkedIn https://www.dhirubhai.net/in/wynhopkins/
Twitter https://twitter.com/wynhopkins
Follow our blog here... https://accessanalytic.com.au/blog/
Check out our training
https://accessanalytic.com.au/training
Wyn
Data-driven CEO @ Carlo Solutions LLC | Microsoft MVP, Power BI, Azure
3 年One Billion.... ??
?? 21X Microsoft Certified, 3X Power Automate Super User
3 年= Table.TransformColumnTypes(Source,{{"count", Int64.Type}})
Trainer & Consultant | Power BI | SQL | DAX | Databricks | Power Query | MS 365 and digital tools
3 年1 0 +
?? 21X Microsoft Certified, 3X Power Automate Super User
3 年0000 ! ??