Find Jobs
Hire Freelancers

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

$250-750 USD

Завершено
Опублікований almost 10 years ago

$250-750 USD

Оплачується при отриманні
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.
ID проекту: 6176963

Про проект

18 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 4 дні(-в)
4,9 (69 відгуки(-ів))
6,5
6,5
18 фрілансерів(-и) готові виконати цю роботу у середньому за $403 USD
Аватарка користувача
Hi, I'll be happy to help you with this project, but I need to see the file before confirming my bid ----------------------------------------------------------------------------------------
$340 USD за 3 дні(-в)
4,9 (252 відгуки(-ів))
7,6
7,6
Аватарка користувача
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 за 5 дні(-в)
5,0 (98 відгуки(-ів))
6,8
6,8
Аватарка користувача
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 за 14 дні(-в)
5,0 (48 відгуки(-ів))
6,6
6,6
Аватарка користувача
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 за 20 дні(-в)
4,9 (115 відгуки(-ів))
6,2
6,2
Аватарка користувача
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 за 10 дні(-в)
4,9 (39 відгуки(-ів))
5,6
5,6
Аватарка користувача
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 за 4 дні(-в)
4,6 (83 відгуки(-ів))
5,6
5,6
Аватарка користувача
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 за 10 дні(-в)
4,9 (7 відгуки(-ів))
3,1
3,1
Аватарка користувача
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 за 10 дні(-в)
4,6 (7 відгуки(-ів))
3,1
3,1
Аватарка користувача
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 за 10 дні(-в)
5,0 (3 відгуки(-ів))
2,2
2,2
Аватарка користувача
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 за 3 дні(-в)
5,0 (1 відгук)
0,8
0,8
Аватарка користувача
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 за 7 дні(-в)
5,0 (1 відгук)
0,6
0,6
Аватарка користувача
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 за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор NIGERIA
Johannesburg, Nigeria
5,0
281
Спосіб оплати верифіковано
На сайті з груд. 28, 2011

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.