Tableau Project – Car Insurance Claim project

 

Dear Participants,

Today many big organizations are sitting on large chunks of data, not knowing what to do with it. They invite consultants & business analysts to have a look at data and come up with insights that could help the organization run their business better. There is no clear set of instructions in such open-ended problems and it is expected of the consultant to do a lot of exploration first and formulate the problems themselves. These DVT projects fall into the bucket of such open-ended problems and a specific problem statement has not been given intentionally. It is expected of students to explore the data and come up with good insights. There is no right and wrong answer here. There should a clear logical story which should come out of their submission.”

Please find below DVT Project instructions:

Note: Please upload the project on Tableau public and include the URL in a word doc and upload it.

  • Any assignment found copied/ plagiarized with another person will not be graded and marked as zero.
  • Please ensure timely submission as a post-deadline assignment will not be accepted.

Please find the instructions here.

To learn how to publish your tableau file, click here.

Please use the following  datasets- (Car Claim Insurance.xlsx)

Business Context 

We are all aware that accidents are prone everywhere due to negligent driving or climatic conditions. An insurance company always needs to be prepared to estimate the number of accidents and the claims that they can receive at a given point time. Also understanding the pattern of claims would help the companies to frame different types of policies for the users providing better benefits and at the same time increasing the premium to the company.

Problem Statement:

Consider that you are a Lead Data Analyst at an Insurance Claims company that has provided you with the Car Insurance Claims dataset. You have been given a task to explore the data, create different plots and interpret useful insights/findings. Your end goal here will be to create a storyboard that you have to present to the Senior Management and the story has to have an end objective and should follow a logical flow to display that you are heading towards achieving the end objective. This will help the Senior Management in taking some decisive actions on the current claims system in place. This storyboard will be an open-ended story for you to explore various different features in the data and try to showcase different plots. Make sure to have minimum clutter in the plots, follow a consistent color scheme across all the plots, and use proper colors to highlight a specific insight. Moreover, your plots on all the dashboards should be interactive and responsive. There should be 1 dashboard that should cover the summary of the story as well as your recommendations.

Important Note: Please reflect on all that you have learned while working on this project. This step is critical in cementing all your concepts and closing the loop. Please write down your thoughts here.

Regards,

Program Office

 CriteriaPoints

Creation of multiple charts and tables for representing useful insights/findings. The charts used should be inline with the objective that you wish to convey to the Senior Management.
[Mandatory 8 types of charts/tables from any of the following: text table, bar chart(multiple/stacked/side by side), bubble chart, treemap, Pareto chart, scatterplot, Wordcloud, line plot, histogram, boxplot, circle views, heatmap, highlighted tables. No restrictions on the upper limit of the number of charts/tables to be used]  16 points

Creating a calculated field. The calculated field should add some meaningful value and should be inline with your storyboard which you will create in this project. (Specify where calculated field has been used)

2 points

Use of filters, parameter, actions, etc in the charts.

4 points

Minimal clutter and consistency in use of colors across charts.

5 points

Multiple Dashboards creation

At least 5 Dashboards 10 points

Correct interpretations/insights from each type of chart created. The interpretations should be inline with the storyboard which is to be created in this project.

These interpretations can be in the captions of the storyboard or in the plots as well 16 points

Interactivity among the charts on each Dashboard 5 points
Storyboard Creation

At least 1 Storyboard 15 points

Logical flow to the story represented in the storyboard. 5 Points
1 dashboard which will cover the summary and the recommendations from the insights to be added to the end of the storyboard

This dashboard will be an extra dashboard apart from the mandatory 5 dashboards mentioned in the 5th part of the rubric. At least 5 summary/recommendation points should be mentioned in this dashboard(at least 1 recommendation/summary point from each dashboard you created). 1 conclusion point of the story. This dashboard has to be a part of the storyboard created and not to be submitted separately. Note: This will not be evaluated if submitted as a separate dashboard/storyboard. 

File attachment

Data Structure

Instructions

Comparison of SORT algorithms

The objective of this Assignment is to compare the performance of some standard SORT algorithms.

