Self Service BI: Has Microsoft Found the Solution to Simple Excel Reporting?

Hear how QUANTIQ fix the pain-points in your ERP solution

Self Service BI: Has Microsoft Found the Solution to Simple Excel Reporting?

It is sometimes difficult to think of things Microsoft Excel can’t be used for in business. For so long a staple part of the Microsoft Office suite, Excel has become to spreadsheet software what Word is to word processing, or Powerpoint to presentations – the default programme entire generations of people have grown up with and use loyally to this day. That’s where self service BI comes in.

That, however, is doing Excel a slight disservice. It’s popularity is not simply down to Microsoft’s market penetration. Its number crunching and data processing tools have set the standard for nearly every other piece of spreadsheet software. And so flexible, user-friendly and familiar are those tools, that millions of business users worldwide opt to use Excel for a myriad range of business operations even when there are more specialised software platforms available.

Accounts, payroll, CRMERP, business modelling, design and engineering – Excel was not built specifically to do any of these, but can and has been harnessed to perform them all, plus many, many more. Indeed, so widespread is the use of Excel formulas and pivot tables, they are sometimes labelled the world’s most popular programming languages.

There is one thing, however, that Excel has never been so great at. As powerful as it is as a data processing tool, turning Excel data tables into actionable business intelligence (BI) – running analytics, finding the patterns, taking crunched numbers and presenting them in a way that is intuitive, intelligible and pretty – has never been all that straightforward.

If you want to analyse and visualise Excel data, your options have either been to bring in a BI specialist, or in more recent times use one of the external plug-ins Microsoft has made available.

But all that has changed.

Organisations worldwide are using Power BI

Microsoft’s Power brand of BI tools originally took the form of four separate applications which could be plugged into Excel. And while each was very powerful in its own right, a lack of consistency and integration between each app meant running longer streams of analysis and reporting could be complex. So if you, for example, wanted to run analysis on a data set in Power Pivot, but then visualise your findings in Power View, there was no natural flow between the two stages. You would have to export from one to the other, and ended up using different interfaces and tools.

For the average Excel user, this was a lot to handle.

Then, in 2015, Microsoft launched Power BI, a so-called ‘self-service’ cloud business intelligence suite intended to compete with the likes of Tableau. Self service BI is basically shorthand for user-friendly and intuitive. As is typical of cloud-based application suitesPower BI breaks down all the silos between earlier incarnations of Power-branded software, presenting a wide range of analytics and visualisation tools in a single, accessible interface.

Microsoft clearly saw the advantages to the end user of this streamlined, simplified BI solution – no doubt influenced by some impressive growth figures for user uptake. It therefore turned back to the issue of analytics in Excel, and created a Power BI desktop version as a solution.

Power BI desktop offers the same integrated, streamlined set of tools in a single interface as the cloud service. The point is that it can now sit right on top of Excel, providing a comprehensive yet user-friendly analytics and reporting suite to replace the previously segmented options.

In that respect, it makes Excel a more powerful productivity software solution. On top of all of that processing and programming power, you now have a single platform which takes care of presentation too, giving you an interactive design interface for sharing your data analysis and business intelligence with the world.

Learn more about self service BI

QUANTIQ is a leading Microsoft resale partner in the UK. Amongst the wide range of services we offer, we specialise in simple, meaningful self service BI, using Power BI dashboards to create a complete 360-degree view of our clients’ business. Contact us today to book your free Discovery Session to find out exactly how we can help transform your business.

Discover QUANTIQ

Find out how our products can be applied to help your business realise results.

QUANTIQ is headquartered in the City of London, formed of a collection of brilliant, knowledgeable and experienced individuals. Our Team work with Microsoft’s specially crafted Business Applications to transform our clients’ business processes. With a headcount of over 200 giving us a combined 1200 years of Dynamics experience, your organisation’s Digital Transformation couldn’t be in safer hands.
As well as being a Microsoft Gold Partner and esteemed Inner Circle member, we are the only Microsoft Partner in the UK that can sell, implement and support the full Dynamics stack in the Cloud, Hybrid-Cloud and On-Premise. We exist to help you enhance your business performance, maintain your competitive edge and drive your growth and profitability.
We work to your organisation’s specific needs, using Microsoft Dynamics Technologies to break down silos in your business and join people, data and processes – now and for the future. We take great pride in the relationships we foster, so choosing us as your Digital Transformation partner allows you to become more productive, more efficient and deliver value to your customers, with a Team you can trust.

Stay connected


Dawson House,
5 Jewry Street,
London EC3N 2EX
United Kingdom
+44 (0)20 7451 1200

QUANTIQ Engineering Hub

c/o Veritra IT Solutions
Plot: 536, 2nd Floor
Madhapur, Hitech City
Hyderabad, Telangana 500081


Unit 3007-3008
One Corporate Centre
Julia Vargas Ave. cor Meralco Ave
Ortigas Center, Pasig City, 1605


7033 E Greenway Pkwy, Suite 160
Scottsdale, AZ 85254

Copyright © 2020 QUANTIQ Technology
All Rights Reserved