Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Metabase Up and Running
Metabase Up and Running

Metabase Up and Running: Introduce business intelligence and analytics to your company and make better business decisions

eBook
$24.99 $35.99
Paperback
$48.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Metabase Up and Running

Chapter 1: Overview of Metabase

Metabase is a free and open source analytics software that allows you and everyone in your organization to ask questions of your data, create visualizations and dashboards, send out daily reporting, and much more.

Traditionally, organizations with good analytics either had to pay for expensive enterprise software, employ a cadre of data scientists and data engineers, or both. The value of analytics was high but the barrier to entry was even higher. Today, the value of analytics continues to grow, but the introduction of software such as Metabase has lowered the barrier to entry. This book will teach you, regardless of your background in analytics and engineering, how to create a robust and scalable analytics environment for your organization using Metabase.

This chapter will be a gentle introduction to Metabase, where we'll learn what it is and how to install it. We will then learn about more powerful, cloud-based installation methods that...

Technical requirements

To follow along, you'll just need a computer: macOS, Windows, or Linux are all adequate operating systems. You'll also want to create a Heroku account. Heroku is a cloud application platform we'll use to deploy Metabase at the end of the chapter. You can sign up for an account at https://www.heroku.com/.

Throughout this book, we'll be using a program called Git. Git is a version control system that helps track code changes in a project. Git has a high learning curve for beginners, and while we will not be covering any Git tutorials in this book, I intend to make the examples easy to follow. No prior knowledge of Git is required.

Often in this book, we'll use GitHub (https://github.com/) in conjunction with Git. GitHub is a code-hosting platform that relies heavily on the Git program. While Git helps you track changes to your code base, GitHub allows you to host that code online, so that others can access, edit, or contribute to...

Introducing Metabase

Before we get started, let's learn about what Metabase is and how it came to be. Metabase is software for analytics. Traditionally, we might refer to it as software for Business Intelligence, or BI. BI generally refers to software that aids in transforming data into actionable insights and visualizations. BI software has been around for a long time; Tableau and MicroStrategy are traditional examples. Today, many people in the industry, myself included, prefer the term analytics software over BI. I will be using that term going forward.

Finding answers in your database

Today, all organizations rely on analytics to stay competitive. As a famous saying goes, "you can't manage what you can't measure." Imagine you are a company selling products online and want to measure the number of products you have sold. While that seems like a simple question, many would have no idea of how to actually arrive at a number. Would you manually count...

Metabase's origins

