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
  • Join Microsoft at Big Data Summit Toronto – Feb 17th & 18th

    If you want to learn more about real world examples of big data implementations driving massive business value, this upcoming conference will definitely be of interest. There are some great sessions lined up, including speakers from Rogers, Bank of Montreal...
  • Architecture for Data Exploration using Microsoft Azure

    I have decided to write this blog post as quite a few of my clients are asking me how best to enable a data culture inside their organizations. Satya Nadella says: “this is where I think we as leaders of our businesses get to do the most transformative...
  • Microsoft Data Platform events in Canada: SQL Server, Power BI, Cortana Analytics and IoT

    Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT solutions? Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions...
  • Power Query Use Case: Contact Management

    Happy new year everyone! Of all the components of Power BI, Power Query was by far the one I was originally most skeptical about. How can an end-user be responsible for creating their own ETL when this process is usually so complex? After I started...
  • SQL Server 2005 Upgrade – Learn from SQL Server experts

    Do you still have SQL Server 2005 databases in your IT environment? Learn from SQL Server experts ( Microsoft MVPs ) why you should upgrade, options you have and what you should consider when upgrading to SQL Server 2014. SQL Server 2005? It’s The Final...
  • Data Platform University for Partners

    If you missed Data Platform University webcast series for partners we ran in October and November 2015, now you can watch them on-demand: Title On-Demand Recording Link Microsoft’s Data Platform - The Opportunity is Bigger Than You Think https://msevents...
  • SQL Server News from PASS 2015

    SQL Server News from PASS 2015 Hi! Last week was PASS Summit in Seattle. Here’s a short summary of announcements: CTP 3 of SQL Server 2016 is now available The roadmap for Microsoft BI visualization tools has been revealed...
  • IT CAMP: Time to upgrade to SQL Server 2014

    You are invited! On April 12‚ 2016 Extended Support for SQL Server 2005 is coming to an end. After this date Microsoft will no longer provide assisted support‚ security updates or hotfixes for SQL Server 2005. Now is the time to upgrade to SQL Server...
  • Data Analytics Camps: from Excel to Power BI

    You are invited! As an advanced user, we want you to benefit from all of the capabilities available within Excel and Microsoft BI tools. Did you know that Excel has advanced data visualization capabilities such as Power View and Power BI? These tools...
  • Microsoft Data Platform at Microsoft Cloud Roadshow in Toronto

    Bringing the best of IGNITE and BUILD conferences to Toronto. We want to invite you to attend the Microsoft Data Platform sessions at Microsoft Cloud Roadshow on November 9-10, 2015 taking place at the Toronto Congress Centre. Register now for this 2...
  • Microsoft Data Platform events in Canada: SQL Server, Power BI, Advanced Analytics and IoT

    Want to get familiar with the new Power BI, SQL Server 2014, Cortana Analytics or IoT solutions? Join Microsoft Canada, our partners and the SQL PASS community for an across Canada in-person and online event series that will introduce you to these solutions...
  • Microsoft Data Platform Days in Canada

    You are invited! The rise of machine learning and advanced analytics‚ combined with cloud unlimited capacity for data storage & computation marks a unique point in history. This is an incredible opportunity for organizations to innovate with agility...
  • SQL Server 2005 End of Support (EOS) Resources

    On April 12‚ 2016 Extended Support for SQL Server 2005 is coming to an end. After this date Microsoft will no longer provide assisted support‚ security updates or hotfixes for SQL Server 2005. Now is the time to upgrade to SQL Server 2014 or Azure SQL...
  • 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...
  • Big Data Hackathon in Vancouver – 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 (Vancouver, April 18-19, 2015). _____________________ As upper level students finishing their Computer Science degrees, we felt that...
  • Datazen vs. Power BI: When and Why?

    Update: Following the announcement of the reporting roadmap for SQL Server and Power BI at PASS 2015, I’ve written a follow up to this blog post. The information below is still valid and has been updated, but for a forward looking analysis of the...
  • 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...
  • 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...