MS Business Intelligence - Developers training course

Administration

Backing up and restoring star schemas
Backing up and restoring cubes and tabular models

Visualization - 1 day

Visualization - overview

MDX queries on multidimensional and tabular
DAX queries on multidimensional and tabular
SSRS reports on multidimensional and tabular
Excel pivot tables on multidimensional and tabular
Power Pivot and Power BI
SharePoint BI, Power View, Power Pivot gallery

SSRS - overview

Reporting Services
Report Server
Report Designer
Report Manager
SharePoint integration

SSRS - designing reports

MDX multidimensional and tabular reports
DAX multidimensional and tabular reports
DMX data mining reports
Using report templates
Deploying reports to Report Manager and SharePoint

SSRS – further techniques

Formatting
Conditional formatting
KPIs
Grouping and drill-down
Totals and running totals
Sorting
Charts and gauges
Parameterised MDX and DAX reports

SSRS - multiple reports

Subreports
Jump reports
Linked reports

Further visualization

Exporting SSRS reports to Excel and PDF
Power View in Excel and SharePoint
Power Map in Excel
Excel pivot tables on multidimensional, full tabular, and Power Pivot
Getting everything into SharePoint

SSRS - administration

Reporting Services Configuration Manager
SharePoint integration
Report caching
Report snapshots
Report subscriptions (emailing reports)
Security overview

SSIS - 1 day

SSIS - overview

Workflow
Control Flow toolbox overview
Data Flow (ETL) toolbox overview
Power Query alternative

SSIS Control Flow

Profiling data
Execute SQL Task
Send Mail Task
Sequence Container
Variables/Parameters
Script task
Foreach Loop Container

SSIS Data Flow

Sources, destinations, and transformations
Data Viewers
Conditional Split transformation
Derived Column transformation
Lookup transformation (with Sort and Merge transformations)
Correcting bad data
Working with incremental updates
Working with Big Data and Hadoop overview

SSIS package administration

Deploying packages
Executing packages with dtexec and stored procedures
Scheduling packages with SQL Server Agent
Configuring packages with parameters
Logging packages