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

Estadística Aplicada a los Negocios (edX) EdX
Galileo University,GalileoX

Estadística Aplicada a los Negocios (edX)

Statistics & Data Analysis

Aprende las principales herramientas y técnicas de la estadística descriptiva y la estadística inferencial para analizar e interpretar datos desde la perspectiva de negocios facilitando la toma de decisiones. Este curso proporciona una introducción al análisis de datos en base a las principales herramientas estadísticas, enfocándose en la estadística descriptiva y la estadística inferencial.

Self Paced
Self-Paced
Statistics Econometrics Data Analysis
Details
Learning Analytics Fundamentals (edX) EdX
University of Texas at Arlington,UTArlingtonX

Learning Analytics Fundamentals (edX)

Education Statistics & Data Analysis

Learn about the growing field of learning analytics and how to analyze basic data sets to generate insights. The demand for data science and learning science skills has continued to increase as classrooms, labs, and organizations look to optimize their data and improve learning environments for students and employees. The UTArlingtonX Learning Analytics courses will give you the opportunity to gain invaluable knowledge and expertise in this growing field.

No sessions available
4 Weeks
Data Analysis Learning Analytics Analytics
Details
Analytics for the Classroom Teacher (edX) EdX
Curtin University,CurtinX

Analytics for the Classroom Teacher (edX)

Education Statistics & Data Analysis

This course is ideal for school teachers who want to improve their teaching through valuable data-driven insights. Do you want to be more reflective in your teaching practice and wonder if there are technologies that can help? Are you curious about how data-driven, evidence-based teaching practices can improve your students’ learning? This is the course for you!

No sessions available
5-12 Weeks
Teaching Teacher Learning Analytics
Details
Big Data and Education (edX) EdX
University of Pennsylvania,PennX

Big Data and Education (edX)

Education Statistics & Data Analysis

Learn the methods and strategies for using large-scale educational data to improve education and make discoveries about learning. Online and software-based learning tools have been used increasingly in education. This movement has resulted in an explosion of data, which can now be used to improve educational effectiveness and support basic research on learning.

Self Paced
Self-Paced
Education Big Data Data Mining
Details
Análisis de datos: Llévalo al MAX() (edX) EdX
Delft University of Technology,DelftX

Análisis de datos: Llévalo al MAX() (edX)

Sci: Mathematics Statistics & Data Analysis

Incrementa tus habilidades de análisis de datos utilizando hojas de cálculo y visualización de datos en Excel. Aumenta tu productividad y produce mejores decisiones de negocio. Este curso de análisis de datos (business intelligence: BI) y estadísticas es para todos aquellos que quieren mejorar sus habilidades en el análisis de datos. ¿Buscas una forma inteligente de visualizar los datos para que tengan sentido? ¿Quieres entender esa colección de datos loca que te dio tu jefe? ¿Tienes Megabytes de sensores de datos para analizar? ¡No te preocupes, lo tenemos cubierto!

Self Paced
Self-Paced
Python Statistics Spreadsheets
Details
Fundamentos TIC para profesionales de negocios: Programación (edX) EdX
Universitat Politècnica de València,UPValenciaX

Fundamentos TIC para profesionales de negocios: Programación (edX)

CS: Software Engineering

¿Tienes que trabajar con las Tecnologías de la Información y te faltan conocimientos? Conoce los fundamentos de la programación software. Este curso forma parte de una serie de 5 cursos de introducción al uso de sistemas de información en las empresas que te introducirá en el apasionante mundo de las TIC.

Self Paced
Self-Paced
HTML Javascript XML
Details
Introduction: Emerging Technologies in an Enterprise Environment (edX) EdX
The University of British Columbia,UBCx

Introduction: Emerging Technologies in an Enterprise Environment (edX)

Business

Successfully leverage and implement emerging technologies within a business enterprise environment. Professionals operating at the intersection of IT and business face unique challenges, amplified by data proliferation and ever-evolving technology. To add business value and remain competitive, it is crucial to understand how to successfully leverage emerging technologies within a broader enterprise context.

Self Paced
Self-Paced
Technology Digital Technology IT
Details
Computing for Data Analysis (edX) EdX
Georgia Institute of Technology,GTx

Computing for Data Analysis (edX)

CS: Software Engineering Statistics & Data Analysis

A hands-on introduction to basic programming principles and practice relevant to modern data analysis, data mining, and machine learning. The modern data analysis pipeline involves collection, preprocessing, storage, analysis, and interactive visualization of data. In the course, you’ll see how computing and mathematics come together.

Aug 19th 2024
13-24 Weeks
Programming Python Computing
Details
The Analytics Edge (edX) EdX
MIT,MITx

The Analytics Edge (edX)

Statistics & Data Analysis

Through inspiring examples and stories, discover the power of data and use analytics to provide an edge to your career and your life. In the last decade, the amount of data available to organizations has reached unprecedented levels. Data is transforming business, social interactions, and the future of our society. In this course, you will learn how to use data and analytics to give an edge to your career and your life.

This course is archived
13-24 Weeks
Data Clustering Data Analysis
Details
Analytics in Python (edX) EdX
Columbia University,ColumbiaX

Analytics in Python (edX)

CS: Programming Business

Learn the fundamental of programming in Python and develop the ability to analyze data and make data-driven decisions. Data is the lifeblood of an organization. Competency in programming is an essential skill for successfully extracting information and knowledge from data. The goal of this course is to introduce learners to the basics of programming in Python and to give a working knowledge of how to use programs to deal with data.

This course is archived
5-12 Weeks
Python Big Data Analytics
Details