SQL Sat #294 PreCon Analytics Without Limits: Modern BI Architecture
Friday, June 6, 2014 from 8:00 AM to 4:00 PM (EDT)
San Francisco, California
London, United Kingdom
Noted author and Micosoft SQL Server MVP Stacia Misner, and Big Data Architect Joey D'Antoni present this pre-con convering big data and its integration with the Microsoft BI stack.
The traditional enterprise data warehouse has been around a long time, and it isn’t going away anytime soon. However, the influence of big data, cloud computing, and in-memory analytics have changed the scale and approach to business analytics. Microsoft is heavily invested in Big Data through its partnership with Hadoop vendor HortonWorks, HDInsight (its Hadoop as a Service offering in Azure) and the Power BI stack which integrates tightly to provide rich visualization and analysis from an array of data sources.
In this preconference workshop, you will learn the basics of Hadoop, both with MapReduce and Yarn (Hadoop 2.0). In addition to learning the architecture of these solutions, you will gain understanding of how to interact with them by using a variety of tools, such as Pig, Hive, and Sqoop. You will learn to refine data from a variety of data sources, and gain an understanding of modern data analytic architectures such as columnstore indexes and In-Memory tables, that allow for near real-time analytics of very large volumes of data.
Also in this workshop, you will learn core analytical techniques using statistics, distributions, and correlations. In addition, you will learn techniques for using data visualizations as part of the analytical process, and specifically how to create rich visualizations using the Power BI toolset. Last you will see how results can be shared across your organization by using Office 365 SharePoint Online, and explored with Power Q&A.
When & Where
Philly SQL Server User Group
The Philadelphia SQL Server User Group (PSSUG) is a community of SQL Server database professionals, specializing in DBA, Database Development, and Business Intelligence topics. We meet monthly in different locations throughout the Greater Philadelphia and South Jersey area. PSSUG is an Official PASS Chapter. We welcome you to visit our web site and to join our email list by sending an email to firstname.lastname@example.org or joining the PSSUG group on www.Linkedin.com