Power Pivot Trivia
Microsoft Recently changed the official name from 'PowerPivot' to 'Power Pivot' with a space.PowerPivot is a free Microsoft Excel add-on that installs on your machine that transforms Excel into a Powerful Data Processing engine enabling you to gather and report on massive amounts of data very easily and at lightning speed.
Let's say you're a product manager for a retail store who is in charge of managing millions of products or analyzing tens of millions of sales to identify which products to keep and which to weed out. You have a massive database of database of support tickets, and you're tasked with distributing reports to management on a weekly basis.
PowerPivot was designed specifically to solve key business questions such as those examples.
Numerous challenges come to mind when in creating. analyzing and distributing those reports
Most reports require some technical savviness to create as you'd be using tools such as SQL Reporting Services or Crystal Reports, and most likely require knowledge of some query language.
Well, the good news is that those are all challenges of the past, because with PowerPivot you can now easily create dynamic reports right from the familiar Excel interface using its tools - you don't need to be a developer.
Collecting the data needed by the report can be daunting task as the data could be spread between different databases, such as Microsoft SQL, Access and Excel. Consolidating this data could be very time consuming each time you want to create a report.
You can easily connect to your data sources across the enterprise, thereby constantly retrieving the latest data directly from the source.
Let us say you're able to consolidate all this data, how will you be able to report on tens of millions of data items? In fact Excel itself only allows you to handle about a million rows only. What reporting tool can truly handle that?
PowerPivot will allow your reports to Handle VPSly infinite number records at lightning speed.
How do you share this report among your peers effortlessly without emailing the huge reports every time there is an update and requiring them to download Excel and PowerPivot.
PowerPivot allows you to Distribute precompiled and dynamic reports via the web to all your peers simply by sending a link.
OK this may all sound promising.. But how does PowerPivot do this?
When you install PowerPivot for Excel, PowerPivot becomes your data warehouse, housing all the data you need for your reports right into the Excel file itself. PowerPivot is configured through a wizard to import all this data from just about any data source such as SAP, Oracle Database, Microsoft SQL Server, Access or any data source. Once your data is imported to PowerPivot, using familiar tools such Pivot Table tools in Excel, you are able to create reports on this data using native Excel tools such as pivot charts and pivot tables. Using slicers and filtering tools, you are able to generate very robust graphical reports that are dynamic, interactive and impressively fast.
This superior speed is possible because all your PowerPivot data is loaded into you computers memory, making handling the data drastically faster than any hard drive. Once your report is created, you can publish this report to a SharePoint instance online that supports PowerPivot, thereby allowing you to syndicate the interactive report to any authorized user without the need for Excel.
A game changer
With PowerPivot, reporting really has never been easier.
Now you see how the power behind PowerPivot can be a true game changer in creating and consuming reports, marking a profound leap forward in the world of business intelligence.
© TekReach Solutions, LLC