EdX

Data Warehousing and BI Analytics (edX)

Offered by IBM,
Data Warehousing and BI Analytics (edX)

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools. 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.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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.
This course is part of the following programs:

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.

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

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to Designing Data Lakes on AWS (edX) EdX
AWS

Introduction to Designing Data Lakes on AWS (edX)

Statistics & Data Analysis Data Science

In this class, we will help you understand how to create and operate a data lake in a secure and scalable way, without previous knowledge of data science! Designing a data lake is challenging because of the scale and growth of data. This course is for professionals (Architects, System Administrators and DevOps) who need to design and build an architecture for secure and scalable Data Lake components. Students will learn about the use cases for a Data Lake and, contrast that with a traditional infrastructure of servers and storage.

Self Paced
Self-Paced
Data Analytics AWS AWS Services
Details
Herramientas de la Inteligencia de Negocios (edX) EdX
Galileo University,GalileoX

Herramientas de la Inteligencia de Negocios (edX)

Statistics & Data Analysis

Aprende el proceso de extraer y transformar data para generar insumos y tomar decisiones. Usa software, herramientas y sistemas de apoyo. Con este curso aprenderas a tomar decisiones empresariales exitosas. Para ello, aprenderas el proceso completo desde extraer data, hasta su integracion, visualizacion, depuracion, analisis y uso. Podr as transformar data cruda en insumos para la toma de decisiones. Dominaras el uso de software, herramientas y sistemas de apoyo.

Self Paced
Self-Paced
Big Data Business Intelligence Power BI
Details
Data Analytics Basics for Everyone (edX) EdX
IBM

Data Analytics Basics for Everyone (edX)

Statistics & Data Analysis

Learn the fundamentals of Data Analytics and gain an understanding of the data ecosystem, the process and lifecycle of data analytics, career opportunities, and the different learning paths you can take to be a Data Analyst. In this course, you will learn about the various components of a modern data ecosystem and the role Data Analysts, Data Scientists, and Data Engineers play in this ecosystem.

Self Paced
Self-Paced
Big Data Data Science Data Scientist
Details
SQL for Data Science (edX) EdX
IBM

SQL for Data Science (edX)

Statistics & Data Analysis Data Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and extracting various data types from databases.

Self Paced
Self-Paced
Python Databases SQL
Details
Introduction to SQL (edX) EdX
Davidson College,DavidsonX

Introduction to SQL (edX)

Statistics & Data Analysis

In this introduction to SQL Online Course you will gain strong understanding and utilize SQL to aggregate, manipulate, analyze, and visualize data in your field. SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases.

Self Paced
Self-Paced
SQL Relational Databases Structured Query Language
Details
Data Analytics and Visualization Capstone Project (edX) EdX
IBM

Data Analytics and Visualization Capstone Project (edX)

Statistics & Data Analysis

Accelerate the knowledge you gain from previous courses in the IBM Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task. This course provides students with the opportunity to assume the role of an Associate Data Analyst who has recently joined an organization. In this role, you will use Data Analytics skills and techniques on real-world datasets to complete a business task.

Self Paced
Self-Paced
Data Data Wrangling Data Visualization
Details
Making Evidence-Based Strategic Decisions (edX) EdX
University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Making Evidence-Based Strategic Decisions (edX)

Statistics & Data Analysis

Drive alignment among managers, employees and the organizational goals through data analytics and data products. This course on digital transformation will show you how to turn your organization into a decision-making factory. What makes a good business decision? How can we combine effective data analytics and feed robust foresight and scenario planning processes?

Self Paced
Self-Paced
Artificial Intelligence Decision Making Data Products
Details
Introduction to SQL (edX) EdX
IBM

Introduction to SQL (edX)

Computer Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases.

Self Paced
Self-Paced
Databases SQL Programming Languages
Details
Relational Database Basics (edX) EdX
IBM

Relational Database Basics (edX)

Statistics & Data Analysis

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships.

Self Paced
Self-Paced
SQL MySQL PostgreSQL
Details
Effecting Digital Transformation with Data Analytics Projects (edX) EdX
University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Effecting Digital Transformation with Data Analytics Projects (edX)

Statistics & Data Analysis Business

Learn how to transform an organization digitally through simulations and case studies by applying the Disciplined Agile Delivery framework to work through three simulations. As a business leader, you may be asking yourself, what’s next? R? Python? Graph Databases? The latest data analytics technology that was launched last week? How do you craft an effective digital strategy from these technologies? How do you build the data transformation roadmap to give your organization a competitive advantage? How will you digitally transform your organization to give the best customer experience? In this course, we will explore three case studies to learn the practical tools and methods used to build a digital organization.

Self Paced
Self-Paced
Digital Transformation Data Analytics Transforming Your Company’s Data Analytics: Championing the Digital Enterprise Professional Certificate
Details
Django Application Development with SQL and Databases (edX) EdX
IBM

Django Application Development with SQL and Databases (edX)

Computer Science

This course introduces you to the basics of SQL, Django and Bootstrap. You will gain hands-on practical experience developing and deploying a full-stack Django web application on the cloud. This course introduces you to the basics of SQL, a simple and powerful programming language for querying and managing data, and the fundamentals of cloud databases. You will discover Object-Relational Mapping (ORM), and how to use Object-Oriented Programming (OOP) languages to work with databases.

Self Paced
Self-Paced
Databases SQL Bootstrap
Details