## build a workbook in Tableau: Data Analytics with Tableau – Exercise

in this exercise, Work through the steps of building a project in Tableau. Follow the steps that are described in the web site provided below. Once complete, submit the file for grading:

The following web site will walk through the process of building a workbook in Tableau:

https://deitatown.com/basic-tableau-2019-for-beginners-with-exercise-file/

## business analysis

There’s a growing demand for __business analytics__ and __data expertise__ in the workforce. But you don’t need to be a professional analyst to benefit from data-related skills.

Becoming skilled at common data visualization techniques can help you reap the rewards of __data-driven decision-making__, including increased confidence and potential cost savings. Learning how to effectively visualize data could be the first step toward using data to your advantage and adding value to your organization.

Several data visualization techniques can help you become more effective in your role. Here are nine essential data visualization techniques all professionals should know, as well as tips to help you effectively present your data.

WHAT IS DATA VISUALIZATION?

Data visualization is the process of creating graphical representations of information. This process helps the presenter communicate data in a way that’s easy for the viewer to interpret and draw conclusions.

There are many different techniques and tools you can leverage to visualize data, so you want to know which ones to use and when. Below are some of the most important data visualization techniques all professionals should know.

DATA VISUALIZATION TECHNIQUES

- Pie Chart

Pie charts are one of the most common and basic data visualization techniques, used across a wide range of applications. Pie charts are ideal for illustrating proportions, or part-to-whole comparisons.

Because pie charts are relatively simple and easy to read, they’re best suited for audiences who might be unfamiliar with the information or are only interested in the key takeaways. For viewers who require a more thorough explanation of the data, pie charts fall short in their ability to display complex information.

- Bar Chart

The classic bar chart, or bar graph, is another common and easy-to-use method of data visualization. In this type of visualization, one axis of the chart shows the categories being compared, and the other, a measured value. The length of the bar indicates how each group measures according to the value.

One drawback is that labeling and clarity can become problematic when there are too many categories included. Like pie charts, they can also be too simple for more complex data sets.

- Histogram

Unlike bar charts, histograms illustrate the distribution of data over a continuous interval or defined period. These visualizations are helpful in identifying where values are concentrated, as well as where there are gaps or unusual values.

Histograms are especially useful for showing the frequency of a particular occurrence. For instance, if you’d like to show how many clicks your website received each day over the last week, you can use a histogram. From this visualization, you can quickly determine which days your website saw the greatest and fewest number of clicks.

- Gantt Chart

Gantt charts are particularly common in project management, as they’re useful in illustrating a project timeline or progression of tasks. In this type of chart, tasks to be performed are listed on the vertical axis and time intervals on the horizontal axis. Horizontal bars in the body of the chart represent the duration of each activity.

Utilizing Gantt charts to display timelines can be incredibly helpful, and enable team members to keep track of every aspect of a project. Even if you’re not a project management professional, familiarizing yourself with Gantt charts can help you stay organized.

- Heat Map

A heat map is a type of visualization used to show differences in data through variations in color. These charts use color to communicate values in a way that makes it easy for the viewer to quickly identify trends. Having a clear legend is necessary in order for a user to successfully read and interpret a heatmap.

There are many possible applications of heat maps. For example, if you want to analyze which time of day a retail store makes the most sales, you can use a heat map that shows the day of the week on the vertical axis and time of day on the horizontal axis. Then, by shading in the matrix with colors that correspond to the number of sales at each time of day, you can identify trends in the data that allow you to determine the exact times your store experiences the most sales.

- A Box and Whisker Plot

A box and whisker plot, or box plot, provides a visual summary of data through its quartiles. First, a box is drawn from the first quartile to the third of the data set. A line within the box represents the median. “Whiskers,” or lines, are then drawn extending from the box to the minimum (lower extreme) and maximum (upper extreme). Outliers are represented by individual points that are in-line with the whiskers.

This type of chart is helpful in quickly identifying whether or not the data is symmetrical or skewed, as well as providing a visual summary of the data set that can be easily interpreted.

- Waterfall Chart

A waterfall chart is a visual representation that illustrates how a value changes as it’s influenced by different factors, such as time. The main goal of this chart is to show the viewer how a value has grown or declined over a defined period. For example, waterfall charts are popular for showing spending or earnings over time.

- Area Chart

An area chart, or area graph, is a variation on a basic line graph in which the area underneath the line is shaded to represent the total value of each data point. When several data series must be compared on the same graph, stacked area charts are used.

