Welcome to the Quad Cities PASS Chapter (QCPASS)

QCPASS is a SQL Server User Group in the Quad Cities area (Davenport & Bettendorf, IA and Rock Island & Moline, IL and the surrounding area).  We meet monthly, typically on the 2nd Wednesday of the month.  Meetings are always FREE and food will typically be provided.  Please come be a part of our local community! 

Time:           5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:     201 N Harrison St (4th Floor)
                   Davenport, IA

Parking:     Parking Ramp      - enter from Harrison St (.75/hr)
                 Parking Ramp      - enter from Harrison St (south side, no gate, FREE)
  On street parking - FREE after 5:00 PM

If you would like to be on our email list, please join our chapter by registering for a free PASS membership at http://www.sqlpass.org and adding our chapter to your myChapters page.  Please also check back here at the website for details!

Speakers and sponsors please contact us from our "About Us" page.

 

 


 

Wednesday, April 15, 2015 - onsite

 

Topic:       Getting Started with Microsoft Azure

From the ground up, getting your first VMs up and running with all the desired infrastructure.  Coming into the portal for the first time is daunting, where to begin?  What should you do first?  This session takes you from a new subscription up to running your first virtual machines and the basic setup in between.  This is especially for those new to the "cloud".

Speaker:  Elliott Whitlow          

Elliott has worked in IT since the late 80's and started off programming in BASIC, in the early 90's he got his first taste of databases and has been at it since.  He has over 20 years of experience with programming and administration of databases and over 25 years of programming and other systems experience.  He has worked for small companies, medium companies, all the way up to a VERY large bank and the Department of Defense. He is currently working for Alteso LLC a company specializing is remarketing of wrecked, recovered, salvaged, and leased vehicles.

RSVPs are appreciated so we know how much food to order - just click on the big red button below.




 

Wednesday, May 13, 2015 - onsite

 

Topic:       Building Metadata Driven ETL Solutions with BIML

ETL development can consume a significant portion of time in Data Warehousing initiatives.  It can also be very cumbersome to change ETL patterns across a large number of objects.  This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.

Speaker:  Dave DuVarney & Rob Long

Dave DuVarney is President and Co-Founder of Talavant.  Dave has delivered numerous business intelligence projects in both a technical and functional leadership role.  Dave's latest technical focus has been on the Microsoft Business Intelligence tools including Analysis Services 2012, Integration Services 2012, BIML, Reporting Services and PowerPivot.  Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives.  This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum.

Rob Long is Chief Architect and Co-Founder of Talavant. Rob is passionate about developing solutions that improve the delivery of data warehousing and business intelligence solutions.  He has a breadth of experience including development, network administration and database administration.  For the last 8 years, Rob has focused his efforts on delivering solutions on the Microsoft BI stack.  He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.

RSVPs are appreciated so we know how much food to order - just click on the big red button below.





 

Wednesday, June 10, 2015 - onsite

 

Topic:      TBA

Speaker:  TBA         

RSVPs are appreciated so we know how much food to order - just click on the big red button below.

Eventbrite - QCPASS Meeting - June 10, 2015



 

Wednesday, July 15, 2015 - onsite

 

Topic:       Forensic Analytics with PowerPivot for Excel

Despite the wealth of analytical technologies available today, 65% of occupational fraud at public companies is detected through tips, management review, or simple accidents. Forensic analytics can change this disappointing scenario by employing a combination of human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

In this session, we explore forensic analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of forensic analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to effectively and confidently ferreting out data anomalies, and outline a methodology to meet key principles by applying a standard, repeatable process to forensic analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive forensic analytics via various tests and reviews.

Speaker:  William E. Pearson III

Bill Pearson, SQL Server Analysis Services Maestro, SQL Server MVP, CPA, CITP, CGMA, CMA, CIA, MCDBA, MCSE, is a consultant, author, mentor and business intelligence architect who has been working with business intelligence for over 18 years, and with the integrated Microsoft Business Intelligence solution since its inception. Bill has been awarded the Microsoft Most Valuable Professional designation multiple years for his technical experience implementing Microsoft BI, as well as his contributions to the community as an author and speaker. Bill’s recent series’ include the Stairway to MDX and Stairway to PowerPivot and DAX columns at SQLServerCentral.com, and he presents regularly at SQL Saturdays and other diverse events worldwide. Bill is a member of the Boulder BI Brain Trust.


RSVPs are appreciated so we know how much food to order - just click on the big red button below.


 


 

PASS Business Analytics Conference 2015

 

Get $150 Discount using our chapter code USSE25

 

 



PASS Summit 2015


Get $150 Discount using our chapter code:  LC15WCH6


This discount code cannot be combined with any other PASS Summit 2015 discount and cannot be applied retroactively to an existing registration.

Registration rates go up after April 19.  Register soon for the best possible rate.

Save on accommodations by registering with PASS' partner hotels when registering for the summit.


 


O'REILLY User Group Offer

 

Receive a 35% discount on Wiley ebooks.  Use code DSUG35 when placing an order online at oreilly.com.

                                     

 


Microsoft Press - Free ebook: Introducing Microsoft SQL Server 2012

Friends, the final and complete version of Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now ready as a free download! You can download the PDF version of this title here (288 pages; 10.8 MB).  The EPUB is here, and the MOBI is here.

If you prefer a hard copy of the book, you can order it here for $14.99.

We are releasing this title to help you learn about the new features and capabilities in SQL Server 2012, which Microsoft released to manufacturing (RTM) on March 6, 2012. You can expect general availability of the product to begin on April 1, 2012.

Please help us share the news about this ebook. And enjoy!

 


 

Next Meeting

Wednesday,

May

13

QCPASS Meeting - May 13, 2015

  • In-Person @ 201 N Harrison St, Suite 600 Davenport, Iowa, United States (map)
  • 17:30 - 20:00 UTC
  • Language: English


Topic:       Accelerating ETL Development with BIML

ETL development can consume a significant portion of time in Data Warehousing initiatives.  It can also be very cumbersome to change ETL patterns across a large number of objects.  This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.

 

Speaker:  Dave DuVarney & Rob Long

 

Dave DuVarney is President and Co-Founder of Talavant.  Dave has delivered numerous business intelligence projects in both a technical and functional leadership role.  Dave's latest technical focus has been on the Microsoft Business Intelligence tools including Analysis Services 2012, Integration Services 2012, BIML, Reporting Services and PowerPivot.  Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives.  This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum.

Rob Long is Chief Architect and Co-Founder of Talavant. Rob is passionate about developing solutions that improve the delivery of data warehousing and business intelligence solutions.  He has a breadth of experience including development, network administration and database administration.  For the last 8 years, Rob has focused his efforts on delivering solutions on the Microsoft BI stack.  He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.


Time:        5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:   201 N Harrison St (4th Floor)
                   Davenport, IA

Parking:    Parking Ramp      - enter from Harrison St (.75/hr)
                   Parking Ramp      - enter from Harrison St (south side, no gate, FREE)
      On street parking - FREE after 5:00 PM

 

Featured Presentation:

Accelerating ETL Development with BIML

Dave DuVarney, Consultant SolidQ

Accelerating ETL Development with BIML

About Dave:
Dave DuVarney is an independent business intelligence consultant and trainer. He has broad technical and functional BI knowledge and has worked with organizations across the full BI life cycle. Dave has helped clients establish their BI program and run Agile development teams. He specializes in SQL Server Analysis Services, Integration Services, and Reporting Services as well as .NET development.