Course Summary:

Whether you regularly analyze data now or provide technical support for those who do, this class teaches you how take business intelligence to the next level using Excel 2007 and Analysis Services 2005. This course includes an introduction to PivotTable fundamentals, and builds on these concepts to more advanced analytical techniques to explore and visualize data. In addition, this course covers working with OLAP data in a free-form format using CUBE functions. This course will also review the use of data mining to find the hidden information in your business using the Data Mining Add-Ins for Excel 2007.

By the end of this course, students will understand how to:

• Create and format a PivotTable
• Use a PivotTable to explore data by drilling, sorting, isolating and eliminating data, or launching actions
• Use visualization features to summarize PivotTable data for easier identification of trends and exceptions
• Use Data Mining Add-Ins for Excel 2007 to simplify investigative and predictive analysis

efst á síðu

Prerequisites:

None

efst á síðu

Length: 1 Day

efst á síðu

Course Layout:

Learning PivotTable Fundamentals

• Creating a PivotTable
• Designing the PivotTable Layout
• Using PivotTable Features to Explore Data

efst á síðu

Visualizing Data

• Working with a PivotChart
• Using Conditional Formatting
• Presenting Key Performance Indicators

efst á síðu

Using CUBE Functions

• Aggregating Cube Values
• Adding Member Labels
• Creating a Set of Members
• Ranking Members in a Set

efst á síðu

Using Data Mining Add-ins for Excel 2007

• Introduction to Data Mining
• Preparing a Data Mining Project
• Using Data Mining for Exploration
• Using Data Mining for Prediction

efst á síðu