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

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 Mining and Knowledge Discovery (edX) EdX
The Hong Kong University of Science and Technology - HKUST,HKUSTx

Data Mining and Knowledge Discovery (edX)

Computer Science

Learn how to discover knowledge in data via data mining. Data mining has recently emerged as a major field of research and applications. Aimed at extracting useful and interesting knowledge from large data repositories such as databases and the Web, data mining integrates techniques from the fields of database, statistics and AI.

Self Paced
Self-Paced
Clustering Classification Data Mining
Details
Foundations of Data Analytics (edX) EdX
The Hong Kong University of Science and Technology - HKUST,HKUSTx

Foundations of Data Analytics (edX)

Statistics & Data Analysis Computer Science

Learn the fundamental techniques for data analytics and to be prepared for learning and applying more advanced big data technologies. Foundations of Data Analytics: This course will provide fundamental techniques for data analytics, including data collection, data extraction, data integration, data cleansing, and basic machine learning techniques.

Self Paced
Self-Paced
Machine Learning Big Data Data Privacy
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
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
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