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