PASS SQL Saturday #138 - Sydney 2012 a success

Grant Paisley - Friday, July 13, 2012

Angry Koala sponsored and hosted PASS SQL Saturday #138 - Sydney 2012 at Epping Boys High School on Saturday 21st April 2012. It was a great success with over 200 people attending.

Having people stick their top three passions (outside technology) to themselves stimulated a HUGE networking day:

 

Anarchy Scrabble
Tell a story with the words
Bushwalking
Peace, danger, the unknown and snakes
Comedy
Who doesn't like to laugh?  Actually, I can name a few ppl...
cricket
I am Indian i have to love cricket
dancing
Girls find guys who can dance sexy
Dreaming and Thinking
Isn't that what we are here for?
Procastrinating
Im lazy so anything that can keep me from doing my job.
Radio Control Car racing
Speed without broken bones
Travelling
Who doesn't!
Wine
I like things I'm no good at - Wine; I can drink the stuff all day, but still can't tell the difference between a Pinot and a Merlot!

My friend Andrew Hill from STARStv put up the lunchtime team building activities and my brother Mark from AV2U put together this great video.

My session "Killer Real-World PowerPivot Examples" was a dry run for Jun 2012 session at TechEd 2012 Orlando (it has already had more than 3,700 views)

I'm not sure the audience appreciated Koala droppings (Hesche kisses) as much as my normal "cling koalas" pegged at them.

Just working on a blog to show you how I created the Measures PowerSlicer...

Grant

Spot - NSW Birds with Pivot

Grant Paisley - Monday, March 22, 2010

I have created an application called Spot for NSW bird sightings with Microsoft Researches new Pivot Technology.

Please vote for Spot if you like it!

You can run Spot yourself but you need to Download Pivot and install it first on Vista or Windows 7 - running Aero

Here is a Spot screencast demo...

Run Spot screencast demo

or a lower quality on youtube







I have entered this in the Apps4nsw competition 



Purpose
Allows you to identify a bird species that you have seen.  Or find birds in you location that are under threat.  Or just experience the variety and beauty of birds in NSW.

Users
Bird watchers, those interested in there environment and the status of bird life. People wanting to experiment with new technology...

Data
Spot is a Proof of Concept based on a 10% sample of species sighting data for NSW from the Department of Environment, Climate Change and Water combined with descriptive information from Birds Australia and create common photographs from some helpful photographers at Flickr.com.   It could be extended to include all animal species, not just birds...

Note: the need to download special software (Pivot) will not be necessary once the Silverlight version of Pivot is released in a few months, at which point a standard browser will be enough...

Thank You
To Geoff Hutchinson for help entering descriptive info and his photos and the other photographers, Jon Irvine, Julian Robinson, Kip Lee and James Bergamin.

Grant

run screencast demo

Event: Grant is presenting at the SQL PASS conference in Seattle

Jodie Miners - Tuesday, November 03, 2009
On Thursday 5 November at 1pm, Grant Paisley will team up with Paul Turley to present at the SQL PASS conference in Seattle. Paul will be presenting on Super Reports: Patterns and Recipes and Grant will join Paul for a part of the presentation to talk about building dynamic reports on Cubes.

Grant's topic will cover how to obtain & present dimension metadata to drive integrated report parameter selection, accessing metadata, dynamic rows and measures and he will be also showing off the OLAP browsing with Spermlines. 


Dynamic Rows


Cube Metadata


Spermlines for 12 months of data

Seattle City B.I. on a Microsoft Surface Table

Shaun Bliss - Monday, January 26, 2009
An interesting demo shown at the Microsoft B.I. Conference in Seattle, showing B.I. data overlayed on a 3D representation of the city, completely interactive using Microsoft's Surface touch screen technology.

Microsoft Video: Business Intelligence #00: Platform Overview

Jodie Miners - Wednesday, January 14, 2009
From the Microsoft MSDN Channel 9 site:
"This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that has been delivered around the globe by Microsoft and Microsoft Partners.  This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology.

This first screencast will take you through the Microsoft BI Platform briefly touching on each of the technologies".

This is an introductory level screencast. If you have any questions at all, please fell free to ask them in the comments section of this post.

See the video here

Microsoft Video: Business Intelligence #01a: Introduction to Microsoft BI

