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.
Logo Design Category: Graphic Design, Illustration, Logo Design, Photoshop Budget: $30 - $250 USD
05-Nov-2025 05:04 GMT
Branding Banners for Web & Social Category: Adobe Illustrator, Photoshop, Banner Design, Branding, Graphic Design, Logo Design, Web Design Budget: ₹2000 - ₹5000 INR
Guangzhou English-Mandarin Interpreter Category: Business Consulting, Business Development, English Translation, Language Tutoring, Market Research, Project Management, Public Speaking, Supplier Sourcing, Time Management, Translation Budget: $15 - $25 USD
Online Sales & SEO Specialist Needed Category: Amazon, Customer Service, Digital Marketing, Email Marketing, Internet Marketing, Link Building, Marketing, SEO, Shopify, Social Media Marketing Budget: $250 - $750 CAD
General Assistant- Full-time opportunity Category: Book Writing, Copy Typing, Data Entry, Excel, Ghostwriting, Microsoft Access, Microsoft Exchange, Word Budget: £10 - £15 GBP
05-Nov-2025 04:53 GMT
Real Estate Marketing Presentation Category: Article Writing, Business Development, Content Creation, Content Writing, Copywriting, Graphic Design, Marketing, Real Estate Budget: ₹1500 - ₹12500 INR
05-Nov-2025 04:51 GMT
Service-Based E-commerce Site Build Category: ECommerce, HTML, Magento, Payment Gateway Integration, PHP, Shopify, Web Development, Web Services, Web Design, WooCommerce Budget: $30 - $250 NZD
Letter press template for custom wedding stationary Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Print Design, Typography, Vector Design, Visual Arts Budget: $10 - $30 USD
05-Nov-2025 04:50 GMT
Power BI KPI Dashboard Category: Data Analysis, Data Modeling, Data Visualization, Excel, Microsoft Access, MySQL, Power BI, Visual Basic Budget: ₹1500 - ₹12500 INR
