By Jeremiah Willett Let’s assume that we have done everything right on our self-service BI journey. We’ve built clean data models and have pristine data…
Transform Your BI Journey with Hierarchies
By Jeremiah Willett In a previous article that I authored, titled Start Your BI Journey with a Data Model, I wrote about the importance of…
Qlik’s Data Profiler: Catching Data Quality Issues Before They Reach the C-Suite
By Jeremiah Willett One of the most critical threats to any BI project is poor data quality. Building beautiful dashboards on top of unverified data…
Designing Business-Aligned Data Foundations for Advanced Analytics
By CIO Review In this article, CIO Review explores how organizations can unlock more value from their data by aligning it with business strategy. Many…
Data Principles: Architecting Business-Driven Data
By Pete Stiglich In this feature, in CIOReview, Data Principles: Architecting Business-Driven Data, the spotlight is on how organizations can build stronger, more effective data…
Enabling High Quality Analytics through a Data Validity Dimension
By Pete Stiglich Explains a practical dimensional-modeling pattern for handling imperfect source data without destroying analytical trust. Instead of rejecting records with invalid dates or…
Performance Benefits of Surrogate Keys in Dimensional Models
By Pete Stiglich Explains why dimensional warehouses typically use surrogate keys in dimensions instead of relying on natural keys from source systems. Small numeric surrogate…
The Holy Grail of Analytics?
By Pete Stiglich The end goal of analytics is to be able to make data-driven decisions — sooner rather than later. Of course, it is…
Empowering Data-Driven Decisions through Effective BI Training
By Jeremiah Willett Data Principles is a proud partner of Qlik, a leading analytics, data integration, and AI company. Qlik Sense Cloud is designed for self-service…
The Power of Dimension Placeholder Records
By Pete Stiglich In a dimensional model, how do you handle missing or invalid values in a fact table source record that are used to…