Microsoft Excel Sales Dashboard

Sales Dashboard

What is a data dashboard ?

A data dashboard is the most efficient way to track multiple data sources because it provides a central location for businesses to monitor and analyze performance. Real-time monitoring reduces the hours of analyzing and long line of communication that previously challenged businesses.

In this video, I have created a sales dashboard on sales and profit data (sample data from google). This dashboard is used to display overviews of large data tracks. The elements like tables, charts, and maps to show the overviews. This dashboards ease the decision-making process by showing the vital parts of the data in the same window.

features: 

• Maps connected with data.
• Slicers(buttons) to select categories.
• Year timelines to select the sales and profit data for a particular timeframe.
• Dynamically connected data and charts that can change as per the options selected.

Who am I ?

I'am an outcome focused executive with an experience of 5 years in several projects related to Data analysis, quality assurance, team management, investigations, complaints handling, operations, retail banking, and development banking. I'm currently manages the Middle Office operations in Punjab National Bank International Ltd (PNBIL). I also have more than 4 years of retail banking experience with PNBIL and Federal Bank Ltd, with in-depth knowledge on Data Analysis, Complaints handling, AML policy, comprehensive branch operations. I have worked across majorly two geographies – the UK, India. I am a self-starter, adept at quickly negotiating the learning curves any new responsibility warrants. I am a visualizer and imaginator and can change data into a valuable information.