If you work with large text input files in your BI process, a good CSV/Text editor is a must have addition in your toolkit. CSVed comes to the rescue.
As you start using Mac OS X for your Microsoft Azure Data development, VSCode may be just one of the many development packages that you want to set up but is one of the most important. With the setup, having the ability to use Github as a code repository will definitely make life easier as many Azure repositories and services utilize Github.
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.
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.
I was working with a client the other day who was using the Microsoft Azure Storage Explore. They were trying to create a folder in an Azure blob storage location and could not find the option to do it. We seemed to be talking about 2 different products. Funny enough we were. When you do…
Update: This issue has been corrected with the August 2017 update release. One of the must-have features I have been desperate to see in PowerBI is the ability to have word wrap in tables. The June 2017 Update, released on July 3, has updated Table and Matrix visualizations which include a number of new features….