Just wanted to compile a list of datasets, or sources of datasets, that can be used for BI/Analytics/Visualization projects and explorations (not limited or specific to any tools). These come in different formats, and some may need to be cleaned up. Please do read the restrictions and EULAs that come with each of the links/sources.
This is a work in progress. I am still updating this post, and will most likely re-arrange or re-categorize the links as I stumble across other data sets.
If you have any that you can share, I would love to add those to this list (and mention you shared it!) – please leave a comment below and I will add them to the list!
Last Updated : February 01, 2015
Thank you to all the troopers who attended my really-early-morning-cold-and-snowy session at SQLSaturday#65 in Vancouver, BC. It was such a great event; thanks to all volunteers, sponsors, speakers and organizers (kudos to Scott Stauffer (blog | twitter) .. Thanks to Todd McDermid (blog | twitter) too for helping me give out swags during my session, and thanks for the great powerpoint slide decks which I’ve used in 2 SQLSaturdays now! 🙂
As promised, here are the SQLSaturday#65 presentation materials for SQL Server 2008/2008 R2 Reporting Services from the Ground Up
Brent Ozar (blog | twitter) has a few pictures of the event 🙂
Sample Reports (pdfs)
Report with different visualization components (data bar, sparkline, indicator, gauge, chart)
Report with drilldown, barcode, gauge
Report using map (from ESRI shapefile for Canada) and Bing Maps layer
Today has been quite an eventful day for me, feels like a mishmash of stuff happened today. Definitely worth a blog post.
Here are some of the things I learned and did today.
And man it amazes me how many smart smart helpful people are out there 🙂
I possibly might need to work on SQL Server Service Broker. I think this might be the right tool for a project, but I need to be certain so I need to give it a test drive.
Thanks to Aaron Bertrand (blog | twitter) for pointing me to these excellent excellent resources on SQL Server Broker.
border:1px solid #E6DB55;
Just wanted to share some common “tips” or “tricks” I find myself using over and over again when creating reports.
I think I’ve had this draft for a while, and just never was able to publish it because things got so busy. Anyway, I will just publish in parts. Better late (and something) than never (and nothing!)
Common Report Tasks
Common page headers and footers
Report (reportname) generated by DOMAIN/User on 02/03/2010 4:51:03 PM
="Report (" & Globals!ReportName & ") generated by " & User!UserID & " on " & Globals.ExecutionTime"
Page X of Y
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
If you have start and end date parameters, and want to display them in your header or footer, with date formatted as MMM dd, YYYY
="Report Details from " & Format(Parameters!StartDate.Value, "MMM dd, yyyy") & " to " & Format(Parameters!EndDate.Value, "MMM dd, yyyy")
Free ebook from Microsoft Press: Introducing SQL Server 2008 R2
New updated version of SQL Server 2008 R2 Training Kit is out, and is full of awesome SSRS goodies (hands on labs, tutorials, presentations, and videos).
These two books are great, and they almost never leave my desk. I’ve been reading them nonstop.
Prologika Press. Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev
Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports by Paul Turley and Robert M. Bruckner
Excellent Free Ebooks from RedGate
SQL Server eBook Selection
1. Protecting SQL Server Data by John Magnabosco
2. The Art of High Performance SQL by Grant Fritchey
3. The Art of XSD by Jacob Sebastian
4. Two Minute SQL Server Stumpers Vol. 5
DBA Ebooks Bundle
1. Mastering SQL Server Profiler
2. Brad’s Sure Guide to SQL Server 2008
3. Brad McGehee’s DBA Best Practices
4. How to Become an Exceptional DBA (2nd edition)
5. SQL Server Tacklebox
The Best of Simple Talk .NET
1. The Best of Simple Talk .NET – Jit N’ Run vol.2
You can download them from this link