This method of data visualization is useful for showing changes in one or more quantities over time, as well as showing how each quantity combines to make up the whole. Stacked area charts are effective in showing part-to-whole comparisons.

- Scatter Plot

Another technique commonly used to display data is a scatter plot. A scatter plot displays data for two variables as represented by points plotted against the horizontal and vertical axis. This type of data visualization is useful in illustrating the relationships that exist between variables and can be used to identify trends or correlations in data.

Scatter plots are most effective for fairly large data sets, since it’s often easier to identify trends when there are more data points present. Additionally, the closer the data points are grouped together, the stronger the correlation or trend tends to be.

OTHER DATA VISUALIZATION OPTIONS

While the examples listed above are some of the most commonly used options, there are many other ways that you could potentially visualize data in order to become a more effective communicator. Some other data visualization options include:

- Bubble clouds
- Bullet graphs
- Cartograms
- Choropleths
- Circle views
- Dendrograms
- Dot distribution maps
- Highlight tables
- Correlation matrices
- Polar areas
- Radial trees
- Ring Charts
- Streamgraphs
- Timelines
- Treemaps
- Wedge stack graphs
- Word clouds and network diagrams

TIPS FOR CREATING EFFECTIVE DATA VISUALIZATIONS

Creating effective data visualizations requires more than just knowing how to choose the best technique for your needs. There are several considerations you should take into account to maximize your effectiveness when it comes to presenting data.

One of the most important steps is to evaluate your audience. For example, if you’re __presenting financial data__ to a team who works in an unrelated department, you’ll want to choose a fairly simple illustration. On the other hand, if you’re presenting financial data to a team of finance experts, it’s likely you can safely include more complex information.

Another helpful tip is to avoid unnecessary distractions. Although visual elements like animation can be a great way to add interest, they can also distract from the key points the illustration is trying to convey and hinder the viewer’s ability to quickly understand the information.

Finally, be mindful of the colors you utilize, as well as your overall design. While it’s important that your graphs or charts are visually appealing, there are more practical reasons you might choose one color palette over another. For instance, using low contrast colors can make it difficult for your audience to discern differences between data points. Using colors that are too bold, however, can make the illustration overwhelming or distracting for the viewer.

Related: __How to Learn Business Analytics Without A Business Background__

VISUALS TO INTERPRET AND SHARE INFORMATION

No matter your role or title within an organization, data visualization is a skill that’s important for all professionals. Being able to effectively present complex data through easy-to-understand visual representations is invaluable when it comes to communicating information with members both inside and outside your business.

There’s no shortage in how data visualization can be applied in the real world. Data is playing an increasingly important role in the marketplace today, and data literacy is the first step in understanding how analytics can be used in business.

Reference

https://online.hbs.edu/blog/post/data-visualization-techniques

## adults clinical week 7

Describe your clinical experience for this week.

- Did you face any challenges, any success? If so, what were they?
- Describe the assessment of a patient, detailing the signs and symptoms (S&S), assessment, plan of care, and at least 3 possible differential diagnosis with rationales.
__Please use a 32 years old patient with hypothyroidism symptoms.__ - Mention the health promotion intervention for this patient.
- What did you learn from this week’s clinical experience that can beneficial for you as an advanced practice nurse?
- Support your plan of care with the current peer-reviewed research guideline.

## Nursing adults Discussion week 7

you are seeing a 15-year-old female patient for a gynecological exam and to explore birth control options. The patient’s mother scheduled the appointment after learning that her daughter has become sexually active. The patient is current with all immunizations, including Gardasil, and has no significant health history that would contraindicate the use of birth control.

- This is the patient’s first gynecological exam, and she expresses feeling nervous and embarrassed that her mother has shared her sexual experience with strangers. Taking this into account, how would you begin the patient encounter?
- As you begin asking questions to determine the patient’s gynecological history, the patient appears frustrated and embarrassed and reminds you that she has only had sex one time. What should the patient understand about the importance of reviewing gynecological history?
- What are the most popular birth control methods prescribed in the United States? What determines the success or failure of a birth control method?
- The patient expresses a desire for the most effective form of birth control but is concerned about weight gain and other side effects. How should you respond to her concerns?
- The patient seems unsure about the best option for birth control and asks if she can take some time to think about the choices. As the use of birth control is ultimately the patient’s choice, you offer to answer any questions and agree to a follow-up visit or call. The patient asks whether using a condom is okay if she decides to have sexual intercourse before selecting a method of birth control. What should you tell her

## RES710: Week3 Discussion

Question 1

Write a 250- to 300-word response to the following:

