Hoppa till huvudinnehåll

Hem Business Intelligence

course

Exploratory Data Analysis in Power BI

GrundläggandeFärdighetsnivå

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.

Börja Kursen Gratis

Power BIExploratory Data Analysis3 timmar9 videos26 exercises2,050 XP48,827Uttalande om prestation

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Älskad av elever på tusentals företag

Utbilda 2 eller fler personer?

Testa DataCamp for Business

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

Kursen
är

Få ett prestationsutlåtande

Lägg till denna inloggningsuppgifter i din LinkedIn-profil, ditt CV eller ditt CV
Dela det på sociala medier och i ditt prestationssamtalRegistrera Dig Nu

Gå med över 19 miljoner elever och börja Exploratory Data Analysis in Power BI idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

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.