IBM
Getting Started with Data Warehousing and BI Analytics
IBM

Getting Started with Data Warehousing and BI Analytics

This course is part of multiple programs.

Taught in English

Some content may not be translated

Ramesh Sannareddy
Rav Ahuja

Instructors: Ramesh Sannareddy

21,515 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.4

(146 reviews)

|

87%

Intermediate level

Recommended experience

16 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll 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 query data 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.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

7 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.4

(146 reviews)

|

87%

Intermediate level

Recommended experience

16 hours (approximately)
Flexible schedule
Learn at your own pace

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

Placeholder

Build your subject-matter expertise

This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

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.

What's included

7 videos2 readings2 quizzes1 app item2 plugins

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.

What's included

8 videos3 readings2 quizzes6 app items1 plugin

In this module, you’ll fast-track your data analytics learning and gain hands-on data analytics experience using IBM Cognos Analytics. After registering with Cognos Analytics, you’ll explore the platform’s capabilities by creating visualizations, building a simple dashboard, and trying out its advanced features.

What's included

6 videos1 reading2 quizzes5 plugins

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.

What's included

3 readings1 quiz1 peer review2 app items1 plugin

Instructors

Instructor ratings
4.4 (28 ratings)
Ramesh Sannareddy
IBM
11 Courses200,424 learners

Offered by

IBM

Recommended if you're interested in Data Management

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 146

4.4

146 reviews

  • 5 stars

    71.33%

  • 4 stars

    13.33%

  • 3 stars

    4.66%

  • 2 stars

    2.66%

  • 1 star

    8%

PM
4

Reviewed on Mar 29, 2023

LA
5

Reviewed on Jun 11, 2023

DL
5

Reviewed on Sep 14, 2023

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions