Business Analysis
I identify weak points, metric drops, missing data and the drivers behind performance changes.
Freelance BI & Data Analyst
BI solutions
for clear decisions.
I build Power BI reports, automated reporting flows, and analytics models that turn scattered data into trusted business decisions.
30+ BI reports shipped
15+ sources integrated
End-to-end BI solutions
Power BIPower BI ServiceRLSMS FabricDatabricksApache SupersetSQLPythonDAX
Available for BI & analytics projects
BI projects delivered
30+
Sources integrated
15+
Scroll to explore
01
About me
I'm Dmitrii. I do more than build dashboards. I turn messy operational data into clean models, KPI logic, automated reports, and business analysis that teams can use every day.
Complete BI solutions, not just dashboard visuals.
I take BI projects from source systems to production reporting: connecting data from a DWH, APIs or files, cleaning and validating it, building data marts and semantic models, publishing reports in Power BI Service, setting up scheduled refresh, and keeping the logic understandable for the business.
DWH / API / files
Data mart and model
Power BI Service
Refresh and insights
Strongest background
Deep expertise in automotive processes: warranty, budgeting, dealer networks and spare parts. My strongest domain knowledge is in automotive: warranty, field performance, e-mobility, product quality, budgeting and parts analytics. I have also delivered analytics projects for restaurant chains and FMCG use cases.Data Foundation
I extract, clean, validate and reconcile data, then shape it into a reliable data mart or semantic model.
Production Reporting
I build reports that refresh regularly, run in Power BI Service and support ongoing decisions.
02
Selected work
BI cases built for clarity and action.
Power BI · Failure analysis
Failure Analysis Dashboard
Product failure analysis dashboard for spotting patterns, comparing drivers, and turning quality signals into clear next actions.
Problem
Manual and fragmented analysis made it hard to detect abnormal product behavior, compare segments and evaluate corrective actions.
Solution
Built an end-to-end Power BI solution with unified data modeling, daily Dataflows refresh, advanced filters and a custom Deneb "Starry Sky" scatter plot.
Impact
Enabled faster pattern and anomaly detection, reduced manual effort and created a reusable foundation for performance monitoring.
Power BI · Restaurant analytics
Restaurant
Restaurant performance dashboard for monitoring sales, menu dynamics, and operating signals in one interactive view.
Problem
Reporting was handled in Excel, which made daily analysis slow, fragmented and difficult to scale for managers.
Solution
Moved restaurant analytics into Power BI, creating an interactive reporting layer for revenue, plan tracking and staff performance.
Impact
Managers can monitor daily performance more easily and plan kitchen and hall workload based on clearer operational signals.
Power BI · Decision support
Dealer Service ROI Calculator
Interactive decision-support tool for estimating dealer service ROI and comparing business scenarios before committing resources.
Problem
Dealer network managers lacked a structured way to evaluate repair capability investments across products, regions and service partners.
Solution
Built a parameter-driven Power BI model with scenario inputs, ROI logic, payback calculation and multi-year financial projections.
Impact
Standardized investment evaluation, reduced manual assumptions and aligned technical repair scenarios with financial outcomes.
Power BI · Performance optimization
Power BI Performance Optimization
Optimization case focused on refresh performance, DAX tuning and scalable architecture between SAP Datasphere and Power BI.
Problem
The existing BI solution had almost 3-hour refreshes, heavy Power Query logic, slow visuals and complex DAX that limited scalability.
Solution
Moved heavy transformations to SAP Datasphere, simplified Power Query, refactored DAX measures and validated results with Performance Analyzer and DAX Studio.
Impact
Reduced refresh time to 45-50 minutes, cut selected visual execution below 0.5 seconds and reduced Storage Engine queries from 775 to 34.
03
Have data?
Start a project
Have data?
Let's make it useful.
Tell me about your challenge. I will get back to you with ideas on how we can solve it.