Context
I created data analysis of some real life sample data looking at the Car battery incidents. This was done using Python, Excel, Jupiter notebook and Power BI.
Actions
- 🔹 Step 1: Clean the database and remove duplicates, missing numbers and remove columns to reduce the file size.
- 🔹 Step 2: Use Jupiter Notebook /Python to read in the files look through the data.
- 🔹 Step 3: Visualize the data using Power BI and create plots.
- 🔹 Step 4: Looked at the trends and then put the results on Power BI to create a dashboard.
Result
Below is the result.
- 📝 Summary of Key Findings:
-
Using Python to clean spreadsheets and reduce file sizes.
-
Data Visualization.
-
Creating Dashboards using PowerBI.
-
Jupiter Notebook.
-
Future Considerations
- 💡 Potential improvements:
- Further Analysis.