This project involves analyzing and visualizing data for Tata Insights and Quants (Tata iQ) using tools like Tableau and Power BI. The tasks included data cleaning, visual creation, and presenting findings based on specific questions posed by the CEO and CMO.
Developed quantitative and qualitative questions relevant to the CEO and CMO based on provided data. Ensured questions guided the creation of meaningful visuals and presentations.
Reviewed the dataset for inaccuracies, including: Negative quantities indicating returns. Incorrect unit prices (below $0). Implemented checks and data transformation methods to exclude or correct erroneous data. Quantity was not below 1 unit. Unit price was not below $0.
Used Power BI to create visuals for four specific questions from the CEO and CMO. Selected appropriate charts or graphs to best display the information. Saved each visual on a separate tab, naming the tab with the corresponding question number. Exported and saved the file in .pbix format for Power BI.
Scripted a presentation to explain the entire process, from initial data load and cleaning to final visualizations. Recorded a video (approximately 5 minutes) presenting the findings to the CEO and CMO. Focused on the most relevant insights and ensured the presentation was clear and concise.