Metabase an Open-Source Business Intelligence Platform

Learn to install Metabase on Windows by using Docker Desktop, pull the Metabase latest image, and start the Metabase server container.

Run the metabase docker image, set a container name, switch the port to 1234 to access the Metabase URL, then build dashboards and graphs from the sample database, orders analytics.

Learn to start Metabase on a Docker container, monitor status with logs, and log in by providing user ID and password.

Learn how to stop a Metabase Docker container by using the status stop button, verify shutdown with the log and page refresh, and manage starting and stopping as needed.

Metabase supports a broad set of databases for visualization, including Amazon Athena, BigQuery, MongoDB, MySQL, MariaDB, PostgreSQL, Oracle, SQL Server, SQLite, Redshift, and Snowflake.

Pull the MySQL Docker image, run a container with environment variables and password, then connect Metabase to view the user table.

Connect Metabase to a MySQL database by configuring host, port, and credentials. Add the database via the updated UI and verify tables and permissions to visualize data.

Connect a MySQL database to Metabase by starting the Metabase container, locating the MySQL IP, enabling SSL, and saving the JDBC connection to view tables and auto-generated reports.

Remove a MySQL database from Metabase by navigating to admin settings, selecting databases, choosing MySQL, and confirming the delete; this session also shows how to add a new database.

Upload a csv data file into Metabase and store it in MySQL by creating the database and enabling upload, using the video game sales data.

Upload data to Metabase by connecting a MySQL database, enabling uploads in admin settings, and importing a video game sales CSV to populate tables.

Metabase models serve as pre-made starting points that organize data from tables, add descriptions to columns, store in collections, and save questions to speed up search results and analysis.

Build a Metabase model using the notebook editor to join orders and products, derive revenue (quantity times price), and save and summarize top products by category.

pull a postgres image from docker desktop, run a container with a name and password, and connect to Postgres via psql to explore databases and run basic SQL operations.

Learn to connect a PostgreSQL database to Metabase by adding the database in the Metabase UI, configuring the host and credentials, and verifying a cars table with a record.

Analyze uploaded video game sales data in Metabase to automatically generate visualizations, including Europe sales, North America sales, global sales, and Japan sales, plus ranking.

Explore questions in Metabase by combining queries with visualizations using the graphical query builder, or write native SQL queries to visualize data for non-SQL users.

Create a line chart with the graphic query builder to analyze video game sales. Select platform and global sales, sort by year, and save the chart to analytics collection.

Create a pie chart in Metabase using the graphic query builder to show the top ten games by global sales, sorted by sum of global sales in descending order.

Write sql queries in the sql query editor to group global sales by publisher, compute the sum, and order results descending, then visualize the top 25 as a pie chart.

Create a bar chart in Metabase by querying top ten consoles by global sales. Group by platform, order by sum of sales descending, and limit to ten.

Create a bar chart of popular genres across platforms by querying the database with the SQL editor, grouping by platform and ordering by count for January data.

Create a 100% stacked bar chart from a SQL query editor, displaying the top ten games by global sales with regional breakdowns.

Create a bar chart from a SQL query editor that counts video game sales by genre for January, generating a two-column table and visualizing the results.

Use the sql editor to build an area chart from January over time by adding a year column, then explore stack and 100% stack options and save the chart.

Create a bar chart of total sales per market from the video game sales data table, grouped by January and ordered by global sales descending, then save to analytics.

Create a video game analytics dashboard in Metabase, add saved questions and charts: top games by global sales, top platforms, and consoles, and view in full screen with auto refresh.

choose the right chart by data type and message, with line, area, bar, column, pie, histogram, scatter, and map options, and consider audience and context for clear visualization.

Explore combo charts in metabase by merging bars and lines or area on a single chart, using joined review and product data with groupings by category and month.

Create a detail chart from the accounts table to display a single record in a two column layout, using filters for Messi and qu be qu.

Master gauge charts in Metabase by displaying the sum of total from orders as a single value within a colored range and adjusting min, max, and currency style.

Metabase automatically selects the best map type for your data, enabling pin maps from latitude and longitude or region maps by country in the accounts table.

Display a single, large number with the number chart by selecting orders and summing total sales, then switch to currency to show the total amount in a big font.

Explore pie, donut, and sunburst charts in Metabase using the products table, grouping by vendor and category, and adjusting the outer ring to reveal layers.

Master pivot tables to swap rows and columns and group data by dimensions such as user state and product category. Show counts and totals with subtotals.

Master creating and configuring a progress bar in Metabase to compare a single value against a goal, and visualize KPI progress on a dashboard.

Learn how Sankey charts visualize data flow across sources and states, using count and sum, grouping by source and state to reveal node contributions in a multi-dimensional workflow.

Learn to create scatter plots and bubble charts in Metabase by visualizing correlations between birth year and product category, using joins, group by, and count.

Celebrate completing Metabase, an open-source business intelligence platform course, and invite learners to post a review and rating while wishing them future success.