CCG prides itself with its affiliations with numerous professional organizations.  As a member of the Professional Association for SQL Server (PASS), we participate in SQL Saturday training events for learning, networking, sharing best practices and as a sponsor.  In the recent SQL Saturday event in Tampa, two of our professionals were selected as speakers.  To request a copy of a presentation, click on the presenter’s name.

SELECT job FROM firm WHERE hired = ‘Yes’:  A look into what recruiters really want to see
Presented by Todd Davis, Operations Manager for CCG.  Davis is responsible for recruiting and hiring some of the industry’s top tier BI Consultants. He is a graduate of the University of Florida and has been instrumental in the placement of more than 1,000 professionals over a ten-year period. Davis regularly gives talks at several colleges and professional groups.

In his presentation, Davis advises what hiring managers really want to see throughout the hiring process. The session walks through the basics that every successful candidate should know: Resume tips, Job search and Interview tips, and more. If you are in a job search, considering one or just want to be prepared for one, the information he shares is what “they” are really looking for.

Lookup Between The Lines is Data Late Than Never:  Strategies in ETL processing
Presented by James McAuliffe, BI Solution Architect for CCG.  McAuliffe has been working as a professional software developer since 1993, and has worked with clients of all sizes, from local businesses to Fortune 500 companies. He has concentrated in the last few years on Microsoft BI technologies. In his current speaking engagements, McAuliffe is excited to share  the new capabilities that SQL Server 2008 brings to the information professional.

In this presentation, McAuliffe discusses how fully cached look-ups are fit for performance in ETL processing. These types of look-ups use a query to pull a limited data set into the SSIS memory cache; then, in processing, an exact match is made on look-up values to provide the match look-up value.  The challenge is when needing to match more than one value, or between look-up types. It is possible, and this session will examine some solutions.  McAuliffe also talks about making allowances for missing data when running ETL processes, strategies for late arriving dimensions and late arriving facts.

SSIShare The Code, Man:  Applying shared code sources to SSIS processing
Also presented by James McAuliffe.  In this session, McAuliffe discusses how, for may SSIS scenarios, a desired outcome is to implement logic or rules that are already in use in existing enterprise applications. The only significant difference is that the implementation is done in a bulk data loading scenario. Many times the logic being applied is complex and multi-step and enterprises have proprietary rules systems that need consistent application throughout the code base. McAuliffe examines a scenario where complex logic from shared code sources can be applied in SSIS processing.

For more information about PASS, SQL Saturday or our speakers, please contact info@ccgBI.com.

Latest CCG White Papers:

Insultating Your Organization From Tough Economic Conditions –  What will it take to endure the changing economic climate? Whether you believe a double-dip recession is upon us or that the 2008 – 2009 downturn never ended, it’s tough for businesses to escape economic turmoil totally unscathed.  How are you getting visibility into financial and operational performance?

Dos and Don’ts: Building Your Business By Building Your Business Intelligence —   How can you make sure your organization’s BI project doesn’t fail like many others? BI is a perpetual, evolving practice – a vision and strategy built upon an organization’s goals and operations. But having just any BI solution within an organization is not enough.