Category

Data Visualisation

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.

Power BI: Dashboard In A Day – Jan 2020

By | Data Visualisation | One Comment

FTS Data and AI kicked off 2020 the right way by hosting another Power BI: Dashboard In A Day (DIAD) event in January. With more events scheduled in the coming months, this post recaps the January event, the feedback we got and what you can expect from the next DIAD event.

What Is It?

As previously mentioned, DIAD is a free one-day course designed by Microsoft to help analysts explore the full capabilities of Power BI. Attendees learn about Power BI in detail, follow a step-by-step lab manual, attempt 2 real-world practical examples and receive expert guidance from a team of experienced instructors. Through self-paced learning, attendees can properly develop their skills in Power BI and create a business-ready dashboard in a matter of hours. No matter what their capabilities are, the workshop is designed to be accessible to everyone in attendance.

“Great presentation, great content and very useful hands-on labs. I would definitely recommend this.”

The January event this year was loaded with attendees from a diverse range of industries and roles. From business analysts to IT managers (with a few engineers and accountants in the mix), DIAD was a hit for all those in attendance looking to sharpen their Power BI skills. From the FTS perspective, this was the ideal audience – a healthy cross section of the modern BI reporting landscape eager to see what Power BI is capable of. The benefit of DIAD is that it can help anyone at any stage of their BI reporting journey, and this was no more evident here with the variety of attendees.

“The content was really easy to follow and I learned a lot. The presenters were excellent and know their stuff.”

From the feedback we collected, the most valuable part of DIAD is the bring-your-own-data session. This is a unique session dedicated to helping attendees solve their individual reporting problems. The FTS team were on hand to deliver one-on-one advice with every participant, with questions ranging from a technical perspective to more opinion-seeking advice. This is the best part of DIAD, and what makes this event like no other. The consulting team love a challenge, and helping the audience get the results they want is an extremely rewarding experience.

“[I liked] that we have the ability to bring our own data to build our own dashboard… Thanks FTS.”

Another unique benefit of DIAD is the showcase session. During the lunch break, attendees are invited to eat while the FTS team showcase some real-world Power BI examples. The audience gets an inside look at how we understand reporting problems and how we use Power BI to solve them. Learning about the functionality of Power BI is one thing, but seeing how it is applied is where you truly realise the benefits.

“All the coordinators were enthusiastic to resolve and address questions.”

Why Should I Go?

DIAD is an event like no other. Designed by Microsoft and delivered by professionals, DIAD empowers attendees with the skills and best practices needed to develop successful Power BI reporting solutions. Based on the overwhelming positive feedback from attendees, these events have been instrumental in getting Power BI quickly adopted in several organisations.

If you want to know more about Power BI: Dashboard In A Day events, please contact us for more information or check out our events page below for upcoming sessions.

Power BI Dynamic Visual Titles

By | Data Visualisation | No Comments

Power BI Dynamic Measures & Dimensions  – Part 2 Dynamic Visual Titles

In Part 1 we saw how we can take our Power BI Reports to the next level by making them fully interactive, incorporating dynamic measures & dimensions. In part 2 we will tie it all together with Power BI Dynamic Visual Titles. In combination with Part 1’s Dynamic Measures & Dimensions, this concept greatly enhances the end user experience as they can monitor/analyse multiple measures and dimensions in a single report page at the click of a button.

Using the same financial dataset from Part 1, we will create 2 types of dynamic visual titles. One using a combination of the Selected Measure and Selected Time data attributes we created in Part 1 with some free text and the second will be a combination Selected Measure, Selected Time, free text and the selected filter from another visual.

In the Donut chart visual below, we have selected the ‘Revenue’ measure (using Selected Measure) and the ‘MTD’ period (using Selected Time) from our Chiclet Slicers and we can see these are reflected in our Donut charts title.

When we change our selection using the Chiclet Slicer, the Donut charts title updates to reflect our new selections as seen below.

How to

This is achieved by creating measures for each of your visual titles, and again utilising the SELECTEDVALUE DAX function we used in Part 1.

Let’s start by creating the measure, called ‘Title-Donut-Region’, that we’ll use for the Donut chart title by using the syntax below which joins (concatenates) the Selected Measure, Selected Time & the string “ by Region”.

With the measure created we then add it to the Donut Visual by going to the Format options within the Visualisations pane and click on fx as seen below.

The following window will pop-up and we select ‘Format by Field value’ and then select our ‘Title-Donut-Region’ measure, click OK.

We can also extend this concept further by adding fields used in other visuals to our visual title measures, in this example, the ‘Region’ field used in our Donut chart visual. Below we have a Clustered bar chart visual showing our Selected Measure, Selected Time data attributes by Country.

In the ‘Title-Bar-Country’ measure as seen below, we have added the Region field (called ‘Group’ in our Data Model)

 

Now when we select a Region from our Donut chart visual, the Clustered bar chart visual by Country updates to show the Countries in that Region and our Clustered bar chart title also updates as seen below.

Power BI Dynamic Visual

As you can see, Power BI Dynamic Visual Titles ties in together nicely with the Dynamic Measures & Dimensions and can greatly enhance the end users experience.

Summary

If you’d like to take your Power BI Reports and Dashboards to the next level and need help, please contact us to discuss how we can assist your organisation.

Power BI Dynamic Measures & Dimensions

By | Data Visualisation | One Comment

Power BI Dynamic Measures & Dimensions – Part 1

A great way to take your Power BI Reports to the next level is by making them fully interactive by incorporating PowerBI dynamic measures & dimensions. With this clever use of DAX, it’s possible to slice your data the way you want without leaving the dashboard screen.

In this 2-part series we’ll look at creating dynamic measures & dimensions within your PowerBI reports in part 1 and then continuing that into visual titles in part 2.

