← Back to Learning Hub

Javed Nilgar

BI Practitioner · Power BI · SQL · Data Analytics · Ahmedabad, India

I am a data and business intelligence practitioner with 19 years of experience across MIS reporting, business intelligence, and data-driven decision support in the travel and technology industry. I specialise in Power BI — from data modelling and DAX through to dashboard design, forecasting, and publishing to Power BI Service.

Before moving into dedicated BI work, I spent years in MIS and business analysis roles, building the data intuition that now underpins everything I write. This blog documents what I have learned — the patterns, the tradeoffs, and the decisions that separate dashboards that get used from dashboards that get ignored.

I hold a BCA with a specialisation in Business Intelligence from Amity Online University, completed as a deliberate upskilling decision alongside my professional career rather than as a foundation for it. I am also certified in SQL, Python, and Advanced Excel.

Certifications

BCA — BI SpecialisationAmity Online University · 2021–2024
SQLSoloLearn · Certified
Python CoreSoloLearn · Certified
Advanced ExcelAmity University · Certified

Technical skills

Power BI Desktop Power BI Service DAX Power Query (M-Query) SQL Python Advanced Excel Star Schema Design KPI Dashboard Design Data Modelling Time Intelligence Forecasting Data Storytelling Q&A Natural Language

About this blog

Everything published here is drawn from real project experience — real datasets, real dashboard challenges, real design decisions. The tutorials are practical rather than theoretical: they start with the problem a business user has and work backwards to the tool or technique that solves it.

The goal is to write the articles I wish had existed when I was first learning Power BI and building dashboards from scratch. If you are a data analyst, a BI practitioner, or someone who works with business data and wants to make it more useful — this blog is written for you.