In Services by Peter

Business Intelligence Data Analytics Report and Dashboard Design Migrations Data Services Data Acquistion, Transformation Data Integration Data Modelling Data Cleansing Database Database Design-Development Star Schema Inmon/ Vault Database Technology Cloud – Azure Data Analytics Data Architecture Azure Synapse Analytics Data Lake Design -Development On-Premise to Cloud Migration Data Warehousing Data Warehouse Design- Development Azure Synapse Analytics ETL/ELT – SSIS -Azure …

Modern Data Warehouse

In Cloud Technology, Data Architecture, Data Warehousing by PeterLeave a Comment

What is a data warehouse? A data warehouse is a system that aggregates data from different sources into a single, central data store to support analytics, data mining, machine learning and AI. Also known as an enterprise data warehouse (EDW), its functionality allows businesses to run sophisticated analytics on petabytes of data that could not be handled by a traditional …

View Post

What is Microsoft Azure Purview?

In Cloud Technology, Data Governance, MS Azure by PeterLeave a Comment

Microsoft Azure Purview is a fully managed, unified data governance service that helps you manage and govern your on-premises, multi-cloud, and SaaS data. Purview creates a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage.
Purview will enable organizations to have a top view of the data landscape, perform data discovery, data classification and establish end-to-end lineage.

The best Canada technology and IT jobs in 2021

In Canada, Job Market, Tech Skills by PeterLeave a Comment

Canada’s tech industry is a major economic driver and will continue to expand, surpassing many sectors along the way. Since COVID-19, technology has become integrated into every aspect of our lives and economies. As the world moves closer towards a digital economy, technology-based companies have become essential to driving GDP, providing high-paying jobs and innovating a new world through continuous …

Differences between Kimball and Inmon approach

In Business Intelligence by PeterLeave a Comment

Inmon advocates using a central data repository design to hold all the data in a structured normalized manner. Access to the data is typically through data marts, which are a subset of the data warehouse repository in an optimized for use structure. These structures can be third normal form (3NF), star, or snowflake designs. Many IT initiatives begin with a …