Business Intelligence Masters Program

Module 01 – Introduction to SQL
Module 02 – Database Normalization and Entity Relationship Model
Module 03 – SQL Operators
Module 04 – Working with SQL: Join, Tables, and Variables
Module 05 – Deep Dive into SQL Functions
Module 06 – Working with Subqueries
Module 07 – SQL Views, Functions, and Stored Procedures
Module 08 – Deep Dive into User-defined Functions
Module 09 – SQL Optimization and Performance
Module 10 – Advanced Topics
Module 11 – Managing Database Concurrency
Module 12 – Programming Databases Using Transact-SQL
Module 13 – Microsoft Courses: Study Material

Tools covered

Power BI

24 Hours 8 Module

Module 01 – INTRODUCTION TO POWER BI
Module 02 – DATA EXTRACTION
Module 03 – DATA TRANSFORMATION – SHAPING & COMBINING DATA
Module 04 – DATA MODELLING & DAX
Module 05 – DATA VISUALIZATION WITH ANALYTICS
Module 06 – POWER BI SERVICE (Cloud), Q & A AND DATA INSIGHTS
Module 07 – POWER BI SETTINGS, ADMINISTRATION & DIRECT CONNECTIVITY
Module 08 – EMBEDDED POWER BI WITH API & POWER BI MOBILE
Module 09 – POWER BI ADVANCE & POWER BI PREMIUM

Tools covered

Azure Data Factory

30 Hours 9 Module

Module 01 – Non-Relational Data Stores and Azure Data Lake Storage
Module 02 – Data Lake and Azure Cosmos DB
Module 03 – Relational Data Stores
Module 04 – Why Azure SQL?
Module 05 – Azure Batch
Module 06 – Azure Data Factory
Module 07 – Azure Data Bricks
Module 08 – Azure Stream Analytics
Module 09 – Monitoring & Security

Tools covered

Tableau Desktop 10

30 Hours 13 Module

Module 01 – Introduction to Data Visualization and The Power of Tableau
Module 02 – Architecture of Tableau
Module 03 – Charts and Graphs
Module 04 – Working with Metadata and Data Blending
Module 05 – Advanced Data Manipulations
Module 06 – Working with Filters
Module 07 – Organizing Data and Visual Analytics
Module 08 – Working with Mapping
Module 09 – Working with Calculations and Expressions
Module 10 – Working with Parameters
Module 11 – Dashboards and Stories
Module 12 – Tableau Prep
Module 13 – Integration of Tableau with R

Tools covered

Informatica Developer & Admin

42 Hours 36 Module

Module 01 – Data Warehousing and Cleansing Concepts
Module 02 – Informatica Installation and Configuration
Module 03 – Working with Active and Passive Transformation
Module 04 – Working with Expression Transformation
Module 05 – Working with Sorter, Sequence Generator and Filter Transformation
Module 06 – Working with Joiner Transformation
Module 07 – Working with Ranking and Union Transformation
Module 08 – Syntax for Rank and Dense Rank
Module 09 – Router Transformation
Module 10 – Source Qualifier Transformation and Mappings
Module 11 – Slowly Changing Dimension in Informatica
Module 12 – Mapplet and Loading to Multiple Designer
Module 13 – Performance Tuning in Informatica
Module 14 – Repository Manager
Module 15 – Best Practices in Informatica
Module 16 – Workflow Informatica
Module 17 – Parameters and Variables
Module 18 – Error Handling and Recovery in Informatica
Module 19 – High Availability and Failover in Informatica
Module 20 – Working with Different Utilities in Informatica
Module 21 – Flat File Processing (Advanced Transformations)
Module 22 – Dynamic Targeting
Module 23 – Working with Java Transformations
Module 24 – Unconnected Stored Procedure Usage
Module 25 – Advanced Concepts in SCD
Module 26 – Incremental Data Loading and Aggregation
Module 27 – Constraint-based Loading
Module 28 – XML Transformation and Active Lookup
Module 29 – Profiling in PowerCenter
Module 30 – Workflow Creation and Deletion
Module 31 – Database Connection
Module 32 – Relational Database Tables
Module 33 – LinkedIn Connection
Module 34 – Connection with Sources
Module 35 – Pushdown Optimization and Partitioning
Module 36 – Cache Management

Tools covered

Qlik Sense

16 Hours 16 Module

Module 01 – Qlik Sense Introduction and Installation
Module 02 – Qlik Sense Features
Module 03 – Qlik Sense Data Model
Module 04 – Creating a Data Model
Module 05 – Advanced Data Modeling
Module 06 – Qlik Sense Enterprise
Module 07 – Qlik Sense Visualization
Module 08 – Set Analysis
Module 09 – Advanced Set Analysis
Module 10 – Qlik Sense Charts
Module 11 – Advanced Charts
Module 12 – Master Library
Module 13 – Qlik Sense Storytelling
Module 14 – Mashups
Module 15 – Extensions
Module 16 – Security

Tools covered

SQL DBA

16 Hours 6 Module

Module 01 – Installation and Configuration
Module 02 – Managing Instances and Databases
Module 03 – Optimizing and Troubleshooting
Module 04 – Managing Data
Module 05 – Implementing Security
Module 06 – Implementing High Availability

Tools covered

Data warehousing & Data Modeling

12 Hours 8 Module

