2011 Meetings

Dec15/2011 Douglas Johnston – SQL Server Denali (SQL Server 2012)

Abstract:
This month, Douglas Johnston introduces the new version of SQL Server, codename Denali. From T-SQL additions to the new Integration Services designer, from Master Data Services to the new Visual Studio project types, he will walk through a real-world example of each. As Douglas is also currently implementing all of these for a client, he will also demonstrate the pitfalls and bugs of the pre-release software. If you are considering upgrading to SQL Server 2012, this session will give you great information on what the benefits and the risks are.

Bio:
Douglas Johnston is a Group Manager in the Business Intelligence & Collaboration Service Line of Avanade. With 10 years of experience with SQL Server and business intelligence tools, in industries as diverse as healthcare, financial services, defense and energy utilities, he has become one of the leading contributors to the Avanade BI community. He advises on, and develops projects with, aspects of database development, performance tuning, architecture, warehouse design and management, high availability, ETL and reporting systems. He is also a founding member of the peer-nominated Avanade Expert Network and holds several Microsoft certifications.

Before becoming a database ninja, Douglas developed with VB6, Perl, Oracle, Business Objects and J2EE, as well as some other really terrible technologies. He has particularly desiccated sense of humor to go with the British accent, owns a kilt, and likes monkeys.


Nov10/2011 Dan Evans – 24-hour Business Intelligence Trainer – Section 3 – SSAS

Abstract:
For this month’s meetinng, we’ll be going over Section III of the Knight’s Microsoft Business Intelligence 24-Hour Trainer about SQL Server Analysis Services (SSAS). We’ll show the major components of SSAS including Data Sources, Dimensions and basic MDX expressions. You’ll see how these points are aplied using the SSAS project and the Cube Wizard. Come learn what SSAS is an what it can do for your Business Intelligence (BI) projects!

Bio:
Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Oct13/2011 Steve Anderson – 24-hour Business Intelligence Trainer – Section 4 – SSRS

Abstract:

Join us on Thursday, Oct 13t, as Steve Anderson walks us through Section IV of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer. We will be taking a look at SQL Server Reporting Services (SSRS) in the Business Intelligence environment.

Bio:

Steve Anderson is a database and analytics professional who received a Master of Engineering Management degree from Christian Brothers University and a Bachelor of Science in Computer Engineering from The University of Memphis. Mr. Anderson specializes in: Database Marketing, Data Analysis, Data Warehousing, Report Development & Business Intelligence. His expertise expands across several industries – sports, entertainment, financial services, gaming, and retail.


Sep 15/2011 24-hour Business Intelligence Trainer – Session 3

Abstract:

If everything works out as we hope, our own Dan Evans will lead a session covering Section III about SQL Server Analysis Services (SSAS). Come learn the fundamentals of SSAS concepts and how to apply SSAS to your BI/DW environment. Understand how to build and deploy a cube, edit dimensions and measures and play around with some MultiDimensional eXpressions (MDX).

If Dan is not able to join us, I will continue from our last session and go over examples of how you might go about loading dimension or fact tables using SSIS.


Aug 11/2011 Jim Houchin & Alvin Ramard – 24-hour Business Intelligence – SSIS

Abstract:

Join us on Thursday, August 11th, as Jim Houchin and Alvin Ramard take us through the second section of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer. This meeting will cover Section II: SQL Server Integration Services. The session will be a mixture of presentation and demonstrations to provide an overview of SQL Server Integration Services (SSIS) and how it can be used in your business intelligence and data warehouse process.

Bios:

Jim Houchin

Jim Houchin has over ten years of experience in software design, development, and implementation, of web and database
applications, with a touch of QA. Jim’s focus for the last year has been as a DBA at Yusen Logistics concentrating on SQL administration and maintenance on SQL 2000, 2005 and 2008R2. Jim also has a strong desire to learn new technologies and he is eager to share information.

Jim Houchin is a Vice-President of the Memphis PASS Chapter.

