Great CSV Editor Tool For Your ETL Toolkit
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.
Setup VSCode and GitHub Integration on macOS
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.
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.
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.
Getting the Latest Azure Storage Explorer Version
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…
PowerBI June Update & Table Export Issue
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….