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

Fri, Jan 04 2013 12:00 (GMT-05:00) Eastern Time (US & Canada)


MDX vs. DAX: Currency Conversion Faceoff

RSVP: None

MDX vs. DAX: Currency Conversion Faceoff

Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. Understand how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. Features covered can be used in a broad range of scenarios (not only currency conversion) adding valuable knowledge to your SSAS arsenal. Level: 400 Christian Wade, creator of the BISM Normalizer, has been doing BI and solution architecture since SQL Server 7. He spoke at the PASS Community Summit in 2012 and 2005, the 2005 European PASS Conference, and other events including SQLSaturday. Christian is from the UK, but lives in California.


Christian Wade is an independent consultant and senior solutions architect. He has led BI, data-warehousing and application-development projects since 1999. In his spare time, he created the BISM Normalizer for the SQL community, which is a free database-compare tool for Analysis Services tabular models. Christian holds a bachelor’s degree in operations research and business statistics.

 

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