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.
AI-Animated Astrophysics Documentary Category: 3D Animation, After Effects, AI Animation, AI Art Creation, AI Content Creation, AI Model Development, Motion Graphics, Video Editing, Visual Arts Budget: $5000 - $10000 AUD
06-Apr-2026 16:04 GMT
Modern Vibrant Hat Embroidery Category: Adobe Illustrator, Photoshop, Embroidery, Graphic Design, Logo Design, T Shirts, Vector Design Budget: $2 - $8 USD
06-Apr-2026 16:03 GMT
Minimalist Box Packaging & Video Category: 3D Rendering, Adobe Illustrator, Adobe Premiere Pro, After Effects, Graphic Design, Logo Design, Packaging Design, Video Editing Budget: $30 - $250 USD
06-Apr-2026 16:03 GMT
Data Analysis Specialist Needed Category: Data Analysis, Data Analytics, Data Visualization, Pandas, Python, SPSS Statistics, Statistical Analysis, Statistics Budget: ₹600 - ₹1500 INR
Roof Antenna Structural Assessment Category: AutoCAD, Building Architecture, Building Certification, Building Design, Building Engineering, Building Surveying, Civil Engineering, Construction, Risk Assessment, Structural Engineering Budget: $250 - $750 USD
06-Apr-2026 15:58 GMT
Forensic Video Analysis Category: Data Analysis, Forensic Consulting, Technical Writing, Video Editing, Video Processing, Video Production Budget: $30 - $250 USD
06-Apr-2026 15:57 GMT
Bank SBLC for Loan Security Category: Compliance, Financial Consulting, Financial Planning, Investment Banking, Risk Management Budget: $50000 - $100000 USD
06-Apr-2026 15:56 GMT
Urgent Private Credit Site Launch Category: Chatbot, CSS, HTML, JavaScript, Lead Generation, PHP, Web Design, Web Development, WordPress Budget: $30 - $250 AUD
