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
Link to download CSV Files and Demo Excel File
aasolutions.sharepoint.com/:f:/g/AA_CPort/Eqq476I-mDFEtp5c64A2glUBf2KeDCNr4F6Zlil7lzZXrw?e=BUSM8C
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.
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/
- 10 Million Rows of data Analyzed using Excel's Data Model ( Download)
- Power BI vs Excel Dashboards - And the winner is... ( Download)
- Excel Vs Power Bi: Which Is Better For You ( Download)
- Different ways to work with Microsoft Excel in Power BI (2023) ( Download)
- Why EVERY Excel User Needs Power Query & Power Pivot ( Download)
- Excel v Power BI compared ( Download)
- Should You Learn Power Bi Everything You Need To Know ( Download)
- Power BI vs Excel: When you should use each tool ( Download)
- Live Training Batches Details - Power BI with DAX ( Download)
- How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI ( Download)
- Try limiting rows when creating reporting for big data in Power BI ( Download)
- Learn Excel Power Query to Automate Boring Tasks ( Download)
- How Power Query Will Change the Way You Use Excel ( Download)
- Excel Data to Power BI - What's Still Working in 2024 ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
