首页 Business Intelligence

课程

Power Pivot in Excel

基础技能水平

更新时间 2026年4月

Master Power Pivot in Excel to help import data, create relationships, and utilize DAX. Build dynamic dashboards to uncover actionable insights.

免费开始课程

ExcelData Manipulation3 小时9 视频26 练习2,000 经验值13,691成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

Starting with Power Pivot in Excel

Getting started on this insightful journey through Excel Power Pivot, transforming your data analysis skills. Begin by learning how to enable the Power Pivot add-in and import data from various sources. You will be guided through the initial steps of preparing your data for analysis, setting the stage for more advanced techniques.

Exploring Data Modeling Concepts

Dive into the fundamental aspects of Power Pivot with data modeling. Learn to create relationships and hierarchies within your data, enabling a more structured and interconnected data model.

Unveiling the Power of DAX in Excel

Unlock the potential of Data Analysis Expressions (DAX). Master the basics of DAX calculations, creating measures and calculated columns to perform advanced data manipulations, allowing you to level up your analytical capabilities.

Crafting Interactive Reports

Utilize Power Pivot's strengths to help introduce interactivity and storytelling in your reports. Learn to add slicers and organize your visuals to create compelling data narratives. You will be able to create informative and engaging reports even within Excel.

This course promises a hands-on approach to mastering Power Pivot in Excel, empowering you to become a proficient data analyst capable of easily extracting actionable insights.

先决条件

Data Preparation in Excel Introduction to Power Query in Excel

1

Starting with 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.

Introduction to Power Pivot

50 经验值

What's the pivot?

50 经验值

Getting started in Power Pivot

50 经验值

100 经验值

Preparing data with Power Query

100 经验值

Manage data in Power Pivot

100 经验值

2

Data Modeling in Power Pivot

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

Data modeling

50 经验值

Face the facts with dimensions

100 经验值

Data modeling in Power Pivot

50 经验值

Connection builds a relationship

100 经验值

Hierarchies

100 经验值

Mark your calendars

100 经验值

3

DAX in Power Pivot

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.

Introduction to DAX

50 经验值

Keep it in context

50 经验值

DAX in Power Pivot

50 经验值

It's math, not magic

100 经验值

We're related

100 经验值

Aggregate measures

100 经验值

4

Dashboards with Power Pivot

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.

Data stories with dashboards

50 经验值

50 经验值

Dashboards in Power Pivot

50 经验值

Visualizing data with PivotTables

100 经验值

Key performance indicators

100 经验值

Visualizing data with PivotCharts

100 经验值

Slice and dice

100 经验值

Congratulations!

50 经验值

Power Pivot in Excel

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Power Pivot in Excel！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。