Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.
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 DW/BI VC

December 2014 Upcoming Sessions


Monday 8 Dec 2014 2:00 PM PST, 5:00 PM EST / Tuesday 9 Dec 2014 9:00 AM AEDT, 11:00 AM NZDT

Implementing Data Warehouse Patterns with the Microsoft BI Tools

Speaker: Kevin S. Goff

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

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.


Kevin S. Goff
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

Check your local timezone here




Friday 19 Dec 2014 1:00 PM AEDT, 3:00 PM NZDT / Thursday 18 Dec 2014 6:00 PM PST, 9:00 EST

Techniques for Dynamic SSRS Reports

Speaker: Mickey Stuewe

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

Do you need a navigation system within your reports? Do you suffer from report sprawl, having hundreds of reports written once and disappearing into the reporting services catalog never to be executed again? Would you like to see one report take the place of fifty? If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we’ll talk about providing dynamic report layouts, filtering data based on the user’s credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero.


Mickey Stuewe
Mickey Stuewe is a Senior Database Developer. Her focus is on T-SQL optimization, requirements gathering, and report design using the SQL Server stack. She is the recent recipient of the “Best New Community Voice” Tribal award from Red Gate. She blogs regularly and co-authored her first book, SQL Server 2012 Reporting Services Blueprints. She has spoken at Dev Connections, SQL in the City for Red Gate, and various SQL Saturday Events. She is also the president of the BIG PASS Community user group.

Check your local timezone here