Strate SQL

The weather says it’s supposed to be storming today.  What a better way to spend a rainy afternoon that in a conference room with your peers discussing SQL Server.  So come out at 2:30 PM for snacks and socializing and we’ll kick things off at 3:00 PM.

We’ll be hearing about Analysis Services Dimension Creation Best Practices & Disks, Real and Virtual and What is Important for SQL Server.

Feel free to contact me via e-mail (jstrate@digineer.com) or twitter (@stratesql) with questions or for more information.

If you are still trying to make plans for tomorrow afternoon… there is a PASSMN meeting you could attend.  This month we’ll be hearing about Analysis Services Dimension Creation Best Practices & Disks, Real and Virtual and What is Important for SQL Server.  The meeting starts at 3:00 PM and there will some snacks and socializing before hand.

Feel free to contact me via e-mail (jstrate@digineer.com) or twitter (@stratesql) with questions or for more information.

In a former life on a SQL Server 2000 project with I had the immense joy of building a few cubes in Analysis Services that took advantage of many-to-many relationships.  At the start I was thrilled to be trying something new and by the end I was cross-eyed trying to keep all of the calculations in the cube straight.  I had heard that in SQL Server 2005 Analysis Services all of this would be a lot easier.

To make things even easier, the guys over at SQLBI.eu put together a many-to-may relationship paper with associated projects to help people implement this in SSAS.  It’s an easy read and well thought out and I’ve grabbed on to quite a bit so far in reading it.

PS… am I the only one that says "SQLBI.eu" as {see qual blue} in my head when I read it?

BI-SIG – Q1 2007 Meeting
Wednesday, March 14th / 3:00 – 6:30
Microsoft Bloomington Offices

Intelligent Business With Business Intelligence

The inaugural meeting of the Microsoft Business Intelligence Special Interest Group (BI-SIG) in December was a huge success with over 120 attendees. Since then the organizational board has held several meetings, established committees, and planned the first meeting of 2007. That meeting is on Wednesday, March 14th. See the agenda and times below. Refreshments will be provided.

3:00 Registration

3:30 BI-SIG Updates & Announcements

3:40 Case Study – Performance Dashboards

Karl Lacher – Manager of Business Intelligence – Capella University

4:30 Microsoft Updates re BI & BPM

4:45 Break

5:00 Key Note Presentation – Project REAL & BI

Rich Johnson – BI Solutions Architect – Microsoft Consulting

With the permission of Barnes & Noble, Inc., Microsoft created an end-to-end data warehouse solution built on SQL Server 2005 based on an actual production data warehouse at Barnes & Noble. Microsoft then put that solution into the public domain as a fully functional data warehouse and set of best practices called Project REAL. Customers can use Project REAL to save 6-12 months of development and design effort in building their own BI solution on SQL Server 2005. Rich was the project architect and manager for the solution at Barnes & Noble and presents and helps customers start their own solutions based on Project REAL. Rich will present a high level overview of all of the pieces of Project REAL during this session.

6:15 Wrap-Up / Prizes

6:30 Optional – Technology Open Forum Q&A Session

So there’s this story:

Some time ago, Wal-Mart decided to combine the data from its loyalty card system with that from its point of sale systems. The former provided Wal-Mart with demographic data about its customers, the latter told it where, when and what those customers bought. Once combined, the data was mined extensively and many correlations appeared. Some of these were obvious; people who buy gin are also likely to buy tonic. They often also buy lemons. However, one correlation stood out like a sore thumb because it was so unexpected.

On Friday afternoons, young American males who buy diapers (nappies) also have a predisposition to buy beer. No one had predicted that result, so no one would ever have even asked the question in the first place. Hence, this is an excellent example of the difference between data mining and querying.

Well, while based partially in fact… a lot of the details are just not correct.  Mark Whitehorn researched the story for The Registerand determined that it’s an IT urban legend for the most part.