The IT Spend Analysis content pack(dashboard, report, and dataset) analyze the planned vs. actual costs of an IT department. This comparison helps us understand how well the company planned for the year and investigate areas with huge deviations from the plan. The company in this example goes through a yearly planning cycle, and then quarterly it produces a new Latest Estimate (LE) to help analyze changes in IT spend over the fiscal year.
This sample is part of a series that illustrates how you can use Power BI with business-oriented data, reports and dashboards. This is real data from obviEnce (http://obvience.com/) that has been anonymized.
The two numbers tiles on the dashboard, the Var Plan % and Variance Latest Estimate % Quarter 3, give us an overview of how well we are doing against plan and against the Latest Qtr estimate (LE3 = Latest Estimate Quarter 3). Overall we are about 6% off the plan. Let’s explore the cause of this variance – when, where, and which category?
Selecting the Var Plan % by Sales Region dashboard tile takes you to the “IT Spend Trend Analysis” page of the IT Spend Analysis Sample report. We see at a glance that we have positive variance in US and Europe and negative variance in Canada, Latin America, and Australia. US had about 6% +LE variance and Australia has about 7% -LE variance.
But just looking at this chart and drawing conclusions can be misleading. We need to look at actual dollar amounts to put things in perspective.
Select Aus and NZ in the Var Plan % by Sales Region chart, and observe Var Plan by IT Area chart.
Now select USA. You get the idea — Australia is a really small part of our overall spend as compared to US.
So we narrowed it down to the USA, now what? Let’s explore which category in the USA is causing the variance.
Select Power BI in the top navigation bar to return to the dashboard.
In the question box, type “show IT areas, var plan % and var le3 % bar chart”.
In the first IT area, Infrastructure, the percentage has changed drastically between the initial variance plan and the variance plan latest estimate.
Go back to the dashboard and look at the Var Plan %, Var LE3% dashboard tile.
Infrastructure jumps out with huge positive variance to plan.
Click this tile to go to the “YTD Spend by Cost Elements” page of the IT Spend Analysis Sample report.
Click the Infrastructure bar in the “Var Plan % and Var LE3 % by IT Area” chart in the lower left, and observe the variance to plan in the "Var Plan % by Sales Region" to the left.
Click the name of each Cost Element Group in the slicer to find the cost element with a large variance.
With Other selected, click Infrastructure in the IT Area and click the sub areas in the IT Sub Area slicer to find the sub area with the largest variance.
We see a huge variance in Networking.
Apparently the company decided to give its employees phone services as a benefit but this move was not planned for.
Still in the report, click the "Plan Variance Analysis" tab on the bottom of the report to go to page 3 of the report.
In the “Var Plan, and Var Plan % by Business Area” combo chart on the left, click the Infrastructure column to highlight infrastructure values in the rest of the page.
Notice on the “Var plan% by Month and Business Area” chart that infrastructure started to have a positive variance around February and then it keeps increasing. Also, notice how the variance to plan value for infrastructure varies by country, compared to the value for all business areas. Use the “IT Area” and “IT Sub Areas” slicers on the right to filter the values in the rest of the page rather than highlighting them. Click the different IT Areas on the right to explore the data in another way. You can also click IT Sub Areas and see the variance at that level.
Click Edit Report in the upper-left corner and explore in Editing View.
See how the pages are made – the fields in each chart, filters on the pages
Add pages and charts based on the same data
Change the visualization type for each chart
Pin them to your dashboard
This is a safe environment to play in. You can always choose not to save your changes. But if you do save them, you can always go to Get Data for a new copy of this sample.
We hope this tour has shown how Power BI dashboards, Q&A, and reports can provide insights into IT spend data. Now it is your turn — connect to your own data. With Power BI you can connect to a wide variety of data sources. Learn more about getting started with Power BI.