data visualization case studies This is a topic that many people are looking for. thetruthaboutdow.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, thetruthaboutdow.org would like to introduce to you Data Analytics Case Study 1 Analyze Sport Data Data Visualization Practical Question . Following along are instructions in the video below:
“There welcome to this video and in this video. I will give you one analytics analytics case study which you will find it for any beginner or any person who at intermediate level. A good case study where you will look at how you can import the data on how you can massage. The data based on the requirements and finally giving the answers with the help of visualisation matrix or text.
So this this case study is basically independent of the tool that you want to use you can use microsoft excel. You can use click view you can use tableau. You can use python are any tool of your interest. And that s why i tried to make it tool independent.
So that any of you who has a special interest. Let s say you are learning power bi from my blog or you have learned tableau from my blog or click view from my blog you can just go ahead and apply this in the tool of your interest. Or you are like completely new you have not seen my blog. But want to do analytics.
Case study then you can basically use it whatever tool that you are using for for this case study. So before i tell you about the case study. Let s review. The data that i m going to provide you for this case study and this data you can the link for this data can be found from the description of the from the description of the of this video alright.
So let s go ahead and see the data. So here is the data that i want to give you in this for the solution of this case study and if you see this is a sports related data and this sports is a very famous sport and if you have just looked at the data. It s basically a cricket sports data. So this data is basically having the information about the matches that have been played various between various regions like for example new zealand tostan uae ireland and australia england and ireland sri sri lanka and zimbabwe scotland a lot of different countries.
If you see they have played the matches in the year 2018. So this entire data is of 2018 starting from the 6th january and going up to the 14th december. So that that completes one year of the cricket. And it has the information about what is a team won that means the first team.
What is a team to the second team against which they have played the match. And then finally who was the winner right so when you say that between the new zealand and pakistan. If new zealand is the winner. Then obviously pakistan is the loser in this case.
Or in this cricket. Match and sort of questions. Which may come is who ve lost most of the matches so you need to keep in mind. That you only have got the winner information and from this you can even drive the lost matches.
Information and then you have the margin margin based on which the the match was won so in this case. 61 runs right so match was won by 61 run so what does that mean so..
If you don t know cricket at all there are two scenarios in which you can win the match either by the number of wickets. So here in case. Eight wickets by 8 wickets. You won new zealand won the match and 61 runs that means by 61 runs new zealand won the match.
So what is the difference. The difference is who played first in this case in case of 61 runs win by 61 runs new zealand actually played first they let s say made 261 run in the in their innings of let s say 50 overs match and then pakistan when they played it they made only 200. So this way new zealand won by 61 run all right when it comes to 8 wickets new zealand actually played second inning or it played it after pakistan played so for example. Let s say suppose pakistan.
Made 200 run in their inning. And then when new zealand came into the play they only lost 2 wickets. And made 201 run. And that s why they won by 8 wicket.
So total. It s basically there are 11 players. And sorry. In this case.
They lost 3 wickets. And that s why they have still got a trick. It s in hand. Which taken place so that s basically a basic difference between when it comes to winning by a wicket or when it comes to winning by a run and then you have over here the ground information on which ground this match was played for example wellington.
This is in new zealand nelson. This is in new zealand. This is dubai. Done lin because it looks like it s in new zealand.
And then melbourne. Which is basically a sydney sorry. Which is basically in australia. Then taka.
Which is bangladesh and then so on and so forth the information about the different venues on which the match was played and then you have the match date. Which is let s say if you got any time series information like for example in each month. How many number of matches were played then you can basically look at the match date column and basically transform this into a sort of a time series. Which let s say by date by week by month by quarter.
All of that information you can display since you have the most raw level date. Which is an actual date on which the match was played all right and this at the end is the basically the information that cody..
I is one day international match. And it s basically the match number is three nine four six the match number is three nine force so it s basically an incremental number indicating. What is the match number right from the beginning. When the first match was played so this this match was 3940.
Sixth odi and match played between new zealand and pakistan in the ground wellington on on beat sixth chen. 2018. So that s at a high level. A description about the data set for those who don t know much about the cricket.
But still wants to pick up this case study as well as for those who knows the cricket. But before the case is study. It s always always always a good you know habit to go through in depth about the data that you are dealing with so. This is a pretty small data set that s why i said it s good for beginners and people who are at intermediate level.
But now let s go ahead and look at the 15 questions that i have made it for you all right so here. We are analytics case study. The first question is data transformation related so transform the margin column in two columns. That means one for run and another one for wicket.
So what do you need to do is you need to basically come to this column and convert this column into two columns. So one column basically find add it over here. One column is basically saying of win by runs well. Let s say what i actually said one four runs and another four wicket win by run then by wickets so what you need to do is wherever the run was present in this case six run it s a win by sixty one run.
It will come over here as 61. And it s basically in this case zero or null. You can leave it and here in kin. This case.
It will be a trickett so this will be eight this will be four. So you need to basically do an automated script. Which will do this whenever. The new data is coming to you so that s the number one thing that you need to do after that you need to figure out the answer of this question.
Which country played the most odi in 2018. I m sorry i wrote 2009 t. Buts that s not true the data that we have is basically 2018. It s probably because we are in 2019 so while training.
The question. I may have wrote that the third question is top three countries who ve worn the most odious top 3 countries who won the most odi is in 2018..
That means. The data that you are dealing with now based on the ground map the country and hint is take the list from google. That based on the cricket playing country is what ground they have the ground information is already present and then you can map the country information. So those sort of situations come.
It s basically a data transformation. Question. Then you have which country plays played the most matches in home ground for example. You have lot of different these countries so new zealand has played in the valent n.
Which is new zealand nelson. Which is new zealand. So you need to identify a country which played the most matches in their home crown. After that how was the performance of sri lanka.
Now this is a very open ended question and this can be answered in various different ways for example. What was their winning percentage. What was their losing percentage. How many matches they played compared to the others how many matches were played in house.
How many many matches played outside of the country and in outside. What was the winning performance when they were in the home country. What was the winning percentage. So on and so forth as well as season.
Whether they played a good cricket in the first season of the cricket or the second season of the cricket or the third season of the cricket so those sort of questions you try to explore based on the sub question. Which i just sad and figure out the answers. Which is it s basically a good candidate of even creating a so think about it where you can create the standard matrix of winning percentage losing percentage winning percentage at home losing percentage home brand of how many matches were played every month. So on and so forth and basically have the filter.
So not only srilanka you can see every other country. So it s a good candidate. It s a very big question. The question number six which will even keep you busy for days.
Now. The seventh question is what are the top three wins by runs that means. The country who basically you know played second right. And then month in which most od eyes were played very straightforward question you need to just engage the timeline.
Then team. Which to most foreign country again that means team which played on most foreign surface or visited to other countries..
How many cricket matches were played every month. It s a trending information like i said this can come on which ground most games were played right so you need to identify that ground did india win mostly by chasing or playing first now you have two columns and you need to juggle through those two columns figure it out what has gone really in favor of india in that case. Which gives a sort of a trend. Which basically result into sort of a data signs where you can see whether it s good for india.
Whenever they chase or they play first then top three country who won most matches in 2008. And what was their winning percentage every month. So it s basically two different visualization that you need to create in this case. Team.
Which had most lost matches or which had lost most of the matches that means team whose performance was really down and then you we can basically that can be a question of a story. If you have seen my videos related to the tableau where i talked about the story. This basically can be a story point that ok. This is the team which has lost most of the matches.
What was the reason of it and then you start building. The story points like first of all their key players were out or not or they played most of the matches on foreign surface or most of the time. The team is known for playing first and winning the matches. But they lost the let s say toss and they were playing second so those sort of things you can you can really brainstorm around and create a story around it and finally 15th did this team loses the match matches.
By chasing or playing first so it s related to question number 14 that it lost most of the matches then it lost the matches. By chasing or playing first so these are the 15 questions i want to give you which i believe will keep you busy for at least at least five to six hours. If you are a beginner or intermediate level based on the transformation based on the different things. Which i have asked you to do in this case.
Study. And if you are able to do it i would be really really glad to see your result. If you are building it in click view or click sense or specially in click sense you have click cloud where you can upload it and show it to me as well as show it to others as well as put it on resuming right. If you are making something really great and then second is if you are using tableau then upload it on the tableau public.
Even power bi gives you the capability to upload it on their cloud or if you are made using python or if you are using r or if you re using any other tool. I will be really glad to see your output and something if you can make much more interesting visualization out of it based on this data based on the performance based on the matches that were played then this would be really interesting to see and i would and i can promise that if i really like your stuff. I will showcase this on my channel by showing it to the others. Which we which you have produced something that from that it one can inspire and create visualization like yours so i hope you will enjoy this cases study and if you have any question megha make your answer.
Ask your question in the comments. That s what i wanted to say so so yeah. That s pretty much it and i ll meet you with a ” ..
Thank you for watching all the articles on the topic Data Analytics Case Study 1 Analyze Sport Data Data Visualization Practical Question . All shares of thetruthaboutdow.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“Hi there in this data analytics case study, I have given you data analysis and data manipulation related questions so that you can do these exercises in the tool of your choice which can be tableau, qlik view, qlik sense, python, r, power bi or any other business intelligence tool.nnCan you take this data analytics challenge and answer all the questions correctly?nnI ll be glad to see your output and the best output, I ll show it to my users with your name. So try this hands on data analytics exercise or case study and make you data analytics and data visualization skills strong.nnLike what I am doing? Buy me a Coffee to re-energize – https://tinyurl.com/txe98jfnnDataset – https://tinyurl.com/tr8ocf3nSolution file – https://tinyurl.com/sjbqwph”,
data visualization case study, data analytics practical questions, data anlaytics case study, analyze sports data, data analytics exercise, data visualizatio…