Integration Services Back to Basics & Introduction to DAX
Thursday, October 25, 2012 from 6:15 PM to 9:00 PM (AST)
PRPASS October Meeting
SSIS Back to Basics & Introduction to DAX
Come and join your Puerto Rico PASS users community group to learn and share about SQL Server.
Integration Services Back to Basics
Level: 100 (Beginner)
Audience: IT Professionals
You’ve read and heard about SQL Server Integration Services and now have a use for the technology. But every time you try to learn more about SSIS you hit an obstacle. On this session, we will teach you what SSIS is about. You can use SSIS to : perform ETL (Extract, Transform, and Load) operations, transfer data, copy database objects, perform FTP operations and work with files. SSIS is built to perform data integration, assist with database administration, and facilitate business intelligence. Data integration consists primarily of moving data from Point A to Point B; or from some source to some destination. The sources and destinations can be databases, but they do not have to be databases. We will go step-by-step in constructing a simple SSIS Package and explain some of the more advance containers to fully utilize all the power that SSIS has.
Speaker: Jose Rivera
Consultant – Nagnoi, Inc.
Mr. José Rivera has more than 10 years of work experience in Information Technology. Currently working on a Datawarehouse project for a large retail chain, using Business Intelligence for Forecasting Sales and Purchases for their chain of stores. Other experience includes Datawarehouse and development of applications for the public sector, database integration for Web solutions and development and maintenance of solutions for Microsoft ERP Systems (Solomon). Mr. Rivera is certified as Microsoft Certified IT Professional (MCITP) in Business Intelligence and Microsoft Certified Technology Specialist (MCTS) in PerformancePoint and Sharepoint. Visit his blog at http://joetechramblings.wordpress.com
Introduction to Data Analysis Expressions (DAX)
Level: 200 (Intermediate)
Audience: IT Professionals
Data Analysis Expressions (DAX) is a formula expression language used to define calculations in PowerPivot for Excel workbooks and Analysis Services tabular model projects authored in SQL Server Data Tools. DAX enable the creation of powerful calculations to enrich your analytic models. Join this session to learn the basics of DAX and star your road to mastering PowerPivot and Analysis Services Tabular.
Speaker: Alan Koo
Senior Consultant – Nagnoi, Inc.
Alan Koo is a Senior Consultant at Nagnoi, Inc.specialized in Performance Management and Business Intelligence. With more than 12 years of experience, Mr. Koo has consulted for top companies in the public and private sectors in and outside of Puerto Rico. Mr. Koo is the co-founder and current President of our SQL Chapter, PRPASS. He was awarded as Microsoft Most Value Professional (MVP) in SQL Server from 2008 to 2011. Mr. Koo is a thought leader who enjoys sharing his experiences through his blog (www.alankoo.com) and presenting in different events for universities, user groups and different associations such as IIBA, SQL PASS Latam, TechNet, and MSDN.
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.