SLAP Tears

slap tear anatomy shoulder

What’s up ? This is THE stephane ANDRE. With my training, I’m interested in biomechanics to avoid injuries. I read « Sport Medicine Media Guide » and I learned some good stuff.

SLAP is an acronym for superior labrum anterior to posterior. The labrum is a rim of tissue that adds depth to the bony socket of the shoulder. The superior or « top » portion or the labrum is important and frequently injured because the biceps attaches to this region.

How

SLAP tears happens because of physical activity with repetitive overhead movements or physical shock. Tears created because of overhead movements are common among athletes as basball pitchers or tennis players. Tears created due to physical shocks are often a fall on a hand stretched with the arm over the head or fall directly on the shoulder.

Diagnosis

slap tear anatomy shoulder

SLAP tears are very difficult to diagnose only with a physical exam because of different shoulder problems. Using a MRI with or without contrast helps a lot.

Treatment

The first step is to do a nonsurgical treatment. While the SLAP tear likely will not heal, a study confirmed that many have improvement of symptoms and function. If nonsurgical treatment (such as physical therapy) isn’t successful, surgery is being considered.

Surgery is usually done arthroscopically and involves reattaching the torn labrum to the top of the cavity. Generally, bone anchors loaded with sutures are inserted into the top of the cavity. The sutures are passed through the torn area of the labrum. The sutures are tied, which brings the torn labrum to the bone.

Prevention

Although it’s difficult to avoir acute SLAP tears, it’s possible to prevent chronic tears, especially with athletes who make overhead movements, maintaining balance in the shoulder.

Exercices that strengthen the muscles around the shoulder blades and exercises that stretch posterior shoulders are recommended to reduce the risk of SLAP chronic tears.

Subscribe to my newsletter and share this article if you think it can help someone you know. Thank you.

-Steph

P.S. If you’re in Miami and you like Caribbean food, go to my cousin’s bistro to eat Haitian food, click here .

Stretching Of Glutes

stretching glutes

I read a Frederic Delavier’s book « Strength Training Anatomy » and I learned good stuff.

Sitting on the floor with one leg stretched out and the other leg bent with your foot on the floor and moving from the outer side of your leg stretched. Press on the outer side of your knee bent with your opposite elbow. This exercise mainly stretches the muscles of the gluteus maximus and the lateral rotator group (piriformis, gemellus superior, obturator internus, gemellus inferior, quadratus femoris and obturator externus).

Variant

It’s possible to press on your knee with your 2 hands.

lateral rotator group muscles hip

stretching glutes variant

Share this article if you think it can help someone you know. Thank you.

-Steph

Connect Tableau to An Excel File

tableau connect excel file geographic map

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

Now that you downloaded the dataset in Excel file format, we’ll use Tableau to analyze this.

We’ll connect to the dataset using the « Excel » option.

Now that you downloaded the dataset which is in Excel format, we will use Tableau to analyze this.

We will connect the the dataset using the « Excel » option.

tableau connect excel file geographic map

Select the dataset in Excel file you downloaded and click on the « Open » button.

tableau connect excel file geographic map

And as you can see, there is only one tab.

tableau connect excel file geographic map

There is only one tab because in the Excel file there is only one tab. If in the Excel file there were several tabs, they would all have been listed here.

tableau connect excel file geographic map

It’s necessary to check that all data is « OK ». Scroll the lines and columns to see that. Everything is good, there are 10 000 lines as in the Excel file.

tableau connect excel file geographic map

Excellent, we connected our Excel source file to Tableau.

Now, click on the « Sheet1 » tab to access the Worksheet.

tableau connect excel file geographic map

tableau connect excel file geographic map

We’ll have a little fun.

For example, let’s look at what we have with « Geography »

tableau connect excel file geographic map

« Geography » is the dimension that gives us the country, so we’ll make a map to see where the clients from the bank come from.

Move « Geography » on this area.

tableau connect excel file geographic map

tableau connect excel file geographic map

Ah, it’s odd, nothing happens ?!? Why ? Look, when you look at « Geography », it’s not recognized by Tableau as a geographic dimension. Here,, you can see that Tableau recognized « Geography » as a dimension of type text with the label « ABC »

tableau connect excel file geographic map

Don’t worry, we can fix it quickly. Click on the arrow of « Geography ».

tableau connect excel file geographic map

Selects « Geography Roles » and « Country Region » so that the « Geography » dimension become geography’s type.

