Excel의 Power Pivot

You will take your first steps in setting up Power Pivot by enabling the add-in. Then, you will import data from various source types and practice preparing your data for analysis.

In this chapter, you will begin exploring data modeling concepts in Power Pivot, including creating relationships and hierarchies.

In this chapter, you will explore DAX (Data Analysis Expressions) in Power Pivot. You will learn to write DAX formulas to create calculated columns and measures. You will also understand the importance of row and filter context when using DAX.

In the final chapter, you will make your Excel reports interactive with Power Pivot by adding slicers and organizing your visuals in a way that tells a data story.