Data Warehousing and BI Analytics from edX

Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools are a crucial skill for Data Engineers, Data Warehousing Specialists and BI Analysts, making who are amongst, the most valued resources for organizations.

This course prepares you with the skills and hands-on experience to design, implement and maintain enterprise data warehouse systems and business intelligence tools. You’ll gain extensive knowledge on various data repositories including data marts, data lakes and data reservoirs, explore data warehousing system architectures, deepen on data cubes and data organization using related tables. And analyze data using business intelligence like Cognos Analytics, including its reporting and dashboard features, and interactive visualization capabilities.

This course provides hands-on experience with practice labs and a real-world inspired project that can be added to your portfolio and will demonstrate your proficiency in working with data warehouses. Skills you will gain include building data warehouses, Star/Snowflake schemas, CUBEs, ROLLUPs, Materialized Views/MQTs, reports and dashboards.

This course assumes prior SQL and relational database experience.

What you'll learn

Describe 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 SQL to build CUBEs, ROLLUPs, and Materialized Views.
Analyze warehouse data using popular Business Intelligence (BI) tools such as Cognos Analytics to create reports and dashboards.
Demonstrate loading data into a data warehouse, writing aggregation queries, creating materialized query tables, and building an analytics dashboard.

What's inside

Learning objectives

Describe 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 sql to build cubes, rollups, and materialized views.

Analyze warehouse data using popular business intelligence (bi) tools such as cognos analytics to create reports and dashboards.
Demonstrate loading data into a data warehouse, writing aggregation queries, creating materialized query tables, and building an analytics dashboard.

Describe 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 sql to build cubes, rollups, and materialized views.
Analyze warehouse data using popular business intelligence (bi) tools such as cognos analytics to create reports and dashboards.
Demonstrate loading data into a data warehouse, writing aggregation queries, creating materialized query tables, and building an analytics dashboard.

Syllabus

Module 1: 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

Module 2: Designing, Modeling and Implementing Data Warehouses

Overview of Data Warehouse Architectures

CUBEs, ROLLUPs, 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

Module 3: 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

Module 4: Final Assignment

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops knowledge of Cognos Analytics, a popular BI tool, which helps learners analyze warehouse data

Teaches data warehouse design, modeling, and implementation using SQL, which are core skills for Data Engineers and Data Warehousing Specialists

Taught by Rav Ahuja and Ramesh Sannareddy, experienced instructors in the field

Examines business intelligence and data analytics, which are highly relevant to the field of data management

Offers practice labs and a real-world inspired project, which helps learners demonstrate their skills

Assumes prior SQL and relational database experience, which may be a barrier to entry for some learners

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data Warehousing and BI Analytics with these activities:

Organize Course Notes and Assignments

Show steps

Enhance your learning experience and retention by organizing your course materials, reinforcing key concepts and improving your ability to locate important information.

Show steps

Review your class notes, assignments, and quizzes.
Create an organized filing system for your course materials.
Summarize key concepts and make connections between different topics.

Review Data Warehousing Concepts

Show steps

Reinforce your understanding of data warehousing concepts by reviewing course materials, strengthening your foundation for subsequent learning.

Browse courses on Data Warehousing

Show steps

Review the course syllabus and identify key concepts.
Re-read the assigned textbook chapters on data warehousing.
Participate in online discussions or forums related to data warehousing.

Read 'Data Warehousing: Concepts, Technologies, and Implementation'

Show steps

Expand your knowledge of data warehousing by delving into a comprehensive book that provides in-depth coverage of concepts, technologies, and implementation strategies.

Show steps

Read the assigned chapters from the book.
Take notes and highlight key concepts.
Discuss the book's content with classmates or colleagues.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Practice Designing Star and Snowflake Schemas

Show steps

Practice designing data schemas to reinforce concepts of normalized and de-normalized data models.

Show steps

Review the course materials on Star and Snowflake schemas.
Design a Star schema for a retail sales database.
Design a Snowflake schema for a customer relationship management (CRM) database.

Follow Tutorials on Cognos Analytics Dashboards

Show steps

Enhance your understanding of Cognos Analytics dashboards by following guided tutorials to strengthen your skills in creating interactive data visualizations.

Browse courses on Cognos Analytics

Show steps

Search for online tutorials on Cognos Analytics dashboards.
Follow a step-by-step tutorial to create a simple dashboard.
Experiment with different chart types and visualizations.

Write SQL Queries for Data Warehouses

Show steps

Enhance your SQL skills and apply them to data warehousing scenarios, improving your ability to extract meaningful insights from large datasets.

Browse courses on SQL

Show steps

Review the course materials on SQL for data warehouses.
Practice writing SQL queries to extract data from a data warehouse.
Use SQL to perform aggregations, joins, and other data manipulation tasks.

Develop a Data Warehouse Design Document

Show steps

