Goals
- Describe the components, architecture and nature of a BI solution
- Create a multidimensional base with Analysis Services
- Implement the dimensions of a cube
- Implement the measures and groups of measures in a cube
- Use the MDX syntax
- Implement a model of tabular data in SQL Server Analysis Services
Program
Elements of an Enterprise BI Solution
Microsoft Enterprise BI Platform
Planning an Enterprise BI Project
Practical Workshops: Exploring a BI solution
Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Create a Cube Cube
Security Overview
Practical workshops: Creation of a multidimensional database
Configure dimensions
Define attribute hierarchies
Sort and group hierarchies
Practical Workshops: Working with Cubes and Dimensions
Working with Measures
Working with Measure Groups
Practical workshops: Configure measures and groups of measures
MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube
Practical Workshops: Using MDX
Work with performance indicators
Work with actions
Work with perspectives
Work with translations
Practical workshops: Customizing a cube
Introduction to Analysis Service Tabular Data Models
Create a Tabular Data
Model Use a Tabular Data Model in Business
Practical Workshops: Implementing a Tabular Data Services Analysis Model
Duration
5 days
Price
£ 2134
Audience
Database professionals who wish to become a developer to create analysis and reporting solutions with SQL Server
Prerequisites
Experience required in the use of relational databases
Reference
BAS1126-F
DAX Fundamentals
Improving a Tabular Data Model with DAX
Hands-on Workshops: Creating Columns and Calculated Measures Using DAX
Introduction to Reporting Services
Create a Report with Report Designer
Group and Aggregate Data in a Report
Publish and View a Report
Practical Workshops: Creating a Report with Report Designer
View graphical data
Filter reports using parameters
Practical workshops: Subscription implementation report
Manage report security
Manage report execution
Subscriptions and alerts
Troubleshoot Report Services
Introduction to using Sharepoint Server in a BI platform
Introduction to PerformancePoint Services
Data source PerformancePoint and Time intelligence
Reports, dashboards
Practical Workshops: Implementing PerformancePoint Services
Data Mining Overview
Create a Data Mining Solution
Validate a Data Mining Model
Use Data Mining Data
Practical Workshops: Using Data Mining to Support a Marketing Campaign
Sessions
Contact us for more informations about session date