tableau connect excel file geographic map

Now you remove « Geography » made a table with a click-and-drag.

tableau connect excel file geographic map

tableau connect excel file geographic map

Look, we have a globe next to « Geography ». This means that Tableau recognize that « Geography » is a geographic dimension.

tableau connect excel file geographic map

Since « Geography » is a dimension of geography type, there are 2 new measures that have appeared : Latitude (generated) and Longitude (generated).

tableau connect excel file geographic map

Put « Geography » in this space with a click and drag.

tableau connect excel file geographic map

Look, this time there is a map.

tableau connect excel file geographic map

You have the possibility of zooming with these buttons.

tableau connect excel file geographic map

The map is fine but we’ll remove the blue dots and modify the map so that it’s easier to read.

We’ll color the countries and display the clients number that has in each country.

We know that in the dataset each line corresponds to a client. What we can do is use the « number Of Record », it means the total of number of observations. In this way, we can visualize the number of lines attended to each country and the number of lines attended to each country is the number of client per country.

Then, take the « number Of Record » and move it to « Colors ».

tableau connect excel file geographic map

Boom ! Each country has a color.

tableau connect excel file geographic map

Look at the color contrasts. France has a darker color which indicates that it is the country with the most clients. Germany and Spain have almost the same colors which indicates that they have almost the same clients number.

But we want to know the clients number per country without have the cursor on the country.

To do this we’ll add a label. Take « number Of Record » and moves it to « Label ».

tableau connect excel file geographic map

tableau connect excel file geographic map

We’ll increase the text’s size and put in bold. Click on « Label », click on « Font » and select « 12 » and bold.

tableau connect excel file geographic map

It’s cool, we can see the clients number per country. You have the possibility to zoom on a region. Click on « Zoom area » and drag and drag to select the region on the map.

tableau connect excel file geographic map

tableau connect excel file geographic map

Now we can see that the majority of clients are in France, this represents almost half of the total clients number of the dataset. Germany and Spain have almost the same number of clients.

Share this article if you think it can help someone you know. Thank you.

-Steph

Label And Format

 data science tableau label format

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

Our bar chart has colors by region but imagines that this bar chart is on a wall of an open space or in a report.

With labels, we can make this bar chart more clear, easier to understand.

In this bar chart, there are all necessary information: representative’s names, regions where representatives make sales and total sales for each representative in Swiss francs.

But, there is a problem. For example, if you ask for someone to say how many sales made Bill. This person must find Bill and see on the vertical axis to the left the value. Here we can see, it’s 1750.

But if we take the James case, we see that it’s between 1000 and 1500. James is far from the vertical axis and it’s difficult to say the true value.

That’s means, all people need to make effort to extract the bar chart’s information.

This it should not be the case because a Data Scientist searches always the best ways to communicate the information. This process is to help people to understand and extract the information in the easiest way.

Start with labels.

« Labels » button allows you to add text information in your bar chart.

data science tableau label format

You will add a label with the SUM(TotalSales) information

To do this, you click on SUM(TotalSales) and press and maintain the key Ctrl or Command on your keyboard and drag and drop SUM(TotalSales) on « Label ».

data science tableau label format

Now you can see the total sales value at the top of each bar.

data science tableau label format

The bar chart is easier to read because there is the total value of sales for each representative.

it’s time to add more information using the labels.

Use the « Rep » information. Click on « Rep », press and hold « Ctrl » key or Command key on your keyboard and drag and drop « Rep » to « Label ».

data science tableau label format

Now you can read the representatives names at the top of the bars.

data science tableau label format

You can also add the region. I’ll show you another way to add « Region » in « Labels ». Click « Region » in « Dimensions » and drag and drop « Region » on « Labels ».

data science tableau label format data science tableau label format

 

But it’s redundant because you can read the representatives names below and the regions at the top of the bar chart.

And each region has its own color. As it’s redundant, we remove « Rep » and « Region » from « Labels » by dragging and dropping out.

data science tableau label format data science tableau label format

 

It’s better, it remains only SUM(TotalSales).

data science tableau label format

Let’s go to the next level, we will publish our labels.

To do this, do a right-click on « Labels » and click on « … » button.

data science tableau label format

It allows you to have your own text. For example write « Sales : » and click on « OK » button.

data science tableau label format

Now you can see that your text appears at the top of the bars.

data science tableau label format

