• Online, Self-Paced
Course Description

This course covers the implementation of data warehousing in retail sales. Learners will learn to design and implement data warehousing solutions using Hive and PowerBI on HDInsight.

Learning Objectives

Data Warehousing with Hadoop: HDInsight and Retail Sales Implementation Using Hive

  • illustrate various data modeling approaches that are adopted for provisioning data warehousing solutions
  • identify the roles of fact and dimension tables in the dimensional design process
  • recall the essential dimensional design processes and the objectives of the various steps involved
  • depict the essential business use cases of data warehousing in the retail sales domain
  • create dimension tables in Hive
  • create fact tables for retail use cases in Hive
  • load data in the dimension and fact tables
  • identify the essential queries that are used and are required in order to fetch essential data from retail schemas
  • construct and execute queries to get the desired outputs from Hive tables
  • create dashboards in PowerBI from Hive data
  • write Hive query to extract data from dimension and fact tables using Joins

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.