You will learn how to build dashboard solutions in Excel and Power Pivot. The main goal of building anything in Excel is to display information form one or serveral "raw" data sources, either for your own use or to report the information to someone else. When communication data, it's important to think about how to show and visualize the relevant information in an effective way.
In this course you will learn real examples and investigate how to visualize information in an effective way, using some basic principles.
Dashboards should communicate the information you know the user needs very clearly at a level that is actionable and recognizable. You will learn how to design and create a dashboard.
Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible.
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using Power Pivot.
To ensure your success in this course, you should have experience working with Excel 2013 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following courses:
Microsoft® Office Excel® 2013: Part 1 (Second Edition)
Microsoft® Office Excel® 2013: Part 2 (Second Edition)
Microsoft® Office Excel® 2013: Data Analysis with PivotTables (recommended)