BDSEBig Data, Small ExcelPower 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
Big Data, Small Excel 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 working data model fro
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 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 1200+ programs annually, while 25,000+ professionals are equipped with up-to-date relevant education and the latest tech solutions across the EMEA region.We help our valued clients with a wide range of services, including Training Needs Analysis, Competency Development and Assessment, and custom-built e-Learning solutions that cater to specific industries and knowledge areas.LEORON mission remains boosting competitiveness of our clients worldwide through continuous learning, while we strive to achieve our vision of becoming the best quality corporate training and EdTech Company in the EMEA and the world.Whether our clients are facing difficulties re-organising their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure, our development planning is a great solution.LEORON’s mission is to help our worldwide clients boost their competitiveness by improving the competency levels of their employees, through top quality training and development solutions delivered by unrivaled global experts and facilitated by the best training managers in the industry.
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.