MSBI Online Training Course
MicroSoft – Business Intelligence
(SSIS, SSAS, SSRS)
Duration : 5 – 6 Weeks
What is Microsoft BI?
Core concept – BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive – more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source
OLAP Modeling
Modeling source schemas—stars and snowflakes
Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling—data mining etc…
Using SSAS in BIDS
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS
Intermediate SSAS
KPIs
Perspectives
Translations – cube metadata and currency localization
Actions – regular, drill-through and reporting
Advanced SSAS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage and Aggregation
Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP, ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design – Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time – Proactive Caching
Cube processing options
Beginning MDX
Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions
Intermediate MDX
Adding calculated members
Adding scripts
Adding named sets
.NET Assemblies
SSAS Administration
Best practices – health monitoring
|
XMLA scripting (SQL Mgmt Studio)
Other Documentation methods
Security – roles and permissions
Disaster Recovery – backup / restore
Clustering – high availability
Introduction to Data Mining
What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models
Introduction to Reporting Clients
Excel 2003 Pivot Tables
Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent
SQL Server 2008 Reporting Services
Introduction to SQL Server Reporting Services
Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin
Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations and Formatting
Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting
Grouping and Sorting
Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports
Report Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
Creating Matrix Reports and Charts
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities
Managing Reporting Services
Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager
Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security
Programming Reporting Services
The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls
Advanced Reporting Services Programming
Using the Reporting Services Web Service
Working with Custom Assemblies
Snapshots and Subscriptions
Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions
Ad-Hoc Reporting with Report Builder
The Report Builder Architecture
Creating Report Model Projects
Running Report Builder |
