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 (UTC-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 DW/BI VC

January 2015 Upcoming Sessions


Monday 12 Jan 2015 1:00 PM EST, 6:00 PM GMT / Tuesday 13 Jan 2015 7:00 AM NZDT

Inside xVelocity in-memory engine (VertiPaq)

Speaker: Marco Russo

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

Power Pivot and SQL Server Analysis Services 2012 Tabular models are based on the xVelocity in-memory analytics engine, also known as VertiPaq. This engine is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine. You will learn common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model.


Marco Russo
Marco is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors like financial services, manufacturing, gambling, and commercial distribution. Marco is also an author and published several books about Analysis Services and Power Pivot. He is also a speaker at international conferences such as TechEd, PASS Summit, SQLRally, and SQLBits.

Check your local timezone here




Tuesday 27 Jan 2015 11:00 AM PST, 7:00 PM GMT / 28 Jan 2015 8:00 AM NZDT

SSIS Internals and Performance

Speaker: David Peter Hansen

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

You have worked with SQL Server Integration Service (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before. In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems. You will also learn how the control flow engine and data flow engine work, what the impact on performance buffers have, and how execution trees are related to parallelism.


David Peter Hansen
David Peter Hansen is Microsoft Certified Master (MCM) in SQL Server and works as Consulting Manager for Advectas Denmark. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He is a frequent speaker at conferences and is an active community member.

Check your local timezone here