FIFA 2022: Visualizing the Group Stage Data by mengene

View this thread on: hive.blog | peakd.com | ecency.com

hive-101690 · @mengene · Dec 8 '22 (edited)

$6.54

FIFA 2022: Visualizing the Group Stage Data

Hi hivers
![](https://images.ecency.com/DQmWdWr8VsNM5ihsQgNDr79iD2g8n4bTGD98AR9HRsdpnPV/screenshot_14_.png)
[->>>CLICK HERE TO ACCESS THE DASHBOARD](https://researchassistant.online/products)

After a much-needed hiatus, I'm back to blogging, and what better way to get started than with the big event everyone is talking about? You're right, of course! The FIFA World Cup 2022 hosted in Qatar. With the first kick of the quarterfinals scheduled to take place in less than 24 hours, the tournament has reached a stage where the stakes are high and it's win it all or nothing!

![](https://images.ecency.com/DQmUazvcLnRLNPjKu7MdTutc6USRZHq91QEYpzTfdNb7oCA/screenshot_15_.png)

I have been working to improve my data analytics abilities over the course of a few months, one of which is data visualization using Microsoft Power BI. After the group stages were finished, all I wanted to do was analyze and visualize the data using Power BI. Let me quickly recap how I came to create this completely interactive dashboard.

![Screenshot 16.png](https://images.hive.blog/DQmTsxJByegk6WYzGMfDwjKcpu15AiLH5LF7qF1p9LZv63D/Screenshot%20(16).png)

[->>>CLICK HERE TO ACCESS THE DASHBOARD](https://researchassistant.online/products)

Starting off:
-Data Scraping: I had to web scrape the fifa 2022 website's data. I entered it via copy and paste into an Excel spreadsheet.

-Data Cleaning: I started by preparing the data for the matches, groups, and flags etc. I got rid of duplicates, blanks and null entries.

-Create the Tabs: The Fixtures tab allows you to view information about the dates, locations, and participants in various matches. While the Standings include information on the teams, including their number of wins, losses, draws, goals scored, and goals conceded. Here, you can compare these statistics to the total while still getting a sense of how each team contributed to each statistic individually.

Please disregard the blank in the group and flags area; I have attempted every means I am aware of to fix it, but it appears adamant, so I have left it alone because it does nothing to the project.

If Messi or Ronaldo wins the world cup, I'll go ahead and provide a more in-depth analysis on the tournament that will feature player statistics and teams, as well as the ongoing knockout games. And we get to fully explore the data to bring out incredible pieces of information about the competition.

I thus hope you have as much fun playing with the data as I did. Share your thoughts and comments in the section below! What are your predictions for the quarter-final fixtures? GO ahead and share and be on the look out for more blogs coming your way!

[->>>CLICK HERE TO ACCESS THE DASHBOARD](https://researchassistant.online/products)

Cheers!

Posted using [SportsTalkSocial](https://www.sportstalksocial.com/@mengene/fifa-2022-visualizing-the-group-stage-data)

👍 xeldal, enki, lemouth, wrestorgonline, adol, sunshine, wolfgangsport, carilinger, sportstalksocial, sports-gov, communitybank, beta500, atheistrepublic, achimmertens, traderhive, citizendog, sbi5, robvector, tokensink, simba, genepoolcardlord, fantasycrypto, trisolaran, mammasitta, genepoolrentsclr, roguewriter, korver, marivic10, sam99, jigstrike, superuser3, steemegg, readthisplease, solox, bartosz546, swirly, jackramsey, onwugbenuvictor, filosof103, quduus1, battebilly, tomlee, iumac03, dashfit, rent-an-ape, tomatom, danokoroafor, peterpanpan, benie111, aotearoa, eprolific, belena2128, ilovegames, xanderslee, freddio.sport, starfighter, frankydoodle, hivedeb, joshglen, netvalar, kdee916, randomblock1, yestermorrow, psyo, and 148 others

`author`	mengene
`permlink`	fifa-2022-visualizing-the-group-stage-data
`category`	hive-101690
`json_metadata`	"{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"image":["https://images.ecency.com/DQmWdWr8VsNM5ihsQgNDr79iD2g8n4bTGD98AR9HRsdpnPV/screenshot_14_.png","https://images.ecency.com/DQmUazvcLnRLNPjKu7MdTutc6USRZHq91QEYpzTfdNb7oCA/screenshot_15_.png","https://images.hive.blog/DQmTsxJByegk6WYzGMfDwjKcpu15AiLH5LF7qF1p9LZv63D/Screenshot%20(16).png"],"links":["https://researchassistant.online/products"],"description":"Explore the data from the group stage of the FIFA 2022 world cup in Microsoft Power BI. The dashboard is interactive and is a little analytics project from me.","format":"markdown","canonical_url":"https://www.sportstalksocial.com/@mengene/fifa-2022-visualizing-the-group-stage-data","app":"sportstalksocial/1.2.0"}"
`created`	2022-12-08 20:53:24
`last_update`	2022-12-08 21:01:18
`depth`	0
`children`	9
`last_payout`	2022-12-15 20:53:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	3.288 HBD
`curator_payout_value`	3.251 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2,877
`author_reputation`	20,689,097,167,261
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,959,823
`net_rshares`	14,417,057,644,292
`author_curate_reward`	""

properties (23)vote details (212)

voter	rshares	pct
xeldal	7,852,069,506,530	14%
adol	220,240,526,368	14%
enki	2,760,724,794,149	14%
simba	36,148,317,718	35%
justtryme90	642,849,998	35%
mammasitta	18,821,803,078	7%
marsresident	700,037,028	35%
nascimentoab	2,345,702,056	35%
joshglen	4,398,271,969	35%
sunshine	188,904,478,709	35%
randomblock1	4,190,112,562	70%
sc-steemit	1,335,756,001	35%
lemouth	1,296,722,409,656	50%
roguewriter	18,028,393,845	35%
dashfit	6,760,773,738	35%
hoboway	817,980,341	35%
daj	675,692,496	35%
ihsan19	589,013,384	70%
yuslindwi	994,714,785	35%
sixexgames	3,924,609,897	35%
more4less	2,209,530,297	70%
frankydoodle	4,590,942,247	35%
ninyea	1,874,995,180	70%
mrstaf	1,416,462,184	35%
christianolu	970,163,393	90%
slefesteem	770,734,684	35%
kisom1	1,286,506,210	35%
friesennerz	1,688,444,184	35%
sam99	14,113,427,510	21%
makrotheblack	2,878,423,913	35%
blackmagic	2,116,034,695	70%
urchice	1,180,103,337	35%
fatherfaith	906,673,464	35%
colmedwardsphoto	3,068,818,073	70%
pearlumie	1,033,214,577	35%
nascimentocb	497,113,185	35%
hundlola	523,200,603	35%
tezzmax	1,657,389,540	35%
tochprince	1,219,231,196	35%
gnarlyanimations	1,248,132,945	70%
tolarnee	817,710,130	35%
bcrafts	1,525,735,650	14%
gregan	1,625,190,720	70%
silasvogt	508,030,845	35%
bartosz546	12,755,698,945	35%
battebilly	8,326,710,724	35%
airhawk-project	1,496,290,633	70%
odebgaming	865,895,273	70%
kdee916	4,221,237,308	35%
kerry234	508,083,589	70%
marvel1206	784,243,611	35%
mirfaner	505,809,710	70%
tboyloyal	888,571,097	35%
hrhmikelength	886,876,788	35%
berkaytekinsen	1,228,175,425	70%
motivatorjoshua	1,262,151,163	70%
steeminer4up	645,334,538	35%
mhm-philippines	721,132,121	35%
xanderslee	4,892,688,204	70%
enjoyy	730,587,995	35%
funshel	688,387,357	35%
tomatom	6,589,821,037	35%
akumar	1,440,199,968	70%
azmielbanjary	1,912,752,431	35%
thedrewshow	501,316,979	70%
benie111	5,290,696,737	28%
sholly1	3,741,117,177	28%
eprolific	5,085,283,654	70%
irisworld	1,178,320,506	35%
communitybank	84,836,904,311	70%
osarueseosato	421,754,984	70%
jigstrike	13,686,818,821	35%
airhawk-exchange	1,276,443,189	70%
mrxplicit	862,121,566	70%
k-banti	2,896,243,401	35%
cheesom	884,429,029	35%
tobias-g	803,487,867	1.25%
fantasycrypto	28,675,654,109	35%
oredebby	422,658,650	35%
photohunter2	755,257,902	35%
preciousimo	1,050,913,535	70%
aotearoa	5,100,144,078	35%
sodrill	653,177,990	56%
joelagbo	3,540,554,936	35%
atjehsteemit	638,142,893	35%
oilprinzz	808,912,031	28%
sunshinebear	924,575,183	35%
carloniere	600,666,490	70%
laviniatherapist	2,900,733,871	59.5%
bookoons	557,055,362	35%
elizabeth-22	606,193,483	35%
kathryn95	616,869,759	35%
achimmertens	70,063,208,604	35%
jacksondavies	1,733,587,483	35%
calebotamus	4,002,394,546	100%
ashley4u	2,036,920,493	35%
thomaskatan	1,156,685,999	49%
guider	493,385,679	35%
netzisde	529,931,161	35%
rachelleignacio	1,026,141,644	35%
carilinger	102,289,387,409	14%
trisolaran	20,236,974,381	35%
dawizy	1,005,621,161	56%
hardaeborla	3,684,066,025	35%
citizendog	62,068,982,234	70%
ihal0001	828,971,272	35%
sbi5	59,469,723,900	7.65%
mayib	547,201,984	35%
drsensor	1,107,529,319	40%
mayorfaruk	522,724,967	21%
fabrik	2,421,153,179	70%
juanhobos	558,598,950	35%
montanacellist	2,838,887,372	35%
mastersa	1,766,767,205	35%
yestermorrow	4,124,041,025	10.5%
marivic10	16,963,896,068	35%
cynicalcake	934,295,508	35%
riottales	914,277,332	35%
jenniferjulius	1,441,470,976	35%
paololuffy91	516,766,916	28%
angoujkalis	949,652,270	35%
predict-crypto	2,521,171,657	1.4%
edward-abu	494,540,071	70%
topworlds	649,856,950	63%
ennydee	539,037,027	35%
starbooks	1,906,307,700	35%
solox	12,811,662,741	70%
martinstomisin	2,074,033,760	35%
fire451	1,387,462,549	70%
starfighter	4,613,404,517	70%
steemegg	13,129,007,009	35%
jtm.support	2,549,465,242	35%
apokruphos	3,581,151,809	1%
anna.kathaxrina	737,654,370	35%
parth7878	1,542,969,417	35%
kggymlife	3,403,689,442	20%
jackramsey	10,607,805,132	49%
filosof103	9,601,524,999	35%
hungryanu	1,415,188,146	21%
zackarie	852,662,889	35%
swirly	11,240,293,845	35%
digitalmack	953,128,478	35%
psyo	4,111,163,606	35%
kgswallet	502,636,901	10%
sportstalksocial	97,201,196,328	100%
tomlee	7,760,339,081	35%
wolfgangsport	132,316,990,059	100%
hyborian-strain	820,080,406	10.5%
freddio.sport	4,877,129,583	50%
tokensink	38,483,357,598	70%
beta500	76,488,972,873	70%
korver	17,876,054,061	100%
sports.alfa	2,676,396,528	100%
atheistrepublic	71,535,206,382	35%
hjmarseille	2,061,784,935	49%
mengene	660,592,461	100%
spiritking	749,915,722	100%
peterpanpan	5,521,913,487	7%
abkevwe	671,363,341	35%
jsalvage	1,068,310,391	35%
ilovegames	4,924,762,643	14%
tajimkhan	1,383,063,986	35%
eniola1990	511,277,930	35%
sports-gov	84,951,161,914	100%
lancergrows	598,549,669	35%
vonzeppelin	1,248,268,934	35%
shamzy	843,678,276	35%
traderhive	65,444,107,382	70%
nanggroe1	857,693,892	35%
din0baba	801,144,892	35%
robvector	45,711,468,953	35%
eythorphoto	3,331,838,003	35%
counterterrorism	1,820,380,525	35%
chuxter	1,259,631,287	35%
iamchuks	3,025,117,036	52%
readthisplease	13,040,548,487	70%
kalivankush	1,048,698,672	35%
danokoroafor	6,481,247,808	35%
onwugbenuvictor	10,460,429,976	35%
bai123	1,569,218,825	35%
rencongland	2,952,403,438	14%
eustace-kidd	2,244,087,220	35%
suteru	2,413,436,724	35%
highhaschdi	560,229,696	35%
poggersdude	1,195,723,647	35%
mofobunny	512,598,129	35%
senseisar	938,196,039	35%
kayntan	2,330,034,138	35%
iumac03	7,179,794,985	35%
jsynnthagr8	810,924,918	35%
ak08	1,720,614,881	70%
theindiankid	520,750,984	35%
netvalar	4,238,471,791	50%
wrestorgonline	432,611,355,451	5%
perinator	1,569,979,527	35%
conodev	1,259,921,214	100%
hivedeb	4,434,054,733	70%
adaezeinchrist	3,662,696,644	70%
quduus1	8,634,595,740	28%
genepoolcardlord	29,403,619,132	35%
cindynancy	737,850,472	35%
genepoolrentsclr	18,158,423,474	35%
era131	1,220,796,048	35%
belena2128	4,974,889,365	100%
oasiskp2	1,285,319,200	35%
rent-an-ape	6,693,099,402	35%
vankushfamily	603,964,526	35%
anvildrak	1,766,374,688	100%
artefactoestudio	582,862,534	35%
yahuzah	516,846,480	49%
superuser3	13,501,500,157	35%
twicejoy-sports	852,223,790	100%

@iamchuks · Dec 8 '22

All eyes on Argentina vs Netherlands tomorrow night,  can't wait for the quarter finals matches to be played.

👍 mengene

`author`	iamchuks
`permlink`	re-mengene-2022128t23254668z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.35-mobile","format":"markdown+html"}
`created`	2022-12-08 22:03:03
`last_update`	2022-12-08 22:03:03
`depth`	1
`children`	1
`last_payout`	2022-12-15 22:03:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	109
`author_reputation`	115,027,808,529,395
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,961,202
`net_rshares`	688,686,344
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mengene	0 B		688,686,344	100%

@mengene · Dec 9 '22

Only a few minutes away.. With Brazil out, I'm really hoping Argentina wins Netherlands

properties (22)

`author`	mengene
`permlink`	re-iamchuks-2022129t191718837z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.30-vision","format":"markdown+html"}
`created`	2022-12-09 18:17:18
`last_update`	2022-12-09 18:17:18
`depth`	2
`children`	0
`last_payout`	2022-12-16 18:17:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	88
`author_reputation`	20,689,097,167,261
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,981,643
`net_rshares`	0

@korver · Dec 9 '22

This is so good to know! I'd love to check more posts of this. Thanks @mengene.

👍 mengene

`author`	korver
`permlink`	re-mengene-2022129t204423336z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.30-vision","format":"markdown+html"}
`created`	2022-12-09 12:44:24
`last_update`	2022-12-09 12:44:24
`depth`	1
`children`	1
`last_payout`	2022-12-16 12:44:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	79
`author_reputation`	105,815,265,373,812
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,974,669
`net_rshares`	659,714,450
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mengene	0 B		659,714,450	100%

@mengene · Dec 9 '22

Thanks for checking it out.. I hope to get more posts out if possible!

properties (22)

`author`	mengene
`permlink`	re-korver-2022129t192010131z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.30-vision","format":"markdown+html"}
`created`	2022-12-09 18:20:09
`last_update`	2022-12-09 18:20:09
`depth`	2
`children`	0
`last_payout`	2022-12-16 18:20:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	70
`author_reputation`	20,689,097,167,261
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,981,712
`net_rshares`	0

@yahuzah · Dec 9 '22

The quarter finals begins in less than 10 hours and it’s all eyes on Brazil and Argentina. I think Brazil will go through but I’m not quite sure about Argentina.

It’s going to be fun to look at the data you’ve provided.

👍 mengene

`author`	yahuzah
`permlink`	re-mengene-2022129t62944905z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.35-mobile","format":"markdown+html"}
`created`	2022-12-09 06:29:48
`last_update`	2022-12-09 06:29:48
`depth`	1
`children`	4
`last_payout`	2022-12-16 06:29:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	221
`author_reputation`	198,150,861,561,992
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,968,726
`net_rshares`	674,015,212
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mengene	0 B		674,015,212	100%

@mengene · Dec 9 '22

Sorry, but CRO got the better of Brazil in the end.. Guess we keep our fingers crossed as regards ARG! And yeah, i'd be real motivated to explore the data if Messi or Ronaldo gets crowned World Champion

properties (22)

`author`	mengene
`permlink`	re-yahuzah-2022129t19195619z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.30-vision","format":"markdown+html"}
`created`	2022-12-09 18:19:03
`last_update`	2022-12-09 18:19:03
`depth`	2
`children`	3
`last_payout`	2022-12-16 18:19:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	202
`author_reputation`	20,689,097,167,261
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,981,682
`net_rshares`	0

@yahuzah · Dec 9 '22

Yeah they did and I’m actually quiet surprised. I was convinced Brazil would qualify. I don’t even want to think if Argentina can make it. This World Cup is insanely good.

properties (22)

`author`	yahuzah
`permlink`	re-mengene-2022129t184913829z
`category`	hive-101690
`json_metadata`	{"tags":["hive-101690","football","worlcup2022","sportstalk","palnet","neoxian","sports","hive","ocd","blog"],"app":"ecency/3.0.35-mobile","format":"markdown+html"}
`created`	2022-12-09 18:49:12
`last_update`	2022-12-09 18:49:12
`depth`	3
`children`	2
`last_payout`	2022-12-16 18:49:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	171
`author_reputation`	198,150,861,561,992
`root_title`	"FIFA 2022: Visualizing the Group Stage Data"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	118,982,362
`net_rshares`	0

2 replies