Coursera
Coursera Logo

IBM - Getting Started with Data Warehousing and BI Analytics 

  • Offered byCoursera

Getting Started with Data Warehousing and BI Analytics
 at 
Coursera 
Overview

Duration

12 hours

Start from

Start Now

Total fee

Free

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Getting Started with Data Warehousing and BI Analytics
 at 
Coursera 
Highlights

  • Earn a Certificate upon completion from IBM
  • Financial aid available
Details Icon

Getting Started with Data Warehousing and BI Analytics
 at 
Coursera 
Course details

More about this course
  • Data is one of an organization's most valuable commodities
  • 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
  • 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.
  • Able to describe how data warehouses serve a single source of data truth for organization's current and historical data

Getting Started with Data Warehousing and BI Analytics
 at 
Coursera 
Curriculum

Data Warehouses, Data Marts, and Data Lakes

Data Warehouse Overview

Popular Data Warehouse Systems

Selecting a Data Warehouse System

IBM Db2 Warehouse (Optional)

Data Marts Overview

Data Lakes Overview

Course Introduction

Summary & Highlights

Practice Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes

Graded Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes

Designing, Modeling and Implementing Data Warehouses

Overview of Data Warehouse Architectures

Cubes, Rollups, and Materialized Views and Tables

Facts and Dimensional Modeling

Data Modeling using Star and Snowflake Schemas

Staging Areas for Data Warehouses

Verify Data Quality

Populating a Data Warehouse

Querying the Data

Grouping Sets in SQL

Data Warehousing with Star and Snowflake schemas

Summary & Highlights

Practice Quiz: Designing, Modeling and Implementing Data Warehouses

Graded Quiz: Designing, Modeling and Implementing Data Warehouses

Data Warehouse Analytics

Introduction to Analytics and Business Intelligence (BI) Tools

Cognos Analytics: Introduction and How to Sign Up

Navigating in Cognos Analytics

Creating a Simple Dashboard in Cognos

Advanced Capabilities in Cognos Analytics Dashboards

Accessing Your Warehouse With Cognos

Summary & Highlights

Practice Quiz: Data Warehouse Analytics

Graded Quiz: Data Warehouse Analytics

Final Assignment and Final Quiz

Project Overview

Team & Acknowledgements

Congrats & Next Steps

Final Quiz

Getting Started with Data Warehousing and BI Analytics
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    3 months
    Beginner
    – / –
    20 hours
    Beginner
    – / –
    2 months
    Beginner
    – / –
    3 months
    Beginner
    View Other 6715 CoursesRight Arrow Icon
    qna

    Getting Started with Data Warehousing and BI Analytics
     at 
    Coursera 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...