Skip to content

Kabir Malhotra

Business Intelligence Analyst

I build the dashboards finance and operations teams open every morning, and the data models that keep them honest.

Open to BI roles in Pune or remote

About me

Six years in reporting and BI, most of them close to finance. I start every dashboard by asking who will open it and what they will decide, then work backwards to the model and the data.

I care about one version of the truth: tested measures, documented definitions and refreshes that do not fail on the first of the month.

Download my resume

Experience

  1. Senior BI Analyst

    Apr 2023 - Present

    Manufacturing group, Pune

    Own the finance and supply chain dashboards for 14 plants. Moved 40 Excel reports to one Power BI model.

    • Power BI
    • DAX
    • Azure SQL
  2. BI Analyst

    Jan 2021 - Mar 2023

    Logistics startup, Pune

    Built the delivery performance dashboard used in every weekly business review.

    • Tableau
    • PostgreSQL
    • dbt
  3. MIS Executive

    Jun 2019 - Dec 2020

    Private bank, Mumbai

    Automated branch reports with SQL and VBA, saving the team two days a month.

    • Excel
    • VBA
    • SQL Server

Dashboards

  • Monthly reports kept by hand: 40, 34, 25, 14, 6, 0.

    -100%

    Plant cost dashboard

    Power BI · 2025

    One page per plant showing cost per unit against budget, with drill-through to the cost centre.

    • 40 reports retired
    • 3 days faster close

    See the build: Plant cost dashboard

  • On-time deliveries, %: 78, 80, 79, 83, 86, 88, 89.

    89%

    On-time delivery tracker

    Tableau · 2022

    Delivery promises against actual drop times by city, rider shift and weather.

    • +11 pts on-time rate

    Open the viz: On-time delivery tracker

  • Branches on the new pack: 120 of 120 done.

    120 of 120branches

    Branch reporting pack

    Excel and SQL · 2020

    A refreshable workbook that replaced 120 hand-made branch reports every month.

    See the build: Branch reporting pack

Tools

  • Power BIDAX, Power Query
  • TableauPrep and Desktop
  • SQLPostgreSQL, Azure
  • ExcelVBA, Power Pivot
  • dbtModels and tests
  • Pythonpandas

Certifications

Get in touch

Hiring for a BI role or need a dashboard rebuilt? Tell me a little about it.