MSBI Online Training Ameerpet Hyderabad

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
  • Data Marts and Star Schema Design
  • Design of Dimension and Facts
  • Definition of Star Schema
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Type of Facts
  • Conformed Dimensions
  • MSBI Online Training  Ameerpet Hyderabad
  • Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
  • Types of Loads
  • First Time Load
  • Full Load
  • Incremental Load

MSBI 2014
I) SQL Server Integration Services (SSIS)
1. Introduction to SQL Server Integration
Services
1. Product History
2. SSIS Package Architecture Overview
3. Development and Management Tools
4. Deploying and Managing SSIS Packages
5. Source Control for SSIS Packages
2. SQL Server Data Tools(Visual Studio)
1. Launching Data tools
2. Project templates
3. The package designer
4. The Toolbox
5. Solution Explorer
6. The Properties window
7. The Variables window
8. The SSIS menu
3. Introduction to Control Flow
1. Control Flow Overview
2. Precedence Constraints
3. The Execute SQL Task
4. The Bulk Insert Task
5. The File System Task

6.MSBI Online Training  Ameerpet Hyderabad

7. The FTP Task
8. The Send Mail Task

4. Advanced Control Flow
1. Containers – grouping and looping
2. The Analysis Services tasks
3. The Execute Process Task
4. The Execute Package Task

5. Introduction to Data Flow
1. Data Flow Overview
2. Data Sources
3. Data Destinations
4. Data Transformations
5. The Copy Column Transformation
6. The Derived Column Transformation
7. The Data Conversion Transformation
8. The Conditional Split Transformation
9. The Aggregate Transformation
10. The Sort Transformation
11. Data Viewers
6. Variables and Configurations
1. Variables Overview
2. Variable scope
3. SSIS system variables
4. Using variables in control flow
5. Using variables in data flow
6. Using variables to pass information between packages

7. Debugging, Error Handling and Logging
1. SSIS debugging overview
2. Breakpoints in SSIS
3. SSIS debugging windows
4. Control Flow: The On Error event handler
5. Data Flow: Error data flow
6. Configuring Package Logging

8. Advanced Data Flow
1. The Lookup Transformation
2. Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
3. The Multicast Transformation
4. The Slowly Changing Dimension Transformation

9. Extending SSIS through Custom Code
1. Introduction to SSIS scripting
2. The SSIS script editor

  1. The SSIS object model
  2. Script in Control flow: The Script Task
  3. Script in Data flow: The Script Component
  4. Introduction to SSIS component development
  1. SSIS Package Deployment
  2. Configurations and deployment
  3. Managing packages with DTutil
  4. Managing packages with SQL Server Management Studio
  1. II) SQL Server Reporting Services (SSRS)
  1. Introducing SQL Server Reporting Services
  2. Features
  3. Reporting Services Architecture
  4. Reporting Services Terminology
  5. Reporting Services Editions
  1. Creating Reports
  2. Shared Data Sources
  3. Creating Reports from Scratch
  1. Calculations and Formatting
  2. Reporting Services Items
  3. Basic Expressions
  4. Using the Global Collections
  5. Formatting Fields
  6. Conditional Formatting
  1. Grouping and Sorting
  2. Creating Groups
  3. Interactive Sorting
  4. Creating Drill-Down Reports
  5. Calculating Totals and Percentages
  1. Report Parameters
  2. Creating Report Parameters
  3. Binding Report Parameters to Dataset Parameters
  4. Creating Drop-Down Parameters
  5. Multi-Valued Parameters
  1. Creating Matrix Reports and Charts
  2. Creating a Basic Matrix Report
  3. Matrix Subtotals
  4. Creating Chart Reports
  5. Exploring the Charting Possibilities
  6. Charting Add-ons
    1. Managing Reporting Services
    2. Using the Web-Based Report Manager
    3. Using SQL Server Management Studio- based Reporting Services Manager
    4. Deploying Reports and Data Sources
    1. Reporting Services Security
    2. Reporting Services Security
    3. Managing Roles
    1. Distributing Reports via Subscriptions
    2. How Subscriptions Work
    3. Creating Standard Subscriptions
    4. Creating Data-Driven Subscriptions
    5. Managing Subscriptions
    1. Ad-Hoc Reporting with Report Builder
    2. The Report Builder Architecture
    3. Creating Report Model Projects
    4. Running Report Builder

    III) SQL Server  Analysis Services (SSAS)

    1. Introduction to Microsoft SQL Server Analysis Services
    2. Overview of Data Analysis Solutions
    3. Overview of SQL Server Analysis Services.
    4. Installing SQL Server Analysis Services.
    1. Creating Multidimensional Analysis Solution
    2. Developing Analysis Services Solutions.
    3. Data Sources and Data Source Views
    4. Creating a Cube
    1. Working with Dimensions
    2. Configuring Dimensions
    3. Defining Hierarchies
    4. Sorting and Grouping Attributes
    1. Working with Measures and Measure Groups
    2. Working with Measures.
    3. Working with Measure Groups.
    1. Querying Multidimensional Analysis Solutions
    2. MDX Fundamentals
    3. Adding Calculations to a Cube

If You Want More Courses Click Here

Find out if YOU are a candidate

IELTS Coaching

IELTS Coaching

SKILLS TRAINING

SKILLS TRAINING

Imigration to Canada

Imigration to Canada

Visa Guidance

Visa Guidance

MSBI Online Training Ameerpet Hyderabad

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
  • Data Marts and Star Schema Design
  • Design of Dimension and Facts
  • Definition of Star Schema
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Type of Facts
  • Conformed Dimensions
  • MSBI Online Training  Ameerpet Hyderabad
  • Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
  • Types of Loads
  • First Time Load
  • Full Load
  • Incremental Load

