Skip to content

melissafisheranalyst/Commercial-Electrical-Project-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Commercial Electrical Project Analysis

This project analyzes the performance of a commercial electrical project (Avid) and compares it with two similar projects. Tools used include Python, Jupyter Notebooks, Excel and Tableau for cleaning, transforming, analysis, and visualization.

Files in this Repository

  • /data/: Contains the raw CSV files extracted from QuickBooks for the Avid, Clewiston, and Manor projects.
  • /processed-data/: Contains cleaned and transformed Excel files, ready for further analysis and visualization.
  • /notebooks/: Jupyter Notebooks used for data cleaning and analysis.
  • /visuals/: PDFs of Tableau dashboards presenting the final insights.
  • requirements.txt: List of Python dependencies required to run the Jupyter Notebooks.

Explore the Project

About

This project analyzes the performance of a commercial electrical job (Avid) in comparison to two similar projects. Using messy financial data extracted from Quickbooks, the project showcases data cleaning in Jupyter Notebooks, Excel transformations, and visualizations with Tableau to identify inefficiencies and insights.

Topics

Resources

Stars

Watchers

Forks

Packages

 
 
 

Contributors