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.

 

 

October 2014 Upcoming Sessions



Wednesday 15 Oct 2014 Noon CEST / 9 PM AEDT / 6 AM EDT

Risk Analysis Dashboard on a shoestring

Speaker: Johan Ludvig Brattås 

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

Visualization is all the rage – with the focus on Self-Service BI, In-Memory technology and fancy graphics. Tableau, QlikView and Microsoft PowerBi are showing off the eye-candy, and managers like what they see. However, either these solutions cost a lot of money, or your organization is stuck on older versions of software that lacks the functionality needed. This session will show you how to make a cool dashboard using a database (MS SQL Server 2008), Excel 2010, and in addition how to prepare your solution for SQL2012 and the full PowerBI-suite with PowerPivot. 



Johan Ludvig Brattås 


Johan Ludvig is a business intelligence consultant who has been working with SQL Server since 2000. He mainly works with T-SQL, reporting and visualization. Johan Ludvig is a certified QlikView developer but is just as happy diiving into PowerView, R and all other sorts of technologies he can get his grubby little hands on.
Read less


Timezone

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

Los Angeles - Wednesday, 15 Oct 2014 at 3:00 a.m 
New York - Wednesday, 15 Sep 2014 at 6:00 a.m 
London - Wednesday, 15 Sep  2014 at 11:00 a.m 
Sydney - Wednesday, 15 Sep 2014 at 9:00 p.m 
Auckland - Wednesday, 15 Sep 2014 at 11:00 p.m 

 

Wednesday 22 Oct 2014 1 PM BST / 8 AM EDT

A Dive Into Data Quality Services

Speaker: Steve Simon

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

Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy. 


Steve Simon 


Steve Simon is a SQL Server MVP and is a senior BI Development Engineer with Atrion Networking Corporation in Providence RI USA. He has been involved with database design and analysis for over 29 years. Steve has presented papers at 8 PASS Summits and one at PASS Europe 2009 and 2010. He has recently presented a Master Data Services presentation at the PASS Amsterdam Rally and is a regular presenter at SQL Saturday’s in the USA and Canada. Steve has presented 5 papers at the Information Builders' Summits. He is a PASS regional mentor.

Timezone

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

Seattle - Wednesday, 22 Oct 2014 at 5:00 a.m
New York - Wednesday, 22 Oct  2014 at 8:00 a.m
London - Wednesday, 22 Oct 2014 at 1:00 p.m
Sydney - Wednesday, 22 Oct  2014 at 11:00 p.m
Auckland - Thursday, 23 Oct 2014 at 01:00 a.m