Power Pivot - Big Data Analysis Made Easy
Providing insights using DAX formulas!
Updated on Apr, 2024
Language - English
Lectures -21
Resources -1
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
If you find yourself stuck with hundreds of millions of rows of data to analyze, or find it a hassle to build a pivot table based on multiple data sources, then this course is for you.
Join me in the course:
- to learn about advanced DAX formulas, also known as Data Analytic Expressions,
- to learn how to connect data from different sources before feeding them into 1 single pivot table,
- to learn Relationship mapping, Power Pivot’s way of doing VLOOKUP()
- to learn about the best practices in Power Pivot modeling and
- to be well positioned for building the ultimate dashboard in Power BI that utilizes DAX formulas
PS: Excel 2010 and newer is needed for this course.
Goals
What will you learn in this course:
- This course will help you
- to learn about using DAX formulas, also known as Data Analysis Expressions
- to learn how to connect data from different sources before feeding them into 1 single pivot table
- to learn Relationship mapping, Power Pivot’s way of doing VLOOKUP()
- to learn about the best practices in Power Pivot modeling and
- to be well positioned for building the ultimate dashboard in Power BI that utilizes DAX formulas!
Prerequisites
What are the prerequisites for this course?
- Intermediate Excel knowledge
- Example: be able to build a pivot table from scratch
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
4 Lectures
-
Introduction
00:30
00:30
-
Data Analysis challenges
03:39
03:39
-
Instructor's background
01:09
01:09
-
Why this course?
00:39
00:39
Power Pivot - from Basic to Intermediate
6 Lectures
Power Pivot - DAX Formulas in Data Analysis
5 Lectures
Power Pivot - 7 Best Practices
2 Lectures
Conclusion
2 Lectures
Supporting Materials
1 Lectures
Instructor Details
Lenny Wu
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now