Microsoft Power BI Intro: Exploring FIFA Stats

In this video, we'll introduce Microsoft Power BI, a powerful visual tool for analyzing data and creating reports. We'll look at some of the main features of Power BI - visualizations, reports, data exploration, the Power Query Editor, and the M language.

In this intro, we'll use data from the popular football video game FIFA, which you can download here - drive.google.com/uc?export=download&id=1K3ipvmX478… .

We'll create several different types of analyses using this data - we'll look at players by age and overall rating, create a table of the top players (with images!), explore ratings by club, and build maps showing which countries have the most footballers. At the end, we'll integrate Power BI and Python to build a potential national team for each country.

If you want to learn more, check out the Dataquest courses on Power BI here - www.dataquest.io/path/analyzing-data-with-microsof… .

Chapters

00:00 Introduction
01:23 Power BI Introduction and loading the data
03:08 Exploring the FIFA data
05:02 Exploratory data analysis
08:21 Building a top players table
11:03 Looking at summary statistics
15:04 Merging data sets
19:12 Finding differences in ratings and salaries
27:10 Look at ratings and salaries by position
31:12 Mapping players by country
32:46 Building a national team for each country
35:04 Transforming data with a Python script
40:41 Next steps with your analysis

-----------------------------
Join 1M+ Dataquest learners today!
Master data skills and change your life.
Sign up for free: bit.ly/3O8MDef