Getting Started with Microsoft Big Data, Hive & HDInsight Jump Start

This is the first of a three-Jump Start series tailored for architects and seasoned developers interested in a demo-heavy learning experience introducing Microsoft’s Big Data solution set. Microsoft Technical Evangelist Saptak Sen and Vice President of Consulting Services, Advaiya Inc Bill Ramos will start with setting up and loading data into Windows Azure storage and a Windows Azure HDInsight cluster. After covering Windows Azure Data Management concepts (e.g., SQL Machines, SQL Databases, Tables, Blobs), they will demonstrate using Hive to query Hadoop data using HiveQL commands and walk through how Hive leverages the entire Hadoop cluster. Finally, they will explore ways to pull data from HDInsight and other sources into Excel using tools like PowerPivot, Data Explorer, Power View and Geoflow to visualize data models with self-service analysis.


Course Outline

- Windows Azure Storage
- Windows Azure HDInsight
- HDInsight Hive Console
     - Create external table statements
     - Table partitions
     - Select statement syntax
- Hive ODBC driver for connecting to ODBC consumers like Excel
- Data Explorer Excel add-in
- Excel PowerPivot and Power View
- Windows Azure Marketplace, SQL Server and Windows Azure SQL Database
- Geoflow Excel add-in

Instructor Team
Saptak Sen | Senior Product Manager - Big Data | @saptak
Saptak is currently focused on delivering best in class Big Data and NoSQL offerings for Microsoft customers. He spends most of his time working with customers to understand their evolving technology platform requirements  and working with Microsoft’s talented engineering and marketing teams to formulate valuable offerings for our customers. For last 12 years he has had a very intellectually  satisfying time working in various roles at Microsoft including Engineering, Consulting and Technology Evangelism in addition to his current role in Product Management. Before joining Microsoft in 2001 he has founded and worked for several product startups.
Bill Ramos | Vice President of Consulting Services | @billramo
In his role at Advaiya, Bill is responsible for the delivery of technical and marketing content to Advaiya’s technology partners like Microsoft. Prior to Advaiya, Bill was a program manager for 15 years at Microsoft. During that time, Bill shipped or had been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Excel 2003, Access 2003, Access XP, Access 2000.
Live Event Details
June 21, 2013
9:00am - 5:00pm (PDT)
What: Interactive Virtual Classroom Training
Cost: Free
Audience: Developer
Prerequisites: Having a basic understanding of Windows Azure