Wise Owl blogs written in 2016 (page 3 of 3)

Showing blogs 41-52 (out of 52)

How to create a calendar in SSAS Tabular to summarise by dates

Posted by Andy Brown on 21 January 2016

Analysis Services has lots of wonderful DAX functions like TOTALYTD and SAMEPERIODLASTYEAR which allow you to summarise your results by date, but to get them to work you'll need to create and use a calendar table first. This blog explains how, and why.

How to use the EARLIER function in DAX to sort, group, band and accumulate data

Posted by Andy Brown on 13 January 2016

Although the EARLIER function in DAX is complicated, it's also very useful! This blog shows how the function works, and how to use it to create running totals, sort rows, create group statistics and divide data into bands.

How to use the RANKX function in DAX measures to sort data

Posted by Andy Brown on 12 January 2016

The RANKX function is one way (probably the best one) to sort data. It's not the world's easiest function to understand, but this blog explains the pitfalls.

How to use the FILTER function in DAX to filter tables

Posted by Andy Brown on 12 January 2016

Although the CALCULATE function is by more useful (and often easier to understand), DAX programmers should also learn about the FILTER function. This provides another way to change the query context for any aggregation.

How to use the CALCULATE function in DAX measure formulae

Posted by Andy Brown on 12 January 2016

The CALCULATE function is the most important one in DAX. This blog shows you how to use it to replace, remove and amend the query context for a measure (and also explains what this sentence means!).

Using DAX Studio or DAX Editor as add-ins to create measures in SSAS Tabular

Posted by Andy Brown on 11 January 2016

The built-in DAX formula editor in SSAS Tabular leaves a lot to be desired. This blog shows how to install and use two of the most useful third-party add-ins: DAX Editor and DAX Studio.

A must-read DAX primer on how to create measures (including query context)

Posted by Andy Brown on 11 January 2016

To create formulae in SSAS Tabular you need to learn DAX, the language used for creating measures. This blog shows the basic syntax of DAX, and explains how SSAS Tabular uses query context in a pivot table to aggregate data correctly.

How to create dynamic connection strings in Integration Services packages

Posted by Andy Brown on 08 January 2016

It's often useful to make connections point to different Excel workbooks or SQL Server databases, depending on the value you set for variables or parameters. This blog shows the underlying principle - it's up to you then to apply this in your workplace!

Tags:   SSIS | Data flow    |    SSIS | General SSIS

How to run SSIS packages in 32-bit mode to avoid Excel and Access errors

Posted by Andy Brown on 08 January 2016

If you're using SSIS to import from or export to Excel workbooks or Access tables - as you surely will be - you'll need to run your packages in 32-bit mode. This blog explains why and how to do this.

Tags:   SSIS | Deployment    |    SSIS | General SSIS

Using the RELATED function to link tables, and how to test for blanks in DAX

Posted by Andy Brown on 05 January 2016

You can make pivot tables much easier to use by combining all of the aggregator columns into a single table, using the RELATED function. This blog also shows you how to work with blanks, including using the ISBLANK function to test whether matching values exist in linked tables.

Learn how to create calculated columns in a tabular model using DAX

Posted by Andy Brown on 05 January 2016

Creating calculated columns in tabular models is deceptively similar to creating formulae in Excel. Deceptively, because the underlying language (DAX) is completely different, and you can make use of functions like SWITCH which have no Excel equivalent. This blog shows what calculated columns are, and how to create them.

A tutorial showing how to import data from Excel, Access and many other sources

Posted by Andy Brown on 04 January 2016

You can import data into tabular models from virtually any data source, as shown by this tutorial.

This page has 0 threads Add post