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

Data Visualization and Building Dashboards with Excel and Cognos (edX) EdX
IBM

Data Visualization and Building Dashboards with Excel and Cognos (edX)

Statistics & Data Analysis

Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data. This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel and IBM Cognos Analytics.

Self Paced
Self-Paced
Spreadsheets Excel Analytics
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
Digital Marketing Analytics: Tools and Techniques (edX) EdX
University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Digital Marketing Analytics: Tools and Techniques (edX)

Marketing & Communication Business

Learn how to leverage leading tools and approaches to digital marketing data analysis. Dive into SEO and SEM strategies including web analytics, machine learning and AI/Big Data applications to strengthen your digital marketing efforts and leverage your resources most effectively.

Self Paced
Self-Paced
Machine Learning SEO Digital Marketing
Details
Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX) EdX
IBM

Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX)

Engineering Computer Science

This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell scripts, Airflow and Kafka. Well-designed and automated data pipelines and ETL processes are the foundation of a successful Business Intelligence platform. Defining your data workflows, pipelines and processes early in the platform design ensures the right raw data is collected, transformed and loaded into desired storage layers and available for processing and analysis as and when required.

Self Paced
Self-Paced
ETL Kafka Bash
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
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
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
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