Practical Excel 2010: PowerPivot & Advanced Business Intelligence Tools for the Workplace

COURSE DESCRIPTION

This course takes up where the Optima Train Excel 2010 Pivot Tables and Pivot Charts course leaves off. It has two primary themes, each ultimately related to data analysis with pivot tables. First, it teaches you a number of methods for importing external data (from a database, text files, or other sources) into Excel for analysis. Second, it devotes considerable time to the PowerPivot add-in introduced with Excel 2010. To learn Excel PowerPivot and Business Intelligence Tools quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.

Category: Office Productivity/Microsoft

What are the requirements?

• Microsoft Office 2010 and the free PowerPivot for Excel 2010 add-in

Prerequisites: Practical Excel 2010 Pivot Tables and Pivot Charts or equivalent knowledge

What am I going to get from this course?

• Over 4 hours of video content, with corresponding Excel data files for hands-on practice
• An understanding of relational databases, a great source for pivot tables, and how queries can be used to import the data you need
• How to import data from various relational sources into Excel with Microsoft Query
• An understanding of how the new PowerPivot add-in adds significant power to Excel’s existing data analysis tools
• How to use the PowerPivot user interface for Excel 2010
• How to import data into PowerPivot and how to use PowerPivot to create relationships between relatable tables
• How to build pivot tables from PowerPivot data
• How to use the DAX language in PowerPivot to create calculated columns and measures, and why DAX is so powerful
• How to create named sets, hierarchies, and KPIs (key performance indicators) with PowerPivot
• How PowerPivot is related to OLAP cubes

What is the target audience?

• Any competent Excel users who want to be on the leading edge with Excel’s latest and most powerful data analysis tools