Olga Awdejew
Private message 
Ukraine
a little busy
Rating
Language Proficiency Level
Українська: fluent
Русский: fluent
Deutsch: upper-intermediate
English: intermediate
CV
Hello! I have over 17 years of experience specializing in market research, business planning, and consulting for various industries in Ukraine, Europe, and North America.
In the past three years, I have expanded my expertise to include data collection, processing, analysis, and visualization using tools like Excel (VBA), SQL, Google BigQuery, Power BI, Google Data Studio, and others. I transform complex data into clear and actionable insights, helping clients automate processes, optimize data workflows, and make informed decisions.
I look forward to collaborating with you!
Skills
Programming
Design & art
- Infographics
- Interface Design (UI/UX)
-
Presentations
from 121 USD per project
Services
-
Data Processing
from 10 USD per hour
-
Enterprise Resource Planning (ERP)
from 11 USD per hour
-
Information Gathering
from 10 USD per hour
Promotion
-
Marketing Research
from 121 USD per project
Architecture
-
Engineering
from 11 USD per hour
Outsourcing & consulting
- Client Management & CRM
-
Consulting
from 11 USD per hour
- Project Management
Portfolio
- All works 50
- Marketing Research 17
- Engineering 1
- Consulting 25
- Data Parsing 1
- Data Processing 3
- Enterprise Resource Planning (ERP) 3
-
Spain Pet Grooming Market Analysis: A Barcelona Focus
Marketing Research
This report provides a detailed market analysis of pet grooming services in Spain, with a particular emphasis on Barcelona. It offers actionable insights for businesses, investors, and stakeholders, covering market size, growth projections, competitive landscape, emerging trends, and potential challenges. The report aims to equip readers with the knowledge necessary to make informed decisions regarding market entry, expansion, and investment in the Spanish pet care industry.
...
This report contains a detailed analysis of the pet grooming services market in Spain, with a particular focus on Barcelona. It provides practical insights for businesses, investors, and stakeholders, covering market size, growth forecasts, competitive environment, emerging trends, and potential challenges. The aim of the report is to provide readers with the necessary knowledge to make informed decisions regarding market entry, expansion, or investment in the pet care industry in Spain.
...
…
The full content of the study can be viewed here https://drive.google.com/file/d/1_aQbS1I6ECzPR3nbsXdK9BtEwU9cq0z6/view?usp=sharing
A preliminary estimate of the cost and timelines for similar work can be obtained here https://docs.google.com/forms/d/e/1FAIpQLSeLm9kT-9eevMU9Biojw5p3fpt6E81ULy_41cOkge8-tXJQ9A/viewform
#Market research
#Market assessment
#Market analysis
#Marketing research
#Company evaluation
#Financial model
#Business plan
#Business analyst
#Excel
#statista
-
114 USD Distributor's assortment and price parser
Data Parsing
#VBA tool (#Excel) that automatically collects, processes, and analyzes prices from an open source (competitor's website) and structures them in a convenient format for further analysis.
What the #parser does:
… Automatically updates data – downloads current prices from the source and updates the database without manual input.
Integration with analytics – collected data is automatically connected to pivot tables (#PivotTable), where average prices, price changes, etc., can be analyzed.
A similar solution can be implemented for almost any website and data: #marketplaces, supplier websites, #competitors, or price aggregators, etc.
Who needs this?
Wholesale and retail sellers, Importers – adjusting their own pricing policy
Manufacturers – monitoring changes in the cost of raw materials and finished products
Any business that wants to automate price monitoring
Market analysis for #business plans and pricing strategies
What does the client receive?
A ready #Excel file with all configured macros, formulas, and the ability to automatically update data.
User instructions – how to update data and set filters.
Expansion possibilities – new sources, additional analytical indicators, etc.
Contact us for consultation and #implementation!
#parsers
#Parsing
#parcer
#parsing
#Data
#Excel
#statista
#Market research
#Market assessment
#Market analysis
#Marketing research
#Business analyst
-
Market research of the fabric market in Ukraine
Marketing Research
This report presents a #marketing #market research of the fabric market in Ukraine as of 2024 with forecasts until 2026. It provides a detailed analysis of key industry segments, production and import dynamics, and the main factors affecting supply and demand.
The study includes strategic recommendations based on the example of business expansion by a medium wholesale player, making it a practical tool for scaling and adapting to real market conditions.
… At the client's request, the execution language is Russian.
The full content of the study can be viewed here https://drive.google.com/file/d/1WFfiKXjNh18KYEEvLD78a8BF1iEQ5kTE/view?usp=drive_link
A preliminary cost estimate and timeline for similar work can be obtained here https://docs.google.com/forms/d/e/1FAIpQLSeLm9kT-9eevMU9Biojw5p3fpt6E81ULy_41cOkge8-tXJQ9A/viewform
#Market research
#Market assessment
#Market analysis
#Marketing research
#Company assessment
#Financial model
#Business plan
#Business analyst
#Excel
#statista
-
Analysis of the real estate market in Cantabria
Marketing Research
The document presents a detailed analysis of the real estate market in the Cantabria region, Spain. It covers residential, industrial, tourist, and commercial real estate, as well as the transport infrastructure of the region.
The document contains statistical data, price trends, demand and supply analysis, as well as market development forecasts until 2034.
The study includes 16 examples of return on investment calculations for all types of real estate represented in the region - based on the increase in real estate prices over the next 5 years, from operational income, and from use in one's own business.
… The full content of the study can be viewed here https://drive.google.com/file/d/1smnzlFGR-SIRMt4NNIK-nasfgXrrR9uJ/view?usp=drive_link
The study can be adapted for other needs (goals and questions that need to be answered), for example, for another region of Spain. The execution time is 1 week (approx. cost 400€)
Also, a similar study can be conducted for any other EU country. The execution time is 2 weeks (approx. cost from 800€)
#Market research
#Market assessment
#Market analysis
#Marketing research
#Company valuation
#Financial model
#Business plan
#Business analyst
#Excel
#statista
#real-estate
-
341 USD Calculator for the calculation of capitalization of real estate objects
Data Processing
Based on Google Sheets, a calculator has been built that allows for a quick assessment of the potential of a real estate object for making the first decision regarding the feasibility of its acquisition (price forecast, costs, profitability, etc. for the next 5 years).
Calculations are carried out according to certain algorithms derived from the results of in-depth analysis of the real estate market in Spain, using auto-updating arrays of official statistical data (for example, current average real estate prices, rental prices, occupancy rates of tourist properties, etc. from the website https://www.ine.es/en/inebmenu/indice_en.htm).
… The user only needs to enter certain data about a specific real estate object and instantly receive estimates in seconds. Demo https://content.freelancehunt.com/snippet/c122a/c420a/1886569/%D0%97%D0%B0%D0%BF%D0%B8%D1%81%D1%8C+%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0+3+%28online-video-cutter.com%29+%281%29.mp4
#Automation
#Excel
#SQL
#Macros
#Dashboards
#Financial Indicators
#Operational Indicators
#Investments
#Data Visualization
#Project Management
#Google Sheets
#Decision-Making Tools
-
454 USD Business plan: Production of Smart furniture. DE
Consulting
The business plan is developed for a company specializing in the design and production of "smart furniture." The main goal is to obtain #financing from banks and private investors.
The plan includes market analysis, identification of key competitors, and analysis of their strengths and weaknesses (#SWOT).
… Sales, logistics, and collaboration strategies with partners, including technology companies and suppliers, are considered.
The business plan presents projected sales volume, #financial strategy, expected #profitability, and #return on investment.
Emphasis is also placed on the management structure, key participants of the startup team, and partnership opportunities.
#Risks of launching are considered, strategies for their minimization are proposed, and prospects for business expansion are outlined.
#Business plan
#Business analyst
#Market assessment
#Company evaluation
#Market analysis
#Marketing research
#Financial model
#Excel
-
454 USD Marketing research: Smart furniture market. DE & EU-27
Marketing Research
The research is aimed at analyzing the current state and development prospects of the Smart furniture market in Germany and the EU-27. The main goal is to identify key #trends, #market drivers, and opportunities for new players.
Geographical features, socio-economic factors, and legislative frameworks affecting the industry's development are studied. Special attention is paid to innovative technologies that shape market offerings.
… The market volume, dynamics, and #competitive environment, including the shares of leading companies, are assessed. Consumer preferences, #target group profiles, and #distribution channels are analyzed.
The research covers both #online and #offline sales channels, including marketplaces and the distributor network.
Future market growth is forecasted, and #risks related to regulatory and logistical aspects are identified.
The research provides recommendations for companies interested in entering this market. The conclusions contain key findings about the market prospects in the region.
#Market research
#Market assessment
#Market analysis
#Marketing research
#Company assessment
#Financial model
#Business plan
#Business analyst
#Excel
-
Business Data Management, Analysis and Visualization System
Enterprise Resource Planning (ERP)
Comprehensive solution for effective management that integrates data from various sources, automates accounting and analytics processes, visualizes, and provides tools for informed decision-making.
Data sources:
SevDesk, Revolut, Bank Austria: Data is imported automatically via #API.
… External sources (Statista, Google Travel Insights): Integration via API to obtain statistical data and trends (upon request).
Manual input: Data is also entered through forms created on Google Apps #Script and stored in #GoogleSheets.
Storage and processing:
All data is transmitted to Google #BigQuery, where separate datasets (#datasets) are created for automatically imported, manually entered, and external data.
Then, the data is cleaned, transformed, and aggregated using #SQL queries to create "cleaned" datasets - for further analysis and visualization.
Visualization:
Data from "cleaned" datasets is displayed in Google #DataStudio as interactive #dashboards, real-time reports, and charts with key performance indicators.
Detailed system description here https://drive.google.com/file/d/1jdr_8EYNPZ9XfHKVDjytqqXF4ThoAYyz/view?usp=sharing
#Business-plan
#Business-analyst
#Databases
#DashBoards
#ETL
#CRM
#GoogleSheets
#SQL
#Financial model
#Excel
-
114 USD Application for calculating and sending price proposals
Data Processing
A Google application has been developed for instant calculation and sending personalized price and deadline proposals to the email of a potential client https://docs.google.com/forms/d/e/1FAIpQLSeLm9kT-9eevMU9Biojw5p3fpt6E81ULy_41cOkge8-tXJQ9A/viewform
The calculation is based on data obtained through Google Forms.
Data from the form is entered into #GoogleSheets, where calculations are performed automatically, and then, after verification by the executor and using Google Apps Script, a PDF document with the price and deadline proposal is generated and sent to the specified email. The user can create a proposal and send it to the client with personalized text and email subject with the click of a button in the table.
… #Automation
#Excel
#GoogleSheets
#GoogleAppsScript
#GoogleForms
#Dashboards
#FinancialIndicators
#OperationalIndicators
#DecisionMakingTools
-
Calculator and report builder for forming financial reserves, DE
Enterprise Resource Planning (ERP)
As part of the project, a calculator and report builder (in Excel and Pdf using macros) was developed, designed to automate the process of forming cash reserves for payment for overtime work and for planned vacations, for a German company with over 1000 employees. Used: #Excel, #Power Query, #SQL, and #Macros, databases in #SAP.
#Automation
#Excel
… #Power Query
#SQL
#Macros
#SAP
#Dashboards
#Financial Indicators
#Operational Indicators
#Data Visualization
#Project Management
#Google Sheets
#Decision-Making Tools
-
454 USD Marketing research and SEO market analysis of Cybersecurity, World
Marketing Research
The project included a marketing research and SEO analysis of competitors in the global #Cybersecurity market, with a consolidated regional distribution (by continents). Key competitors, their strategies, traffic, traffic sources, and search queries were studied. Using #Statista and #Spyfu, the market size, regional demand, and competitors' #SEO strategies were analyzed. A keyword analysis, advertising queries, and positions in search engines (#SERP) were also conducted to identify optimization opportunities.
A preliminary cost estimate and timeline for similar work upon your request can be obtained here https://docs.google.com/forms/d/e/1FAIpQLSeLm9kT-9eevMU9Biojw5p3fpt6E81ULy_41cOkge8-tXJQ9A/viewform
… #Market analysis
#Marketing research
#SERP
#SEO
-
454 USD Market research of SEO services, EU
Marketing Research
As part of the project, a comprehensive marketing research of the #SEO services market in Europe was conducted. An analysis of market potential and growth opportunities by regions and industries was performed, the target audience was identified, and its behavioral characteristics and needs were studied. An analysis of consumer behavior was conducted to understand customer motivations. The activities of key competitors, their products, prices, and strategies were evaluated. The competitiveness of the client's services was analyzed. A #SWOT analysis was performed for strategic planning. Conclusions and recommendations were provided for business optimization and improving market positions.
A preliminary estimate of the cost and timelines for such work can be obtained here https://docs.google.com/forms/d/e/1FAIpQLSeLm9kT-9eevMU9Biojw5p3fpt6E81ULy_41cOkge8-tXJQ9A/viewform
… #Market analysis
#Marketing research
#swot-analysis
#SEO-specialist
-
454 USD Marketing research: The market for legal services in Germany
Marketing Research
Marketing Research: "The Market for Legal Services in Germany: State, Trends, Tendencies, and Key Players by Regions and Areas of Law"
A comprehensive study of the legal services market in Germany, focusing on regional distribution, areas of law, and types of services. The analysis covers key areas of law, including corporate, tax, labor, inheritance, criminal, family, and administrative law. Additionally, the research highlights regional trends in demand and supply, as well as identifies key profiles of major market players.
… Due to the terms of cooperation, details cannot be disclosed, thank you for your understanding.
#Business Plan
#Business Analyst
#Market Assessment
#Company Valuation
#Market Analysis
#Marketing Research
#Financial Model
#Excel
#Pitchdeck
#Pitch deck
-
795 USD Pitch deck, business plan and financial model, EU
Consulting
A market research of legal services in Germany and the EU has been completed. Based on this, a dynamic financial model, business plan (#Google Tabs), and #Pitchdeck (#Canva) have been developed for a network of consulting companies aimed at scaling the business through a franchising model.
Due to the terms of cooperation, details cannot be disclosed, thank you for your understanding.
… #Business-plan
#Business-analyst
#Market-evaluation
#Company-evaluation
#Market-analysis
#Marketing-research
#Financial-model
#Excel
#Pitchdeck
#Pitch deck
-
Data analysis system for Team / Project Manager, IT, UK
Enterprise Resource Planning (ERP)
In the framework of the project, the following was accomplished:
Data loading automation: Manual input was eliminated, reducing the risk of errors and speeding up information processing.
KPI calculation: Formulas and macros were created for the automatic calculation of key performance indicators (KPI), such as team productivity and budget execution.
Interactive dashboards: Dashboards were developed to display financial and operational metrics in real-time.
… Charts for analysis: Charts were created to analyze project progress, simplifying decision-making.
Automated reports: Automatic generation of weekly and monthly reports with detailed descriptions of expenses and progress was set up.
#Automation
#Key Performance Indicators (KPI)
#Macros
#Dashboards
#Financial Metrics
#Operational Metrics
#Data Visualization
#Project Management
#Google Sheets
#Decision-Making Tools
Reviews and compliments on completed projects 14
25 March
326 USD
Market analysis for a hybrid network of grooming salons
The freelancer did an excellent job: a deep and thorough market analysis, where every detail is elaborated and justified. The results turned out to be extremely useful for the development of my business. I am completely satisfied with the collaboration and recommend this specialist to anyone looking for a professional!
9 January
57 USD
Collect data on employees, analysis and visualization of KPI (Excel, Google Sheets, Google Studio)
Well-done work! The system for analyzing and visualizing labor costs and KPIs, developed by Olga a year ago, works flawlessly and is easily scalable, which was one of the key requirements. Will definitely return with a new project. Highly recommended!
9 December 2024
13 USD
Online Excel consultation
Thank you very much for your help! You dedicated even more time than we agreed!
8 November 2021
77 USD
Тестування гіпотези бізнес ідеї в соц меражах
Задание исполнено очень профессионально и в сроки. Быстрая обратная связь. Рекомендую!
20 September 2021
72 USD
Analysis of the cosmetic market of the US and Russia
The project is carried out at a highly professional level. Olga and her team did everything according to the agreement of the KP, a great analysis of the survey. I recommend cooperation.
14 September 2021
72 USD
Market analysis of divorce processes in the United States
The Olga team completed the project in time and in full. I advise for cooperation.
2 August 2021
92 USD
Собрать плацдарм ФПИ
Поставленная задача Ольгой выполнена.
14 May 2021
169 USD
The business plan
Excellent work, at a high level. Olga is a professional. I recommend !
14 April 2021
255 USD
Complete Marketing Analysis
Professionally conducted the market analysis of Proptech Solutions. I recommend cooperation.
9 April 2021
204 USD
Market research of potential B2B partners
Very pleased with cooperation! Professional, fast and correct. A very friendly and pleasant user in communication. We will be happy to get the next order.
| Response feedback
18 February 2021
102 USD
Developing a business model
Olga is a professional of his business. The business model she made on 10+.
It has been completely inserted into my numbers and all is realistically well written, I think it’s very important to insert what the customer wants.
I am very pleased with the project. I recommend it as a quality specialist.
Thank you very much for the quality work!
28 January 2021
51 USD
Проанализировать готовое маркетинговое исследование на 15 стр. — персональный проект для Olga Awdejew
Идеальное исполнение заказа, высокий профессионализм и стратегичное мышление. Качество работы превосходит ее стоимость.
27 January 2021
87 USD
Assessment of the effectiveness of the project
Everything in the highest class, everything I love. The task is done in time, the calculations are clear and transparent, the considerations are consistent and logical. Thank you, Olga, you gave me a great deal with this project.
13 October 2015
20 USD
Beautiful heating calculation
Everything was done exactly as it was ordered - very beautiful and very skillfully.
A rare combination.
I recommend it.
Activity
| Recent proposals 10 | Budget | Added | Terms | Proposal | |
|---|---|---|---|---|---|
|
Freelance-project |
|||||
|
Freelance-project |
|||||
|
Freelance-project
24 USD
|
|||||
|
Freelance-project |
|||||
|
Search and analysis of real estate objects (by artificial intelligence)
48 USD
|
|||||
Market analysis for a hybrid network of grooming salons
326 USD
|
|||||
|
Freelance-project |
|||||
|
Freelance-project
60 USD
|
|||||
|
Freelance-project
24 USD
|
|||||
|
Freelance-project |