more
Lenny Wu, Management Reporting Analyst, Seaspan Ship Management
Lenny is Management Reporting Analyst with over 10 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and real estate lease auditing. He is a CPA, CGA, and a Certifi
This instructor has 25 courses »To Access This Course:
The course is presented in four parts.
First: A brief introduction to Power Pivot and discuss reasons it has become more versatile than the conventional pivot table:
- 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
- Power Pivot can combine all data sources into one pivot table. So no more VLOOKUP()
- A plethora of DAX formulas in Power Pivot. Plus the formulas can be re-used!
Second: To demonstrate basic maneuvers on how to:
- Map all dimension tables and fact tables together, and
- 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:
- CALCULATE
- SUMX
- RELATED
- SAMEPERIODLASTYEAR
Last: We culminate the webinar with the best practices in Power Pivot modeling, including:
- Use Measures (or Calculated Fields) over Calculated Column in order to
- Table naming conventions, and
- DAX format
Course Key Concept: Power Pivot, Calculated Column, Calculated Field, Measures, DAX formulas, Data Analysis Expressions, Dimension table, Fact table.
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.
Last updated/reviewed: November 5, 2020
Prerequisites
Course Complexity: Intermediate
Basic Excel knowledge; be able to open one Excel file and add a new sheet, etc.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .