Data Warehousing · BI Live online

Data Warehousing and BI Certification Training

Q: How much does the Data Warehousing and BI course cost?

The Data Warehousing and BI training costs $99, down from the regular $179 (you save 45%). It is a one-time payment in US dollars, and you can pay securely by card or PayPal.

CertOcean's Data Warehousing and BI training is a live, instructor-led online course. You learn in 10 live sessions (30 hours in total) with an expert instructor, work through 9 curriculum modules with hands-on assignments and keep lifetime access to the class recordings.

4.9Rated Excellent on Trustpilot

30 hoursLive training
10 sessionsWith an instructor
9 modules68 topics
Mon, Oct 26Next batch

DWBI Data Warehousing · BILive instructor-led training

$99 ~~$179~~ One-time · USD

You save$8045% off

Enroll now

Not sure yet? Talk to a course advisor

Pass or full refund, in writing
Secure checkout

Course overview

About the Data Warehousing and BI training

Data warehousing and BI training teaches you to design data warehouses, move data into them with ETL and turn that data into reports and dashboards.

Why learn data warehousing and business intelligence?

Data warehouses and BI sit behind most reporting and analytics in modern companies.
You learn the SQL, modeling and ETL skills BI teams use every day.
The course suits freshers starting a data career as well as working professionals.

This course includes

Instructor-led live classes30 hours of live online classes: 10 weekend sessions of 3 hours each.
Real-life case studiesWork on a live project with the AdventureWorks and sales datasets to perform data and reporting analytics.
AssignmentsEvery class is followed by practical assignments, adding up to at least 25 hours of practice.
Lifetime accessKeep lifetime access to all course material, including presentations, quizzes, installation guides and class recordings.
24/7 expert supportOur support team is available 24x7 to answer technical questions.
CertificationComplete the final project to receive CertOcean's Data Warehousing and BI certificate.

What you'll learn in this course

Understand data warehousing, business intelligence and ETL
Design data warehouse architecture with dimension and fact tables
Normalize data and build data models with ERwin
Build ETL jobs with Talend Open Studio
Create reports and dashboards in Tableau
Complete an end-to-end data warehousing and BI project

What is data warehousing and BI certification training?

Data warehousing and BI certification training is a course that teaches you to design, build and report from a data warehouse. You learn structured data modeling and data manipulation, gain practical SQL experience and develop a solid understanding of data warehouse design. By the end, you build a small data warehouse and create dashboards and visual analytics on top of it.

What are the objectives of data warehousing and BI training?

Understand database management, data warehousing and business intelligence, and write the SQL needed to answer business questions
Design data warehouses and build data integration workflows
Know the features of relational database systems used in BI reporting
Understand BI concepts, tools and applications, including OLAP and building visualizations and dashboards

What will you learn in data warehousing and BI training?

By the end of the course, you will understand:

Databases and database management systems (DBMS)
The SQL CREATE TABLE statement and how to populate tables
SQL SELECT and UNION
Code tables that support a business design
ERD symbols
Building business data models
Data modeling problems and alternative designs
Schema conversion
Standardization and normalization
Data warehouse architecture and concepts
Data integration tools and infrastructure
Using data warehousing and BI to support business decisions
Data visualization and dashboard design

What are the prerequisites for data warehousing and BI training?

There are no prerequisites, so anyone can take this course. A good sense of how data supports a business will help you get the most out of it.

What are the system requirements for data warehousing and BI training?

You need a computer with a reliable internet connection. Our 24x7 support team can help with any setup questions.

How do the hands-on data warehousing practicals work?

You do all the projects in a lab environment set up for this course.

What case studies are included in data warehousing and BI training?

Toward the end of the course, you work on projects that build a sales data warehouse and data marts, and run transactional analysis for retail analytics.

Curriculum

Data Warehousing and BI course syllabus

9 modules · 68 topics · 30 hours of live training

Introduction to Data Warehousing and Business Intelligence 11 topics

Learning goal: Understand data warehousing, business intelligence and the main ETL, cloud and BI tools.
What data warehousing is
Inmon vs. Kimball approaches
Data warehousing tools
Schema modeling tools: Toad Data Modeler and Oracle SQL Developer Data Modeler
ETL tools: Informatica, Talend, IBM DataStage and SAS
Cloud data warehouses: Snowflake, Google BigQuery, Amazon Redshift and Microsoft Fabric
ETL vs. ELT
Types of data warehouses
What business intelligence (BI) is
BI tools and how they are classified

Data Warehouse Architecture 11 topics

Learning goal: Learn data warehouse architecture, its source systems and OLAP cubes.
Relational vs. analytical systems
OLTP and OLAP, and the MOLAP, ROLAP and HOLAP types
Data warehouse vs. data mart
Dependent and independent data marts
Data warehouse architecture
Source systems
ETL: extraction and transformation
What a cube is and why it helps
Creating and deploying a cube
Building a report from a cube

Dimension and Fact Tables 6 topics

