Installing and Configuring SQL Server R Services
Reading Time: 3 minutes NOTE: as of April 2016, this article no longer accurately reflects the installation experience with SQL 2016 RC2. How do you get started with R Services in SQL Server 2016? If you are like most people,…
Read More
Power BI — 3 Data Preparation Tips to Enhance your Word Cloud
Reading Time: 6 minutes The Microsoft Power BI team recently unveiled a new Word Cloud custom visual for the Gallery. Read the formal announcement and see the short video by Amir Netz. As Amir mentions, word clouds can be used to…
Read MoreGeocoding in a Pinch: Power Query and the Google Maps API
Reading Time: 4 minutes A colleague of mine recently asked if I knew of an easy way to get latitude and longitude coordinates from city and state information. Of course I do! There are plenty of ways, and many of…
Read MoreStep by Step: Using Power Query to Replace Text in Table Headers
Reading Time: 4 minutes Recently, I came across a dataset involving traffic accidents that I really liked and wanted to clean up for a demonstration. As with most datasets originally pulled from the web or from text files, there were…
Read MoreTableau 9 – Data Interpreter Put to the Test
Reading Time: 4 minutes While “data preparation”, “in” and “Tableau” have not been words you often see together, Tableau 9 offers some new options, building on recent data preparation advances in 8.2 with features like the data window and better…
Read More