Free Seminar – Feb 21, 2019 – Calgary: Enable Data-Driven Decisions with (Microsoft Power BI)-the Jr. Oil Co. Case

Fuzeium oil and gas business case with Power BI

Data-Driven Decisions: please join us to learn more about this important capability

Audience: Business decision makers who want to learn more about data-driven decisions and become more aware of Microsoft Power BI’s capability. This is Not a technical IT “how-to” presentation.

Information is presented as a Case Study:

  • Using a fictitious, very small, Jr. Oil Co. operating near Red Deer.
  • The business case is simplified to allow for illustration of Power BI.

From this seminar you’ll understand:

  • The value of question-led data analytics / data dashboards
  • The value of integrating multiple sources of data
  • How data dashboards generate insight
  • Typical roles associated with dashboard initiatives
  • Basic components of Power BI

Attendee feedback from similar sessions by Fuzeium using Calgary vehicular traffic analysis:

  • “I was absolutely taken with the content, the flow, the story, your pace and your ability to create a comfortable and engaging environment for us participants”
  • “The ‘storyline’ was very powerful … I stayed captivated throughout the presentation”
  • “It was wonderful, and I really enjoyed how you structured the presentation”

Fuzeium is an innovative data analytics consultancy based in Calgary.
We emphasize question-led analytics, of which Microsoft Power BI plays an important part.

The Iceberg Analogy

Insight From Data Dashboards: A big chunk of the work pertains to the data itself, and when it’s done well, a small portion of the effort pertains to the visual layer.

11 Steps to Generate Insight From Data Using Visual Dashboards

11 steps to generate insight from data using visual dashboards. Data analytics is often messy and iterative, so this workflow can serve as a guide. We begin by uncovering a key question of interest for the customer. We end with a narrative explaining how the dashboard’s insights address the question. This workflow is not dependent on any one technology, though at Fuzeium we use Microsoft Power BI (and an assortment of other tools).

Generating Insight From Data Takes An Assembly Of Skills and Roles

Generating insight from data takes an assembly of skills and roles–often in the form of an integrated team. We display the main areas as an arch. The red keystone, which is the business domain knowledge, holds the arch together. The left side of the arch is more technical; the right side less so. The narrative is very important in terms of explaining how the analysis of data has led to insight.

2 hr Seminar: Enabling Data-Driven Decisions with Power BI – Sep 20, 2018

Back by popular demand!

Join us and learn more about the fascinating world of Data-Driven Decisions.

We are again offering a 2 hr seminar on Enabling Data-Driven Decisions.
Please register at on Eventbrite.

Previous attendee feedback:

  • “I was absolutely taken with the content, the flow, the story, your pace and your ability to create a comfortable and engaging environment for us participants”
  • “It was wonderful and I really enjoyed how you structured the presentation”

On Sep 20, 2018 between 2:00-4:00pm.

At the Palliser Conference Centre Amphitheater in Calgary.

Masters Degrees May Suggest Maturity of a Tech Ecosystem

The count of Masters degrees with program titles related to Data Science and Analytics may suggest the maturity of a tech ecosystem…and where large tech companies are more likely to invest.

In compiling a list of post-secondary programs across Canada, we see that both (the provinces of) BC and Ontario have several Masters’ level programs that reference “Data”, “Data Science”, or “Analytics”.   By comparison, Alberta currently has no Masters level programs identified as such.

Interestingly, Toronto, Ontario has made it on the shortlist of Amazon’s bid competition for its second head office in North America.  And Vancouver, BC just announced that Amazon will generate 3,000 new jobs in that city related to e-commerce, cloud and machine learning.

These profiles below help compare the 3 provinces.  They are derived from a data dashboard on the subject. Feel free to take a look and explore for yourself.

Pertaining to Data Science and Analytics Programs in Canada – April 2018:

Alberta:   0 Masters Programs

British Columbia (BC):   4 Masters Programs

Ontario:   8 Masters Programs

When you interact with the dashboard, it looks like this:

Proto-typing a Data Dashboard with Microsoft Power BI: Varsity Soccer Example

Approach:
We demonstrate below how one can proto-type some statistical analysis in the form of an interactive dashboard.   In doing so, multiple sources of public data can be simplified, visualized and made more insightful.  Using two off-the-shelf products from Microsoft, Excel 2016 and Power BI, we scraped data from nearly 20 public web pages on two sites and produced an interactive display.

Using Excel 2016 (and its Query Editor) we were able to extract data from tables on Web pages and create a data workflow to improve it for analysis.    The aggregated data was then modeled into several tables within Power BI.  The Report building feature of Power BI was then used to create visuals and enable interactivity.

The resulting interactive dashboard for the 2017 Canadian U Sport Soccer Championship is embedded below.

Background:

Canadian U Sport is the governing body for Canadian university sports.  Their national soccer championship in Nov 2017 awarded Gold to the Cape Breton University Men’s team and Gold to the Université de Montréal Women’s team.

Insight:

  • Of the 6 medals awarded in the finals (Gold, Silver, Bronze for both Men and Women), 4 of the medals went to teams from relatively small schools.
  • Two universities garnered two medals each.
  • All of the medal winners (with the exception of one team) had strong records in their respective divisions going back 8 years.

Where would you find that information, and which other schools competed and received medals? 

According to U Sport, there are 56 universities in Canada with about 12,000 student-athletes competing in various sports.   U Sport has its own site for publishing statistics, but there are numerous other ones too, often reflecting the geographic divisions across the country.  And then the universities have their own sites to promote their teams, their results and to build esprit de corps on campus.

  • You can see the soccer medal summary for both men or women.
  • You can see the size of their respective schools.
  • You can see the historical goal differential by selecting each team.
    Note:  Use the bi-directional arrow in the bottom right of the dashboard to make it full screen.

This link will demonstrate how Canadian Scholarship/AFA data can be represented.


Fuzeium’s dashboard platform and expertise are largely based on Microsoft’s Power BI and Microsoft Azure Cloud. The capabilities are applicable to any industry.  Please contact us if you like more information.

3 Case Studies to Illustrate Business Intelligence and more…

We are pleased to add Calgary census data as one of three case studies on our site.   The two other cases include Alberta Geothermal Potential and Alberta Inactive and Orphan Wells.

You can access all three case studies from the home page.

These cases illustrate how we tackle key questions and generate insights through data dashboards.

They also serve as examples of business intelligence, data analytics, and visualization, while leveraging the Microsoft Power BI and Microsoft Azure platforms.