Module 01 – Introduction to Data Warehouse
Module 02 – Architecture of Data Warehouse
Module 03 – Data Modeling concepts
Module 04 – Data Normalization
Module 05 – Dimension & Fact Table
Module 06 – SQL parsing, Cubes & OLAP
Module 08 – Forward & Reverse Engineering (self paced)

MSBI

30 Hours 29 Module

MSBI SSIS Course Content

Module 01 – What is BI?
Module 02 – ETL Overview
Module 03 – Working with Connection Managers
Module 04 – Data Transformations
Module 05 – Advance Data Transformation
Module 06 – Slowly Changing Dimensions
Module 07 – Overview of Fuzzy Look-up Transformation and Lookup and Term Extraction
Module 08 – Concepts of Logging & Configuration

MSBI SSRS Course Content

Module 09 – Introduction to SSRS
Module 10 – Matrix and Tablix Overview
Module 11 – Parameters and Expression
Module 12 – Reports and Charts creation
Module 13 – Dashboard Building
Module 14 – Reports and Authenticity

MSBI SSAS Course Content

Module 15 – Getting started with SSAS
Module 16 – Structures and Processes
Module 17 – Type of Database Relationship
Module 18 – SSAS Cube
Module 19 – Cube: Operations & Limitations
Module 20 – Cube and In-memory Analytics
Module 21 – Data Source View
Module 22 – Dimensions
Module 23 – Measures & Features of Cube
Module 24 – Measures and Features of Cube Cont.
Module 25 – Working with MDX
Module 26 – Functions of MDX
Module 27 – BI Semantic Model
Module 28 – Plan and deploy SSAS
Module 29 – Microsoft Courses ( Self-Paced Course)

Tools covered

Free Career Counselling

We are happy to help you 24/7

Project Work

Projects will be a part of your Business Intelligence Master’s program to consolidate your learning. It will ensure that you have real-world experience in BI.

Practice 100+ Essential Tools

Get Real-world Experience

Query a Large Relational Database

This interesting project on relational databases allows the learners practical know-how to work with various data types, table basics, SQL functions, and SQL operators to acquire the customer details through database querying.

SQL Server Management

As a part of the project, administer the Microsoft SQL Server Database and work with the architecture of MS SQL Server, the enterprise edition of SQL Server, and various tools of SQL Server to create and modify databases.

Design a Relational Database

As a part of the project, learn to successfully design a relational database and convert relational design, consisting of the details of the various users, user accounts and user roles, etc., in the SQL Server table.

Data Calculations DAX

Design a dashboard and successfully perform calculations by making use of the Power BI DAX formulae Also, as a part of the project, the scheduled deliveries of loads need to be analyzed using correlation across measures.

Work with the Customer Data of the UK Bank

This real-life based project has been included to let learners analyze and create a dashboard to gain insight from the UK bank’s customer data. Build an asymmetric drop-down consisting of the region and the corresponding user details.

Deal with Financial Data

This project requires learners to analyze global sales and profit by developing an interactive map. It also helps the learners to practically understand how to use map styles and layers for enhanced visualization.

Work with Agricultural Data

As a part of the project, learners will have to display district-wise data to successfully build an interactive treemap with state labels. Also, the districts must be displayed on hovering over the respective states.

Informatica ETL Deployment

This project, based on Informatica ETL deployment, lets learners access the data from multiple sources, manage current and historic data with SCD, import source, and target tables, etc. Also, extract the data and fetch it into staging.

Create Azure Data Factory to find the Popular YouTube Channels

This real-life based project on YouTube requires learners to fetch the list of videos from the YouTube channels dataset with the highest views and likes to promote advertisements on the channel with maximum traffic.

Identify the Global Mortality Rate Due to COVID-19

The project aims at identifying the mortality rate by COVID-19 at a global level. Analyze and create a dashboard to gain insights into the COVID-19 cases. Use a world map to compare the confirmed cases and death cases worldwide.

Comparative Analysis with Qlik Sense

This project requires learners to effectively work with the Qlik Sense dashboard that displays the sales details order-wise, year-wise, customer-wise, or product-wise, and so on, doing a successful comparative analysis.

Visual Mapping between Vaccination rate and Measles outbreak

This is one of the most popular projects in the domain. Plot measles outbreaks as per the population. Plot measles infection cases before 1st dose, between 1st and 2nd dose, and after the 2nd dose of measles vaccination.

Career Transition

Vishal Sharma

Senior Analyst | India

30% Salary Hike & Internal Role Transition

I was able to successfully make an internal transition from a Business Analyst to a Senior Analyst. The training has helped me effectively execute the projects in my organization. I am glad to have chosen Intellipaat.

Business Analyst

Senior Analyst

Mandip Dobariya

Sr. Full Stack Engineer | Gujrat

20% Salary Hike

The best result of the program was when I got promoted to a Lead role with a salary hike. Intellipaat’s training has helped me gain skills to handle projects single-handedly.

Full Stack Engineer

Sr. Full Stack Engineer

Er. Sushil Kuvind

Software Engineer | MP

100% Salary Hike

Intellipaat training helped me make a career switch from a Developer to a Software Engineer with a 100% hike even during the pandemic. The best part was the job assistance and mentoring sessions.

Developer

Software Engineer

Rishabh Johri

Senior Project Manager | Delhi

Promotion with 40% Salary Hike

Post enrolling in the course, I gained skills that have made me more confident to face the interviews and I was promoted to Sr. Project Manager. Intellipaat is the best place to get conceptual knowledge.

Project Manager

Senior Project Manager

Somika Simlote

Senior Software Engineering Lead | India