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.
Cinematic House Project Video Edit Category: 3D Animation, Adobe Premiere Pro, After Effects, Animation, Color Grading, Video Editing, Video Post Editing, Video Production Budget: $10 - $30 AUD
Canal YouTube Monetizado para Stand-up -- 2 Category: Content Creation, Digital Marketing, SEO, Video Editing, Video Production, Video Services, YouTube, YouTube Ads Budget: $250 - $750 USD
15-Mar-2026 16:53 GMT
Modern Living Room Interior Design Category: 2D Drafting, 3D Design, 3D Rendering, 3D Visualization, Building Architecture, Interior Design Budget: €2 - €6 EUR
15-Mar-2026 16:50 GMT
Meta Ads Lead-Gen Setup Category: Advertising, Digital Marketing, Facebook Ads, Google Adwords, Google Analytics, JavaScript, Lead Generation, PHP Budget: ₹600 - ₹1500 INR
15-Mar-2026 16:49 GMT
Software Usabiliy Testing Needed Category: Accessibility Testing, Software Testing, Testing / QA, Usability Testing, User Experience Research, User Interface / IA, User Research, Web Testing, Website Testing Budget: ₹750 - ₹1250 INR
15-Mar-2026 16:49 GMT
Future World Nonfiction Book Category: Article Writing, Business Writing, Content Writing, Copy Editing, Editing, Ghostwriting, Non Fiction Writing, Research, Technical Writing, Writing Budget: ₹37500 - ₹75000 INR
15-Mar-2026 16:47 GMT
Tingkatkan Fitur Aplikasi Saya Category: Agile Development, API Development, App Development, Backend Development, Frontend Development, Project Management, Software Development, User Experience Research Budget: $10 - $30 USD
15-Mar-2026 16:47 GMT
Creative T-Shirt & Sticker Idea for Pump Track Riders Category: Branding, Concept Art, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop, Sticker Design, T Shirts, Visual Arts Budget: $15 - $25 USD
