Healthcare Industry Analysis

It should be organized in this manner

 Introduction section

Industry Analysis section 

Conclusions section 

References section 

In the Industry analysis section, include all your findings, important information, personal observations, professional interests on one or more industries, market projections, job opportunities, etc

You can refer 

Abinav Shashank, (2017,September 18)The Evolution of Data and Technology in Healthcare http://blog.innovaccer.com/evolution-data-technology-healthcare/ 

  

Demand of Data Analytics in Healthcare. Retrieved from
https://www.usfhealthonline.com/resources/healthcare/demand-for-data-analytics-inhealthcare/

The big data revolution in Healthcare. Retrieved From: http://www.pharmatalents.es/assets/files/Big_Data_Revolution.pdf

Chandan K Reddy, (2013), Big Data Analytics for Healthcare. Retrieved from: http://www.achc.org.co/hospital360/contextos/Tecnologia_e_Informacion/Big_Data/Analisis_de_grandes_datos_en_salud.pdf  

Career spotlight: health care data analyst. (2017).Pearson https://www.pearson.com/pathways/areas-work-study/analytics/healthcare-data-analyst.html

McKinsey & Company. (2013). The big data revolution in healthcare. https://www.mckinsey.com/insights/health_systems/~/media/7764A72F70184C8EA88D805092D72D58.ashx

Sarat chandran, V. (2022, February 9). 5 Ways BigData is Changing the Healthcare Industry. Fingent Technology.
https://www.fingent.com/blog/5-waysbig-data-is-changing-the-healthcare-industry 

Telling the Data Story

 

Assessment Description

The purpose of this assignment is to use fundamental visualization software techniques to analyze data and tell the data story.

Problem

Open Tableau and connect to the \”RentalData\” worksheet in the \”Rental Data\” file. 

The \”Rental Data\” file contains data on car rental activity for a specialty rental car company, whose customer base is only college students. Note for the \”Insurance\” field 1 = customer purchased rental insurance, and 0 = customer did not purchase rental insurance. The \”InputData\” worksheet provides a description of each \”CarID\” code. \”TimeOut\” is measured in hours, and \”Price\” is dollar amount charged for the rental. The \”Note\” field includes the general condition of the rented car upon its return. The remaining fields in the \”RentalData\” worksheet are self-explanatory.

Create the following charts/tables using Tableau. Charts/Tables will be based on the \”RentalData\” worksheet in the \”Rental Data\” file. Place each chart/table into a separate sheet in your Tableau file.

  1. Column Chart: Sum of Miles by CarID. Ensure that the column bars are purple and that the mileage values are above each column. Name the Tableau sheet \”MilesbyCarID.\”
  2. Pie Chart: Percentage Time out by \”Standing.\” Ensure that the percentage values for each pie piece are displayed on the chart. Name the Tableau sheet \”TimeOutbyStanding.\”
  3. Scatter Chart: Time Out by Price. Ensure \”TimeOut\” is the x variable, and \”Price\” is the y variable. Name the Tableau sheet \”TimeOutbyPrice.\”
  4. Horizontal Bar Chart: Time Out by Car ID by Month. Ensure that the horizontal bars are green and that the time out values are to the right of each column. Partition the chart by month. Name the Tableau sheet \”TimeOutbyCarID.\”
  5. Text Table: Count of Notes by Gender by Standing by Insurance. Ensure that the counts are blue. Name the Tableau sheet \”NotebyGenderbyStandingbyIns.\”
  6. Treemap Chart: Count of Notes by Standing. Select your own colors for the treemap. Name the Tableau sheet \”NotebyStanding.\”
  7. Packed Bubbles Chart: Miles by CarID by Insurance. Select your own colors for the chart (one color for each \”Insurance\” category). The size of the bubbles should be based on mileage for each \”CarId.\” Display the \”CarID\” inside each bubble. Name the Tableau sheet \”MilesbyCarIDbyInsurance.\”
  8. Area Chart: Miles by Month. Select your own colors for the chart (one color for each area). Display the \”Miles\” values on the chart. Name the Tableau sheet \”MilesbyMonth.\”

For each required item above, take note of the results. The insights gained from this information will need to be summarized in a PowerPoint presentation that will be submitted as a part of this assignment. You are required to submit the completed Tableau *.twb file and the Excel file containing the source data to your instructor. Create a .zip file that contains your Tableau file and any other supporting files.  Submit your .zip file. Ensure that your last name is in the filenames.

Property management

