HDInsight & Retail Sales Implementation Using Hive

Apache Hadoop    |    Intermediate
  • 11 videos | 45m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 4 users Rating 4.5 of 4 users (4)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 4m 36s
    Upon completion of this video, you will be able to illustrate various data modeling approaches that are adopted for providing data warehousing solutions. FREE ACCESS
  • 6m 7s
    In this video, you will learn how to identify the roles of fact and dimension tables in the dimensional design process. FREE ACCESS
  • Locked
    3.  Dimensional Design Steps
    3m 16s
    After completing this video, you will be able to recall the essential dimensional design processes and the objectives of the various steps involved. FREE ACCESS
  • Locked
    4.  Retail Business Use Cases
    3m 43s
    In this video, you will learn how to depict the essential business use cases of data warehousing in the retail sales domain. FREE ACCESS
  • Locked
    5.  Dimension Tables
    3m 30s
    In this video, you will learn how to create dimension tables in Hive. FREE ACCESS
  • Locked
    6.  Fact tables
    3m 17s
    Learn how to create fact tables for retail use cases using Hive. FREE ACCESS
  • Locked
    7.  Data Loading in Dimension and Fact Tables
    2m 27s
    In this video, you will load data into the dimension and fact tables. FREE ACCESS
  • Locked
    8.  Essential Queries
    3m 47s
    In this video, learn how to identify the essential queries that are used to fetch essential data from retail schemas. FREE ACCESS
  • Locked
    9.  Creating and Executing Queries
    5m 5s
    Find out how to construct and execute queries to get the desired outputs from Hive tables. FREE ACCESS
  • Locked
    10.  Hive and Power BI for Visualization
    4m 40s
    During this video, you will learn how to create dashboards in PowerBI from data stored in Hive. FREE ACCESS
  • Locked
    11.  Exercise: Writing Hive Query to Extract Data
    4m 35s
    During this video, you will learn how to write a Hive query to extract data from dimension and fact tables using Joins. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.