Viewing 15 posts - 1 through 15 (of 98 total)
Hi,The articles are not published yet - I presume that the links will start working as each article appears on SSC.Regards,Adam
June 30, 2018 at 8:42 am
Thanks for the comment and I am glad that this was useful.
160 M records - wow!
All the best,
October 6, 2016 at 4:56 am
Thanks Alan - much appreciated!
June 6, 2016 at 10:01 am
You are right that it is not instantaneous - but with the May 2016 update to Power BI Desktop you can now create Power BI templates - and so carry...
June 6, 2016 at 9:06 am
I chose DAX here simply because Power Query solutions have been discussed elsewhere so well. I use either, depending on the scenario.
June 6, 2016 at 9:04 am
There are many ways of adding time intelligence to Power BI dashboards - this is only one among many - in fact I describe how to create Excel-based tables...
June 6, 2016 at 8:43 am
I once had a Triumph TR4 - what a motor!
The apogee of British engineering, it added real joy to driving. Not to mention the surprise factor if you turned the...
August 30, 2015 at 12:40 pm
Absolutely right - in fact I described this (really cool) tool in the previous article referred to at the start of this one.
August 4, 2015 at 5:22 am
I am used to using modulo as it is nicely deterministic and easy to extend to several parallel processing IDs.
But anything is good if it works!
August 4, 2015 at 1:55 am
You are absolutely right, the source is a bottleneck.
Watch out for an upcoming article where I show some solutions to handle this for both database and file data sources.
August 4, 2015 at 1:53 am
This is a direct load into a database, not a data staging approach - it just loads faster due to parallel loading.
August 4, 2015 at 1:52 am
The balanced data distributor works with all versions of SQL Server from 2008.
Link to 2008 version here:
July 7, 2015 at 7:15 am
Perhaps I need to caveat the concept of "reusable". By this I mean that you do not have to rebuild the date selector for every report.
You will, however, have...
May 21, 2015 at 11:29 am
The code here is to go into the database from where the SSRS report will read the data.
If you download the sample file you can see this in the...
May 21, 2015 at 6:01 am
To combine the two you set the reportingyear and reportingmonth parameters to visible = false in the slicer report described in the previous article.
This has the effect of "replacing"...
May 21, 2015 at 3:22 am