Hoppa till huvudinnehållet

Hem Business Intelligence

Kurs

Exploratory Data Analysis in Power BI

GrundläggandeKunskapsnivå

Uppdaterad 2024-10

Learn how to build impactful reports with Power BI’s Exploratory Data Analysis (EDA) that uncover insights faster and drive business value.

Starta kursen gratis

Power BIExploratory Data Analysis

3 tim

9 videor

26 Övningar

2,050 XP

50,194

Intyg om genomförande

Omtyckt av lärande på tusentals företag

Utbildar du ett team?

Prova för företag

Kursbeskrivning

Introduction to Exploratory Data Analysis in Power BI

Enhance your reports with Power BI's Exploratory Data Analysis (EDA)! This beginner course for data analysts covers foundational aspects of EDA, including descriptive statistics, handling missing data, analyzing distributions, and identifying outliers. You'll learn to use histograms, box plots, and scatter plots to visualize data, interpret distributions, and understand relationships between variables.

Apply Statistical Techniques

Explore how to manage categorical and continuous variables, use advanced visualization techniques, and calculate correlation coefficients. Interactive exercises and real-world examples ensure you can apply these skills to analyze and interpret your data effectively.

Förkunskapskrav

Introduction to DAX in Power BI

1

Initial Exploratory Data Analysis in Power BI

You’ll begin this Exploratory Data Analysis (EDA) course by learning how to use descriptive statistics and identify missing data, and apply imputation techniques to fill the gaps in your data.

What is exploratory data analysis?

Steps to EDA

Initial EDA of AirBnB listings

Identify missing data

Descriptive statistics for a variable

Imputation for missing data

2

Distributions and Outliers

In the second chapter of this course you'll learn how to identify and address outliers within the dataset. You will build histograms to analyze distributions and use winsorizing to remove outliers.

Distributions and outliers

Choices for finding outliers

Histograms and outliers in AirBnB listings

Create your first histogram

Identify outliers

Addressing outliers in the data

3

EDA with Categorical Variables

Now it’s time to explore the relationships between categorical variables using proportions. You’ll then use box plots and descriptive statistics to determine how a continuous variable is influenced by a categorical one.

EDA with categorical variables

Histograms vs. box plots

Exploring categorical variables with AirBnB data

Analyzing a categorical variable

Proportions with categorical variables

Analyzing multiple categorical variables

Creating a box plot

4

Relationships between Continuous Variables

In the final chapter, you’ll dive into scatter plots to analyze the relationship between two continuous variables and calculate the correlation coefficient.

Relationships between continuous variables

Practice interpreting a scatter plot

Exploring AirBnB listings with scatter plots

Analyzing relationships with scatter plots

Adding context to scatter plots

Correlation coefficient

Congratulations!

Exploratory Data Analysis in Power BI

Kurs
slutförd

Tjäna ett prestationsbevis

Lägg till det här beviset i din LinkedIn-profil, ditt CV eller din meritförteckning
Dela det i sociala medier och i din medarbetarutvärderingRegistrera dig nu

Gå med 19 miljoner lärande och börja Exploratory Data Analysis in Power BI idag!

Utveckla dina datakunskaper med DataCamp för mobilen

Gör framsteg när du är på språng med våra mobila kurser och dagliga 5-minuters kodningsutmaningar.