Data Dashboard: Who Were the Best University Soccer Teams in Canada for 2017?

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.

If you are interested in digging deeper into university sports statistics, it can be challenging based on the disparate nature of the data.  But it’s getting a bit easier…here is an example.

We demonstrate below how to proto-type some statistical analysis in the form of an interactive dashboard.   In doing so, multiple sources and large amounts 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 U Sport Soccer Championship is embedded below.  You can expand it to full screen; click on its charts; interact with it and learn.

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


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.

Data Dashboard: Calgary’s Population and How it is Distributed by Community

Calgary, Alberta, Canada - Photo credit: Kevin Cappis

Whether you are new to Calgary, or a long-time resident, you may be interested in knowing how the city’s population changed over time.  And how the population is distributed among the communities.

The following analysis was derived from Fuzeium’s interactive dashboards, which analyze Calgary’s 2017 civic census data.

Feel free to interact directly with the
Calgary census Fuzeium dashboards.

Calgary’s population has grown every year since 1995.  Although in 2010 and in 2016, that growth declined due to a net migration out of the city. In total, the population has increased by 89,000 people in the past 5 years.

Calgary is a young city with a median age  (i.e the middle age) of 36.4 years (according to Calgary Economic Development).  The age category of 25-44 years old, is the largest group, with over 440,000 people.  The two communities with the highest number of those individuals are The Beltline and Panorama Hills.

As Calgary continued to grow, we see the biggest increase in population changes in the outer communities, which are newer subdivisions.

The green areas on the map below illustrate which communities had an increase in population (dark green with the highest), whereas the pink-red indicates communities that declined in population.

The five communities with the largest growth over 5 years, grew in total by more than 32,000 people.  Not surprisingly, these are on the edges of the city in the north and the south.

They are pinpointed on the map below.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com

 

Fuzeium, A Winning Spark at SPARX Pitch Competition – Jun 2017

We very much enjoyed competing within a strong cohort of competitors at the SPARX pitch competition in Calgary (at the Global Petroleum Show 2017).

And we are honored to be selected as one of the winners for our approach to enabling Alberta Oil & Gas market intelligence through dashboards.

The SPARX 2017 Theme:
“This competition is targeted at ENTREPRENEURS who have business or technical innovations relevant to the energy sector that are either CLEANER or LEANER (ie. HR, envirotech, cleantech, safety, health, management consultants, etc.) & can be used by all types of companies – not just the energy sector.”

The Fuzeium “Pitch” Being Delivered to Judges and General Audience

Demos & Conversations At the Kiosk

Cenovus Drilled the Most Wells in Alberta Between Jun 26, 2016-Jun 21, 2017

Despite the difficult operating environment in the oil and gas industry, Cenovus has continued to actively drill and produce in Alberta.

As forecasted in their corporate update of Jun 20, 2017, Cenovus has estimated total production to be 482 Mboe (482,000 boe) by the end of 2017. See excerpt below.

While the production estimate includes the assets they’ve purchased from Conoco-Phillips, we at Fuzeium were curious as to what kind of drilling program they’ve had in Alberta.

Between Jun 26, 2016, and Jun 21, 2017, Cenovus and Cenovus FCCL drilled 562 wells, which is more than their next competitor CNRL (438 Alberta wells drilled) and significantly more than the top 10 (licensee) average of 190 (Alberta wells drilled).  Cenovus’s drilling operations accounted for about 14% of total drilling activity in Alberta during that period.

Cenovus’s drilling activity in 2017 relates to 195 licenses issued since the beginning of the year. Their licensing is split between their Heavy Oil assets (Foster Creek/ Christina Lake) and their Crude Oil assets in South East Alberta.

In short, Cenovus has been the most active licensee in terms of drilling wells in Alberta from Jun 2016 to Jun 2017.

* the maps above were derived from Fuzeium’s Well Intelligence dashboards for Alberta, which interprets public data from the AER.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com


Hotspots for Geothermal “Direct Heat” in Alberta (e.g. greenhouses)

According to an industry study of Alberta’s geothermal potential,  numerous communities have oil and gas wells with temperatures above 90c and are also within 10kms of a municipality.  At that temperature and proximity, there is potential to use geothermal capabilities for generating direct heat.

* The table of communities to the right reflects the top 15 (by well count).  Use the dashboard below to explore for more.
* The well data used in the study were current to Oct 31, 2016.
* New wells would have been drilled since and are not part of the study.

