External BI-tools
External BI-tools overview
Access the data from your connected data sources with any BI-tool of your choice.
Before you start! Enhanza comes with a powerful and built-in Insight Builder and Data Organizer. They meet most needs for reporting and analysis. Share reports with your team and customers. Need help to get started? Book a free onboarding.
Supported BI-tools
You’ll find easy-to-follow connection guides below for each supported BI-tool below. Do you need help to choose?Microsoft Power BI
Google Bigquery
Google Sheets
Microsoft Excel
Google Looker Studio
Metabase
Qlik Sense
Tableau
Which external BI-tool is best?
It depends. It can be useful to ask yourself the following questions. In a hurry, read the summary.- Which environment do you work in daily
Most companies use either Microsoft or Google for their daily operations. Let that weigh heavily in your decision. - What do you want to achieve?
- (Pivot) tables and/or dashboards?
Do you (only) want to extract data to work with it “manually”? Then Google Sheets is our first choice and Microsoft Excel second. Why? Because Google Sheet is 100% cloud based and easy to connect. It’s light-weighted, easy to use and completely free. ☁️
- (Pivot) tables and/or dashboards?
- Who will use the reports?
- Just you, a closed team, or the entire organization? Maybe shared with customers or even shown publicly?
Google Looker Studio and Sheets are as easy to share as any file in Google Drive. Microsoft Power BI can on the other hand be implemented in Teams and Sharepoint.
- Just you, a closed team, or the entire organization? Maybe shared with customers or even shown publicly?
- How do you want to publish it?
- On a regular screen, mobile, or a large TV screen on the wall?
Most BI-tools work well on any screen.
- On a regular screen, mobile, or a large TV screen on the wall?
- What are you willing to pay?
There are fantastic tools that are completely free. But do they meet your needs?
Google’s tools are completely free and very powerful. Microsoft Power BI is affordable if you don’t have many viewers. Klipfolio has become quite expensive, in our opinion.
Summary
| BI-tool | Our comments |
|---|---|
| Microsoft Power BI | Powerful. Part of the broader Microsoft suite. |
| Google Looker Studio | Quick to get started. Easy to share. |
| Google Sheets | Like Excel, but much better. |
| Microsoft Excel | The tool almost everyone has and knows. |
| Klipfolio | Powerful for dashboards, perfect for TVs. |
| Metabase | Popular among startups. Self-host or rent. |
| Tableau | Great for analyzing and exploring data. |
| Qlik | Web-based version of former Qlik. |
Missing a reporting tool? We likely support it too. Contact us.