Metabase began as an internal tool at Expa (https://www.expa.com), a start-up studio in San Francisco run by Garrett Camp, the co-founder of Uber. His CTO, Sameer Al-Sakran, had been working on simple ways to serve actionable data to CEOs and investors of companies in the Expa portfolio.

These start-ups needed an easy, low-cost, and low-friction way to understand their product data and measure things such as growth and engagement. It didn't take them long to realize that if the tools they were building were helpful for Expa's start-ups, they would probably be helpful to other start-ups, technology companies, and other organizations. They decided to turn this internal project into a company. Soon after, they put the source code for their project on GitHub, a website for collaborative software development that we'll rely on throughout this book. It became available for everyone to use, and Metabase was born.

On October 21, 2015, Metabase...

Why open source?

One of the unique things about Metabase that sets it apart from other analytics software is that it is open source. That means the source code for Metabase is freely available to be downloaded, redistributed, and modified. All the code for Metabase is hosted on the project's GitHub repository at https://github.com/metabase/metabase. So why is open source a big deal and how might it benefit you, the user?

It's free

Analytics software can be pricey. The goal of Metabase is to offer the same (or better) quality for free, so you can get the most value from your data without paying a third party. Metabase's open source software is and always will be 100% free to use. You may be wondering: how does Metabase make money? Recently, they've come out with an Enterprise version and a cloud hosting solution, both of which they charge for. The Enterprise version has some powerful features, some of which might make sense for certain organizations. In this...

Installing Metabase locally

By far the easiest way to try out Metabase is to install it locally. Installing Metabase locally means that you are running the program from your own computer, rather than off some external server (for those unfamiliar with servers, you can think of them as computers that are always running and accessible via the internet). While running Metabase locally is not the ideal way to run Metabase, it was created to be perfect for beginners who just want to kick the tires, try it out, and gain familiarity with the product. I'll go into detail about its limitations later in this chapter, but for now, let's go ahead and install it.

Installing on Mac

To familiarize yourself with Metabase's website, head to https://www.metabase.com. There you'll see a Get Started button. Click that and you'll be taken to a page with all the various installation options, with their Metabase Cloud hosted version highlighted by default. Click the Host it...

Installing and deploying Metabase via the cloud

In the last section, we learned how to install Metabase locally on our computers. We also learned the limitations of running it locally. By installing and deploying to the cloud, we unlock Metabase's true power. Let's get started.

Running software in the cloud

The good news is that it is not too much more complicated to get Metabase running on a web server. Practically, this means that when you run Metabase on a web server and close up your laptop, Metabase will stay up and running (unlike a locally installed version).

While you could go out and buy a web server and plug it in at home, today that is rarely done. Running a server in your home or office is referred to as on-premises, or on-prem. Some organizations may have their own servers on-prem for security reasons but nowadays most servers are run in the cloud. Today you can pay companies including Amazon, Microsoft, and Google a very small amount of money and they...

Summary

At this point, we have learned what Metabase is, what it is used for, and who should use it. We've outlined the four types of Metabase users: admins, consumers, analysts, and power users – the latter of which you will be by the end of this book!

We have installed Metabase locally, and in the cloud, using Heroku. We have an instance of Metabase running and have signed up for an account. We're all but ready to add other users and start analyzing our data.

At the same time, we now understand the limitations of using Heroku's Free Tier to administrate our Metabase instance. As mentioned throughout the chapter, the recommended way to run Metabase is with AWS. Doing so is a much more involved process than the one-click method Heroku offers, but a necessary step for those who want more control and oversight.

In Chapter 2, Hosting Metabase on AWS, we will take a detailed look at running Metabase with AWS.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Deploy Metabase applications to let users across your organization interact with it
  • Learn to create data visualizations, charts, reports, and dashboards with the help of a variety of examples
  • Understand how to embed Metabase into your website and send out reports automatically using email and Slack

Description

Metabase is an open source business intelligence tool that helps you use data to answer questions about your business. This book will give you a detailed introduction to using Metabase in your organization to get the most value from your data. You’ll start by installing and setting up Metabase on your local computer. You’ll then progress to handling the administration aspect of Metabase by learning how to configure and deploy Metabase, manage accounts, and execute administrative tasks such as adding users and creating permissions and metadata. Complete with examples and detailed instructions, this book shows you how to create different visualizations, charts, and dashboards to gain insights from your data. As you advance, you’ll learn how to share the results with peers in your organization and cover production-related aspects such as embedding Metabase and auditing performance. Throughout the book, you’ll explore the entire data analytics process—from connecting your data sources, visualizing data, and creating dashboards through to daily reporting. By the end of this book, you’ll be ready to implement Metabase as an integral tool in your organization.

Who is this book for?

This book is for business analysts, data analysts, data scientists, and other professionals who want to become well-versed with business intelligence and analytics using Metabase. This book will also appeal to anyone who wants to understand their data to extract meaningful insights with the help of practical examples. A basic understanding of data handling and processing is necessary to get started with this book.

What you will learn

  • Explore different types of databases and find out how to connect them to Metabase
  • Deploy and host Metabase securely using Amazon Web Services
  • Use Metabase's user interface to filter and aggregate data on single and multiple tables
  • Become a Metabase admin by learning how to add users and create permissions
  • Answer critical questions for your organization by using the Notebook editor and writing SQL queries
  • Use the search functionality to search through tables, dashboards, and metrics
Estimated delivery fee Deliver to Chile

Standard delivery 10 - 13 business days

$19.95

Premium delivery 3 - 6 business days

$40.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 30, 2020
Length: 332 pages
Edition : 1st
Language : English
ISBN-13 : 9781800202313
Category :
Languages :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Chile

Standard delivery 10 - 13 business days

$19.95

Premium delivery 3 - 6 business days

$40.95
(Includes tracking information)

Product Details

Publication date : Sep 30, 2020
Length: 332 pages
Edition : 1st
Language : English
ISBN-13 : 9781800202313
Category :
Languages :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 152.97
Metabase Up and Running
$48.99
ETL with Azure Cookbook
$48.99
Workflow Automation with Microsoft Power Automate
$54.99
Total $ 152.97 Stars icon

Table of Contents

14 Chapters
Section 1: Installing and Deploying Metabase Chevron down icon Chevron up icon
Chapter 1: Overview of Metabase Chevron down icon Chevron up icon
Chapter 2: Deploying Metabase with AWS Chevron down icon Chevron up icon
Section 2: Setting Up Your Instance and Asking Questions of Your Data Chevron down icon Chevron up icon
Chapter 3: Setting Up Metabase Chevron down icon Chevron up icon
Chapter 4: Connecting to Databases Chevron down icon Chevron up icon
Chapter 5: Building Your Data Model Chevron down icon Chevron up icon
Chapter 6: Creating Questions Chevron down icon Chevron up icon
Chapter 7: Creating Visualizations Chevron down icon Chevron up icon
Chapter 8: Creating Dashboards, Pulses, and Collections Chevron down icon Chevron up icon
Chapter 9: Using the SQL Console Chevron down icon Chevron up icon
Section 3: Advanced Functionality and Paid Features Chevron down icon Chevron up icon
Chapter 10: Advanced Features, Getting Help, and Contributing Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(7 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Ricardo Landim Jan 08, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I absolutely loved this book. It’s very detailed and very easy for beginners to understand and follow the steps.Great resource for those looking to use Metabase at their company. I feel like no stone was left unturned so someone with access to this book will have everything they need to get Metabase working perfectly, and more.
Amazon Verified review Amazon
Rob Oct 08, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Well structured and complete. Lets you go from nothing to having your very on fully deployed and fully functional Metabase instance with reports and dashboards that you can easily share with your team.
Amazon Verified review Amazon
MSSF Nov 08, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book about metabase. Author Tim Abraham is a world class expert in his field.
Amazon Verified review Amazon
A. Faiz Dec 31, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Tim's guide to getting Metabase up and running is incredibly informative and useful for anyone interested in setting up Metabase for their business needs. I've been using Metabase since the beginnings of the product, and I still found nuggets in this book that I wasn't aware of.The organization of the book leads you through the steps in a realistic way of how one would integrate the product and workflows into the existing process of data collection for most scenarios a company would need. Even more importantly, the book walks through some of the helpful ways you can share Metabase insights through other tools like Slack and email to help spread knowledge and insights on your analysis. I learned some new things about how to organize the data and use snippets of query code across questions that I didn't know existed. I've been using Metabase on AWS consistently for years and Tim's steps aligned with my own experience very well. Some of the lessons he shares are incredibly helpful in organizing dashboards and projects in a cohesive way that definitely helps once your data needs reach a certain scale.Hopefully others find this guide helpful and can leverage the power of Metabase for their own companies and products!
Amazon Verified review Amazon
Josh Yiangou Jan 04, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I've been evaluating different analytics software for my company and this book was the perfect read for learning more about Metabase and deploying it. While the world of databases, deploying analytics tools, and analytics is complex, this book helped simplify it with very helpful step-by-step guides and commentary from the author. Coming from an analyst background, I learned a lot about the processes of managing a database and cloud-based analytics software.In addition to the guides, there are many excellent recommendations on best practices for managing data and your data model within your organization. Metabase also has several interesting differentiators from its larger competitors that can make data more accessible to nontechnical people while providing more security to your data.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela