SQL powerpoint project for Business Analytics nanodegree

SQL powerpoint project for Business Analytics nanodegree

Presentations You are now on the portion of the project you will need to submit to a reviewer. To pass this project, follow the below instructions to create a presentation. Your presentation should include: Four slides One visualization per slide A 1-2 sentence explanation of each slide The SQL query is used to create the data used in the visualization. Note: you may choose to use queries motivated by the questions on the previous concepts or choose four entirely new questions. However, if you use any of the previous queries, they must have a JOIN as stated in the Rubric. The submission template is a Google Slides file. Make a copy of the submission template to complete your project. We suggest you use the layout provided, though it is not a requirement. Queries Please include a text file that includes each of the queries used to create the visualizations. Please format your queries for readability, use a SQL formatting tool like sqlformat.org sql-format.com Then paste your code into a plain text file .txt. You can use notepad on a Mac notepad++ atom or any other plain text editor Example of the rubric items for the SQL queries for this project, which you and find in the rubric. Rubric items that pertain to your sql queries An image showing SQL queries in plain text. Example queries in plain text Put your text file and presentation in a folder and zip it. Then submit the zipped folder for your project. A slide template is provided here, at the bottom of the page, and in the classroom resources: Submission Template Visualizations We suggest using a spreadsheet application, such as Excel or Google Sheets, to create your visualizations. However, you’re welcome to use whatever tool you’d like. Your visualizations could be any that you learned about in the previous lesson. Below is one example, and a link has been provided to an example slide. Example of a horizontal bar chart showing the total spent by each country in U.S. dollars with an explanation of what the visualization is showing. You should have four slides similar to the example above, but the questions you ask are up to you, and all four of your final submitted queries should contain a JOIN and AGGREGATION. Look at the Rubric to verify you have met all of the necessities for this submission. How to Get Data Into Excel To export the results of your queries from DB Browser, use the button below and to the right of the results window. Below shows you how you can export your data to spreadsheet software. To create the visualizations like those shown in the link above, you will need to move your data out of SQL and into Excel (or another spreadsheet application). Find the export button, which is a download icon and could be located in different places depending on your version of the software Find the export button. NOTE: it may be in a different location depending on your software version. Select Export to CSV, and then select the settings that match the ones below. Make sure your setting on Newline characters is set to Unix: LF(\n). Then you should be able to use open the data in your spreadsheet application. Make sure your setting on Newline characters is set to Unix: LF(\n) Additional Guidelines There shouldn’t be any additional data prep (sorting, filtering, renaming, etc.) between the query output and the visualization. All your four queries must include at least one join and aggregation. Review your project against the project Rubric. Reviewers will use this to evaluate your work. The first part of this project is aimed at helping you understand the database, so you can ask interesting questions in the second part. Feel free to use and expand upon the queries you wrote in the first part. Once you’ve finished your project, submit the presentation as a PDF and the queries as a .txt file. Don’t be afraid to challenge yourself! Try to combine the SQL concepts you know! In order to review your presentation, you will need to save your slides as a PDF. You can do this from within a presentation tool by selecting File > Download as > PDF Document. Supporting Materials SQL Project Submission Template ———-

Get Your Custom Essay Written From Scratch
Are You Overwhelmed With Writing Assignments?
Give yourself a break and turn to our top writers. They’ll follow all the requirements to compose a premium-quality piece for you.
Order Now