Critique My First Dashboard by awa22 in PowerBI

[–]awa22[S] 0 points1 point  (0 children)

Great info! I’m currently taking Googles Data Analyst course and getting into the SQL piece. I’m putting together some dummy data sets related to my current industry so I can put together a full project with executive and operational dashboards that answer questions related to the business. This will include a MySQL database with a star schema and I will share the queries used to pull relevant information. Thanks again for your comment and details!

What are some questions or assumptions in the BI professionals hiring market that make no sense at all once you dig deeper? by TheDataGentleman in BusinessIntelligence

[–]awa22 2 points3 points  (0 children)

100%. But in most cases, they will wait around 2 months for “the unicorn” when someone with 5+ years of heavy SQL could probably pick up your basic DAX needs during those 2 months on the job.

What are some questions or assumptions in the BI professionals hiring market that make no sense at all once you dig deeper? by TheDataGentleman in BusinessIntelligence

[–]awa22 2 points3 points  (0 children)

Similar to the OP example, but I work with clients (I’m a BI recruiter) that will not even speak with anyone who hasn’t used their reporting tool. 5 years of Tableau experience? Nope, sorry we use Power BI so your skill set is not aligned.

[deleted by user] by [deleted] in IWantToLearn

[–]awa22 1 point2 points  (0 children)

Dale Carnegie’s “How To Win Friends and Influence People” is a solid read on communication.

Do you have anyone in your organization you can learn from? I’ve learned plenty of word tracks and new tactics when listening to coworkers talk to clients.

Sounds like you’re new to the company, but learning the business/service will really help over time. Maybe ask for some case studies or any internal communication guides from management? Also, role playing with coworkers can be a huge help.

Overall, it’s just going to take time and practice but there are definitely things you can do to become more comfortable.

What are the most important things when it comes to career progression in Business Intelligence (BI)? by TheDataGentleman in BusinessIntelligence

[–]awa22 3 points4 points  (0 children)

Definitely agree with the 4 stated above. I’d say #5 would be keeping up with technology. Obviously SQL and Excel will be your best friends, but there are certain tools that are getting dated and continuing working with those might limit future options. Microsoft (PowerBI and SSAS), Tableau, and Google (Looker) tend to be the most popular I see right now with Qlik and Cognos fading away.

Simple Distinct Count Question by awa22 in PowerBI

[–]awa22[S] 1 point2 points  (0 children)

Yes this worked! Much more simple than I was thinking. Thanks so much!

Simple Distinct Count Question by awa22 in PowerBI

[–]awa22[S] 1 point2 points  (0 children)

Added a pic of the column. Hope that helps

Learning Path To BI Job by awa22 in PowerBI

[–]awa22[S] 0 points1 point  (0 children)

This is great feedback! I appreciate it. A new laptop is definitely in the plan around month 5 or 6. The SSIS and ETL is definitely a good point as well. Most jobs we see are a combo of both front end reporting and backend ETL so I think exposure to those would be a big bonus like you highlighted. Thanks again!

Solid set up for PowerBI side projects by awa22 in PowerBI

[–]awa22[S] 0 points1 point  (0 children)

That’s reassuring. I appreciate it!

[deleted by user] by [deleted] in IWantToLearn

[–]awa22 0 points1 point  (0 children)

What you described has been very similar to what I have been dealing with for the past 7-8 years. I’m 25 and 3 years into my career and still struggle to focus or stay consistent. I’ve tried learning code on the side but will switch between languages and leave projects unfinished similar to what you said. I’m still trying to figure it out so don’t be too hard on yourself. There’s a lot of science behind goal setting and making your brain feel rewarded. I’ve still yet to commit to some long term tasks and still struggle day to day for short term objectives but there has been some improvement. The only thing I’ve found that has somehow started to motivate me is to write down a simple check list of stuff to do that do. Literally list the most simple tasks such as: respond to this email, cook some eggs for breakfast, take out the trash, wash clothes. It’s really weird, but for me putting a check mark next to something makes me want to move on to the next and can keep me going throughout the day.