SQL Server 2014 In-Memory OLTP and Multidimensional Models with Analysis Services
Thursday, July 17, 2014 from 6:30 PM to 9:00 PM (AST)
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
SQL Server 2014 In-Memory OLTP Migration Overview
Are you considering migrating to SQL Server 2014? Are you aware of the advantages of the In-Memory OLTP features for your application workload? In this session we will make an overview of the In-Memory OLTP features and explore possible migration scenarios that can help you understand what the perfect fit is for you. We will demonstrate how you can analyze and implement this new technology to your existing applications and gain the wanted performance without event changing you application code.
Speaker: Jose L. Rivera
Consultant – Nagnoi, LLC
Jose L. Rivera (@SQLConqueror) is a seasoned data professional, speaker, SQL Server MVP and community leader working as Consultant for Nagnoi LLC. Jose L specialize in the design, development and implementation of Business Intelligence solutions with special emphasis on systems data integration and enhanced data visualizations using Microsoft BI tools. He shares his knowledge and experience on his blog (sqlconqueror.com) and throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC) and board member of the Puerto Rico PASS (prpass.org)
Developing Multidimensional Models using Analysis Services 2014
Building up solid basis for your enterprise Business Intelligence solution
Analysis Services is the center piece of any robust Microsoft BI solution. Now, Analysis Services comes in many flavors, embedded in Excel, Sharepoint, Office 365, Tabular and Multidimensional models. This session will be focus on Multidimensional models aka as OLAP, the most enterprise and scalable of all of their flavors. Analysis Services Multidimensional was initially released in 2005 in its modern version, and from that time to now, is very well positioned in the Gartner Magic Quadrant as the leader for Business Intelligent OLAP solutions.
During this demo oriented session, we will be discussing the advantages and limitations of multidimensional models while demoing step by step model creation and deployment. Participants will learn:
- How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis Services project within SQL Server Data Tools.
- How to view cube and dimension data by deploying the Analysis Services project to an instance of Analysis Services, and how to then process the deployed objects to populate them with data from the underlying data source.
- How to define calculations using MDX, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
- Querying multidimensional models using Excel and Reporting Services.
Speaker: Alan Koo
Senior Consultant – Nagnoi, LLC.
Alan Koo is a Senior Consultant at Nagnoi, LLC. 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 of PRPASS. He was awarded as Microsoft Most Value Professional (MVP) in SQL Server from 2008-2011 and 2014. 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.