Logo de Freelancer Cómo funcionaBusca trabajos
Iniciar sesión Registrarse
Publica un proyecto
EXPLORAR
Data Processing
Excel
Excel Macros
Finance
Visual Basic
Foto de portada de perfil
Ahora estás siguiendo a
Error al seguir a usuario.
Este usuario no permite que los usuarios lo sigan.
Ya estás siguiendo a este usuario.
Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.
Dejaste de seguir correctamente a
Error al dejar de seguir al usuario.
Has recomendado exitosamente a
Error al recomendar al usuario.
Algo salió mal. Por favor, actualiza la página e intenta de nuevo.
Email verificado correctamente.
Avatar del usuario
$15 USD / hora
Bandera de UKRAINE
kharkiv, ukraine
$15 USD / hora
Aquí son las 10:31 p. m.
Se unió el agosto 1, 2018
1 Recomendación

Viktoriia Z.

@hopkovictoria

 5,0 (5 comentarios)
5,1
5,1
100%
100%
$15 USD / hora
Bandera de UKRAINE
kharkiv, ukraine
$15 USD / hora
100 %
Trabajos finalizados
100 %
Dentro del presupuesto
100 %
A tiempo
N/A
Tasa de recontratación

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
Ver todo Excel Experts en Ukraine

Contacta Viktoriia Z. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Portafolio

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

Comentarios

Cambios guardados
Mostrando 1 - 5 de 5 reseñas
 Filtrar reseñas por:
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 más
Avatar del usuario
Bandera de Jason S.
@jasonsetzer81
•
hace 5 años
5,0
$30,00 USD
Excel SUMIFS and VLookup for multiple columns and two sheets
Excellent Excel Skills
Excel
Avatar del usuario
Bandera de Jason S.
@jasonsetzer81
•
hace 5 años
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
Bandera de Lukasz L.
@LukeWarsaw
•
hace 5 años
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
Avatar del usuario
Bandera de Nick L.
@nick727
•
hace 5 años
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
Bandera de Harry S.
@uksikh
•
hace 6 años

Experiencia

Business Intelligence Developer

VisiQuate Inc.
jun 2019 - nov 2021 (2 años, 5 meses)
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 meses, 1 día)
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.

Educación

Master's Degree

Kharkiv State Economics University, Ukraine 2011 - 2017
(6 años)

Calificaciones

MicroStrategy Analyst

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

Contacta Viktoriia Z. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Verificaciones

Freelancer preferente
Identidad verificada
Pago verificado
Teléfono verificado
Email verificado
Facebook conectado

Certificaciones

us_eng_1.png US English 1 75%

Principales habilidades

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

Explorar freelancers similares

Excel Experts in Ukraine
Excel Experts
Data Processing Executives
Financial Experts

Explorar galerías similares

Excel
Data Processing
Finance
Excel Macros
Usuario anterior Usuario siguiente
¡Invitación enviada correctamente!
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Logo de Freelancer Argentina / Español Ayuda y soporte Freelancer CategoríasProyectos Concursos Freelancers Empresarial MembresíaPrograma de Freelancers Preferentes Gestión del proyecto Trabajos localesPhoto Anywhere GaleríaAPI para desarrolladoresVerifícate Software de escritorio Información Quiénes somos Cómo funciona Seguridad Inversionista Mapa del sitio Historias NoticiasEquipoPremiosComunicados de prensaEmpleos Términos Política de privacidadTérminos y condicionesPolítica de derechos de autorCódigo de conductaCargos y TarifasSociosEscrow.comLoadshiftWarrior Forum Apps Logo de "App Store" de AppleLogo de Google Play
Falló el copiado al portapapeles. Intenta de nuevo después de ajustar tus permisos.
Copiado al portapapeles.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.