Freelancer logo How It Works Browse Jobs
Log In Sign Up
Post a Project
EXPLORE
Data Processing
Excel
Excel Macros
Finance
Visual Basic
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$15 USD / hour
Flag of UKRAINE
kharkiv, ukraine
$15 USD / hour
It's currently 4:21 AM here
Joined August 1, 2018
1 Recommendation

Viktoriia Z.

@hopkovictoria

 5.0 (5 reviews)
5.1
5.1
100%
100%
$15 USD / hour
Flag of UKRAINE
kharkiv, ukraine
$15 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
N/A
Repeat Hire Rate

Automated Excel Tools for Business Analysis

Hi! I am a BI developer with economic background from Ukraine. I am especially interested in business analysis and automation of business processes in Excel. In order to find the solution, I use complex functions with comprehensive logic, array formulas, charting and sparklines, conditional formatting, pivot tables and slicers, data protection, basic knowledge of macros (VBA). You can find my previous works on my YouTube channel: [login to view URL] Also, I worked with big data using the program MicroStrategy connected to MS SQL Server. In the future, I am going to learn other business intelligence tools such as Power BI, Tableau etc. in order to be able to deliver clear analytics for your business needs. Have a nice day and lots of smiles!
Freelancer Excel Experts Ukraine
See all Excel Experts in Ukraine

Contact Viktoriia Z. about your job

Log in to discuss any details over chat.

Portfolio

4707272
Credit Calculator
Credit Calculator
4510546
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
4373937
The task was done using conditional formatting. You can add new products and dates by copy-paste of the previous ones. See how it works: https://youtu.be/gThJEKpIOYQ
Product Lifecycle Matrix
4391486
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
4333452
The user fills the data in the table. New dates are added to the drop-down list automatically, the data source for the charts is also updated automatically.
Charts with floating dates
4707272
Credit Calculator
Credit Calculator
4510546
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
4373937
The task was done using conditional formatting. You can add new products and dates by copy-paste of the previous ones. See how it works: https://youtu.be/gThJEKpIOYQ
Product Lifecycle Matrix
4391486
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
4333452
The user fills the data in the table. New dates are added to the drop-down list automatically, the data source for the charts is also updated automatically.
Charts with floating dates

Reviews

Changes saved
Showing 1 - 5 out of 5 reviews
Filter reviews by:
5.0
$3,253.82 USD
Project for Victoria H.
Victoria worked on multiple financial and operational report projects ~400 hours - for me for well over a year and did an outstanding job. She was very meticulous and was always available when needed. If you have any Excel work she should be your go to freelancers
Excel
Finance
English (UK) Translator
English (US) Translator
+1 more
User Avatar
Flag of Jason S.
@jasonsetzer81
•
5 years ago
5.0
$30.00 USD
Excel SUMIFS and VLookup for multiple columns and two sheets
Excellent Excel Skills
Excel
User Avatar
Flag of Jason S.
@jasonsetzer81
•
6 years ago
5.0
$25.00 USD
Creative business name for recruitment company with free .com domain
Victoria invented a great name for our company. Not a straightforward connection of words but something more sophisticated!
Catch Phrases
Creative Writing
Internet Marketing
Marketing
Slogans
L
Flag of Lukasz L.
@LukeWarsaw
•
6 years ago
5.0
$100.00 AUD
Excell Spread Sheet to Calculate Life Insurance requirements
Brilliant work from Victoria. She was presented a difficult task which included complex mathematical formulas and resolved this promptly. Her quality of work is very professional, i look forward to getting her help again. Thank you Victoria!!
Data Processing
Excel
User Avatar
Flag of Nick L.
@nick727
•
6 years ago
5.0
$25.00 USD
Formula for MS Excel needed to round up or down timings into a banding
very good and quick
Data Entry
Data Processing
Excel
Mathematics
U
Flag of Harry S.
@uksikh
•
6 years ago

Experience

Business Intelligence Developer

VisiQuate Inc.
Jun 2019 - Nov 2021 (2 years, 5 months)
Worked with the program MicroStrategy on different big data projects in the American medical business area. Data was stored in MS SQL Server databases. Duties: • environment configuration, building of attributes, metrics, reports, cubes, dashboards, visual insights, subscriptions from scratch; • supervision of the daily ETL process; • optimization of cubes, reports and dashboards performance; • creation of new users and provision of appropriate accesses.

Economist of the Risk Management Department

PJSC "MEGABANK"
Oct 2017 - May 2018 (7 months, 1 day)
Duties: - identification, monitoring, analysis of the bank's risks; - control of the existing risks level and accordance of the bank's performance with economic standards; - monitoring of employees' knowledge of operational risk (data collection and analysis); - monthly reporting on risks for the top management and the National Bank of Ukraine in tabular and graphical form; - providing recommendations for minimizing risks.

Education

Master's Degree

Kharkiv State Economics University, Ukraine 2011 - 2017
(6 years)

Qualifications

MicroStrategy Analyst

MicroStrategy
2020
https://www.credential.net/6970fca2-a5ff-4d11-82df-446503e4c5ac#gs.uaazmj (my last name has changed)

Contact Viktoriia Z. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

us_eng_1.png US English 1 75%

Top Skills

Excel 5
Data Processing 2
Finance 2
Excel Macros 2
Visual Basic

Browse Similar Freelancers

Excel Experts in Ukraine
Excel Experts
Data Processing Executives
Financial Experts

Browse Similar Showcases

Excel
Data Processing
Finance
Excel Macros
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo US (International) / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App About About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers Terms Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges Partners Escrow.com Loadshift Warrior Forum Apps Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
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.