Format:
1 online resource (333 pages)
ISBN:
9781800203143
Content:
This book is a comprehensive introduction for anyone who wants to use Metabase in their organization to make the most of their data. Metabase Up and Running guides you through the entire analytics journey, from connecting your data sources and creating visualizations and dashboards through to daily reporting
Note:
Description based on publisher supplied metadata and other sources
,
Cover -- Copyright -- About PACKT -- Contributors -- Table of Contents -- Preface -- Section 1: Installing and Deploying Metabase -- Chapter 1: Overview of Metabase -- Technical requirements -- Introducing Metabase -- Finding answers in your database -- Who should use Metabase? -- What is Metabase good for? -- What kind of data does Metabase accept? -- Metabase's origins -- Why open source? -- It's free -- You are in control of your data -- What's the catch? -- Installing Metabase locally -- Installing on Mac -- Installing on Windows or Linux -- Limitations of installing locally -- Installing and deploying Metabase via the cloud -- Running software in the cloud -- Heroku - an easy platform for cloud-based applications -- Signing up for a Heroku account -- Deploy Metabase to Heroku with one click -- Sign up before proceeding -- Limitations of Heroku's Free Tier -- Upgrading and deleting your Heroku app -- Summary -- Chapter 2: Deploying Metabase with AWS -- Technical requirements -- Introduction to Amazon Web Services -- Signing up for a free trial of AWS -- Signing in as the root user -- Metabase on Elastic Beanstalk -- Quick launch on Elastic Beanstalk -- Configuring your application for quick launch -- Using best practices for Metabase on AWS -- Creating an IAM user -- Creating a Virtual Private Cloud -- Deciding on scalability, availability, and cost -- Creating the Metabase application -- Creating a web app in Elastic Beanstalk -- Configuring your environment -- Configuring your database -- App creation -- Overview of the Metabase app infrastructure -- Terminating your environment -- Deleting your application -- Upgrading Metabase on Elastic Beanstalk -- Monitoring costs on AWS -- Monitoring app performance -- Summary -- Section 2: Setting Up Your Instance and Asking Questions of Your Data -- Chapter 3: Setting Up Metabase
,
Technical requirements -- Signing up for Metabase -- Getting to the admin panel -- Using a subdomain -- Serving Metabase over HTTPS -- Creating an SSL certificate in AWS -- Adding an HTTPS listener to the load balancer -- Defaulting all traffic to HTTPS -- Setting up email -- Setting up email with AWS -- Setting up email with Google Gmail or G Suite -- Allowing others to use Metabase -- Inviting users by their email addresses -- Setting up Google sign-in -- Authentication with LDAP -- Integrating Metabase with Slack -- Summary -- Chapter 4: Connecting to Databases -- Technical requirements -- What is a database? -- Creating a PostgreSQL database in AWS -- Downloading the PostgreSQL client on macOS -- Downloading PostgreSQL on Windows -- Connecting to your database with psql -- Introducing Pickles and Pies, our fictional business -- Loading data into our PostgreSQL database -- Connecting to our PostgreSQL database in Metabase -- Connecting to a database with best practices -- Making your database private -- Creating a read replica -- Creating a bastion host -- Connecting to your bastion host -- Connecting to a private PostgreSQL database via a bastion host -- Connecting to a private database via a bastion host in Metabase -- Connecting to other types of databases in Metabase -- Relational databases -- NoSQL databases -- Analytical databases -- Other databases and sources -- H2 -- SQLite -- Google Analytics -- Summary -- Chapter 5: Building Your Data Model -- Technical requirements -- Editing your data model -- Touring the Pies database in Metabase -- Editing the data model's metadata -- Specifying foreign key relationships -- Defining segments and metrics -- Defining segments -- Creating metrics -- Building your data dictionary -- Viewing and editing the data reference for a database -- Viewing and editing the data reference for tables
,
Segments and metrics in the data reference -- Additional thoughts on the data reference -- Creating permissions -- Creating user groups -- Applying data permissions -- Understanding how permissions apply to groups -- Limiting column-level access -- Additional thoughts on permissions -- Summary -- Chapter 6: Creating Questions -- Technical requirements -- Asking questions in Metabase -- Saving your first question -- Creating new collections -- Figuring out what questions to ask -- The three types of questions in Metabase -- Asking a simple question -- The table -- An optional filter -- An optional aggregation to summarize by -- An optional grouping -- Playing around with saved questions -- Asking a custom question -- Building on a custom question using joins -- Building on a custom question -- Starting a question from a saved question -- Formatting columns in questions -- Creating a native query -- Why use a native query? -- Writing a native query -- Summary -- Chapter 7: Creating Visualizations -- Technical requirements -- Customizing plots -- Choosing a visualization -- Customizing a simple line plot -- Creating bar plots, histograms, and row plots -- When to use bar plots -- Creating a bar plot -- Creating a histogram -- Creating a row plot -- Plots with multiple dimensions or metrics -- Creating a plot with two dimensions -- Creating a plot with two metrics -- Creating a plot with many dimensions or metrics -- Exploring more visualizations in Metabase -- Creating scatter plots -- Creating pie plots -- Creating funnel plots -- Creating plots based on single numbers -- Creating number, progress, gauge, and trend plots -- Setting up alerts -- Goal-based alerts -- Setting up event-based alerts -- Creating maps -- Creating a region map of users by US state -- Creating a pin map -- Creating a grid plot -- Adding custom maps with GeoJSON -- Summary
,
Chapter 8: Creating Dashboards, Pulses, and Collections -- Technical requirements -- Creating a simple dashboard -- Resizing questions in a dashboard -- Adding more questions to a dashboard -- Adding filters to a dashboard -- Adding Markdown to a dashboard -- Configuring your dashboard for fullscreen viewing -- Creating pulses -- Sending a pulse by email -- Sending a pulse via Slack -- Using MetaBot in Slack -- Discovering MetaBot's features -- Interacting directly with MetaBot -- Using MetaBot in Slack channels -- Organizing everything in collections -- Pinning items in collections -- Understanding permissions in collections -- Setting collection-level permissions -- Summary -- Chapter 9: Using the SQL Console -- Technical requirements -- Introduction to SQL in Metabase -- Translating notebook editor questions into SQL -- Learning about the SQL console -- Writing a simple SQL query -- Comparing SQL questions to notebook editor questions -- Choosing SQL over the notebook editor -- Creating Questions-as-Tables using SQL -- Using saved questions to ask more questions -- Adding SQL-based saved questions to dashboards -- Using variables in SQL queries -- Adding variables to SQL queries -- Configuring variables -- Adding an optional variable -- Configuring Field Filter variables -- Using variables in dashboards -- Creating saved SQL snippets -- Summary -- Section 3: Advanced Functionality and Paid Features -- Chapter 10: Advanced Features, Getting Help, and Contributing -- Technical requirements -- Caching queries -- What is cache? -- Configuring cache -- Limitations of cache -- Embedding and sharing externally -- Publicly sharing questions and dashboard -- Embedding questions and dashboards on external websites -- X-raying your data -- Creating an x-ray -- X-raying individual questions -- Zooming out and in on an x-ray
,
Using the Compare to the Rest feature -- Troubleshooting your Metabase instance -- Tasks -- Jobs -- Logs -- Troubleshooting using Metabase's documentation -- Getting help on Discourse -- Other Discourse use cases -- Creating issues and filling bugs on GitHub -- An example of a GitHub issue and pull request -- When to open an issue on GitHub -- Contributing to Metabase on GitHub -- Summary -- Other Books You May Enjoy -- Index
Additional Edition:
Erscheint auch als Druck-Ausgabe Abraham, Tim Metabase up and Running Birmingham : Packt Publishing, Limited,c2020 ISBN 9781800202313
Language:
English
Subjects:
General works
Bookmarklink
