Data Lineage relates to the visibility of where data has originated from and what may have been done to that data to transform it on its journey from an original source to a final destination.

Our in-house team of full-time consultants are all based in the UK, with our offices and training centre based in Wokingham, just outside Reading. The vast majority of our delivery work takes place remotely, taking full advantage of cloud based technologies to provide the most flexible service possible. We do also love to get out and meet people in person though, and are very happy to join you onsite at your own premises as requirements suit.

Our in-house team of full-time consultants are all based in the UK, with our offices and training centre based in Wokingham, just outside Reading. The vast majority of our delivery work takes place remotely, taking full advantage of cloud based technologies to provide the most flexible service possible. We do also love to get out and meet people in person though, and are very happy to join you onsite at your own premises as requirements suit.

Wherever works for you! We can come to a venue of your choice, or we'd love to welcome you to our training centre in Wokingham, just outside Reading. Alternatively, all of our courses can be delivered remotely via Teams, Zoom, etc. and make use of our virtual classroom environment. Talk to our team to discuss what would be the best delivery option for you.

Wherever works for you! We can come to a venue of your choice, or we'd love to welcome you to our training centre in Wokingham, just outside Reading. Alternatively, all of our courses can be delivered remotely via Teams, Zoom, etc. and make use of our virtual classroom environment. Talk to our team to discuss what would be the best delivery option for you.

Typically, our closed courses are suited for groups of up to 8. If you have larger groups than this, please give us a call to discuss your requirements and the best options for you.

Joining instructions are typically sent out to each course attendee 2 weeks prior to the course start date, or immediately if booking within this time.

Our virtual classroom provides delegates with access to a browser based virtual lab environment through which our instructors can interact with and provide support for all course participants. The classroom also provides access to guided learning materials, shared whiteboards, and code snippets that may be worked on throughout the class, and students are able to take away their work files from the course for further study after the course ends.

Our virtual classroom provides delegates with access to a browser based virtual lab environment through which our instructors can interact with and provide support for all course participants. The classroom also provides access to guided learning materials, shared whiteboards, and code snippets that may be worked on throughout the class, and students are able to take away their work files from the course for further study after the course ends.

Data Strategy Platform Solutions - Data Integration and One Truth Repository

Use case – Data Integration and One Truth Repository

Our client currently produces reports in tools such as Excel and PowerPoint for many reporting requirements, pulling data manually from data sources such as Financial, CRM and Audit systems. This is labour intensive, time consuming and error prone, as well as resulting in visualisations that are not engaging and effective.

The objective for this solution was to architect a new business intelligence platform to streamline the process for collecting and preparing this data, centralising the storage of the data, improving the development and deployment life cycle of reports, and to produce rich, visually compelling and interactive reports that can be embedded within bespoke applications.

Business Requirement

Provide a central, accurate repository and model of data to act as a single authoritative, consistent and reliable source
Improve development and deployment times for reports and dashboards
Provide richer, more compelling and interactive reports
Consolidate storage and delivery of reports to achieve greater consistency
Make access to reports and dashboards simple and fast
Embed dashboards and reports within bespoke applications and web services

The PTR Solution

The solution implemented was built around Microsoft Azure SQL Database, Azure Analysis Services, Azure AD, Azure Data Factory, Azure Data Lake and Power BI.

Azure SQL Database to host a newly designed Data Warehouse
Azure Analysis services to host a Tabular Model
Azure AD to service User Authentication & Authorisation to Power BI, Azure SQL Database and Azure Analysis Services
Azure Data Lake Storage Gen 2 to provide a single repository for source data
Azure Data Factory to facilitate ELT pipelines to extract data from the Data Lake, load data into Staging tables in the Data Warehouse, transform data by manipulating it into a desired tabular structure for consumption
Power BI for a Self-Service Business Intelligence tool set

The Benefits

Newly designed Data Warehouse fit for purpose
Central Tabular Model providing unique and complex business calculations, measures and KPIs, and a single authoritative source of truth
Single sign on across the whole Data Platform enabling highly granular User Access Control to reports, source data and administrative functionality
Single repository for source data in its native format
Pipelines and dataflows tailored to meet real-time operational reporting requirements, and extensible for future enhancements such as direct source load to data warehouse, or direct source load to Power BI for live reporting
Delivery of rich, engaging visualisations empowering users with insight, interactive analysis and the ability to answer their own questions swiftly using a trustworthy, consistent single truth Tabular Model

Data Strategy Platform Solutions - Data Integration and One Truth Repository Consultancy Services