Use Microsoft Power Pivot to make your organisation self sufficient in BI within 4 weeks!
The ultimate goal of PowerPivot for Excel is to make data analysis really easy for
your business users through its' familiar Excel interface, Excel formulas and
formatting capabilities. Having achieved that goal, PowerPivot goes much
further by providing your users with the capability to easily integrate data
from multiple sources and, with its in-memory technology, to crunch huge
volumes of data if that is what is necessary to generate the insights you need.
While Microsoft has a powerful suite of BI tools including SQL Server Analysis
Services and SQL Server Reporting Services, all integrated in the
enterprise-strength SQL Server 2008 platform, these tools are designed for IT
professionals. Unlike these tools, PowerPivot for Excel is intended to be
used by the same people who build Excel PivotTables today - your team.
The idea is that Excel users should be able to leverage the training and
experience they already have and should not be required to learn complex
multi-dimensional concepts nor specialized multi-dimensional languages.
For your business users to use PowerPivot, all you need is Excel 2010, either 32 or
64-bit versions.
To take the value to the next level where your users are
able to leverage centrally-managed and refreshed data sets and securely share
their individual insights across the organisation, you need to run SharePoint
Server 2010 and SQL Server 2008 R2 Enterprise Edition.
Isidore can help you to realise the promise of business intelligence by empowering your
organisation to take advantage of this powerful technology. Through a
twenty day engagement our consultant will work through an agreed program with
your key stakeholders to develop the foundation of knowledge and skills your
organisation requires to successfully leverage PowerPivot to develop reports,
analytics and dashboards for ongoing business value.
This program will focus on your Finance organisation, providing hands-on training in PowerPivot
basics followed by the definition and development of the data model for your
Profit and Loss functional area and the P&L Report(s). At the
completion of the engagement, your team should have the skills to leverage the
work done for significant additional business value, including enhancement of
the P&L data model, creation of new data models, and the creation of
additional reporting and analytics.
In other words, your team should be largely self-sufficient in terms of being able to develop the reporting and analytics they need to drive better business outcomes. |
