Skip to content

Posts from the ‘Uncategorized’ Category

5 Steps to Improve Your Excel Data Visualization Productivity

You can improve your data visualizations productivity by using the built-in table functionality available in Excel. This tutorial and sample Excel workbook, available on GitHub, will move you from raw table to interactive analysis in less than 5 minutes.

Read more

Create HTML Documentation for Your Data Discovery

There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.

Read more

33 Free Data Sources

Forbes Tech has just released a list of 33 free data sources that you can use for your next proof of concept or demo.  The list is a wide and varied source of Canadian, US and European open data initiatives.

Bernard Marr has written the article which is available on the Forbes website: Big Data: 33 Brilliant And Free Data Sources For 2016.

A short post, but a great resource.

 

DAX Studio Released

I must admit, it is always great to find a new tool that you can fit into your BI workflow and DAX Studio which helps you edit DAX queries is one of those tools. I was pleasantly surprised at the full functionality and deep feature set of this tool on CodePlex.

Read more

New Updates to Capacity Planning for SQL and SharePoint 2013

If you are using SharePoint 2013 this resource provides guidance on determining your capacity plan for SQL.

Read more

%d bloggers like this: