Retail (Adventure works)

demo

Knowing what products are selling best among the stores, markets and regions is crucial to the decision making process. What products should be invested in and what should be weeded out? Also in this report: how many of the products we purchased are being rejected? What vendors are providing the best quality and speedy delivery?

Launch Demo
Login: spfm\powerpivot
Password: Power100!

Sales Summary

demo
demo

The new timeline slicer is a quick way define date rang for your report. Excel’s Conditional formatting bar charts will truly give you a quick and colorful insight into your report. Need to drill down even further? Hierarchies can be created within PowerPivot bringing predefined paths for consuming the data. Check out how we can drill down from a Country down to the State and even City.

Detailed Product Rank by Market

demo
demo

Knowing what products are the best-sellers and their behavior in each of the markets is crucial when deciding what products to produce and which to discontinue. Ranking among multiple contexts is something that can be done easily with PowerPivot. It doesn’t matter if you’re trying to do a rank of the current selection or a combination of time intelligence and rank, the report is fast-paced and demonstrates that you can create fields and measures to work however you want…the possibilities are endless. Note: this report cannot be created in native Excel. Thank you PowerPivot.

demo

Purchase Report

Check out this report to see how two simple pivot tables interact with multiple types of slicers giving us the insights that any Purchase Manager would strive for. PowerPivot, whether hosted or local, will delivery fast reports despite the slicers and complexities behind the scenes.

Sales Overview

An impressive and interactive dashboard that shows you exactly how your sales are doing at any given moment. This Power View dashboard (which utilized SQL Reporting Services) will provide an immersive experience that will let you click away for hours.

demo
demo

Purchase Quarter Analysis

Scatter charts are a great way of seeing how multiple variables have correlations between each other. Add to that how their relationship evolves over time. In this example, we created a simple scatter chart that shows us how each Vendor is doing in terms of complying with the orders that we have. Are they delivering the materials in good shape or are those orders being rejected? How much was that order worth? Is their quality of work improving with time?