Popular BI – State of the Self Service BI market Jan 2022

By | Data & AI, Data Visualisation, Enterprise PowerBI | No Comments

Popular BI Tools in 2022

This is an update on a series of posts I have written over the last few years looking at the relative popular BI Tools (2019’s is here). I did try to expand my search to cover more platforms but there are still only three that seem to really matter.

Trying to get actual usage figures of any Self Service BI tool is pretty difficult – none of the big vendors will willingly release figures – and if they did they’d probably be suspect.

But in analytics sometimes there are useful proxies which, while not as accurate as hard numbers, can give a useful perspective. In this case, we will use our friend, google trends:

Graph of search for Popular BI tools

Tableau is Red, PowerBI is Yellow & Qlik is Blue.

A quick note on methodology – I’m looking for Qlik (Software Company), Tableau (Data Visualisation Company) and Power BI (Software). I restricted the search to the US because Tableau is also French for “Table” so a worldwide search gets noise from that as well.

State of the Self Service BI Market

What you can see is that PowerBI has caught up with and slowly started overtaking Tableau as of early 2021. Tableau no longer appears to a leader in the self service field, with PowerBI looking to dominate. Qlik is continuing its slide into irrelevance. From this data we get a bit more insight – search volume across all three has been declining from its peak in 2019, now at 80% of its height in 2022.

Next up if we look at market share rather than sheer numbers, we see something interesting. In 2016 Tableau held about 70% of the searches, which has now dropped in 2021 to 46% (and still falling). More interestingly Qlik’s share has fallen to about 5% of the market (compared to 18% in 2015) but Power BI’s share has grown to about 49% (and still rising), compared to 8% in 2015. From the chart there was quite a change in velocity in Tableau searches from early 2020 (in line with the acquisition by Salesforce). It is also worth underlining the fall in share for Qlik is also based on declining search volumes overall.

What does the future hold for Popular BI tools?

Based on trends to date I would make the following headline predictions for the Popular BI tools market in 2022:

  • The Self Service BI market is not as hot as it once was, the hype having moved on
  • Power BI will continue to experience strong growth and will consume more market share, whereas Tableau’s growth will fall
  • QlikView will continue to decline, and no major competitors will arise either

These findings confirm my view held since 2018 – confirmed by my market feedback – that Qlik is a dead platform walking. It’s failed to catch up with market changes and is simply a legacy product. It’s squeezed between the two with no compelling reason to be chosen. However with Salesforce acquiring Tableau, it seems to have gone into a vendor locked decline (in a similar manner to products that have fallen into the SAP or IBM fold in older days). PowerBI has an almost empty field in which to compete.

Competing with PowerBI is going to be a tough proposition as any challenger will need the all encompassing Data Platform juggernaut of Azure behind it (excuse my hyperbole) which gives it the enterprise capability needed to succeed long term. Effectively only Google or Amazon could hope to do so.

However, Google and Amazon’s offerings, (Data Studio & Quicksight respectively) still lack much market traction at this point. The acquisition of Looker seems not to have impacted Googles presence much, despite having 3 years to do so.

My previous predictions have pretty much held true, but as Yogi Berra famously said, “It’s tough to make predictions, especially about the future”. I can be certain that it will be another exciting year in Data & AI. We specialise in Enterprise PowerBI so contact us if you need some help on your journey.

A Review of RPA in 2021

By | Automation Initiation | No Comments

With the year almost over, now is a good time to reflect on the previous 12 months and examine the key highlights in order to help plan for 2022. In this blog post, we will be examining RPA in 2021, specifically by looking at the changes we saw in the market and RPA technology, as well as giving some predictions for where we see RPA in 2022.

 

Growing Interest

First and foremost, Talos saw a huge spike in interest in RPA in 2021. This was evidenced by the increased number of attendees at our UiPath Academy Live events throughout the year. The increase in interest meant that we were offering these events monthly to a new audience. What was most exciting was that the audience was typically made up of organisations with little-to-no experience with RPA. This gave us good ground for introducing RPA concepts and technology to a brand new audience, many of which were completely unaware of RPA. These events were particularly successful in helping organisations understand their own RPA opportunities, how they could be easily achieved and helping initiate their automation journey.

