In this course, you will learn to import data from a variety of sources, and summarize data quickly and effectively in Power Pivot to deliver KPI report in minutes. You will also learn to use DAX formula language, time-intelligence functions and cube formulas to analyse data.

## Key Modules Covered in this Course

### Tour of the Power Pivot

- Why Power Pivot is great for accountant
- Import million rows data into Power Pivot
- Learn how to create linked table
- Consolidate variety Data Tables with Power Pivot
- Build Relationship for data analysis
- Add Slicer to a Power Pivot Report

### Use DAX (Data Analysis Expressions) formula to analyse data

- Construct efficient databases and designs for Power Pivot analysis
- Understand Power Pivot formula engine
- Use DAX formula to create calculated columns
- Use calculated columns as new filterable items for analysis
- Build “or” and “and” relation in DAX formula
- Compare Measure with Calculated Columns
- Hide Power Pivot fields from Pivot table

### Advanced DAX functions

- Introduce the dramatic benefits of “Portable Formulas”
- Use one Measure inside another Measure
- Learn to use functions that filters before it CALCULATEs
- Learn to use functions that calculate data which ignore ALL filters
- Use disconnected tables for sophisticated data analysis

### Time intelligence with DAX

- Introduce Time Intelligence and Calendar Tables
- Calculate current month, current quarter, year to date (YTD) information
- Compare values from various time periods

### Case Study: KPI variance report

- Build the basic measures for your report
- Protect time intelligence functions from discontinuous dates
- Use unlinked tables to toggle thousands/millions
- Use unlinked tables to toggle between sales, costs and profits
- Highlight key performance indicators with KPI icons

### Combine PivotTable Power with Formula Flexibility

- Convert Power Pivot PivotTables to CUBE formulas
- Extract a Slicer selection with CUBERANKEDMEMBER
- Evaluate a measure for multiple members with CUBESET

Very impressed by the new idea of ‘block’ applied to analyse the data in this course. Terry is very patient to answer each student’s query in class and shares a lot of precious experience in building the model.

因各种原因，这门课错过了好几次，这次终于如愿以偿。Terry讲得一如既往的好，课程设计得也非常棒，让我们充分领略到Powee Pivot 的强大。原来以为高大上的事情，在Power Pivot里却瞬间就得以实现，让我们的会计分析变得游刃有余。非常喜欢的一门课。强烈推荐！

两天的课程内容非常丰富，希望工作中能把Terry的建模逻辑好好用上。能用上则事半功倍。课堂上的东西非常系统有条理，涵盖的知识不是从Google上都能搜素到的。推荐给所有希望改进自己工作效率的会计人员。

Ver impressive! A great learning experience I had the past two days.

I believe this is going to be my powerful tool at work. Great thanks to Terry.

Terry老师的课程有许多数据模型建立的实战经验，课程内容实用，结构合理，解答问题很有耐心，每次上课都收获颇多，学过的技能马上就用在了工作中。

The course is great, it has open up the limitations to analysis data in different angle simultaneously and make analysis more interesting.

Though it require more practice to master the use, but enough for me to think various way of analysis the data.

This course is really good, provides a new ideas about how could we cook the data in many different ways. There are a lot of learning for me from two day’s study.

不想评论，因为这门课已经厉害到没法评论了。从没想到Excel还能有如此先进的用法

学建模后感

人在忙碌的时候，就只能看着脚下的路，没空去想目标和意义。我为什么要建这个表格，能不能换个思路，都没时间想，照做就可以了。

Terry老师的建模培训课，非常有价值，是真正意义上的普渡会计从业人员。

当然，这种意义也是慢慢生长，先是对一小撮人有意义，再可能是更多的人。总之，知道别人不知道的，能做别人不能做的，就让大家在学习和追赶中，慢慢升级迭代，build block越做越好。

最后，愿你早上醒来，会像Terry老师一样，自信满满打开电脑，应对各种建模。

Amazing course.This BIG DATA Training course is a new way , and different angle to analyse data.

Learn a lot of powerful Excel Skill – Power Pivot, will definitely help in future work. Love new technique, make accounting life much interesting and easier.

Great course, Great content and Great tutorial as always. The three BI courses are setting up competitive advantage for me in the real world. Have attended most of Terry’s courses and none of them disappoint. Enriched contents and Terry always can change the scenarios to resolve our queries on site. So Well-Done!

This is a amazing course. it is easily to find a loads of videos or tutorials online regarding to Power Pivot. However, Terry is the only one teaches the logic and secrete to successfully use PowerPivot. Highly reconmmed!

这门课让我们领略了Excel的强大power。谢谢Terry老师精心设计课程和耐心地讲解。

This course fundamentally changed the way I am doing the report. It makes report more structured, easy to maintain and saved time.

Very impressive course.

The calendar table, measures and DAX formula are so powerful. Building block idea is so great!

Learned a lot of things this weekend. Thank you so much, Terry

This is a course you must have!

我觉的power BI为我们打开了一扇大门，非常神奇，Terry老师就像一位魔术师把所有的数据的玩转到一种高度，很好的一门课程

这次课程又学到了新的思路和新的公式，回去以后需要时间消化一下。希望自己不要在懒惰，可以花些时间把它运用在工作中。期待下次学习几个BI软件的交叉运用，融合在一起来解决问题。谢谢老师上课时的耐心讲解，人品大大的赞！

非常喜欢做一个砖头AMT，然后把AMT 变成sales cost profit,来生成不同report.

The ideal to link tables then to do the analysis is very useful!

Excellent course, can’t miss it!

Power BI 的核心，让你对excel的应用达到新的高度。

This BIG DATA Training course is a new way , and different angle to analyse data. It is a fantastic courses.