Power BI Templates
Learn how to access your DataHawk data on our Power BI templates.
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 | Changes |
---|---|---|---|
Product | - BSR - Ratings - Price - LQS - Sales and Units - Estimates - Sales Share - Active Buy Box % | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened. |
Search | - Search Ranks - Share of Voice - Keyword Research - Keywords Insights | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened. |
Seller Finances & Supply Chain | - Profit & Loss - SKU-Level P&L - Unit Economics - Inventory - Replenishment Recos | February 26, 2024 | Separate filters for Sales and P&L tabs |
Advertising | - Account Ads - Campaign Ads - Products Ads - Keywords Ads | March 7, 2024 | Added additional attribution-related columns in the Product Overview tab (eg. breakdown between same-SKU and other SKU data, usage of 14-day attribution, etc.). Added Campaign and Campaign ID filters. Keywords can be grouped by Campaign or Ad Group. Added Quarterly and Yearly Bookmarks for History tabs. Improved Filter behavior |
Market Intelligence | - Category Insights - Top-selling Products - Est. Market Size, Share, Growth | March 12, 2024 | Changed Power BI Query according to changes in Power BI Online requirements |
Vendor Finances, Traffic & Supply Chain | - Vendor Revenue - Shipped/Ordered Revenue, Units - Product Page Views - Inventory - Demand Forecasts | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened. |
Accessing our Templates on Power BI Online
Estimated configuration time of less than <5 minutes.
- Go to app.powerbi.com to access Power BI Online
- From the left navigation menu, pick or create a workspace
- Click "Upload", and "Browse," then select the .pbix template file you downloaded; the upload takes a few seconds
- Point your mouse over the newly-uploaded dataset, then click the three dots to access the "Settings"
- 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
- Under the "Data source credentials" section, click "Edit credentials" to enter the username and password using the relevant credentials of that same destination
- Under the "Refresh" section, toggle the auto-refresh option to turn it on so that your dataset is refreshed daily. Optionally, select the time zone and time that make most sense for your business
- Data will start refreshing - this can take up to 30 minutes, depending on the volume and history
- 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
Setting up your Power BI Online instance for DataHawk templates
Our DataHawk Power BI templates use DirectQuery. It requires to activate SSO for each data provider you aim to use (Snowflake or BigQuery).
Estimated configuration time of less than <5 minutes.
Prerequisites: You need to be an administrator of your Power BI instance to be able to run this procedure.
- Navigate to https://app.powerbi.com/admin-portal
- Navigate to Tenant Settings
- In the list go to “Snowflake SSO” or “Google BigQuery SSO”
- Expand and activate the Enabled toggle.
It can take a few hours to be applied to your organization.
Accessing our Templates on Power BI Desktop
Estimated configuration time of less than <5 minutes.
- Using Power BI Desktop on Windows, open the .pbix template file you downloaded
- Click on "Transform data" in the upper actions bar in the Home section to open the Power Query Editor
- Click on "Manage parameters" in the upper actions bar
- Replace the values in Database, Server, and Warehouse with the relevant credentials of the Power BI destination you added on the DataHawk web app
- Click "Close & Apply" in the upper actions bar
- Enter the username and password using the relevant credentials of that same destination
- 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
Old Templates Versions
You can download below older versions of our Power BI dashboard templates in PBIX format.
Dashboard PBIX Template | Version | Changes |
---|---|---|
Market Intelligence | April 17, 2023 | |
Market Intelligence | April 21, 2023 | |
Seller Finances & Supply Chain | May 19, 2023 | |
Seller Finances & Supply Chain | May 23, 2023 | Ads and FBA metrics available in product overview tab Fixed various data quality issues |
Seller Finances & Supply Chain | May 25, 2023 | Made financial metrics sortable in the "Product Overview" tab |
Seller Finances & Supply Chain | June 08, 2023 | Fixed Inventory data |
Seller Finances & Supply Chain | July 05, 2023 | Now has both ASIN and SKU level product metrics Now has weekly historical Fewer tabs, more slicers FBA data available two ways Raw Amazon restock recommendations Custom metrics with user-selected quantity formula, lead time, and target weeks on hand Fxed Warehousing cost, ROAS, FBA inventory, Growth and Ad Spend metrics |
Seller Finances & Supply Chain | July 11, 2023 | Changed format of locked columns (account/product/sku) to remove gaps in tables Added TACoS and TRoAS Fixed Sales Growth to be calculated in the correct direction Polished the Amazon FBA Restock Recommendations to have more readable field names Polished misc. field names and formatting Polished slicer layout |
Seller Finances & Supply Chain | July 19, 2023 | Fixed project and tags slicers when adding more than 1 but less than all options Speed up on the Overview and Inventory tab |
Seller Finances & Supply Chain | August 01, 2023 | Fixed advertising to be in negative values similar to other costs |
Search & Content | May 31, 2023 | Fixed Product tag filter |
Vendor Finances, Traffic & Supply Chain | May 16, 2023 | |
Seller Finances & Supply Chain | August 03, 2023 | Set data to be unanonymized by default |
Market Intelligence | May 30, 2023 | |
Seller Finances & Supply Chain | August 04, 2023 | Set data anonymization to be off by default |
Seller Finances & Supply Chain | August 22, 2023 | Fixed inventory and restock recommendations for SKUs sold in multiple marketplaces.Included a P&L comparison tab where you can compare financial KPIs across two different periods. |
Vendor Finances, Traffic & Supply Chain | August 08, 2023 | Database parameters are now successfully editable. |
Advertising | March 31, 2023 | |
Search & Content | August 08, 2023 | Fixed inaccurate display of LQS in the Content tab. |
Market Intelligence | August 08, 2023 | Database parameters are now successfully editable. |
Seller Finances & Supply Chain | September 01, 2023 | Faster performance on the Sales Charts, Overview and Inventory, P&L History, and P&L Comparison tabs. Other filters no longer depend on the entity filters e.g. you can filter SKUs even if displaying account-level metrics. The P&L Comparison tab now has a selector for using actual values or adjusted values for base metrics instead of displaying both at the same time. |
Vendor Finances, Traffic & Supply Chain | September 14, 2023 | Changed default Marketplace filter to all. |
Search & Content | September 19, 2023 | Show last view time on report tabs. Remove an unecessary workspace_id column reference. |
Vendor Finances, Traffic & Supply Chain | September 19, 2023 | Show last view time on report tabls. |
Search & Content | September 22, 2023 | Reference updated brand information from product data. |
Search & Content | September 27, 2023 | - Search Ranks - Share of Voice - Keyword Research - Keywords Insights - Content - Sales Rank - Buy Box - Changes |
Seller Finances & Supply Chain | September 19, 2023 | Show last refresh time on report tabs. |
Search | October 30, 2023 | New template: a more robust Search-centric dashboard Performance improvement (up to 6 months of history for up to 1K keywords tracked) Non-SEO tabs removed Sponsored ranks added UX improvements (tooltips on the Search Overview tab, views customization with hierarchies options) |
Product | November 22, 2023 | Ability to customize rows for segmentation levels by Market, Seller, Project, Tag, Brand, Variant, and Category. Ability to customize columns for analyzed metrics. Addition of a historical analysis tab. |
Seller Finances & Supply Chain | December 12, 2023 | All associated seller account names across marketplaces are now displayed as seller account name on tables. |
Vendor Finances, Traffic & Supply Chain | September 26, 2023 | |
Product | Dec 5, 2023 | A Dashboard tab providing a Product metrics overview Additional KPIs: sessions, pageviews, conversion rates, and real Buy Box ownership (require a Seller Central account connection) |
Product | February 9, 2024 | Product Name available as Entity Product Name filter added Project filter removed following Projects deprecation |
Seller Finances & Supply Chain | January 10, 2024 | Orders data has been added to the dashboard along with new visuals. Sales from orders indicate earned sales from completed purchases while sales from financial events indicate realized sales from collected payments. |
Product | February 16, 2024 | Improved visuals by removing unnecessary filter Improved Dashboard tab metrics by aggregating data for the entire selected period instead of just the last date. |
Product | February 19, 2024 | Improved visuals by removing unnecessary filter Improved Dashboard tab metrics by aggregating data for the entire selected period instead of just the last date. Disassociated seller in traffic table from buy box seller. |
Search | December 19, 2023 | Removed unnecessary date filter on the keyword research tab. |
Seller Finances & Supply Chain | February 20, 2024 | Orders tab removed for performance Tabs have been renamed for clarity - the Sales tabs rely on Orders data for analyzing sales performance, while the P&L tabs provide the accounting view through financial events. Unified currency for Sales data, added currency filter. Added Product Names and Brands to visualizations and filters |
Advertising | September 19, 2023 | Show last view time on report tabs. |
Market Intelligence | September 19, 2023 | Show last view time on report tabs. |
Seller Finances & Supply Chain | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened. |
Advertising | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened. |
Market Intelligence | February 21, 2024 | Last datapoint date is shown on each tab. Data refresh tracking has been lightened.Added additional attribution-related columns in the Product Overview tab (eg. breakdown between same-SKU and other SKU data, usage of 14-day attribution, etc.). Added Campaign and Campaign ID filters. Keywords can be grouped by Campaign or Ad Group. Added Quarterly and Yearly Bookmarks for History tabs. |
Market Intelligence | March 5, 2024 | Ability to filter Brands on History tab. Enhanced user guidance for Optimal Data Selection. |
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.
Updated 17 days ago