Closed

Slice and Dice Excel Model , Visually-exciting Dashboard and simple predictor Model for 200 variables dataset Reporting and future value prediction

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.

Skills: Analytics, Database Administration, Excel, Statistics

See more: excel slice, dashboard slice dice, statistics algorithm, statistical algorithm, slice and dice the data, slice and dice data, simple reporting, modeller job, job with excel skill, exciting opportunity, develop an algorithm, algorithm statistics, algorithm and analysis, statistics job, excel scenario, data modeller, supermarket, statistics linear, statistical model, regression model

About the Employer:
( 228 reviews ) Johannesburg, Nigeria

Project ID: #4833617

25 freelancers are bidding on average $597 for this job

happy2helpp

Consider it is done. Got complete idea about what you needed. Please check PMB. Thank you.

$360 USD in 6 days
(25 Reviews)
5.7
shikhamehta

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

$833 USD in 15 days
(83 Reviews)
5.4
shanki161

Lets discuss, Thanks

$555 USD in 3 days
(23 Reviews)
5.1
priyal1997

;-)). Please refer pm for samples. Thanks - Priyal

$500 USD in 5 days
(48 Reviews)
4.9
sahergis

I have active proposal for you project, you can check details in PM.

$600 USD in 10 days
(5 Reviews)
4.5
dpune

Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at my feedback to see more about me and my work. tks.

$333 USD in 3 days
(13 Reviews)
4.4
caabdul

Dear sir, you may expect the best solution here, thank you

$250 USD in 7 days
(5 Reviews)
3.3
logoDS761

I am highly experienced in Excel, VBA, VB & SQL

$500 USD in 7 days
(1 Review)
1.0
burramichelle

I can jump on this and get it done straight away for you. I am new to Freelancer and looking for the opportunity from you to start. I am having more than 10 years of experience in analytic and excel (check my PM). I ca More

$555 USD in 5 days
(0 Reviews)
0.0
gastik

Hi, I am an expert in the field of liner and multiply regression. Your project looks simple and easy. I have a wide variety of analytical tools available to me which will allow me to analyze your data and choose the More

$633 USD in 7 days
(0 Reviews)
0.0
smithrt111

Sstatsc is my partner, and he contacted me about your project. I can likely finish part 1 for you within 2 days, but I have a few important questions about your variables and your preferences on the visual presentation More

$1111 USD in 14 days
(0 Reviews)
0.0
usitaraman

NEw freelancer with prior analytics, excel and statistics skills...please see PM

$555 USD in 12 days
(0 Reviews)
0.0
wyliechan

Excellent Excel Modeler. Linear, Non-Linear regression of dataset. Statistical Predictive Algorithm.

$555 USD in 3 days
(0 Reviews)
1.7
craighubbard1983

We can complete for you quickly to the expected professional standard. We are a group of individuals based in London with experience of doing this kind of work for major global blue chip clients. Please consider our bi More

$450 USD in 7 days
(0 Reviews)
0.0
Areen1

Dear project manager My name is Areen. I am a Ph.D. and an expert in excel, data analysis and reports summaries. I have decided to become a freelancer so I can put my expertise to work for serious clients only. I More

$555 USD in 3 days
(0 Reviews)
0.0
hamidelmi

I have 3+ years experience in Microsoft Excel. I also have done several analytical scenario within Excel. In addition, I have great experiences in software development in order to accomplish your project's goals. Y More

$666 USD in 3 days
(0 Reviews)
0.0
on2it

Kia ora! [login to view URL] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$773 USD in 21 days
(0 Reviews)
0.0
ExpertKris

Hi........I can help...................would like to suggest that apart from statistical tools, use of CrystalBall...will get better forecasting and a better predictor model......for the first part....some suggested lo More

$833 USD in 12 days
(0 Reviews)
0.0
connectdt124

Hi, I am a statistical analyst with 13+ years experience in financial and retail industry. I am a certified Professional Risk Manager from [login to view URL] and also an MBA from a premier business school. The services that I c More

$666 USD in 15 days
(0 Reviews)
0.0
aerobace

Hello, I'm very keen on your project, please see my PM for further reference

$722 USD in 10 days
(0 Reviews)
0.0