MSBI AcademyA new video is available on MSBI Academy which covers an Introduction to Calculations in Power Pivot.  Calculations can significantly enhance the information available from a data model, and are an important skill for any Power Pivot data modeler. This video from Melissa Coates introduces the two types of calculations: Calculated Columns and Calculated Fields (aka Measures). It also discusses Implicit and Explicit aggregation behavior for Calculated Fields. If you or your staff are new to data modeling in Power Pivot or SSAS Tabular, this video can help jumpstart your understanding of the types of calculations.

Microsoft BI Academy ( is a free site hosted and maintained for the community by BlueGranite. The site contains dozens of brief technical training videos authored and recorded by BlueGranite consultants, analysts, and architects.

At BlueGranite, we assist business and technology leaders interested in crafting Self-Service Analytics and Reporting strategies. Our flexible approaches can support the initiative by targeting a wide range of supporting activities, from building data repositories specifically crafted for Power Pivot use, to end user training, mentoring, and adoption programs. Be sure to contact us if you are in the process of deciding which flavor of Self-Service Analytics is most appropriate for your organization.