I need support with this Business question so I can learn better.
Business Intelligence Consulting Project
Use the Alberstonne Sales Data to complete this assignment.Alberstonne is a BI consulting firm. It is facing stiff competition in its top-of-the-line and in-demand services, which are:
- Balance scorecard analysis.
- Business consulting.
- Data visualization training.
- Executive dashboard.
- Key performance indicator (KPI) analysis.
- Strategy map analysis.
Alberstonne has three core business functions to deliver its services:
- Consulting services.
Alberstonne has five groups of customers:
- Large enterprises.
- Small and medium businesses.
In the Alberstonne Sales Data document, Table 1 presents the transaction data in a chronological order for daily sales and cost by services, business functions, and customer groups.
- Use a pivot table or SAS Enterprise Miner to create graphical presentations of sales per customer group, per service, and per a selected unit of time (weekly, monthly, and yearly).
- Determine the following:
- The most selling service.
- The most profitable customer group.
- Any trend that you may observe.
Note: One of the services in the data has typos on purpose. Please clean the data before performing your analysis.Present your analysis in a 5–10 page report. Include supporting graphs from Excel.
- Written communication: Written communication should be free of errors that detract from the overall message.
- APA formatting: Your paper should be formatted according to the current APA style.
- Length: 5–10 typed, double-spaced pages.
- Font and font size: Times New Roman, 12 point.