Microsoft Business Intelligence Masters Program

About the Course

Business Intelligence Masters Program makes you proficient in tools and systems used by Business Intelligence Professionals. It includes in-depth training on Data Warehousing and BI, Teradata, Informatica, Microsoft BI and Tableau. The curriculum has been determined by extensive research on 5000+ job descriptions across the globe.

 JOIN THE COURSE

Learning Plan

  • Data Warehousing and BI Certification Training |

    Introduction to Data Warehouse & Business Intelligence
    Learning Objectives – In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling.

    Topics – What is Data Warehousing?, Definitions by W.H. Inmon [Top-Down Design], Ralph Kimball [Bottom-Up Design], Inmon Vs Ralph Kimball, Data Warehousing Tools, Schema Modeling Tools, CA, ERwin, Dell Toad Data Modeler, Oracle Data Modeler, ETL Tools: Informatica Power Center, Talend DI Open Studio, IBM Data Stage, SAS, Data Warehousing categories. What is BI – Business Intelligence?, BI Definition, BI Tools, Classification of BI Tools.

    Data Warehouse Architecture
    Learning Objectives – In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e., Production Data into Relational, Flat File and various legacy system to Staging Area and finally into the Data Warehousing/Data Mart for presentation layer.

    Topics – Relational Vs Analytical. What are – OLTP, OLAP, OLAP categories – MOLAP, ROLAP, HOLAP, Data Warehouse Vs Data Mart, Dependent and Independent Data Mart, Data Warehouse Architecture, Source System, ETL Extraction, Transformation. What is a cube?, Benefits of cube?, How to create the cube?, How to deploy a cube?, How to create a report using a cube?

    Data Warehouse Dimension & Fact Tables
    Learning Objectives – In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension – Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact – Granularity for the fact data and also talks about the Measure Type.

    Topics – DIMENSION TABLE – What is a Dimension Table?, Dimension table categories, FACT TABLE – What is Fact Table?, Fact Table Granularity, Fact Table categories.

    Data Modeling
    Learning Objectives – In this module, you will learn about What is Data Normalization and their 3 types of forms. Here you learn about the type of dimensional modeling, benefits, principles and characteristics

    Topics – What is Data Normalization?, Data Normalization Rules – 1NF, 2NF, 3NF, Data De-Normalization, Dimensional Modeling – What is DM?, Principles, Benefits, Type and Technique.

    Building Data Warehouse with ERwin
    Learning Objectives – In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERwin r9.

    Topics – Source System Understanding, Future Data Requirement and Understanding, Designing and Developing Dimension Table, Designing and Developing Fact Table Designing and Developing ER Model With ERwin, Designing and Developing Entity Relationship Modeling.

    Introduction to Open Source ETL Tool Talend DI Open Studio 5.x
    Learning Objectives – In this module, you will learn about the open source and commercial ETL Tools available into the market and it various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations.

    Topics – Open source ETL Talend DI Open Studio -Difference between Licensed and Open Source ETL Tools, What are Licensed and Open Source ETL Tools, Working with ETL Transformation in Talend Open DI Studio.

    Building ETL Project With Talend DI Open Studio 5.x
    Learning Objectives – In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD[Business Requirement Document] and TDD [Technical Design Document] and its uses.

    Topics – Building ETL Project Talend DI Open Studio, Understanding the Data Source System which will be a future Data Requirement, Identify Business Requirement Gathering, Building the ETL Talend Technical Design Document, Building an ETL Project.

    Introduction to Data Visualization BI Tool Tableau 9.x
    Learning Objectives – In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions.

    Topics – Data Visualization BI Tool : Tableau 9.x-Introduction to Data Visualization with Tableau, Exploring Data Visualization with Tableau. What is Data Visualization?, Exporting Data and Working With Tableau.

    Building Data Visualization BI Project With Tableau 9.x
    Learning Objectives – In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirement.

    Topics – Building Data Visualization BI Project With Tableau 9.x, BI Reporting Understanding, Report and Dashboard Template Document, Tableau Design and Development Database Source Connection.

    An Integrated Data Warehousing & BI Project
    Learning Objectives – This is an integrated Data Warehousing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments.

    Topics – An Integrated Data Warehousing & BI Project, Developing a Data Warehouse and BI Project, Source System understanding today’s data that will be the future data requirement, Identify the Business Requirement Gathering, Report and Dashboard Template Document, Designing and Developing Models, Designing and Developing the Staging Area, Finalizing the Dimension Modeling Type, Designing and Developing Dimension Modeling

  • Teradata Certification Training|   

    Teradata – An Overview
    Learning Objectives – In this module, you will understand basic relational concepts and overview of Teradata such as its History, Comparison with other RDBMS, Architecture, Components (PE, BYNET, AMP), Interaction between components, Storage and Retrieval architecture, Connectivity with Mainframe and advanced architecture.

    Topics – Basic Relational Concepts, What is Teradata, Competitive advantages over other RDBMS, Teradata Architecture, Teradata Components, How components Interact with each other, How Data is stored and Retrieved, Connectivity with Mainframe and Network Applications, Tools & Utilities, Teradata Unified Data Architecture.

    Teradata Indexes and Join Strategies
    Learning Objectives- In this module, you will learn about various indexing concepts in Teradata and how they affect storage and retrieval of data. You will understand the importance of Primary index and how it affects the storage of data, Use of secondary and Partition Primary index in fast retrieving data. You will also learn the hashing algorithm in detail and various join strategies used by Teradata to join tables.

    Topics – Difference between Primary Key and Primary Index, Primary Index and types, How primary index is used in data distribution and retrieval, Secondary index and its types, Data retrieval using secondary Index, Partition primary index and its types, Advantage of PPI , Join strategies, How data is redistributed for Join processing.

    Teradata SQL
    Learning Objectives – In this module, you will learn about SQL commands used in Teradata. You will learn to create/alter/drop database objects and perform various SQL operations on the data stored in Teradata tables.

    Topics – Data types, DDL Statements (CREATE, ALTER, DROP) , DML Statements (Insert, Delete, Update), DCL Statements (Grant, Revoke), Order by, Group by, Distinct, SET Operators, Logical & Conditional Operators, String functions, Cast & Format functions, HELP and Show Functions, Date Functions, Built-In Functions, Aggregation, Joins (INNER and OUTER).

    Data Protection
    Learning Objectives – In this module, you will learn about various data protection mechanism provided in Teradata. You will learn how AMP failure, Node failure, Transaction failure and Disk failures are handled.

    Topics – Transaction locks, Fallback tables, Clusters, Permanent Journal, Down AMP Recovery Journal, Transient Journal, Cliques, Hot Standby nodes, RAID 1 & RAID 5, Data Dictionary.

    SQL Advanced
    Learning Objectives – In this module, you will learn more about SQL Commands in Teradata. You will learn how to use sub queries, using OLAP functions, Transaction modes and temporary tables. You will learn to understand Explain statement and collect statistics.

    Topics – Sub queries, Upsert, Case, Coalesce, Nullif, OLAP Functions, Rank & Row Number, Transaction Modes, Temporary Tables (Derived, Volatile and Global Temporary), Explain, Collect Statistics.

    Advanced Database objects and performance optimization
    Learning Objectives – In this modules, you will learn about additional database objects such as views, Macros, Stored Procedure and Join Index. You will also explore common performance tuning options.

    Topics – Views, Macros, Stored Procedure, Join Index, Performance Tuning tips.

    Teradata Utilities – FastLoad, MultiLoad, BTEQ
    Learning Objectives – In this module, you will learn about some of the Application utilities provided by Teradata. You will learn how FastLoad and MultiLoad are used to import data into Teradata. Also, you will understand using BTEQ to submit SQL queries.

    Topics – What is FastLoad, How FastLoad loads data, How to restart failed FastLoad jobs, What is MultiLoad and how MultiLoad works, Using MultiLoad to insert/update/delete data from Teradata tables , Using BTEQ to import/export data.

    Teradata Utilities – FastExport,TPT
    Learning Objectives – In this module, you will learn about the FastExport and TPT utilities

    Topics – FastExport Exporting data from Teradata , TPT overview, TPT Export, TPT SQL Selector, TPT Load, TPT Update Comparison of Load/Unload Utilities.

  • Informatica Training & Certification|  

    Informatica PowerCenter 10 – An Overview
    Goal : In this module, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Product, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor. We will also discuss the installation of Informatica in this module.

    Objectives :
    Explain Informatica & Informatica Product Suite
    Explain the purpose of PowerCenter as ETL Tool
    Describe PowerCenter Architecture
    Explain component-based development techniques in PowerCenter
    Explain the new features of Informatica 10.X over 9.X
    Topics :

    Informatica & Informatica Product Suite
    PowerCenter as ETL Tool
    PowerCenter Architecture
    Component-based development techniques
    Hands On/Demo :

    Installation of the Product in Windows and using Oracle as Database
    Creation of the services and connecting the client with the server
    Data Integration and Data Warehousing Fundamentals
    Goal : In this module, we will discuss about different Data Integration Concepts. You will be introduced to the concepts – Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing.

    Objectives :
    Explain Data Integration concepts
    Understand Data Profile and Data Quality
    Describe ETL Architecture & Process flow
    Describe different ETL methods & Tools
    Explain Data Warehouse Concepts & Architecture
    Topics :

    Data Integration Concepts
    Data Profile and Data Quality Management
    ETL and ETL architecture
    Brief on Data Warehousing
    Hands On/Demo :

    Look through the properties of the services required
    Shutdown and start-up of the services from the Administration Console
    Creation and execution of a simple pass through mapping.
    PowerCenter Transformations
    Goal : In this module, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping.

    Objectives :
    Describe & Visualize PowerCenter Client Tools
    Understand basics of Data Flow
    Explain how to create & Execute mapping
    Explain different Transformations & their usage
    Topics :

    Visualize PowerCenter client tools
    Data Flow
    Create & execute mapping
    Transformations & their usage
    Hands On/Demo :

    Use multiple transformations inside the mapping to resolve different use cases
    Look at the properties of the transformations to customize them
    PowerCenter Tasks & Workflows
    Goal : In this module, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow.

    Objectives :
    Explain PowerCenter Workflow Manager
    Describe Flow within a Workflow
    Describe Reusability & Scheduling in Workflow Manager
    Understand components of Workflow Monitor
    Explain Workflow Task and job handling
    Topics :

    PowerCenter Workflow Manager
    Flow within a Workflow
    Reusability & Scheduling in Workflow Manager
    Components of Workflow Monitor
    Workflow Task and job handling
    Hands On/Demo :

    Create tasks, workflow
    Configure workflow properties
    Schedule a workflow
    Advanced Transformations, Techniques & Reusability Features
    Goal : Advanced Transformation techniques will equip you to deal with advanced concepts of PowerCenter transformations like, Java, XML etc. of PowerCenter. We will also discuss about transaction processing & reusability features available in Informatica.

    Objectives :
    Understand the uses of advanced transformations like Java, SQL, Normalizer
    Explain the XML File Processing & Transaction Processing
    Use different error handling features
    Use Advanced Functions, Regular Expressions to cleanse the data
    Learn about the reusability features
    Topics :

    Advanced transformations (Java, SQL, Normalizer)
    XML File Processing & Transaction Processing
    Error handling features
    Cleaning the data (Advanced Functions, Regular Expressions)
    Reusability features
    Hands On/Demo :

    Use of advanced transformations like XML Processing, Union etc.
    Use of inbuilt and custom functions to fulfil the data transformation needs.
    Reusable transformations, Sessions, Mapplets, etc.
    ETL Scenarios using Informatica
    Goal : We will discuss about advanced ETL scenarios using Informatica. You will be introduced to the concepts – Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change data Capture) etc. We will also discuss about creating Data Warehouse related processes like SCD, Fact and Dimension Loading.

    Objectives :
    Implement advanced concepts like Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
    Implement advanced techniques using Flat File, XML File
    Implement techniques for loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
    Implement other advanced concepts using Informatica PowerCenter
    Topics :

    Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
    Advanced techniques – Flat File, XML File
    Loading Dimensional Tables (SCD-1, SCD-2, SCD-3
    Hands On/Demo :

    Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
    Advanced techniques – Flat File, XML File
    Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
    Service & Support of PowerCenter Environment
    Goal :
    This module will help you understand the features provided by Informatica to debug, troubleshoot & handle error to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options and for tasks and workflows will be discussed along with the recommended best practises to the operations process.

    Objectives :
    Describe basic PowerCenter Error
    Follow a basic troubleshooting methodology
    Use the debugger
    Use Workflow and Session logs to diagnose errors
    Recognize & repair Connection Errors & Network errors
    Understand the recovery scenarios & mechanisms
    Configure Workflow & sessions for recovery
    Understand the purpose of High Availability
    Monitor the PowerCenter Environment
    Topics :

    PowerCenter Error
    Basic troubleshooting methodology
    Debugger
    Workflow and Session logs to diagnose errors
    Connection Errors & Network errors
    Recovery scenarios & mechanisms
    Configure workflow & sessions for recovery
    High Availability
    PowerCenter Environment
    Hands On/Demo :

    Perform troubleshooting of Informatica errors.
    Use of Debugger to debus a mapping
    Perform workflow and session recovery and related configuration needed for that
    Performance Tuning, Design Principles & Caches
    Goal : This module will highlight the performance aspects of Informatica PowerCenter components and the efficient usage of them. We will also discuss about the best practises suggested by Informatica for optimum performance of your ETL process.

    Objectives :
    Understand the Performance Tuning Methodology
    Learn Mapping design tips & tricks
    Explain Caching & Memory Optimization
    Learn Partition & Pushdown Optimization
    Explain Design Principles & Best Practices
    Topics :

    Performance Tuning Methodology
    Mapping design tips & tricks
    Caching & Memory Optimization
    Partition & Pushdown Optimization
    Design Principles & Best Practices
    Hands On/Demo :

    Identify the bottlenecks
    Different configurations needed to resolve the bottlenecks
    Learn tips and tricks to code efficient mappings
    Cache and DTM buffer memory configuration
    PowerCenter Repository Management
    Goal : This module will introduce you to the usage and components of PowerCenter repository manager and managing the repository effectively.

    Objectives :
    Recognize and explain the functionalities of the Repository Manager tool
    Describe how to create and delete folders using the Repository Manager tool
    Illustrate how to migrate components using Repository Manager tool
    Learn PowerCenter Repository Maintenance
    Topics :

    Repository Manager tool (functionalities, create and delete, migrate components)
    PowerCenter Repository Maintenance
    Hands On/Demo :

    Get acquainted with the repository manager tool and its functionalities
    Creation and editing of a Folder
    Copy Informatica objects
    Historical view of session and workflow statistics
    Informatica Administration & Security
    Goal : This module will give you an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. We will also discuss about the command line utilities and use them to manage the domain and repository, start and control workflows.

    Objectives :
    Explain the new features of PowerCenter 10
    Explain an overview of the PowerCenter Administration Console
    Recognize and explain the integration and repository service properties
    Identify how to handle services in the Administration Console
    Explain how to handle locks through the Administration Console
    Illustrate how to create users and groups
    Topics :

    Features of PowerCenter 10
    Overview of the PowerCenter Administration Console
    Integration and repository service properties
    Services in the Administration Console (services, handle locks)
    Users and groups
    Hands On/Demo :

    Learn details of different components of Informatica Administration tool
    Create user, group, assign privileges to the users and groups
    Create roles
    Looking at the service logs, taking export of the service logs
    Service maintenance from Administration console
    Command Line Utilities
    Goal : This module will deal with command line part of Informatica PowerCenter.

    Objectives :
    Apply infacmd to domain objects and security
    Apply infasetup to domain objects
    Apply pmcmd to execute and control workflows
    Apply pmrep to manage the PowerCenter Repository
    Explain Automate tasks via command-line programs: why you need these skills/why you need to know
    Topics :

    Infacmd, infasetup, pmcmd, pmrep
    Automate tasks via command-line programs
    Hands On/Demo :

    Use Infacmd, infasetup, pmcmd, pmrep to automate tasks via command-line programs
    Informatica 10 – Technical Architecture
    Goal : This module gives you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.

    Objectives :
    Describe Informatica 10 Architecture
    Explain the application services related to PowerCenter and their related processes
    Understand buffer memory
    Describe Connectivity among the tolls
    Describe Connection pooling used in PowerCenter
    Topics :

    Informatica 10 Architecture
    Application services
    Buffer memory
    Connectivity among the tolls

  • Preparing to Develop the Project Schedule  
    Topic A: Develop a WBS
    Topic B: Create an Activity List
    Topic C: Identify the Relationships between Activities
    Topic D: Identify Resources
    Topic E: Estimate Time

  • Planning Project Costs|  
    Topic A: Estimate Project Costs
    Topic B: Estimate the Cost Baseline
    Topic C: Reconcile Funding and Costs

  • Planning Human Resources and Quality Management 
    Topic A: Create a Human Resource Plan
    Topic B: Create a Quality Management Plan

  • .
  • Planning for Risk 
    Topic A: Create a Risk Management Plan
    Topic B: Identify Project Risks and Triggers
    Topic C: Perform Qualitative Risk Analysis
    Topic D: Perform Quantitative Risk Analysis
    Topic E: Develop a Risk Response Plan

  • .
  • Executing the Project 
    Topic A: Direct the Project Execution
    Topic B: Execute a Quality Assurance Plan
    Topic C: Assemble the Project Team
    Topic D: Develop the Project Team
    Topic E: Manage the Project Team
    Topic F: Distribute Project Information
    Topic G: Manage Stakeholder Relationships and Expectations

  • .
  • Monitoring and Controlling Project Constraints 
    Topic A: Control the Project Scope
    Topic B: Control the Project Schedule
    Topic C: Control Project Costs
    Topic D: Manage Project Quality

  • .
  • Monitoring and Controlling Project Risks
    Topic A: Monitor and Control Project Risks

  • .
  • Closing the Project
    Topic A: Implement Basic System Security
    Topic B: Secure User AccountsTopic A: Troubleshoot System-Based Issues
    Topic C: Troubleshoot Hardware Issues
    Topic D: Troubleshoot Network Connection and Security Issues

  • .

    Class Venue

     This is an online course. Student can join from anywhere in the world. Every student will get dedicated Trainer. Live, Hands on Classes via Remote Instructor

    Watch our Demo Classes

    I have become more aware of Digital Marketing Techniques and it’s importance. With the advice and Guidance of the course leaders I was able to expand my connections within the Digital Marketing industry and to create a professional presence online which enhances my employ-ability. As a result of the course, I have also applied for a variety of work experience placements in the practical Digital Marketing experience and to improve my understanding of a Digital Marketing environment.  Thank You Leaders from Trainmehub.

    The IT course from Trainmehub gave me an opportunity to take risks, explore my potential and develop my self paced strategy. I feel incredibly privileged to have taken part and to be part of the training legacy. Thank you course trainer.

    400
    faculty and staff teaching courses and discussing topics online

    Vinay Kumar

    Phone: 844-874-7137 ; 945-919-3018
    Regional Office: Mall Road Shimla
    Jubliee Hills Rd 10 C, Hyedrabad, India. Pin: 500033