Excel Data Analytics & Visualization
Budget: $15 – $25 USD
I have several datasets sitting in Excel that need a full data analystics treatment from start to finish. First, I want the raw sheets cleaned and pre-processed so every column is consistent, missing values are handled, and outliers are flagged. Once the data is tidy, I need solid statistical analysis that surfaces the key trends and relationships hidden in the numbers. Finally, those insights should be presented through clear, informative visualizations—charts, graphs, or dashboards—that I can drop straight into reports or slide decks.
Please deliver:
• A cleaned master workbook (or CSV export) with all preprocessing steps documented
• A concise analytical write-up describing the statistical methods used and the main findings
• An accompanying set of visualizations (native Excel charts or another tool of your choice, provided the files are editable)
Everything starts and ends in Excel, so fluency with its advanced functions—or with Python/R that can round-trip back to Excel—is a must.
Please deliver:
• A cleaned master workbook (or CSV export) with all preprocessing steps documented
• A concise analytical write-up describing the statistical methods used and the main findings
• An accompanying set of visualizations (native Excel charts or another tool of your choice, provided the files are editable)
Everything starts and ends in Excel, so fluency with its advanced functions—or with Python/R that can round-trip back to Excel—is a must.