A Data Analyst with passion for storytelling
Sales is a fast-paced & highly demanding job position to fill in. What makes it more difficult is tracking activities across each division under each sales-person.
All we now need is an intuitive and interactive dashboard that tracks revenue and sales of SKUs to get better idea of the performance.
This project is slightly different from the conventional data analysis project that also involves a bit of forecasting and prediction.
It solely wants to improve and clean the data, and find out factors affecting the revenue of top 5000 movies.
As you already know by now, an interactive dashboard is a storyteller by itself, this excel dashboard involves complicated and comprehensive usage of excel functions applicable in the field of data.
Cleaning data is by far the most critical step in data processing and nothing could replace SQL for this job!
Technologies that I am proficient in and most proud! I have extensively used these skills required to develop a data and numbers sense.
Experienced in handling of large datasets using libraries such as numpy and pandas. Developed meaningful graphs with matplotlib and seaborn. Forecasted multiple datasets with scikit-learning.
Performed multiple ETL functions to analyse clean information.
Created numerous BI dashboards on real-life industry datasets.
Well versed with often used formulas such as SUMIFS(), VLOOKUP(), MATCH() and many more.
The love for data Visualization never stops which shows my experience in another widely used BI tool