Currently viewing the tag: "data visualization"

The CAPP (Canadian Association of Petroleum Producers) Statistical Handbook presents a historical summary of the petroleum industry’s progress, summarizing detailed statistical information concisely in one publication.

With applied data scraping I was able to extract related information on Net Cash Expenditures for the Canadian Petroleum Industry from 1947-2010. Using my favorite rapid-fire Business Intelligence tool; Tableau Software! this is what I came up with…

Source:
CAPP Statistical Handbook for Canada’s Upstream Petroleum Industry (November 2011)
You can download the lastest stats and data here: Statistical Handbook

Wouldn’t it be great if you could have access to all of your LinkedIn Data and be able to do some analysis and visualization!

Besides LinkedIn Maps that let’s you visualize your professional world based on the relationships between your connections there isn’t any other great alternatives to enable you to do some further analysis of your data and that’s because it is not fully available for you to download… (LinkedIn needs to change this!)

I actually had to assemble my own LinkedIn Data to produce the following.

I’m a little bit late to the game, but I wanted to share some great information that was announced earlier this week at the Professional Association of SQL Server (PASS) Summit 2012.

Code named project “Hekaton” is Microsoft’s new in-memory technology for transaction processing that will be built directly into the data platform and ship in the next major release of SQL Server. This will close the loop of in-memory capabilities across analytics, transactions, streaming and caching workloads. Based on some early testing and feedback by customers “Hekaton” will offer considerable performance gains of up to 10 times for existing apps and up to 50 times for new applications optimized for in-memory performance.

Microsoft also announced the new release of SQL Server 2012 Parallel Data Warehouse (PDW) which should be available on the first half of 2013. PDW will be powered by PolyBase, a breakthrough data processing engine that will enable queries across relational data and non-relational Hadoop data (Big Data). PolyBase will enable you to write plain, normal T-SQL queries, and it will know how to translate them, and how to federate the underlying data, so your applications can transparently access a traditional star schema warehouse stored in SQL Server 2012 PDW or read results from MapReduce Big Data processing jobs which are stored in HDFS.

The much anticipated SQL Server 2012 SP1 as also been released and is now available for download here.

  • SQL Server 2012 SP1 provides rich integration and support for the new business intelligence capabilities in Office 2013. Powered by our in-memory analytics engine, it enables business users to interact directly with raw data in Excel 2013 with tools such as PowerPivot for data modeling and Power View for stunning interactive data visualization.
  • SQL Server 2012 SP1 also delivers a number of non-BI enhancements listed here.

Also newly available is the Data Mining Add-Ins for Office 2013 which you download here. I also strongly suggest that you take a look at the Microsoft SQL Server 2012 SP1 Feature Pack available here

Quite an exciting week it was at PASS Summit 2012 for the SQL Server community!

For further details and other SQL Server related news please follow this link : Latest SQL Server News

Voici un portrait de la population selon le groupe d’âge et le sexe de l’Outaouais et l’ensemble du Québec.

La première grille démontre la fluctuation en pourcentage de 1996 à 2011 et la seconde les détails de 1996, 2001 et de 2006-2011 et ce pour tous les groupes d’âge et le sexe.

Il est intéressant de noter que le pourcentage de fluctuation de 1996 à 2011 pour les 55-64 ans et 75 ans et plus de l’Outaouais sont plus élevés que l’ensemble du Québec.

Bonne analyse!

Source : Institut de la statistique du Québec, Direction des statistiques sociodémographiques et Statistique Canada

Avec l’aide des données non ouvertes de la Société de l’assurance automobiles du Québec, voici un portrait du bilan des victimes pour les mois de janvier à décembre en Outaouais. Les statistiques sont énoncées sur une base comparative pour les six dernières années, soit de 2006 à 2011.

Le total des victimes est généralement à la baisse. Ce qui serait intéressant c’est de comparer ces données avec le nombre de détenteurs de permis de conduire pendant ces années.

Ces données sont-elles à la baisse parce ce qu’il y a moins de gens sur nos routes? Le transport en commun?

Source : http://www.saaq.gouv.qc.ca/rdsr/sites/files/12012002.pdf