analyst.az

Analytics that turns your numbers into decisions

I bring your sales, finance and operations data into one place, automate the reports that are still built by hand, and build dashboards that give management a clear picture every day.

Get in touchSee services
01020304050JanFebMarAprMayJunJulAugSepOctNovDec123
  1. The report is assembled by hand from 6 Excel files
  2. Sources merged into a single database
  3. The dashboard refreshes automatically every morning
Sample project: time spent preparing the monthly reporthours: 42 → 6

How I can help

Every engagement ends with a measurable result: a working dashboard, a model or an automated process.

  • Dashboards and BI reporting

    Sales, finance and operations metrics in one dashboard. Management sees refreshed numbers every morning instead of hunting for files.

    Tools: Power BI, Looker Studio

  • Financial analysis and modelling

    Cash flow, profit and loss, budget vs. actual and forecast models, so you can see the scenarios before you decide.

    Tools: Excel, Python

  • Report automation

    I turn Excel reports that are assembled by hand every month into an automated process. Your team spends its time on analysis, not on reporting.

    Tools: Power Query, SQL, Python

  • Data audit and cleanup

    I find mismatches between systems, remove duplicate and incorrect records, and build a single database you can rely on.

    Tools: SQL, PostgreSQL, 1C

  • Training and advisory

    I teach your team to build and update their own reports, and we set the rules for analytical work together.

    Tools: Excel, Power BI

Selected projects

Every project starts with one metric to improve. Below you can see how that metric changed.

Retail chainSample

Weekly sales report: from 3 days to 15 minutes

Till data from 28 stores is collected automatically, and management opens a ready dashboard every Monday morning.

Before
3 days
Now
15 min

DistributionSample

Overdue receivables down 38%

An ageing report by customer and daily alerts helped the sales team spot late payments early.

Before
AZN 412k
Now
AZN 255k

Services companySample

Budget variance down to ±4%

A budget model was built by department, and spending is compared with actuals automatically every month.

Before
±18%
Now
±4%

How we work

You know in advance what you get at the end of each stage.

  1. Intro meeting

    I listen to your goals, the decisions you make and the data you have today.

  2. Data audit

    I review sources, quality and gaps, and send a written proposal with scope and timeline.

  3. Build

    The model, dashboard or automation is built in stages. We review the result together every week.

  4. Handover and support

    I train your team, hand over the documentation and stay available during the first months.

About

I'm [Ad Soyad], a data and financial analyst. For [X] years I have been helping companies make decisions based on their accounting, sales and operations data.

My main principle is simple: a report only creates value when it is read and acted on. That is why I build every dashboard together with the people who will use it.

Everyday tools

  • Power BI
  • Excel / Power Query
  • SQL
  • PostgreSQL
  • Python
  • Looker Studio
  • 1C

Let's talk about your data

Briefly describe your situation: which reports you have and what you want to see. I will get back to you shortly.