How to Integrate Agility PIM and Power BI for Seamless Visualization

The ability to integrate and consolidate business intelligence (BI) from multiple sources is essential for supporting the needs of today’s eCommerce businesses. As such, we’ve designed Agility Product Information Management (PIM) to deliver standard input and output connectors to all of your systems, out of the box.

We’ll show you how our AMI system can easily integrate with other applications. Here’s an example of Power BI visualization and the tools to create it on your Agility system.

Prepare your data

You’ll need to decide what data you’ll be using to prepare as the foundation of your visualization.

The easiest way is to make a database “view” of the data you wish to visualize. A view is a query stored in the database that lets you pull data from many tables. Although it’s stored in the database, it doesn’t affect the underlying structure (schema) of the database and doesn’t affect how Agility runs.

One thing to bear in mind—you’re not restricted to using only Agility data: you can show data from outside Agility inside AMI.

Our example

Our example visualization checks whether certain objects have values for specific attributes: if they have those values, the objects are awarded one, two or three “stars” to show how complete their information is.

We have a tool (view-generator-utility.jar) to create a database view that prepares this information. It’s a simple process of selecting which attributes something must have to earn a one-, two- or three-star rating, which types of objects you want to check and which structure(s) to look in.

Then just run the tool to create the view.

Create your visualization

Here is where you get to shine… your visualization can be as sophisticated or as direct as you need it to be. Power BI supports a huge range of features, including cross-report drill through, data insights and the powerful (and free!) R statistical computing language and environment.

Our example

The example view created by view-generator-utility.jar includes a wide range of data suitable for a completeness report. Below is an example of a very simple visualization using Count 𝚺 CHILDOBJECTID, then 𝚺 RATINGSCORE:

Show it in AMI

Now you have the report, hook it up to AMI via an AMI gadget.

You have two choices here: use either the streamlined BI Reports gadget or the highly customizable Bound Templates gadget.

  • The BI Reports gadget gives a straightforward view of the report, essentially a link to the report’s page.
  • The Bound Template gadget is the “full-fat” integration option for web-based content. With this gadget, you can use the full spectrum of web functionality, including JavaScript.

Our example

The example includes a set of HTML and JavaScript files you can use with the Bound Template gadget. Point the gadget at the HTML “mini page” and AMI will display the visualization along with a custom Refresh button, powered by JavaScript.

Wrap Up

There you go: in three simple steps, we’ve integrated a powerful visualization tool into the heart of your AMI system. You can apply these principles to your own Power BI visualizations, or any of your other web-based applications.

For the complete details to configure our example BI visualization, contact Agility today!