In this blog we will create a simple Power BI report for HR using dynamic measures. As mentioned in previous posts in this series, we are using the Adventure Works sample databases AdventureWorks2017 and AdventureWorksDW2017.

In this tutorial we will query the SQL Server database AdventureWorksDW2017 with python. We will do this by using pyodbc which is an open source Python module that makes accessing ODBC databases very simple.

Hello and welcome to the first in a series of tutorials utilising Microsoft’s Adventure Works database samples. The focus of these tutorials will be on database and analytics concepts and software. In particular, we will look at performing queries and other important tasks with SQL Server Management Studio, interacting with databases with python, creating Power BI reports and many other topics.