Power BI Shopify Overview Dashboard Template

Shopify Orders Dashboard

This Shopify Dashboard Report Template for Power BI helps you to visualize your own Shopify data in Power BI in a few clicks.

 

Follow the steps outlined below to get your data connected.

 

The template is available both as

 

Power BI Web Template

  1. Connect your Shopify Data to Windsor.ai

    Go to onboard.windsor.ai

    Register for free or login if you already have an account.

  2. Choose Shopify from the left-side menu, then click on “Shopify App Store”. From the Shopify App Store, search for “Windsor connector” and install it.
  3. Once the Windsor connector app is installed, go back to onboard.windsor.ai and select your store from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Install the Power BI Web App

    Install Power BI Web App: Shopify Overview Dashboard

  6. Click on Connect your data in the upper section of the dashboard.
    Shopify Power BI Dashboard Template - Connect your Data
  7. Enter your API Key from Step 4.
    Shopify Power BI Dashboard Template - Enter your API Key

  8. On the next screen click on Sign In
  9. Your data should be loading now. Depending on your data size this may take a minute or two.

 

Power BI Desktop

  1. Connect your Shopify Data to Windsor.ai

    Go to onboard.windsor.ai

    Register for free or login if you already have an account.

  2. Choose Shopify from the left-side menu, then click on “Shopify App Store”. From the Shopify App Store, search for “Windsor connector” and install it.
  3. Once the Windsor connector app is installed, go back to onboard.windsor.ai and select your store from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Download the Desktop Template

    Download Power BI Desktop Template: Shopify Overview Report

  6. When opening the template, on the start screen, paste your API Key from step 4:

Api Key

 

 

Power BI Shopify Dashboard Template: metrics and dimensions

Below are the predefined metrics and dimensions available in the template. However, you can any other field you need in the connection string.

 

Dimensions:

    • Order Date
    • Account Name
    • Order Name
    • Order ID
    • Order Currency
    • Order Payment Status
    • Shipping Country
    • Shipping Province
    • Shipping City
    • Shipping ZipCode
    • Shipping Address
    • Product Name
    • Product SKU
    • Product Title
    • Product Variant
    • Product Brand
    • Customer Name
    • Customer Email
    • Customer Tags
    • Customer Status

 

Metrics:

    • Gross Sales
    • # of Orders
    • Average Order Value
    • Net Margin
    • Net Margin %
    • Customer Spend
    • # of Customers
    • Average Spend per Customer
    • Average Orders per Customer

 

The Power BI Shopify dashboard template can be customized with > 50 different dimensions, breakdowns and metrics. Head here to see a complete list: available metrics and dimensions.

It queries the data through our connector and makes it available in real-time.

 

You might also be interested in…

Tags: