The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.
Next Meeting

Tue, Sep 03 2013 13:00 GMT Daylight Time


From Data Source to Secret Sauce: Hive for BI Pros

RSVP: https://attendee.gotowebinar.com/register/2767188545162802688

From Data Source to Secret Sauce: using Hive for BI Pros

Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce that will help the business to make data-driven decisions to drive the enterprise forward. How can you get your organisation's secret sauce? Big Data allows us to conduct better analyses because research has shown that simple algorithms with a lot of data can produce better results than complex algorithms that do not have a data-rich set to work on. Data scientists need a way of combining the scalability of Big Data with the ability to conduct extensive data analysis. Big Data can look like a minefield: what is Map Reduce? Do I have to know Java? In this session, you will be introduced to Hive, which is comfortingly similar to SQL and translates your SQL queries into Map Reduce behind the scenes for you. It's an essential tool so please join us to learn more about it.


Jen Stirrup, a SQL Server MVP and PASS Director-At-Large (Elect), is a well-known Business Intelligence and Data Visualisation expert, author, data strategist, and technical community advocate who has been peer-recognised as one of the top 100 most global influential tweeters on Big Data topics. Jen has presented at TechEd North America and Europe, Summit, SQLBits, as well as at SQLSaturday events in Europe and the US. She is a former Awardee of PASS's prestigious PASSion Award in 2012.

 

Web: http://Bi.sqlpass.org | Twitter: @PASSBIVCEmail:  

 

 

PASS Summit 2014 Discount Code

The annual PASS Summit is taking place in Seattle, on Nov 4-7, 2014. If you have not registered, you can use PASS DW/BI VC discount code of VCSUM05 to get $150 off registration price. To register, please visit http://www.sqlpass.org/summit/2014/RegisterNow.aspx.

 

 

September 2014 Upcoming Sessions


Tuesday 2 Sep 2014 1 PM BST / 10 PM AEST / 8 AM EDT

Counting is easy, Measuring is hard: insights using Data Visualisation

Speaker: Jen Stirrup

Registration URL: https://attendee.gotowebinar.com/register/6683524726630716673

"Don’t worry about people stealing an idea. If it’s original, you will have to ram it down their throats.” Howard Aiken, Founder of Harvard’s Computing Science Program. 

Counting is easy, measuring is hard! KPIs, dashboards, and basic data analytics often make us feel like we understand what’s going on. Data is moving so fast these days, and people understand it best through data visualisation. However, Data Visualisation can lead and mislead, and in this session we will look at theory andpractice based on dataviz gurus such as Stephen Few and Edward Tufte, and scientists such as Cleveland and Ben Schneiderman. If you don't know who they are - even more reason for you to join us and learn what the gurus have to say about dataviz! 

If your data is visualised wrong, your data-based decisions are based on wrong insights. In this session, we will look at understanding the data visualisation by exploring the Power BI components and tools available in the cloud.


Jen Stirrup

Jen Stirrup, a SQL Server MVP and PASS Director-At-Large (Elect), is a well-known Business Intelligence and Data Visualisation expert, author, data strategist, and technical community advocate who has been peer-recognised as one of the top 100 most global influential tweeters on Big Data topics. Jen has presented at TechEd North America and Europe, Summit, SQLBits, as well as at SQLSaturday events in Europe and the US. She is a former Awardee of PASS's prestigious PASSion Award in 2012.

Timezone

Check your Timezone by clicking here, or use our handy list below

Los Angeles - Tuesday, 2 Sep 2014 at 5:00:00 a.m 
New York - Tuesday, 2 Sep 2014 at 8:00:00 a.m 
London - Tuesday, 2 Sep 2014 at 1:00:00 p.m 
Sydney - Tuesday, 2 Sep 2014 at 10:00:00 p.m 
Auckland - Wednesday, 3 Sep 2014 at 00:00:00 a.m 

 

