ERD Design

   1. ERD For this phase, assume you are a member of a team of database and Graphical User Interface (GUI) developers/analysts. As a member of the database team, you are required to create an ER Diagram that will facilitate the development of Health Care Options’ company-wide database (see the Heath Care Options, Inc. document … Read more

Week 2 _ data _ discussion

  Respond to the following in a minimum of 175 words: The most frequently used measures of central tendency for quantitative data are the mean and the median. The following table shows civil service examination scores from 24 applicants to law enforcement jobs: 83        74        85        79 82        67        78        70 18        93        64        27 93        98        82        78 68        82        83        99 96        62        93        58 Using Excel, find the mean, standard … Read more

Professional Assignment #2

  Using, Internet, and the textbook, prepare a 2-3-page, APA-formatted paper in which you:  Discuss the pros and cons of establishing a business analytics competency center.  You need to include what industry and company type you would be establishing this for (small, medium, large business in a specific industry such as automotive, healthcare, retail, service, … Read more

week 1 _ data_ Statistics Analysis

  In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or in a separate Microsoft® Word document: Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of … Read more

BYOD

   Some organizations have implemented bring your own device (BYOD) policies. This enables organizations to save money on equipment costs because employees are now using their personal computers. At the same time, BYOD policies also present challenges for organizations. Now organizations are in the business of supporting personal computers. Integrate at least two quality, academic … Read more

Data Analysis Case Study

The purpose of this assignment is to apply a waiting line model to a business service operation in order to recommend the most efficient use of time and resources. Use the information in the scenario provided to prepare a managerial report for Office Equipment, Inc. (OEI).  Scenario Office Equipment, Inc. (OEI) leases automatic mailing machines … Read more

Data Mining

What are the techniques in handling categorical attributes? How do continuous attributes differ from categorical attributes? What is a concept hierarchy? Note the major patterns of data and how they work. What is K-means from a basic standpoint? What are the various types of clusters and why is the distinction important? What are the strengths … Read more

Data Visualization mini project

You are hired by JJ Office Supper, an office supply company with almost ten years of experience in the business and have expanded its business nationwide.In the last four years, the company has tried to introduce a new ERP system and seen the value of data.As a new hire, the COO (Chief Operational Officer) Kim … Read more

Professional Assignment #1

Your company provided you with data about sales, customers, and products. You review the data and find yourself concerned when you notice the high customer churn rates (loss of current customer-base).  Discuss some methods or applications of data science that can help identify potential customer churn and how it can help prevent customers leaving (retention).  … Read more