SQLSaturday #463 - Costa Rica BI Edition 2015
Event Date: 11/21/2015 00:00:00
Event Location:
- Home - Hotel Bougainvillea
- Santo Tomas, Heredia
- Santo Domingo, Heredia, Costa Rica
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Dimensional Modeling Design Patterns: Beyond the Basics
Abstract: Dimensional modeling is one of cornerstones of successful business intelligence (BI) initiatives. Even with new technologies such as PowerPivot and SQL Server Analysis Services (SSAS) tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model can also help to ensure that your data warehouse or data mart is responsive and can accommodate emerging requirements.
This session dives deeper into the art of dimensional modeling. We look at how and when to create different types of fact and dimension tables, including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After this session, you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to this interactive and engaging session.
Speaker(s):
- Jason Horner
Track and Room: Multidimensional Modeling - Salon Principal
Title: Power Query para Power BI: De Cero al [M]#225;ximo
Abstract: Power Query is a free add-in created by Microsoft for Excel 2010 (or later) and also for the Power BI Designer. It’s an intuitive tool that lets you manipulate, transform, consolidate, enrich, merge and do much more with your data. It also acts as an ETL tool which means that it Extracts data from almost any data source, Transforms that data somehow and then Loads it somewhere – in our case that’s either Excel, Power Pivot or the Power BI Designer canvas.
In short, this is THE best Data tool for the Business User.
In this session you’ll learn the basics of this tool and how some things are even easier with this tool than with something like SSIS.
Speaker(s):
- Miguel Escobar
Track and Room: BI Information Delivery - Salon Principal
Title: Using big data to drive U.S. healthcare reform
Abstract: A big-data revolution is underway in healthcare. Over the past decade payers and providers have been digitizing patient records into medical databases, including data from patients covered under private and public insurance programs. During this same timeframe technological advances have made it easier to collect and analyze information from different sources including payers, hospitals, laboratories and physician offices. In this session we will explore how McKinsey Healthcare Analytics manages and analyzes large databases with billions of records of highly sensitive information and produce market changing insights on the U.S. healthcare landscape. What are the challenges? How can we make sense of highly heterogeneous data? In what ways can we visualize the data to make it valuable?
Speaker(s):
- Pedro Huguet
Track and Room: Big Data / Internet of Things - Salon Principal
Title: S#250;base al Bus de la Inteligencia de Negocios y h#225;galo #161;#193;gilmente!
Abstract: Esta sesi#243;n esta orienta al aprendizaje del dise#241;o de cubos de informaci#243;n, responderemos las preguntas que probablemente sean las m#225;s importantes que enfrentan los Arquitectos, dise#241;adores, desarrolladores, especialistas de negocio y todos los involucrados en un proceso de BI #191;El c#243;mo empezar? #191;Qu#233; construir? #191;Por qu#233; construirlo? Y las m#225;s dif#237;ciles tambi#233;n… tales como #191;Por qu#233; NO hacer lo que el usuario CREE querer?, aprenda lo que no se debe hacer y porque no hacerlo. En esta sesi#243;n completamente conceptual mostrare la llave talvez m#225;s importante en un Proyecto de BI que har#225; su misi#243;n pertenecer al orgulloso grupo de proyectos #161;exitosos! No es un secreto el alto porcentaje de proyectos fallidos en el mundo as#237; que venga y sea parte del #233;xito.
Speaker(s):
- Ricardo Estrada
Track and Room: Multidimensional Modeling - Salon 2
Title: Inteligencia de Negocios aplicado para Proyectos de Desarrollo
Abstract: En esta sesi#243;n vamos a conocer las herramientas que tenemos disponibles para aplicar inteligencia de proyectos a nuestros proyectos de desarrollo, utilizando tecnolog#237;a en la nube. Esta sesi#243;n va orientada tanto para desarrolladores como administradores de proyecto que desean conocer datos anal#237;ticos sobre los diferentes proyectos de desarrollo.
Speaker(s):
- David Sánchez Aguilar
Track and Room: BI Information Delivery - Salon 2
Title: Advanced Spatial Analysis: Beyond Bubble Charts
Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!
Speaker(s):
- Jason Horner
Track and Room: BI Information Delivery - Salon Principal
Title: Iniciando con Stream Analytics
Abstract: Se conocer#225; acerca de la tendencia Stream Analytics, analizando c#243;mo podemos aplicarla en la vida real y c#243;mo la Nube contribuye al desarrollo de aplicaciones para an#225;lisis de datos.
Speaker(s):
- Keneth Murillo
Track and Room: Cloud Analytics - Salon 2
Title: Como aplicar Scrum a proyectos de BI
Abstract: La primera implementaci#243;n de Scrum, suele ser intimidante en proyectos de desarrollo, pero es abrumadora si adicionalmente vas a aplicarlo a un proyecto de BI. Por eso si has o#237;do hablar de Scrum, o si tu jefe ha o#237;do hablar de Scrum y quieres aplicarlo a BI, esta sesi#243;n te servir#225; para cumplir dos prop#243;sitos: Entender porque Scrum funciona como funciona; y ver como se ha aplicado de forma pr#225;ctica la metodolog#237;a en proyectos de BI.
Speaker(s):
- Javier Loria
Track and Room: Data Warehouse Architecture, Development Administration - Salon 2
Title: La receta de la abuela para mejores Cargas de Datos!
Abstract: En esta sesi#243;n veremos mejores pr#225;cticas para cargas de datos a ser utilizados en ETLs de alto volumen, veremos t#233;cnicas de carga y configuraci#243;n de la base de datos, uso de particiones, compresi#243;n, indexes columnstore y m#225;s. Esta receta estar#225; cargada de buenas demos, todas aprobadas por la abuela desde epocas que datan antes del windows 3.1!
Speaker(s):
- Alejandro Cordero
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Opciones de Mejora de Rendimiento para el Datawarehouse
Abstract: Utilizando T#233;cnicas de ColumStore Indexes, Particionamiento y Compresi#243;n de Datos para mejorar el rendimiento del Datawarehouse
Speaker(s):
- Carlos Rojas Vargas
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Introduciendo Azure Data Warehouse
Abstract: Se analizar#225; el impacto del Azure Data Warehouse en los entornos existentes. As#237; como ser#237;a una migraci#243;n hacia dicha tecnolog#237;a y los beneficios al hacerlo.
Speaker(s):
- César Oviedo
Track and Room: Cloud Analytics - Salon 2
Title: Introducci#243;n a BI con DATAZEN
Abstract: Con la incorporaci#243;n de Datazen dentro de los productos de BI de Microsoft se cuenta con nuevas capacidades para la creaci#243;n de Dashboards, en esta sesi#243;n veremos una introducci#243;n a la Arquitectura de Datazen Server y las formas de creaci#243;n de Dashboards as#237; como su consumo desde distintos dispositivos multiplataforma.
Speaker(s):
- Eduardo Castro
Track and Room: Data Warehouse Architecture, Development Administration - Salon 2
Title: Lo que debe saber un DBA sobre BI.
Abstract: Quien termina brindando soporte y mantenimiento a las distintas bases de datos en una soluci#243;n de inteligencia de negocio es el DBA. Qu#233; debe conocer un DBA sobre BI? Conozca cu#225;les habilidades necesita reforzar desde un enfoque de vida real.
Speaker(s):
- Adrian Miranda
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Muldimenional Data Base Design by means of BISM Tabular Models
Abstract: The main focus of this session is to explore general concepts and some specific topics, about the design and implementation of Multidimensional Data Bases, we will explore the design in two levels: 1 - Relational Data Base 2 - Analysis Services Tabular Data Base
All the topics will be developed with SQL Server 2014/2016
Speaker(s):
- Jose Mayorga
Track and Room: Multidimensional Modeling - Salon Principal
Title: Data Profiling (SSIS)- Herramienta #250;til para el perfilamiento de Datos
Abstract: En esta sesi#243;n veremos como sacarle provecho al Data Profiling de Integration Services, ya que es una poderosa tarea si conocemos sus caracter#237;sticas y funciones.
Speaker(s):
- Maristel Castro Montero
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Introducci#243;n a SSIS, lo que necesitas saber para iniciar a trabajar con SSIS
Abstract: Esta sesi#243;n es una introducci#243;n a los que es SSIS, para que sirve, en que se puede usar y las ventajas que tiene, sin dejar de lado las buenas practicas.
Speaker(s):
- Carlos A. Ulate Hernandez
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Dise#241;ando mi datawarehouse “Disaster recovery ready”
Abstract: Los datawarehouse son probablemente las bases de datos mas grande que vamos a encontrar en los sistemas. si alguna vez te has preguntado como dise#241;o mi datawarehouse de tal forma que en caso de desastre pueda recuperarlo rapidamente o si nunca te has hecho la pregunta, en esta sesi#243;n vamkos a discutir con base al esquema estrella la distribucion de files y filegroups anl igual que la utilizacion de tecnologias como inmemory OLTP para hacer mi datawarehouse “Disaster recovery ready”
Speaker(s):
- Kenneth Urena
Track and Room: Data Warehouse Architecture, Development Administration - Salon 1
Title: Como implementar una plataforma del Internet of Things con Azure
Abstract: En esta sesi#243;n se va a demostrar como se puede crear una plataforma del Internet de las cosas de manera practica tomando en consideraci#243;n aspectos comunes de contextualizacion, an#225;lisis y visualizaci#243;n de los datos de manera practica.
Por medio de una demostraci#243;n se va presentar un caso de uso practico en el cual se va a transformar datos en informacion recolectando datos de diferentes dispositivos
Speaker(s):
- Oscar Marin
Track and Room: Big Data / Internet of Things - Salon Principal
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Miguel Escobar
Twitter: - EscobarMiguel90
LinkedIn: Miguel Escobar
Contact: http://www.poweredsolutions.co/blog
Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He also holds the Microsoft MVP distinction and is a Microsoft Certified Professional.
Jose Mayorga
LinkedIn: Jose Mayorga
Data Warehouse/Business Intelligence (DW/BI) and Data Base (SQL Server) architect, consultant, lecturer. Teacher of post graduate courses in Computer Science.
Economist with a Master Degree in Computer Science, more than 15 years leading projects of DW/BI, Data Bases and IT management.
- DW/BI Architect and Consultant
- DW/BI Analysis, Design and Build, ETL, Data Quality, OLAP
- Data Base: administration, tunning, analysis amp; design, auditing, clustering, t-sql
Keneth Murillo
Twitter: - @kenethmurillo1
LinkedIn: Keneth Murillo
Contact: https://kmurillo.wordpress.com/
Consultor en Desarrollo de Software, conocedor de tecnolog#237;as basadas en la Nube y vanguardista entusiasta de las tecnolog#237;as Microsoft, Con conocimientos en las distintas plataformas Web, Escritorio, M#243;vil siempre aplicando las mejores pr#225;cticas y tecnolog#237;as del momento.
Ricardo Estrada
Twitter: - pricardo03@hotmail.com
Contact: http://SeHablaSQL
Soy Ricardo Estrada consultor y conferencista en temas relacionados con SQL, resido en Costa Rica, curioso por la tecnología y apasionado por las bases de datos y sistemas de BI, gusta de compartir conocimiento, buscar soluciones a problemas cotidianos y construir aplicaciones que faciliten las operaciones y decisiones a nivel empresarial, es orgullosamente speaker de los SQLSaturdays de Centroamérica desde el año 2014, además de participar como expositor en los Summit para España y Panamá. Mi primer contacto con SQL Server fue con la versión 2000 y no ha dejado de aprender trucos, metodologías, técnicas y estrategias nuevas… y desde entonces… las he compartido en diferentes posts, principalmente la página de fb: SeHablaSQL
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Carlos A. Ulate Hernandez
Twitter: - https://twitter.com/sql506
LinkedIn: Carlos A. Ulate Hernandez
Contact: http://www.sql506.com
Más de 12 años de experiencia en el análisis, desarrollo y soporte de aplicaciones y bases de datos, Ingeniero en Sistemas de la Universidad Fidélitas Costa Rica, Desarrollo de diferentes proyectos bancarios utilizando diferentes herramientas de Microsoft a nivel de BI y bases de datos, DBA/DBE para diversas compañias del mercado tecnológico. Chapter leader del capitulo local para PASS, Data Group Guanacaste, Parte del staff del capitulo virtual en español para PASS.
Pedro Huguet
Pedro holds an MBA from the Universidad de Costa Rica and a Bachelor Sc in Electronics Engineering from the Instituto Tecn#243;logico de Costa Rica. He has been coding in VB, SQL and other languages for the past 20 years. Currently works as a Data Specialist at Mckinsey Healtcare Analytics creating datamarts and tools to process and analyze medical claims data. Recent experience includes SQL, Talend and Big Data.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Eduardo Castro
Twitter: - edocastro
LinkedIn: Eduardo Castro
Contact: http://ecastrom.blogspot.com
Eduardo Castro, Microsoft Data Platform MVP and PASS Board of Advisor for LATAM, is well known LATAM SQL Server Expert and focuses on architecture, Business Intelligence and Data Analytics, Eduardo has an specialization and master degree in Data Analysis and Big Data. I have been speaker at PASS Summit delivering session about R and Data Science.
Eduardo Castro has presented in United States, Costa Rica, Colombia, Guatemala, Mexico, Panama, El Salvador and South Korea.
César Oviedo
Twitter: - @bi_latam
LinkedIn: César Oviedo
Contact: https://www.facebook.com/BusinessIntelligenceLatam
César Oviedo is a Data Platform MVP with more than 12 years of experience working in multidisciplinary projects running roles such as Scrum Master, Project Manager, BI Developer and DB Administrator. With experience leading teams and projects with more than 30 members. Currently focused on Data Science and Big Data platforms. Community Manager at “Business Intelligence LATAM” (BI PASS Chapter Leader for Costa Rica and PowerBI User Community), international speaker and trainer for Data and Cloud technologies.
Javier Loria
Twitter: - @JavierSQL
LinkedIn: Javier Loria
Contact: http://javiersql.wordpress.com/
Javier Loria es un experimentado Arquitecto de Software y Arquitecto de Inteligencia de Negocios, Desarrollador de BI, con un historial de Ingeniera de redes. Javier tiene más de 20 años de experiencia como Instructor Técnico, casi 30 años como desarrollador; 16 años como arquitecto de software y de inteligencia de negocios.
Carlos Rojas Vargas
Contact: http://sqlugcr.net
Carlos Rojas Vargas es Microsoft MVP en SQL-Server desde el año 2001 con 16 años consecutivos de obtener este reconocimiento, trabaja con SQL-Server desde el año 1995. A partir de 1999 se certifica como MCT y comienza a impartir Capacitación certificada Microsoft, actualmente trabaja como Consultor en SQL-Server, Windows Server, Virtualización con Hyper-V, Alta Disponibilidad y Soluciones de Colaboración con Sharepoint en Grupo CMA. En este momento cuenta con las certificaciones MCSA(SQL-Server 2012/2014), MCSA(SQL-Server 2008), MCITPro (Database Adm SQL-Server 2008), MCTS(Sharepoint 2010), MCTS(SQL-Server 2008), MCTS(Windows Server 2008 App Infrastructure), MTA, MCDBA, MCSD.NET, MCAD, MCSE, A+, N+. Fundador del Grupo de Usuarios de SQL CR.
Miguel Escobar
Twitter: - EscobarMiguel90
LinkedIn: Miguel Escobar
Contact: http://www.poweredsolutions.co/blog
Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He also holds the Microsoft MVP distinction and is a Microsoft Certified Professional.
David Sánchez Aguilar
Twitter: - @davidsancheza
LinkedIn: David Sánchez Aguilar
Contact: http://davidsanchezaguilar.wordpress.com
David S#225;nchez Aguilar, especializado en Tecnolog#237;as Microsoft. Cuenta con el reconocimiento de Microsoft Most Valuable Professional y con varias certificaciones como MCP, MCTS, MCITP, MCSD, Microsoft Specialist y Microsoft Certified Trainer. Es graduado de la carrera de Ingenier#237;a en Sistemas Computacionales y actualmente cursa una Maestr#237;a en Administraci#243;n de Tecnolog#237;as de la Informaci#243;n. Cuenta con m#225;s de siete a#241;os de experiencia trabajando con diferentes plataformas Microsoft.
Alejandro Cordero
Twitter: - @ale_corderocr
LinkedIn: Alejandro Cordero
Contact: http://sqlturbo.com
DBA with Over 10 years of experience. Focused on SQL Server development , performance tuning, High Availability. Scrum Master Certified, MCTS, MCSA, Entrepreneur and Author at SQLTurbo.com. Currently working as technical leader for database consultants in Pythian Company.
Regular speaker at SQLSaturdays in Latin America ( Costa Rica, Guatemala, Colombia) and virtual chapters( In-Memory chapter, Spanish Chapter). Have presented in SQLSaturday Ottawa in Canada.
Kenneth Urena
Twitter: - @sqlcr
LinkedIn: Kenneth Urena
Contact: http://www.sqlcr.com
Kenneth Ureña is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016.
Kenneth has performed the role of Database Developer, Database Architect and Database Administrator, always relying on his disaster recovery and performance tuning skills.
He co-leads the Global Spanish Virtual chapter of PASS. PASS LatAm Regional Mentor, he speaks at multiple SQL Server events in both Spanish and English. Kenneth holds multiple SQL server certifications.
Maristel Castro Montero
M#225;s de 5 a#241;os de experiencia en desarrollo de aplicaciones, y actualmente en Bussiness Intelligence. Conocimiento en Base de Datos, desarrollo en .Net, Web Services, asp.net.
Oscar Marin
Twitter: - https://twitter.com/marin_cr
Contact: http://blog.marin.cr
12 years of experience working for international and domestic markets in software, Business Intelligence and IT infrastructure projects, leading teams creating mission critical applications from its conception to production and support. Lead highly efficient multidisciplinary teams in diverse fields ranging in multiple industries such as Financial, Automotive, Consumer Goods, Life Sciences, Energy and Utilities, Hospitality and Government.
Adrian Miranda
Twitter: - @JMCJOSEAD
Profesional de datos con más de 15 años de experiencia en mercados financieros, seguros, retail, entre otros. Cuenta con amplia experiencia en la definición de arquitectura de base de datos, soluciones en la nube utilizando Microsoft Azure, ha participado en la definición de estrategias de alta disponibilidad, desastre y recuperación utilizando Microsoft Azure como plataforma y continuidad de negocios en general. Formó parte del equipo de soporte global en SQL Server para Microsoft, además, se desempeñó como consultor para un Microsoft Partner y ha sido conferencista para múltiples eventos relacionados con la comunidad de datos en LATAM.
Sponsors
The following is a list of sponsors that helped fund the event: