Enterprise BI Portal v4.2 Released

The latest release of the Enterprise BI Portal is all about asset management, and boy does it deliver.  A new asset embedding framework now allows you to embed any web based asset directly into the portal.  To remove the complexity of embedding assets, the new version also comes with easy to follow wizards that guide you step by step through the process.

For those with more technical skills, you can now also upload your own code and design elements to completely customise the portal to your individual organisation guidelines.

Lets take a look at what 4.2 includes:

Asset Management Features:


We have included a new embedding framework that allows you to embed any web based asset type right in to the portal.  Previous versions of the Portal only allowed you to register and publish assets, but to view the asset meant you were directed to the source application.  Now you stay right where you are!

Embedding an Asset type does involve some technical complexity.  We’ve provided wizards for the following groups of asset types that take the guess work out of setting this option up.  v4.2 provides wizards for the following asset types:

    • Power BI
    • Power BI Report Server
    • SQL Server Reporting Services

Not only can you now embed assets, you can choose exactly which assets you want to embed, or disable the embed options for assets you would prefer to access at the source.


Once your asset has been embedded you can pin the asset directly to a tile layout.  This means you can control exactly which assets are targeted to which team for their individual landing page.

A new feature also gives you the ability to disable users from opening the asset in the source system.

Update Connection

In this version, you can now update asset connection information, and even change the asset type.

Power BI Report Server Support

We’ve provided support for Power BI Report Server in this release, with this support you can;

  • Register assets from Power BI Report Server
  • Embed these assets using the Power BI Report Server embedding wizard. We even support embedded excel if you’ve connected an Office Online Server!
  • Import these assets automatically using the Power BI Report Server source system connector

SSRS 2017 Support

Enterprise BI Portal 4.2 now comes with a SQL Server Reporting Services source system connector to support the new 2017 version.


Try it for yourself today.

 Additional Resources

  1. For more information
  2. Download the White Paper Now
  3. Click Here to arrange a Demonstration today.

New Release of Enterprise BI Portal

Version 4.1 of the Perspective Enterprise BI Portal is here, and the latest visualization focused enhancements are stunning.

Perspective Enterprise BI Portal is a “one-stop-shop” to bring together and harmonize heterogeneous reporting environments. For organizations adopting a bi-modal analytics strategy combining both traditional BI with modern BI, Perspective – Enterprise BI Portal solves the pains of trying to find the right report, reduce duplicate analytical efforts, and unite silos of insight.

Here is a break down of the latest features:

1. Customised Branding

You can now fully customise the look and feel of the Portal via the brand new ‘Branding’ option available for Portal administrators.  From minor cosmetic changes such as logo and color theme, right through to being able to upload your own CSS file to seamlessly fit in with your Corporate style guide.

2. New Layout Options

Prefer to view results in a list? The Portal now has the ability to switch layout views so you can find what you are looking for in a format that you want.

We have also added a visually stunning presentation of Asset information and Editing.  Click on on the Information tab, and select an area to edit.  A smooth transition and presentation allows the user to view the page they came from and what they are editing in one block.

3. Keyword Search

You can now perform a keyword search across all published assets.  Simply enter what you are looking for and the Portal will display all relevant assets for your search.

4. Breadcrumbs

Dive deeper into the Portal and our new breadcrumb navigation will remind you exactly how you got there.   You can navigate to and fro along the breadcrumb to find what you are looking for.

Try it for yourself today.

Additional Resources

  1. For more information
  2. Download the White Paper Now
  3. Click Here to arrange a Demonstration today.

Perspective ILM announces 2 new Product Releases

Its with great excitement that we announce the latest major release of both Perspective Data Governor v5.0 and Perspective Enterprise BI Portal v4.0.

Perspective ILM products have been expediting BI initiatives of our customers for the past seven years, and have continuously evolved based on customer feedback, and latest Microsoft technologies.

Jen Underwood is hosting an exclusive Webinar to present the products in detail.  Make sure you register to hear from one of the greats of Analytics and Business Intelligence.

Focused on delivering enterprise BI rapidly and cost effectively, Perspective ILM products can stand up a production ready environment in days.  Let’s have a look at the products.

Low Friction Data Warehousing with Data Governor v5.0:

Perspective ILM Data Governor is a data orchestration accelerator.

