Power BI: Tableau: Power BI is the business data analytics tool to analyze the business and derive insights from it. Tableau is the business intelligence and data analytics tool for generating reports and data visualization with high flexibility. Released on Jun 5, 2020 Corresponding Community Edition release: 0.35.4 This update contains an important security fix and is a recommended update for users who have a BigQuery or SparkSQL database connection in Metabase. Please see the Metabase CE v.0.35.4 release notes for more details.

Metabase Enterprise Edition also ships with all the improvements included with the Open Source Edition, 0.39. Customize filter values for each dashboard subscription. In Metabase Enterprise Edition, when setting up a dashboard subscription you can now specify different values for each filter in the dashboard. BigQuery’s cost of $0.02/GB only covers storage, not queries. You pay separately per query based on the amount of data processed at a $5/TB rate. Because BigQuery doesn’t provide any indexes, and many analytical queries cover the entire database, we can assume that each query will need to scan a big chunk of the data. Adobe Analyticsに入り切らないデータをBigQueryに投入する; GA 360 Suite. Google Analytics 360: BigQueryを使ってアトリビュー Tableau. Tableau：2つの値の比較に便利な「ダンベルチャート」を作る; Adobe Analytics. Metabase: カスタムマップで日本地図を追加する.

Metabase连接mysql5.6.16-log版本数据库报错：Unknown system variable ‘session_track_schema’

情况一：Metabase启动数据库为mysql5.6.16

启动直接报错，启动失败

Metabase在启动时报错session_track_schema，日志文件如下：

情况二：添加数据源mysql5.6.16

如果数据源是这个版本也会同样的问题：

这个问题是数据库版本导致的，你看一下详细查看Metabase github的issue：9483的讨论

关于这个问题Metabase上的issue特别的多，而且容易看晕，最后终于在找到了一个解决办法，亲测可用

最终解决方案，你可以看一下（见issue：9954）：

分析原因-session-track-schema

至于MariaDB是MySQL 的一个 branch，还是MariaDB 是 MySQL 的一个fork先不讨论，不过它俩似乎一直就存在兼容性的问题，Metabase MySQL/MariaDB driver是mariadb-java-client这个包。

Metabase不支持Alibaba RDS MySQL 5.6.16-log，因为在0.32.0版本中更改为MariaDB Connector/J，因为旧MySQL不支持session-track-schema。

后来发现就是这个5.6.16-log这个小版本有问题，目前其他的版本未发现存在问题。

解决办法-mariadb-java-client包

首先确定Metabase使用的MySQL/MariaDB driver版本，到project下面

需要下载源码包：mariadb-java-client-2.3.0-sources.jar（Metabase当前版本用的这个版本）

编译完替换就重新启动即可，也可以直接下载我编译完的 AbstractConnectProtocol.class

Need crisp insights to make reliable business decisions? Use these tools and generate reports from years of business data.

“Should we increase the spending on Facebook ads this month?”

“How much stock should we ship to the New York store for this week?”

“Do we need three or five cashiers on Saturday evenings?”

Gone are the days when business decisions like these were made on assumptions. Today, you will invariably want to look at data and insights before answering any of the above questions.

Dashboard software is the go-to tool for visualizing business data and extracting insights from it. It helps monitor and measure performance in real time and get a consolidated, single-pane view of important business metrics.

If apprehensions about heavy investment are keeping you from using dashboard software, we’ve got you covered with this list of top free and open source tools.

To be considered for this list, tools had to support the following functionalities:

• Importing data via manual input, file upload, or integration with different data sources, applications, and platforms.
• Visualizing data into different forms, such as charts, bar graphs, and pie charts.
• Providing a single-panel view of the aggregated data.

What does “top” mean? Each of the four tools included in this article has had a minimum user rating of 4.0 on Capterra’s software directory over the past year.

For more details on how we selected the products, you can read our methodology at the bottom of the article.

4 best free or open-source dashboards

(In alphabetical order)

• 
  Cyfe
• 
  Databox
• 
  Metabase
• 
  Zoho Analytics

1. Cyfe

Cyfe is a cloud-based dashboard tool that pulls data from advertising, email marketing, sales, finance, social media, support, and web analytics accounts into one panel.

It connects to over 1,500 third-party applications, including Google Analytics, Salesforce, AdSense, Mailchimp, Facebook, WordPress, and Trello. It can also import internal business data via custom widgets or push APIs.

Marketing dashboard generated in Cyfe (Source)

The tool helps visualize data by different categories (such as department, client, and time period) into charts and graphs. You can export generated reports in PNG, JPEG, PDF, and CSV formats or share the dashboard with stakeholders via a custom URL.

The free module of the tool provides full functionality but limits to two dashboards and a single user. It also limits the dashboard to a 30-day history, even though the module never expires.

Reviewers of Cyfe on Capterra share the following pros and cons:

2. Databox

Databox is a cloud-based business intelligence (BI) tool that imports data from sources such as marketing, sales, social media, search engine optimization (SEO), and project management tools.