- What is the difference between a normal distribution and a skewed distribution?
- What causes a skew and how might a researcher deal with skewed data?
- Under what conditions would it be acceptable to allow skewed variables in a research study?

Include your own experience as well as 2 citations that align with or contradict your comments as sourced from peer-reviewed academic journals, industry publications, books, and/or other sources. Cite your sources according to APA guidelines. If you found information that contradicts your experience, explain why you agree or disagree with the information.

Question 2

Write a 250- to 300-word response to the following:

- How will you use measures of central tendency in your dissertation research or professional practice? Cite specific examples of how you expect to apply this week’s topics.

Include your own experience as well as 2 citations that align with or contradict your comments as sourced from peer-reviewed academic journals, industry publications, books, and/or other sources. Cite your sources using APA formatting. If you found information that contradicts your experience, explain why you agree or disagree with the information.

## measures of central tendency

**Respond** to the following questions.

- What are some considerations for choosing a measure of central tendency?

[Enter your response here.]

- What impact do variable types have on testing when considering central tendency?

[Enter your responses here.]

- Which measure of central tendency was most appropriate for each of your variables? Why?

[Enter your response here.]

## Managerial Economics (ECO 506)

Use the dataset “assignment-data” available on LMS. It has a data by year on US gasoline consumption

(G), gasoline prices (PG), per-capita income (Y), price of new cars (PNC), price of used cars (PUC), and population (POP). By using the data, perform the following tasks:

- Calculate gasoline per capita consumption (GPC) and draw a line graph and interpret the trend.

**[2 marks]**

** **

Economic theory suggest the following, in relation to a demand function for the gasoline:

GPC = f(PG, Y, PNC, PUC)

With a regression model in log form as follows:

log *GPC *= log*A *+ *B*1 log *PG *+ *B*2 log *Y *+ *B*3 log *PNC *+ *B*4 log *PUC*

(1)

- Determine the signs of regression coefficients using economic theory and provide reasoning

- Run a simple regression model (by using equation 1 above) and interpret regression coefficients and elasticities and provide reasoning for each coefficient. Are the regression coefficients similar to the economic theory? If not, what could be the reason? Consult some academic literature.

**[10 marks]**

- Now create previous year gasoline consumption (LPrevGPC) variable as an independent variable and re-run regression model (equation 2) as follows:

log *GPC *= log*A*+*B*1 log *PG*+*B*2 log *Y *+*B*3 log *PNC*+*B*4 log *PUC*+*B*5 log *PrevGPC,*

(2)

