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.
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
01Introduction to Data Warehousing and Business Intelligence11 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
02Data Warehouse Architecture11 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
03Dimension and Fact Tables6 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
04Data Modeling6 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
05Building a Data Warehouse with erwin7 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
06ETL with Talend Studio8 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
07Introduction to Data Visualization with Tableau6 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
08Building a Data Visualization BI Project with Tableau5 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
09Integrated Data Warehousing and BI Project8 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.
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.