Skip Main Navigation
Page Content
This event has ended

Integration Services Back to Basics & Introduction to DAX

Puerto Rico Professional Association for SQL Server

Thursday, October 25, 2012 from 6:15 PM to 9:00 PM (AST)

Integration Services Back to Basics & Introduction to...

Ticket Information

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

Who's Going

Loading your connections...

Share Integration Services Back to Basics & Introduction to DAX

Event Details

 

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.

Have questions about Integration Services Back to Basics & Introduction to DAX? Contact Puerto Rico Professional Association for SQL Server

When & Where


Microsoft Puerto Rico

Guaynabo, PR 00968
Puerto Rico

Thursday, October 25, 2012 from 6:15 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.