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

Bringing ChatGPT into Business Central

By -
Image
Multi-purpose Buttons Join on WhatsApp E-books for International Buyers E-books for Indian Buyers Schedule a Call  Hi readers, The purpose of the blog is to provide a step-by-step guide on how to integrate ChatGPT, a conversational AI tool, in Business Central, an all-in-one business management solution. The blog aims to educate readers on what ChatGPT and Business Central are, and how to sign up for ChatGPT, obtain the ChatGPT API, and create a Codeunit, Table, and Page in Business Central. The blog post also aims to show readers how to integrate ChatGPT into Business Central, and how it can be used to streamline business operations and enhance customer support. Overview What is ChatGPT? Definition and overview of ChatGPT Explanation of how it works and its key features 2.       What is Business Central? Definition and overview of Business Central Explanation of i...
Read more

🚀 ISRO Launches Bharatiya Antariksh Hackathon 2025 – No Fees, Internships & National Exposure!

By -
 Are you ready to solve real-world space-tech challenges and get mentored by ISRO scientists? Before we dive in — 🎥 Don’t miss our exclusive video breakdown on this hackathon with tips to stand out: 👉 Subscribe to our YouTube Channel for updates – stay ahead in space innovation! 🔭 Overview The Bharatiya Antariksh Hackathon 2025 (BAH 2025) is a national-level innovation challenge organized by ISRO in collaboration with Hack2Skill . After the grand success of its first edition, the second edition was launched on June 18, 2025 , to bring together brilliant student minds to solve space-related challenges using AI, ML, geospatial science, and data analytics . The Grand Finale will be a 30-hour event held on August 7th and 8th, 2025,  at NRSC, JD Metla Campus, Hyderabad . 🌟 Key Highlights Feature Details Organizer Indian Space Research Organisation (ISRO) Innovation Partner Hack2Skill Finale Date 7–8 August 2025 Submission Deadline 7 July 2025 (tentative) Fees Zero (...
Read more

Top 5 Project Websites for Students

By -
Image
 In the digital age, students have unprecedented access to resources that can aid their academic and professional growth. One such vital resource is project websites, which offer free and paid projects, study materials, and guidance on various technical topics. Here, we explore the top 5 project websites for students, each providing unique features and a wealth of knowledge to kickstart your learning journey. For personalized guidance, you can schedule a call here .  Don't forget to subscribe to my channel for more updates: GomsTechTalks . 1. Project Worlds  Project Worlds offers an array of PHP projects, including the Online Admission System using PHP, MySQL, and Bootstrap. This platform is perfect for students looking to enhance their web development skills. The projects are designed to provide hands-on experience with real-world applications, allowing students to understand the practical aspects of programming. With detailed documentation and source code, Project Worl...
Read more