Amazon BI FAQs

Here you will find answers to frequently asked questions about Amazon BI. The interface is based on the tool “Metabase”, so for more in-depth topics we link to the official Metabase documentation.

Tip
The Metabase documentation is available in English. The videos clearly demonstrate the usage, making them easy to follow.

Basics

How do I create a new dashboard?

A dashboard is a collection of charts and KPIs on a single page. Here is how to create a new dashboard:

  1. Click the + icon in the upper right corner
  2. Select New Dashboard
  3. Enter a name
  4. Add charts with + > Add a question

Detailed guides:

How do I create a new chart?

In Metabase, charts are called “questions.” You “ask” your data and receive a visual answer:

  1. Click + > New Question
  2. Select Simple Question for the visual Query Builder
  3. Choose a data source (e.g., “SellerProductsCurrent”)
  4. Configure filters, groupings, and aggregations
  5. Click Visualize
  6. Select the desired chart type

Detailed guide: Asking questions

What data sources are available?

In Amazon BI, you will find the following prepared data sources:

Data sourceDescription
SellerProductsCurrentCurrent Seller product data
VendorProductsCurrentCurrent Vendor product data
SellerProductsHistoryHistorical Seller data
VendorProductsHistoryHistorical Vendor data

Depending on your account type, you will see Seller and/or Vendor data sources.

Filters and Interactivity

How do I work with filters in a dashboard?

Filters allow you and other users to explore dashboards interactively. Typical filters include:

  • Marketplace: DE, UK, FR, IT, ES, etc.
  • Brand: Filter by your brands
  • Time period: Flexible date ranges
  • Tags: Filter by AMALYTIX tags

How to add filters:

  1. Open a dashboard in editing mode
  2. Click the Filter icon
  3. Select the filter type
  4. Link the filter to the relevant charts

Detailed guides:

When you create a dashboard filter, you can link it to multiple charts. This way, a single filter affects all relevant visualizations:

  1. Create a filter (e.g., “Marketplace”)
  2. Click on the filter and select Link filter
  3. Enable all charts that should respond to this filter
  4. Select the corresponding data field for each chart

Visualizations

What visualizations are available?

Amazon BI offers a broad range of visualization options:

Chart types:

  • Table, bar chart, line chart, pie chart
  • Area chart, combination chart, pivot table
  • Map, funnel chart, scatter plot, waterfall chart

KPI widgets:

  • Single number, trend sparkline, gauge, progress bar

Detailed guide: Visualizations

How do I create a period comparison?

Compare current data with previous periods (e.g., current month vs. previous year):

  1. Create a new question with a date grouping
  2. Click the visualization settings icon
  3. Enable Compare to previous period
  4. Select the comparison period (previous year, previous month, etc.)

Detailed guide: Creating time series comparisons

Export and Reports

How do I export a dashboard as PDF?

  1. Open the desired dashboard
  2. Click the … menu in the upper right corner
  3. Select Export dashboard
  4. Choose PDF as the format

How do I set up automatic email reports?

You can have dashboards sent regularly via email:

  1. Open the dashboard
  2. Click the Share icon
  3. Select Create subscription
  4. Configure recipients and schedule

How do I export individual chart data?

  1. Click on a chart
  2. Select the … menu
  3. Choose Download results
  4. Select the desired format (CSV, Excel, JSON)

Advanced Features

How do I create calculated fields?

With Custom Columns, you can create your own calculations:

  1. Open the Query Builder
  2. Click Custom column
  3. Enter the formula (e.g., [Revenue] / [Units sold] for average price)
  4. Assign a name

How do I join multiple data sources?

With Join Data, you can combine data from different sources:

  1. Select your primary data source
  2. Click Join data
  3. Choose the second data source
  4. Define the join field (e.g., ASIN)

Can I write SQL queries?

Yes, for complex analyses you can also use SQL directly:

  1. Click + > New Question
  2. Select Native Query instead of Simple Question
  3. Write your SQL query
  4. Click Visualize
Note
SQL queries require knowledge of the database structure. For most use cases, the visual Query Builder is sufficient.

Troubleshooting

My chart shows no data

Possible causes:

  1. Filters too restrictive: Check whether your filters are excluding data
  2. Wrong time period: Select a time period that contains data
  3. Wrong data source: Make sure you have selected the correct source (Seller/Vendor)

Performance is slow

With large datasets, queries may take longer:

  1. Use filters: Narrow down the data volume
  2. Set row limit: Limit the number of rows
  3. Aggregate: Use Summarize instead of displaying raw data

Support and Training

Our Customer Success Team is happy to assist you with setup and offers individual training sessions. Contact us through the support chat in AMALYTIX or by email.