IT Spend Analysis sample for Power BI: Take a tour
Overview of the IT Spend Analysis sample
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.
Get the content pack for this sample
- Open the Power BI service (app.powerbi.com) and log in.
In the bottom left corner select Get data.
On the Get Data page that appears, select the Samples icon.
Select the IT Spend Analysis Sample, then choose Connect.
Power BI imports the content pack and adds a new dashboard, report, and dataset to your current workspace. The new content is marked with a yellow asterisk.
Get the .pbix file for this sample
Alternatively, you can download the sample as a .pbix file, which is designed for use with Power BI Desktop.
Get the Excel workbook for this sample
You can also download just the dataset (Excel workbook) for this sample. The workbook contains Power View sheets that you can view and modify. To see the raw data select Power Pivot > Manage.
The IT Spend Analysis Sample dashboard
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?
“YTD IT Spend Trend Analysis” page
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.
Ask questions of the data
- Select IT Spend Analysis Sample in the top navigation bar to return to the Dashboards.
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.
“YTD Spend by Cost Elements” page
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.
“Plan Variance Analysis” page
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.
Edit the report
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.
Next steps: Connect to your data
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.