Disclosure: when you buy through links on our site, we may earn an affiliate commission.

# Power Pivot – Big Data Analysis Made Easy

4.1
4.1/5
(7 reviews)
12 students

## 9.1

CourseMarks Score®

7.9

Freshness

10.0

Feedback

8.9

Content

Platform: Udemy
Video: 1h 1m
Language: English
Next start: On Demand

## Description

The course is presented in four parts.

First, brief introduction to Power Pivot and discuss reasons it has become more versatile than the conventional pivot table:
o Excel spreadsheet has limit of 1 million rows, while Power Pivot can connect to over 1 million rows of data. So no limit on the data sources
o Power Pivot can combine all data sources into one pivot table. So no more VLOOKUP()
o A plethora of DAX formulas in Power Pivot. Plus the formulas can be re-used!

Second part is to demonstrate basic maneuvers on how to:
o map all dimension tables and fact tables together, and
o incorporate data from ALL sources into 1 pivot table, and

Third, we demonstrate 6 fundamental DAX formulas in Power Pivot to get you started in building advanced models for effective analytics, including:
o CALCULATE
o SUMX
o RELATED
o SAMEPERIODLASTYEAR

Last, we culminate the webinar with the best practices in Power Pivot modeling, including:
o Use Measures (or Calculated Fields) over Calculated Column in order to
o Table naming conventions, and
o DAX format

Course Search Keywords
– Power Pivot
– Calculated Column
– Calculated Field
– Measures
– DAX formulas
– Data Analysis Expressions
– Dimension table
– Fact table

● Basic Excel knowledge
● Example: be able to open one Excel file and add a new sheet, etc.

Learning Objectives
● Discover Power Pivot as the big data analysis tool
● Identify the best practices in Power Pivot modeling
● Recognize Power Pivot’s essential steps in relationship and integration
● Discover 6 essential DAX formulas to get you started in Power Pivot formula writing
● Explore differences between a calculated column and a calculate field

#### You will learn

✓ – 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!

#### Requirements

• Intermediate Excel knowledge
• Example: be able to build a pivot table from scratch

#### This course is for

• Students (Secondary or post secondary), Office workers, Professionals, and Managers

#### Lenny Wu, MBA, CPA, CGA

Online Professional Development Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. He also sat as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language),  and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny’s motto at work is “Don’t work hard, work smart”. Lenny has passion in teaching how to build your own “robot” into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
Lenny is a big proponent of OCR (One-click Reporting), and SSR (Self-service Reporting).

Browse all courses by on Coursemarks.
Platform: Udemy
Video: 1h 1m
Language: English
Next start: On Demand