Category: SQL

Getting active with Active Directory

Posted by Ross Waterston | Jul 11, 2017 | PowerBI, SQL | 0 |

Getting active with Active Directory

by Ross Waterston | Jul 11, 2017 | PowerBI, SQL | 0 |

SO reality hit yesterday, we needed to import the data from all a client’s Active...

Read More

My Ultimate Date Dimension! at least until I figure out a better one!

by Ross Waterston | Jul 4, 2017 | Direct Query, Power Query, PowerBI, SQL | 0 |

As you progress in Power BI (and Power Pivot), you quickly find you need a date dimension, the...

Read More

A plan forms

by Ross Waterston | Sep 6, 2016 | PowerBI, SQL | 0 |

Like many companies the company I work for has concerns about the cloud, like most we’re...

Read More

Too many Dates?

by Ross Waterston | Mar 10, 2016 | PowerBI, SQL | 0 |

Real world item often have more than one critical date, Orders will have an Ordered Date,...

Read More