The PASS Business Analytics Chapter provides virtual training on the tools and architecture patterns required to create world-class Microsoft Business Analytics.

Join us today - become a member of the Business Analytics Virtual Chapter.

Sign up for a free PASS membership and choose the option to join the BA Virtual Chapter in the myPASS portal. We'll keep you posted of all upcoming meetings, learning opportunities and the latest and greatest info form Microsoft.

Interested in speaking at an upcoming BA VC webinar?

Contact us today to let us know: passbavc@sqlpass.org

Next Meeting

Thu, Aug 08 2013 12:00 (GMT-04:00) Atlantic Time (Canada)


Drab to Dynamite! Managed Self-Service BI!!

RSVP: None

Drab to Dynamite! Managed Self-Service BI Using Real-World Data

Not every business has perfectly structured data. But with managed self-service business intelligence, you can now create rich, powerful analytics solutions that let you glean and share business insights from that data. This walk-through session will begin with actual small business data in Excel format and add data from Windows Azure to expand your analytics possibilities and show how to integrate data from SQL or other sources. PowerPivot will take the stage next, joining the data and enhancing it with calculated fields and KPIs. We’ll step through Power View to produce beautiful visualizations and deep exploration functionality. We’ll finish by sharing our solution, publishing it to SharePoint (using both PowerPivot Gallery and Excel Web Services) and via PowerPoint. Whether you’re an IT pro or business user and whatever your data’s structure, after this session, you’ll have the start-to-finish instruction manual to take any data set from drab to DYNAMITE!


Sandy Rivas is a Program Manager for Power View in the SQL Server Business Intelligence / Visual Analytics team at Microsoft.  A 14+ year Microsoft veteran, Sandy has helped to ship 6 versions of Microsoft Office, working closely with a wide variety of Office products such as Access, Excel and SharePoint to name a few. Her primary focus was on driving globalization and world-readiness into the Office products.  Her real-world use of Excel, PowerPivot and Power View for reporting product statistics division wide, is what fueled her passion for business intelligence and data visualization, driving her to become a Program Manager for Power View.