Power BI templates

Learn how to access your DataHawk data on our Power BI templates.

Anuja avatar
Written by Anuja
Updated this week

This article is no longer being updated. For updated information visit LINK

We provide a library of ready-to-use templates based on best practices from hundreds of top brands and agencies. With these powerful, theme-based dashboards, you can analyze your data in just a few minutes.

🚧 Note: These templates should exhaustively cover the needs of 90%+ of the brands out there. In case you want to customize them but are unable to do so autonomously, we provide a paid customization and dashboard-building service.

Templates

You can download below our Power BI dashboard templates in PBIX format. Simply follow the instructions below to start using them within minutes.

Dashboard PBIX Template

Content

Version

  • Search Ranks

  • Share of Voice

  • Keyword Research

  • Keywords Insights

  • Content

  • Sales Rank

  • Buy Box

  • Changes

April 4, 2023

  • Profit & Loss

  • SKU-Level P&L

  • Unit Economics

  • Inventory

  • Replenishment Recos

April 2, 2023

  • Account Ads

  • Campaign Ads

  • Products Ads

  • Keywords Ads

March 31, 2023

Vendor Finances & Supply Chain

  • Ordered Units, Revenue, COGS

  • Shipped Units, Revenue, COGS

  • Account and Product-Level Data

  • Inventory

Coming soon - Contact us for Beta

Market Intelligence

  • Category Insights

  • Top-selling Products

  • Est. Market Size, Share, Growth

Coming soon - ETA mid-April

Accessing our Templates on Power BI Online

Estimated configuration time of less than \<5 minutes.

1. Go to app.powerbi.com to access Power BI Online

2. From the left navigation menu, pick or create a workspace

3. Click "Upload" and "Browse," then select the .pbix template file you downloaded; the upload takes a few seconds

4. Point your mouse over the newly-uploaded dataset, then click the three dots to access the "Settings"

5. Under the "Parameters" section, replace the values in Database, Server, and Warehouse with the relevant credentials of the Power BI destination you added on the DataHawk web app

6. Under the "Data source credentials" section, click "Edit credentials" to enter the username and password using the relevant credentials of that same destination

7. Under the "Scheduled refresh" section, toggle the auto-refresh option to turn it on so that your dataset is refreshed daily

8. Data will start refreshing - this can take up to 30 minutes, depending on the volume and history

9. Once refreshed, you'll be able to access the report template tied to that dataset as you navigate back to your workspace and select the report

[block:html]
{
"html": "<div style=\"position: relative; padding-bottom: calc(50.3515625% + 41px); height: 0;\"><iframe src=\"https://demo.arcade.software/m9qTpKvn3zhRlcBap7R0?embed\" frameborder=\"0\" loading=\"lazy\" webkitallowfullscreen mozallowfullscreen allowfullscreen style=\"position: absolute; top: 0; left: 0; width: 100%; height: 100%;color-scheme: light;\" title=\"Power BI - Accessing our Templates on Power BI Online\"></iframe></div>"
}
[/block]

Accessing our Templates on Power BI Desktop

Estimated configuration time of less than \<5 minutes.

1. Using Power BI Desktop on Windows, open the .pbix template file you downloaded

2. Click on "Transform data" in the upper actions bar in the Home section to open the Power Query Editor

3. Click on "Manage parameters" in the upper actions bar

4. Replace the values in Database, Server, and Warehouse with the relevant credentials of the Power BI destination you added on the DataHawk web app

5. Click "Close & Apply" in the upper actions bar

6. Enter the username and password using the relevant credentials of that same destination

7. Data will start refreshing - this can take up to 30 minutes depending on the volume and history; if you run into any error, try re-applying the changes once or twice, then contact our team for further assistance

[block:html]
{
"html": "<div style=\"position: relative; padding-bottom: calc(50.66406249999999% + 41px); height: 0;\"><iframe src=\"https://demo.arcade.software/oci521JifH1OoKD4a9sv?embed\" frameborder=\"0\" loading=\"lazy\" webkitallowfullscreen mozallowfullscreen allowfullscreen style=\"position: absolute; top: 0; left: 0; width: 100%; height: 100%;color-scheme: light;\" title=\"Power BI Templates\"></iframe></div>"
}
[/block]

Old Templates Versions

You can download below older versions of our Power BI dashboard templates in PBIX format.

Dashboard PBIX Template

Version

Jan 26, 2023

Feb 13, 2023

March 6, 2023

March 13, 2023

March 13, 2023

March 22, 2023

March 27, 2023

March 30, 2023

Dashboard Building Service and eCommerce Data Advisory

Our team of eCommerce experts and data analysts is available to assist with the creation of completely customized dashboards that are tailored to your business needs, processes, workflows, and preferred data visualization methods.

Our approach goes beyond simply creating charts and tables. We strive to understand your daily workflows and business challenges, drawing on our extensive experience supporting hundreds of brands and agencies. With this insight, we can help you build efficient solutions that empower you to accelerate growth and establish a competitive advantage.

Did this answer your question?