Using this concept greatly enhances the end user experience as they can monitor/analyse multiple measures and dimensions in a single report page at the click of a button making this a highly desirable solution.

In the PowerBI report example below, we have a financial dataset which includes revenue, expenses & taxes and from these we can calculate profit. We have created 1 set of measures for profit, revenue, expenses & taxes and 1 dimension for the time periods Fiscal Year to Date (FYTD), Quarter to Date (QTD) and Month to Date (MTD).

This will allow end users to view, as seen in the examples below, Profit by FYTD or QTD or MTD as well as the variances to the previous FYTD or QTD or MTD and all the visuals and visual titles will update when a different measure or time period is selected.

Profit FYTD

Profit QTD

Profit MTD

How to

There are quite a few steps involved to get this concept up & running but the benefits to your report consumers will be well worth the effort.

  1. Create the base measure for Profit, then create the Time Intelligence measures for the current periods, Profit FYTD, Profit QTD & Profit MTD and then create the measures for the previous periods, Profit PFYTD, Profit PQ QTD, Profit PM MTD and repeat this process for Revenue, Expenses & Taxes.

  1. Create 2 new tables, one for measure selection, this allows end users to select from Profit, Revenue, Expenses & Taxes measures, and one for time selection, this allows end users to select from FTYD, QTD & MTD time periods.

Dynamic Measures table

 PowerBI Dynamic Measures Table

Dynamic Dimensions table

  1. Create the base measure for the Measure Selection and Time Selection These 2 measures utilise the SELECTEDVALUE DAX function, becoming the foundation for the dynamic measures we create for the visuals within the report page.

Below is the Time Selected measure.

 

  1. Next we create the Selection 1 and Selection 2 These 2 measures utilise the SWITCH DAX function. Selection 1 is for the current period measures FYTD, QTD & MTD and Selection 2 is for the previous period measures PY FYTD, PQ QTD and PM MTD. Below is the Selection 1 measure.

PowerBI Dynamic Measures DAX

 

  1. Finally, we create the variance measures between Selection 1 & Selection 2 allowing us the show the variances by $ value and % value between the selected time periods i.e. variance between FYTD and PY FYTD as seen below.

 

Bringing it all together

Using your preferred slicer, in this example the Chiclet Slicer (available via the PowerBI Marketplace), we create 2 slicers, one for the Selected Measure and one for Selected Time. These slicers allow your report consumers to dynamically change measures & time periods within the report page.

Below is the Selected Measure Chiclet Slicer.

PowerBI Dynamic Measures Slicers

With all the setup now complete, we create the visuals for the report page using either or both the Selection 1 and Selection 2 measures and you’re done!

Summary

If you’d like to take your PowerBI Reports and Dashboards to the next level and need help, please contact us to discuss how we can assist your organisation.

Power BI: Dashboard In A Day

By | Data Visualisation | One Comment

Power BI: Dashboard In A Day

Over the past few weeks, FTS Data & AI have had the privilege of hosting multiple Microsoft-sponsored Power BI: Dashboard In A Day (DIAD) events across Sydney. As a Microsoft Gold Partner for Data Analytics, the team presented over 3 days’ worth of content to a combined audience of over 100 business analysts, report developers and data professionals. Handpicked to present at Microsoft’s headquarters in North Ryde, we were able to deliver events that were both informative and beneficial for all those in attendance. For those who are curious and could not attend, this blog post covers what a DIAD event is, and why you should register to attend the next one.

L-R: Alex Gorbunov, Matthew Oen, Swetha Pakki, Sahan Vaz Goonawardhane, Ajit Ananthram

What Is It?

DIAD is a free one-day course designed by Microsoft to help analysts explore the full capabilities of Power BI. Attendees learn about Power BI in detail, follow a step-by-step lab manual, attempt 2 real-world practical examples and receive expert guidance from a team of experienced instructors. Through self-paced learning, attendees can properly develop their skills in Power BI and create a business-ready dashboard in a matter of hours.

Most importantly though, a large section of the day is devoted to providing attendees with the opportunity to develop Power BI reporting from their own datasets. This is where attendees get the most value, as they can ask questions and get assistance from experienced consultants regarding their own business’s reporting projects. The FTS Data & AI team were able to lend a hand and provide tailored advice to a vast number of businesses at various stages of their Power BI reporting journey.

Presenting to a large audience at Microsoft HQ

When Is It?

DIAD events occur throughout the year. Depending on your location, you can find dates for upcoming events by contacting us.

Attendees work on real-world practical examples

Where Is It?

DIAD events are held across the country. The Sydney events this year were held at the Microsoft head office in North Ryde. Here at the Microsoft HQ, attendees were able to fully engage with the technology, and see first-hand what Power BI and other Microsoft products are capable of, and how they could be used in their business.

See the full and latest capabilities of Power BI

How Much Will It Cost?

DIAD events run for 8 hours and are FREE. Make sure you register your interest early to ensure that you reserve a seat, as spots are limited at each event. Lunch and refreshments are also complimentary and provided throughout the day.

Learn how Power BI can be implemented at your organisation

Each attendee receives expert advice

Why Should I Go?

DIAD is an event like no other. Designed by Microsoft and delivered by professionals, DIAD empowers attendees with the skills and best practices needed to develop successful Power BI reporting solutions. Based on the overwhelming positive feedback from attendees, these events have been instrumental in getting Power BI quickly adopted in several organisations.

The opportunity to receive tailored advice from professional Power BI consultants means that you can accelerate the implementation of Power BI at your business, and be confident that you have the capability to develop powerful reporting solutions at your organisation well into the future.

See how other organisations have successfully adopted Power BI

 

If you want to know more about Dashboard In A Day events, please contact us for more information.