LEARN WITH AUGMENT SYSTEMS PVT LTD

6 months duration

Course Fees: 89,999 INR

Comprehensive Business Intelligence with MSBI (Microsoft Business Intelligence) Suite

This course provides a comprehensive introduction to the Microsoft Business Intelligence (MSBI) suite, covering essential concepts, tools, and techniques for building robust data integration, analysis, and reporting solutions. Through a series of hands-on Session#s, participants will learn the fundamentals of MSBI, including data flow and control flow, ETL (Extract, Transform, Load), data warehousing, and more. The course also explores advanced topics such as SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services) components, enabling learners to develop expertise in building data-driven solutions for business intelligence needs.

Session# 1: MSBI Fundamentals, Data Flow, Control Flow, ETL, Data Warehouse (SSIS)

• Introduction to MSBI suite and its components
• Understanding data flow and control flow in SSIS
• Implementing ETL processes using SSIS
• Building a data warehouse for business intelligence

Session# 2: Conditional Split, Data Conversion, and Error Handling (SSIS)

• Splitting data based on conditions using the Conditional Split transformation
• Converting data types using the Data Conversion transformation
• Handling errors and exceptions in SSIS packages

Session# 3: For Loop, Variables, Parameters, and Debugging (SSIS)

• Implementing iterative processes using the For Loop container
• Working with variables and parameters in SSIS
• Debugging and troubleshooting SSIS packages

Session# 4: Packaging and Deployment, File Component, and Running SSIS Package as a Task (SSIS)

• Packaging SSIS packages for deployment
• Using the File component for file operations in SSIS
• Running SSIS packages as tasks in other SSIS packages

Session# 5: Dimensions, Measures, Star Schema, Snowflake, Shared Connection Managers, and Package Tasks (SSIS)

• Designing dimensions and measures for analysis
• Implementing star schema and snowflake schema in SSIS
• Working with shared connection managers and package tasks

Session# 6: Slowly Changing Dimensions (SCD), OLE DB Command, and Unicode Conversions (SSIS)

• Handling slowly changing dimensions (Type 0 and Type 1) in SSIS
• Using the OLE DB Command transformation for custom SQL operations
• Performing Unicode conversions in SSIS

Session# 7: Lookup, Data Conversion Optimization, and Updating SSIS Packages (SSIS)

• Performing lookup operations using the Lookup transformation
• Optimizing data conversions in SSIS packages
• Updating and maintaining SSIS packages

Session# 8: Sort, Merge, and Merge Joins (SSIS)

• Sorting data using the Sort transformation
• Merging data from multiple sources using the Merge transformation
• Performing merge joins in SSIS packages

Session# 9: Creating SSAS Cube (SSAS)

• Introduction to SQL Server Analysis Services (SSAS)
• Designing and creating SSAS cubes for multidimensional analysis

Session# 10: SSAS Time Series and Excel Display (SSAS)

• Analyzing time series data using SSAS
• Visualizing SSAS data in Excel

Session# 11: Transactions and Checkpoints in SSIS (SSIS)

• Understanding transactions and implementing them in SSIS packages
• Using checkpoints to resume package execution in SSIS

Session# 12: Simple SSRS Report and Implementing Matrix, Tabular, Parameters, Sorting, Expressions (SSRS)

• Creating a basic SSRS report
• Implementing advanced report features such as matrices, tabular layouts, parameters, sorting, and expressions

Session# 13: Data Profiling Task for Data Quality Checking (SSIS)

• Using the Data Profiling Task in SSIS to analyze data quality
• Identifying and resolving data quality issues

Session# 14: Hierarchical Dimensions (SSAS)

• Designing and implementing hierarchical dimensions in SSAS

Session# 15: Web Services and XML Task (SSIS)

• Consuming web services in SSIS packages
• Processing XML data using the XML Task

Session# 16: DrillDown and Subreports (SSRS)

• Enabling drill-down functionality in SSRS reports
• Creating and integrating subreports into main reports

Session# 17: SSAS Key Performance Indicators (KPI) (SSAS)

• Designing and implementing Key Performance Indicators (KPIs) in SSAS cubes

