This project includes three Excel-based tools: a habit tracker, a personal finance tracker, and a grocery store sales analyzer. These tools automate tasks such as recording my habits and helping me track which month I was exercising the most, or what product the grocery chain could drop, or simply just to manage my budget month. The mantra behind these small projects is: Practice Makes Progress. I still remember the first time following a YouTube data analyst tutorial; I had to replay every single step. Now I still have to put the video speed at 0.75 or replay, but it takes much less time to shuffle around the sheets and buttons and tabs.
Another thing is that some businesses just need Excel as their main tool, while larger organizations have their own giant data warehouse, in which the data analyst should be proficient in SQL or PySpark for big data handling.
The habit tracker helps me monitor daily habits, visualize progress, and stay accountable. And these are my key takeaways:
This project did help me master the dashboard color wheel and theme de javu. Excel has colored wheels that are designed for us, so no need to run around and neatly pick them again. Also, pay attention to the business logo color; I might want to create dashboards aligned with them. Staying less is more: one main theme color, like navy blue, and the rest are its different shades. Lets come back to my small expenditure spreadsheet from my book. Now I want to simplify and organize transactions to see where my money went by following these steps:
Helps small businesses optimize sales performance.
Insights from the grocery store sales analysis: