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

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

Event: Best Practice in Analysis Server and MDX

Grant Paisley - Tuesday, June 05, 2007
Microsoft SQL Server 2005 Analysis Services includes a complete re-architecture of the Online Analytical Processing (OLAP) engine from Microsoft SQL Server 2000.

In this session we will focus on the performance and scalability aspects of the Analysis Services architecture and cover cube design, providing specific guidance on how to design for optimal performance, and also cover MDX and calculations.

Cube design and storage

We will discuss cube modeling (emphasizing the importance of attribute relationships), partitioning strategies, aggregation management and cube processing. For each of these, we will explain the important design principles, and provide best practices for performance and scalability.

MDX and calculations

We take common business problems and show how MDX can be utilized to solve them while keeping query performance under control. Finally we point out common gotchas for poor performance in MDX and best practices to address them.

These principles and practices should be a necessary foundation for any organization embarking on a large-scale business intelligence project based on Analysis Services 2005.

We will make *you* the BI hero!

For more information see http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=264

Event: Implementing Partitioned Tables

Grant Paisley - Wednesday, March 14, 2007
In this session Geoff Orr will demonstrate how to implement and update partitioned tables. He will also show how partitioned tables can assist to manage very large databases (VLDB's) and how to perform archive operations without the need to perform deletes.

For more information see http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=243

Event: Business Intelligence "lights up" with Office SharePoint 2007

Grant Paisley - Thursday, November 09, 2006
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...

For more details see http://www.sqlserver.org.au/Events/RegisterMeeting.aspx?EventId=220

Event: Grant to present at TechEd China 2006

Grant Paisley - Thursday, September 07, 2006


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

Event: SQL Server 2005 Reporting Services: Advanced Report Authoring

Grant Paisley - Sunday, July 17, 2005
This session presents advanced techniques for building reports with SQL Server 2005 Reporting Services and the Visual Studio-based Report Designer.

Topics include

* how to use the built-in expression language,

* report parameterization
(data driven, multi-valued, and hierarchical),

* supporting multiple data sources
(including relational, multi-dimensional, and XML), and

* making reports interactive.

See http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=100 for details

Event: Business Intelligence - What will my user see?

Grant Paisley - Monday, June 27, 2005
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.

For more details see http://www.sqlserver.org.au/Events/RegisterMeeting.aspx?EventId=90