SSW Blog

A group of enterprise software developers specializing in Microsoft solutions

You are here: Home / Management / Power BI – The Six Reports Every Consultancy Should Have

Power BI – The Six Reports Every Consultancy Should Have

November 9, 2016 By Ulysses Maclaren Leave a Comment

I’ve been at SSW,  a medium sized custom software consultancy, for over 10 years, and in that time I’ve asked for a number of SQL Reporting Services reports to be made, but due to the difficulty in getting exactly what I needed out of the developers, I still had to make many decisions based on best guesses.

In the past year, since I’ve had access to Power BI and can make many of the required reports myself, this has sent me down a serious rabbit hole of discovery into what metrics I really need to run a software consultancy.

So here are the most important reports that I think every consultancy should have.

Financial Reports

Every responsible business owner / General Manager needs to keep their finger on the pulse of the financial health of their business. It’s also important to be able to drill down by both time (years, quarters, months) and expense types (salaries, fixed costs, variable costs, etc) to investigate anomalies.

Utilisation

As a services based business, how many hours you bill vs how many salaries you’re paying is a very good success marker. Keep track of how well each of your employees and offices are going with a Utilisation report. I’t s a good idea to look at this kind of report monthly to ask questions like:

  1. Should I hire / fire someone to grow / shrink one of the offices?
  2. If some people have low utilisation, can they be up-skilled, or is there a good reason that they need to work on internal things?

Client Overview

Your employees will need a nice easy way to get up to speed on the history of a particular client when they join a project or are speaking to them about potential new work. An Overview Report like the one above is a good way for them to get acclimatised. It shows:

  1. When / how much previous work has been done
  2. Who did that work
  3. What projects have been worked on
  4. What technologies those projects are/were built in

Technology (i.e. Income Streams)

As a software development company, our main way of splitting up income streams is by project technologies, but for you this could be any way of splitting the service you’re offering by skill types. The importance of this report is it allows us to know what technologies we should be focusing on with new hires, internal work, or up-skilling. For example, we can tell from the Trends visualisation on the top right above, that SharePoint is becoming less relevant for us, and Dynamics CRM work is becoming a larger proportion of our income.

Current Sales Opportunities

As a services company, you’re probably dealing with a relatively small number of high value companies, and it’s vital that your sales process is strong to keep work coming in. This report shows which of your sales people are dealing with which opportunity, and where those opportunities are coming in from. This report is the reason we opened up an office in Victoria, as we could easily see that there was enough demand there to justify it.

Booked in Days (Forecast)

In order to run a services company, you need a service calendar so you know who is available for client work and who’s already booked in or on leave. We use Dynamics CRM but built our own “booked in days” report as the out of the box one was hard to use. This was built in SQL Reporting Services, but will soon be redeveloped in Power BI.

The Rest

We have other reports that we use to drill down on a lot of the above info, such as conversion rates reports to see how successful our sales process is, or detailed invoicing and receipting reports to see how our clients are paying us and who are main clients are, but the above 6 will get you most of the way there.

Do you have any others that you think I should make? Please let me know in the comments below and I’ll see what else I can spin up.


[This post was originally published at https://ulyssesmaclaren.com/2016/10/24/power-bi-the-six-reports-every-consultancy-should-have]

Share with someone

Filed Under: Management Tagged With: Best, Business, Important, Management, Metrics, Power BI, Reports, Top

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About SSW

We are a group of enterprise software developers specializing in Microsoft solutions that today build on top of Angular, React, Azure, Azure DevOps, SharePoint, Office 365, .NET Core, WebAPI, Dynamics 365 and SQL Server and we have been delivering awesome solutions for over 25 years for more than 1,000 clients in 15 countries.

Fire Boot Camp - 9 Weeks Intensive .Net Developer Training

Dev Super Powers - Meet your superhero from the Microsoft Stack

Original Blogs

  • Adam Cogan
  • Anthony Ison
  • Brendan Richards
  • Jason Taylor
  • JK
  • Matthew Wicks
  • Mehmet Ozdemir
  • Ulysses MacLaren
  • William Liebenberg

Follow Us

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

SSW / SSW TVFollow

SSW / SSW TV
SSW_TVSSW / SSW TV@SSW_TV·
28 Feb

We are excited to announce that our new office in Newcastle is now open!

Join us for finger food, drinks and a chance to meet the team on March 12. @AdamCogan will also do a short talk for #developers ''7 Simple Steps to Building your Profile'': RSVP: https://t.co/MdIool2Za9

Reply on Twitter 1366158662612508686Retweet on Twitter 13661586626125086865Like on Twitter 13661586626125086865Twitter 1366158662612508686
SSW_TVSSW / SSW TV@SSW_TV·
19 Feb

Meet Jean Thirion! Jean is an SSW Solution Architect & Angular trainer. If you want to learn Angular, or you just need some new tricks & best practices - this is the course for you! Join our #ONLINE course in March. Early bird discount finishes soon!
➡️ https://t.co/pC09oij0Ji

Reply on Twitter 1362658209627004930Retweet on Twitter 1362658209627004930Like on Twitter 13626582096270049303Twitter 1362658209627004930
Retweet on TwitterSSW / SSW TV Retweeted
mattgoldmanMatt Goldman #BlackLivesMatter@mattgoldman·
6 Feb

Automagic Tenant Config for Mobile Apps

Check out my blog post:
https://t.co/3kisEtO0ly

#MobileApps #MobileDev #XamarinForms

Reply on Twitter 1358190776467947520Retweet on Twitter 13581907764679475204Like on Twitter 13581907764679475207Twitter 1358190776467947520
Retweet on TwitterSSW / SSW TV Retweeted
jasontaylordevJason Taylor@jasontaylordev·
18 Jan

I'm looking forward to running a 2-day workshop on Clean Architecture with #Net5 at #NDCLondon next week! See you there!😃
@NDC_Conferences
https://t.co/Ak5EOgak1P

Reply on Twitter 1351294683926781952Retweet on Twitter 13512946839267819527Like on Twitter 135129468392678195228Twitter 1351294683926781952
SSW_TVSSW / SSW TV@SSW_TV·
20 Jan

We're experiencing technical difficulties with our live feed widget, please join us for Matt Goldman's talk here until it's up and running! https://t.co/gdJJdtvEb5

Reply on Twitter 1351795851933446144Retweet on Twitter 13517958519334461441Like on Twitter 13517958519334461441Twitter 1351795851933446144
Load More...

Recent Posts

  • The 5 Technologies that Will Change Everything in the Next Decade
  • The Sunk Cost Fallacy
  • How to Delegate Effectively (Orders and Enrolment)
  • Power BI – The Six Reports Every Consultancy Should Have
  • Seven Tips to Being a Great Product Owner

Contact Sales

Australia
+61 2 9953 3000

China
+86 571 8517 8910

Contact Us

Copyright © 2021 SSW. All Rights Reserved.