Data Governor fast tracks operational data store, analytical sandbox and data warehouse creation by eliminating most of the complex extract-transform-load (ETL) work that historically accounted for 80% of the work effort. Utilizing an agile orchestration design and a simple user-friendly web interface, you can deliver insights with Data Governor from disparate data sources with no complex coding.

Additional Resources:

  1. For more information
  2. Download the White Paper Now
  3. Click Here to try it for yourself.

Unifying Analytics with Enterprise BI Portal v4.0:

Perspective Enterprise BI Portal is a “one-stop-shop” to bring together and harmonize heterogeneous reporting environments. For organizations adopting a bi-modal analytics strategy combining both traditional BI with modern BI, Perspective – Enterprise BI Portal solves the pains of trying to find the right report, reduce duplicate analytical efforts, and unite silos of insight.

The 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 catalogue offerings.

Additional Resources

  1. For more information
  2. Download the White Paper Now
  3. Click Here to try it for yourself.

Perspective winds the dial on BI development

There are two very important factors in achieving faster actionable insight from your Business Intelligence environment.

  1. Your Data needs to be ready
  2. You need to be able to make sense of it

You have data in disparate systems across your enterprise.  Most businesses will be producing reports directly off the source systems, or bulk loading data into a staging environment to then produce reports.  In most cases these are produced manually, stitched together in Excel, and served to the business via email.  Sound familiar?

Here’s where Perspective steps in.  Lets look at how the products help.

Faster Data Delivery

Drastically reduce the time required to provision data for Reporting and Analytics

Establishing a Business Intelligence environment traditionally requires custom development of management frameworks and tools. Perspective Data Governor ensures a faster Data Warehouse development cycle by reducing the delay of onboarding new data, reducing the amount of ETL normally needed and minimising the ongoing management overhead. Featuring a single web interface, you can centrally manage job dependencies, data reconciliation and your data pipeline across multiple command operations, whilst defining ongoing incremental load rules in seconds.

Reliable and Timely Information

Automate processes to verify data accuracy and reduce your processing time
There may be a number of reasons why you’re experiencing quality and timing issues with data published for reporting and analytics.
Typically, it is difficult to time jobs to run in succession, and issues required a lot of time to investigate error logs and perform manual reconciliation checks.
Perspective Data Governor provides a practical Data Process Control framework that provides assurance of the timeliness and reliability of data by making sure jobs run in the right sequence and that dependencies are managed to fit into the time window for processing. Data Governor simplifies incremental processing to speed up data refreshes and provides automated Alerts of failed processes.
By automatically reconciling data between source and target systems at a transactional and aggregate level, Data Governor allows access to reliable and timely data required for meaningful business insight.

User Self-Service

Create a single point of delivery of all information across all your tools
Reporting sprawl is a common symptom of disparate department reporting requirements being provisioned by multiple tools used across different source and legacy systems. Due to this, it becomes increasingly difficult to find the information you are looking for, and even more difficult to track where and when the data originated. The Perspective Enterprise BI Portal drastically reduces the number of disparate reporting tools usually associated with provisioning BI. A single location for all of your reporting requirements, the Portal provides self-service capabilities for your entire business in a secure and governed manner.


The Enterprise BI Portal just got even better. V3 is here.

V3 of the Enterprise Business Intelligence Portal continues to flex its capabilities as the Microsoft BI suite grows, now providing seamless integration with Datazen and Power BI.

The Portal features a unique publishing framework to ensure reports are created, collaborated on, published and discoverable in a governed manner. Pivoting around a global report catalogue, V3 also introduces a unique and secure audience targeting capability to ensure that the right information is available to the relevant audience every time.

So, let’s take a look at the new features available:

Datazen Integration

The key focus of the Enterprise BI Portal is to provide a central and governed Business Intelligence framework, removing the complexity of trying to make sense of your data when spread across multiple applications. True to its purpose, one of the latest features in V3 is Datazen integration.

An option you can choose to enable, this feature ensures that your existing Datazen dashboards can be registered, rendered and consumed directly from the Portal.

A new Datazen library allows you to register your Datazen dashboards in the central catalogue using the same metadata that you have across your entire portal. This means Datazen dashboards are now treated like any other artefact within the portal. What does this mean? It means that Datazen dashboards can be searched for, published and viewed in the same governed manner as your existing reports.

