4.4
stars
88 ratings

Ramesh Sannareddy +1 more instructor

10,898 already enrolled

Offered By

IBM Skills Network

About this Course

56,193 recent views

Data is one of an organization’s most valuable commodities. But how can organizations best use their data? And how does the organization determine which data is the most recent, accurate, and useful for business decision making at the highest level? 
After taking this course, you will be able to describe different kinds of repositories including data marts, data lakes, and data reservoirs, and explain their functions and uses. 

A data warehouse is a large repository of data that has been cleaned to a consistent quality. Not all data repositories are used in the same way or require the same rigor when choosing what data to store. Data warehouses are designed to enable rapid business decision making through accurate and flexible reporting and data analysis. A data warehouse is one of the most fundamental business intelligence tools in use today, and one that successful Data Engineers must understand.   

You will also be able to describe how data warehouses serve a single source of data truth for  organization’s current and historical data. 

Organizations create data value using analytics and business intelligence applications. Now that you have experienced the ELT process, gain hands-on analytics and business intelligence experience using IBM Cognos and its reporting, dashboard features including visualization capabilities. 

Finally, you will complete a shareable final project that enables you to demonstrate the skills you acquired in each module.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

Computer and IT literacy.

Approx. 15 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

Explore the architecture, features, and benefits of data warehouses, data marts, and data lakes and identify popular data warehouse system vendors.
Design and populate a data warehouse, and model and querydata using CUBE, ROLLUP, and materialized views.
Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.
Design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Skills you will gain

Data Warehousing
Cube and Rollup
Business Intelligence (BI)
Star and Snowflake Schema
cognos analytics

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

Computer and IT literacy.

Approx. 15 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructors

Instructor rating

4.37/5 (17 Ratings)

Ramesh Sannareddy

Data Engineering Subject Matter Expert

Skill-up Technologies

125,592 Learners

10 Courses

Rav Ahuja

Global Program Director

IBM Skills Network

1,543,533 Learners

35 Courses

Offered by

IBM Skills Network

IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

3 hours to complete

Data Warehouses, Data Marts, and Data Lakes

Welcome to your first module! This module provides a gentle but thorough introduction to data warehouse systems, data lakes, and data marts. When you complete this module, you’ll be able to identify and compare data warehouse systems, data mart, and data lake architecture, and understand how organizations can benefit from each of these three data storage entities. Optionally, you’ll explore the workings of IBM Db2 data warehouse system architecture, view use cases, and understand the key capabilities and integrations available with IBM Db2 Warehouse. Then, you’ll learn about three types of data warehouse systems and popular data warehouse system vendors. You will be ready to help your organization assess new data warehouse system offerings when you know the five essential, critical criteria, including total cost of ownership, to evaluate before changing to a new data warehouse system.

3 hours to complete

6 videos (Total 33 min), 2 readings, 3 quizzes

6 videos

Data Warehouse Overview5mPopular Data Warehouse Systems6mSelecting a Data Warehouse System6mIBM Db2 Warehouse (Optional) 4mData Marts Overview5mData Lakes Overview5m

2 readings

Course Introduction5mSummary & Highlights2m

2 practice exercises

Practice Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes10mGraded Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes18m

Week2

Week 2

5 hours to complete

Designing, Modeling and Implementing Data Warehouses

In this knowledge-packed module, you’ll explore general and reference enterprise data warehousing architecture. You’ll discover how data cubes relate to star schemas. Then you’ll learn how to slice, dice, drill up or down, roll up, and pivot relative to data cubes. Next, you will examine the capabilities of materialized views, their benefits, and how to apply them. You’ll learn how data organization using facts and dimensions and their related tables organizes information. Then, you will explore how to use normalization to create a snowflake schema as an extension of the star schema. You will learn about populating a data warehouse, incremental data updates, verifying data, querying data, interpreting an entity-relationship diagram for a star schema, creating a materialized view, and applying the CUBE and ROLLUP options. You’ll also discover how organizations can benefit by implementing staging.

5 hours to complete

8 videos (Total 56 min), 3 readings, 7 quizzes

8 videos

Overview of Data Warehouse Architectures 5mCubes, Rollups, and Materialized Views and Tables7mFacts and Dimensional Modeling6mData Modeling using Star and Snowflake Schemas6mStaging Areas for Data Warehouses4mVerify Data Quality7mPopulating a Data Warehouse8mQuerying the Data8m

3 readings

Grouping Sets in SQL10mData Warehousing with Star and Snowflake schemas10mSummary & Highlights2m

2 practice exercises

Practice Quiz: Designing, Modeling and Implementing Data Warehouses10mGraded Quiz: Designing, Modeling and Implementing Data Warehouses18m

Week3

Week 3

4 hours to complete

Data Warehouse Analytics

4 hours to complete

6 videos (Total 26 min), 1 reading, 2 quizzes

6 videos

Introduction to Analytics and Business Intelligence (BI) Tools4mCognos Analytics: Introduction and How to Sign Up1mNavigating in Cognos Analytics3mCreating a Simple Dashboard in Cognos4mAdvanced Capabilities in Cognos Analytics Dashboards3mAccessing Your Warehouse With Cognos7m

1 reading

Summary & Highlights2m

2 practice exercises

Practice Quiz: Data Warehouse Analytics10mGraded Quiz: Data Warehouse Analytics18m

Week4

Week 4

5 hours to complete

Final Assignment and Final Quiz

In this module, you’ll complete your final course project, which brings together concepts and practices you previously learned in the first three modules. In this final project, you will design and load data into a data warehouse using facts and dimension tables. Then you’ll write aggregation queries using CUBE and ROLLUP functions and create materialized query tables, known as a materialized view. You will complete your project by using IBM Cognos to create an analytics dashboard.

5 hours to complete

3 readings

Reviews

4.4

18 reviews

5 stars
75.26%
4 stars
8.60%
3 stars
4.30%
2 stars
3.22%
1 star
8.60%

TOP REVIEWS FROM GETTING STARTED WITH DATA WAREHOUSING AND BI ANALYTICS

by DSSep 2, 2022

Good course, theory and hands-on alligned! In special, operations in cubes, such as: rollup, drill down, drill up, pivot and others. Thanks!

by JPSep 25, 2022

Really great introduction to Data warehouses, applications and operations inside them.

View all reviews

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Getting Started with Data Warehousing and BI Analytics

About this Course

What you will learn

Skills you will gain