Traditionally, as discussed earlier, the three principles of the PowerPivot interface will be implemented using separate tools and different people can be involved in doing so. One person will not do everything, since they might have to deal with lots and lots of tables and a variety of data sources. For big data warehouses, it will be kind of a big process and it's possible to complete it with some manpower.
Once they have designed the data warehouse schema, they have to create a data mart (provide decisional information for a specific business area, for example, sales, marketing, and human resources) for the end user to be able do the analysis using different kinds of tools for different analyses, such as multidimensional analysis with the OLAP tool, complex reports using the reporting tool, and predictive analytics with the data mining tool, so they can then take a decision.
More precisely, the data mart will be done for big data warehouses, for...