PowerPivot Training

A Proud Partner of PowerPivot Workshop

Light Speed Solutions is a partner of PowerPivot Workshop and provides the comprehensive PowerPivot training course based on the innovative PowerPivot for Excel 2010: Give Your Data Meaning, written by Business Intelligence experts Marco Russo and Alberto Ferrari. We are a team of PowerPivot Pros here to deliver the invaluable training that will facilitate the use of this remarkable new technology into your day-to-day operations.

Microsoft PowerPoint - The Revolutionary Excel Add-in

Starting from basic concepts and moving up to complex data models and DAX formulas, our PowerPivot Pros are here to guide you through all facets of this revolutionary Excel add-in. We will not only introduce you to the full capabilities of Microsoft PowerPivot, but also help you to identify the scenarios where you should not use the add-in.

Comprehensive PowerPivot Training Course

Light Speed Solution's PowerPivot training is an extensive and interactive course offering hands-on instruction interleaved with core principles tailored to the specific needs of Excel professionals making the transition to PowerPivot. We adopt a universal skills approach using realistic samples, PowerPivot tutorials and direct PowerPivot training using the data that drives your business. Topics our PowerPivot Pros will cover include:

• PowerPivot introduction


• Data loading techniques with OLTP, DWH, Microsoft SQL Server, Microsoft Access and other types of sources


• Building PowerPivot data models using basic strategies


• Full coverage of the DAX programming language complete with hands-on examples


• Best practices for data modeling and calendar computation


• Solving common scenarios using advanced data modeling techniques


• Integrating SharePoint

Download PDF for full PowerPivot Workshop Outline

One and Two-Day PowerPivot Training

Light Speed Solutions offers beginner to advanced level PowerPivot training in either a one or two-day course based on the individual needs of the client. We provide our PowerPivot training, designed for Excel Power Users, IT and BI professionals, in one of the following two ways:

• Typical Open-Class Format: 5 to 20 participants from different backgrounds and companies will follow the default course program complete with all the PowerPivot examples.


• Single Company Workshop: We can follow the standard course or prepare a range of examples taken from the company data warehouse or OLTP system. Participants will have a set of workbooks at the end of the course that would be already working on their data.

In addition to these classes, Light Speed Solutions can provide a third day of PowerPivot Training dedicated to working directly with your data complete with the opportunity to discuss your data model with the teacher and get immediate hints and tips. We also offer PowerPivot Consulting services for clients searching for additional assitance.

Our decades of high-end Excel experience and expertise, combined with the unique perspective of industry leaders and partnership with PowerPivot Workshop, ensures that each client receives complete PowerPivot training from the best in the business. Call Light Speed Solutions today at (631) 752-2000 and talk to the people in the know.