Sales Data Migration & Analysis
Budget: $30 – $250 CAD
Data Setup & Migration
Import the liquor sales data into AWS RDS, using a provided data dictionary to guide the schema.
If needed, split large files into smaller parts to keep things efficient.
Use Apache Sqoop to move the data from RDS to HBase, and design a clean, scalable schema for HBase.
Make sure the data is accurate and consistent in both systems.
Cleaning Things Up
Get rid of missing, incomplete, or broken records.
Standardize formats across fields (especially dates, categories, etc.).
Deduplicate entries to keep the data tidy and usable.
Batch Processing & Analysis
Use MapReduce to process and analyze data in bulk.
Key insights we’re looking for:
Revenue breakdown by store, county, and liquor category.
Top performers – best-selling categories, most successful vendors, high-revenue stores.
Trends over time – monthly and yearly sales patterns, seasonal shifts.
Turning Data Into Strategy
We want more than just charts — we need your help to surface actionable insights:
What stores or vendors are outperforming and why?
Which liquor categories are driving the most value?
Where can operations or marketing be optimized based on trends?
Import the liquor sales data into AWS RDS, using a provided data dictionary to guide the schema.
If needed, split large files into smaller parts to keep things efficient.
Use Apache Sqoop to move the data from RDS to HBase, and design a clean, scalable schema for HBase.
Make sure the data is accurate and consistent in both systems.
Cleaning Things Up
Get rid of missing, incomplete, or broken records.
Standardize formats across fields (especially dates, categories, etc.).
Deduplicate entries to keep the data tidy and usable.
Batch Processing & Analysis
Use MapReduce to process and analyze data in bulk.
Key insights we’re looking for:
Revenue breakdown by store, county, and liquor category.
Top performers – best-selling categories, most successful vendors, high-revenue stores.
Trends over time – monthly and yearly sales patterns, seasonal shifts.
Turning Data Into Strategy
We want more than just charts — we need your help to surface actionable insights:
What stores or vendors are outperforming and why?
Which liquor categories are driving the most value?
Where can operations or marketing be optimized based on trends?