MSBI
PRAGIM Technologies: MSBI Course Contents
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 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
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
- 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