MSBI 2014
I) SQL Server Integration Services (SSIS)
1. Introduction to SQL Server Integration
Services
1. Product History
2. SSIS Package Architecture Overview
3. Development and Management Tools
4. Deploying and Managing SSIS Packages
5. Source Control for SSIS Packages
2. SQL Server Data Tools(Visual Studio)
1. Launching Data tools
2. Project templates
3. The package designer
4. The Toolbox
5. Solution Explorer
6. The Properties window
7. The Variables window
8. The SSIS menu
3. Introduction to Control Flow
1. Control Flow Overview
2. Precedence Constraints
3. The Execute SQL Task
4. The Bulk Insert Task
5. The File System Task

6.MSBI Online Training  Ameerpet Hyderabad

7. The FTP Task
8. The Send Mail Task

4. Advanced Control Flow
1. Containers – grouping and looping
2. The Analysis Services tasks
3. The Execute Process Task
4. The Execute Package Task

5. Introduction to Data Flow
1. Data Flow Overview
2. Data Sources
3. Data Destinations
4. Data Transformations
5. The Copy Column Transformation
6. The Derived Column Transformation
7. The Data Conversion Transformation
8. The Conditional Split Transformation
9. The Aggregate Transformation
10. The Sort Transformation
11. Data Viewers
6. Variables and Configurations
1. Variables Overview
2. Variable scope
3. SSIS system variables
4. Using variables in control flow
5. Using variables in data flow
6. Using variables to pass information between packages

7. Debugging, Error Handling and Logging
1. SSIS debugging overview
2. Breakpoints in SSIS
3. SSIS debugging windows
4. Control Flow: The On Error event handler
5. Data Flow: Error data flow
6. Configuring Package Logging

8. Advanced Data Flow
1. The Lookup Transformation
2. Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
3. The Multicast Transformation
4. The Slowly Changing Dimension Transformation

9. Extending SSIS through Custom Code
1. Introduction to SSIS scripting
2. The SSIS script editor

  1. The SSIS object model
  2. Script in Control flow: The Script Task
  3. Script in Data flow: The Script Component
  4. Introduction to SSIS component development
  1. SSIS Package Deployment
  2. Configurations and deployment
  3. Managing packages with DTutil
  4. Managing packages with SQL Server Management Studio
  1. II) SQL Server Reporting Services (SSRS)
  1. Introducing SQL Server Reporting Services
  2. Features
  3. Reporting Services Architecture
  4. Reporting Services Terminology
  5. Reporting Services Editions
  1. Creating Reports
  2. Shared Data Sources
  3. Creating Reports from Scratch
  1. Calculations and Formatting
  2. Reporting Services Items
  3. Basic Expressions
  4. Using the Global Collections
  5. Formatting Fields
  6. Conditional Formatting
  1. Grouping and Sorting
  2. Creating Groups
  3. Interactive Sorting
  4. Creating Drill-Down Reports
  5. Calculating Totals and Percentages
  1. Report Parameters
  2. Creating Report Parameters
  3. Binding Report Parameters to Dataset Parameters
  4. Creating Drop-Down Parameters
  5. Multi-Valued Parameters
  1. Creating Matrix Reports and Charts
  2. Creating a Basic Matrix Report
  3. Matrix Subtotals
  4. Creating Chart Reports
  5. Exploring the Charting Possibilities
  6. Charting Add-ons
    1. Managing Reporting Services
    2. Using the Web-Based Report Manager
    3. Using SQL Server Management Studio- based Reporting Services Manager
    4. Deploying Reports and Data Sources
    1. Reporting Services Security
    2. Reporting Services Security
    3. Managing Roles
    1. Distributing Reports via Subscriptions
    2. How Subscriptions Work
    3. Creating Standard Subscriptions
    4. Creating Data-Driven Subscriptions
    5. Managing Subscriptions
    1. Ad-Hoc Reporting with Report Builder
    2. The Report Builder Architecture
    3. Creating Report Model Projects
    4. Running Report Builder

    III) SQL Server  Analysis Services (SSAS)

    1. Introduction to Microsoft SQL Server Analysis Services
    2. Overview of Data Analysis Solutions
    3. Overview of SQL Server Analysis Services.
    4. Installing SQL Server Analysis Services.
    1. Creating Multidimensional Analysis Solution
    2. Developing Analysis Services Solutions.
    3. Data Sources and Data Source Views
    4. Creating a Cube
    1. Working with Dimensions
    2. Configuring Dimensions
    3. Defining Hierarchies
    4. Sorting and Grouping Attributes
    1. Working with Measures and Measure Groups
    2. Working with Measures.
    3. Working with Measure Groups.
    1. Querying Multidimensional Analysis Solutions
    2. MDX Fundamentals
    3. Adding Calculations to a Cube

If You Want More Courses Click Here

WHY CHOOSE i2C CONSULTANCY

Our promoters being passionate, experienced, and dedicated academicians with immense exposure of more than 25 years in India and Canada can help potential aspirants realise their dreams of settling in Canada.

Being a Canadian resident, our chairman has been associated with the Canadian Ministry of Education, Universities and Colleges of Canada for the past 13 years.

Read More >

OUR SERVICES

  • Students Study Visa
  • Visitors Visa guidance
  • IELTS Coaching
  • IT Training
  • Financial Assistance
  • Employability Skills Training
  • Campus Recruiting Training

OUR LOCATION

i2C Education & Immigration
#410, Nilgiri Block, Aditya Enclave, Ameerpet, Hyderabad - 500038,

040 4852 7978, +99 1212 0040, 99 1212 0050

+1 416 495 6922, +1 647 961 6047