1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com
ecommerce-data-warehouse.jpg

Data Warehouse Design for E-commerce Environments

In this hive project, you will design a data warehouse for e-commerce environments.

Users who bought this project also bought

What will you learn

  • Roles in a data engineering project and their functions
  • Analysing a data problem
  • Designing a big data warehouse
  • Data processing using Spark
  • Data querying using Hive/Impala

What will you get

  • Access to recording of the complete project
  • Access to all material related to project like data files, solution files etc.

Prerequisites

  • It is expected that students have a fair knowledge of Big Data and Hadoop particularly HDFS, Pig/Spark, Hive and Impala.

Project Description

The entire goal of investing in a data infrastructure is to improve the edge of business as well as the company's bottom line.

In this big data project, we are going to be designing a data warehouse for a retail shop. The design and implementation, however, we focus on answering some specific questions that are related to price optimization and inventory allocation. The two questions we will be looking to answer in this hive project include:

  1. Were the higher priced items selling in certain markets?
  2. should inventory be re-allocated or price optimized based upon geography?

We will recognize the entire purpose of answer these questions with data is to boost overall bottom line for the business while improving the experience for the shoppers.

Instructors

 
Michael

Big Data & Enterprise Software Engineer

I am passionate about software development, databases, data analysis and the android platform. My native language is java but no one has stopped me so far from learning and using angular and node.js. Data and data analysis is thrilling and so are my experiences with SQL on Oracle, Microsoft SQL Server, Postgres and MyS see more...

Curriculum For This Mini Project

 
  Importance of Data Engineering
04m
  Overview of the E-commerce Business Problem
16m
  Solution Design
13m
  Data Exploration
19m
  Create Views
15m
  Migrate Data or ETL with Apache Sqoop
17m
  Executing and Troubleshooting a Sqoop Job
12m
  Create Views for EDA (Exploratory Data Analysis)
09m
  Perform EDA (Exploratory Data Analysis)
07m
  Analyse data with Spark
06m
  Perform EDA and Troubleshooting
19m
  Data Processing with Spark Scala
05m
  Scala function to create objects
17m
  Building a Map function
04m
  Key Value Pairs
03m
  Write to HDFS
05m
  Troubleshooting Spark script
14m
  Business example - Market segmentation
02m
  Oozie
05m
  Build and troubleshoot an Oozie script
19m
  Oozie dryrun
02m
  Oozie Coordinator
13m
  Troubleshooting Oozie configuration
05m