Microsoft Suite Training (SSIS-SSAS-SSRS)

The Microsoft Suite training (SSIS-SSAS-SSRS) allows you to design and deploy a Business Intelligence solution with SQL Server.

Educational Objectives of the Microsoft Suite Training (SSIS-SSAS-SSRS):

• The architecture of the SSIS-SSAS-SSRS suite
• The concepts of Change Data Capture/Data Quality and Master Data Services
• Creating a control flow and implementing data transformations with the SSIS ETL
• The concepts of PowerPivot and Powerview / DAX queries for analysis
• Formatting reports with SSRS

Microsoft Suite training course (SSIS-SSAS-SSRS):

• Introduction to the Microsoft Suite (SSIS-SSAS-SSRS)
  • Why build a data warehouse and OLAP cubes?
  • Business strategy via Balanced Scorecards.
  • The principles of modeling (star, snowflake, constellation, etc.).
  • SQL Server 2012 BI Architecture.
  • Manage database structure with Master Data Services.
• Module 1 of the Microsoft Suite training (SSIS-SSAS-SSRS): Integration Services (SSIS), the objects handled
  • The notion of Package, the notion of WorkFlow.
  • The flow of control and its tasks: SQL script…
  • The Change Data Capture task.
  • Task add-in (filewatcher).
  • Sequence container, For Each loop.
  • Practical work
  • Creation and modification of control flows.
• Module 2 of the Microsoft Suite training (SSIS-SSAS-SSRS): SSIS, knowing how to feed the tables
  • Source, destination and transformation.
  • Transformations: conditional splitting, derived column, grouping…
  • Deployment, execution of packages.
  • Logging, security.
• Microsoft Suite Training Module 3 (SSIS-SSAS-SSRS): Analysis Services (SSAS), Building Cubes and Star Schemas
  • introduction to multidimensional cubes.
  • Introduction to tabular cubes and PowerPivot techniques.
  • Dimension and fact tables.
  • Creation of cubes in BIDS.
  • Practical work
  • Creation of an Analysis Services database. Setting up dimensions.
  • Creation of cubes.
• Microsoft Suite Training Module 4 (SSIS-SSAS-SSRS): SSAS, Advanced Elements
  • The MDX language.
  • Extraction and reports.
  • Data Mining: clustering, forecasting, decision trees, etc.
  • DMX prediction graphics queries.
• Microsoft Suite Training 5 (SSIS-SSAS-SSRS): Reporting Services (SSRS), Building Reports
  • The report server.
  • Report Designer vs. Report Builder 3.0.
  • Use Tablix.
  • The Report Model.
  • MDX cube reports, subreports, and linked reports.
• Microsoft Suite Training Module 6 (SSIS-SSAS-SSRS): SSRS, Deploying and Managing Reports
  • Report export (PDF, Excel, etc.).
  • Using PowerPivot in Excel, DAX language.
  • Deployment, report management with SharePoint.