INTRODUCTION TO BUSINESS INTELLIGENCE (BI)

• The definition of BI
• Why is BI important?
• Preview a BI stack

 CHOOSING THE RIGHT BI TOOLS

• Differentiate between business groups that consume BI
• Understand the typical progression of BI
• Determine the best BI tools for your needs

 FIRST STEPS WITH POWERPIVOT

• Working with Classic Excel PivotTables
• Working with PivotTables in PowerPivot
• Importing, Querying Data and Creating a Data Model
• Creating PivotTables from multiple data sources

 POWERPIVOT AT WORK

• Using the PivotTable to Produce Reports
• Formatting Numbers
• Adding Calculated Columns
• Adding Measures
• Adding More Tables
• Refreshing Data
• Using Slicers

The key topics that it covers include recorded macros, the macro editor, using and defining variables, creating custom forms and working with the various objects within Microsoft Excel.