Analyze and Monitor your SweetIQ Data with Power BI

SweetIQ lets you to easily track your local listings by providing location and review data from your local search ecosystem. Power BI allows you to analyze and monitor that data, by offering out of box content built from your SweetIQ data. This content includes a dashboard, a set of reports and a curated dataset to explore and provide insights such as the average rating of your listings.

This post will detail how the Power BI content pack helps you explore your SweetIQ data. For additional details on how to get started, please see the SweetIQ content pack for Power BI help page.

The content pack brings in data about your listings, locations, ratings and reviews from SweetIQ. To get started, just connect to your SweetIQ account.

A dashboard is automatically created once you’ve provided credentials. The dashboard is a set of tiles, each one displaying a specific metric to monitor from the dashboard view. Select one of the tiles to drill in further to the reports, such as “Listing Errors”.

This brings you to the Listing report, one of four pages of reports that are included as part of the out-of-box content. Other reports include Locations, Rankings and Reviews. Each tile on the dashboard may lead to different report pages.

Each report visualizes the data in the best way possible to provide unique insights. You can hover over any of the items for more detail, or select a particular value to cross filter the other visuals on the page. The filter pane allows you to change the slice of data you’re viewing.

Any of the existing visuals can be pinned to the dashboard, allowing you to fully customize it for your needs. You can also switch into Edit mode, to view all the fields available for your reporting. This allows you to edit or add additional visuals to customize your report and dashboard.

Another way to explore the data is through the question box above the dashboard. Start by asking a question of your data – such as “best rank by keyword search” or “average rating by domain”. Those results can also be pinned to your dashboard by hovering over the image and selecting the pin icon.

After the initial import, the dashboard and the reports continue to update daily. You can control the refresh schedule on the dataset.

With the SweetIQ content pack for Power BI, you have access to a rich local marketing dataset of metrics and insights so you can explore your data even further.

We’re always interested in hearing your feedback – please contact us at http://support.powerbi.com to let the team know how your experience was and if there’s anything we can do better. We look forward to your feedback!