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 sleep app Category: AI Chatbot, AI Content Creation, AI Development, AI Mobile App Development, AI Model Development, AI Text To Speech, Graphic Design, Illustration, Mobile App Development, Photoshop Budget: €750 - €1500 EUR
17-Aug-2025 10:03 GMT
Modern E-Commerce Site Development Category: Database Development, Full Stack Development, Graphic Design, HTML, PHP, UI / User Interface, Web Development, Web Design Budget: ₹12500 - ₹37500 INR
Successive Impact Simulation on RCC Slab Category: 3D Modelling, Abaqus, Civil Engineering, Finite Element Analysis, Mechanical Engineering, Solidworks Budget: ₹1500 - ₹12500 INR
17-Aug-2025 10:01 GMT
Hong Kong Business Setup Specialist Category: Business Analysis, Business Consulting, Business Development, Business Plans, Import / Export, Market Research, Marketing, Supplier Sourcing Budget: $2 - $8 CAD
17-Aug-2025 10:01 GMT
React Next.js & ReactFlow Developer Needed Category: API Integration, Frontend Development, JavaScript, Next.js, Software Development, Web Development Budget: ₹12500 - ₹37500 INR
TikTok & Instagram Video Creation Category: Adobe Premiere Pro, After Effects, CapCut, Motion Graphics, Social Media Marketing, Video Editing, Video Production, Video Services Budget: $2 - $8 USD
17-Aug-2025 09:58 GMT
3D Model of Presswood Pallet Category: 3D Animation, 3D CAD, 3D Drafting, 3D Layout, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max Budget: €30 - €250 EUR
17-Aug-2025 09:57 GMT
Instagram Leads for Car Bookings Category: Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Lead Generation, Marketing, Social Media Marketing Budget: ₹600 - ₹1500 INR
17-Aug-2025 09:54 GMT
Expert UX/UI Designer Needed for Website Category: Adobe XD, Figma, Graphic Design, Logo Design, UI / User Interface, User Interface / IA, UX / User Experience, Web Design Budget: $30 - $250 AUD
