OC SQL Data Platform

Welcome to BIG PASS Community

  • We meet at the Del Taco Headquarters in their training room on the ground floor  |  25521 Commercentre Dr, Lake Forest, CA 92630 
  • We start mingling around 6:30, start the presentation at 7:00 and head to Los Cabos Cantina for drinks around 8:30

March 8th

Anday Nakamura will be presenting: A Beginners Adventure into Reporting Services 2017 and PowerBI Reporting

April 12th

No Meeting as SQLSaturday Orange County at Golden West College in Huntington Beach is 2 days later on the 14th.  Check out the Pre-Cons on the 13th!

May 10th

Speaker and Topic to be announced soon.


Do you have any events to share? If you do, send them to Ted Stathakis.


 

Next Meeting

Thursday,

February

13

Feburary 2014 Meeting - Speaker Brent Greenwood

  • In-Person @ 25521 Commercentre Dr. Lake Forest, California, United States (map)
  • 18:30 - 21:00 (UTC-08:00) Pacific Time (US & Canada)
  • Language: English

We are really looking forward to our next meeting. I hope you are too. If you can make it, please RSVP here.

Agenda

6:30 PM - Networking and a bite to eat. (Our sponsor this month is Pyramid Analytics.)

7:00 PM - Announcements

7:15 PM - Brent Greenwood will be presenting on DW ETL Design Patterns with SSIS 2012

7:45 PM - Break

7:55 PM - Mickey Stuewe will present on why and how to use business cards to further your networking skills

8:15 PM - Brent Greenwood will be presenting on Power Pivot Prototyping

8:45 PM - Raffle and wrap up (Bring a new person to the meeting and you both get an extra raffle ticket.)

9:00 PM - For those that are interested, we'll head over to the District for more networking and socializing (NOTE: This activity is a non-sponsored part of the meeting.)

Abstracts below

You do not need to bring a paper ticket to the event. The registration is to obtain a head count for the size of the room and for how much food needs to be purchased. Please unregister by Wednesday if you know that you won't be able to make it. Thank you.

 
Please contact Mickey Stuewe if you have any questions.

 

Featured Presentation:

DW ETL Design Patterns with SSIS 2012

Brent Greenwood, Senior BI Engineer / DBA Altegris Investments

Data volumes aren't getting any smaller and DW processing windows aren't getting any larger. Improvements in SW and HW are helping, but poor designs can still derail your ETL processes and throw a big wrench in the analytic environment works. This session will be a showcase of DW ETL design patterns and best practices implemented in SSIS2012. We'll cover common challenges in DW & Data Integration and options for addressing these. Specific topics will include extract techniques, loading techniques, and dimension & fact processing patterns. And along the way, we'll highlight several of the new features in 2012.

About Brent:
Brent Greenwood, MS, MCITP, CBIP, is a PowerPivot junkie and long-time Microsoft BI Pro with 13+ years of experience in the data analysis, data warehousing, and business intelligence crafts. He's delivered solutions and worn lots of different hats in a variety of verticals, including Investment Management, Brokerage, Insurance Services, Healthcare, and Higher Education. Most importantly, Brent is a cycling enthusiast and loves riding and building prototypes with AdventureWorks cycling data.

Power Pivot Prototyping

Brent Greenwood, Senior BI Engineer / DBA Altegris Investments

In Data Analytics and BIDW efforts, prototyping and proofs-of-concept are great light-weight methods for gathering requirements, getting early feedback and validating assumptions with minimal effort. With Power Pivot, we have an exceptionally powerful platform for this. In this session, we'll cover the "why" of prototyping & discuss several scenarios where it can be extremely powerful for a variety of roles: Business / Data Analysts, BI Developers, DW Modelers, ETL Developers and BIDW Architects. Then, we'll walk through the "how" via a quick POC and a more functional Prototype in Power Pivot to demonstrate its agility and speed. Along the way, I'll share tips and tricks, as well as real-world success stories. And we'll wrap up by addressing some prototyping challenges and common sources of resistance and fear in BI/DW circles.

About Brent:
Brent Greenwood, MS, MCITP, CBIP, is a PowerPivot junkie and long-time Microsoft BI Pro with 13+ years of experience in the data analysis, data warehousing, and business intelligence crafts. He's delivered solutions and worn lots of different hats in a variety of verticals, including Investment Management, Brokerage, Insurance Services, Healthcare, and Higher Education. Most importantly, Brent is a cycling enthusiast and loves riding and building prototypes with AdventureWorks cycling data.

How to use business cards to further your networking

Mickey Stuewe, Sr. Database Developer Quick Bridge Funding

We'll discuss why everyone should carry business cards to networking events. We'll also talk about what information you should put on your business card and how to increase the chances that it will be kept by the person you gave it to.

About Mickey:
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQL Saturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.

Upcoming Speakers

March 2018 - Andy Nakamura   |  SSRS 2017 and PowerBI

April 2018  - SQLSaturday on the 14th and pre-cons on the 13th

May 2018 - One of our SQLSaturday 2018 speakers!

June 2018 - You?!

If you would like to speak for us, please contact the chapter leader, Ted Stathakis.

 

PASSChapterLogo.jpg


Sponsors



 

sql_micro_sm.gif

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids