Pages

▼
Showing posts with label powerpivot. Show all posts
Showing posts with label powerpivot. Show all posts
Monday, December 9, 2013

P4.4: Data Modeling in PowerPivot: Relationship JOIN Types

›
Hello Readers, In this post we will continue our discussion (from P4.3 ) on the types of JOINS we can use when creating relationships, esp...
Thursday, November 14, 2013

P4.3: Data Modeling in PowerPivot: SQL Query Denormalization

›
Hello Readers, This post is a continuation from the last post of understanding normalization in data modeling using PowerPivot. As usual, ...
Thursday, November 7, 2013

P4.2: Data Modeling in PowerPivot: Normalization and Denormalization

›
Hi Readers,  Today we will discuss normalization and denormalization of tables in data models. As usual, we will being using the companion ...
Tuesday, November 5, 2013

P4.1: Data Modeling in PowerPivot: Relationships

›
When we wanted to merge two table together, an option would be to use the VLOOK UP function. To analyze the many tables in a data model, VL...
Friday, August 23, 2013

P3.2: Beginning DAX 2

›
And we are back again for more DAX! This post is a continuation in the understanding DAX series (link to P3.1 .) Here we will gain a deeper ...
Saturday, August 17, 2013

P2.2: Creating Calculated Columns and Calculated Fields in PowerPivot

›
This post will explore calculated columns and fields in PowerPivot, using the sample database from the Ferrari PowerPivot  book . We will c...
Friday, August 16, 2013

P2.1: Loading Data from External Sources to PowerPivot

›
This post will describe how to load external data sources to PowerPivot, using examples from Chapter 2 of the Ferrari PowerPivot  book . ...