Where the expression* B*1*/*(1 − *B*5) is in fact long run elasticity of demand. Calculate this long run elasticity of demand and interpret the number by comparing it with short run price elasticity. What conclusion would you draw from these estimates?

**[4 marks]**

- What sort of recommendations you would make as an analyst to an energy firm operating in the USA in relation to the pricing and disposable income in particular.

**[4 marks]**

** **

** **

## real estate

This week we will be discussing the final walkthrough before closing. Read The Balance’s article by Elizabeth Weintraub, “Tips for Doing the Final Walkthrough Before Closing on a Home” (attached). In it, Elizabeth stresses the point that final walkthroughs aren’t home inspections… nor are they a time to begin negotiations with the seller to do repairs.” Reflect on the information in the article, then give your thoughts on a few questions. Here we go…

- A point is made that buyers may be tempted to pass on the final walkthrough. What would you say to your clients to have them reconsider that stance?
: You do the final walkthrough with your client and find that some of the agreed upon repairs the seller agreed to have done… weren’t. How would you approach this situation?__Scenario #1__: The home inspection showed no blaring issues, but you do the walkthrough two-days before closing and you find a problem. How would you address this with your client, the buyer? The seller and their agent?__Scenario #2__

My discussion boards are opinion oriented. That being said, remember net etiquette and be sure to provide a brief explanation/justification for your viewpoint. There is no right or wrong answer to these questions, just your personal, thoughtful response.

## Mt 106 unit 9 journal: company branding

Branding is important for companies to establish themselves in the customer or client’s mind. As the marketplace becomes ever more competitive, the company must distinguish itself from the competition. Branding involves attributes such as the font type used in the company’s name, the company logo, and the social causes a company supports. It also involves how they treat stakeholders, their ethics, reputation, promotions, mission and values, all that people think of when the company’s name is mentioned. Think of Walmart’s logo symbolizing the inspiration of Sam Walton, the Google logo with its letters of different colors, McDonald’s arches, or Patagonia’s simple lowercase letters in a particular font. Each one of these companies has come to be associated with certain attributes in the customer’s mind.

**Scenario:** This company produces dog and cat treats and has a small kiosk in the town’s outdoor mall. They need your help.

Make sure to view the branding activity prior to addressing the bulleted items. Then do some research on the Internet on pet food and supply companies.

- Who does the scenario company want to attract to their products?
- What kind of competition do they have in the marketplace?
- What branding should they use? Describe it and why it is effective.
- How will they distinguish the branding you suggest from the competition’s?
- Where should the scenario company use this branding, and why?
- Create a brand for this business

## exam

- How many young people are there if there are 35 old people and the ratio of old to young is 7 to 1?

A) | 7 |

B) | 1 |

C) | 21 |

D) | 5 |

E) | 10 |

- If 28 out of 100 persons, on average, prefer to watch action movies, what is the nearest full percentage of those people, rounded to the nearest multiple of ten?

A) | 28% |

B) | 2.8% |

C) | 0.28% |

D) | 30% |

E) | 0.2% |

- One and a half pieces are required for one man to eat. There are four and a half portions required for three men to eat. How many servings are required if there are twelve men eating?

A) | Twelve |

B) | Fourteen |

C) | Sixteen |

D) | Eighteen |

E) | Twenty |

- A beverage with five measures of pineapple juice, one measure of orange juice, and three measures each of lime juice and orange juice. Five beverages will need to be made, so

A) | Twenty-five measures of pineapple juice, 25 measures of orange juice, and 15 measures of lime juice. |

B) | 15 measures of pineapple juice, 12 measures of lime juice, and 5 measures of orange juice |

C) | 15 measures of lime juice, 6 measures each of orange and pineapple juice, and 20 measures of each. |

D) | Six measures of orange juice, 15 measures of pineapple juice, and 15 measures of lime juice. |

E) | 25 measures of pineapple juice, 12 measures of lime juice, and 4 measures of orange juice |

- A t-shirt costs $4 extra for every ten people who purchase one. The t-starting shirt’s cost was $24. The t-shirt is purchased by 22 individuals. What is the current price of it?

A) | $36 |

B) | $34 |

C) | $32 |

D) | $30 |

E) | $28 |

- An organization that provides physical training maintains a ratio of at least three instructors to every ten students. The number of teachers must always be even. What is the minimal number of instructors needed in the organization if there are 110 pupils there?

A) | 34 |

B) | 33 |

C) | 32 |

D) | 36 |

E) | 30 |

- A group of pals, 72% of whom enjoy trekking in their spare time. Everyone else in the group does not. How may the number of friends, rounded to the next first decimal place, who don’t enjoy hiking be effectively stated as a percentage of the entire group?

A) | 0.28 |

B) | 0.3 |

C) | 0.2 |

D) | 0.38 |

E) | 0.7 |

- A project is being worked on by a group of writers. The job should be finished in 140 hours. The team initially consists of ten writers. The anticipated project completion time drops by 4 hours for each additional writer on the team. The anticipated project completion time grows by 4 hours if a writer departs. The crew grows by 50% in size. The group then includes one more person. What is the updated projected date of project completion?

A) | 124 hours |

B) | 130 hours |

C) | 114 hours |

D) | 120 hours |

E) | 116 hours |

- Two pieces of soft leather, three pieces of hard rubber, one piece of wood, and two pieces of cotton are used to make one pair of shoes. How much toughened rubber and cotton are required in total to create 12 pairs of shoes?

A) | 24 parts cotton, 36 parts toughened rubber |

B) | Toughened rubber in 30 parts and cotton in 20 parts |

C) | 26 parts cotton, 39 parts toughened rubber |

D) | 12 parts cotton, 18 parts toughened rubber |

E) | 18 parts cotton, 24 parts toughened rubber |

- Over the course of eight months, an advertising-supported magazine makes $120,000. The magazine’s earnings will increase by 20% if it adds two more ad places. Advertising space and revenue have a linear connection. In eight months, the journal is able to make $156,000 from advertising. How many ad spots were made available?

A) | No change |

B) | -1 ad space |

C) | + 1 advertisement |

D) | -2 ad spaces |

E) | +3 ad spaces |

- Two men are attempting to strengthen their cardiovascular systems. One man runs five miles in the early morning. The second man runs a distance that is two times as long as the first, plus one additional mile. How far did the two men run together overall?

A) | 10. Miles |

B) | 15 miles |

C) | 20 miles |

D) | 16 miles |

E) | 14 miles |

- There are 148 footballs in a sports facility. In the first six months of the year, 28 footballs are either lost or irreparably damaged. Then, the facility buys 14 footballs. A total of 36 footballs are lost or irreparably damaged throughout the second half of the year. How many playable footballs does the facility have left at the end of the year?

A) | 94 |

B) | 84 |

C) | 98 |

D) | 88 |

E) | 96 |

- The male has two interests. His primary interest is shooting, and he also enjoys wrestling. He must spend two fewer hours grappling for every hour more he spends shooting due to travel times and other issues. The man first spends 12 hours of wrestling and 20 hours of shooting per month. He chooses to spend an additional four hours filming the next month. How many hours does he wrestle in that month?

A) | 4 Hours |

B) | 8 hours |

C) | 6 hours |

D) | 10 hours |

E) | 12 hours |

- A worker puts in six hours a day and receives $10.50 an hour. How much money does she make in a week if she works five days a week?

A) | $ 325 |

B) | $ 315 |

C) | $ 305 |

D) | $ 300 |

E) | $ 330 |

- Three pals choose out a hotel room to reserve. They create damage while they are here and are given a bill when they check out. The $682 total amount due. The first friend pays $242 toward the tab. How much does each friend pay if the two other friends split the remaining cost equally?

A) | $ 280 |

B) | $ 240 |

C) | $ 220 |

D) | $ 231 |

E) | $ 210 |

- A company encounters a challenging period. At first, it offered its salespeople a wage of $20 per hour. Due to the challenging circumstances, this wage has been decreased by 25%. When business picks up, the proprietors raise each employee’s pay by 50% of what they were originally paid. How much does a salesperson currently make per hour?

A) | $25 |

B) | $20 |

C) | $30 |

D) | $35 |

E) | $15 |

- A company has a maximum possible workforce of 24 employees. The company pays each employee $15 per hour. The company is currently working with only half of its full personnel. What is the total amount paid by the company if the present staff works for 6 hours?

A) | $ 1220 |

B) | $ 1120 |

C) | $ 1200 |

D) | $ 1000 |

E) | $ 1080 |

- A woman chooses to travel a distance by car. She travels at a 60 mph average. She has traveled a total of 12000 miles. What is the total distance she has traveled after three days, assuming she drives for 10 hours per day at an average speed?

A) | 1400 miles |

B) | 1200 miles |

C) | 600 miles |

D) | 2400 miles |

E) | 1800 miles |

- A business that offers outdoor training buys two parcels of property. 180 feet long is the first piece of land. The second piece of property is half as long as the first. How much land are on each plot together?

A) | 360 feet |

B) | 370 feet |

C) | 360 feet |

D) | 290 feet |

E) | 270 feet |

- A man creates a brand-new bank account. On the last day of each month, interest is paid on the account’s balance. In the first half of the month, he deposits $140, and in the second, $540. 10% is the interest rate. On the first day of the second month that the account has been open, what is his balance?

A) | $748 |

B) | $680 |

C) | $740 |

D) | $728 |

E) | $734 |

- A man spends $780 on one work of art and $2800 on another. The price of the art carries a 10% tax. What does the man pay in total?

A) | $ 3838 |

B) | $ 3938 |

C) | $ 3983 |

D) | $ 3883 |

E) | $ 3838 |

- Two types of tables are sold by a tiny local table manufacturer. The price difference between two types of tables is $40 and $56. The table manufacturer sells 120 of the first type of table and 600 of the second type over the course of three months. What is the appropriate ratio between the first table’s sales and the second table’s sales?

A) | 1:3 |

B) | 1:4 |

C) | 1:5 |

D) | 1:6 |

E) | 4:1 |

- Eight toys are made in a day by a factory. How many toys does the factory manufacture in four weeks, assuming it produces the same number each day and is open seven days a week?

A) | 212 |

B) | 224 |

C) | 228 |

D) | 204 |

E) | 226 |

- A man wants to put on more weight before a sporting event. The man is 220 pounds in the outset. The man increases his body weight by 5% during the first week of trying, and then he increases it by an extra 5% during the second week to reach his goal weight. What is the man’s new weight after this two-week period?

A) | 240 lb |

B) | 242 lb |

C) | 244 lb |

D) | 238 lb |

E) | 236 lb |

- A company uses vehicle A and vehicle B, two different types of transport vehicles. Vehicle A can accommodate 24 passengers, while Vehicle B can accommodate 18 passengers. The company uses three vehicle As and two vehicle Bs for a specific journey. All of the vehicles are completely occupied. How many passengers are traveling?

A) | 104 |

B) | 106 |

C) | 114 |

D) | 108 |

E) | 116 |