steel homeworkthe subject for this assignment is steel in civil engineering. Here you not designing, you only need to determine what is been asked in section A, for section B you need to have access to U.S. Steel design manual. “the two sections are related in one question”
Tableau 2 Assignment – NOTE: there are several submissions – be sure to check out the details on this..• If you didn’t complete the Tableau 1 project, please consider doing that tutorial so you know how Tableau works. Ata minimum, refer to the Tableau 1 project instructions to download and register for the Tableau software. See theTableau 1 assignment or the Tableau Overview page in the Modules area on Canvas.• Download the project data file (Tableau 2 Data F20.xlsx) from the Tableau 2 assignment.• The scenario for this assignment is that you have been given a data file and have been asked to evaluate the sales forthe various product lines. The data owners admit that the data may not be ‘clean’, meaning it may have errors.• How to start? One good way to start is to use Excel filtering to check out what is in each field. For example, if you turnfilters on and then filter on year, you can see how many years the data spans, or the types of products or states whereproduct is sold. You can also use pivot tables. Getting an overview with Excel can be helpful. Then you’ll analyze thedata with Tableau to see what sales / marketing recommendations you can make for thefuture, given several years’ data. Page 3 of these instructions has notes on analyzing data.• Data / Prep• Import the data: Open Tableau, go to the Connect pane (left) and click on Microsoft Exceland browse to the data file and click ‘Open’• Open a blank sheet and check the field properties,o Geographic fields (locations) should have a globe-like icon next to them. If they don’tyou can this property. Right click the name (Region, for example), select ‘geographicalrole and then select country / region.NOTE: Keep the geographical roles of fields State and State Abbrev as State/Province.o For currency fields, right click each field, select ‘Default Properties’, then ‘Number Format’ and select ‘Currency(Standard)’.o For percentage fields, do the same but select percentage with 1 decimal place.• You can now start analyzing the data. The last page of this document has guidelines and tips to get you started. Afew additional suggestions: with this data, some things to investigate might be states or regions with high sales(what is selling?), those with low sales (what isn’t selling?), states in a region and what seems to be similar in termsof sales. Any outliers you see, drill down and see what is causing the variation in sales.Deliverables:1) Tableau Workbook Analysis (worth 35 points)Save your Tableau workbook as a Tableau Packaged Workbook (.twbx). USE ‘SAVE AS’. Name it yourlastname_Tableau2.twbx. See the Tableau 1 instructions for more on this saving workbooks correctly.Your tableau workbook should include:1) The Data2) At least 4 worksheets / visualizations (3 different formats, at least one map). Include filters, colors, and labelsin your charts.3) At least 1 interactive dashboard (made up of at least 2 visualizations)4) One story made up of at least 5 panes – all worksheets / visualizations and your dashboard(s).5) Comments on each story pane briefly explain what you are showingFor notes on how to analyze the data, see the last page of these instructions: “Analyzing Data – Tableau 2.pdf”2) Word Documentation (worth 40 points) – Name your Word document yourname_Tableau2.docx. Includethe following sections:Part 1) The Data – A paragraph describing the data – what’s included in the columns and rows and how youapproached the analysis of this data. This should include: 1) what you did to initially analyze the data, 2) howthe initial data analysis influenced the types of visualizations you included, 3) any problems you had and 4) anychanges in your thoughts about the data as you worked through the project.Part 2) Workbook Sheets – Screenshots of the (at least) 4 sheets that you’ve created. Do not use cell phonepictures. Below each screenshot, include a detailed paragraph (more than a few sentences) describing: 1)what you are showing AND what you learned about your data from the visualization, 2) what led to thisvisualization and 3) the relevance / importance in relationship to the data. Also include 4) why you chose theparticular visualization format and 5) a response to the question, “Why is this analytic / visualizationmeaningful?”Part 3) Workbook Dashboard – Include a screenshot (not a cell phone picture) of at least 1 dashboard and belowthe dashboard a detailed paragraph describing: 1) what the components you included & how the interactionworks, 2) why you included them and 3) what’s the point of this collection of sheets – why did you includethem together, what’s do they show as a group?Part 4) The Story – You don’t need a screenshot of each pane in your story. But 1) Describe a narrative of howyour worksheets and dashboard(s) tell your analysis ‘story’. 2) Include the points you are making by includingthem in the ‘story’ and 3) your specific recommendations to improve sales / profits going forward.Part 5) Conclusions – A paragraph describing what you learned about Tableau. Include skills learned and obstaclesovercome.3) YouTube Video (worth 25 points)Create a short video (5 minutes at a minimum and no phone videos) that includes:
You! Introduce yourself, using your laptop camera to record yourself* (your face!) so you are included in the video.
Switch your video to your desktop* and with your Tableau file open, walk through your Tableau project, describing:a) The datab) Each of your 4 (or more) worksheets / visualizations, explaining why each analytic is meaningfulc) Your dashboard(s) – what is included and why you included these visualizations. Your dashboard should beinteractive, so demonstrate this.d) Your analysis ‘story’ – what all of your analysis shows, the conclusions and your recommendationse) What you learned about Tableau and your data(Use your Word document above to guide your video script.)
Upload your video to YouTube as an unlisted video and test your URL / link.Information on video software, uploading to YouTube and Tableau/Video/YouTube help sessions can be found at the“Tableau Projects and Citizen Data Science Certificate” document, found in our Tableau Overview page (modules area).*If you are using software that records your desktop and records you at the same time (in a small inset window), you cando your introduction in this format.Submitting your Deliverables – READ THIS CAREFULLY – follow all steps
Upload to the Tableau 2 Canvas Assignment. This should include:1) your Tableau Packaged Workbook, ‘saved as’ a Tableau Packaged Workbook .twbx (or we won’t be able tograde it. Named correctly.2) your Word document, named correctly.3) and the URL to your video story (add this to the comment area of your submission)
Complete the Citizen Data Science Certificate Survey (another assignment on Canvas). You’ll just enter your nameand the URL to your YouTube video. Just the URL, no comments please. Something like http://youtube…. You won’tget credit towards the Citizen Data Science Certificate unless you complete the project fully and complete this survey.
ALSO submit another copy of your Word document to the Canvas assignment called, ‘Tableau 2 TurnItIn Submission’.Your Word document must be submitted to both assignment areas to be graded.Tableau is being used in many businesses so be sure to include Tableau, Access and Excel in your resume when mentioninganalytics.Analyzing Data & Tips / Notes (next page) – Tableau 2How do I get started? Using the Tutorial (Tableau 1) as a guide, you can follow a very similar process:
Look at the source data to get an idea of what it’s all about (you can do this either in Tableau or look at it in Excel).If you are using Excel, you can do some filtering or pivot tables to see what is in each field – looking for any outliersor interesting trends. Some things you might want to look at are: Dates, any spikes or dips in sales, which brands / departments, which states or regions, profits Cities, states or regions, what sells, how much in sales and/or profit Brands or departments – what sells best in which states or regions, at which times, etc.
In Tableau, create an initial broad visualization (sheet #1) and again, notice some outliers or some trends that maybe interesting
Create sheet #2 to further explore either the outlier(s) or the trends. For example, depending on your data, thiscould lead to geographic questions, questions relating to years, specific products, departments, etc. You can dothis by duplicating sheet 1 and filtering / drilling down.
Create sheet 3 to explore the questions in sheet 2 in more detail – by filtering again and /or showing some differentattributes (fields) and using a different visualization format. This will lead to more questions about the trend /outliers that you can further drill down to analyze
Sheet 4 (or more) will let you keep looking at the data in more detail until you figure out what triggered the outlieror is most responsible for the trend. Depending on your data, this could be product sales in a specific region or by aspecific product or department.
When you have figured this out – come up with one or more recommendations. Depending on your data, it couldbe something like – don’t sell xxx in this state, or this was a bad month for product xxx in state yyy, but theyrecovered, or… whatever you discover. Create a dashboard or two to illustrate this.
Then go back and create a story with your sheets and dashboard(s), be sure to include all of the required Tableaufeatures (see the instructions on this) .TIPS / Notes• Take advantage of FILTERING. To do this, select the data type you want to filterand drag it to the filter ‘box’o For example: drag the ‘Sales Date’ to the Filter box >> double click‘Months’ >> and try selecting the months you want or select ‘All’o Then you can also right click the ‘Month…’ label in the filters box andselect ‘Show Filter’ and the checklist will show up on the right and youcan select months that way.• You can do similar filtering with other fields.
Get professional assignment help cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why choose our academic writing service?
Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently
Get Professional Assignment Help Cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor’s, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why Choose Our Academic Writing Service?
Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently
How It Works
1. Place an order
You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.
2. Pay for the order
Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.
3. Track the progress
You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.
4. Download the paper
The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.
PLACE THIS ORDER OR A SIMILAR ORDER WITH Essay fount TODAY AND GET AN AMAZING DISCOUNT
The post steel in civil engineering appeared first on Essay fount.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
