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

E-Commerce Data Warehouse

In this project, we are going to be designing a data warehouse for a retail shop.

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.


  • 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 hackerday, 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 question we will be looking to answer in this 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.



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