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

Tue, Sep 17 2013 19:00 GMT Daylight Time


Data Driven formatting in SSRS

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

Data Driven formatting in SSRS

Ever had marketing send out that email saying that they are re-branding the company with new colours and fonts, normally not a problem until they mention that the 300+ SSRS reports need to be changed too... This session will show you how to make use of SSRS project templates, and built in data sets, variable, expressions and a bit of modification to the SSRS database to help make these sorts of requests a simple matter of updating some values in a database. As opposed to pulling the reports out of source control before modifying them and trying to get a deployment scheduled.


John currently works as a SQL Server Premier Field Engineer for Microsoft, supporting and advising a wide array of customers on how to get the best out of their SQL Server systems. Working with SQL Server for over six years on all versions from SQL 2000 to 2014, I have accumulated a lot of experience in Ops, Development and BI roles that help me get the most out of SQL Server.

 

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



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 Cloud & Enterprise team at Microsoft, working on Self-Service Information Management (SSIM) in Power BI and related hybrid cloud efforts. Matthew has previously worked Enterprise Information Management (EIM) tools including 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.

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