You should look at MergeSort, QuickSort, (see attached code) and Selection Sort (from Week 2); you can also look at an additional Sort mechanism that isn’t covered in class or that isn’t covered in the book for extra credit. OR you can find an implmentation of Radix Sort.

You will have to find the right implementation in Java so that you can make your comparisons for the 4th algorithm (if you choose to go for the extra credit).

Things you will be comparing are the raw running time (measured with Java time functionality) and the time complexity (iteration count) in terms of a key operation for the algorithms (ex: as we discussed in class for Selection Sort comparisons are often a good way of measuring the time complexity of sort algorithms), for this purpose you’ll have to use meaningful count variables.

Refer to https://docs.oracle.com/javase/7/docs/api/java/lang/System.html for time methods. 

Use:

https://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTimeMillis()

or

https://docs.oracle.com/javase/7/docs/api/java/lang/System.html#nanoTime()

as you see fit.

Testing:

When comparing algorithms you want to make sure that you use a wide variety of test cases. In your case, you should have at least 4 different example sets on which to run your tests, each test case should have at least 20 numbers.

Report:

If you chose a 4th algorithm for extra credit, discuss which is the 4th algorithm and why you chose that.

You must have MergeSort, QuickSort, and Selection Sort.

Discuss your plan for testing. Explain the 4 test cases that you chose and explain briefly why you chose those test cases. Test cases must have at least 50 integers or more.

Summarize your results for both measured running time and time complexity.

Describe your conclusions including insights, and surprises if any. How does the measured time complexity compare with the expected O cost?

Grading:
1. Test plan and code implementation: 50 points
2. Report and results: 40 points

3. What is the sorting mechanism that Arrays.sort() uses? How does that compare with the others? 10 points

4. Extra credit: up to 20 points

MAKE SURE TO USE TEAMS for discussion and to clear doubts.

You can either use the class attached or you can copy and paste into separate classes. 

Additional resources for assignment

BigDataPlatform

Topic:  Big data platform (Project with 6- 7 pages)

1. Cover page

2. Abstract

3. Introduction (including motivation)

4. Related Journal/article review

5. Major Components of your topic

6. Research/analyze mechanism/scheme/approach

7. Simulation/experimental/comparison/analysis and discussion

8. Final concluding

9. Reference article/websites

Exp19_PowerPoint_Ch02_CapAssessment_Food

  

Project Description:

Your school’s Culinary Club is raising money for the local food bank. You volunteer to create a slide show that will be shown at a potluck fundraiser put on by the club. In this activity, you will create a presentation that meets slide show design principles, and has shapes, animation, video, and audio.

     

Start PowerPoint. Download and   open the file named Exp19_PPT_Ch02_CapAssessment_Food.pptx.   Grader has automatically added your last name to the beginning of the   filename

 

Replace Student Name in the subtitle placeholder on Slide 1 with Carl   Patterson Change   the title font size to 54.

 

Click Slide 2. Change the title font size to 48. Change the subtitle font   size to 32.

 

Click Slide 3. Change the title   to sentence case. Change the title font size to 54. Change the bulleted text   to 32.

 

Click Slide 4. Change the title   font size to 48. Change the bulleted text to 32.

 

Click Slide 5. Change the title   font size to 48. Change the subtitle font to 27.

 

Click Slide 4 and insert a heart   shape. Size it to a height of 2.5” and a width of 2.75” . Apply Colored Fill – Red, Accent 1, Darker   25%. Apply a shape outline in Black, Text 1. Apply Preset 2 as a shape   effect. Position the shape horizontally at 10.35” from the Top Left Corner.   Position the shape vertically at 4.9” from the Top Left Corner.

 

Click Slide 2. Select the   subtitle text and add the Zoom Entrance animation. Click After Previous in the Start box.   Adjust the Duration to 01.75 and the Delay to 00.50.

 

Click Slide 3. Select the first   text bullet and apply the Fade Entrance effect. Set the animation to start   After Previous with a Duration of 02.00 and a Delay of 01.75. Click the   Animation Pane, and then click the arrow for the first bullet. Select Effect Options   to access the Fade dialog box. Set the After Animation to Orange (sixth from   the left) on the Effect tab.

 

