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.
Our ability to keep up with the volume of new cloud-based products and services is becoming more difficult. To survive in this environment, we need to adopt various learning techniques and Guided Technical Enablement is an example of Agile Learning and uses Learning Plan is one of them.
This learning Path covers Azure Synapse Analytics This service is not only the next evolution of Azure SQL Data Warehouse, but combines enterprise data warehousing and Big Data Analytics into collaborative projects to ingest, prepare, manage and serve data together in a single pane of glass experience.
There is an odd error when trying to install SQL Server Data Tools (SSDT), either as a stand-alone, or adding to an instance of Visual Studio 2017. I had the same setup failure, no matter what configuration I was using. The following steps worked for me, and may for your situation.
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.
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:... Continue Reading →
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.