This will be the fifth SQLSaturday and Tech Day in Baton Rouge, LA on Saturday August 3rd, 2013.
I found a collection of SQLSaturday, SQLRally and PASS Summit shirts with various stickers collected over the last 5 or 6 years.
It is going to be hot this weekend in Baton Rouge, so why not join us in the Business Complex at Louisiana State University for some AC, Networking, visit with Sponsors and excellent sessions.
For 24 Hours of PASS 2013 Summit preview (#24HOP – twitter hash tag), I was asked to give a preview of the 1/2 day session on Slicing and Dicing in Analysis Serves 2012 for the upcoming PASS Summit 2013. My response: No Problem.
In Denver, it was the year 2007 when I attended the first Summit. I had never been to a SQL Server conference before and just happened to read about it on SQLServerCentral.com. My boss thought it was a good idea for both of us to attend, Wow, what an experience that the first year! I sat through session after session of presentations on SQL Server stuff I had never known before. We used the SSC code to get a discount and a visit to the Casino Night put on by Steve Jones and gang.
Now, the tables have turned, and I have to present while expecting the attendees to learn the same as I had learned in 2007. By the third Summit in 2009, I was thinking: Hey, I can do that.
Analysis Services caught my attention because of the degree I received at LSU – Quantitative Business Analysis. I was amazed at what OLAP could do with data. This lead to reading Kimball books and a lot of trial and error. The meat of everything seemed the entry into a dimensional model, and this was through Attributes and Hierarchies.
This preview is about the defaults in Analysis Services Multidimensional Cubes and what needs to be changed or configured before using Attributes and Hierarchies.
Please come online with us on July 31st thru August 1st and get a taste of what you can expect from the Summit in Charlotte, NC Oct 14-18, 2013. You can pick one and more sessions to learn more about SQL Server.
Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing a financial data warehouse in the real world. Come chat with a SQL Server MCP and seasoned data warehouse architect to reflect on his many years experience in this industry.
There will be a $50 amazon gift card given away during the session.
Online Meeting URL: https://global.gotomeeting.com/join/659855837
DataArch.SQLPass.org
Speaker: Steve Simon, Senior Business Intelligence Development Engineer Atrion Networking Corporation
Summary: In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time. In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
About Steve: Steve Simon is a SQL Server MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Data Quality Services presentation at the PASS Nordic Rally in Copenhagen. Steve has also presented 5 papers at the Information Builders' (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.
Please join the Business Analytics Virtual Chapter as Mark Tabladillo talks about Best Practices for building a Framework for Data Mining. The GoToMeeting link for Noon Atlantic on June 13th is https://attendee.gotowebinar.com/register/7717448277059007488
More Information
Virtual Meeting
Data mining increasingly fascinates business people and information technology professionals alike, with the promise of finding meaningful patterns, relationships, and opportunities in our continuously growing volumes of data. There are tried and tested best practices you can follow to begin and improve your data mining efforts.
About Mark:
Mark Tabladillo, a Microsoft MVP and SAS expert. He helps teams become more confident in making actionable business decisions with the use of data mining and analytics. Mark provides training and consulting for companies in United States and around the world. He also teaches part-time with the University of Phoenix. He tweets @marktabnet and blogs at http://marktab.net
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5 or 6 sessions on each track. This will be the largest SQLSaturday event I have been a part of. It will be my first time at a SQLSaturday event in Atlanta. There are also 5 different pre-conference sessions today (Friday) from some great speakers – Bill Pearson, Denny Cherry, Stacia Misner, Eddie Wuerch and Adam Machanic.
I get to present 2 different sessions. DW ETL with SSIS 2012 was a session I did at the PASS Summit last year and Attributes and Hierarchies is a new session I presented to the local Baton Rouge SQL Server User Group a month ago.
This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demonstration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints.
The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.
Hope to see ya’ll all there if you are local to the area.
Thursday May 16th at noon central, we are going to be educated by MCM and past SQL Server MVP Robert Davis talking about “How to deliver a public-facing website on a global scale.” The online webcast is part of the monthly presentations by the PASS Data Architect Virtual Chapter which Robert help revitalize about 2-3 years ago. Please join us.
Summary: How do you deliver a public-facing website on a global scale? To be truly competitive in a global market, you need to deliver a high performing website no matter what part of the world the user is in. Scaling out websites to multiple locations is easy, but it doesn’t really provide the performance required if the website has to get data from halfway around the world. This session will look at the challenges to scaling out the entire application to meet global performance requirements and how we addressed these challenges for an existing web application.
About Robert: Robert is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for 13+ years, most recently as Chief SQL Server Evangelist for Idera Software. Previously he served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter and was co-author of Pro SQL Server 2008 Mirroring
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th at Georgia State University. If you follow @SQLPass and #SQLSatAtl on twitter, you might have seen tweets about 775+ registered attendees for this event. You can still get on the waiting list if you really want to attend. So what does this mean? There are going to be lots of networking along with some of the great speakers sharing their SQL Server knowledge.
It is going to be cool to talk with Bill Pearson again, visit with Adam Machanic and Louis Davidson, plus get to sit in on sessions from Stacia Misner, Teo Lachev and Mellissa Coates. I wish I had time to go to a Brave’s baseball game, but I will instead go to the Speaker Dinner Friday night and the after-party on Saturday, then fly home.
Below is my session:
The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.