The overall goal as a modern property manager is to run the business more effectively. However, it seems there are a lot of challenges that professionals in this industry have to deal with. In light of what you have learned so far in this course, and your other businesses courses, what do you think is really at the bottom of these struggles?  From the Wood article, explain your agreements, disagreements, and/or questions regarding the idea, as well as any implications it may have in the role of a property manager.

Discussion: Challenges in Property Management Resources

Article is attached 

5-2 Project

nstructions

The second milestone of your final project is due at the end of this module.

For this milestone, you will need to reference your previous work on job evaluation points from Milestone One Internal Consistency: Job Evaluation.

To complete this assignment, read the , , and the for detailed information on the requirements for this project.

Note: This project requires the use of the Microsoft Excel Analysis ToolPak as instructed in Module Ones Final Project Review.

OL 325 Milestone Two Guidelines and Rubric

Overview: The importance of compensation varies depending on the viewpoint, as described by Barry Gerhart and Jerry Newman in Compensation. Society views compensation as a measure of justice; managers may view compensation as a major expense or a motivator; employees view compensation as an entitlement or as an incentive. Regardless of the viewpoint, fairness and equity are essential. Compensation must also be up-to-date, competitive in the market, and easy to understand.

Aligned pay structures support the way the work gets done, fit the organizations business strategy, and are fair to employees. Organizations typically task an in- house human resource (HR) professional or hire an HR consultant to create and maintain the companys pay structure.

Prompt: Salary Surveys: To ensure the pay structure is externally competitive, a salary survey should be conducted, as stated by Lisa Burke in Designing a Pay Structure. For the results of a survey to be valid, the market pay data must be from a relevant labor market. Since most of the office support, HR, and operations jobs will be filled by regional candidates, local pay data should be gathered.

A salary survey is developed by your team and sent to industry competitors. Descriptive data such as organization size, industry, annual revenue as well as compensation data for each of the benchmark jobs were collected. Surveys were completed and returned by six organizations that recruit and hire similar positions within a 90-mile radius of Rockville. Base pay data from the responding organizations are reflected in Appendix B of the Final Project Case Study. Organizations are referenced as companies A, B, C, D, E, and F for anonymity. Those who participated also received copies of the results for their contribution.

In this assignment, you will address the external competitiveness component of a pay structure using the specifically designed case scenario. Read the Final Project Case Study (linked to in your course) for detailed information on the requirements for this project.

Specifically, you must address the critical elements listed below.

External Competitiveness:

  1. Calculate the weighted means of base pay for each of the following benchmark jobs: administrative assistant, operations analyst, production worker,
    and benefits manager from the six companies listed in Appendix B of the final project case study.
  2. Calculate the predicted base pay for each of the following benchmark jobs: administrative assistant, operations analyst, production worker, and
    benefits manager.
  3. Create a market pay line using the following benchmark jobs: administrative assistant, operations analyst, production worker, and benefits manager.
    Clearly label your job evaluation points and salaries.
  4. Calculate the adjusted pay rates for each benchmark job based on your companys decision to lead in base pay by 3%.
  5. Create pay grades by combining benchmark jobs that are substantially comparable for pay purposes. Clearly label your pay grades and explain why
    you combined any benchmark jobs to form a grade.

1

page2image1369348176

F. Create pay ranges including minimum and maximum for each of the pay grades based on pay grades created in item E above.

Rubric
Guidelines for Submission: Your final project will be a Word document, approximately 89 pages in length (plus a cover page and references) and must be

written in APA format. Your Word document may include Word tables, Word lists, Excel screenshots, and rationale in written paragraphs. Use double spacing, 12- point Times New Roman font, and one-inch margins.

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

page2image1465715584 page2image1465715872 page2image1465716160 page2image1465589504 page2image1465589792

External Competitiveness: Weighted Means

Provides correct weighted means for each benchmark job identified

Provides incorrect weighted means for some of the benchmark jobs or provides weighted means for all benchmark jobs with consistent computational errors

Does not provide weighted means for benchmark jobs

15

External Competitiveness: Predicted Base Pay

Provides correct predicted base pay for each benchmark job identified

Provides incorrect predicted base pay for some of the benchmark jobs or provides predicted base pay for all benchmark jobs with consistent computational errors

Does not provide predicted base pay for benchmark jobs

15

External Competitiveness: Market Pay Line

Provides correct market pay line for each benchmark job identified with clear labeling of job evaluation points and salaries

Provides incorrect market pay line for some of the benchmark jobs or provides market line but does not clearly label job evaluation points and salaries

Does not provide market pay line for benchmark jobs and does not clearly label job evaluation points and salaries

15

External Competitiveness: Adjusted Pay Rates

Provides correct adjusted pay rates for each benchmark job identified

