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.
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.
"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.
"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.
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.
Come and see how Office SharePoint 2007 "lights up" Business Intelligence.
What is business intelligence? It is simply "turning data into knowledge"
We have extraordinarily powerful quiver of tools for building knowledge from data in SQL Server including:
1. SQL Engine - data storage
2. Analysis Server - multidimensional database
3. Integration Services - move and transform data
4. Reporting Services - creation, management, deployment of reports.
Office SharePoint 2007 gives us the best vehicle to integrate and expose this knowledge through collaboration and document management. In this session we get a whirlwind tour of:
- KPI's / Dashboards
- Server based Excel and data visualization
- Report Centre
- BI Web Parts
- Business Data Catalog
This is the session presented by Grant at TechEd 2006 in Australia and China
Microsoft Office SharePoint 2007 is in Beta 2 now and will be release late this year...
Business Intelligence "lights up" with Office SharePoint 2007
What is business intelligence? It is simply "turning data into knowledge"
We have extraordinarily powerful quiver of tools for building knowledge from data in SQL Server including:
1. SQL Engine - data storage
2. Analysis Server - multidimensional database
3. Integration Services - move and transform data
4. Reporting Services - creation, management, deployment of reports.
Office SharePoint 2007 gives us the best vehicle to integrate and
expose this knowledge through collaboration and document management. In
this session we get a whirlwind tour of:
- KPI's / Dashboards
- Server based Excel and data visualization
- Report Centre
- BI Web Parts
- Business Data Catalog
This is the session presented by Grant at TechEd 2006 in Australia and it will now be presented at TechEd in China
Ever wondered what Microsoft offers the users for Business Intelligence?
What is possible with tools you already own...
Plumbing - BI Architecture SQL2000 v's SQL2005
Exploring - What tools are best when
Gluing - What do we use to bring it all together
Perception is that Microsoft has a market leading back end in with Analysis Server, but has not had decent front end tools. This no longer true! There are now a range of technologies available including:
- Office Web Components,
- BI Portal,
- Sharepoint,
- Reporting Services,
- Report Builder,
- Excel,
- Data Analyzer,
- Excel Accelerator for OLAP,
- Scorecard Accelerator.
In this session we will explore some of these offerings demonstrating the rich BI delivery platform Microsoft now offers with real world examples.