We also saw more traffic in terms of enquiries about RPA showcases and demo’s. More organisations were interested in seeing what RPA looks like, and we were more than happy to demonstrate our capabilities. These showcases were very good at providing an entry point for conversations around RPA, as well as giving some great real-world examples of automation that apply to most businesses.

 

New Opportunities

Talos saw a significant increase in RPA project delivery in 2021. We had more projects this year, spread over a variety of different businesses and processes. Key projects this year included:

These projects were all delivered in 2021, and have been instrumental in changing the ways these businesses work. We had a good mix of new and returning customers this year – a good sign that automation produces long-term benefits for businesses, and is not a ‘one-time’ only tool.

We also had quite a few requests for proof-of-concepts (POC) in 2021. Larger businesses typically requested these, along with a process design document, in order to understand the feasibility of implementing RPA in 2021. These POC’s were very helpful to the business, but also to us at Talos, as it broadened our experience with different industries and processes. We now have great experience in automating the ‘Big 3’ business processes:

  1. Invoice processing
  2. Customer on-boarding
  3. Email triage

 

Expanding Technologies

UiPath underwent some massive upgrades in 2021. Notable improvements were evident in features such as:

These were our favourite features in 2021, and were pivotal in some of our larger project deliveries. Businesses who leveraged these technologies were reaping immediate rewards through increased processing speed, volume and efficiency.

We also got to work on more projects, which gave us some more experience in automating technologies such as:

  • Dynamics CRM
  • TechnologyOne
  • HAMBS
  • Carelink
  • Pronto

This is just a brief list of the more significant systems we saw in 2021. We got to experience developing RPA on a variety of different applications and environments – nearly all of it delivered remotely throughout the year. This gave us great experience in knowing how to deliver projects remotely with minimal tech headaches.

 

On The Horizon

If 2021 is anything to go by, we expect 2022 to be another huge year. In terms of interest, we are already seeing more new customers making enquiries about RPA. It’s very likely we will continue our UiPath Academy Live events each month starting in the new year. Opportunities-wise, our pipeline of work is looking big in 2022 – returning customers making up a large part of that. That trend is likely to continue, as we see organisations continue their automation journey. As for technology, we expect more improvements to the UiPath platform, particularly in the task mining space and process discovery suite. Machine learning and document understanding are the other areas we predict will undergo further improvement and sophistication.

All in all, 2021 was a tremendous year for RPA – lots of interest, plenty of opportunities and massive technological improvements. We here at Talos are looking forward to 2022 and seeing where the road takes us!

3 faces of Enterprise PowerBI Training

The 3 faces of Enterprise PowerBI Training

By | Enterprise PowerBI | No Comments

Since Self Service BI became an actual thing we have advised many organisations on how to roll it out successfully and give the best ROI as part of our Enterprise PowerBI Training solutions. A key mantra for me has always been to tune the content to the audience. After all, you book The Wiggles for your children’s party, not a heavy metal band (well, unless they are into Hevisaurus).

Over the course of working with organisations to define these audiences, consistently there are 3 personas that come up, each with their own needs with regards to enablement in terms of data and training. These 3 personas are:

  • The Actor
  • The Creator
  • The Author

Lets have a quick walk through these roles!

The Actor

An Actor is reading from the script, interpreting what is in front of them but not changing it.

This user makes up the bulk of users in most organisations. Their use of data and reporting is as an input to drive or inform decision making. The individuals in these roles can range from the CEO who needs to have an at-a-glance dashboard of their organisations performance, to a field sales worker who needs to know the buying profile of their next client.

The level of interactivity with any reporting will be basic – maybe selecting a few options or filters, perhaps drilling down a pre-set path to get some finer detail. Consequently the degree of training and enablement they need is fairly light. Key information for them is where to find the report, what the data on the report actually means and what buttons to press.

The Creator

A Creator builds an vision from the script, taking it to design their performance.

