Microsoft DW/BI Technologies

Description

The key to every successful DW/BI (Data Warehouse & Business Intelligence) system implementation is understanding the business requirements and preparing the data necessary to meet them. This means that a project’s success relies on how accurately business processes will be identified and modeled, as well as on obtaining proper data quality and structure.
The goal of the training is to equip analysts, BI specialists and database programmers with knowledge and skills necessary to create DW/BI systems according to the methodology established by Ralph Kimball and his group, the Kimball Lifecyle. This is one of the most commonly used methodologies, which in a detailed way describes each step of designing, implementing and maintaining a DW/BI class system, and may successfully be applied for Microsoft technology. The training emphasizes the crucial role of a properly designed data warehouse and the ETL (Extract, Transform and Load ) process which supplies it, in creating functional and efficient analysis-report systems, not omitting nonetheless the issues related to providing access to the systems to business users.

Options

  • Course level: 300
  • Start date: as required
  • Duration time: 5 days

Price: 5000 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer

Class

The course is addressed to BI specialists and database programmers. Its participants will be given a complete methodology of DW/BI projects, starting with identifying business processes, through the implementation of information management processes, multi-dimension modeling, creating analytic databases, and finishing with making information available to the users in the form of an Excel sheet and reports. They will also be trained in Microsoft technologies enabling to create DW/BI systems and to apply them in business analysis.

Plan

The basic training is comprised of 11 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants. We would like to encourage you not only to choose the modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered during the course.
Our trainings are exceptional also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.

Modules

Duration: Level:
Module 1

Introduction to DW/BI Systems
  • Kimball’s Methodology (Data Warehouse Development Lifecycle)
  • Presentation of Microsoft DW/BI Technologies

60 minutes 200
Module 2

Designing and Creating Data Warehouses
  • Identification and Analysis of Business Processes
  • Determining Requirements and Limitations of a Project Scope
  • Star Schema and Snowflake Schema
  • Dimension Tables and Fact Tables
  • Slowly Changing Dimensions
  • Time Dimension
  • Hierarchies, Including Unbalanced Hierarchies and Parent-Child Hierarchies
  • Relationships between Tables, including Many-to-Many Relationship
  • Model Implementation (Distribution of Data, Indexes, Partitioning, Data Compression)

180 minutes 300
Module 3

Loading Data Warehouse with Data
  • SSIS Service
  • SSIS Packages
  • Control Flow and Data Flow Components
  • ETL Process Implementation using SSIS Packages (loading Dimension and Fact Tables)
  • Data Quality Assessment
  • Managing Changing Data Using Slowly Changing Dimension Transformation Component, Change Data Capture Mechanism and MERGE Statement

180 minutes 300
Module 4

Managing Business Data Using SQL Server 2012 EIM Functionality
  • SQL Server EIM (Enterprise Information Management) Solutions
  • Data Integration and Data Cleansing Using Data Quality Services
  • Central Data Management Using Master Data Services
  • DQS, MDS and SSIS Integration

120 minutes 300
Module 5

BISM Model
  • Overview of Microsoft BISM Model (BI Semantic Model)
  • Multi-Dimensional (Traditional) Model and its Components
  • Tabular Model and its Components
  • Comparison and Choice of Appropriate Model
  • Programming SSAS Server

60 minutes 300
Module 6

Designing and Creating Databases in the Multidimensional Model
  • Data Sources
  • Data Source Views
  • Measures and Measure Groups
  • Relationships
  • Implementation of the Model (Method of Storing Dimensions and Groups of Measures, Partitioning, Aggregations)

180 minutes 300
Module 7

Designing and Creating Data Mining Models
  • Preparing Source Data
  • Data Mining Techniques
  • Creating Models in BIDS/SSDT Environment
  • Microsoft Data Mining Algorithms
  • Assessment and Improvement of Data Mining Models

180 minutes 300
Module 8

Designing and Creating Databases in the Tabular Model
  • Data Sources, Measures, Computed Columns, Relationships, Partitioning, Perspectives and Constraints
  • xVelocity(VertiPaq) and DirectQuery Working Modes
  • Transformation from a PowerPivot Model to an Analysis Services Project in the Tabular Mode
  • Extensions of BISM Model in the Tabular Mode

180 minutes 300
Module 9

BI Languages
  • MDX Expressions and Queries
  • Calculations in Multidimensional Cubes
  • Adding Actions to Multidimensional Cubes
  • Named Datasets and Key Performance Indicators (KPI)
  • DMX Predictive Queries
  • DAX Expressions and Queries
  • Adding Measures, Key Performance Indicators and Computed Columns to Tabular Models
  • Using Hierarchies in the Tabular Mode
  • Creating User Perspectives and Constraints

210 minutes 400
Module 10

Implementation and Management of DW/BI System
  • Implementing Analysis Databases
  • Implementing SSIS Packages
  • Monitoring of DW/BI System
  • Optimizing DW/BI System
  • Security and User Access Control

210 minutes 300
Module 11

Providing Users with Access to a DW/BI System
  • Access via Excel
  • Access via SSRS Service Reports
  • Work with Models Using PowerPivot
  • Data Visualization Using PowerView Data Visualization Using PerformancePoint Services – Reports, Scorecards, Key Performance Indicators, Dashboards

240 minutes 300

Form

Ask Question

Register