A Story of BI, BIG Data and SQL Server in Canada

We focus on BI, Big Data and SQL Server, providing the latest news from Microsoft and the industry, sharing upcoming events, customer stories and SQL Server product information. Find out why SQL and not Oracle or SAP.

A Story of BI, BIG Data and SQL Server in Canada

Posts
  • Datazen vs. Power BI: When and Why?

    Following up on my last post that provides an overview of Microsoft’s platform for analytics , let’s now focus on the visualization tools. Since the Datazen acquisition, I’m often asked how Power BI and Datazen compare: which tool should...
  • Microsoft Data Platform Overview

    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...
  • Microsoft Big Data Hackathon Resources (Vancouver)

    Category Data Set Demographics Local census profile http://namara.io/#/display/9ebda3ec-ea3f-4caf-bbac-95274f4317c8 Transportation EV locations: http://namara.io/#/display/7aee7c3c-009b-46e4-8b1d-797aa58d19ec Parking meter data: http://namara.io/#/display...
  • Big Data Hackathon – a Story from a Winning Team

    This blog post was created collaboratively by the winning team of the Big Data Hackathon in Data Visualization category (Microsoft Canada office, Mississauga ON, March 13-14, 2015). Big Data Hackathon Team members : Kosta Zabashta , Ontario Teachers'...
  • Microsoft Big Data Hackathon Resources

    Data sets ThinkData Works Data sets: http://namara.io/#/ The site consolidates data from open.data.ca, Statistics Canada, Provincial Data sources, GoodLife Fitness, SpotCrime and others. Here are the links to a few datasets of interest: Category Details...
  • Predictive Analytics Customer workshop in Montreal

    YOU ARE INVITED TO ATTEND: Predictive Analytics Customer Workshop Join us for an exciting, two-day learning event on predictive analytics using Microsoft Azure. WHO SHOULD ATTEND Data Scientists, Developers & Programmers, Architects, and Analysts...
  • Predictive Analytics Customer Workshop in Vancouver

    PLEASE FIND THE EVENT RESOURCES HERE (Password: Azure) Join us for an exciting, one-day learning event on predictive analytics using Microsoft Azure. WHO SHOULD ATTEND Data Scientists, Developers & Programmers, Architects, and Analysts WHY SHOULD...
  • Big Data Hackathon in Vancouver

    The event is over. Please find the event presentations and resources here . Prize winners: - Data Modelling: Vancouver Crime Analysis by team Droptable UBC - Data Visualization: Reflex Math Analytics by team Synergy You’re invited! The Microsoft Big Data...
  • BIG Data Hackathon in Mississauga

    The event is over! Congratulations to the winners! Data Modelling Prize winner: Ontario Parking Ticket Revenue Forecaster project Data Visualization Prize winner : Parking Tickets and Air Flights project Please find the event resources here . __________________________________________...
  • 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...
  • MVP Series: Promoting an Excel Tabular Model to SSAS

    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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • How to Analyze your Facebook Data with Power BI

    You’ve seen with my last post the types of analytics easily possible with Excel. Now let’s show you how you can make a similar analysis of any Facebook page you like. Step 0: Getting the tools ready For this to work, you need Excel 2013...
  • 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...
  • 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...
  • 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...
  • 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...
  • Microsoft Tools to Tackle Ebola, Updated Ebola Analytics File

    Microsoft Tools My earlier article highlighting how Power BI can be used to analyze WHO ebola data generated a lot of interest. To follow-up on this topic, I’m writing today about the announcement made by Microsoft CEO Satya Nadella regarding...
  • MVP Series: Business Intelligence Grows Up

    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...
  • Webémissions de Microsoft Canada: Power BI, Analyse prédictive et "SQL Server as a Service"

    Vous êtes invité. Vous avez été nombreux à assister aux divers événements de formation virtuelle que nous avons publiés. Dans la foulée de ce succès, Microsoft Canada organise une série de webémissions portant sur la plateforme de données Microsoft. Ces...