This type of user is actually one of the most important in terms of organisational impact. These are the people that are tasked with generating content for the Actors, and as such have a deep understanding of the data in their domain. These are the people tasked to work with the technology experts to build out the data models that drive much of the self service capability.

These users really get into the guts of the data and understand it in depth. When an Actor asks for explanation on a particular data point they are the ones that have to investigate. The technical training they need focuses on content creation and publishing. The enablement needs to cover things like business analysis skills, Master Data Management and Data Cataloguing.

The Author

The Author of course writes the script, starting from very raw materials to build a story.

Most people calling themselves PowerBI experts sit here, and most organisations have a handful of them – they are not a big population (though in my world are a vocal one!). They sometimes fill the role of creator but more often than not are trying to make sense of the organisations data, how it interlinks and where the hidden treasure lies. They “self-serve” from the raw data, constructing new ways to get insight into the organisations performance.

Here enablement focuses on technical capability as they need to understand how to manipulate and interrelate data that may be in less than ideal forms and certainly hasn’t been through an enterprise cleaning process. Data Catalogues support them in the discovery process.

To wrap

The key message to take from this post is that when rolling out Enterprise PowerBI Training at scale these different communities and capabilities need to be addressed – and in different ways. There is no value in sending all of your team on advanced PowerBI training if the skills learned will never find a practical application. Similarly if you build it, they won’t come – you need to guide them there.

Good luck, and if you need some help or advice, please get in touch.

PowerBI Desktop Security Risk!

By | Uncategorised | No Comments

Who doesn’t love PowerBI Desktop? Enterprise BI capability on your desktop for free! You can connect to virtually any source, pull all the data from it and start creating powerful analytics in a matter of minutes. Brilliant! But PowerBI Desktop Security Risk is rarely considered….

PowerBI Desktop Security Risk

PowerBI Desktop Security Risk

Sorry, did you just say “Pull all the data”?

Oh yes. All of it. Everything the developer has access to. You know how business owners used to stress about sales people having their own black books or stealing the customer data? This is so much worse.

If someone (not even a PowerBI developer) has enough access to one of your systems they can pull everything they want from it into PowerBI. There may be some restrictions put in place at the application level which restrict what can be pulled, but users find them annoying and so often access to the data is often very generously granted. The risk then lies in these two factors:

  • Any application security is removed by pulling the data into PowerBI. All those logins that prevented application access now have no effect.
  • A PowerBI file is an unencrypted store of all that data and is easily shared. It can’t even be password protected.

Most of the time this is not really a big concern – people are trying to do the right thing and just want the data to do their jobs. But there are two key scenarios where this risk becomes problematic.

Scenario 1: Malicious actor

Someone within the business wants your data for their own purposes and needs a simple, portable store to take it off your systems. PowerBI is a great tool for pulling large quantities of data and making it highly portable. As PowerBI Desktop is free, once someone has a PowerBI file, they have a means of reading all that data at their convenience.

Scenario 2: Naïve actor

A user builds a piece of valuable reporting that helps someone external to the organisation. They email it to that 3rd party, forgetting that some of the working data has client personal information in it. There has now been an inadvertent data breach for your business to control.

How do you limit the PowerBI Desktop Security Risk?

As with all issues to do with governing risk, there are a mix of hard (technical) and soft (policy) tools you can bring to bear to the problem.

On the “hard” front, first is your Data Loss Prevention software which actively stops PowerBI files being distributed outside of your organisation by email, upload or whatever methods of egress you want to control. Second is controlling the spread of the software by limiting who can actually install it on their desktops. Finally, keep a better grip on your data through rigorous access control, and deploying tools such as Azure information protection to keep an eye or lock on sensitive data.

On the “soft” front, your teams need to be educated on the risks of data loss, costs of data leakage and how it can happen. It won’t deter malicious users much – but it will at least give the naïve actor pause for thought.

How does my organisation protect itself?

PowerBI presents risks but it also offers the ability to really drive data driven decision making in your organisation. It just needs to be governed and directed properly to make sure you maximise the benefits while minimising risks. We have advised many organisations on just this – please reach out to us if PowerBI is in growing your organisation and needs to be properly managed as part of an Enterprise PowerBI implementation.

 