Provides incorrect adjusted pay rates for some of the benchmark jobs or provides weighted means for all benchmark jobs with consistent computational errors

Does not provide adjusted pay rates for benchmark jobs

15

External Competitiveness: Pay Grades

Provides correct pay grades for combined benchmark jobs, labels pay grades incorrectly, and explains why combined benchmark jobs form a grade

Provides incorrect pay grades for combined benchmark jobs or labels pay grades incorrectly or does not explain why combined benchmark jobs form a grade

Does not provide pay grades for combined benchmark jobs, does not label pay grades correctly, and does not explain why combine benchmark jobs form a grade

15

External Competitiveness: Pay Ranges

Provides correct pay ranges for each pay grade and provides rationale for pay ranges

Provides incorrect pay ranges for some pay grades or does not include rationale

Does not provide pay ranges for pay grades and does not provide rationale

15

2

page3image1374247856 page3image1373673664 page3image1373716496 page3image1373971808page3image1374175296 page3image1374248176

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

Total 100%

Articulation of Response

Submission has no major errors related to grammar, spelling, syntax, organization, or citations

Submission has major errors related to grammar, spelling, syntax, organization, or citations that negatively impact readability and articulation of main ideas

Submission has critical errors related to grammar, spelling, syntax, organization, or citations that prevent understanding of ideas

10

page3image1373020960 page3image1372966128

3

3-1 Discussion

Overview: The importance of compensation varies depending on the viewpoint, as stated by Barry Gerhart and Jerry Newman in Compensation. Society views compensation as a measure of justice; managers may view compensation as a major expense or a motivator; employees view compensation as an entitlement or as an incentive. Regardless of the viewpoint, fairness and equity are essential. Compensation must also be up-to-date, competitive in the market, and easy to understand.

Aligned pay structures support the way the work gets done, fit the organizations business strategy, and are fair to employees. Organizations typically task an in- house human resource (HR) professional or hire an HR consultant to create and maintain the companys pay structure.

Prompt: In Milestone One, you will address the internal consistency component of a pay structure using the specially designed case scenario. Read the Final Project Case Study (linked to in your course) for detailed information on the requirements for this project.

Specifically, you must address the critical elements listed below. Internal Consistency:

  1. Create complete job descriptions for the benefits manager and production worker position using O*NET. Note: There may be several versions of these positions on O*NET. You should create personalized job descriptions that are tailored to the company.
  2. Calculate the job evaluation points for the administrative assistant, operations analyst, production worker, and benefits manager jobs. Provide a rationale for assigning specific weights and degrees to the various jobs. Use the job descriptions you created in section one, as well as the job descriptions in Appendix A of the final project case study, as a reference. Note: The weights, broken down by the compensable factors, must total 100%.
  3. Create job families for all the roles at the Rockville location. The families may be illustrated in a table or bullet format. List positions within each family based on the difficulty level. Provide a rationale for why jobs were assigned to the various families.
    Rubric

Guidelines for Submission: Your final project will be a Word document, approximately 59 pages in length (plus a cover page and references) and must be

written in APA format. Your Word document may include Word tables, Word lists, Excel screenshots, and rationale in written paragraphs. Use double spacing, 12- point Times New Roman font, and one-inch margins.

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

page1image1448887280 page1image1448887568 page1image1448887856 page1image1448888144 page1image1448888432

Internal Consistency: Job Descriptions

Provides complete job descriptions tailored to the company

Provides job descriptions that are incomplete or are not tailored to the company

Does not provide job descriptions required

25

1

page2image1449101680 page2image1449102080 page2image1449102432 page2image1449102720 page2image1449103008page2image1449103360

Critical Elements Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

Internal Consistency: Job Evaluation

Provides complete job evaluations for all identified job descriptions and explains rationale for assigning specific weights and degrees to the jobs

Provides incomplete job evaluations for all or some of the identified job descriptions or does not explain rationale for assigning specific weights and degrees to the jobs

Does not provide complete job evaluations for identified job descriptions and does not provide rationale for specific weights and degrees to jobs

35

Internal Consistency: Job Families

Provides logical job families for all job roles and explains rationale for why jobs were assigned to the job families

Provides illogical job families for some of the job roles or does not explain rationale for why jobs were assigned to the job families

Does not provide job families and does not provide rationale

20

Articulation of Response

Submission has no major errors related to grammar, spelling, syntax, organization, or citations

Submission has major errors related to grammar, spelling, syntax, organization, or citations that negatively impact readability and articulation of main ideas

Submission has critical errors related to grammar, spelling, syntax, organization, or citations that prevent understanding of ideas

20

Total 100%

page2image1448506032 page2image1448506320