Skip to content

How to Setup VSCode for Python and GitHub Integration

For those DBAs are using SQL for data discovery, the move to data science can involve a brand-new set of varied tools and technologies. This article is a walkthrough of setting up the tooling to do some data discovery using Python. By setting up your workflow using, GitHub, VSCode and Python you will have the basic architecture set up for Data Exploration.

Read more

How to Set up Free Microsoft Office Online for Data Analysis

This first article in the Introduction to Data Analysis series will walk you through setting up Microsoft's free Office Online and introduce you to using Excel Online with OneDrive.

Read more

Productionalize, Productionize, or Productionise?

You are writing and come across a word that just does not look right. This article covers one of my pet peeves, "Productionalization". As I looked at various sources, I realized that perhaps I have to open my mind to the new english.

Read more

How to use Azure Automation PowerShell Runbooks to Create BI PaaS Architectures

This post covers the automation and creation of an; Azure Resource Group, Blob storage, Azure SQL Server and an Azure Analysis Services in a PaaS offering using Azure Automation PowerShell Runbooks.

Read more

How to keep Your Microsoft Azure Automation Runbook Modules Up-to-Date

This article will review a major trap you can find yourself in when using PowerShell in your Runbooks as Azure Automation does not keep your referenced modules up to date.

Read more

Using Azure Data Lake with Power BI

Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.

Read more

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table.  A working Live Interactive Power BI Sample is attached at the bottom of this post.

Read more

SSDT for Visual Studio 2017 – Fixing the Install Error

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.

Read more

How to use Azure Data Factory V2 Sliding Windows for SQL Exports to Azure Data Lake

This article reviews the process of using Azure Data Factory V2 sliding windows triggers to archive fact data from SQL Azure DB. This process will automatically export records to Azure Data Lake into CSV files over a recurring period, providing a historical archive which will be available to various routines such as Azure Machine Learning, U-SQL Data Lake Analytics or other big data style workloads.

Read more

How to use Data Driven Settings to Control Power BI Reports

It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.

Read more