Learning goal: Learn the types of dimension and fact tables.
What a dimension table is
Types of dimension tables
What a fact table is
Fact table granularity
Types of fact tables

Data Modeling 6 topics

Learning goal: Normalize data and apply dimensional modeling.
What data normalization is
Normalization rules: 1NF, 2NF and 3NF
Denormalization
What dimensional modeling is
Dimensional modeling principles, benefits, types and techniques

Building a Data Warehouse with erwin 7 topics

Learning goal: Build staging and target data warehouses and data marts.
Understanding the source system
Understanding future data requirements
Designing and developing dimension tables
Designing and developing fact tables
Building the ER model with erwin Data Modeler
Designing and developing entity-relationship models

ETL with Talend Studio 8 topics

Learning goal: Compare ETL tools and build an ETL project with Talend Studio.
Open-source vs. licensed ETL tools
Talend today: Talend Open Studio was retired in January 2024, and Talend Studio is now part of Qlik Talend Cloud
ETL transformations in Talend Studio
Understanding the data source system
Gathering business requirements
Writing the ETL technical design document
Building an ETL project

Introduction to Data Visualization with Tableau 6 topics

Learning goal: Learn data visualization and create reports and dashboards in Tableau.
What data visualization is
Data visualization BI tools in the market
Introduction to Tableau
Exploring data visualization with Tableau
Exporting data and working with Tableau

Building a Data Visualization BI Project with Tableau 5 topics

Learning goal: Build reports and dashboards for a BI project in Tableau.
Understanding BI reporting needs
Report and dashboard template documents
Tableau design
Connecting Tableau to a development database

Integrated Data Warehousing and BI Project 8 topics

Learning goal: Build an end-to-end data warehousing and BI project.
Understanding the source system
Gathering business requirements
Report and dashboard template documents
Designing and developing models
Designing and developing the staging area
Choosing the dimensional modeling type
Designing and developing the dimensional model

Get the detailed syllabus

Receive the full module plan, batch timings and a call with an advisor who can answer your exam questions.

Request syllabus Ask on WhatsApp

Upcoming batches

Next Data Warehousing and BI batches

Live online classes with an instructor, 9:00 AM to 5:00 PM Eastern Time (ET).

Weekday batch

Starts Monday, October 26

Starts tomorrow · Live online

Enroll

Weekend batch

Starts Saturday, October 31

Starts in 6 days · Live online

Enroll

Flexible

Need another date or time?

Ask for a private or custom schedule.

Ask us

Sample certificate

Certificate IDCO-2026-48217

Certificate of Completion

This is to certify that

Michael Anderson

has successfully completed 30 hours of live, instructor-led training in

Data Warehousing and BI

October 26, 2026Date of issue Head of Training

Certification

Earn your Data Warehousing and BI certificate

Certificate of completionIssued by CertOcean when you finish the training and assignments.
Show it to employersAdd it to your LinkedIn profile and resume.

Start your certification

Learner reviews

Why learners choose CertOcean

Rated Excellent · 4.9 out of 5 on Trustpilot

The training curriculum was great. CertOcean provided me everything required to obtain my CISM. They're excellent!

Laxmi Haya Vadan KaramcheduUnited States · CISMVerified

Very resourceful company, I passed my PMP exam at first attempt, highly recommended.

IjeomaCanada · PMPVerified

Great training support! Helped me pass several certifications.

Cozumel TyUnited StatesVerified

US, Canada and UK hoursClasses set around your working day
Expert instructorsWorking professionals in your field
Career supportResume and interview help

FAQ

Data Warehousing and BI course FAQs

Can't find your answer? A course advisor can help with the syllabus, batch dates and exam questions.

Chat on WhatsApp Request a callback

How much does the Data Warehousing and BI course cost?

The Data Warehousing and BI training costs $99, down from the regular $179 (you save 45%). It is a one-time payment in US dollars, and you can pay securely by card or PayPal.

What if I miss a data warehousing class?

You can watch the class recording in your LMS, or attend the same session in the next live batch.

Can I get help after completing the course?

Yes. Our support continues after your course ends, so you can keep asking functional and technical questions.

How long is the data warehousing and BI course?

The course has 30 hours of live online classes, run as 10 weekend sessions of 3 hours each, plus at least 25 hours of assignments.

Who can I contact if I have a problem during the course?

Contact our support team, available 24x7. Ask any question about the course and we will resolve it as quickly as possible.

Will I get a certificate after the Data Warehousing and BI training?

Yes. You receive a CertOcean certificate of completion when you finish the training.

Free course consultation

Talk to a Data Warehousing and BI advisor

Share your details and we will send the syllabus, the next batch dates and the best plan for your exam date.

1Tell us your goal and exam date
2Get the syllabus and batch options
3Enroll when you are ready

+1 805 200 4058 WhatsApp us support@certocean.com

Get the syllabus and batch dates

Takes under a minute. No payment needed.

Full name

Mobile number

Country

Course