Microsoft BI

Course Features

Course Details

Introduction To MS - BI:
What is MS-BI
BI/DWH life cycle
ETL and OLAP Tools
Features of MS-BI
Introduction To SSIS:Package
Tasks
SSIS installation
SSIS Architecture
SSIS Wizard
Control Flow Tasks
Data Flow Task
Variables and Expressions
Errors and Debugging SSIS
Data viewers
Deployment
Manually Executing SSIS Package
Scheduling SSIS Package
Importing and Exporting Packages
Monitoring and Optimizing Packages
Introduction To SQL Server Reporting Services
Reporting Services Architecture
Reporting Services Terminology
Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations And Formatting
Creating Expressions
Using the Global Collection
Grouping And Sorting
Creating Groups and Calculating Totals and Percentage
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
Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security
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
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
Beginning MDX:Basic Syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions
Welcome to the Real Time – Proactive Caching
Cube processing options
This course does not have any sections.

More Courses by this Instructor