All you need to do is enter the dashboard name, dashboard group and dashboard hub and it will be available to users without having to ever leave the BI Portal. Datazen dashboards can be optionally displayed in full screen mode to hide the portal navigation also.

Power BI Integration

BI Portal customers can also optionally choose to enable Power BI integration.

Similar to the Datazen integration feature, a unique Power BI library allows you to enter the URL of your Dashboard, Report or Dataset and categorise it by type.

These will then appear in the report catalogue and automatically navigate to the particular page in Power BI when selected.

Audience Awareness

Customer feedback plays a significant role in the continuous development and growth of the Enterprise BI Portal, and a big part of customer feedback has been to further enhance targeting content to different audiences. Ensuring every user’s experience is as relevant as possible, V3 introduces a number of enhancements in the following areas:

Commentary Targeting

Every commentary thread now can be filtered by an author for particular users or groups of users. That means that sensitive discussions on reports can be secured.



Item Level Security by Meta-Data tag and Audience

In V2 we allowed you to control which audience could see particular items in the global navigation menu based on settings set on the metadata associated with each artefact.

Now in V3, we’ve extended this to control permissions for individual items that have been tagged with a particular business area and also sensitivity level. This means you can ensure only those users which specific permissions will be able to view highly sensitive reports. Other users can still navigate to a particular business area (as part of the global navigation) but will not be able to see, search for, or find these secure items.


Tile Audience Targeting by AD Group

In line with our focus on ensuring the right information is delivered to the right audience each time, we’ve added further support for tiles to allow an AD group to be targeted also. 

O-Data Service

We’ve had lots of requests to make it easier to extract commentary and integrate into reports or other documents. To make this easy, we’ve created an O-Data Service that you can connect to via Power Query or SSIS to integrate into other reporting such as SSRS or Power View Dashboards.

The O-Data Service isn’t just limited to Commentary Threads, report catalogue meta-data can be also queried from the BI Portal, to allow you to build custom auditing solutions to suit your individual business needs.

Custom Metadata

Certain functionality built into the Portal depends on pre-configured metadata. But what about metadata specific to your business? V3 now allows you to configure custom metadata and assign to any artefact registered in the portal. You can add custom fields to the ‘Assign Metadata’ dialogue box and also select input type from a range of options including taxonomy, date, text and more.

What does this mean for your users? It means that they can now also refine search results by the new metadata you’ve created, making discoverability even easier, and relevant to your business.

And there you have it, V3 is a bumper release, and focused on integration and enhanced audience targeting, security and usability.

configure metadata


More Information

New Customers:

Please contact us at info@perspectiveilm.com.au if you are looking at implementing a new BI Platform and Licensing the Enterprise BI Portal Framework.

Existing Customers:

If you are looking to add Datazen to an existing BI Environment, implementing a new Power BI Tenant, or interested in our Platform Support Agreement please feel free to contact your Account Manager to find out the details, or email us at info@perspectiveilm.com.au

For more information please email us at info@perspectiveilm.com.au.





Datazen – First Impressions

April 14th saw Microsoft announce their latest acquisition – Datazen Software.  Excited with the possibilities this meant for our Enterprise BI Portal, and Microsoft’s BI suite in general I immediately downloaded Datazen and decided to lift the lid.  Here are my findings.

What  Datazen brings to Microsoft

There’s a lot that can be mentioned here, so i’m just going to break it down to the key points I’ve noticed.

Rich authoring experience:

There are multitude of dashboard creation options that dashboard authors can select from and build.  By a simple drag and resize, you can stand up an executive dashboard in minutes, with a good variety of visualisations available.  Snap to grid is nifty, and lets you align KPIs with ease.

Cross device compatible:

Out of the box compatibility with Windows, Android and Apple.  Pretty straight forward and a welcome addition to Microsoft’s BI offering.  As a designer you also have the choice to design dashboards for tablet and / or phone use.


Visually Appealing and interactive:

The front end of Datazen is pretty impressive.  Nice clean design and attractive use of colours.  Dashboards are highly interactive with drill throughs, filters and time sliders.  Touch enabled, immediate insight to key metrics are possible directly from your tablet / phone.


Separation of Roles:

