Тёмный

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

Fernan
Подписаться 45 тыс.
Просмотров 12 тыс.
50% 1

Get Demo Files here
ko-fi.com/s/416406cdfe
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/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
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 RU-vid.
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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

 

15 фев 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@cecewang70
@cecewang70 Год назад
that's exactly what i need for my work! thank you !
@gintomino4136
@gintomino4136 2 года назад
This is very helpful!!! I can now use this in certain dashboards. Thanks!! U're the best.
@mominfauzan8279
@mominfauzan8279 2 года назад
Thank you for making this channel, it's very Useful
@jrobinson8898
@jrobinson8898 11 месяцев назад
Very Helpful!! Thank you!!
@lijunchen
@lijunchen Год назад
Great video. This is a clear way to do cartesian matching.
@SolutionsAbroad
@SolutionsAbroad Год назад
Thanks for watching!
@Nura853
@Nura853 2 года назад
Thank you for the great video!
@SolutionsAbroad
@SolutionsAbroad 2 года назад
No worries!
@redsectionXD
@redsectionXD 8 месяцев назад
Life saver
@fpoester
@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.
@manognas455
@manognas455 8 месяцев назад
Did you figure out how to do it?
@johnnyhernandez8605
@johnnyhernandez8605 Год назад
Great video! I am wondering if you know of a way to make this an exact match?
@luiseachflynn7098
@luiseachflynn7098 2 года назад
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 :)
@marjorieherrera3031
@marjorieherrera3031 Год назад
Same question here!
@lijunchen
@lijunchen Год назад
How about adding a space before and/or after the keyword?
@fpoester
@fpoester Год назад
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.
@rohanthawale7889
@rohanthawale7889 Год назад
Hie i have a question on 5:00 where did you clicked to edit ? i did not found it
@cecewang70
@cecewang70 Год назад
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!
@rajendratiwari5321
@rajendratiwari5321 Год назад
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
@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.
Далее
Multiple Key Words Search with Power Query
15:58
Просмотров 32 тыс.
❤️My First Subscriber #shorts #thankyou
00:26
Просмотров 4,6 млн
Word Frequency counter Power Query
14:16
Просмотров 15 тыс.
Search for key words with Power Query
18:04
Просмотров 29 тыс.
I Bet You Don't Know All These Power Query Tricks
12:28
Master Power BI with AI | @PavanLalwani
12:33
Просмотров 62 тыс.