This event has ended

SQL Server 2014 In-Memory OLTP and Multidimensional Models with Analysis Services

Puerto Rico Professional Association for SQL Server

Thursday, July 17, 2014 from 6:30 PM to 9:00 PM (AST)

Guaynabo, Puerto Rico

SQL Server 2014 In-Memory OLTP and Multidimensional...

Ticket Information

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

Who's Going

Loading your connections...

Share SQL Server 2014 In-Memory OLTP and Multidimensional Models with Analysis Services

Event Details

Come and join your Puerto Rico PASS user group to connect, learn and share about SQL Server.

WHERE:
Microsoft Puerto Rico (Click here for a map)
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, PR  009

TOPICS:

 

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.

Have questions about SQL Server 2014 In-Memory OLTP and Multidimensional Models with Analysis Services? Contact Puerto Rico Professional Association for SQL Server

When & Where


Microsoft Puerto Rico
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, Guaynabo 00968
Puerto Rico

Thursday, July 17, 2014 from 6:30 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.