Excel: Modeling with Power Pivot and Reporting Insights

Excel: Modeling with Power Pivot and Reporting Insights

This course is part of Data Analysis and Visualization with Microsoft Excel Specialization

Instructor: Bill Rosenthal

Access provided by Gruppo AB

3 modules

Gain insight into a topic and learn the fundamentals.

3 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

3 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Activate the Power Pivot interface to build unified data models, map database relationships, and define table cardinalities.
Formulate custom calculations and key performance indicators using Data Analysis Expressions syntax and functions.
Structure automated corporate reports using macro-enabled workbooks, specialized templates, and flat file exports.
Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Data Analysis and Visualization with Microsoft Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 3 modules in this course

To round out your data-analysis skills in Excel, you'll use Power Pivot to create data models and perform advanced analysis and visualization tasks. You'll also plan and then create a report for presenting data-driven findings.

You are already aware of Microsoft® Excel's® many analytical capabilities. But, as powerful as Excel is, there are some tasks it simply can't handle on its own. There may be times in your career where you need to perform complex data analysis on very large datasets from a wide variety of sources, which may include data in numerous database tables or from massive data feeds. When your analysis requires this sort of heavy lifting, Excel could use a bit of help. Fortunately, Excel includes a powerful add-in that can handle this very type of heavy lifting: Power Pivot. Taking the time to become familiar with this add-in, its capabilities, and how it works, will open an array of new opportunities in terms of high-level data analysis.

What's included

1 reading6 plugins

Although charting in Microsoft® Excel® and reporting with Excel are often considered the same thing, there are many subtle differences. Reports may well include charts, but they also must include additional information to put the charts in context. Reporting is a task you will likely be called upon to do frequently, so acquiring the skills to do it effectively will help you in any job role.