Oleksandr K.
Offer Oleksandr work on your next project.
Private message
Offer work
Kyiv,
Ukraine
6 months 4 days back
available for hire
on the service 1 year
Rating
Successful projects
Average rating
Skills and abilities
Programming
-
Databases & SQL
from 14 USD for hour
Services
-
AI Consulting
from 27 USD for hour
-
Customer Support
from 9 USD for hour
-
Data Processing
from 14 USD for hour
-
Enterprise Resource Planning (ERP)
from 23 USD for hour
-
Information Gathering
from 9 USD for hour
Promotion
-
Search Engine Optimization (SEO)
from 18 USD for hour
Administration
-
System & Network Administration
from 18 USD for hour
Outsourcing & consulting
-
Accounting Services
from 18 USD for hour
-
Client Management & CRM
from 18 USD for hour
Portfolio
-
68 USD Sales Analysis Dashboard
Accounting Services
Project description:
This interactive sales analysis dashboard helps visualize key business metrics, track profit, and analyze sales dynamics by product categories, countries, and payment methods.
Tools used:
… Excel (pivot tables, charts, conditional formatting)
Power Query (data processing and transformation)
Segments and timeline (for data filtering)
Excel formulas (SUMIFS, INDEX+MATCH, GETPIVOTDATA)
Functionality:
Visualization of total revenue and profit of the company
Sales dynamics by months and quarters
Analysis of the most profitable product categories
Payment distribution (cash, check, card)
Interactive filters for quick analytics
-
23 USD Interactive sales dashboard in Excel | Analytics and visualization
Created a professional sales dashboard in Excel for data analysis for January-February 2024.
What is included:
… Data processing and structuring
Dynamic filters by categories, cities, managers
Automated sales visualization (charts, diagrams)
User-friendly interface for analytics
The dashboard helps quickly identify key trends and metrics, simplifying decision-making in business.
Technologies: Microsoft Excel, Pivot Tables, Power Query
Ready to create a similar project for you!
-
68 USD CRM system in Excel (Light version) with analytics and deal statuses
CRM system in Excel (Light version) for managing clients and deals
Project description:
I developed a convenient and functional CRM system in Excel that allows for tracking clients, controlling deals, and analyzing financial indicators.
… Main features:
Client database – storing contacts and deal history.
Deal statuses – "New", "In Progress", "Closed" with automatic counting.
Financial analysis – total deal amount, active and completed deals.
Dashboard – interactive charts and pivot tables for analytics.
Conditional formatting – color highlighting of statuses for quick analysis.
Possible improvements:
Adding VBA macros for process automation.
Integration with Google Sheets or Power BI for advanced analysis.
Automatic report generation by periods.
An ideal solution for small and medium-sized businesses that replaces complex and expensive CRM systems.
Ready to develop a similar solution tailored to your needs!
-
45 USD Interactive dashboard in Excel for sales analysis
Created a dashboard in Microsoft Excel for analyzing the company's sales. Functionality:
Dynamic filters by managers, cities, dates, and product categories
Automatic highlighting of data using conditional formatting
Charts and pivot tables for visual representation of data
… Fully automated report without the use of macros
Such a dashboard helps to quickly obtain analytics suitable for sales departments, financial analysts, and managers.
Activity
| Latest proposals 4 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Excel table
16 USD
|
|||||
|
Marketing analytics Power BI / Tableau
136 USD
|
|||||
|
Filling in product cards on the website and marketplaces for 27 positions
34 USD
|
|||||
|
Excel template for accepting print orders (calculation)
25 USD
|
