SSAS 2008 R2 training course (3 days)
Do you feel there is meaning tied up in your corporate database, if only you could extract it? If you already know SQL, maybe it s time to learn how to analyse your data using SQL Server Analysis Services (rather than simply reporting it as previously). Learn how to create multi-dimensional cubes, monitor KPIs and conduct data-mining algorithms with SQL Server Analysis Services.
SSAS 2008 R2 training - Course Contents
The contents of our SSAS 2008 R2 course are as follows (any items marked with a * will be covered if time allows):
Unified Dimensional Model
- OLAP and OLTP
- What are cubes?
Visual Studio - BIDS
- Configuring Visual Studio
- Creating a data source
- Creating a project
Data Source Views
- Keys and relationships
- Exploring data
- Named queries
- Named calculations
Dimensions
- The dimension wizard
- Attribute hierarchies
- Deploying dimensions
Publishing dimensions and cubes
- Deploying
- Processing
- Handling deployment errors
Basic Cubes
- Using the cube wizard
- The cube designer
- Filtering cubes
Star and snowflake schemas
- The 2 types of schema
- Which to use
Hierarchies and Relationships
- Natural hierarchies
- Unnatural hierarchies
- Suppressing hierarchies
- Attribute relationships
Parent-child Hierarchies
- The self-join needed
- Tidying up the dimensions
- Limitations
Time dimensions
- Creating a time dimension
- Autogenerating
- Creating time hierarchies
Measures
- Measures and measure groups
- Formatting measures
- Dimension usage
- Multiple measure groups
|
Advanced dimensions
- Role-playing dimensions
- Referenced dimensions
Calculations
- Creating calculations
- Formatting calculations
- Basic MDX expressions
Writing MDX Queries
- Tuples
- Using axes
- Default and multiple measures
- Sets and named sets
- WHERE clauses
MDX Expressions
- Year-to-date
- Ratios
- Previous period comparisons
- Ranking
KPIs
- Key Performance Indicators
- Status and trend expressions
- Using KPIs in client tools
- KPI functions
Using client software
- Using Excel as a client
- Using Reporting Services
Cube actions
- Creating URL click-throughs
- Drill-through actions
Mining Models
- Creating a mining structure
- Decision trees - example
- Clustering - example
- Reviewing model accuracy
Data-mining algorithms
- The 9 types of algorithm
- When to use each algorithm
|
Click on any link above to show free exercises for the topic in question. You should only attend this course if you have either attended our two-day introduction to SQL course or if you are comfortable creating queries using SQL. You should also have a good understanding of what a relational database means. There will be a maximum of 6 people on each course, and each person will have their own computer.
