Memphis PASS Chapter

Oct 13th Meeting – Steve Anderson – 24-hour Business Intelligence Trainer – Section 4 – SSRS

October 8, 2011 in Meetings

When: Thursday, Oct 13th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

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.

Number of View :560

Tags: Business Intelligence, Data Warehouse, Reporting Services, SQL Server, SSRS No Comments »

by Alvin Ramard

Sept 15th Meeting – 24-hour Business Intelligence Trainer – Session 3

September 14, 2011 in Meetings

When: Thursday, Sept 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us for our third session from “Knight’s Microsoft Business Intelligence 24-hour Trainer“.

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.

Number of View :241

Tags: Business Intelligence, Data Warehouse No Comments »

by Alvin Ramard

Aug 11th Meeting – Jim Houchin & Alvin Ramard – 24-hour Business Intelligence – SSIS

August 6, 2011 in Meetings

When: Thursday, Aug 11th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

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.

Number of View :494

Tags: Business Intelligence, Data Warehouse, SSIS 1 Comment »

by Alvin Ramard

July 14th Meeting – Dan Evans – 24-hour Business Intelligence Overview

July 2, 2011 in Meetings

When: Thursday, Apr 14th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, July 14th, as our own Dan Evans gives us an introduction to Data Warehousing and Business Intelligence.

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.

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.

Number of View :243

Tags: Business Intelligence, Data Warehouse No Comments »

by Alvin Ramard

User Groups? Those Still Exist? They Do, and You Should Be Going To One

June 24, 2011 in User Groups

Did you ever ask yourself why you should get involved with local user groups? Why waste your personal time? Why drive out of your way?

See what Jes Schultz Borland, Database Administrator at Kimberly Clark, had to say on the subject.

User Groups? Those Still Exist? They Do, and You Should Be Going To One

Number of View :238

No Comments »

by Alvin Ramard

Pragmatic Works Summer School Special

June 15, 2011 in Training

Pragmatic Works is offering a summer school special.

The BI Stack is the fastest growing segment in the SQL Server Community. Enhance your career with education by Pragmatic Works, now including Power Pivot!

Click here for more information.

Number of View :207

No Comments »

by Alvin Ramard

June 9th Meeting – Brian Ringley – Data Warehouse Data Quality

June 2, 2011 in Meetings

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.

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.

Number of View :173

Tags: Data Quality, Data Warehouse, Master Data Management, Sharepoint No Comments »

by Mem-Pass Admin

No Memphis PASS Chapter May Meeting

May 9, 2011 in Uncategorized

There will be no May meeting for the Memphis PASS Chapter.

Instead, we’re all invited to the Memphis in May BBQ Fest. (See the invitation below.)

This event is by INVITATION ONLY, so we reserve your seat today.

Please note that due to the flooding along the Mississippi River, the event has been moved to:

Tiger Lane | Mid-South Fairgrounds
335 S Hollywood
Memphis, TN

May 12-13, 2011
Tiger Lane | Mid-South Fairgrounds
335 S Hollywood
Memphis, TN

Presented by:
Microsoft, BT, New Horizons, SoftChoice, Citrix, Quest, Polycom, Avanade, NetApp and Aspect

Questions?
Contact Natalie Baskin @ 901.328.2162 or email nbaskin@nhmemphis.com

As a valued customer, we have your tent waiting…

Please join us in the Smoke Masters Championship BBQ Team Tent (#R-049) at the 2011 Memphis in May – World Championship Barbecue Cooking Contest. Presented by Microsoft, BT, New Horizons Computer Learning Center, SoftChoice, Citrix, Quest, Polycom, Avanade, NetApp and Aspect.

This event is by INVITATION ONLY, so we encourage you toreserve your seat today.

Dates & Times
Thursday, May 12	Lunch: 11:30 am – 2:00 pm
	Dinner: 4:30 – 7:00 pm
Friday, May 13	Lunch: 11:30 am – 2:00 pm

General Information

Admission to Memphis In May is FREE from 11:00 AM to 1:00 PM. Single Day Tickets are $8 (after 1:00 PM) – Children 6 and under are Free.

Admission to the Smoke Masters tent is free to invited guests. Please print this invitation and bring to our tent. Great prizes will be raffled both days at Noon and 7:00 pm!

Number of View :217

No Comments »

by Alvin Ramard