Course details

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

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


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.



Expected Duration (hours)
0.8

Lesson 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
  • Course Number:
    it_dfdwha_03_enus

    Expertise Level
    Intermediate