Code-Sage

Add Year-over-year Reporting Feature with Python (Business Sales Dashboard - App Enhancement & Maintenance)

09 Nov 2024

Dev Ops

Objective

Add 2 new features to the interactive dashboard. 1) Ability to visualize year-over-year insights of product sales, category sales, manufacturing, and market data. 2) Allow the ability to download the raw dataset for further analysis.

Technical Goals/Overview

Create the desired dataset/pivot table and corresponding visualization for the year-over-year insights. Add a download button to the dashboard to allow users to download the raw dataset. Also, dependency updates and code refactoring to improve maintainability.

Summary: Technical Implementation

  1. Project Setup
    • Python Environment
    • Jupyter Notebook
    • Data Analysis and Visualization Packages
  2. Application Update
    • Update dashboard dependencies to latest compatible/ available.
    • Explore, understand, and create a year-over-year dataset from raw data.
    • Update the dashboard UI to include the new visualization.
    • Add a download button to the dashboard to allow users to download the raw dataset.
    • Update tests to include new features.
    • Update CI/CD pipeline matrix to test against Python 3.12 and 3.11.

Skills Footprint:

Category Technical Specifics
general Data Science * Data Analysis * Data Visualization
standards CSV * Spreadsheet * Charts * Graphs * Pivot Tables
tools VSCode * GIT * Python * Jupyter Notebook * GitHub Actions
concepts Dataset Creation * Data Analysis * Data Visualization * Data Cleaning * Data Processing * CI/CD * Automated Testing * Automated Deployment
packages pandas * yaml * numpy * dash * flask * plotly * matplotlib * seaborn * pip * pytest * playwright

Related posts