I require assistance developing a comprehensive data analysis dashboard that can dynamically visualize key performance metrics pulled from an Excel dataset. The core objective is to analyze monthly sales figures, profitability stats, customer retention numbers and other important business KPIs across multiple regions and product lines for the past 2 years.
The ideal candidate will have strong expertise in Excel, particularly in functions like VLOOKUP, PivotTables, conditional formatting etc to manipulate and analyze the provided dataset. Advanced Excel skills are essential to conduct thorough research, identify trends, outliers and patterns in the data. Dashboard visuals need to be intuitive, visually appealing and customizable. Candidates proficient in dashboard development using tools like Power BI, Tableau etc. may have an added advantage.
The dashboard needs to be interactive with interactive filters and slicers to allow drilling down into the data from high level aggregate views down to detailed transactional views. Visualizations incorporating charts, graphs, maps are expected to provide an at-a-glance snapshot of business performance. The end product needs to be aesthetically formatted for easy comprehension of insights by non-technical stakeholders too. Ability to enhance, maintain and update the dashboard on an ongoing basis is necessary. Experience working with largeEnterprise datasets and delivering business intelligence solutions is preferred. Please indicate your approach and timeline to complete this project. I look forward to reviewing your proposals.
