Find KEYWORDS from strings EASILY using this trick // Beginners Guide to Power BI in 2022

Get Demo Files here

In this video were going to go through how you can find keywords within list of strings really easily using only Power Query

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[cecewang]

that's exactly what i need for my work! thank you !

[lijunchen]

Great video. This is a clear way to do cartesian matching.

[gintomino]

This is very helpful!!! I can now use this in certain dashboards. Thanks!! U're the best.

[fpoester]

I have a question. If I have a larger dataset, let`s say 10k responses, and lets say 10 keywords, the comparison table out of a sudden will jump from 10k to 100k. This can get nasty for performance quite fast. Can I somehow just relate both tables without unpivoting the keywords? I hope I was clear with the question, thank you for the very interesting material.

[mominfauzan]

Thank you for making this channel, it's very Useful

[rohanthawale]

Hie i have a question on 5:00 where did you clicked to edit ? i did not found it

[johnnyhernandez]

Great video! I am wondering if you know of a way to make this an exact match?

[luiseachflynn]

Very helpful thanks so much! Quick question: one of my keywords is "Dust" and the query is matching records containing the word "Industry", any tips on how to address this? Thanks again :)

[cecewang]

i did the same for my work. But it's not counting correctly. for example, it counts much 18 "1"s while there are only 2 "1". it counts 36 while there are 6 "1". Any idea what is wrong? Thank you!

[rajendratiwari]

I tried this method for a large dataset it's generating too many duplicate values and while sorting it gives me error as "can't convert the value # (2022, 12, 02) to date"
Please help

[zoomingby]

Lol, you say "without further ado, let's get started." THEN you introduce yourself and do more marketing of your channel, etc. I'm not sure you know what "without further ado" means.