Part1 : Provided a dataset of volume sales of products from 2019 to 2022 run an extensive exploratory data analysis including the following: . 1. Data Quality & Structure Checks Missing values, duplicates, negative sales, outliers Date consistency (no gaps, proper frequency, handling holidays/weekends) 2. Descriptive Statistics Overall distribution of daily sales (mean, median, std, skewness, kurtosis) By dimension: product, customer Identify top products per customer by volume 3. Time Series Exploration Trend: long-term upward or downward movement Seasonality: daily/weekly patterns (weekdays vs weekends), monthly, quarterly, yearly cycles Rolling averages (7-day, 30-day) to smooth patterns 4. Visualization Layer Time series plots: raw daily sales, moving averages Boxplots: distribution of sales by weekday or month Histograms/density plots: sales distribution 5. Anomaly & Outlier Detection Unusual spikes/drops Use Z-scores or interquartile ranges to flag anomalies 6. Correlation & Drivers of Sales Correlation if needed 7. Performance Metrics (Baseline) Set benchmarks to prepare for forecasting models: Average daily sales per SKU/store Volatility (Coefficient of Variation) Baseline forecast error (e.g., naïve forecast MAPE)
EDA Deliverables : By the end of an extensive EDA, I should have: Clear understanding of demand patterns, seasonality, and anomalies Insights into drivers of sales (internal like price/promo, external like weather/events) Segmentation of products into high/medium/low performers A baseline performance snapshot to compare forecasting models against.
Part 2 : After cleaning the data based on the above analysis, run a linear regression-based model to prepare a sales volume forecast at product & customer level for 2022 in python or/and pyspark. Measure the accuracy by introducing quality measures and explain why have you introduced these measures.
Birthday Slideshow with Original Music Category: Adobe Premiere Pro, Audio Production, Camtasia, Final Cut Pro, Video Editing, Video Production, Video Services, Videography Budget: £250 - £750 GBP
08-Jun-2026 04:02 GMT
自媒体优惠兼职推广来 Category: Advertising, Content Creation, Content Marketing, Copywriting, Digital Marketing, Graphic Design, Marketing Strategy, Social Media Management, Social Media Marketing, Video Editing Budget: $10 - $30 USD
08-Jun-2026 04:02 GMT
Manual Data Entry from Scans Category: Data Analysis, Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Excel, PDF Budget: ₹1500 - ₹12500 INR
08-Jun-2026 04:00 GMT
Manufacture-Ready Baby Diaper CAD Category: 2D Drafting, 3D CAD, 3D Design, 3D Modelling, AutoCAD, CAD / CAM, Product Design, Solidworks Budget: $750 - $1500 USD
08-Jun-2026 04:00 GMT
Forms & Email Support Category: Admin Support, C#, Programming, Customer Service, Data Entry, Email Handling, PHP, Software Architecture, WordPress Budget: $30 - $250 USD
08-Jun-2026 03:56 GMT
Insurance Fund Social Text Ads Category: Advertising, Brand Management, Content Writing, Copywriting, Facebook Marketing, Logo Design, Slogans, Social Media Marketing Budget: $8 - $15 USD
Social Media Specialist for Ed-Tech Startup Category: Analytics, Content Creation, Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Pinterest, Social Media Management, Social Media Marketing, Twitter Budget: ₹600 - ₹1500 INR
Google Ads Expert Needed For Long-Term Opportunity Category: Conversion Rate Optimization, Digital Marketing, Google Ads, Google Adwords, Google Analytics, Google Tag Management, Internet Marketing, Lead Generation, PPC Marketing, Search Engine Marketing (SEM) Budget: min £36 GBP
