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 Data Governor 4.6 is Released!

‘Loving the new features in v4.6! Great stuff guys.’- Ben Oastler, St Vincent’s Hospital, Melbourne.

Thanks to your feedback, Data Governor has been refreshed and we’re pleased to share the latest features in v4.6.

Key enhancements in v4.6 include:

Support for SQL Server 2016

Data Governor now supports SQL Server 2016. It can be installed in a SQL Server 2016 environment and can also manage and govern SQL Server 2016 objects and services.


Simpler Reconciliation

Simplified reconciliation reporting visualisation now displays source and targets as records (rows) with errors highlights side by side. This allows the user to quickly and easily identify reconciliation issues at a glance.


Enhanced User Experience

V4.6 includes a number of enhancements that improve the overall usability of the product. These include:

  1. Ability to clone tasks
  2. Search functionality to locate tables quickly
  3. Ability to change the status of a job directly from the job list instead of clicking through to each job to change
  4. A drag and drop capability to reorder reconciliation steps as required.

Want to try v4.6 of Data Governor for yourself?

Click here to try it now.

Existing Customers can access the full release notes, updated user guide and installers on the Yammer Support Site.

To arrange access, email

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.


Perspective Data Governor 4.0 is Released!

2015 is proving to be the year of major releases, and Data Governor 4.0 is no exception. An exciting new release that introduces automated deployment through development, test and production environments. The new features include:

Automated deployment for Jobs and Processes

Data Governor facilitates the deployment of Jobs and Processes through the development lifecycle, between Development, Test and Production Environments. It ensures environments are easily kept consistent and dramatically simplifies the effort involved in migrating through the environments.

Addition of Operating System Command process type

Data Governor can now execute and manage Operating System Commands allowing processing functionality beyond the data manipulation and transformation of SSIS packages and stored procedures.  Data Governor can now execute batch files that may manipulate files, execute external application processes, run PowerShell commands, and more.

Addition of XMLA process type

Processing SSAS cubes is now supported in Data Governor.  Both Tabular and MDX cubes are supported and allows the processing of cubes to be executed, managed and logged by Data Governor.  To process a cube (Tabular or MDX) simply add a Process (of type XMLA), define a connection as an XMLA connection to the Job and the cube will be processed.

Data Migration import and export to flat files

Import/Export to Flat File has now been improved and does not require the ACE driver (Microsoft Office – Access) to be installed.  Multi character delimiters can now be defined to allow import/export of verbose text columns (where single delimiters may be found within the text). There is also a swag of enhancements ranging from IE11 compatibility, additional logging information, enhanced usability and more.  Make sure you check out the website for more details, and download a fact sheet  to see how Data Governor help your BI initiatives.

Data Governor v3.5 has been released

Data Governor 3.5 is an exciting new release that has introduced seamless integration with SharePoint, MDS, direct input of SQL Command Execution and Role Based Security.  These new features include:

  •  The ability to import and export data directly to and from SharePoint lists and / or Master Data Services removing the need to export data to  disparate intermediate repositories, prior to processing.
  • SQL Command Execution, allows you to enter SQL statements directly into Data Governor as a executable process.  This development has now removed the reliance on SSIS / Stored procedures for simple SQL Commands.
  • The introduction of Role Based Security  means that business users can be given role specific, limited access to run specific jobs independent of IT.
  • Stay tuned for Version 4.0 which will include the automated capability to migrate your processes from development to production removing the need to manually re-create processes for each environment.

Leveraging the SQL Server platform, Perspective enables faster time to value for Business Intelligence projects.   Perspective also provides the governance and stewardship you need ensuring the information you use to make critical decisions is timely and reliable.

Come and check out the new website to learn more about our solutions or Contact Us  to arrange a demonstration.

Microsoft SQL Server 2014 released – What does it mean for BI?

Microsoft SQL Server 2014 was released for General Availability on April the 1st and brought with it a host of new features including integration with Azure, in-memory OLTP, security enhancements and improvements to AlwaysOn. (you can go here for more details)

The most compelling change for Business Intelligence workloads from SQL Server 2012 is the introduction of Updatable Columnstore indexes.

Columnstore indexes introduced in SQL Server 2012 increased throughput and improved common data warehouse query execution times significantly.    However, the read-only nature of the indexes proved to be a limitation.  This meant they had to be dropped and recreated when updating the underlying table causing additional processing overhead which proved difficult to accommodate near real-time BI.  Another drawback encountered was the extra space the columnstore index required as the indexes had to be stored in addition to the existing row-based tables as they were built on top of the unpinning tables.

In comes SQL Server 2014 with its updateable Columnstore indexes.  This development will change the way in which traditional SQL Server data warehouses have been implemented.  Immediate improvements include:

  • Columnstore indexes are created without reliance on row based storage which reduces space and processing requirements
  • As they are now updateable, there is no need to drop indexes and rebuild hence supporting near real-time data provisioning

In short, this is a key improvement to SQL Server 2012, which will change the way in which we think about data warehousing in the future.

You can download the Evaluation for SQL Server 2014:

On Premise




SQL Server 2012 released

​It’s out, and its delivering more reliable data, faster than ever before!

We at BizData like how SQL Server 2012 is making the business of delivering business intelligence much faster, whilst providing a strong data governance foundation.

N.B. The editions have changed, so make sure you have software assurance in place before April 1st!
Contact your licensing partner or get in contact with us to find out more.

A snapshot of what’s new:

Data Quality Services – a whole new suite that will allow you to manage a knowledge base of data cleansing rules, as well as connect to third party data cleansing services through Windows Azure

Master Data Services – an improved set of features to manage a reference data hub and provide platform for data stewardship. Including performance improvements (we’ve looked under the hood to make sure), and a new ad-in for excel which is available for download.

Column Store Index – the ability to create indexes on an existing data warehouse to improve query performance by 10 – 100 times.

In-Memory, Compressed, Column-based Storage – quite simply: instant retrieval and aggregation of data for large data sets. The underlying technology that will provide a user experience of “train-of-thought” data analysis.

Tabular Projects – a design environment that makes building a semantic model for reporting and analysis easier and accessible to a wider audience.
This will appeal to advanced analytics/data mining practitioners as a much faster data preparation workbench alternative.

Power View – self-service, ad-hoc data discovery and visualisation that anyone can drive. And yes, it can be interactive in a PowerPoint slide deck using live data. Expect a lot more mouse clicking in executive leadership meetings!

PowerPivot – available for download now, a new version of the desktop data mashup environment for Excel. Ideal for quick analytical and reporting prototypes by power users.

Also Microsoft continues with its compelling alternative to expensive data warehouse appliance renewals.

Fast Track for SQL Server 2012 – a reference architecture that will reduce the costs of performance tuning and deliver massive throughput for your data warehouse queries for up to about 20Tb.

SQL Server Parallel Data Warehouse Appliance Update 3 (AU3) – The Tier 1 large scale data warehouse appliance provides scalability to 100’s of terabytes at a fraction of the cost of the usual suspects, which is expected to deliver 10x performance improvements with this release.