Надія

NADIIA PRUDNIKOVA
Junior Data & BI Analyst
📞[відкрити контакти](див. вище в блоці «контактна інформація») |📧 [відкрити контакти](див. вище в блоці «контактна інформація») | 💬 @NadiiaPrudnikova | 📍Kyiv, Ukraine
LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація»)

SUMMARY: Junior Data & BI Analyst with a strong foundation in business reporting, data modeling, and
visualization. Hands-on experience in building interactive multi-page dashboards in Power BI (Star Schema, DAX,
Power Query), conducting cohort analysis in SQL, and exploratory data analysis (EDA) in Python and Tableau.
Passionate about transforming complex datasets into clear, actionable business insights and supporting data-driven
decisions. In addition, I have experience with website content management and publishing blog articles using
WordPress.

HARD SKILLS: Power BI (Desktop), DAX, Power Query, Data Modeling, Star Schema, Drillthrough, Bookmarks,
Tableau, SQL (PostgreSQL), Python (Pandas, NumPy, Matplotlib, Seaborn), Data Cleaning & Transformation,
Exploratory Data Analysis (EDA), Cohort Analysis, A/B Testing, Statistical Analysis, Data Storytelling, KPI Analysis,
Product Metrics (Conversion, Retention, Churn, ARPU, LTV).

TOOLS: Pandas, NumPy, Matplotlib, Seaborn, PostgreSQL, Tableau, Power BI, Excel, Google Sheets, Jupyter
Notebook, Github.

SOFT SKILLS: Analytical Thinking, Problem Solving, Attention to Detail, Communication, Teamwork,
Adaptability, Time Management.

PROJECT EXPERIENCE
Power BI Sales & Logistics Dashboard (Northwind Traders) | View Presentation
Tools: Power BI, DAX, Power Query, Star Schema, Data Modeling
Description: Developed an end-to-end interactive 4-page Power BI report analyzing $1.27M in revenue, carrier
logistics performance (SLA), and sales staff efficiency.
My Tasks:
● Designed a Star Schema relational data model (1-to-Many) connecting Fact and Dimension tables.
● Cleaned, transformed, and typed raw data in Power Query; generated a custom DimDate calendar table.
● Developed custom DAX measures for Net Sales, Discounts, YoY trends, and Delivery Delays (% Late Orders
using VAR, CALCULATE, DIVIDE).
● Configured automated Drillthrough order detailing and Bookmarks navigation for optimized UX.
Result: Delivered an executive-ready dashboard enabling stakeholders to monitor financial KPIs, evaluate carrier SLA
compliance, and identify employee sales bottlenecks.

Stack Overflow Developer Survey Analysis | Google Colab Notebook
Tools: Python, Pandas, NumPy, Matplotlib, Seaborn
Description: Conducted analysis of Stack Overflow Developer Survey data to identify key trends in
technologies, salary levels, and professional experience.
My Tasks:
● Data cleaning and preprocessing
● Exploratory data analysis
● Trend analysis (technologies, salary, experience)
● Data visualization and insight generation
● Presentation of findings
Result: Identified key industry trends and provided insights into developer technologies, compensation, and
experience distribution.

User Retention Analysis (Cohort Analysis) | Cohort Analysis Dashboard
Tools: SQL, PostgreSQL, Google Sheets
Description: Analyzed user retention and acquisition channels using cohort analysis.

My Tasks:
● Data extraction using SQL queries
● Cohort definition and segmentation
● Retention rate calculation
● Channel performance comparison
● Data aggregation in Google Sheets
Result: Identified retention patterns and the most effective acquisition channels based on user
engagement over time.

A/B Testing Analysis | Google Colab Notebook
Tools: Python, Pandas, NumPy, Statsmodels, Tableau
Description: Conducted statistical analysis of A/B testing results to evaluate conversion performance and user
behavior.
My Tasks:
● Data preparation and validation
● Conversion rate analysis
● Hypothesis testing
● Statistical significance testing
● Dashboard creation and presentation of findings
Result: Identified the most effective variation and provided data-driven recommendations for improving conversion
rates.

WORK EXPERIENCE
Computer Systems Analyst / Data Analyst | PJSC MHP
2007 – 2015
● Analyzed telecommunications expenses and usage data across multiple business units. ●
Developed analytical reports, forecasts, and cost optimization recommendations. ● Monitored KPIs
and supported data-driven decision-making.
● Collaborated with suppliers and internal stakeholders.
● Standardized reporting and documentation processes.
Achievement: Implemented cost optimization initiatives and improved expense monitoring and reporting processes.
Assistant | LLC Amrita
2006 – 2007
● Analyzed sales performance data.
● Prepared analytical reports and presentations.
● Identified opportunities to improve sales performance.
Achievement: Supported management decision-making through regular reporting and analysis.

EDUCATION
IT School GoIT National Technical University of Ukraine
Data Analytics Program | 2025–2026 "Igor Sikorsky Kyiv Polytechnic Institute" —
Specialist Degree, Automation & Computer
Integrated Technologies | 2001–2007

LANGUAGES
English — Pre-Intermediate (B1) Ukrainian — Native