Now, we will analyse the Data Marts with Excel Power Pivot.
In Excel, under PowerPivot → Manage → From Database, connect to SQL Server
In the Choose How to Import the Data windows, check if select from a list of tables and views to choose the data to import ist selected. Click Next.
Your data model should look quite complex now.
Create a new query and answer the following question:
Check, if your product mix in the store fits to the product mix sales amount.
You started marketing campaigns in different months. Check, if you selected the months, where the highest sales activities are.
Check, if your marketing campaigns were successful. A marketing campaign is successful, when the gross profit is higher than the marketing costs.
The following report shows the performance of your salespersons. Does the revenue, the sales amount and the gross profit correlate? With other words, does the salesman with the highest sales amount make the highest gross profit?
Analyse GrossProfit, Revenue, SalesAmount and GrossProfit-to-Revenue ratio by salesmen.
Did you employ enough salespersons?
Make a quick calculation:
How many salesman should be employed?