PRPASS February 2014 Meeting
Thursday, February 27, 2014 from 6:30 PM to 9:00 PM (AST)
Guaynabo, Puerto Rico
San Francisco, California
London, United Kingdom
Come and join your Puerto Rico PASS user group to connect, learn and share about SQL Server.
Microsoft Puerto Rico (Click here for a map)
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, PR 009
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)
When & Where
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.