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

Fri, Mar 22 2013 12:00 Eastern Daylight Time


My Brain Hurts: Presenting Data with Microsoft Pro

RSVP: None

Presenting Data with Microsoft Products

There is an old saying, “May you live in interesting times.” It is both a blessing and a curse. Microsoft certainly makes viewing data interesting. Excel, Excel Services, SQL Server Reporting Services, PerformancePoint Services, PowerPivot, Power View are the tools Microsoft proposes. It’s no wonder companies are confused. Craig Utley looks at each of these tools, showing not only the capabilities, but providing guidelines for the strengths and weaknesses of the tools based on the target audience. If you want to get a handle on the confusing world of Microsoft BI delivery tools, this talk is for you.


Craig Utley is a Senior Architect with CTS and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he focused on business intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0 and has consulted on over 50 BI implementations worldwide, including the largest Microsoft data warehouse in the world. He is a former MVP in both SQL Server and C# and has written three books and more than 35 articles.

 

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