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

News and Updates

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

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

Interested in speaking at an upcoming BA VG webinar?

Send us your information by completing the Call for Speaker survey here and we will follow up with you or you can contact us today to let us know by email using


Drab to Dynamite! Managed Self-Service BI!!

Thu, Aug 08 2013 12:00 Atlantic Daylight Time


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

Sandy Rivas is a Program Manager for Power BI at Microsoft. A 17+ year Microsoft veteran, she has shipped numerous Microsoft products. She manages the Power BI online Community and Power BI User Groups across the world. Her real-world use of Power BI with her brother’s business has given her a keen insight to the practical uses and value of self-service BI. Sandy has a passion for empowering customers to master their data through self-service BI. Her practical experience & enthusiasm is contagious!

Follow us on Twitter: @PASSBAVC | Contact us: PASSBAVC@SQLPASS.ORG
Back to Top