Code-Sage

Data Science - Analysis/Cleaning with Python (Business Sales Dashboard - Phase 1)

13 Jul 2023

Analysis

Objective

Create an interactive dashboard that offers valuable business insights into product sales, manufacturing, and market data to allow for seamless exploration of key metrics, facilitating informed decision-making and enhancing understanding of the sales and manufacturing processes as well as market trends and opportunities.

Phase 1: Data Analysis/Cleaning

Technical Goals/Overview

Analyze data and develop iterative process to produce clean data sets for consumption by a visualization dashboard.

Summary: Technical Implementation

  1. Project Setup
    • Python Environment
    • Jupyter Notebook
    • Data Analysis and Visualization Packages
  2. Data Analysis
    • Explore, understand, and create a dataset from raw data.
    • Provide report of missing, duplicate, and invalid data for correction.
    • Clean and process data.

Skills Footprint:

Category Technical Specifics
general Data Science * Data Analysis
standards CSV * Spreadsheet
tools VSCode * GIT * Python * Jupyter Notebook
concepts Dataset Creation * Data Cleaning * Data Processing
packages pandas * yaml * numpy

Related posts