Find Jobs
Hire Freelancers

Slice & Dice Excel Dashboard with simple predictor Model for 100 variables dataset Reporting and prediction

$250-750 USD

Completed
Posted over 9 years ago

$250-750 USD

Paid on delivery
An Excel modeller with rich 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 100 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 predict future market share of each supermarkets and by customer age profile and [login to view URL] statistical interface will use correlations and linear regression to determine each supermarket market share drivers The third and also important part of the project is prediction 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.
Project ID: 6176963

About the project

18 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I have a deep knowledge in Excel and VBA, developing VBA programs for more than 15 years and creating dashboards, doing data analysis and representation and teaching VBA and Excel (all levels) for 12+ years. As you can guess, I have created a plethora of macros, dashboards, reports, trend analysis, etc... for both training purposes and business. I'm working for a survey analysis company for the last 4 years, I have also worked for many different companies creating dashboards, analyzing datasets, developing and implementing algorithms, and developing goal seek scenarios. Unfortunately it is not permitted to upload files from here, but if you want to see samples of my previous work, please send me a message, so that to have a chance to send you the samples. Looking forward to hear from you, Kind regards, Chriskerpini
$340 USD in 4 days
4.9 (69 reviews)
6.5
6.5
18 freelancers are bidding on average $403 USD for this job
User Avatar
Hi, I'll be happy to help you with this project, but I need to see the file before confirming my bid ----------------------------------------------------------------------------------------
$340 USD in 3 days
4.9 (252 reviews)
7.6
7.6
User Avatar
Hello Hagof, After starting working on your first project I saw you also had this one available. If you are happy with the response time and quality of analysis I have provided and the support I provide to make sure 100% satisfaction is guaranteed, I would like the opportunity to assist with this project too. It sounds as the data file as vastly more complex, so it should allow for very nice interactivity, color, and drill down features in comparison to the relatively simpler first project that could be explained with a number or more formatted graphs. If you have any questions or comments, or would like to show me the Excel file for me to verify my capabilities, please let me know! I would be happy to provide the same accurate analysis and show you an in-depth dashboard to visualize the data on. Looking forward to continuing our relationship, ~Mark, (MasterOfNumbers) [100% completion, 100% on-time, 100% accuracy, 100% satisfaction]
$350 USD in 5 days
5.0 (98 reviews)
6.8
6.8
User Avatar
Greetings! Let's start a dialog about your project. I'm the number one rated statistician here on the website and would love the opportunity to help. For Excel projects like this I normally bring in a pal of mine on board to assist. Please check out my reviews and contact me. I'm more than willing to help! A good example of previous work. https://www.freelancer.com/projects/Algorithm-Mathematics/risk-score-algorithm.html Cheers, SstatsC
$750 USD in 14 days
5.0 (48 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 USD in 20 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. Some of the projects which I have done include: 1) Pattern identification: Prepared software to identify repeating patterns due to addition of new data-point. (Project - "Write some Software which can detect Patterns" - 5882496) 2) Time series analysis to determine relationship and prediction of retail petrol vs from wholsale petrol prices (Project - 5332392) 3) Multi-regression for product harvesting strategy using dummy variables wherever applicable. Used Minitab and JMP for above projects. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$368 USD in 10 days
4.9 (39 reviews)
5.6
5.6
User Avatar
Hello Hagof, I am m.s of systems engineering and b.s of industrial engineering and like to work on this project, I have studied statistics, econometrics, probability theory and I have done many projects in excel regarding dashboard and statistical modelling that you can simply see in my profile and ask me to provide examples. Also worked with regression, correlation functions and data analysis of excel, as well as formulas. I hope I can hear from you fast. Best Regards
$250 USD in 4 days
4.6 (83 reviews)
5.6
5.6
User Avatar
HI Brother, I am Data Scientist working in Multinational Company. My work is to see the hidden pattern in the large and complex data sets and predictive analytics, Data mining,Machine Learning and also uses the statistical techniques on those datasets to see what data behaves in past. By seeing the past what will be the behavior the that data set in future. I am also working on "kaggle" competitions currently .I am also writing the column on All Analytics and my rank on All analytics in Statistician. I am also working on the Time Series analysis using ARIMA, SARIMA models and also working on econometric analsysi using Linear, Nonlinear, Logistic, Probit models, hypothesis testing and Cox regression for the survival analysis and also survey analysis etc. I am also the writer of the various research papers and one of them is relating medical data you can sight my paper at IEEEXPLORE. I am also using R, SPSS Statistics, Spss Modler, Stata, SAS, MATLAB, WEKA, Statistica and Pyhthon for Data Analysis for Machine Learning, Data Mining and Data Science. Thanks Regards, Muhammad Shoaib. Data Scientist
$555 USD in 10 days
4.9 (7 reviews)
3.1
3.1
User Avatar
Hello, During the past 10 years I have made dozens of Excel models such as yours for multinationals such as J&J, Pfizer and the local government. Feel free to contact me in case you want to see examples and/or screenshots. Best regards, Tom
$444 USD in 10 days
4.6 (7 reviews)
3.1
3.1
User Avatar
Hello, I have rich experiences in Data Mining. I am interested in this project. I am also work as data analytic. Thanks & Regards HGDumaswala
$555 USD in 10 days
5.0 (3 reviews)
2.2
2.2
User Avatar
It is our mission to provide clients with a wide range of Microsoft Excel and Access services like no other, to surpass all expectations and deliver above and beyond service. We will not compromise our client’s satisfaction. Our focus starts and ends with the client in mind, and so shall every aspect of our work.
$333 USD in 3 days
5.0 (1 review)
0.8
0.8
User Avatar
I work as data analyst on daily basis and have just finished postrad in Financial Engineering. Have experience in Excel/VBA/Matlab/R. If You need the task to be done 100% professional, take my offer. Doing dashboards in excel is my daily job :)
$250 USD in 7 days
5.0 (1 review)
0.6
0.6
User Avatar
Dear Hiring Manager, Today I have found this job post on job-board, and I’m very interested in your job post involving these skills. I have gained a wide knowledge and understanding of data collection methodologies, principles and techniques. I also have excellent data mining, cleaning and processing skills, as well as being a superb communicator with first class report writing skills. I have experience of working with large data sets using a range of statistical (parametric and non-parametric tests), six sigma methodology, non-stationary time series and segmentation techniques. I have acquired the experience and skills to perform every aspect of this job beginning with creating surveys and researching the data in order to find an answer to the questions or to solve the problems presented by the administrators. I have extensive knowledge of statistical analysis software programs Mat lab, SPSS, Minitab used to analyze the data collected and am familiar with and have the ability to learn how to use large, complicated information systems. I have experience interpreting quantitative data to financial and risk management problems, price & crm-analytics, manage risk and identify profitable opportunities; checking and maintaining databases to make sure they are reliable and designing statistical models to assist with problem solving. My experience also includes creating charts and tables with complete accuracy, interpreting data summaries and preparing forecasts based on the data.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there I ve good typing speed and proficient with excel. Dedicated to complete to job as per requirements . Look forward to hearing from u soon .
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please consider my bid, I am a commercial analysis, holder of a 1st class honours degree in busines and i am a part qualified CIMA accountant. I currently work as an analyst for a FCMG company that supplies retailers and wholesalers of doors globally. I am an expert user of Excel, Power pivot and advanced filtering applications of Excel to create easy to use and detailed reports and KPI documents. Please consider my bid for this work as i relish the chance to work on this project and outside of that supply you with after sales support for any additions you may have for your on-going requirement. Thank you and Best regards, James
$350 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir I am supervisor i have to deal with excel everyday i use to create tables and graphs to show my teams production and quality to impress my boss. I can do this job well. If not satisfied kindly test me with sample if not satisfied don't need to provide a job but i am sure you will give it to me after completing my sample test. Expecting a this project from you I am not expecting 250$ i am expecting project first even you can pay lesser amount then that. Thanks Regards, Daniel Charles
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I understand your requirement very closely as i am working on various similar request, i have 10+ years of experience in excel and can do needful asap. I am good at general excel formulas to creating wonderful dynamic dashboards :), lets start it - i bet you will have more work for me. Regards, Mindmapping
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Johannesburg, Nigeria
5.0
281
Payment method verified
Member since Dec 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.