O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Preparation Analysis of Data Source

After installing PowerPivot and getting to know the basic concepts, we will now take a deep dive into data sources and the different types of data sources that can be imported to the PowerPivot interface.

As discussed in Chapter 1, Principles and Installing PowerPivot, there are three principles in PowerPivot; the first principle is Preparation, which is displayed in a red colored box in the following figure:

Preparation Analysis of Data Source

Preparation for data analysis

The most important thing is that a lot of users may have both structured and unstructured data coming from a variety of sources (for their urgent data analysis). The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required