Data Cleansing and Data Summary

This is a Collaborative Learning Community (CLC) assignment. Now that you have identified the business problem translated it into an analytics problem identified the data needs and acquired the data you will use data that you have found (or with the companys permission you can use its data for analysis) to resolve the analytics problem. Using one or more of the following software applications (IBM SPSS Modeler SPSS Statistics Excel PowerBI Tableau or R) analyze the data so that the findings can be used to address the established business problem in your company. Conduct an exploratory data analysis and provide a draft outline describing the key features of the data and any significant relationships and information contained in the data set that you found. You are required to include specific screenshots of graphs tables etc. that are provided: Provide the raw software files (Tableau or PowerBI) that you used for this assignment. Synthesize the information from your draft outline to complete in 1500–2000 words the relevant components in the Data Diagnostics and Descriptive Summary section of the “Capstone Project Thesis Template.” Submit your draft outline raw data Excel files screenshots and the updated “Capstone Project Thesis Template.” Prepare this assignment according to the guidelines found in the APA Style Guide located in the Student Success Center. An abstract is not required. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance. Requirements: every thing is the question please use the tableau software and send me the files. How did you verify that the data was reliable before proceeding? What problems did you find and how did you address them? What relationships did you find in the data? Are there any missing data? How are you going to summarize data samples? Analyze trends with respect to any appropriate characteristics that you may have discovered. Include relevant line graphs pie charts bar charts and scatter plots. What have you done to prevent the Simpson’s paradox? Next you will work on a descriptive analytics. Supplement your description with appropriate charts/figures and finalize by creating an appropriate dashboard with PowerBI or Tableau. Include a summary that provides a detailed overview of the data behavior you have identified based upon the analysis. Indicate any causal relationships you found. Segment the data accordingly if needed to help describe the data behavior. Did you have to redo your sample? Can you identify any data anomalies? If there are anomalies what do they represent and how do you avoid them? Indicate the steps you have taken to investigate the quality of the data and indicate any variables you have transformed or discarded as a result. How did you verify that the data was reliable before proceeding?What problems did you find and how did you address them?What relationships did you find in the data?Are there any missing data?How are you going to summarize data samples?Analyze trends with respect to any appropriate characteristics that you may have discovered. Include relevant line graphs pie charts bar charts and scatter plots.What have you done to prevent the Simpson’s paradox?Next you will work on a descriptive analytics. Supplement your description with appropriate charts/figures and finalize by creating an appropriate dashboard with PowerBI or Tableau. Include a summary that provides a detailed overview of the data behavior you have identified based upon the analysis. Indicate any causal relationships you found.Segment the data accordingly if needed to help describe the data behavior. Did you have to redo your sample? Can you identify any data anomalies? If there are anomalies what do they represent and how do you avoid them?Indicate the steps you have taken to investigate the quality of the data and indicate any variables you have transformed or discarded as a result.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 3234125597

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 25% with the discount code CLASS