Module 01 - Business Intelligence and Business Analytics Overview

You have been hired by Robert M. Lopez, Chief Compliance Officer of ANox Pharmaceutics to examine sales data and identify any conduct by sales consultants that is inconsistent with ABC pharmaceutics' policy for selling agents.

ANox pharmaceutics sells pharmaceutic contracts to physicians, physician groups and hospitals. Currently, ANox pharmaceutics is preparing for a federal audit and needs to find outliers prior to the official government audit.

You will gather the business requirements from a meeting that was conducted by the Chief Compliance Officer. Your engagement will include the retrieval, classification, and analysis of the data for 27 ANox Pharmaceutic sales consultants. After analyzing the data, you will provide a report that visually assesses the data providing the Chief Compliance Officer with an executive summary of your findings.
You have been provided three artifacts to accomplish your objective:

1. The 2014FourthQuarter spreadsheet contains sales data pertaining to ANox's 27 sales consultants. The spreadsheet contains data for 2014 fourth quarter in tabs labeled October2014, November2014, and December2014.
2. ANox Pharmaceutic Policy P1029 - Sales Consultant Selling Practices will detail standard operating procedures that must be adhered to by all sales consultants.
3. The 1/15/2015 meeting notes and expectations from ANox's Chief Compliance Officer, Robert M. Lopez

To prepare for this project:

• Read and understand ANox Pharmaceutic Policy P1029 for selling agents.
• Read the 1/15/2015 meeting notes and expectations from Robert M. Lopez.
• Initial examination of the 2014FourthQuarter.xls

No Deliverable