Goals
- Describe the key points and benefits of self-service BI
- Use SQL Server Reporting Services to implement a reporting solution
- Design and implement Big Data processes for self-service BI support
Program
Overview
Planning a BI project
Microsoft BI platform
Plan a Data Warehouse
Infrastructure
Plan an ETL Infrastructure Plan an Analysis Services
Infrastructure Plan a Reporting Services Infrastructure
Design a logic diagram
Design a physical diagram
Plan data extraction
Plan data transformation
Plan data load
Plan SSIS package deployment
The possible options
Create a tabular model
Overview
Choosing a delivery method
Design reports
Consideration around running reports
Planning a reporting solution
Use Excel for
PowerPivot data and analysis reports in Excel
Power View in Excel
Overview
Plan Solution Security
Plan Reporting Services
Configuration
Plan PowerPivot Configuration Plan PerformancePoint Services
Overview
Monitor and optimize the Data Warehouse
Monitor and optimize Analysis Services
Monitor and optimize Reporting Services
Overview
Automate ETL Jobs
Post ETL Jobs
Plan a Backup Solution
Duration
5 days
Price
£ 3006
Audience
BI and Database Professionals
Data Analysts
Prerequisites
Have knowledge of the data warehouse and data modeling principles
Have a good command of Microsoft Excel and Microsoft SharePoint Server 2013
Reference
BAS1175-F
Sessions
Contact us for more informations about session date