SQLServerCentral.com Articles tagged Powerpivot

Stairway to PowerPivot and DAX - Level 5: The DAX ISBLANK() Function

Thu, 09 May 2013 06:00:00 UT

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX ISBLANK() function, and then provides some hands-on exposure to its use, particularly in combination with other DAX functions, in managing empty values underlying our PowerPivot model designs.

Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

Mon, 18 Mar 2013 06:00:00 UT

Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

Tue, 26 Feb 2013 07:00:00 UT

Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.

Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions

Fri, 07 Dec 2012 07:00:00 UT

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

Wed, 21 Dec 2011 07:00:00 UT

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.

New PowerPivot Forum

Wed, 16 Nov 2011 07:00:00 UT

We have a new forum setup for your Powerpivot questions. If you are working with Powerpivot, please feel free to ask questions here.

Self-Service vs. Managed BI

Thu, 22 Jul 2010 06:00:00 UT

Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.

Self-Service BI with PowerPivot for Excel 2010

Fri, 22 Jan 2010 07:00:00 UT

Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.

PowerPivot

Mon, 14 Dec 2009 07:00:00 UT

A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.

PowerPivot

Mon, 14 Dec 2009 07:00:00 UT

A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.

PowerPivot

Mon, 14 Dec 2009 07:00:00 UT

A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.

PowerPivot

Mon, 14 Dec 2009 07:00:00 UT

A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.