The wells associated with those communities above are also mapped to Alberta’s Township range system.  Each circle below give a sense of where the wells are located. These lower temperature wells have a wider dispersion across the province than either the  >120c or >90c wells do.

To recreate and explore the results, simply go to the associated dashboard (click on the image below) and then select the lower right button called “1. Direct Heat within 10kms of Municipality”.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com


Hotspots for Geothermal “Industrial Heat” in Alberta (e.g. timber drying)

According to an industry study of Alberta’s geothermal potential,  numerous communities have oil and gas wells with temperatures above 90c and are also within 10kms of a road network.  At that temperature and proximity, there is potential to use geothermal capabilities for generating industrial heat.

* The table of communities to the right reflects the top 15 (by well count).  Use the dashboard to explore for more.
* The well data used in the study were current to Oct 31, 2016.
* New wells would have been drilled since and are not part of the study.

The wells associated with those communities above are also mapped to Alberta’s Township range system.  Each circle below give a sense of where the wells are located. All are along the western side of the province but are in much greater in number and cover a larger area than the hottest wells do.

To recreate and explore the results, simply go to the associated dashboard (click on the image below) and then select the lower right button called “2. Industrial Heat within 10kms of Road Network”.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com


 

Hotspots for Geothermal “Power Generation” in Alberta

According to an industry study on Alberta’s geothermal potential, the following communities have oil and gas wells with temperatures above 120c and are also within 10kms of a power line or substation.  At that temperature and proximity, there is potential to use geothermal capabilities to generate electricity.


* The range in # of wells above is from 1 (Claresholm) to 54 (Hinton).
* The well data used in the study were current to Oct 31, 2016.
* New wells would have been drilled since and are not part of the study.

The wells associated with those communities above are also mapped to Alberta’s Township range system.  Each circle below give a sense of where the wells are located.  All are along the western side of the province where the wells are the deepest.

To recreate and explore the results, simply go to the associated dashboard (click on the image below) and then select the lower right button called “3. Power Generation within 10kms of Powerline or Substation”.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com


 

It’s So Much More Than a Petroleum Show…

With a theme of developing a leaner and cleaner industry, the SPARX Pitch Competition finalists (at the 2017 Global Petroleum Show) are diverse. They include companies with the ability to improve extraction of oil & gas; reduce emissions;  develop geothermal energy; harness solar energy; gain market intelligence; efficiently acquire services; collaborate with data visualization; improve pipeline integrity. We at Fuzeium are proud to be one of the finalists.


The 13 participants in alphabetical order are:

Agestpc
Patented thermal desorption technology

Blair Air
Air Compressor / Injection Pump for SWEET and SOUR well sites

Borealis Power
Canoe Reach Geothermal Project: The next generation of renewable energy

Finis Energy
The Most Efficient & Cost-EffectiveSolar Power Roof System

Fuzeium Innovations Inc.
Gain Alberta Oil & Gas Market Intelligence Through Online Data Dashboards

Geometric Energy.ca
Shaping a Sustainable Future

H2nano
Clean water, clean industry.  Powered by light.

Pursuit-Technologies
Test reservoir properties for each stage individually with one trip in the well

Riger
For energy service and equipment rentals

RNG International Ltd
Natural gas dehydration systems

Steambooster Technologies
Superheating Steam for SAGD Operations

Vizworx
Geospatial data visualization

Zeel GIS
Helps energy companies tackle their pipeline integrity challenges

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com


 

Who’s Been Drill’n for Oil & Gas in Alberta?

Who’s been drilling in Alberta? Well, it is a moving target, but this dashboard shows the last 14 days.

Click on the dashboard below to find out.
(Use the “Full Page” diagonal arrow for full screen.)

How to....

And if you want more detail over the last year and see who the drilling contractors were, subscribe to Fuzeium’s Well Intelligence module.

You’ll be able to access a drilling activity dashboard that looks something like the following, which was captured as just an image on Jun 2, 2017.

Definition and Interpretation:  

  • The data used is AER ST 49 – Daily Drilling Activity (spudding of new wells).
  • Interpretation of the source data is done by Fuzeium using a variety of data integration and visualization techniques.

*All information is provided subject to our Terms of Use, including disclaimer of warranties and limitations on liability. © Fuzeium Innovations Inc. To provide feedback, contact us at info@fuzeium.com