Find KEYWORDS from strings EASILY using this trick // Beginners Guide to Power BI in 2022
Вставка
- Опубліковано 5 жов 2024
- Get Demo Files here
ko-fi.com/s/41...
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
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solu...
solutionsabroa...
❤ Other ways to support
ko-fi.com/solu...
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 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 UA-cam.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.micros...
#PowerBI #DataAnalytics #BusinessIntelligence
that's exactly what i need for my work! thank you !
Great video. This is a clear way to do cartesian matching.
Thanks for watching!
This is very helpful!!! I can now use this in certain dashboards. Thanks!! U're the best.
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.
Did you figure out how to do it?
Thank you for making this channel, it's very Useful
Very Helpful!! Thank you!!
Thank you for the great video!
No worries!
Great video! I am wondering if you know of a way to make this an exact match?
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 :)
Same question here!
How about adding a space before and/or after the keyword?
I had a similar problem and added a space before. As long as the word is not the first of the sentence, it should work.
Life saver
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!
Hie i have a question on 5:00 where did you clicked to edit ? i did not found it
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
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.