Alvin Ramard

After working for 14 years as an electrical engineer, Alvin Ramard returned to school to pursue a career in Information
Technology. Alvin has almost 12 years of experience working mainly with SQL Server 2000, 2005, 2008, and 2008R2, with
strong focus on ETL and BI. Alvin also has a strong desire to learn new SQL Server technologies and he is enjoys sharing this information with other SQL Server enthusiasts.

Alvin Ramard is a co-founder and a Vice-President of the Memphis PASS Chapter.


Jul 14/2011 Dan Evans – 24-hour Business Intelligence Overview

Abstract:
Based on the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer, come learn the essence of developing BI/DW solutions using industry best-practices and leverage your investment in SQL Server. This meeting will cover Section I – Data Warehousing and Business Intelligence fundamentals including key concepts and data modeling. The session will be a mixture of presentation and demonstrations.

Bio:
Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Jun 9/2011 Brian Ringley – Data Warehouse Data Quality

Abstract:
A major challenge for any BI data warehousing project is issues with data quality. Often times business users expect the IT departments to simply clean up the data without providing any other input or information. Unfortunately, IT often needs business rules in order to decide how to clean up the data. Without the proper business rules the data cleansing project can take longer to complete or even fail. A way to avoid this situation is to “empower” the business users and give them a way to manage their own data.

Bio:
Brian Ringley, a Solution Architect at PointBridge Solutions, will present a simple method to allow users to manage their own data using SharePoint and SQL Server Integration Services. There are many Master Data Management tools available in the market, however, these are often expensive or difficult to use. Allowing users to manage their data within SharePoint allows them to use an environment they are comfortable with and leverage other out of the box SharePoint functionality.


Apr 14/2011 – Rob DeMotsis – Policy Based Management

Abstract

Today’s DBA is required to be more than just a DBA. Especially those who must monitor and manage a large number of database servers and/or maintain strict adherence to industry policies such as SOX, HIPAA, and the like, now have a new way of doing this.

Using Policy-Based Management within SQL Server 2008, the modern DBA can now do this with a little more ease. This presentation will touch on the basic elements of how it works and why it is a solid tool for using in many SQL Server environments. Also, we will create a simple policy to help you get started on building a Policy-Based environment for your SQL Server Environment.


Feb 17/2011 – Eric Farney – SQL Server Reporting Services


Abstract

Eric Farney will present an overview of SQL Server Reporting Services, focusing on development, development tools (including Report Builder 3.0), and best practices.

Bio:
Eric Farney has worked at NYK Logistics for the past 23 years. The first 18 years were spent in business operations (9 years in St. Louis, MO and 9 years in Dallas, TX). The past 5 years have been spent in Memphis as a Data Analyst, System Analyst and Developer. During that time, he has used a combination of SQL, Coldfusion, Crystal Reports and SQL Server Reporting Services to provide data solutions to the company.


Jan 13/2011 – Peter Myers – Introduction to Analysis Services Cubes

Abstract:
Analysis Service’s OLAP component allows organizations to implement a cube that is designed for rapid ad hoc information retrieval of their data. The cube, as a single version of the truth, can be enriched to encapsulate business rules and calculations, and advanced Business Intelligence features including KPIs and actions.

For organizations that have a Standard or Enterprise SQL Server license, Analysis Services is a possible zero-cost opportunity for your organization today. In the session learn how to exploit the capabilities and features, and the basics of best practice design. Be prepared for numerous compelling demonstrations and to leave the session energized by the potential!

This presentation is targeted at IT professionals with an interest in cube design, and equally for non-IT professionals interested to understand and evaluate what cubes could achieve for them. There is no requirement to have any background or experience with OLAP technologies.

Bio:
Peter Myers has 13 years’ solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.

Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.

He has a broad business background supported by a bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2006.

Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events and conferences.


Leave a Reply

Your email address will not be published. Required fields are marked *

14 + one =