Séries de web-émissions: Top 5 solutions de données Microsoft

    Réécoutez les 5 émissions!   Les technologies de plateforme de données sont en constante évolution. Pour vous aider à apprendre les nouveautés, Microsoft Canada a organisé une série de webémissions à ce sujet. Réécoutez les enregistrement pour en apprendre plus au sujet de la nouvelle génération de solutions de données Microsoft : Power BI, le…

1

Webcast Series: Top 5 Microsoft Data Platform Solutions

  You are invited. Data Platform Technologies are constantly evolving. To help you keep up to date Microsoft Canada introduces a Data Platform webcast series.   Please join us to learn about new generation of Microsoft Data Platform solutions: Power BI‚ Analytical Platform System appliance, In-Memory technologies, Azure Cloud Data Services and SQL Server 2014….

2

Custom Map with Power Map for Excel

Scenario Since the September 2014 update to Power Map, it is possible to visualize data in Excel on top of any map (e.g. picture) right from Power Map. How does it work? In this post I’m using the STM’s map, Montreal’s subway system. I’ll overlay this map with randomly generated data points that could represent…

2

MVP Series: Overlooked Features of SQL 2014

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. Please feel free to leave…

0

Canadian County and Postal Code Shading in Power Map for Excel

Good news for Canadian users of Power Map. I discovered by playing with a dataset that it’s now possible to shade polygons in maps at both county and postal code levels! To my knowledge his was not previously possible as only Country and Province shading was available. I was surprised it worked when I mistakenly…

7

How to Analyze your Facebook Data with Power BI

Update 2015-07-30: Facebook changed their API a few months ago. It is now only possible to connect with Power Query to pages you own.  Power Query must be approved by the page owner, and once completed, the steps below can be followed. Update 2015-11-08: The diagram of the Microsoft BI platform has been updated following…

0

Facebook Data Analytics with Power BI

Can you analyze social network data in Excel? The answer might surprise you, but yes! The key is Power Query’s Facebook connector! Scenario Now let’s consider an actual scenario! Let’s do the analysis of Microsoft Canada’s Facebook page. The file is available for download below. First let’s look at the post trend Power View sheet….

1

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

MVP Series: This is the Data You’re Looking For

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. …

3