What ’bout some fancy dashboards for ya? Power BI vs. Geckoboard

In my capacity as the chief data analyst of bitstars, it’s one of my key responsibilities to regularly compile all relevant figures concerning our web platform HoloBuilder. These figures are mostly intended for people who don’t have the time to dive deeply into some fancy but complicated statistics. Hence, from the user experience perspective it’s crucial to provide them in an easy-to-understand and pleasant-to-look-at form. A well-established way of doing so are data visualizations of different forms which are provided in terms of dashboards for optimal accessibility. Since we are currently redesigning our internal process for providing figures and statistics, I’ve done some research on two potential software solutions that could be used for this.

Requirements

Since we are talking about a solution for our internal process at bitstars, there is a set of company-specific requirements a contemplable software has to fulfill. In particular, these requirements are:

Moreover, there are two nice-to-haves:

In the following, I investigate two possible solutions—Power BI and Geckoboard—, which are evaluated against the above requirements.

Power BI

Power BI WebsitePower BI is a cloud-based business analytics service provided by Microsoft. It comes as a part of the Office 365 suite, but can also be used standalone. There is an online as well as a desktop version, whereas the latter has a significantly larger range of functions. Power BI distinguishes between dashboards (“[…] something you create or something a colleague creates and shares with you. It is a single canvas that contains one or more tiles.”) and reports [“one or more pages of visualizations (charts and graphs)”]. Reports can be saved in the Power BI Desktop file format (.pbix); dashboards can be shared.

Power BI comes with a rather limited range of integrable services, among which are Google Analytics (☑) and MailChimp (☑). AdWords (☑) statistics can be integrated via Google Analytics if your respective accounts are connected. However, integration for Facebook Ads (✖), Pipedrive (✖) and AWS (✖) is still missing. FB Ads integration has been requested, but is yet to be realized. There is moreover functionality to integrate data from Excel and CSV files (from your computer or OneDrive) or Azure SQL databases, among others, which also enables you to import your own custom data.

The basic version of Power BI can be used for free while Power BI Pro comes for $9.99 per user & month.

How to create a cumulative chart in Power BI?

Cumulative charts are not a built-in functionality of Power BI, but can be easily realized using Data Analysis Expressions (DAX, ☑). That is, you have to create a new measure in your dataset. Assume, for instance, you want a cumulative chart of your sales (to be accumulated, Y axis) over time, which are only present in your dataset as the number of sales per date (X axis). The DAX formula for your new measure would be as follows:

Measure = calculate(
  SUM('Your Dataset'[Sales]);
  FILTER(
    all('Your Dataset'[Date]);
    'Your Dataset'[Date] <= max('Your Dataset'[Date])
  )
)

(found at http://www.daxpatterns.com/cumulative-total/). You can then simply add a chart visualizing your new measure (Y axis) per date (X axis) to your Power BI report to obtain your desired cumulative chart.

Geckoboard

Geckoboard WebsiteGeckoboard is a web platform for creating individual dashboards that show your business’s KPIs (key performance indicators), e.g., unique visits to your website, Facebook likes or sales per day. The platform has built-in support for integration of a wide range of external data sources, including Google Analytics (☑), AdWords (☑), Facebook Ads (☑), MailChimp (☑), Pipedrive (☑) and AWS (☑) and many more (in fact, way more compared to Power BI). Moreover, Geckoboard supports CSV and Google Sheets integration for your own custom data.

Like in Power BI, there is no built-in support for cumulative charts. However, since it is easily possible to create those in Google Sheets (see, e.g., this link), they can simply be imported and visualized in Geckoboard as well (☑). Of course, this means an additional intermediate step is required.

Geckoboard offers no free plan. Paid plans start from $49 per month for one user and two dashboards.

Conclusion

Power BI Geckoboard
Cumulative charts (☑)1 (☑)1
Google Analytics integration
AdWords integration
Facebook Ads integration
MailChimp integration
(Pipedrive integration)
(AWS integration)
overall rating ⭐⭐⭐ ⭐⭐⭐⭐

Both tools miss built-in functionality for cumulative charts, but provide means for importing own custom data. When it comes to the integration of third-party services, Geckoboard supports a significantly lager range of available data sources. Because of this, I give Power BI an overall rating of 3 out of 5 (⭐⭐⭐). Since the pricing is more expensive and cumulative charts require an additional intermediate step, but the overall package makes a better impression regarding what we need at bitstars, Geckoboard receives a rating of 4 out of 5 (⭐⭐⭐⭐).

To summarize, if you’re fine with Google Analytics stats and some custom data imported via Excel files or an Azure DB, go for Power BI. Yet, if you rely on the seamless integration of a wider range of external services, you’re clearly better off with Geckoboard—unless you wanna implement the integration of the different services’ APIs yourself in a DIY solution.

1 These are given in parentheses because an additional intermediate step is required.

Advertisements

[offene Masterarbeit] Was that Page Pleasant to Use? Usability-Metriken in einer echten Suchmaschine

Es gibt viel zu viele schlechte Webseiten! Schon mal versucht, auf www.finanzen.sachsen.de die Tagessätze für Auslandsreisekosten zu finden? Falls nicht, einfach mal ausprobieren und viel Spaß dabei! Oder schon mal auf der Seite der Uni Würzburg versucht, herauszufinden, wie genau eine Bewerbung für den Bachelor in Wirtschaftswissenschaften abläuft? Nein? Ist auch eigentlich besser so, weil der Versuch einen leicht in den Wahnsinn treiben kann.

Motivation: Usability? Nein, danke!

Viele Webseiten (auch großer Unternehmen) beweisen keinerlei Gespür für grundlegende Usability-Prinzipen, welche weder sonderlich neu noch sonderlich kompliziert sind. Häufig sind z. B. Informationen, die eine Großzahl an Nutzern betreffen, nicht direkt über die primäre Navigation erreichbar, sondern nur über verschlungene Pfade und zahllose Klicks. Und das trotz einer Fülle an Frameworks und Content-Management-Systemen, die modernste Webdesign- und Usability-Prinzipien unterstützen. Der wohl häufigste Grund für mangelnde Usability einer Webseite ist die Tatsache, dass entsprechende Tests nur unzureichend oder gar nicht durchgeführt werden, häufig aus Kosten- oder Zeitgründen.

The WaPPU dashboardUm dem entgegenzuwirken, habe ich als Teil meiner Doktorarbeit ein prototypisches Tool namens WaPPU entwickelt, welches es ermöglicht, wesentlich günstigere A/B-Tests auf Basis einer neuartigen Metrik für Usability durchzuführen. Das heißt, die Usability zweier leicht unterschiedlicher Versionen derselben Webseite wird während der Benutzung durch echte Nutzer in Form von Metriken in Echtzeit erfasst und in einem Dashboard visualisiert (siehe Abbildung).

Ziel der Arbeit

Mein Dissertationsprojekt ist eingebettet in die Forschungs- und Entwicklungsabteilung der Unister GmbH in Leipzig, welche aktuell eine neuartige Reisesuchmaschine entwickelt. Der entwickelte Prototyp soll im Rahmen einer Masterarbeit in diese reale Suchmaschine integriert werden, um verschiedene Interface-Variationen im produktiven Betrieb anhand ihrer Usability bewerten zu können. Weitere Informationen können der offiziellen Ausschreibung entnommen werden. Interessenten melden sich bitte unter der in der PDF angegebenen E-Mail-Adresse oder über mein Kontakformular.

Demo

Ein Demo-Video zum WaPPU-Tool gibt’s hier.