DMPPDData Modeling with Power Pivot and DAXPower Pivot and data modelling
Rating:
English
Advanced
Face to Face
Instructor-Led Training
(F2F-ILT)
Virtual
Instructor-Led Training
(V-ILT)
COACHING
& MENTORING
(C&M)
Self-Paced
Learning
(SPL)
Select Date
Download Brochure
Course Overview
Data Modeling with Power Pivot and DAX shows advanced Excel users how to build genuine relational data models inside Excel using Power Pivot, extending far beyond what a standard spreadsheet can handle. Rather than treating large datasets as a reason to abandon Excel, this course teaches the data modeling and relationship-building skills that let Excel manage them properly. Delegates build a worki
Key Takeaways
1
Build a relational data model inside Excel using Power Pivot
2
Establish correct relationships between multiple data tables
3
Write basic DAX formulas for calculated fields
4
Handle datasets far larger than a standard spreadsheet can manage cleanly
5
Prepare a properly structured data model ready for reporting or Power BI
Certifications
LEORON - Professional Development Institute
LEORON Institute is the leading corporate training and EdTech company in the EMEA region, with the most comprehensive learning and development solutions in all strategic corporate functions, including Corporate Finance, HR, Procurement and SCM, Technology, Quality, Operations and Engineering. Through instructor-led sessions, in-company training, and coaching, our faculty of experts deliver over 2,000+ programs annually, while 50,000+ learners are equipped with up-to-date relevant education and the latest tech solutions across the EMEA region.
As a NASBA-registered CPE sponsor with a KHDA educational services permit in Dubai, LEORON also offers selected professional certifications eligible for HRDF reimbursement in Saudi Arabia.
As a NASBA-registered CPE sponsor with a KHDA educational services permit in Dubai, LEORON also offers selected professional certifications eligible for HRDF reimbursement in Saudi Arabia.
Course Outline
1. Why standard spreadsheets break down with large datasets
2. Power Pivot fundamentals and the data model
3. Building relationships between multiple tables
4. DAX basics for calculated fields
5. Full build - a working data model from raw tables
Who Should Attend?
This course is designed for advanced Excel users working with datasets too large or complex for standard spreadsheet techniques. It suits analysts who want to build genuine data models inside Excel before their organization moves fully to a dedicated BI platform.
FAQ
Do I need Power BI experience for this course?
No, this course is entirely Excel-based, though the data modeling skills transfer directly to Power BI.
What level of Excel user is this for?
This is an advanced-level course aimed at users already comfortable with standard formulas and pivot tables.
Does this feed into a certification?
Yes, this course connects naturally to the five-day Data Analysis and Reporting using Power BI program.