Skip to content

Posts from the ‘Tutorial’ Category

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.

Read more

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

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

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