La próxima reunión de la Asociación de Usuarios Profesionales de SQL en Puerto Rico (PRPASS), será este próximo jueves 3 de noviembre. Los tópicos elegidos para esta reunión son relacionados al mundo de Inteligencia de Negocios: “Introduction to SQL Server Analysis Services 2012 BI Semantic Model” y “Power View and Reporting Enhancements in SQL Server 2012”. Estos temas serán presentados por mis compañeros de Nagnoi, Inc. Joralis Sanchez y Guillermo Caicedo respectivamente quienes vienen trabajando con SQL Server “Denali” desde hace algunos meses y van a compartir sus experiencias con la audiencia.
www.prpass.org
www.facebook.com/prpass
Como ven, ambos temas nos siguen preparando para lo que se viene en SQL Server 2012 que según Microsoft, se espera que sea lanzado durante la primera mitad del próximo año. Si están en Puerto Rico, no se pueden perder este evento, corran la voz y nos vemos ahí!
Cuándo y dónde:
- Fecha: Jueves 3 de Noviembre del 2012
- Hora: 6:15pm a 9pm
- Lugar: Microsoft Puerto Rico (ver mapa)
Agenda:
- 6:15pm – 6:30pm: Registro / networking
- 6:30pm – 7:30pm: Introduction to SQL Server Analysis Services 2012 BI Semantic Model
- 7:30pm – 7:45pm: Receso, anuncios, etc.
- 7:45pm – 8:45: Power View and Reporting Enhancements in SQL Server 2012
- 8:45pm – 9pm: Comentarios de cierre / sorteos.
Temas:
Introduction to SQL Server Analysis Services 2012 BI Semantic Model (BISM)
Level: 200 (Intermediate)
Audience: IT Professionals | BI Developer
The BI Semantic Model (BISM) is a relational (tables and relationships) model with BI artifacts such as hierarchies and KPIs. It unifies the capabilities of SMDL models with many of the sophisticated BI semantics from the UDM. BISM has been introduced in Analysis Services 2012 with the Tabular Mode. Instead of replacing UDM, it expands and enhances the analysis methods that we know today. It allows users with relational modeling skills to create analytical solutions at ease to get faster results.
Join this session to learn the benefits of SSAS Tabular Mode and how to create and configure tabular models, calculations, measures, hierarchies, KPIs and more.
Speaker: Joralis Sánchez
Consultant | Nagnoi, Inc.
Speaker Profile: Joralis Sánchez is a Business Intelligence Consultant at Nagnoi, Inc., where she has been involved in developing a collaborative business intelligence solution for banking, as well as an analytics system for hospitals using SQL Denali and the new Tabular Mode. Her expertise also includes advanced visualization with SharePoint’s Visio Services, ETL development using SQL Server Integration Services, and reports development using SQL Server Analysis Services and SQL Server Reporting Services.
Joralis also has experience developing custom, web-based solutions and mobile applications. Before Nagnoi, she worked as a software developer in the IT Department of Medtronic Puerto Rico in Juncos, PR. Miss Sánchez holds a bachelor’s degree in Computer Engineering from the University of Puerto Rico, Mayagüez Campus, and recently became a fitness instructor.
Power View and Reporting Enhancements in SQL Server 2012
Level: 200 (Intermediate)
Audience: IT Professionals | BI Developer
Power View (code named "Project Crescent") provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Code-Named “Denali” Analysis Services (SSAS) instances.
Come join us and see an overview of Power View in action and other interesting reporting enhancements coming in the new version of SQL Server.
Speaker: Guillermo Caicedo
Consultant | Nagnoi, Inc.
Speaker Profile: Mr. Guillermo Caicedo 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 five years of experience as Business Intelligence and applications developer in the healthcare industry, specifically within the pharmacy benefits management processes, regulations and standards. He is a Microsoft Certified Professional in Microsoft SharePoint 2010 and his experiences include Data Warehousing implementations, ETL development using SQL Server Integration Services, metadata modeling and reporting using SQL Server Analysis Services, IBM Cognos and SQL Reporting Services, respectively. Mr. Caicedo has also extensive experience developing comprehensive web-based and mobile solutions.