The role of the business user and the developer are clearly separated in Datazen. Developers can author data views via the management interface, handling the complexities of query writing and authentication settings, which allows the business user to focus on building dashboards that best represent what they want to convey to the business via the friendly authoring application.

Speed to setup:

Easy to install, the speed and simplicity in standing up a new environment is assisted with well defined documentation provided by Datazen


Published dashboards are pretty easily integrated to sharepoint via wiki pages with embedded code provided by Datazen

Potential Points of Improvement

  • Unfortunately User Management demands considerable administrative overhead at the moment.  Thankfully this is something Microsoft excel in so bringing their expertise in User Management via Active Directory groups to reduce the overhead of user management will be a welcome improvement.
  • Future security integration with SharePoint to provide a seamless user experience will also be welcome

Technical Requirements

  • Windows Server, IIS (Internet Information Services) and optional integration with Active Directory for User Management
  • Consumption across all mobile devices including Microsoft, Android and Apple
  • In browser consumption requires HTML5 (sorry IE8 users it may be time to upgrade!)
  • Authoring dashboards requires a Windows 8 App which you can download from the store
  • System Management is performed in browser, along with authoring of data views and KPI’s

Licencing Requirements

Current SQL Server Enterprise License Holders with Software Assurance can use Datazen for no additional cost, while those who don’t meet these requirements can licence Datazen through existing sales channels via the Datazen website.

Sourcing Data

Data can be sourced from a number of locations, including;

  • SQL Server Analysis Services
  • SQL Server Database Engine
  • SharePoint Lists
  • Azure
  • ODBC and OLE DB providers such as Oracle
  • OData and XML web services

Datazen and the Enterprise BI Portal

We are busy integrating Datazen into the Enterprise BI Portal Architecture and look forward to providing integrated management capabilities Datazen dashboarding in the next release.  What is also means is Enterprise BI Portal customers will experience the same discoverability functions with Datazen dashboards as they currently do with reports and artefacts on the Portal today.

All in all a wonderful product providing extensive, feature rich visualisations across all devices.  An indication of Microsoft’s ongoing commitment to improve and expand its Business Intelligence capabilities and both on premise and in the cloud.

Perspective Enterprise BI Portal V2 is Released!

Perspective Enterprise BI Portal V2 is here!

We are proud to announce the much anticipated new release of the Perspective Enterprise BI Portal.

The Enterprise BI Portal streamlines the creation and publication of reports across multiple platforms. Built on a central report catalogue enabling unmatched ease of discovery for business users, the portal solution provides business users the ability to create and find dashboards and reports from a single location.

After an overwhelming response in 2014 to V1 Enterprise BI Portal, we have spent the last 6 months in development to include brilliant new features in version 2.

From a brand new report visualisation layout, to tile based data alerts, commentary and more, the Enterprise BI Portal V2 promises to deliver a more interactive, easier to customise and personalise, audience targeted portal solution than before.

V2 introduces the following new features:

New Report list visualisation:

A stunning tile based layout of subject specific reports, V2 provides report type based visual categorisation, allowing you to quickly and easily identify the type of report saved.  From each tile you can open the report, and view all the related information associated to the report in a single click, eliminating the need to use the traditional ellipse.


Report Information Page:

A custom feature that provides a central location from the navigation to view a report, view information about the report and perform actions on the report from one location.


Commentary capture against reports:

Commenting on documents has always been possible, why not on reporting objects? The Enterprise BI Portal provides the ability to create commentary on reports, whilst also allowing other users to ask questions provide feedback on the commentary.


Tile Based Scorecards and Data Alerts:

Data driven tile visualisations means that the Enterprise BI Portal allows you to view data alerts and scorecards directly from the homepage. Know if and when action needs to be taken immediately on key data updates presented in a device friendly tile layout.

User Defined Tiles including Audience Targeting:

Tile based navigation is integral to the useability and success of adoption of the Enterprise BI Portal. Focused on key functions, the tiles allow a “one-click” approach to navigating quickly around the site. Being data driven, the function and appearance of the tiles can be configured by administrators as required, and can also be targeted to specific audiences ensuring the right teams are presented with the right tiles based on permissions.

There we have it, a host of brand new features you asked for, we are excited to offer V2 and look forward to kicking starting your BI initiative in 2015.

For more information go to www.perspectiveilm.com or simply contact us for a demonstration.