An Excel modeller with statistical skill is urgently required to develop an extensive slice and dice Dashboard - colourful, simple-to-use interface/fool-proof, highly descriptive and intuitive.
The dataset is an Excel table of over 250 variables to be dynamically outputted by 4 Supermarket brands, 5 customer age profile and 7 provinces. The dataset covers a period of 4 years, broken down into quarters.
The Dashboard will have a visually exciting and slice-and-dice interface that is both tabular and in chart with opportunity to add more sub-variables and go into granular analysis on sub-variable level.
There are about 25 dominant variables while others are sub-variables.
The second part of the project requires the Excel modeler to develop a simple statistical algorithm based on the 4 years historical trend to determine variables that uniquely and optimally predict future market share of each supermarkets and by customer age profile and [url removed, login to view] statistical interface will use correlations and linear regression to determine each supermarket market share drivers and a conjoint equation for all the 4 in general and per segments (customer age and provinces). These statistical framework will run in the background will simple and easy to use output
The third and also important part of the project is scenario analysis where a dynamic data form will be designed to determine the required changes in key variables to determine a desired market share point per supermarket.
Proof of previous experience will be appreciated.
Best Excel modeller will get the job.
25 freelancers are bidding on average $597 for this job
Hey, I am an excel/statistics expert and can work with you to create the dashboard as required. Please check the private message for details and suggested approach. Thanks and Regards, Shikha