Professional KPI series 1 Part 1-The Trend Indicator

Shashanka Shekhar
Microsoft Power BI
Published in
6 min readFeb 15, 2024

--

Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create interactive dashboards and reports. Power BI can help you gain insights from your data and communicate them effectively.

What is a KPI?

A KPI, or a key performance indicator, is a measurable target that shows how well an individual or a business is performing in terms of meeting their goals. KPIs can be financial, such as net profit or revenue, or nonfinancial, such as customer satisfaction or retention. KPIs help organizations track their progress, identify their strengths and weaknesses, and make informed decisions to improve their outcomes.

Building the KPI

We will be making this KPI:

The Professional KPI we will be making

Here we have YTD and YoY percentage calculations followed by an Area chart of current year sales.

Regarding the distribution of articles

Now this KPI will take time to make so if I include everything in one article it is going to be long and cumbersome to read and follow, so I have divided the entire KPI building process into three small parts with each part covering some portion and everything will come together in the final part.

--

--

Shashanka Shekhar
Microsoft Power BI

Contributor for Microsoft Power BI. I like Data Analysis and Data Science. Also I enjoy sports, videogames and Japanese Anime in my free time.