customer base analysis - excel

Завершен Опубликован 4 года (лет) назад Оплачивается при доставке
Завершен Оплачивается при доставке

I have developed an excel file that tracks the following and need help to expand it more and fine tune it

Revenue analysis for each client

- Sales from last years

- CAGR

- Average Sales / month

- up to date sales

- Seasonal Sales (MoM what he bought this year vs last year on MoM basis and the what is left in term of product and revenue)

- Products and categories with the highest increase

- products that make 70%, 30% and the rest of sales for the last 3 years

- Products with the highest profit margin

This is the correct descreption

- Sales from previous Years
- Last years Revenue
- CAGR (3YRS)
- Average Sales per month
- Up to date Sales (based on what he has previously bought until the day of the analysis)
- Seasonal - MoM what he bought this year vs last year on MoM basis and what is left in terms of product and revenue until the end of the year
- Products and categories with the highest increase
- Products that make 70% of Sales & 30% & the remaining
- Top 20 Products in Revenue from last years
- Products with the highest increase in revenue and quantities
- Products to target for the next period (what he bought last year from the day of the analysis till the end of the current year)

Бухгалтерия Бизнес-анализ Обработка данных Excel Финансы

ID проекта: #18068413

О проекте

38 заявок(-ки) Удаленный проект Последняя активность 4 года (лет) назад

Поручен:

TAP1990

Hi, I’m a Business Specialist, with great experience in Business Plans and Business Analytics. I’ve worked in Accenture as a Business and Finance consultant for the last 4 years. I will provide you with an upgrated Ex Больше

€55 EUR за 2 дней(-я)
(1 отзыв)
1.6

38 фрилансеров(-а) готовы выполнить эту работу в среднем за €155

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project customer base analysis. I can assure you the quality job. I have good experience in Accounting, Business Analysis, Data Processing, Excel, Fi Больше

€150 EUR за 2 дней(-я)
(422 отзывов(-а))
8.3
dgled

I can create for you a KPI Analysis Module in Excel to calculate sales performance based on chosen parameters. The performance reports show results per period, person, working group and company levels. during the pr Больше

€250 EUR за 3 дней(-я)
(113 отзывов(-а))
7.6
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Больше

€85 EUR за 3 дней(-я)
(289 отзывов(-а))
7.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure Willing to take up your project. Thank you, Regards.

€200 EUR за 5 дней(-я)
(171 отзывов(-а))
6.9
priyal1997

Hi There, I can develop a perfect dynamic excel based customer analysis for this purpose. I am an expert in advanced excel modeling and have already develop lots of similar models for businesses across the world. Pl Больше

€90 EUR за 2 дней(-я)
(249 отзывов(-а))
6.9
polarjin2017

Hello? How are you? I have good experiences in "customer base analysis - excel" as you can see my profile for these (Accounting, Business Analysis, Data Processing, Excel, Finance). I have been working for 7 yrs in Больше

€155 EUR за 3 дней(-я)
(94 отзывов(-а))
6.7
Pmshah1985

I am Chartered Accountant by profession having experience of more than 6 years in a reputed MNC, worked as financial analyst .Proficient in accounting, bookkeeping. Very hardworking and good communication skills Servi Больше

€250 EUR за 10 дней(-я)
(69 отзывов(-а))
6.6
afenache

Hi, I can help you with your sheet to visualize all the metrics listed. If a dynamic dashboard (similar with the sample from my portfolio) I can bult it like this. The advantage of this kind of dashboard is that it Больше

€140 EUR за 4 дней(-я)
(23 отзывов(-а))
5.7
Stefanie2000

Hi, I can help you with this project. I did a similar analysis for my own business in the past. I am a business consultant specialised in strategy development, market research & analysis and business plan writing. I Больше

€250 EUR за 7 дней(-я)
(24 отзывов(-а))
5.6
Baderah

Being an investment banker, making presentation and financial models are central to our professional life. Therefore, I am advance user of MS Excel and Ms Power point. I can start your project now and deliver it in few Больше

€50 EUR за 3 дней(-я)
(110 отзывов(-а))
5.7
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple e Больше

€138 EUR за 3 дней(-я)
(26 отзывов(-а))
4.9
telfordm

Hi, I am a native English speaking Finance professional with over 15 years experience providing financial reporting and analysis to my customers. I can help with your project. I have developed a number of report Больше

€200 EUR за 5 дней(-я)
(14 отзывов(-а))
4.5
alhassanlatif

Hi, I am a professional Access developer I have done many great projects in Access have a look at my profile Send me more details about the work

€155 EUR за 3 дней(-я)
(2 отзывов(-а))
3.1
bijensheth26

I have worked as business analyst for 1 year in retail and BFSI sector. I have also completed a free lancing project by doing useful analysis and helping him/her to achieve their target. Having the experince i feel c Больше

€200 EUR за 5 дней(-я)
(1 отзыв)
2.0
shettyarjun75

I have an experience of 8 years as a manager of handling customer experience for a reputed startup in India Relevant Skills and Experience Complete hands on excel Experience on deriving insights on data Worked on proj Больше

€155 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
ZhenExpert

Hi, I have done many projects similar to this with R, Matlab, Python. If you hire me, I can help you with awesome result. Can I discuss in detail via interview? Regards,

€155 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
Anamol77

HELLO! I am interested to work with you . I can help you with your requirement.I am skill full in article writing, accounting, website development,data entry,advertising ,marketing, google ads , fast typing etc I a Больше

€250 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
mehultanchak

I have good grip on excel and i am also doing job of senior account executive .. So i will complete your work as per yout time line

€155 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
Ccastillog33

Analista de datos por 4 años, creación de base de datos por 3 años tambien, poder de análisis alto Relevant Skills and Experience Analista de datos, habilidad para trabajar bajo presión ,

€166 EUR за 10 дней(-я)
(0 отзывов(-а))
0.0
himanshugirdhar5

Hey I can work on this thing.I have knowledge of excel. Thanks

€200 EUR за 10 дней(-я)
(0 отзывов(-а))
0.0