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
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.
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...
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.
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.
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.
Subscribe to RSS Feed
seattle Office 2007 BI SQL Server 2008 developer Excel event Reporting Services SQL Server Data Analyzer Report Designer OLAP MDX video geographic electricity city management Microsoft Research Data Mining water Analysis Server Pivot SharePoint Data Visualisations Spermlines presentation Sparklines surface