Basic ETL Exercise in Power BI

By -
Multi-purpose Buttons
Join on WhatsApp E-books for International Buyers E-books for Indian Buyers Schedule a Call

 Hi,

Please watch this video before doing the exercise.

ETL-2 video link


Download the data from here: Github link

Task

1. Get the excel file into the Power BI
2. Launch Power Query Editor
3. Check all the columns are properly named (if not, name it properly)
4. Remove the null values (Rows)
5. Delete the irrelevant columns
6. Add a new table with simple columns.


If you face any issues, please comment. 

Comments

Post a Comment

Popular posts from this blog

ISRO FREE Data Analytics Online Course 2025: FREE Certificate, Eligibility, and How to Apply

By -
Image
 Are you looking for a 100% free, government-recognized certificate course to boost your data analytics skills? The Indian Space Research Organisation (ISRO) , through its Indian Institute of Remote Sensing (IIRS) , is offering a Free Data Analytics Online Course 2025 — and the best part? Anyone can apply! ✅ Before we begin — Don’t forget to Subscribe to Goms Tech Talks on YouTube for regular updates on free courses, tech news, Power BI, and AI tools! 🚀 What Is the ISRO Free Data Analytics Course? This course is a part of IIRS’s distance learning program and is completely free of cost . The course focuses on Remote Sensing Data Analytics , and covers vital topics like: Python Programming Machine Learning (ML) Artificial Intelligence (AI) Geospatial Analysis Remote Sensing Applications in Agriculture It’s designed to help learners gain hands-on data analytics skills using real-world satellite and remote sensing datasets — crucial for modern industries such as agri-tech,...
Read more

A Comprehensive Guide to the Roles and Responsibilities of a Business Central Functional Consultant in Manufacturing

By -
Image
 Introduction In the dynamic landscape of modern businesses, the role of a Business Central Functional Consultant is of paramount importance. These experts play a pivotal role in optimizing enterprise operations, streamlining processes, and ensuring successful ERP implementations. With a profound understanding of both business processes and technical capabilities, Business Central Functional Consultants act as key bridge-builders, ensuring that Microsoft Dynamics 365 Business Central aligns seamlessly with an organization's unique needs. In this comprehensive guide, we will delve into the multifaceted roles and responsibilities of a Business Central Functional Consultant, with a particular focus on a real-life scenario in the manufacturing domain. Throughout this blog, we will explore how these professionals navigate the complexities of ERP implementations, providing insights into their indispensable value. Here are the key areas we will cover in detail: Understanding the Manufactu...
Read more

How to Become a Google Certified Educator – Level 1 & Level 2 (Step-by-Step Guide)

By -
Image
 Becoming a Google Certified Educator is one of the best ways for teachers, trainers, and education professionals to demonstrate their expertise in using Google tools effectively in the classroom. Google offers two levels of certifications – Level 1 and Level 2 – that validate your skills and help you stand out in your professional journey. Why Get Google Certified? According to Google for Education Certifications : Demonstrate proficiency in Google Workspace tools. Make a bigger impact by creating engaging, interactive learning experiences. Increase efficiency by streamlining teaching and administrative tasks. Google Certified Educator – Level 1 Purpose : Designed for educators who are new to Google tools and want to build confidence. Exam Details : Cost: $10 Duration: 180 minutes Validity: 3 years Preparation : Use the official learning path: Level 1 Resource . Registration : Register for the Level 1 Exam . Google Certified Educator – Level 2 Purpose : For advanc...
Read more