All Courses
×
This advanced certification in business intelligence program by iHUB DivyaSampark, IIT Roorkee will give you mastery of the core concepts of business intelligence. Learn Informatica, Tableau, Power BI, SQL, Data Warehousing, Azure Data Factory and much more through real-time projects and case studies. In this course, you will complete 9 courses and 32 different projects. Enroll today!
Next Cohort starts
Online Bootcamp
Courses
9+
iHUB, IIT Roorkee
Certification
Campus Immersion
iHUB, IIT Roorkee
EMI Starts
at ₹2878/month*
3109
1493
24542
Master the important concepts of business intelligence and data warehousing with this advanced certification in business intelligence course from iHUB DivyaSampark, IIT Roorkee. Work with SQL and carry out performance tuning in data warehouses.
About iHUB DivyaSampark, IIT Roorkee
iHUB DivyaSampark at IIT Roorkee, established under the National Mission on Interdisciplinary Cyber-Physical Systems (NM-ICPS) by the Department of Science and Technology (DST), focuses on fostering innovation in advanced technologies such as AI, ML, and more. The hub plays a pivotal role in technology development, incubation, and startups, particularly in areas like Healthcare,Read More..
55% Average Salary Hike
45LPA Highest Salary
12000+ Career Transitions
300+ Hiring Partners
Career Transition Handbook
*Past record is no guarantee of future job prospects
Identify reusable opportunities and build and maintain business standards with the help of the best practice guidelines.
Manage a team of Developers and Analysts who are skilled in performing various processes of BI for development and implementation.
Manage Tableau and its numerous tasks, including the creation of dashboards, authoring and troubleshooting reports, and data source management.
Document, assist, and organize Data Lake SQL queries.
Audit and review various modeling processes and their results to help in the growth of the business.
Skills to Master
MSBI
MS-SQL
Tableau
Dashboarding
Tableau
Power BI
Power Charts
Informatica
Azure Data Factory
Data Lake
Elastic Pool
SQL DBA
Qlik Sense
Data Warehousing
Data Modeling
SSIS
SSRS
SSAS
Tools to Master
16 Hours 13 Module
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
24 Hours 8 Module
Module 01 – Introduction to Power BI
Module 02 – Data Extraction
Module 03 – Data Transformation – Shaping and Combining Data
Module 04 – Data Modelling & DAX
Module 05 – Data Visualization with Analytics
Module 06 – Power BI Services (Cloud), Q&A, and Data Insights
Module 07 – Power BI Settings, Administration, and Direct Connectivity
Module 08 – Embedded Power BI with API and Power BI Mobile
Module 09 – Power BI Advance and Power BI Premium
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
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
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
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
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
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)
30 Hours 29 Module
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
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
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)
Projects will be a part of your advanced certification in business intelligences program to consolidate your learning. It will ensure that you have real-world experience in BI.
Practice 20+ Essential Tools
Designed by Industry Experts
Get Real-world Experience
Via Intellipaat PeerChat, you can interact with your peers across all classes and batches and even our alumni. Collaborate on projects, share job referrals & interview experiences, compete with the best, make new friends – the possibilities are endless and our community has something for everyone!
Admission Details
The application process consists of three simple steps. An offer of admission will be made to selected candidates based on the feedback from the interview panel. The selected candidates will be notified over email and phone, and they can block their seats through the payment of the admission fee.
Submit Application
Tell us a bit about yourself and why you want to join this program
Application Review
An admission panel will shortlist candidates based on their application
Admission
Selected candidates will be notified within 1–2 weeks
Total Admission Fee
EMI Starts at
We partnered with financing companies to provide competitive finance options at 0% interest rate with no hidden costs
Financing Partners
Admissions are closed once the requisite number of participants enroll for the upcoming cohort. Apply early to secure your seat.
Next Cohorts
| Date | Time | Batch Type | |
|---|---|---|---|
| Program Induction | 15th Dec 2024 | 08:00 PM IST | Weekend (Sat-Sun) |
| Regular Classes | 15th Dec 2024 | 08:00 PM IST | Weekend (Sat-Sun) |
This advanced certification in business intelligence course is a structured learning path especially designed by industry experts, which ensures that you transform into a business intelligence expert. Individual courses at Intellipaat focus on one or two specializations. However, if you have to master business intelligence, then this program is for you.
Intellipaat offer certification training on Business Intelligence courses such as Power BI, Tableau, MSBI, ETL, Informatica, Cognos, Qlikview, SSIS, SSRS, MicroStrategy, SSAS, Data Warehousing, OBIEE, Oracle Hyperion, IBM DataStage, Jaspersoft, Pentaho, Tibco Spotfire, Talend, etc.
3 technical 1:1 sessions per month will be allowed.
Intellipaat offers career services that include 3 guaranteed interviews for all learners enrolled in this course upon movement to the placement pool. Learners will be moved to the placement pool once they clear the PRT (Placement Readiness Test).
Intellipaat is offering 24/7 query resolution, and you can raise a ticket with the dedicated support team at any time. You can avail of email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, 1:1 session support is provided for 6 months from the start date of your course.
Intellipaat is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in a real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry-ready.
You will work on highly exciting projects in the domains of high technology, e-commerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.
Intellipaat provides placement assistance to all learners who have completed the training and moved to the placement pool after clearing the PRT( Placement Readiness Test) More than 500+ top MNCs and startups hire Intellipaat learners. Our Alumni work with Google, Microsoft, Amazon, Sony, Ericsson, TCS, Mu Sigma, etc.
Learners are required to submit the mandatory assignments, project work, and quizzes for receiving the Intellipaat verified certificates.
Apparently, no. Our job assistance program is aimed at helping you land your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final hiring decision will always be based on your performance in the interview and the requirements of the recruiter.
What is included in this course?
