I have created polygons files of several Canadian cities to use in Tableau. They are either Electoral Districts or Wards and the source shapefiles comes from the following cities Open Data Portals:
You can access these polygon points csv files from my public Dropbox here: Polygons for Tableau
City of Ottawa Wards
If you want to know how to create and prepare polygon maps from shapefiles to use in Tableau, I recommend the following articles:
- A blogger Russian Sphinx wrote a great blog post -> How to create map in Tableau with ShapeToTab
- Richard Leeke the author of ShapeToTab -> Grow your own Filled Maps
- Robert Mundigl – Clearly and Simply -> Create Your Own Filled Maps in Tableau
Keep you posted on new files from other Canadian cities…
Slides from my presentation at the Ottawa SQL Server 2014 Day.
Thank you to everyone who attended the full day presentations on SQL Server 2014.
SQL Server 2014’s mission is to deliver for our customers mission critical performance for the most demanding database applications, hitting on all aspects of mission critical criteria from performance to security, scalability and high availability along with the mission critical support.
When it comes to business intelligence the mission is to deliver faster insights into any data big data, small data, all data and most importantly deliver BI in a consumable manner for business users through familiar tools.
Crisis Text Line is the first US nationwide, free, 24/7 text hotline for teens in crisis.
Millions of teens are quietly suffering every day with bullying, homophobia, suicidal thoughts, and more. The solution is beautifully simple: Crisis Text Line will provide crisis intervention services to teens via a medium they already use and trust: text.
Now that SQL Server 2014 is out, it’s time to get busy and learn! Below you will find a series of resources that will help you get started. First get an evaluation copy (180-day trial) here Download SQL Server 2014
Learn & Experience
Get free training and guided experience on learning about SQL Server.
- TechNet Virtual Labs – SQL Server 2014
- Microsoft Virtual Academy – SQL Server
- SQL Server Developer Center
- Books Online for SQL Server 2014
Community & Social Media
Want to Connect, Learn, and Share? Join the SQL Server Community by becoming a PASS member here PASS – Professional Association SQL Server and find a Local PASS Chapter where you can share your passion and knowledge about Microsoft SQL Server and Business Intelligence with other enthusiasts.
A minimal list of “SQL Server Community” Twitter accounts worth following:
Presentation slides from my session “Building Network Graphs with Tableau” at the Ottawa Tableau User Group Meetup – Thanks to everyone who attended.
To build the network graph demo, here is the Excel Workbook with the sample data for download:
Network Graph Sample Data (Microsoft Excel) – AsterixGraphData_Tableau.xls
To implement network graphs in Tableau, Data preparation is key!
Let’s quickly go through the steps and create a network graph with this very small sample dataset;
To start, drag the “LineY” attribute to the Rows shelf and the “LineX” attribute on the Columns shelf. Set the Mark type to “Circle” this will render a basic scatterplot.
Add the “CircleY” attribute to the Rows shelf as a Double Axis (right click on the Axis and click “Dual Axis”), and then synchronize the two Y axes (right click on the Axis, and click on “Synchronize Axis”)
Next we need to format the Tableau Mark cards to show “Multiple Mark Types“. Go to the “CircleY” Mark card and set Mark type as “Pie“. Drag the “NodeName” attribute on Label and “ID” on Color on the Mark card – each pie slice represents a connection (transaction)
Then cycle to the “LineY” Mark. Drag the “ID” and “Relationship” attributes on Detail on the Mark card. Set the Mark type to “Line”. Tableau will connect the dots… and Voilà! A simple Network Graph. You can resize the LineY series to make lines thinner.
To further enhance your visualization you could add a summary table, provide filters, and modify the tooltips.
TagsBusiness Intelligence Concert Data Data Analytics Database Databases Data Journalism Data Quality Services Data Visualization Data Warehouse DevTeach Données Ouvertes DQS Excel Gatineau GitHub Hadoop HDInsight Maps Master Data Services MDS Music NoSQL Office 365 Open Data Open Government Outaouais Power BI Power Map PowerPivot Power Query Power View Presentation Prog Prog-Rock Progressive Slides Speaking SQL Server SQL Server 2014 SSIS T-SQL Tableau TED Talks Wine
My Instagr.am GallerySorry, an error occoured while trying to get your instagr.am ID! Please try another instagr.am url.