SQL

 

Exercise 1: Histogram

Exercise 1 in the text: You may use any spreadsheet program. Submit a Word document with a screenshot from your computer showing the histogram. Comment your images with a sentence or so of description in your own words of what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. 

 

Execise 2: Calculating Quartiles

Exercise 2 from the text: Use any spreadsheet program. Submit a Word document showing a screen shot from your computer with the quartiles underlined or highlighted.  Comment your images with a sentence or so of description in your own words of what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

 

Exercise 3: Central Tendency

Exercise 3: Use any spreadsheet program. Submit a Word document with a screen shot from your computer showing the highlighted median.  Comment your images with a sentence or so of description in your own words of what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. 

 

Exercise 4: Dispersion

Exercise 4: Use any spreadsheet program. Using the data provided in the text, submit a Word document with a screen shot from your computer highlighting the range, standard deviation, IQR, and outliers of Add-on Sales.  Comment your images so the viewer knows what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results

 

Exercise 5: Pearson Correlation

Exercise 5: Use any spreadsheet program. Using the data provided in the text, create a scatter plot and calculate the Pearson Correlation Coefficient. Comment your images with a sentence or so of description in your own words of what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. 

 

Activity 2: Exploring Sales Data

There is no activity 1.

Activity 2: Use the attached dealerships.csv file and any spreadsheet program. Submit a Word document with a screen shot from your computer of your solutions to questions 2 – 7 in the text. Highlight your results.  Comment your images with a sentence or so of description in your own words of what you are doing.  Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results

week 7 paper work (Business Intelligence)

        

W7: Paper

Graded Assignment:  Knowledge and Skills Paper

Paper Section 1: Reflection and Literature Review

Using Microsoft Word and Professional APA format, prepare a professional written paper supported with three sources of research that details what you have learned from chapters 13 and 14.  This section of the paper should be a minimum of two pages. 

Paper Section 2:  Applied Learning Exercises

In this section of the professional paper, apply what you have learned from chapters 13 and 14 to descriptively address and answer the problems below.  Important Note:  Dot not type the actual written problems within the paper itself.

  1. Go to cloudera.com, MapR.com, hortonworks.com, or marklogic.com or in combination to find at least three customer case studies on Hadoop implementation, and then discuss the commonalities and differences of these cases.
  2. Search the job search sites like monster.com, careerbuilder.com, and so forth. Find at least five job postings for data scientist. Identify the key characteristics and skills expected from the applicants and based on what you are learned in this class, how high is your motivation now to seek these types of career choices?
  3. Important Note:  With limited time for a college class, perfection is not expected but effort to be exposed to various tools with attempts to learn about them is critical when considering a career in information technology associated disciplines.

Important Note:  There is no specific page requirement for this section of the paper but make sure any content provided fully addresses each problem.

Paper Section 3:  Conclusions (Part 1)

After addressing the problems, conclude your paper with details on how you will use this knowledge and skills to support your professional and or academic goals. This section of the paper should be around one page including a custom and original process flow or flow diagram to visually represent how you will apply this knowledge going forward.  This customized and original flow process flow or flow diagram can be created using the “Smart Art” tools in Microsoft Word.

Paper Section 4:  Overall Course Conclusions and Reflection (Part 2)

After the primary conclusion of this paper, extend this conclusion into an overall class conclusion and reflection providing at least 500 additional words of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current or future work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.

Paper Section 5:  APA Reference Page

The three or more sources of research used to support this overall paper should be included in proper APA format in the final section of the paper.

Connection assignment 2

 

Provide a reflection of at least 500-800 words of how the knowledge, skills, or theories of “  – Information Security & Risk Management  ” have been applied or could be applied, in a practical manner to your current work environment(software developer). If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

Provide an 500-800 word minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

Share a personal connection that identifies specific knowledge and theories from this course.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

Research Paper

Main Topic: How are companies using sentiment analysis to improve customer relations?

Sub Topic: MEASUREMENT AND IMPROVEMENT OF MARKETING STRATEGIES,

Please work on the sub-topic, for your reference I added the main topic as well,

I need a total of 600 words with 2 references, the paper should be in APA format and I need a plagarisim report as well

Thanks

Job search 3.0

Research project manager’s positions and please post the following. Please do not copy and paste from web sites.

  1. Find three different job postings in the area you live in for a Project Manager. What are the items in the three job ads that are the same? Are there any major differences? Also, look up how much a project manager earns in your area. 
  2. In your opinion was any of the information that you uncovered in your search interesting or surprising?
  3. 1000 words

Excel Worksheet

  

A window blind company owner never knew how exactly how much material he needed for any single project. He would estimate the amount and put that figure into Excel. When he estimated too much, it cost him money for materials he didn’t use. When he estimated too little, it delayed the project’s completion because he had to get more material from his supplier. Plus, he used Excel as if it was just a paper chart.

Solution: Worksheet Creation

· Use Excel to create a worksheet for each order as part of a workbook for orders to his suppliers. 

· After all the individual orders are entered in the workbook as worksheets, the new Excel workbook calculates how much material was needed for was needed for the entire group of orders. 

· The worksheet should demonstrate savings for the company in time and money because the owner could order the right amount of material from his suppliers and allocate it correctly to the customers’ jobs.

Data Mining Techniques in Transportation safety (National Highway Traffic Safety Administration – NHTSA)

For this project, you will write a 10-page APA formatted paper followed by a PowerPoint Presentation on a how a particular organization that has experienced some type of Security or Privacy Challenges around Data. You will explain the following: 1) Why the challenges exist, 2) What is the general approach to solve the challenges, 3) What kind of data tools or databases do you plan to use, and 4) Finally what risk concerns were addressed by solving the Challenges. You should describe your problem, approach, dataset, data analysis, evaluation, discussion, references, and so on, in sufficient details, and you need to show supporting evidence in tables and/or figures. You need to provide captions for all tables and figures. 

i m looking for research paper and powerpoint PPT 

assignment

  

· Pick two (2) charts of different chart type (Categorical, Hierarchical, Relational, Temporal and Spatial) [Do not choose bar, pie and line charts)

· For each use a tool that can be used to create the selected chart. Use a different tool to create each chart.

· For each chart, write how to read the chart and what to look for.

Delivery: A word file with the following information:

1. 2 Charts

2. 2 Screenshots of the charts in development with the tools selected.

3. Paragraphs detailing how to read each chart and what to look for.

Analyzing and Visualizing Data

  

  • Outline for Assignment 1
    • Refer to the Documenting Research Guide for assistance in organizing your research and developing your outline.
    • You can find this guide in the Useful Information folder, as well.

Outline for Assignment 1

Using the Documenting Research Guide and the assignment 1 instructions, develop your outline. Submit the outline in an MS Word document file type. Utilize the standards in APA 7 for all citations or references in the outline. Ensure that the document includes your name. Do not include your student identification number. You may use the cover page from the student paper template. The assignment 1 instructions are at the bottom of this content folder.

Submit your outline on or before the due date.

By submitting this paper, you agree:

(1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy;
(2) that your institution may use your paper in accordance with UC's policies; and
(3) that the use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.