9 things to know before getting into Power BI (Or, really anything)

[@seancasey5378]

Great video. Three years or so working with Power Bi, can't stress the importance of spending a LOT of time in the query editor, Power Query, before putting any slicers or visual down on the canvas. Obviously when you're starting out, you want to create visuals of your data. That's important to see your own development happening in front of your eyes. However, as the projects get bigger and you begin to pull in more datasets to your model, spending time in the query editor manipulating your data will pay off down the road. Also, don't be afraid to wipe everything off the canvas if it's not working the way you want it to and go back to the query editor to get it working.

[@edgards]

Sean Casey yesssss! Data prep and cleanup is essential, pointless to build beautiful but wrong reports!

[@GuyInACube]

Agreed! Thanks for sharing that Sean 👊

[@mwaltercpa]

This is 100% spot on. Finance Excel people, if you get hooked and do all of this, your role is going to change... It did take all of this for me to grow. For me, I'd stress: 1. Don’t discount learning more about power query, there are amazing prep abilities here... also, 2. Start showing your employer what is possible. When you get support to buy the books, take courses, go to conferences, don’t hesitate just do it!! . I’m hooked and learning, still sticking my neck out... having a blast :) and the online community has been VERY supportive :)

[@GuyInACube]

YES! 👊 love those points

[@theashtonsdaddy]

As always great - practical advice - "..not everything is on Import, sometimes I have to Direct Query" Quality, and sooo true :)

[@GuyInACube]

Haha yeah it’s true

[@pkelly411]

Adam, thanks for the tips. Here' one for your consideration. Start by reading a Getting Started With or similar introduction to PowerBI book and do all the examples. When you are starting out, It is a great way to avoid frustration with doing the basics.

[@gw3nniej]

Thank you for this inspiring video! It helps me to remind: just start, practice and practice. I'm not directly a pro but I will be there in the future!

[@elrevesyelderecho]

1:19 ...and because PBI is monthly updated, so you need to keep up to date. Second, there is a huge community creating content and ways to work our that you need to follow and Third, every week at work something new come up and you will need to learn how to do it. PBI has a lot of features and functionalities or ways to do stuff that I don't thing someone knows 100% the features.

[@GuyInACube]

Agreed. I don’t know anyone that knows everything about the product. Some may know A LOT but not everything. And that’s ok...

[@markwise7130]

So great to hear somebody admit it: "It's (you're) going to suck at first!" I have been doing this part time for four years, and I have a long way to go. All the ". . . in a day" training can create self-doubt. One more thing to know, though. Know your business. Technically astute people can waste months developing beautiful reports with little business value.

[@mdhidayat5706]

I feel inspired and motivated now with the video. You can do a TedTalk, cheers!

[@GuyInACube]

Wow! Thank you for that. That is very high praise. 👊

[@HavensConsulting]

Was that a stock video of the guy typing, or did you record a friend??

[@HavensConsulting]

Also, all great concepts! I've been hesitant to talk about soft skills topics but I know people really appreciate hearing experts and their opinions on best practices and such 🙂

[@GuyInACube]

Shhhh don’t give away secrets 😉

[@HavensConsulting]

@@GuyInACube haha, only in small doses.

[@waysilentbob6976]

Couldn't agree with this more, after doing this for about 3 years, on and off, the first few months are really hard. Lot's of questions like "I know what I want to do, but I don't know where to do it". It does get easier the more you do it. I still try to format the decimal places in a visual before remembering "Nope, you click on the field to set the number of decimals". These videos help! It's like working out, the more you do it, the easier it get's. Remember, your brain is a muscle too! 😂

[@Soulenergy31]

0:51 have and development of the passion like watering and fertilizing the Chinese bamboo tree 3:52 start working on the project 4:00 Power BI is like lego 7:36 talking to like-minded people and the users 9:25 learning the fundamentals 9:50 get involved in social media 10:52 try to give a presentation 11:40 start a local group in your organization

[@Silverlythia]

I just started being a speaker about power bi, it was outside my comfort zone but really rewarding! I love doing demos and mentoring power bi, but being a speaker was definitely a new experience.

[@GuyInACube]

That’s amazing! Love it! You will be amazed when looking back how far you have come. Stick with it 👊

[@katiawei6817]

Very inspiring video. I feel energized again in my PBI journey. Thanks a lot.

[@lucyk7292]

just found this channel. love the energy and way of explaining already!

[@prakash4190]

Great Content! Definitely useful for the folks who want to begin their Career!

[@GuyInACube]

Appreciate that! Thanks for watching 👊

[@djl8710]

Sounds like he knows what he's talking about...

[@GuyInACube]

Haha just a guy in a Cube doing the work 👊

[@msiddi01]

Adam thanks for the video. Is there a way I can watch these PowerBI videos in a sequence from introduction to advanced in a structured way so I can learn this tool better? I watch your videos but I am struggling to connect because of my relative inexperience. Thnx.

[@GuyInACube]

We have a structured course that we sell. You could also check out guided learning on powerbi.com

[@kirillperian]

Awesome, Adam! I am sharing this with my kids!

[@GuyInACube]

Love it 👊😎

[@ShabnamKhan-vk7fj]

Couldn't agree more on all those points. Having a crystal clear understanding on the directions of the relationships and how that affects your data model and which table will ultimately get you to the exact visual/metrics you need is a must to be successful in report creation in PBI. Without perseverance and motivation this work will never be easy! I am so glad that Adam brings this up as a point! No one has talked about it in PBI lectures, great job!

[@GuyInACube]

Love it! Thanks for sharing and watching 👊

[@rogersantos2605]

Thanks for the video, it was very helpful ! I am from Brazil, from a little city called Jaguaruna, and find your channel it was one of the best things that I did in my professional life 😊😊

