-
Alice Kamau
-
Category:
Business & Management & Creative Arts & Media & Science & Technology
Usually, tidy data is a mirage in a real-world setting. Additionally, before quality analysis can be done, data need to […]
Usually, tidy data is a mirage in a real-world setting. Additionally, before quality analysis can be done, data need to be in a proper format. This project-based course, “Prepare, Clean, Transform, and Load Data using Power BI” is for beginner and intermediate Power BI users willing to advance their knowledge and skills. In this course, you will learn practical ways for data cleaning and transformation using Power BI. We will talk about different data cleaning and transformation tasks like splitting, renaming, adding, removing columns. By the end of this 2-hour-long project, you will change data types, merge and append data sets. By extension, you will learn how to import data from the web and unpivot data. This project-based course is a beginner to an intermediate-level course in Power BI. Therefore, to get the most of this project, it is essential to have a basic understanding of using a computer before you take this project.
In this Guided Project, you will:
- Prepare and Clean Data using Power BI
- Transform and Load Data using Power BI
2 hours
Beginner
No download needed
Split-screen video
English
Desktop only
Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
- Split and rename columns
- Add Columns
- Remove Columns and Change data types
- Merge data
- Append data
- Unpivot data
Note: This is part of the larger overall course Data Analyst. To complete it fully, you will need to complete all of the following courses:
- Google Data Analystics
- Getting started with Microsoft Excel
- Application of Data Analysis in Business with R Programming
- Prepare, Clean, Transform, and Load Data using Power BI
- Get Started With Tableau
Note: This is part of the larger overall course Digital Marketer. To complete it fully, you will need to complete all of the following courses:
- Google Digital Marketing & E-commerce
- Create a Landing Page using Mailchimp
- Create Digital Marketing Campaign Dashboards in Tableau
- Prepare, Clean, Transform, and Load Data using Power BI
- Get Started With Tableau
- Create a value proposition canvas in Miro
- Introduction to Relational Database and SQL
- Simple Linear Regression for the Absolute Beginner
- Create a website with MailChimp
- Getting started with Microsoft Excel