Well, click on « Labels » and click on « … » button.

data science tableau label format

Delete the text « Sale : »and click on « OK » button.

data science tableau label format

We will see now how to format your bar chart. This is the last step before your bar chart is in production.

You will change the labels size. Click on « Labels » and click on « Font »

data science tableau label format

Select « 12 » and bold.

data science tableau label format

Oh, you can do the same thing by clicking on « … » button

data science tableau label format

You have the possibility to change the color but we will keep the color black

data science tableau label format

Now you’re going to change the label type. Right-click on SUM(TotalSales) and click on « Format… ».

data science tableau label format

In fact the labels have their own format and you can change that by clicking on « Label » but all the other thing on Tableau give their format options make a right-click on it.

So when you click on « Format », you’ll see 2 tabs : « Axis » and « Pane ».

Select the tab « Pane » because that’s where the labels of our bar chart.

data science tableau label format

By clicking on « Alignement », you can change the text’s direction of the labels.

data science tableau label format

But what you can’t do with the « Labels » button is to change the digital type.

data science tableau label format

Return on the tab « Pane », we’ll change the numbers in currencies. Click « Numbers » and select « Currency(custom) ». You can also change the currency type in the « Prefix/suffix ».

data science tableau label format

To simplify, you delete 2 decimals in « Decimal Places ».

data science tableau label format

As you can see on my bar chart, the SUM(TotalSales) is vertical at the top of each bar. To change the direction of the label text, click « Alignement » in the « Pane » tab.

data science tableau label format

But there is a problem. Some bars don’t have SUM(TotalSales). To fix this, right-click on each bar and select « Mark Label » and « Alwlays Show ».

data science tableau label format

Now, the bar chart is more understandable.

Let’s put the units in thousands. Click on « Numbers » => « Currency(custom) » => « Units » => « Thousands (K) ».

data science tableau label format

Add a decimal in « Decimal Places ».

data science tableau label format

That’s better, we can see Swiss francs sales for each sales representative.

Look, there’s something you need to know You can’t change the size of the text in the tab « Pane ».

If you click on « Font » and change the size, it will not change anything on your bar chart.

data science tableau label format

This is because the font size in the « Label » button dominates the font that is in the tab « Pane ».

data science tableau label format

Ok, we changed the labels format. Now, let’s change the axes format.

To do this, right-click on the vertical axis and select « Format ».

data science tableau label format

Click on the « Axis » tab and change the text size with « Font » to 12.

data science tableau label format

Then, right-click on the horizontal axis. Selects « Format ».

data science tableau label format

And in the « Header » tab, you change the text size with « Font » to 12.

data science tableau label format

Oooh, do you see ? Mathiew is cut off. To arrange this, enlarge the bar chart by clicking and dragging on the right.

data science tableau label format

Right-click on « Central » in the top axis and select « Format ».

data science tableau label format

And changes the text’s size with « Font » to 12 and bold.

data science tableau label format

Now, look at the top of the bar chart. The « Region/Rep » line is useless because we know that Central, East and West are the regions and the representatives names are at the bottom of the bar chart.

data science tableau label format

To change it, right-click on « Region/Rep » and select « Hide Field Label for Columns ».

data science tableau label format

if you want to improve the title « TotalSales » by adding a space, right-click on the vertical axis and select « Edit axis ».

data science tableau label format

In the « General » tab, add a space in the title and click « OK ».

data science tableau label format

Let’s do one more thing. We’re going to put all the « Total Sales » in Swiss francs. Make a right-click on the vertical axis and select « Format ».

data science tableau label format

Click on tab « Axis » => « Numbers » => « Currency(custom) ».

In « Decimal Places », you put « 0 ». In « Units », you put « Thousand(K) ». In « Prefix/Suffix », you put « CHF ».

data science tableau label format

Well, you did a good job. Now you know how to change the format of the charts in Tableau.

Share this article if you think it can help someone you know. Thank you.

-Steph

Create A Calculated Field

data science tableau calculated field

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

Now is the time to solve the problem of who is winning the bonus.

The first thing to do is clean the dashboard. To do this, click on the « Clear Sheet » button.

data science tableau calculated field

To start we need to create a « Bar Chart » to see the salesperson. In this data, salesperson named « Rep » for representatives.

data science tableau calculated field

To see how many items were sold by each sales representative, you need to put « Rep » in « Columns » and « Units » in « Rows ».