[@GuyInACube]

Wow! That's bananas! Really appreciate that. 👊

[@matthewtupuola6091]

Am looking for a group...could you recommend one?

[@SaniGarba]

Thanks Adam, and Patrick as well. You spoke directly at me. Thank you for the very valuable tips.

[@GuyInACube]

Awesome to hear. Glad it spoke to you 👊

[@amywatts2743]

Thank you Adam, this video has been very helpful. I was starting to get a little disheartened by my ability to understand the program. I feel much better about my learning now

[@GuyInACube]

I love that! Glad it was helpful. You are definitely not alone in your journey. It can be very overwhelming. Try to keep it simple and take it a day at a time. It gets better 👊

[@solarpunk_]

This post was so much better than I expected it to be. Thankyou, genuinely, thankyou...

[@GuyInACube]

Appreciate that Tim! Glad you liked it 👊

[@mohammedadnan2147]

Thanks for sharing these informations... I like the most is the last point...

[@GuyInACube]

Awesome! Glad to hear that 👊

[@88peterkhoo]

Great motivation. thank you.

[@tomogorman3947]

Just about to start with Power BI. I’ve been a business controller/financial analyst for ten years building up my own reports and dashboards in excel. But now its time to develop myself and learn something new. A friend suggest learning power query and power pivot first? Is this true?

[@jrobinson8898]

Thanks for the great feedback!! I have incorporated most of your recommendations and I can attest that it helps tremendously. Having that person that you can bounce ideas off is such a big help. Researching too. Just recently I found the answer I was looking for in a KZbin video where the young man spoke Hindu. So don't shy away from videos that are in different language because the information is universal. 😆

[@doaaismail1842]

That was fantastic high quality information and the best part is " My brain is not like an imported cashed model in Power BI. Sometimes I got a direct query". Thanks Adam and Patrick for all your amazing tips ^_^

[@powerb_i]

Really enjoyed this video - thanks. Patience and Passion are definitely key in your Power BI journey. I'm a self-taught certified Power BI Data Analyst and persistence has definitely paid off. Do the work, hang in there and as with anything, the journey gets easier. Thanks Guy in a Cube for great content, which has help me on my journey.

[@darcyg852]

What if you're at the mercy having to use the models someone else has built? Another words, the BI Analysts builds it and we have to use what they built.

[@pennyjnewton]

Thank you!! I train Business Intelligence Analysts across the world in data transformation and Power BI and other BI tools and I reference your videos because you use language that can easily be understood by people in different countries where English is not necessarily their primary language. :)

[@aVanGeLz07]

I like this video. Maybe when I am down or lost at work, I'll watch this again.

[@shonek6367]

for real, i was randomly click on this video hope to get some insight of power bi, but i ended strangely motivated to learn other things and this video encourage me to get more patience before really mastering a things or a job. Thankyou so much (big thumbs up)

[@extensionshk2314]

Nice, one important need is Matrix visual 's column expand/collapse using +/- icon like row, pls add thanks

[@k0708870]

Invaluable advice, massively agree with having someone else to bounce ideas off in those tough moments can really help you navigate a problem and save a lot of time!

[@darylellis7597]

Extreme amount of truth in this video. Learning the various components (power query, DAX, visuals, and Service) is overwhelming. My advice start out with a small project - go thru the complete process, before starting a second or more difficult project. Thank you for the confidence builder!

[@marlucaplus]

I loved the first animation with legos and the lego analogy ! Great tips, I have been through this path and it's like that. It is fantastic to have a video telling the new bi guys about this

[@GuyInACube]

Yup. Been outlet whole careers. Even today we are still learning and trying new things.

[@mohammed333suliman]

This is Great video. Thank you guys.

[@GuyInACube]

Appreciate that! Thanks for watching 👊

[@FranciscoCamacho_fjcamachoj]

Hi Adam great video. Do you have any advice about learning statistics, math or any other skill? Any book recommended?

[@vijayarjunwadkar]

Very nice Adam! Your tips are surely going to help a lot! Keep up the great work! 😊👍

[@ayushurmaliya5217]

wow you are amazing Adam , i am sure gonna learn beauty of power BI in Guy in a Cube.

[@joaquinmaverick82]

"Searching is your friend" -BING hahaha

[@GuyInACube]

Yup! :) Internet search engine of your choice, but when you go to Bing, type...

[@dantemartinez3609]

Great content here! As far visualization goes, can you recommend some books for a beginner. Something I can use to get a good foundation. Thank you!

[@wmfexcel]

Great contents! Practice makes perfect! Keep moving! 👍

[@SmitNReyansh]

Big fan of guy in cube.. you guys are amazing! Can't thank you enough 🙂

[@TrekTreats]

Good advice - thanks

[@GuyInACube]

Most welcome! Thanks for watching 👊

[@saraouchtal6375]

Great content! Thank you :)

[@GuyInACube]

Most welcome Sara! Thanks for watching 👊

[@JaideepShahG]

Superrr.... Loved it. 😍

[@GuyInACube]

Thanks for that Jaideep! 👊

[@sarker.]

Really inspiring speech!

[@samirkapadia3423]

Appreciate the guidance

[@sarinashrestha9540]

Awesome!!

[@GuyInACube]

Thanks Sarina! 👊

[@CRUBIOLP]

FIRST!

[@GuyInACube]

BAM! 👊

[@Fernando_Calero]

Fining the mentor doesn't sound like a good idea though ... 😎

[@GuyInACube]

How do?

[@Fernando_Calero]

@@GuyInACube Just a typo, Man. Check min. 7:12

[@bezuayehuyilma5281]

Thank you

[@agustinpisano8064]

Excellent!

[@tabassumrao]

It was just a waste of 13 minutes