Getting Started with Data Warehousing and BI Analytics

Course Cover

5

(5)

compare button icon

Course Features

icon

Duration

3 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

icon

Video Content

3 hours

Course Description

Data is an important resource for any organization. How can an organization make the most of its data? How can an organization decide which data are the most current, accurate, and relevant for business decision-making at the highest levels?

This course will teach you how to describe various repositories such as data lakes, data marts and data reservoirs and what their uses are. A data warehouse is a large data repository that has been maintained in a consistent quality. Different data repositories can be used in different ways and require different rigor in choosing which data to store. Data warehouses enable business decision making by providing accurate, flexible reporting and data analysis. Data warehouses are one of the most important business intelligence tools available today. Data engineers who succeed in this field must be able to understand them. This course will help you understand how data warehouses provide a single source for data truth that includes both historical and current data. Analytics and business intelligence apps are used by organizations to create data value. After you have had an opportunity to experience the ELT process, get hands-on experience with IBM Cognos' reporting, dashboard and visualization features. Final project: This will allow you to show the skills that you have acquired in each module.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Explore 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 querydata using CUBE, ROLLUP, and materialized views

Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics

Design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard

Course Instructors

Author Image

Ramesh Sannareddy

Data Engineering Subject Matter Expert

Ramesh Sannareddy holds a Bachelors Degree in Information Systems (Birla Institute of Technology, Pilani). He has two and a half decades of experience in Information Technology Infrastructure Managem...
Author Image

Rav Ahuja

Global Program Director

Rav Ahuja is a Global Program Director at IBM. Rav leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. He is the architect for the IBM Data Science Profession...

Course Reviews

Average Rating Based on 5 reviews

5.0

100%

Course Cover