Wednesday 17 Sep 2014 4 PM EDT / 1 PM PDT / 9 PM BST / Thursday 18 Sep 2014 6 AM AEST / 8 AM NZST

Absolute beginners presentation for Power BI for Office 365

Speaker: Kevin S Goff

Registration URL: https://attendee.gotowebinar.com/register/4757737807317828865

As the title states, this is an absolute beginner’s presentation. I actually create a brand new Power BI site, completely from scratch, then provision it, set up a gateway, and then create a few basic examples. The objective isn’t to show off all the cool visualizations in PowerView and PowerPivot, it’s more to show the core mechanics of creating a site, pushing up content, and setting up a refresh through the gateway. The presentation is intended to show to brand new people that it’s really not that difficult. At the conclusion I’ll talk about some of the new features coming down the pike soon for Power BI. 

Kevin S. Goff (www.KevinSGoff.net) 

* SQL Server MVP since 2010 (was a C#/.NET MVP from 2005-2009) 
* SQL Server/Business Intelligence architect/developer/speaker/instructor/author 
* CoDe Magazine Columnist from 2004-2013 on .NET and SQL Server/BI Topics 
* Frequent speaker at community events in the Mid-Atlantic region, and regular speaker for the SQL Live!360 Conference Brand 
* Created 13-week SQL Server 2012 webcast series for Microsoft TechNet Radio 

Timezone

Check your Timezone by clicking here, or use our handy list below

Los Angeles - Wednesday, 17 Sep 2014 at 1:00 p.m 
New York - Wednesday, 17 Sep 2014 at 4:00 p.m 
London - Wednesday, 17 Sep  2014 at 9:00 p.m 
Sydney - Thursday, 18 Sep 2014 at 6:00 a.m 
Auckland - Thursday, 18 Sep 2014 at 8:00 a.m 

 

Thursday 25 Sep 2014 7 AM PDT / 10 AM EDT / 3 PM BST

Using Power BI for Managing Personal Fitness

Speaker: Matthew Roche

Registration URL: https://attendee.gotowebinar.com/register/1209847980362173186

In the summer of 2011, Matthew Roche joined the SQL Server team, moved his family across the country to Redmond. Over the next 15 months, inundated with the demands of a new role, move-related family stress, and an abundance of great food, Matthew managed to gain over 20 kilograms – and he realized that he needed to make a change. That change involved many healthy habits, but centered around weight training pushing his limits and abilities week after week. And of course, data and business intelligence were at the heart of how Matthew reversed his downward spiral and embarked on a fitness journey of epic proportions. 

In this session Matthew will present a custom solution for managing personal fitness data, implemented in Excel using Power Query, Power Pivot, and Power View. The session will focus on the real-world solution Matthew developed to measure and guide his fitness progress, including data sources, data modeling, and data visualization, and may or may not include shirtless progress photos. If you’re motivated by data, and want to see how you can reach your fitness goals while letting Excel do the heavy lifting, this is the session you’ve been waiting for. 

Matthew Roche 

Matthew Roche is a Senior Program Manager on the SQL Server product team, working on Enterprise Information Management (EIM) in SQL Server Integration Services (SSIS), Master Data Services (MDS) and Data Quality Services (DQS). Before joining Microsoft in 2008, Matthew was a business intelligence consultant and trainer and a Microsoft SQL Server MVP. In addition to implementing small- and large-scale BI solutions with SQL Server, Matthew has presented on SQL topics at major technical conferences, code camps, and user groups across the US and in Europe.

Timezone

Check your Timezone by clicking here, or use our handy list below

Seattle - Thursday, 25 Sep 2014 at 7:00 a.m 
New York - Thursday, 25 Sep  2014 at 10:00 a.m 
London - Thursday, 25 Sep 2014 at 3:00 p.m 
Sydney - Friday, 26 Sep 2014 at 0:00 a.m 
Auckland - Friday, 26 Sep 2014 at 02:00 a.m