Skip Main Navigation
Page Content
This event has ended

PRPASS February 2014 Meeting

Puerto Rico Professional Association for SQL Server

Thursday, February 27, 2014 from 6:30 PM to 9:00 PM (AST)

Guaynabo, Puerto Rico

PRPASS February 2014 Meeting

Ticket Information

Ticket Type Sales End Quantity
Free Admission Ended Free  
Donation Admission Ended

Who's Going

Loading your connections...

Share PRPASS February 2014 Meeting

Event Details

Come and join your Puerto Rico PASS user group to connect, learn and share about SQL Server.

WHERE:
Microsoft Puerto Rico (Click here for a map)
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, PR  009

TOPICS:

Power and Simplicity using Tables for Numbers, Dates, and Times

In this session we will explain how many queries can be made simpler with pre-built tables for numbers, dates, and times.  These tables simplify aggregations and groupings involving numeric ranges and time periods, aid in gap analysis, and allow clever ways to implement certain algorithms – all without having to resort to procedural code.  Examples include identifying the number of business days between two dates, grouping data by weeks and quarters, parsing strings of comma-separated numbers, and identifying missing numeric values in a table.  We will present these and other examples and show how these tables may be designed and populated.

Speaker:  Adolfo Socorro
President – eSOLUTIONS, Inc.

 
Adolfo Socorro, Ph.D., has more than 15 years of experience in developing software solutions for public and private organizations.  He has been a project leader for many successful projects that have involved mobile and web technologies, data analysis, business intelligence, data warehouses, reporting, and data integration.  He holds advanced degrees in computer science and is a Microsoft Certified Professional.

Automating the Data Cleansing process with DQS and SSIS

The quality of data becomes more important every day, this is why having a system to automate these tasks is vital to every business. In this session we will be showing how to automate these tasks for data cleansing, de-duplication and exporting domains to Excel.

Speaker:  Jose L. Rivera
Consultant – Nagnoi, LLC

Jose L. Rivera is a consultant for Nagnoi LLC specialize in the design, development and implementation of Business Intelligence solutions with special emphasis on systems data integration and ETL plus extensive experience in the development of reports/dashboards using tools such as IBM Cognos and Microsoft BI. José L., shares his knowledge on his blog (sqlconqueror.com), his passion for education as Online Faculty at University of Phoenix and his commitment with the community as Chapter Leader for the Global Spanish Virtual Chapter (globalspanish.sqlpass.org), member of the board of Puerto Rico PASS (prpass.org) and Webmaster for the Azure PASS VC (azure.sqlpass.org)

Have questions about PRPASS February 2014 Meeting? Contact Puerto Rico Professional Association for SQL Server

When & Where


Microsoft Puerto Rico
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, Guaynabo 00968
Puerto Rico

Thursday, February 27, 2014 from 6:30 PM to 9:00 PM (AST)


  Add to my calendar

Organizer

Puerto Rico Professional Association for SQL Server

Puerto Rico Professional Association for SQL Server (PRPASS) is a volunteer organization founded in 2005 with the main objective of providing a learning, networking and collaboration Information Technology (IT) users community for SQL Server professionals. PRPASS is the local Chapter affiliated to PASS, the largest community of SQL Server users in the world.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.