Course Outline
Introduction
- Metabase vs Superset vs Tableau
- Overview of Metabase features and components
Getting Started
- Installing Metabase
- Setting up an account
- Connecting the database
- Exploring the UI and tools
Querying Data
- Adding a question (simple and custom)
- Creating explorable charts
- Using custom expressions
- Joining tables in Metabase
- Aggregating multi-level queries
Working with SQL
- Writing SQL queries (native query)
- Creating filter widgets
- Adding smart filter widgets
- Working with dates in SQL
- Using SQL snippets
- Simplifying queries with CTEs
- Organizing SQL codes (snippets, saved questions, views)
- Combining tables with joins
Building Visualizations and Dashboards
- Choosing a chart type
- Customizing visualization settings
- Setting up and configuring dashboards
- Making dashboards interactive
- Adding dashboard filters
- Best practices and tips
Analyzing and Managing Data
- Using time series comparisons
- Building a customer lookup tool
- Delivering customer-facing analytics
- Embedding charts and dashboards to websites
- Other use cases and examples
Common Issues and Troubleshooting
Summary and Next Steps
Requirements
- An understanding of data analytics and database concepts
Audience
- Data analysts
- Data scientists
Testimonials
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
Marco Iuliano
some of the best practices on charts
AIG SHARED SERVICES-BUSINESS PROCESSING, INC.
Related Courses
Business Intelligence in MS SQL Server 2008
14 hoursTraining is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of
55232-A: Writing Analytical Queries for Business Intelligence
21 hoursThis three-day instructor led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis - in other words, making
AWS QuickSight
14 hoursAWS QuickSight is a business analytics service by Amazon. It provides tools for building data visualization, performing ad hoc analysis, and getting business insights from different data sources. This instructor-led, live training (online or
Sisense Business Intelligence
14 hoursSisense is a Business Intelligence tool that provides user-friendly solutions for managing, visualizing, and modifying multiple big data sets quickly and efficiently. This instructor-led, live training (online or onsite) is aimed at developers
Big Data Business Intelligence for Govt. Agencies
35 hoursAdvances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of
Big Data Business Intelligence for Telecom and Communication Service Providers
35 hoursOverview Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow
Qlik Sense for Data Science
14 hoursQlik Sense is a cloud-based data analytical software for analyzing and displaying data. With Qlik Sense, users will be able to gain impactful insights by connecting to different data sources and creating advanced visualizations. This
Big Data Business Intelligence for Criminal Intelligence Analysis
35 hoursAdvances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these
Datameer for Data Analysts
14 hoursDatameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led,
IRIS: Document Classification and Data Capture
7 hoursIRIS is an Enterprise Content Management (ECM) system. With IRIS, users can automate document classification and data capturing. This instructor-led, live training (online or onsite) is aimed at content managers who wish to optimize and update
Power BI Dashboards
14 hoursLearn how to Get & Transform Data to Prepare Interactive Dashboards Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which
Pentaho Open Source BI Suite Community Edition (CE)
28 hoursPentaho Open Source BI Suite Community Edition (CE) is a business intelligence package that provides data integration, reporting, dashboards, and load capabilities. In this instructor-led, live training, participants will learn how to maximize
Qlik: Advanced Topics in Design and Development
14 hoursQlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this
QlikView Server Administration
14 hoursQlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this
Business Intelligence with SSAS
14 hoursSSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client