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.

 

 

August 2014 Upcoming Sessions


Friday 15 Aug 2014 11 AM PDT / 2 PM EDT / 7 PM GMT

Continuous Integration for Reporting Services

Speaker: Nat Sundar

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

Developing a Report with Reporting Services is easy. But how can we deliver consistent and bug free Report in a short turnaround. Continuous Integration help us to Build, Unit Test and Deploy the components as we develop. It helps the Developers, DBAs, Test Engineers and the Release Managers. 

Continuous Integration: 

With the help of CI tools , we can build the Report files (.RDL) from Source control (Perforce, SVN, etc). However writing Unit test cases for Reports requires little thoughts. Once the test development has completed, this also need to be build and integrated with the CI tools for automatic runs. 

Also the Reports, Datasets and the Datasources have to be deployed to a Test environment. With the help of CI tools the deployment process can be automated as well. 

In this Demo Rich session, I will walkthrough the best practices around the Development, Build, Unit Test case and Deployment. 

Nat Sundar

Nat Sundar is an independent SQL BI consultant working in the UK. He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). 

He is passionate in SQL Server, SSIS, SSAS, SSRS and MDX. 

Linked-In Profile: http://uk.linkedin.com/pub/nat-sundar/58/a87/842

Timezone

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

Los Angeles - Friday, 15 Aug 2014 at 11:00:00 a.m 
New York - Friday, 15 Aug 2014 at 2:00:00 p.m 
London - Friday, 15 Aug 2014 at 7:00:00 p.m 
Sydney - Saturday, 16 Aug 2014 at 4:00:00 a.m 
Auckland - Saturday, 16 Aug 2014 at 6:00:00 a.m 

 

Wednesday 27 Aug 2014 Noon BST / 9 PM AEST

Intro to R

Speaker: Stephanie Locke

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

R, the statistical programming language, is another open-source program making inroads into the Microsoft world. 

R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about to save yourself pains you didn't even know you had. 

Stephanie Locke 

Stephanie Locke (@SteffLocke) is an experienced Analyst and BI developer within the Finance and Insurance industries. Steph runs her local SQL Server User Group, helps organise SQLRelay, co-author of the book Tribal SQL and contributes to the community at large via blogging, presenting and forums. 

Timezone

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

Seattle - Wednesday, 27 Aug 2014 at 4:00 a.m 
New York - Wednesday, 27 Aug 2014 at 7:00 a.m 
London - Wednesday, 27 Aug 2014 at Noon 
Sydney - Wednesday, 27 Aug at 9:00 p.m 
Auckland - Wednesday, 27 Aug at 11:00 p.m