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…


Formation Microsoft en mode laboratoire sur la plateforme de données

(English version here) Étant donné le succès de notre première série d’ateliers pratiques à Montréal au cours de la première moitié de l’année, nous redoublons nos efforts pour augmenter la capacité de la salle ainsi que la sélection et la profondeur des sujets. Nous croyons fermement que la meilleure façon de mettre en valeur notre technologie…

0

Microsoft Data Platform Hands-on Labs

(Version en français ici) After the success of our first series of hands-on labs in Montreal in the first half of the year, we are expanding our efforts to increase room capacity, topic selection and depth. We firmly believe that placing our technology in your hands is the best way to make it shine. After all, teaching…

0

Real-time streaming dashboard with Power BI

[This article was first published on stephanefrechette.com, and kindly contributed to CanSQL] I was recently asked to provide a simple demo/proof-of-concept on how to quickly create a real-time streaming dashboard with Power BI. Did you know that you can stream data and update dashboards in real-time? Any visual or dashboard that can be created in…


Creating an OAuth 2.0 authentication token for Azure Data Lake Store

Hi All!   A Data Lake can be defined as a storage repository that holds a vast amount of raw data in its native format until it is needed. My question is, what would be the point of storing all this data if you can’t access it easily? Azure Data Lake store, which is Microsoft’s…

0

Data Science VM and Azure Data Lake Store – The hidden feature

Hi All!   I wanted to highlight a hidden feature in the data science VM which allows you to consume data stored in Azure Data Lake Store from Microsoft R Server.   As part of the continued improvements made to the data science VM, towards the end of December 2016, the necessary libraries that allow…


Live Query Statistics in SQL Server 2016

Hi everyone! For this blog post, I thought I would bring attention to “Live Query Statistics” (LQS), one of the many new features and improvements of SQL Server 2016 available from SQL Server Management Studio (SSMS). LQS is an important new feature because it directly addresses a requirement often heard from SQL Server DBAs: “we…


Profisee Workshop for Master Data Management in Montreal

Are you struggling to get the single view of truth from your data? Can you see and use a clean 360 view of customer for your business? Did you know that Profisee offers the only product dedicated to enabling enterprise MDM with Microsoft technology? Microsoft and Profisee invite you to attend a free Master Data…

0