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.
Excel Dataset Cleaning & Validation Category: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Microsoft Office, Visual Basic Budget: ₹1500 - ₹12500 INR
12-Nov-2025 11:03 GMT
full animation - 3d construction (facility walk through) Category: 3D Animation, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, AutoCAD, Building Architecture, Interior Design, Video Editing Budget: $30 - $250 USD
12-Nov-2025 11:02 GMT
Dholera Smart City Sales Partnership Category: Business Development, Market Research, Marketing Strategy, Project Management, Property Management, Real Estate, Sales, Sales Management, Urban Planning Budget: ₹37500 - ₹75000 INR
12-Nov-2025 11:01 GMT
Urgent Business Analyst Assignment Help Category: Accounting, Business Analysis, Data Analysis, Data Management, Data Visualization, Excel, Google Sheets, Statistics Budget: ₹600 - ₹1500 INR
12-Nov-2025 11:01 GMT
InstaPay EGP Transfer Category: Android, Android App Development, Flutter, IOS Development, IPhone, Logo Design, Mobile App Development, Payment Gateway Integration, PhoneGap, React Native Budget: $30 - $250 USD
12-Nov-2025 10:59 GMT
Modern Cloud Kitchen Logo Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: ₹1500 - ₹12500 INR
React Animated Business Automation Landing Page Category: Animation, CSS, Frontend Development, Graphic Design, HTML5, JavaScript, Tailwind CSS, Typescript, Web Development, Web Design Budget: ₹12500 - ₹37500 INR
12-Nov-2025 10:55 GMT
3D Cartoonish Gamified Learning System Category: 3D Animation, Game Design, Game Development, JavaScript, MongoDB, NLP, Node.js, React.js, Simulation, Web Development Budget: ₹600 - ₹1500 INR
12-Nov-2025 10:53 GMT
Video Repair Specialist Needed Category: A / V Editing, After Effects, Audio Editing, Audio Engineering, Video Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 AUD
12-Nov-2025 10:53 GMT
Children's Book Cartoon Illustration Category: 2D Animation, 2D Drawing, Art Consulting, Caricature & Cartoons, Character Illustration, Creative Design, Digital Art, Graphic Design, Illustration Budget: $250 - $750 USD