Session# 18: Pivot, Unpivot, and Aggregation (SSIS)

• Performing pivot and unpivot operations in SSIS
• Aggregating data using the Aggregate transformation

Session# 19: SSAS Calculation (SSAS)

• Implementing calculations in SSAS cubes

Session# 20: SQL Execute Task (SSIS)

• Executing SQL statements and scripts using the SQL Execute task in SSIS

Session# 21: Reference and Many-to-Many Relationship (SSAS)

• Working with reference relationships in SSAS
• Implementing many-to-many relationships in SSAS cubes

Session# 22: Script Task and Send Mail Task (SSIS)

• Extending SSIS functionality using the Script Task
• Sending emails from SSIS packages using the Send Mail task

Session# 23: Script Component (SSIS)

• Using the Script Component for custom data transformations in SSIS

Session# 24: Bar Chart, Gauge, and Indicators (SSRS)

• Creating bar charts, gauges, and indicators in SSRS reports

Session# 25: Partitions in SSAS (SSAS)

• Partitioning SSAS cubes for improved performance and manageability

Session# 26: Changed Data Capture (CDC) in SSIS (SSIS)

• Implementing Change Data Capture (CDC) in SSIS for incremental data updates

Session# 27: Additive, Semiadditive, and Non-additive Measures in SSAS (SSAS)

• Understanding and implementing different types of measures in SSAS cubes

Session# 28: Buffer Size Tuning (SSIS)

• Optimizing buffer size settings for improved SSIS package performance

Session# 29: Multithreading in SSIS (SSIS)

• Implementing multithreading techniques for parallel execution in SSIS

Session# 30: Processing SSAS Cube in Background (SSAS)

• Configuring background processing of SSAS cubes for automation

Session# 31: Asynchronous, Synchronous, Full, Semi, and Non-blocking Components in SSIS (SSIS)

• Understanding different execution modes and components in SSIS

Session# 32: SSRS Architecture and Deployment (SSRS)

• Exploring the architecture of SSRS
• Deploying SSRS reports to the report server

Session# 33: Data Quality Services (DQS) (SSIS)

• Introduction to Data Quality Services (DQS) for data cleansing and enrichment

Session# 34: Tabular Model and Power Pivot (SSAS)

• Understanding tabular models and Power Pivot in SSAS

Session# 35: MDX (Multidimensional Expressions) Queries (SSAS)

• Writing and executing MDX queries for multidimensional analysis

Session# 36: Data Mining Fundamentals and Time Series Algorithm (SSAS)

• Exploring data mining concepts and techniques in SSAS
• Implementing time series analysis using the Time Series algorithm

Session# 37: Page Split and Performance Issues with SSIS (SSIS)

• Understanding page splitting and its impact on SSIS performance
• Addressing performance issues in SSIS packages

Session# 38: Aggregations in SSAS (SSAS)

• Implementing aggregations for improved query performance in SSAS cubes

Session# 39: ROLAP, MOLAP, and HOLAP (SSAS)

• Understanding different storage modes (ROLAP, MOLAP, and HOLAP) in SSAS

Session# 40: Instrumentation using Data Taps (SSIS)

• Using data taps to capture data during SSIS package execution for monitoring and troubleshooting purposes

Session# 41: Lookup Caching Modes and Cache Transform (SSAS)

• Configuring lookup caching modes for optimized performance in SSAS
• Using the Cache Transform for data caching in SSIS

Session# 42: Perspectives and Translations (SSAS)

• Creating perspectives to provide customized views of SSAS cubes
• Implementing translations for multi-language support in SSAS cubes

Session# 43: Tabular Model Training 1: Installation, Xvelocity, Vertipaq, DAX, Creating Cubes, Measures, KPIs, Partition, and Translation (SSAS)

• Step-by-step training on installing and configuring a tabular model
• Exploring Xvelocity and Vertipaq in-memory technologies
• Using DAX (Data Analysis Expressions) for defining calculations and measures
• Creating cubes, measures, KPIs, partitions, and translations in a tabular model

This course outline is extensive and covers a wide range of topics in the field of business intelligence using the MSBI suite. Depending on the duration of the course, some Sessions may be combined or modified to suit the time.