Unleash the Power of Powerpivot 2010 for Data Insights
For powerful, rapid, highly visual business intelligence reporting.
In-House sessions are available upon request.
In this Excel course, you will be using Power Pivot and Pivot table as the primary functions to create a dashboard. Power Pivot is a new function in Excel 2010 that works hand in hand with the all too familiar Pivot Table. Power Pivot can analyse multi-million rows of data seamlessly, combine multiple sources of data into one. It also comes with the new Slicer features as well as DAX formulas that make insightful, professional looking Dashboard Reports creation a breeze.
Who Should Attend:
This course is specially tailored for business managers and executives who are responsible for preparing management reports and are seeking new perspectives to enhance and add value to their presentation. Participants must have attended everydayExcel.’s Hidden Secrets in Data Analysis with Excel Course or possess advanced knowledge about Excel. Advanced Excel users are defined as regular users of VLOOKUP worksheet function, complex functions (formulas within formula), Pivot Table, etc.
Through the development of a Monthly Performance Report, you will learn how to:
- Establish and connect data from multiple sources such as SQL, SharePoint, Excel workbooks, CSV files and Excel Tables.
- Apply the new DAX formulas in Power Pivot.
- Create Slicers and enhance the report’s interactivity.
- Prepare Impressive charts and tables for reporting.
|Section 1: Creating an Interactive Title for Management Report|
|Section 2: Importing Data from multiple sources using Excel Power Pivot|
|Section 3: Creating and linking slicers to Power Pivot Table|
|Section 4: Displaying selected Historical Data with Power Pivot|
|Section 5: Using DAX formulas and Measures in Power Pivot|
|Section 6: Creating an interactive line and column chart in Excel|
|Section 7: Auto calculate MTD and YTD Actual and Targets with Power Pivot|
|Section 8: Activating and using the highly interactive Excel Camera|
|Section 9: Automatically display the Top 5 products/customers/categories with Power Pivot|
|Section 10: Using Coloured Bands in charts for benchmarking|
|Section 11: Turning on PowerPivot auto-refresh function|
|Unleash the Power of Powerpivot 2010 for Data Insights (2-Day)||14:00:00|
No Reviews found for this course.