The tool connects to over 70 third-party applications, including sources like Google Analytics, Salesforce, HubSpot, Mixpanel, Facebook, and Shopify, via one-click integrations. It also offers over 200 pre-built report templates that can be customized using the do-it-yourself (DIY) Dashboard Designer.

TV screen view of Databox dashboard to display KPIs (Source)

Databox offers a DataBlock library for you to choose data visualizations that can be dragged and dropped into the dashboard. It also incorporates goal tracking to set daily, weekly, monthly, or annual targets for any business metric you’re tracking. You can schedule auto-generated daily, weekly, and monthly snapshots of any dashboard to be sent via email, or create custom URLs to share dashboards with other stakeholders.

The free module of the tool is limited to three data sources, three dashboards, and three users, and only provides one daily refresh (as opposed to real-time or hourly refresh).

Reviewers of Databox on Capterra share the following pros and cons:

3. Metabase

Metabase is an open source dashboard tool that can be set up without specialized technical know-how. It works with multiple data sources, such as Google BigQuery, Amazon Redshift, Teradata, Snowflake, and Mongo.

The tool helps users summarize and visualize data without any SQL expertise. It offers a quick and easy lookup function to help search and filter through data and visuals.

A business dashboard generated through Metabase (Source)

You can schedule emails to share charts and snapshots from the dashboard or manually share them via Slack. You can also set goals for various metrics, much like possible with Databox.

The free version offers full functionality. Being open source, it needs to be hosted on-premise.

This can require higher upfront investment compared to cloud-based tools but gives complete control over the software, with no predefined storage limits, pricing tiers, or caps on the number of dashboards or users.

The vendor shares new features, interface improvements, and bug fixes for free with all users as well as provides a community space for users to share feedback and fixes for the tool.

Reviewers of Metabase on Capterra share the following pros and cons:

4. Zoho Analytics

Zoho Analytics is a self-service BI tool that helps users create dashboards to measure business metrics. It was previously known as Zoho Reports.

It imports data from multiple sources, including cloud drives (such as Dropbox and Google Drive), relational databases (such as Oracle and Sybase), and cloud databases (such as Microsoft SQL and Amazon Redshift). It also supports manual import of data in a number of file formats, such as CSV, TSV, Excel, HTML, TXT, and JSON.

Report created in Zoho Analytics (Source)

The tool allows visualizing data in charts, widgets, pivot tables, geo-visuals, and tabular views. You can create reports by dragging and dropping components into the dashboard and analyze those reports by applying filters and creating drill-downs.

The free version of the tool provides access to two users for up to 10,000 rows of data, three query tables, and five workspaces. Users can create unlimited reports. However, it limits integrations with third-party applications to QuickBooks, Microsoft Dynamics, Xero, Teamworks, HubSpot, MailChimp, Facebook, Twitter, and Google Analytics.

Reviewers of Zoho Analytics on Capterra share the following pros and cons:

Quick checklist for choosing a dashboard tool

Now that you’ve reviewed the top free and open source dashboard software, it’s time to ask yourself which one might meet the needs of your business. Below is a quick checklist to help you out:

✔ Spend some time on our dashboard software buyers guide to learn what the software does, what are its typical features, and how it can benefit you.

✔ Ascertain the number of users who will be accessing the dashboard and ensure that the tool supports that number of users.

✔ Ensure that the tool gives flexibility in the visual representation of data and insights. It should allow you to choose between various formats of charts and graphs as well as to customize reports.

If you’re still confused about which tool is right for your business, spend some time reading reviews from verified users on Capterra. See which features are working for them and what challenges they are facing, and incorporate those insights into your shortlisting process.

Metabase Bigquery

Methodology

To select the products mentioned in this article, we identified the most common product listings for dashboard software searches via Incognito Google search on Mar 4, 2020. Products that appeared on third-party listings at least twice during this research were shortlisted for further evaluation.

The shortlisted products were evaluated against the definition of dashboard software: Dashboard software is an information management tool that visually tracks, analyzes, and displays key performance indicators (KPIs) to help businesses make informed decisions and improve productivity and the efficiency of their workflows. Dashboards provide a customizable interface that collects real-time data from multiple sources and displays the generated insights in the form of charts, tables, gauges, and timelines.

The tools were further checked for the following criteria:

• Offering a completely standalone free module of the tool, that did not require the user to purchase the tool after a set period of time.
• Not requiring extensive technical know-how or coding languages to set up.
• Overall rating of 4.0 or more on Capterra software directory between Mar 4, 2019 and Mar 4, 2020.

Metabase Bigquery Convert

The tools that met all the above criteria were selected for the article.

Disclaimer:

Listed pros and cons are derived from features listed on the product website and product user reviews on Gartner Digital Markets domains (Capterra, GetApp, and Software Advice). They do not represent the views of, nor constitute an endorsement by, Capterra or its affiliates.

The applications selected in this article are examples to show a feature in context and are not intended as endorsements or recommendations. They have been obtained from sources believed to be reliable at the time of publication.

Looking for Business Intelligence software? Check out Capterra's list of the best Business Intelligence software solutions.