PowerPivot is an end user tool. No programming skills are required. But, you may need a resource to help you with these aspects of building a dashboard with PowerPivot:
- Setting up your PowerPivot data structure
Once PowerPivot is connnected to the data you do not need to worry about this anymore. You can just click on the refresh button and PowerPivot will import an updated copy of the data. Setting up the PowerPivot database requires that you understand some new concepts such as relationships, date tables and period tables.
Writing PowerPivot formulas
PowerPivot Data Analysis Expression (DAX) formulas are just like Excel formulas. They were designed so that Excel users could quickly became comfortable with them. During your learning process it can be a time saver to receive help from an expert.
With a few Excel macros written in Visual Basic for Applications you can automate any special data reformatting, data imports, printing, drill downs and workbook navigation.
If you need to make changes and corrections to data before analyzing with PowerPivot you can use Access as a simple and user friendly tool to work with your data.
John F. Lacher & Associates, LLC
John Lacher has been providing Excel consulting services for over 15 years. He works off-site via e-mail. phone and GoToMeeting with clients all over the world. His background is in accounting and management. His Excel skills include PowerPivot, DAX, VBA, and integration with Access.
To inquire about availability and costs of consulting, please fill out this contact form and click "Submit":