Building a dashboard on top of a web API with Power BI and Azure – Part 3

In Part 1 of this series we connected to the driveBC API in Power BI Desktop and built a simple dashboard. In Part 2 we designed the architecture capable of storing the data over time. In Part 3 we are implementing implement the architecture. In the previous article, we defined our architecture as follow: We…


Self-Service BI: Culture, Processes, People

A customer asked me an interesting question: when implementing self-service BI, what roles and workflows should be defined? Stepping back, self-service BI is about reducing the “time to insight.” Traditional BI takes too long to get the data, leaves less time for analyzing, and thus often the business decisions are rushed and even made before…

0

Microsoft Data Platform Overview

Update 2015-11-11: Updated the graphics to include Azure Data Catalog. The variety of offerings in Microsoft's end-to-end analytics platform sometimes feels overwhelming, especially with the rapid evolution. For example, at the Build conference we announced the upcoming availability of Azure SQL DW and Azure Data Lake, while at the Ignite conference we presented the new…

3

MVP Series: 7 Ways to Lose Your DBA Job

We are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week.  We hope you enjoy them, please feel free to leave a comment. Thanks to Karen Lopez for…

14

MVP Series: What is a DBA, anyway?

We are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts around their favourite tips, tricks & features of SQL 2014.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week.  We hope you enjoy them, please feel…

2

MVP Series: Top 5 Interview Questions for a SQL Server DBA

For the next couple months we are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts around their favourite tips, tricks & features of SQL 2014.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week.  We hope you enjoy…

1

MVP Series: Integrate Self-Service BI in your Corporate BI strategy

For the month of October and November we are thrilled to have special guest authors from the Canadian MVP Award Program contributing posts around their favourite tips, tricks & features of SQL 2014.  For the next few weeks, we will be posting a different article from one of our Canadian SQL Server MVPs each week. …

1