Freelancer logo How It Works Bla gjennom jobber
Logg inn Registrer deg
Legg ut et prosjekt
UTFORSK
Data Processing
Excel
Excel Macros
Finance
Visual Basic
Profilbilde
Du følger nå
Feil med følging av bruker.
Denne brukeren tillater ikke brukere å følge dem.
Du følger allerede denne brukeren.
Medlemskapsplanen din tillater bare 0 følginger. Oppgrader her.
Sluttet å følge
Kunne ikke slutte å følge bruker.
Du har vellykket anbefalt
Kunne ikke anbefale bruker.
Noe gikk galt. Oppdater siden og prøv igjen.
Vellykket bekreftelse av e-post.
Brukeravatar
$15 USD / time
UKRAINEs flagg
kharkiv, ukraine
$15 USD / time
Det er for øyeblikket 1:12 p.m. her
Ble med august 1, 2018
1 Anbefaling

Viktoriia Z.

@hopkovictoria

 5,0 (5 omtaler)
5,1
5,1
100%
100%
$15 USD / time
UKRAINEs flagg
kharkiv, ukraine
$15 USD / time
100 %
Jobber fullført
100 %
Innenfor budsjett
100 %
I tide
N/A
Gjenansettelsesrate

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
Se alle Excel Experts i Ukraine

Kontakte Viktoriia Z. angående jobben din

Logg inn for å diskutere eventuelle detaljer over chat.

Portefølje

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

Anmeldelser

Endringer lagret
Viser 1 - 5 av totalt 5 omtaler
 Filtrer anmeldelser etter:
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 flere
Brukeravatar
s flagg Jason S.
@jasonsetzer81
•
5 år siden
5,0
$30,00 USD
Excel SUMIFS and VLookup for multiple columns and two sheets
Excellent Excel Skills
Excel
Brukeravatar
s flagg Jason S.
@jasonsetzer81
•
5 år siden
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
s flagg Lukasz L.
@LukeWarsaw
•
5 år siden
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
Brukeravatar
s flagg Nick L.
@nick727
•
5 år siden
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
s flagg Harry S.
@uksikh
•
6 år siden

Erfaring

Business Intelligence Developer

VisiQuate Inc.
jun. 2019 - nov. 2021 (2 år, 5 måneder)
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"
okt. 2017 - mai 2018 (7 måneder, 1 dag)
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.

Utdanning

Master's Degree

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

Kvalifikasjoner

MicroStrategy Analyst

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

Kontakte Viktoriia Z. angående jobben din

Logg inn for å diskutere eventuelle detaljer over chat.

Verifiseringer

Foretrukket frilanser
Identitet verifisert
Betalingsverifisert
Telefonverifisert
E-postadresse verifisert
Koblet til Facebook

Sertifiseringer

us_eng_1.png US English 1 75%

Toppferdigheter

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

Bla i lignende frilansere

Excel Experts in Ukraine
Excel Experts
Data Processing Executives
Financial Experts

Bla i lignende utstillinger

Excel
Data Processing
Finance
Excel Macros
Forrige bruker Neste bruker
Invitasjonen ble sendt!
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Freelancer logo Norway / Norsk-Bokmål Hjelp og støtte Frilanser KategorierProsjekterKonkurranserFrilansereEnterprise MedlemskapForetrukken Frilanser-program ProsjektledelseLokale jobberPhoto AnywhereProsjektutstillingAPI for utviklereBli verifisertSkrivebordsapplikasjon Om Om ossHvordan det fungererSikkerhetInvestorSidekartHistorierI nyheteneTeamPremierPressemeldingerKarrierer Vilkår PersonvernBrukervilkårRetningslinjer for opphavsrettEtiske retningslinjerAvgifter og gebyrerPartnereEscrow.comLoadshiftWarrior Forum Apper Apple App Store logoGoogle Play logo
Kopiering til utklippstavlen mislyktes. Prøv igjen etter å ha justert tillatelsene dine.
Kopiert til utklippstavlen.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.