Conversations with Data Warehouse Experts – Chris Webb

ByMike Rabinovici Updated on
Chris Webb
Chris Webb

In this episode, I had the pleasure of speaking with Chris Webb, a well respected independent consultant based in the UK.  He specialises in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general.  He is a widely read blogger having authored more than a 1000 posts over the last 10 years.  Chris regularly speaks at leading industry conferences and events including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups.  Listen to the podcast at bit.ly/Dimodelo-ChrisWebb-Podcast

His blog can be found at blog.crossjoin.co.uk.  Find out more about Chris on LinkedIn and follow him on Twitter.

Mike Rabinovici

Similar Posts

What is Dimensional Modeling (introduction)

ByAdam Gilmore

Dimensional modeling is a data modeling technique used to model the presentation layer of a data warehouse. It focuses on delivering simplicity and query performance for the end user. It allows users to easily understand and navigate the data available for reporting and ad hoc analysis. A dimensional model supports high-performance aggregated queries and performs…

|

Persistent Staging Case Study – Payroll Fact in Human Resources Data Warehouse

ByAdam Gilmore

This post is the first in a series of detailed cases studies discussing the ETL strategies that can be used when a Persistent staging layer is included in your Data Warehouse. It’s intended as a reference for developers using Dimodelo Data Warehouse Studio, our Data Warehouse Automation tool to quickly build a Data Warehouse. It’s…

How to prioritize Data Warehouse development

ByAdam Gilmore

Attempting to deliver your Data Warehouse in a single iteration, “waterfall” style, would be very difficult. Today’s agile development process demands that the tasks be broken down into smaller iterative phases that incrementally deliver value. This means you need to prioritize your Data Warehouse development. In the case of a Data Warehouse, the business value…

Dimension Tables – An Introduction

ByAdam Gilmore

A Dimension table is one of the 3 key elements of dimensional modelling used to build a Data Warehouse. This article will give you an in-depth understanding of various Dimension table concepts. What is a Dimension Table? Conceptually, Dimension tables are database tables modelled to represent the business entities involved in business processes and events….

Data Warehouse/Business Intelligence Requirements – How To ?

ByAdam Gilmore

How do you gather requirements for a Data Warehouse/Business Intelligence project ? Typically, on a BI project, if you ask a business user, ‘what do you want’ you will get one of 2 responses. I don’t know. I want everything. Which are, effectively, the same thing… As much as it pains IT people to hear…

Modeling Many to Many Relationships in a Star Schema

ByAdam Gilmore

Many to Many relationships are defined in a Star Schema Dimensional model using a “Group” Dimension and a “Bridge” Fact. Take the example below: In the above example, an insurance company receives medical claims. The medical claims are the business event represented by the Fact table. Each medical claim can have more than one associated…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.