HDInsight & Retail Sales Implementation Using Hive
Apache Hadoop 2.7
| Intermediate
- 11 videos | 45m 2s
- Includes Assessment
- Earns a Badge
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 solutionsIdentify the roles of fact and dimension tables in the dimensional design processRecall the essential dimensional design processes and the objectives of the various steps involvedDepict the essential business use cases of data warehousing in the retail sales domainCreate dimension tables in hiveCreate fact tables for retail use cases in hive
-
Load data in the dimension and fact tablesIdentify the essential queries that are used and are required in order to fetch essential data from retail schemasConstruct and execute queries to get the desired outputs from hive tablesCreate dashboards in powerbi from hive dataWrite hive query to extract data from dimension and fact tables using joins
IN THIS COURSE
-
4m 36s
-
6m 7s
-
3m 16s
-
3m 43s
-
3m 30s
-
3m 17s
-
2m 27s
-
3m 47s
-
5m 5s
-
4m 40s
-
4m 35s
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.