data science tableau calculated field

You can see that the representative who sold the most is Richard.

But we want to have more details. We need to know who is the best representative by region and for now, we can’t see that.

To see this, you put « Region » in « Columns » before « Rep ».

data science tableau calculated field

As you can see, the « Bar Chart » changed. There are separations by region.

In each region, you can see the representatives and the number of items they sold. Alex is the best in Central. Richard is the best in the East and James is the best in West.

To get better visibility, you can order the bars in descending order. Move the mouse over the label « Units » of the bar chart and an icon will apprear. Click on it and the bars will be sorted in descending order.

data science tableau calculated field

Unfortunately, we didn’t answer the question because « Units » is only the number of items sold. What interests us is the amount of money earned by selling the product but we don’t have this type of measure. There is no measure that shows us the total value of sales. There are only « Units » and « Units Price ».

In this case, you have to make a calculation to have the total sales in cash. For each representative, you need to multiply « Units » with « Units Price ».

Let’s look at the data to make a test calculation. Right-click on the « OfficeSupplies » data and click on « View Data ». For example, you see that Nick sold 29 binders to $1.99. So 29 (Units) multiplied by 1.99 (Unit Price) equals $57.71 for this sale.

data science tableau calculated field data science tableau calculated field

In our data, we have no measure where « Units » is multiplied by « Units Price ».

data science tableau calculated field

To solve this problem, you will create an additional measure with a « Calculated Field ». « Calculated Field » si an element that allows us to create measures by calculating quantities.

To create this, right-click in the « Measure » zone and select « Create calculated field… ».

data science tableau calculated field

You can name the calcultated field « TotalSales »

data science tableau calculated field

Select « Units » uses the « * » sign to multiply and select « Unit Price » and click « OK ».

data science tableau calculated field data science tableau calculated field

Now, you can see that your measure « TotalSales » in the « Measure » zone.

data science tableau calculated field

By looking good, you can see that there is an « = » sign before the « # ». This is to indicate that this measure is a calculated field.

Ok, the measure is ready, let’s go. Put « TotalSales » on « Units » to replace « Units » with « TotalSales. Tableau automatically takes the sum aggregate.

data science tableau calculated field

If you want to do this more cleanly, you can remove « Units » by dragging it outside « Rows », then take « TotalSales » and put it in « Rows ».

data science tableau calculated field data science tableau calculated field

Now, that we have a « Bar Chart » with data from « TotalSales », we sort the bars in descending order by clicking here.

data science tableau calculated field data science tableau calculated field

As you can see, the results are different because Richard is no longer the best representatives in the East, it’s Suzanne. The best representative in the East is Suzanne, the best representative at the Center is Mathiew and the best representative in the West is still James.

it’s with the calculated field « TotalSales » that we can know who are the best representatives by region so Suzanne, Mathiew and James earn a bonus.

This was an example to learn how to create a calculated field in Tableau. Have fun creating new calculated field to master this tool that is really useful.

Share this article if you think it can help someone you know. Thank you.

-Steph

Navigate In Tableau

front boat

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

We’ll explore Tableau’s tools

From the connection manager, we’ll go into the Tableau’s workspace.

Click on the « Sheet1 » tab at the bottom of the window.

data science tableau screenshot

Here is the Tableau’s workspace.

data science tableau screenshot

The 2 important elements of the workspace are « Data » on the left and the workspace on the right. It’s in the workspace that you’ll create tables and charts.

We’ll start with « Data » on the left.

data science tableau screenshot

« Data » divided into 2 zones : dimensions and measures.

The dimensions and measures are 2 different rules that will allow you to manipulate data.

Tableau sets the numerical values in « measures » and the categorical or quantitative variables in « dimension ». This is the Tableau’s settings by default.

There is also another way to explain « dimension » and « measures ». The « dimensions » are independent variables and the « measures » are dependent variables.

For exemple, « Units » is a measure, it’s the number of items sold per product. « Region » is a dimension, it’s the geographic region where the product sold. With 2 elements we can know how many items sold by region. This means that « Region » is an independent variable and « Units » is a dependent variable because it will be grouped by region.

But if you don’t like it, you can move the entities between dimension and measures and the opposite by click and drag.

In the menu bar, at the top, there is « File » where you can open and save file.

data science tableau screenshot

« Data » to connect to new source files.

data science tableau screenshot

« Worksheet » is the workspace to create analyzes

