Consulting Project
Question Description
-
Business Intelligence Consulting Project
Assignment Instructions
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.
- Licenses.
- Maintenance.
Alberstonne has five groups of customers:
- Large enterprises.
- Government.
- Small and medium businesses.
- Administration.
- Others.
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.
Additional Requirements
- 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.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."