Adopt or foster a pet. Save a life. Reduce animal shelter overcrowding. Read more...
Perspective ILM BI Portal

Unifying Analytics Across Vendors with Perspective ILM BI Portal



With the recent industry shift towards the use of agile self-service BI solutions, traditional and modern BI solutions are often deployed side-by-side in a bi-modal analytical strategy. It is not uncommon for organizations today to have three or more different reporting vendors and numerous reporting server instances scattered across departments or locations. In this article, I will share a lovely new solution called Perspective ILM BI Portal for unifying heterogeneous analytics solutions.

Perspective ILM


Although some organizations are consolidating analytics portfolios, providing the right analytical tool for the right user and use case is invaluable. Windows of opportunity are smaller today. It is unlikely any one vendor can satisfy all modern, constantly changing reporting needs, in a timely manner. Thus flexibility is an important aspect in modern analytics architecture.

Providing the right analytical tool for the right user and use case is invaluable.

Reports Everywhere

Users are overwhelmed by the expanding ecosystem of reports. Trying to quickly find the right information, when and where you need it, continues to be more time consuming and difficult to do. Many organizations literally have thousands of reports. Sifting through the clutter of outdated, redundant or similar reports is frustrating and an expensive waste of limited time.

With constantly growing lists of data sources and new self-service reports being shared in a heterogeneous “Bring Your Own Reporting Tool” world, managing and governing these systems is even more challenging. Data quality, security and privacy are high priority initiatives in an increasingly digital world.

Historically SharePoint or other intranet web portals have been used to organize links or open windows to various reporting assets. SQL Server Reporting Service 2016 also provides a slightly improved user experience for Microsoft-centric reporting but with only one report server instance. These approaches partially solve the pain of locating a report. However, it leaves much to be desired with regards to truly amalgamating reporting business taxonomy, metadata management, context, collaboration, and governance across assets from different reporting vendors or multiple reporting servers.

Introducing Perspective ILM BI Portal

Perspective ILM BI Portal provides a “one-stop-shop” for unifying and harmonizing heterogeneous reporting environments. It allows you to manage reporting metadata across Microsoft BI (SQL Server Reporting Services, Power BI, Datazen, Excel), Pyramid Analytics, Tableau, Qlik, TIBCO Spotfire, IBM Cognos, SAP Business Objects, Microstrategy, and many other popular web-based reporting solutions. Everyone will appreciate a ubiquitous environment for discovering, sharing and collaborating on analytical insights.

Perspective ILM BI Portal

BI Portal makes finding and using relevant reports easy with natural language query. It breaks down inefficient silo reporting across the enterprise. Analytics users benefit from global search, context-aware audience targeting, improved reporting visibility, collaboration and centralized reporting governance. Non-technical users can customize tiles and personalize landing pages with links to key reports, KPIs, data sources, and embed related BI content. Report consumers can enjoy added reporting context with tags, annotations and metadata management.

Solution Architecture

BI Portal’s unique publishing and tagging framework ensures content is discoverable in an intelligent, governed manner. With a completely configurable taxonomy, this solution allows you to manage reporting metadata across vendors and optionally integrate with third-party data catalog offerings such as Azure Data Catalog, Alation, or Waterline Data.

BI Portal Architecture

Solution Highlights

A summary of BI Portal key capabilities and features includes but is not limited to the following list of highlights.

  • Global reporting search with extensions for natural language
  • Enterprise business data glossary and reporting taxonomy
  • Automated discovery and population of new reports
  • Intelligent personalized audience targeting
  • Fine grained role-based reporting data governance and stewardship
  • Simple publishing workflow
  • Self-service reporting help desk ticketing system
  • Integration with third-party data catalog metadata
  • On-premises or cloud deployment options

For More Information

BI Portal is intended for organizations that are adopting a bi-modal analytics strategy that want to harmonize heterogeneous reporting environments. For more information, please check out the following resources.



The Author

Jen Underwood is the founder of Impact Analytix, LLC. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning. Over the past 20+ years, Jen has held worldwide product management roles at Microsoft and DataRobot. She also served as a technical lead for system implementation firms. She has experience launching new products and turning around failed projects. Most recently she provided advisory, strategy, educational content development, and marketing services to 100+ technology vendors through her own firm. She has been mentioned by KD Nuggets, Information Management and Forbes for her work. She also has written for InformationWeek, O’Reilly Media, and numerous other tech industry publications. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego. She was also honored to be a former IBM Analytics Insider, Tableau Zen Master, and Top 10 Women Influencer.