data science tableau screenshot

« Dashboard » is a combination of worksheet

data science tableau screenshot

« Story » is a combination of worksheet and dashboard

data science tableau screenshot

« Analysis » to specify how you want to do your analysis on your workspace

data science tableau screenshot

« Map » to add maps to the workspace

data science tableau screenshot

« Format » contains formatting options

data science tableau screenshot

Now, let’s study the workspace.

In the workspace, the main elements are « Columns » and « Rows ». This is where you decide which data goes in columns and rows in your worksheet.

You can also choose different format for these elements like colors, size, text level of detail and tooltips (useful tool optional).

data science tableau screenshot

Let’s do a test. Use data from « Region » (which is in « dimension »). Move « Region » with a click and drop to the center of your workspace. Now, « Region » is in the element « Rows ».

A table appears in your workspace.

data science tableau screenshot

You put a dimension in your workspace. Now put a measure in your workspace.

Uses the « Units » data. Move « Units » with a click and drop next to the « Region » column.

data science tableau screenshot

As you can see, Tableau automatically put « Region » in the « Rows » element and the « Units » data aggregated by region. In this way, you can tell how many items were sold by region.

Now, what you can do is to move « SUM(Units) » to the « Columns » element.

data science tableau screenshot data science tableau screenshot

And then, you have a « bar chart » to see how many items have been sold by region. You can enlarge the graphic with a click and drop.

Let’s look at the tools that are in « Show Me » zone.

data science tableau screenshot

Click on « Pie chart » to have this chart’s type.

data science tableau screenshot

Click on « Size » icon and drag from left to right you can increase the chart’s size.

data science tableau screenshot

In this chart, each region has a color and proportion of items sold by region.

You can also test the « bubble chart ». Tableau organizes the data automatically and everything and placed in the « Marks ».

data science tableau screenshot

You can test « Treemaps » chart. This is the same principle as « bubble chart » but it’s rectangles instead of circles.

data science tableau screenshot

As you can see in « Show Me », there are charts disabled. This is because you need some elelments in your data to be able to activate them.

For example for the « Area chart », you need « date »data to activate it.

Share this article if you think it can help someone you know. Thank you.

-Steph

Connect Tableau Public To A CSV File

tableau connect file csv data science

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

After downloading the file « OfficeSupplies.csv », you will open this file with Tableau. When you open Tableau, there is a « Connect » column :

tableau connect file csv data science

Click on « Text File » and open the file « OfficeSupplies.csv » :

tableau connect file csv data science

The connection manager appears for this source file :

tableau connect file csv data science

At the top left, there is « Connect » where the file is located and below it, there is « File » with 1 file. There is 1 file because you imported 1 file. I’ll show you later how to import several files of the same type.

tableau connect file csv data science

In the center, there is a window with the files you connected. And it’s possible to connect several files.

tableau connect file csv data science

For exemple, if you do a drag and drop here, Tableau will try to connect these 2 files.

tableau connect file csv data science

You can work with data comes from several differents files, different tables from different CSV files. We’ll see that later.

At the bottom, there is a preview of the file with columns and rows. Colums « Order Date », « Region », « Rep » and « Items » identified as data in text format. Columns « Units » et « Unit Price » identified as data in number format.

tableau connect file csv data science

Now you’re gonna go on the dashboard. To access it, click here.

tableau connect file csv data science

Here is the dashboard. 

tableau connect file csv data science

We will discuss the various function in more detail in the next section.

Now, I just want to show you that we have « Data » column with our source file.

tableau connect file csv data science

If you do a right-click and click on « View Data », you see the data as in the previous window.

tableau connect file csv data science

tableau connect file csv data science

You’ve seen, it’s simple to connect a source file to Tableau.

Wait, I’ll show you how you can connect more source files. Click here to return to the connection manager where you can connect several different files.

tableau connect file csv data science

Of if you want to stay on the dashboard, you can click on the top left on « Data » then « New Data Source ».

tableau connect file csv data science

Or click on this icon on the dashboard. Here are the files types you can connect to Tableau

tableau connect file csv data science

What is interesting with the « Statistical File » is that we can connect files type SAS, SPSS and R.

tableau connect file csv data science

We have access to different server with OData and others.

tableau connect file csv data science

It’s perfect, now you can connect a data source to Tableau and you’ll see later how to connect data faster.

Share this article if you think it can help someone you know. Thank you.

-Steph