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 |
Credential | Certificate |
Getting Started with Data Warehousing and BI Analytics at Coursera Highlights
- Earn a Certificate upon completion from IBM
- Financial aid available
Getting Started with Data Warehousing and BI Analytics at Coursera Course details
- 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