Introduction to SSIS with BIML & Power BI First Look!
Thursday, September 26, 2013 from 6:00 PM to 9:00 PM (AST)
Guaynabo, Puerto Rico
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 00968
Introduction to SSIS with BIML
Level: 200 (Intermediate)
Audience: IT Professionals
Do you ever find yourself repeating the same steps over and over while developing ETL packages? BIML is an XML markup language that automates your BI patterns and reduces the manual repetition that consumes most of your time. In this session we will learn the basics of BIML scripting and use the tools BIDS Helper provides to create a simple SSIS package using BIML.
Speaker: Guillermo Caicedo
Consultant – Nagnoi, Inc.
Guillermo is an active member and alumni of the Professional Association of SQL Server (PASS) and PRPASS. He currently works as a Consultant at Nagnoi, Inc. and has more than six years of experience as Business Intelligence and applications developer. He is a Microsoft Certified Professional in Microsoft SharePoint 2010 and SQL Server 2012. His experiences include Data Warehousing implementations, ETL development using SSIS, metadata modeling and reporting using SSAS, Cognos and SSRS respectively. Mr. Caicedo has also extensive experience developing comprehensive web-based and mobile solutions.
Introducing Power BI
Level: 100 (Beginner)
Audience: IT Professionals
A couple of months ago Microsoft disclosed Power BI for Office 365. Power BI allows power users and business analysts to easily search, discover, and access data within and outside your organization and, with just a few clicks, shape and transform data. Analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device.
In this session you will learn how through Power BI you and your customers will have access to this full set of self-service BI capabilities for on-premises and cloud-based environments.
Speaker: Ramon Ponte
Ramon has over 16 years of experience delivering enterprise architecture and advisory services to medium and large size organizations in Puerto Rico, the Caribbean and Central America. Industries of expertise include government, education, financial services, insurance, and the telecommunication sector. As part of his current role, one of Ramon’s main responsibilities consists on helping organizations understand how through technological solutions they can achieve their most challenging business and organizational goals. In Microsoft, Ramon’s area of specialization is Enterprise Application Platforms. This includes, but is not limited, to basic operating system application infrastructure, system architectures, development, application lifecycle management, business intelligence, data management, service oriented architectures and business process management solutions.
When & Where
Puerto Rico Professional Association for SQL Server
The 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.