Interactive Dashboard Of A Mid-Size Retail Shop: VThere are a lot of small and mid-size grocery or kirana shops at my locatility. I approached one of the who has been using an older version of MS Excel. I understood how they envisioned on their sales and came up with an interactive dashboard based on daily transactions they captured on their excel files 😊😎😊

Blood Pressure Tracker:  One of my engineering batchmates became my first of the clients. He is not proficient in excel/google sheets. His elderly mother suffers from hypertension due to which her blood pressure changes rapidly. He has to constantly change the medication. One of the best ways to tackle it by tracking her blood pressure. I had several conversations with him on this. He agreed to enter the blood pressure of his mother almost on a daily basis. I developed a pivot chart on the captured data to identify the peak systolic rate of the day. This data analysis helped him in arriving at a decision on when to give and change the medication😊😎😊

Employee Leave Tracker:  The owner of small businnes could not afford to spend money on expensive CRM tools. He uses MS Excel/google sheets for most his work. He has around 10 to 15 employees who work and take leaves on a roster basis. It was nice to interact with him and come up with employee leave tracker. 😊😎😊

PDF To Excel Conversion: The client receives pdf files on a weekly basis, however, they are better analyzed in an excel format. Converting  pdf to excel then becomes a task of paramount importance. Here are the sample of the files which were changed as part of this project. All the real time client data have been replaced by dummy data.😊😎😊

Sales Amount Dashboard Using Power BI:   A real estate promoter wanted to create a dashboard using Power BI for visualization. This was achieved by using Decomposition Tree, Waterfall model charts, cards to describe the KPIs based on dummy data provided by the client ☺🙂😎🙂🤗