Produce a comprehensive document that outlines your understanding of data warehouse design principles and best practices, solidifying your knowledge and enhancing your ability to apply these concepts in real-world scenarios.

Show steps

Review the course materials on data warehouse design.
Choose a specific business scenario and design a data warehouse to support it.
Document your design, including the data model, ETL process, and performance considerations.

Assist Classmates with Data Warehousing Concepts

Show steps

Enhance your understanding by explaining concepts to others, reinforcing your knowledge and developing your communication skills.

Show steps

Identify classmates who may benefit from your assistance.
Offer to help them understand specific concepts or complete assignments.
Explain the concepts clearly and provide examples.

Career center

Learners who complete Data Warehousing and BI Analytics will develop knowledge and skills that may be useful to these careers:

Data Warehouse Architect

A Data Warehouse Architect designs and implements data warehouse systems, which are used to store and manage large amounts of data. This course provides the skills and knowledge needed to design, implement, and maintain enterprise data warehouse systems. It covers topics such as data warehouse architectures, data modeling, and data quality. This course can help you build a foundation for a career as a Data Warehouse Architect.

See salaries and explore the career path for Data Warehouse Architect

Business Intelligence Analyst

A Business Intelligence Analyst uses data to help businesses make better decisions. This course provides the skills and knowledge needed to analyze data and create reports and dashboards. It covers topics such as data analysis, data visualization, and business intelligence tools. This course can help you build a foundation for a career as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Data Engineer

A Data Engineer designs, builds, and maintains data pipelines. This course provides the skills and knowledge needed to design and implement data pipelines. It covers topics such as data integration, data transformation, and data quality. This course can help you build a foundation for a career as a Data Engineer.

See salaries and explore the career path for Data Engineer

Database Administrator

A Database Administrator manages and maintains databases. This course provides the skills and knowledge needed to manage and maintain databases. It covers topics such as database design, database optimization, and database security. This course can help you build a foundation for a career as a Database Administrator.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst uses data to solve business problems. This course provides the skills and knowledge needed to analyze data and solve business problems. It covers topics such as data analysis, data mining, and machine learning. This course can help you build a foundation for a career as a Data Analyst.

See salaries and explore the career path for Data Analyst

Data Scientist

A Data Scientist uses data to build predictive models. This course provides the skills and knowledge needed to build predictive models. It covers topics such as machine learning, artificial intelligence, and data mining. This course can help you build a foundation for a career as a Data Scientist.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. This course provides the skills and knowledge needed to design, develop, and maintain software applications. It covers topics such as software design, software development, and software testing. This course can help you build a foundation for a career as a Software Engineer.

See salaries and explore the career path for Software Engineer

Computer Programmer

A Computer Programmer writes and maintains computer programs. This course provides the skills and knowledge needed to write and maintain computer programs. It covers topics such as programming languages, data structures, and algorithms. This course can help you build a foundation for a career as a Computer Programmer.

See salaries and explore the career path for Computer Programmer

Systems Analyst

A Systems Analyst analyzes and designs business systems. This course provides the skills and knowledge needed to analyze and design business systems. It covers topics such as systems analysis, systems design, and business process modeling. This course can help you build a foundation for a career as a Systems Analyst.

See salaries and explore the career path for Systems Analyst

Business Analyst

A Business Analyst analyzes and solves business problems. This course provides the skills and knowledge needed to analyze and solve business problems. It covers topics such as business analysis, business process modeling, and data analysis. This course can help you build a foundation for a career as a Business Analyst.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager plans and manages projects. This course provides the skills and knowledge needed to plan and manage projects. It covers topics such as project planning, project management, and project risk management. This course can help you build a foundation for a career as a Project Manager.

See salaries and explore the career path for Project Manager

Product Manager

A Product Manager plans and manages products. This course provides the skills and knowledge needed to plan and manage products. It covers topics such as product planning, product management, and product marketing. This course can help you build a foundation for a career as a Product Manager.

See salaries and explore the career path for Product Manager

Marketing Manager

A Marketing Manager plans and manages marketing campaigns. This course provides the skills and knowledge needed to plan and manage marketing campaigns. It covers topics such as marketing planning, marketing management, and marketing research. This course can help you build a foundation for a career as a Marketing Manager.

See salaries and explore the career path for Marketing Manager

Sales Manager

A Sales Manager plans and manages sales teams. This course provides the skills and knowledge needed to plan and manage sales teams. It covers topics such as sales planning, sales management, and sales forecasting. This course can help you build a foundation for a career as a Sales Manager.

See salaries and explore the career path for Sales Manager

Customer Success Manager

A Customer Success Manager manages relationships with customers. This course provides the skills and knowledge needed to manage relationships with customers. It covers topics such as customer relationship management, customer service, and customer satisfaction. This course can help you build a foundation for a career as a Customer Success Manager.

See salaries and explore the career path for Customer Success Manager