Select the second text bullet   and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a   Delay of 01.75. Click the arrow for the second bullet in the Animation Pane.   Select Effect Options to access the Fade dialog box. Set the After Animation   to Orange (sixth from the left) on the Effect tab.

 

Select the third text bullet and apply the   Fade Entrance effect. Set the animation to start After Previous with a   Duration of 02.00 and a Delay of 01.75. Click the arrow for the last bullet   in the Animation Pane. Select Effect Options to access the Fade dialog box.   Set the After Animation to Orange (sixth from the left) on the Effect tab.

 

Click Slide 4 and select the   heart shape. On the Animations tab, in the Animations group, click More and   add the Pulse Emphasis effect. Set the animation to start After Previous with   a Duration of 02.00 and a Delay of 0.25. Click the arrow for the shape in the   Animation Pane. Select Timing and set Repeat to Until End of Slide and click   OK.

 

Click Slide 1 and add the Fade   transition. Set the Duration at 01.00. Set the slides to advance   automatically after 00:07.00. Set it to apply to all.

 

Click Slide 5. Insert the   downloaded video file Veggies.mp4

 

Apply the Rounded Diagonal   Corner, White moderate video style.

 

Set the video to start Automatically. Change the Video   Options to Hide While Not Playing and to Rewind after Playing. Compress the media in the   presentation using the Standard setting. Mac users, compress all pictures in   the presentation using the On-screen setting.

 

Save and close Exp19_PPT_Ch02_CapAssessment_Food.pptx.   Exit PowerPoint. Submit the file as directed.

Write A 4 Page – Paper In APA Format With Summary

For your final paper, compare the uses, speeds, and benefits of WiFi vs cellular wireless technologies in a business environment. Present a business case where WiFi is most appropriate, and a second case where cellular service is more appropriate. Research and support your reasoning and recommendations.

python program

 

2. Write your own unique Python program that has a runtime error. Do not copy the program from your textbook or the Internet. Provide the following.

  • The code of your program.
  • Output demonstrating the runtime error, including the error message.
  • An explanation of the error message.
  • An explanation of how to fix the error.

Itsd427u2ip

Assignment Description

Note: Prior to developing your project, please make sure you have downloaded and installed the Android Studio IDE and the Android Development Tools (ADT) according to the instructions found by clicking here.

Assignment Details

You have been hired to create a mobile application for Healthy Life, a local organic bakery and grocery store. The owners want to offer a mobile application to customers that features recipes that contain ingredients that they sell in their store. Over the next few weeks, you will be developing, testing, and deploying the mobile application based on the specifications provided for each assignment. Once completed, you will be demonstrating the mobile application to the client.

The following specification is what the client has requested:

  1. Create a new Android Application Project.
  2. The main screen should state the name of the person who owns the phone.
  3. The recipe application should have a tile or visual shortcut placed in the application list.
  4. The application should have a splash screen that serves as an appropriate graphical advertisement for the application.
  5. The application should use an appropriate template design and application icon image.
  6. Once opened, the main page of the application should use the page name of Healthy Life and a normal full-screen layout using a 2-column grid control in the Content Panel with 4 buttons in the right column and 4 corresponding images in the left column of the grid control. The text of the four buttons should read: BreadFruitsVegetables, and Soup, respectively. Note: In Phase 5, the buttons will be linked to the corresponding recipe category in a local database.
  7. Test your application by running the Android Phone Emulator.
  8. Create screenshots of all of the relevant screens of your running application, and save them in a Word document named “yourname_ITSD427_IP2.docx.” You should also use this document to describe the work you performed for this assignment, with specific details regarding the locations and changes of the code you created and modified.
  9. Save and close the project. Zip the entire project, including your screenshots and work description, to a file named “yourname_ITSD427_IP2.zip,” and submit the ZIP file to the dropbox.

NOTE: Please download android studio to complete this work

Assignments

Please find attached document and work on each topic as instructed in that. please reach out to me if any question.