Jodie Miners - Wednesday, January 14, 2009
From the Microsoft MSDN Channel 9 site:
"This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners.  This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology".
This is a developer level screencast, so if you have any questions at all, please fell free to ask them in the comments section of this post.

See the video here:

Event: Fun with Dick and Jane? Excel 2007 Data Mining Add-in can tell us why

Grant Paisley - Monday, September 15, 2008
Grant will be presenting at the Office DevCon conference to be held at the Sydney Microsoft office on 15-16 Nov 2008. Office DevCon is a free community driven conference about all aspects of Microsoft Office Devlopment.
 
This is a deep-dive session.

Data mining has moved from the hallowed halls of long bearded professor types to today where literally anyone can dabble with some serious data exploration. Come along and learn how to take data in Excel and utilizing the new Table Analytics (Data Mining Excel 2007 Add-In) and really understand the behaviour of people like Dick and Jane. How are your customers similar? What customers are different? Basket analysis - is there really a relationship between Nappies and Beer?

Find out more here http://www.officedevcon.com.au

Event: Angry Koala at TechEd 2008

Grant Paisley - Thursday, July 31, 2008

Below is a list of sessions that the Angry Koala crew will be presenting at TechEd 2008. TechEd is Microsoft's premier developer conference in Australia.

Grant Paisley

Report Authoring with Microsoft SQL Server 2008 Reporting Services

Explore the SQL Server 2008 Reporting Services Report Designer tool. This session is a walkthrough of the many enhancements in the new release. Learn about some of the new Report Designer usability features, how to add data visualizations with Gauges, build complex structures with Tablix, and build richly formatted Textboxs. 

Shh data mining works in Excel 
 
Shh don't tell your friends, but anyone can use the new data mining add-in for Excel. But if *you* do, you can impress your friend / boss / colleague / mum. I guarantee by the end of this session you will be a data mining guru, at least to your Mum. We will utilizeTable Analytics to find unusual data, troll through customer demographics to find what influences buying decisions, classify customers...

Glyn Llewellyn

SQL Service Broker in Action

Introduced in SQL 2005, SQL Service Broker forms the basis for many of the new features in SQL 2008. People are using it in a wide variety of applications from :- i) Distributed data gathering (retail stores trickling sales into Head Office) ii) High Availability &/or Load Balancing (every transaction is pushed out to DR & Reporting services) thru to iii) Spreading out Load Spikes. Come & see how your company could take advantage of this flexible technology.

Geoff Orr

MDX for a SQL dude (Demystifying MDX) 

If your brain is wired for Transact-SQL and you're looking for a quick and dirty introduction to the weird and wonderful world of Multi-Dimensional eXpressions then this is the session for you. The syntax looks similar to SQL but does not work the same way. Cubes have far more metadata & MDX takes advantage of that. The session commences with an explanation of the basic concepts and principles underpinning the MDX language, contrasts it with TSQL and then proceeds to describe and demonstrate key syntax, MDX queries and some MDX scripting. Key Topics: Dimensions, Measure Groups and Members, How to do a join, How to add a condition, Where vs Filters. Perspectives, Accessing Properties, A few must know functions.

Rob Farley

TSQL Tips n Techniques: Improving Your T-SQL Arsenal

As the quantity and complexity of questions we ask of our data increases, database professionals need to be as proficient as possible with T-SQL. In this talk, see many advanced T-SQL tips and learn techniques to improve your T-SQL arsenal.

For more information about the sessions at TechEd see https://aunz.msteched.com/au/public/sessions.aspx

Event: Report Authoring in SQL 2008 Reporting Services

Grant Paisley - Friday, June 20, 2008
Grant will cover tips learnt building reports in SQL Server 2008 Reporting Services, including a walkthrough of the many enhancements in the new Report Designer tool. Learn about some of the new Report Designer usability features, how to add data visualizations, build complex structures with Tablix, and build richly formatted Textboxes. You may even see sperm!

For more details see http://www.sqlserver.org.au/events/ViewEvent.aspx?EventId=340

MOSS and BI Presentation at SBTUG

Grant Paisley - Sunday, July 29, 2007
This month I presented at the Sydney Business and Technology User Group on the topic of MOSS (Microsoft Office Sharepoint Server) and BI.

You can read Craig Bailey's review of the session here: http://blog.craigbailey.net/2007/07/sbtug-report-on-last-meeting-online.html.