Business Intelligence Data Quality from First Principles Why data quality is an ongoing, people, process, and tools problem, and how to think about getting better at it.
Business Intelligence The Three Types of Fact Tables A concise tour of one of the basic components of Kimball dimensional data modeling. We explore the three types of fact tables, and then analyze why they have lasted the test of time.
Business Intelligence The Data Modeling Layer The data modeling layer describes a distinct category of data analytics tools that exists in the market today.
Business Intelligence Slowly Changing Dimensions (SCDs) In The Age of The Cloud Data Warehouse What a new approach to slowly changing dimensions tell us about the future of dimensional data modeling.
Business Intelligence When Doing Digital Transformation, Think Capabilities, Not Maturity Why maturity models can be a bad idea, and why using a capability model is a better idea for digital transformation.
Business Intelligence How to Measure Software Development, from ‘Accelerate: The Science of Lean Software and DevOps’ Tracking the performance of your software development team is really, really difficult. The 2018 book Accelerate: The Science of Lean Software and DevOps gives us a fantastic way to measure just that. Here's how.
Business Intelligence Why Measuring Cash Flow is More Important Than Measuring Profitability Why your CEO is so obsessed with cash flow metrics, and what you can do to help as an analytics person in your company.
Business Intelligence Metabase Limitations and Top 4 Alternatives (BI) Metabase is a good open-source BI tool but when your needs grow, you will quickly face problems with it. In this post we'll detail the problems and share some alternatives
Business Intelligence The Two Philosophies of Cost in Data Analytics There appears to be two philosophies today when it comes to managing costs in a modern data stack. We explore what they are.
Business Intelligence Developing an Intuitive Understanding of the SaaS Quick Ratio An explanation of the SaaS Quick Ratio that focuses on the intuition behind the metric. Written with the data analyst in mind.
