Prerequisites
Participants who want to attend this training should have at least an intermediate knowledge in Microsoft Excel Working with familiarity in Data Analysis, Advance Logical, Lookup, and Nesting Functions.
Course Description
Perhaps the best feature of Microsoft Excel is its ability to provide a more agile and highly cost-effective approach to Business Intelligence which has been made possible by PowerPivot. It extends the things you already know about Excel, rather than having to start from scratch.
Learn the in-depth tools available in PowerPivot so you can analyze huge amounts of data quickly and accurately. This course will enable you to create business intelligence reports out of Microsoft Excel using the power of Power Pivot.
Course Objectives
At the end of this course, the participant should be able to:
-
Learn how to connect, analyze and visualize massive amounts of data from familiar interface of Excel from different external sources.
-
Explore the power of Data Model and how to integrate structure to Microsoft Excel.
Course Coverage
-
Understanding PowerPivot
-
PowerPivot Data Source
-
Data Model
-
Pivot Table from PowerPivot Design
-
DAX Overview
Who Should Attend
Finance or accounting executives, data analysts, marketing executives, business managers and any professionals who deal with generating reports and would like to create a graphical representation using the power of Microsoft Excel.