Identifying RPA Use Cases

By | Automation Initiation | No Comments

A very common issue we have seen in the last 12 months is identifying RPA use cases in organisations. In our workshop events, we regularly have discussions with attendees around their existing RPA use cases, and it is not uncommon for attendees to really struggle to identify a single existing business process that they think would make a good candidate for automation. However, we actually know from experience that this, in fact, is a good indicator for automation opportunity. This blog post explains how and why the most successful organisations with RPA usually have a difficult time getting started, and what to do if you are in a similar situation.

The Problem

The first part of the automation initiation journey is simply to identify and assess RPA use cases within your business. There are many ways of going about this, ranging from internal business process analysis to sophisticated process mining technologies. Ultimately though, a business will need to identify a single RPA use case to act as a proof-of-concept and good kickstarter to their RPA journey. This candidate use-case will typically possess the following attributes:

  • Clearly defined benefits that have objective advantages
  • Very few downsides, risks or reasons not to proceed with developing it as a proof-of-concept

However, we have seen and spoken to many businesses who say they struggle to identify a single good RPA use case. Common traits for these businesses are that their:

  • Processes are not written down anywhere
  • Processes are not formally revised and updated regularly
  • Staff cannot clearly articulate what it is that they do each day/week/month

At this point, businesses might well be thinking that automation is either too difficult or not presently applicable, and will abandon pursuing RPA altogether. But the reality is that if a business is really struggling to reconcile their internal processes with automation, that is not such a bad thing. In fact, if you can’t identify a single good candidate for RPA, that is a good sign that you are in need of automation. This is because it says that your business, and specifically business processes, are far too reliant on your staff and/or systems. Your business is likely to be operating purely thanks to the efforts of long-term staff, who personally hold all your process knowledge in their brain, and legacy systems that are not being fully utilised, or at the very least, are not being continually challenged as to how the technology can be improved/redesigned to improve efficiencies.

This ‘make-do’ attitude means that your business is exposed in two ways:

  1. You are more at risk and indeed affected by staff turnover. When existing staff leave, tremendous business process knowledge leaves with them, significantly impacting both short and long-term business.
  2. Your business is obviously inefficient – there simply MUST be processes in a business which can be more effectively outsourced to automation. No business has ever demonstrated to us that it did not possess a single process that could not be more efficently done via automation, and certainly all big-businesses and market leaders utilise automation in their organisations.

Despite the abovementioned risks having significant consequences, very few businesses take any steps to meaningfully address or manage them. But managing these risks is actually very straightforward.

How to Solve the Problem

The key is to first recognise that this perceived absence RPA opportunities is not because of a true lack of process candidates, but is because of an internal, cultural approach to business, which over relies on staff/systems to execute processes. By recognising this approach, you can begin to enact change to inject good habits and policies into your business. These will typically take the form of:

  • Documenting all your processes in detail
  • Implementing a continuous improvement framework for your processes (including regular reviews and assessments for risks and opportunities)
  • Implementing proper process discovery technologies, such as UiPath Process Mining, Task Mining or Task Capture

After making the above changes, businesses will very quickly begin to accumulate lots of information about their processes, both known and unknown. More importantly though, they also begin to enhance business processes because the knowledge has now been taken from the minds of employees and put on paper, allowing that knowledge to be collectively analysed. This strategy of diversifying process knowledge away from staff not only reduces the risk of business disruption from staff turnover, but allows existing processes to be challenged and enhanced, making them ripe for automation. It is at this point that the original problem of identifying RPA use cases is now solved, because your business is now flush with well documented and well evolved processes.

It’s surprising that the most successful organisations with RPA have usually gone through the above experience: struggling to get started, realising what that struggle actually means, resetting their approach to business process, and succeeding in RPA initiation and implementation. If you want to succeed with RPA, you need to recognise and accept this experience within your own organisation, and understand what it means and how to successfully navigate it. Otherwise, rejecting the opportunity for RPA can be a very costly mistake that could have been easily avoided.