Відео

Hi there, Welcome again to my channel. In this quick tutorial, I'll show you a powerful Excel trick to split text into multiple rows in just a few easy steps! Whether you're dealing with long lists, cleaning data, or organizing information, this technique will save you tons of time and make your data more manageable. Don't forget to subscribe now and turn on the notification bell so you dont mi...

Welcome back to my channel, Data Fam! In today's video, I'll walk you through how I cleaned the popular FIFA dataset using some basic but powerful Excel functions. Stick around until the end, and you'll see that it's not just about knowing a lot of functions-it's about making the most of what you have to get the job done efficiently Link to the dataset for practice: github.com/TemiTayo2304/FIFA...

Hi everyone! Welcome back to my UA-cam channel. In this video, I will be sharing how I connected a folder stored on my desktop to Power Query. With this method, whenever the data in the folder is updated, the data gets automatically updated in Power Query. This means that every data cleaning, data manipulation, or data visualization process gets automated and added to the new data. I used a cas...

Hi everyone, Welcome to my channel In this in-depth tutorial, I’ll tackle two real-world scenarios that demonstrate the power and flexibility of the Filter function: - Scenario 1: Dynamically extracting customer information for a specific region, making it easy to target your audience and analyze sales trends. I’ll show you how to use the Filter function to quickly isolate data for a particular...

Hi everyone! Welcome back to my channel! Do you struggle with the continuous download of Google Form survey data and the repetitive process of data analysis, including data cleaning and data manipulation? In today's video, I'll show you how to connect your Google Form to the Power Query Editor in Power BI to automate the data migration process. This way, once a new response is submitted, your P...

Hi everyone. Welcome again to my channel. Walk with me as take you behind the scenes of my recent data cleaning project involving the raw FIFA 2021 dataset. Using Power Query in Excel, I'll share my personal approach and the techniques I employed to transform this messy dataset into a polished, analysis-ready state. You'll see how I leveraged the powerful features of Power Query to streamline m...

Hi There! Welcome again to my channel This video explains how I was able to perform market basket analysis in SQL, aimed at identifying the most frequently bought pair of products in a transaction dataset. To understand more about market basket analysis and it's impact on businesses, check out my writeup on medium: medium.com/@anifowosedeborah95/market-basket-analysis-for-businesses-growth-5f2a...

This video introduces you to keybr.com. A beginner friendly website designed for individuals that are passionate about honing their typing skills

Hello! Welcome again to my channel. In this video, I shared the second part of the process of cleaning this dirty dataset that I manipulated myself. I utilized Power Query in Power BI to clean this dataset. I hope you learn from it and I hope to be able to share more of this. Thank you for watching. Don't forget to Like and Subscribe. Link to the first part of the video: linktw.in/cwRqLg Practi...

Hello! Welcome again to my channel. In this video, I shared the first part of the process of cleaning this dirty dataset that I manipulated myself. I utilized Power Query in Power BI to clean this dataset. I hope you learn from it and I hope to be able to share more of this. Thank you for watching. Don't forget to Like and Subscribe. Link to the continuation of the video: linktw.in/UPkLuD Pract...

Hi Guys! Welcome to my channel, and thank you for clicking on my first video. I came across this case study and I thought to myself "Why don't you make a video and share it"? In this video, I shared how I was able to utilize power query in Power BI to answer a simple business question. I hope you learn from it and I hope to be able to share more of this. Thank you for watching. Don't forget to ...