Getting my organization to make the necessary investments to implement better data solutions. Since they won’t, now it’s building out the skill set to go somewhere that will.
@@HoosierHorn Yeah, me too. Stuck using Google Sheets cause even Excel seems to be too complex to share within organization. Made an education plan for myself, gonna try and learn Power BI to start with and start pushing that withing organization. If nothing, off I go to try and find greener pastures.
For me, definitely getting quality feedback. I work with Marketing & Sales teams a lot, even though there's some Riskmanagement involved there too (iGaming industry) and within my organization we barely have any meetings. So it's basically expected of me to either make really short video presentations or somehow make the Dashboard or Report to be super simple. Of course, more often than not I either don't get any feedback whatsoever apart from a thumbs-up on Slack or "please make it shorter" --- Without even describing which aspect may have been useful and which one not. Boss is happy, and basically the only person that will give feedback but.... It's driving me crazy. I find it impossible to improve or get greater insight into problems with this company culture.
Data analytics is a great career. It has its a share of downsides, but those can be mitigated by joining the right company/team. One thing I'd like to tell aspiring analysts- be aware of letting the 'analyst mindset' creep in to your personal life. It happens slowly over years.. Soon you will be making spreadsheets and trying to quantify everything. While thinking like that has its benefits, there are many downsides.
Huh? Everything can be quantified. Everyone has value, some are just higher than other and the numbers would be different from people to people because everyone has their own standards. But what matters is how much you value yourself.
@@sunshine1004 IMO, although it’s the nature of it, can at times be extremely tedious. Some companies do not have a great data culture, and it can lead to many hours of work just to be able to begin work on a project. It can be very frustrating to chase down a bug in poorly written code or to discover fundamental flaws in the data preventing you from answering a question.
There’s always a temptation to build something great and beautiful but you need to be prepared that your management often doesn’t need it. Working with data is like an art.
6:18 speaking on the anxiety portion, back in 2018 (when I got my first analyst role) I had extreme anxiety to the point where I was completely uncomfortable talking to people on the phone. However, over the years talking with a bunch of people in different teams it has significantly improved my social anxiety. That's not to say that it's completely gone, but I no longer fear (as much) talking to people these days. Nowadays in 2022 I manage the data behind our finance team's labor plan so I have to have weekly meetings with finance stakeholders and usually executives 1-2 times per year, so I've gotten much more comfortable.
Zach, thanks for sharing this! It's awesome to hear how you worked on this over the years and tthat you've seen an improvement in being more comfortable with controlling social anxiety! This was motivating to read, so thank you!
This video represents my work haha. I have been through many of those. Rejection wasn’t easy, I must admit. I love the job so the lesson is to continue improving to create better value and to be able to prove it to management in words they understand (and also learning that management can be right about their decisions even if it hurts our pride). I am believer that the most fundamental skills for a data nerd are social skills and constant learning. As Luke says, we need to communicate to find out what the team and the business needs and we then need to communicate our solution in words that the team and management understand and those usually aren’t the tech words we all know and love.
So very much agree with this, José!! Loved your perspective on this. Communication skills and learning is such an imperative part of this process and when you can talk in a manner that your teammates understand, success happens! Thanks again!
Isn't any job requires you to provide values to the company? Otherwise you're nothing but a walking and breathing waste of space and oxygen that is asking for the pink slip.
Data Analyst is like being an artist with one key difference. As a data analyst, non data people don't care about your work, but you make a good living. As an artist, people admire artwork as magic and talent, but its hard to make a living
If you can find a business partner who fully buys in to becoming data driven, with your assistance their area will outperform and the cause will be noticable. This tends to make other business partners request your assistance. Focus on what you can measure that they have the power to improve.
Yea I'm lucky to work for a data driven company where my work is valued. I was more so referring to the general public . I make art too and all my friends and fam love seeing and talking about my art , but get nausea when I bring up my enthusiasm for data lol
As an aspiring data analyst with every odd stacked against him, I appreciate this video very much. I'm still not deterred from my mission 🙏 Good shit Bro
As someone who has been a data analyst at a corporation for almost a decade, I feel you hit the nail on the head with most of this video. Nice work giving people insight into the job!
Haha the intro is so hilarious! Very well done! 👍Actually Ken is a very nice boss who even told you what you were getting into LOL. Definitely relate to all the points you mentioned, Luke. I'd like to add one more point here from my experience that a lot of time in my life has been dedicated to waiting for data to run as well haha.. just a reality of working in big data projects.
Hey Thu Vu!! 👋🏼 Love your channel!! Agree on Ken being a very nice boss, I'm actually very much lucky to have him! Or at least he tells me that.. 🤣 jk Also great point on the running data pipelines!! So true!
@@LukeBarousse Hey Luke, thanks for checking out my channel! I'm so glad you liked it 😄. Agreed, I can imagine you two would work together very well haha. Ken definitely reminds me of one of those smart and perfect colleagues at my work 🤓
Haha I feel that too much. The most difficult part I've encountered is changing metrics. I spent two months just gathering requirements, literally no building, because they kept changing what they wanted.
An honest look at being a DA. I know the intro was in good jest, but it was always painfully accurate too haha. Surprised to see that I came in at the upper end of DA salary on my first job in the field. But Luke isn't lying, I have to show up and fight for my job every day, and provide value. I also think your bit on Python is true, as much as I would love to learn it right now, for the first three years or so, I need to focus purely on the tools I use every day: Tableau, Excel, and a little SQL. This was the honest hard truth some needed to hear.
Ken may have made the interview feel a little 'too real'. 😂🤣 And thanks for sharing this perspective, Travis!! Glad you can confirm the Python portion and that I'm not alone on this claim. I am a little worried about the backlash from the python and r lovers tho... 😂
Three years may be a stretch. It should take a couple of weeks to learn to write SQL queries reasonably well, same for the basics of a BI tool. Excel takes a few months. For all tools, your proficiency will continue to increase the more use cases you apply them to. I tend to push new analysts fresh from academia to start learning Python after 3-6 months, and support them taking time each week to learn and practice. Data Camp is a great introduction, and you can start learning for free. I like that it has hands on coding examples that you can actually run to see the results. Only a browser is required, not a python install. Start by learning the Pandas library. It is like a mix of SQL and Excel, and many other packages work well with dataframes. Best of luck!
@@benjamincarter6095 I appreciate the dialogue and challenging me to push my timeline forward. I'll accelerate my path a bit: I should be able to come better than proficient in Tableau / Excel / SQL within this calendar year. I appreciate the tips on Python too, and like your roadmap on skills/python/timeline too, thank you for helping
I totally relate to this! Thru the course of time, I developed the skill to create a story and nonstop patience in observation to backup my claims to make sure my proposed solution will be used. Not to mention the empathy, making sure we are connected to our stakeholders emotionally for them to fully trust your work because they know that you understood their challenges. Most importantly, make sure that if our stakeholders find it hard to understand what you are saying, we need to level down our vocabulary to a level that they would comprehend so it would make sense. Happy analyzing folks! This is a great content!
Hi Luke, another fine video. Excellent perspective. I can't wait to start my career as a data analyst. I mean really Luke, it's all so immensely fascinating. Thanks again man for posting such good content.
Hi Luke, I also like that you have a sense of humour. Everyone knows that data is serious stuff. But you find a way to not take yourself super serious. And when you are serious, we get that. Keep on man. It's very helpful.
Currently I am almost midway to my Data Analytics course. Watching this video confirmed some of the things I am anticipating to encounter when I finally start working. And no I'm not discourage. And I seemed to look forward to it. As always, great video Luke! Thank you!!!
In regard to "what tool we are working with or learning" poll. Programming has the highest score probably because it's the hardest among other tools to learn and thus has the highest priority. Anyways, thanks for another great video as always!
Thank you four your insights!! I'm working as an economist at an university, but I'm considering more and more (for many different reasons) to change my career path towards data science
That's cool, I've always been interested into economy. Even thought about changing my career path towards economy. There are two famous latin american economists called Axel Kaiser and Javier Milei. I think they are good exponents of latin american economic thought and are making the youth interested in economy.
Thank you Luke! I very much enjoy the seemingly doomy videos like these, as they show me the real and sometimes painful aspects of the job. Although you list some discouraging things on this list, I feel like it makes me even more motivated to make the most out of it and pursue my dreams!
thanks so much for this!! as someone who is looking to make a career swap this was super insightful and even encouraging! made me realize what I value in a career and data analysis is looking really great right now!
Great video! I agree with basically everything here. I’ve found that if you know SQL then that can be an easy why to up your initial salary a bit. As far as stakeholders having strong opinions on which charts you should use (looking at you finance people 😅), I generally create the exact dashboard the stakeholder asks for and then add my ideas. When I present the dashboard, I start off with what they asked for, make they’re they’re satisfied with that, then say something like “I put something together last night that I think might help” and show them the extras. Sometimes it works sometimes it doesn’t haha
Shashank!! My dude! Thanks for checking this video out! Also, I very much like your perspective on how you deliver a dashboard: 1) you give them what they want and 2) you provide them with a little something extra 😉. This is definitely a more viable approach for delivering your solutions 🙌🏼 If anybody wants another perspective on becoming a data analyst check out Shashank's video on it: th-cam.com/video/-AbAm4t4FYQ/w-d-xo.html
Great video. I'm starting to learn SQL and I see a number of options: T-SQL, MySQL, PostgreSQL etc what are the differences and which will you recommend I learn?
Tsql is only used with Microsoft SQL. MySQL and Postgre, are more widely used and have lots of integrations and tools. PostgreSQL has more options for large databases, some similar to Oracle SQL, without the licensing and old software garbage. I would recommend getting a course with Postgre and test building a few projects with it, then comparing it to MySQL. The next step would probably be mongodb (nosql) or influx (time series)
In my opinion, it does not matter which System you are learning on. The basic commands are always very similar. I like prostgres but i learned SQL on sqlite and Microsoft SQL. The gap is not that big and IT should not prevent you from start learning. Good luck
Hey Nathan, It looks like there are great answers above from @username & @Peter_Silie. I agree with the fact that it doesn't matter as much about the database management system you pick (Microsoft SQL, MySQL, POstgreSQL), but instead it matters more that you know how to write SQL syntax (which is basically the same in all these different database management systems). I would focus on learning SQL syntax. From there pick a common database management system and start building!
@@LukeBarousse Thanks for your response and others. I am also in the same situation. Learning PostgreSQL and wondering if my learning is comprehensive. Now I understand better. Thanks👍
Reinforcing the minds and the reality. Thank you. It was soothing to hear. I did want to avoid the problems you mention as an mfg engineer but it's good to learn that I will encounter them in every job and that it's ok. Dont get frustrated there will be better days.
The intro gave me anxiety. Haha! Great video, there's some really good insight here and some valuable takeaway of the commitment needed to be a data analyst.
I find a lot of what may deter someone is actually positive and can strengthen a person's character instead. It's part of the reason why I'm pursuing a data analyst role and teaching myself technical skills right now. However, I am curious about maintaining a healthy work-life balance or just not getting too burnt out. I would love your input on this. I'm like you where job satisfaction is very important, and I actually was planning on just using this career to build up my actual passion on the side. Basically having a fair income while trying to not be a literal starving artist lol
Yeah, I feel your pain, I struggle with this healthy work-life balance and not being burnt out as well. Unfortunately, I don't have a winning answer to this and instead, this is a struggle that many of us are trying to figure out.
Company culture is everything when it comes to work life balance. Remember that you are interviewing the company as much as they are interviewing you. Ask questions about the culture and work life balance. If you meet individual contributors at the company, ask what their average workday is like and what they enjoy most about their job and their company. If possible, either before or after the interview, talk to a person in the lowest level position your can identify and approach. How a company treats easily replaceable employees, and what those employees think of their company,speaks volumes to the quality of the culture.
Really interesting video. I’m trying to change careers at 41 and think that data analyst is a likely entry level position to get my foot in the door with.
@@LukeBarousse hey Luke... How did was your experience when you transitioned? You must have had a lot of experience in some other tech and becoming sort of a fresher again and competing to those younger professionals who has already been working in that field, how did you manage that? Did you ever have doubts that all those years of experience would go to waste and did starting something new at that point of career by leaving a path where you are already well settled gave you anxiety or self doubts?
@@ABHITECHNOCRAT Yeah I actually made a video on it: th-cam.com/video/3Ao2FV1r5-8/w-d-xo.html But to answer your question more specifically, I had A TON of doubts of starting in this career. Mainly I had spent 7 years of my life in another unrelated career and was afraid it would go to waste. BUT I figured out how to take advantage of this experience instead and apply it in my new role. Hope this helps shed some light on this!
@@LukeBarousse I'm a new subscriber and haven't noticed this video. Thank you for linking it! I'm an introvert as well and in my 30s trying to transition to data, so it was very motivating!
I’m really considering becoming a data analyst, as maths and calculations were never my strength. I have a degree in psychology and main transferable skills was statistics, but when I hear people from economics and computer background commenting I feel so intimidated 😅
Your videos have so much value that every time I watch them, I get one thing to study in order to make better decisions in my daily work with data. Thanks, @Luke.
While Microsoft Excel might be the most demanded skill for data analysts. from the perspective of users of the data analysis that is, it creates a nightmare in terms of "one source of truth." Each person can modify the Microsoft Excel spreadsheet or workbook. Eventually, nobody can agree on the outcomes produced by the various modified versions , each held by a single individual. An interactive dashboard, with clearly defined functionality and restricted ways to "tamper with the outcome," in my opinion, is a superior way to let users "play" with the data.
Very much agree with your pains! I've experienced such similar issues in my job, it can be soooo frustrating. I actually made a whole video on this topic: th-cam.com/video/3TBwY4VjLX8/w-d-xo.html
Strongly recommend that all analysts don't rely on excel for this reason, and use jupyter notebooks instead. They are deterministic/reproducible, and can be checked in to version control.
Excel should not be the primary source for any key data. If there are any data silos, integration should occur using appropriate tools. Work to develop the data maturity of your company, including data governance appropriate for your size and complexity.
@@benjamincarter6095 fortunately I am not an employee of any company so their disasters are on them. I can only offer fact-based advice; any client is free to ignore it at their peril. As to Microsoft Excel, my comment was focused on end-users adding formulae and/or calculation cells (row-wise or column-wise), and playing "what-if" games with the data which was intended to be static...that is, no connection back to the data source(s). Dashboards can and should directly connect to the source data albeit non-operational, non-line-of-business databases, APIs, etc. that could adversely impact the production environment.
Don't expect to start by showing something new that will revolutionise the company. Expect to show management what they already know, but give them a little understanding why. Then after years of doing that, they will trust you enough to show them something new. Also its ok that some projects don't go anywhere. It's great to confirm that the company is sailing the right course and no action is required opposed to costly knee jerk reactions.
I liked these insights, Daniel! Very much agree about with your first statement and like how you use Buy-in to get management to adapt to your ideas. Thankks for this!
You have to walk before you run. Depends on the level of data literacy and maturity of the company as to what they will expect and accept. Trust is paramount, never let it slip.
I want to emphasize something that was not said in the video. Domain Knowledge. I was a Mechanical Engineering in manufacturing that switched to data analyst in health insurance. It was one of the most stressful job since I had to learn about the entire healthcare industry and its process. My supervisor told me that the analyst should be the smartest person in the room with the ability to answer all the questions management throws at you. I know that everyone's experience is different but im just saying what my transition was like. I switched to being a data engineer in manufacturing and never been more happier.
I strongly agree on the part about "A job may have different tools than the ones you prefer or have experience using". I trained for Excel, MySQL, Python, and GCP. Now I may need to know Azure and Java for work. Not a big fan of Azure as IAAS, but the job requires it.
Unfortunately salary is more important than job satisfaction. Thinking like that means you are probably making more than the average salary in your area. Living in Miami the average salary is 50k but entry level analyst are making over 60k; I feel that if you are making over the average salary you are on good living conditions.
thank you Luke ,i am a graduate data analyst with Coursera , what's your recommendation for the next courses i need to prepare myself . Big fan of yours Cheers.
So, you telling me that you could have been doing a great job and show something new but still get rejected by your bosses. In that case, what is true success for you(and all) as DA? What are you looking for to end your day and feel like "i did a great job today/this week/this month"?
I actually got to practice some python at work this week, nothing has come of it yet but it satisfied my itch of starting to solve a particular problem
I guess I must be the exception. I just landed my first data analyst position. There were two rounds of interviews and in both I had to complete technical tasks in Python.
Interesting, thanks for sharing this! I do think that Python is a popular tool for Data Analysts, but yeah from my research it appears that SQL and Excel are more popular. Either way... YOU GOT THE JOB!! Congrats my dude!!
I observe that a person needs to be heavy into mathematics inside of calculus and understand how to apply those skills into Excel/SQL/maybe Python as a gift from god once you reach that level -- not to mention investigative skills that drive you to dig in and find "things" bad/good, and become a gambler do the distance and then test your full blown skill sets at the Tables!
Could you make a video comparing data analyst with business analytics? Most universities have programs like MS in Business analytics but the curriculum is pretty much that of a data analyst.
I am currently doing an MSc in business analytics and applying for graduate data analyst roles. From what we've learnt, it's exactly what the data analyst role asks for
The job descriptions are synonymous. Business analyst may imply a focus on a specific business function (department) rather than an organizational focus. Always ask about the scope of the position early if it is not clear from reading the JD.
TBH I spent a little bit too much time editing... and not enough time building dashboards... probably why I encountered all these issues in the video 🤣
What I get from this video is, whatever the world portrayed data analyst as a cool job, it's actually the same as the other job. Keep humble is the key to strive and survive from the pressure.
I haven't being in that ground yet. But I learn to demystifying data jobs from now, so I don't put my expectation too high and become sour if it is not as I expected.
If you get stuck at a company where your job is not what you think it should be, first try to enact the change you want to see. This may take years, but if you see signs that change is possible and at least some areas are receptive to your efforts then this path can lead to a very rewarding experience and career. If you spend a year of being intentional in your efforts to lead change and all you experience is roadblocks, then there is a cultural issue that will be very challenging to overcome. In this case, develop your personal network and consider looking for another position with a new company. Share your efforts to lead change during your interview. A great data and analytics manager will appreciate your proactive approach, and may even commiserate since they likely have similar experiences.
Interesting - im considering switching from psychology to data analysis. in psychology i got comfy with R and we got a nice overview of statistical approaches for testing distributions, compare group, data prediction with regressions and principal component analysis. What i actually would like to do is: use my psych background to gather insights based upon already proven scientific concepts, but im a bit afraid that as a data analyst actually i would maybe even work below some mba or psychogy-person who then just gives me the task while all my conceptual knowledge in the field wouldnt count much and i maybe would even earn less? (i guess the manager of the data scientist earns more?)
Hey Predro! 👋🏼 It sounds like you want to provide data analytics in a psych-type role. Which I think you can totally do. Data analytics (and data science in general) is needed in so many fields to start digging into the data and gain insights. I wouldn't focus too much on finding a role titled "Data Analyst". What you are looking for may not always be called that so I would more look for Psych-roles that match your interest in data analytics. Regarding whether you'll be working below somebody is really up to what job you choose. I think in your case you just need to be creative in looking for these types of jobs and opportunities and making sure that the job itself relates to your background.
Want a job? I need someone familiar with behavioral psychology, statistics and some basic coding experience. Working on projects to improve our understanding of customer preferences and life journeys, with the goal of personalizing user experiences and predicting major life events. Training and access to a seasoned team will catch you up on any areas you feel deficient. Always interested in recruiting new talent with a wide array of skills and experiences! Let me know if you are interested and we'll figure out a way to talk.
Aw thanks for this Joanna! Ha, if you met me in real life you would notice immediately that i'm an introvert 🤣 but yes! def have been working on my communication skills.
Hey Luke, I'm now to your channel. I'm currently preparing my exam for database fundamentals. Does data analyst also use EER schematic's. Also learning SQL is really fun! :)
bro, its great that you can choose a job based off passions but most people get jobs for the money, so yeah im gonna become whatever employee that gets paid well cause the money i make will satisfy me by not being poor. Passions come outside of work hours.
Another great video, I'm learning so much from these and from the comments section too, thank you. I wanted to ask if there are particular resources/courses or platforms that folks would recommend for excel in particular? I know I could learn it from a number of places, but I'm wondering if there are any courses or resources that have stood out to folks? Cheers.
I am planning to do my Masters in Business Analytics in the US to get into the field of Data analytics/science. I want to ensure that I get a great job at a decent firm in the US. I will be starting my master's in Fall 22. What do you suggest I do or divert my focus to for a better chance of landing jobs once I'm in my master's degree? I have experience as a data analyst for 3 years.
I'd start with building up your portfolio and also your online presence in the data analytics community. It's great to have a degree, but can showcase experience to an employer (through a portfolio) I found that you can have the most success!
I like data analysis, but mostly for personal use. I feel like it’s a passion of mine, but if I take on a full time corporate job where I have to solve problems I’m not interested in, I feel like it will ruin it for me. I think I just don’t like the corporate setting, corporate politics. I might go the upwork route for its flexibility and options. What do you think about this?
Aww thanks so much for this!! It really depends on what tool you want to dive into! I recommend using the Google Data Analytics certificate to find out what your interest is in and then using a tool to dive in to practice skills on the data.
Data Camp is a great starting point for free. From there, many free resources exist for data sets of various sizes which you can download and use to continue learning. Ideally, if you have the resources and the patience to follow step by step instructions, setup a SQL server. Then dump multiple tables from a few source into tables in a data base. Explore this data with various tools, including SQL, Excel, Python, R, Power BI and Tableau. Get a sense of which tool works best for different use cases. I wish colleges had this environment available to all students, with use cases loaded into databases related to various subjects. You can use this setup to continue to learn and experiment even after you have a job.
since you mentioned the influence of an individual on entry level job I, i guess like in most cases,any job ..you wouldn't get to have much of opinion or influence mostly it's you do the job and learn more to develop certain skill set to go further , so yeah that doesn't apply on data analyst only anyway xD thanks for sharing your insights
I hate work as data analyst, but I really like job as data engineer. I hate being constantly with stakeholders in useless meetings... Am introvert, I feel totally drained after those meetings
Same here, i am a stammerer , constant communication would be very hard for me . But is they any way we can a be a data engineer without first being a data analyst?
I have a BA in Psychology. So I was wondering if Data Science could be a nice Career change and also something that could add to my existing skills. Any body have any comments about it?
@Luke Barousse, tnx for the video. What Coursera course would you recommend someone starting from zero? Like just basic Excel understanding.. Thanks in advance!
Sounds like you work at a great company, or at least one devoted to improving data maturity. Congrats! You will get out of the training what you put into it. Look for opportunities to apply what you learn early and often. Early on, share your work with someone in analytics and ask them to review it and offer suggestions for improvement. This will help you build confidence and take your learning to the next level while also gaining exposure to experts who are obviously interested in identifying internal talent. It will also ensure your analysis is reviewed and reduce the likelihood of errors in your finished product. Best of luck!
Great explanation, thank you.... IMO you should not use music as a background, even if it low volume, because it's a bit disturb my concentration.... I don't know about other, but I need extra focus in listening people who speak English, maybe because its not my mother tounge, idk.... Anyway it's a great video, thanks a lot for the explanation 👍🏻
Thanks for sharing this! I agree with what you are saying so let me see what I can do for future videos. I do like to have some music (and I did spend extra time in this video trying to put it low enough... but apparently that wasn't enough 🤣) Thanks for watching!
I'm just confused between doing the CompTIA trifecta and going for IT support or becoming a data analyst.. I just want a job where I can find work-life balance and avoid overwhelming stress that I'm dealing with in my current job
Do you ever use python for data analysis at work? I ask because I mostly use it for data cleaning and ETL. Coming into the field, I realized it's not used much for analysis at least where I work
Interesting to hear how you are using Python for your job! So I've been in a few roles and only my most recent one did I actually use Python. Mainly I found that I needed to use the same tools that my team was using so that way my work would live on after I left. Not sure if you saw this video but I talk about this more here; th-cam.com/video/Zcy-ND_4ydQ/w-d-xo.html
I manage a data analytics team. Python, SQL, Excel and Power BI are all wonderful tools. Each tool has strengths and weaknesses. Use the right tool to get the job done. Research and learn additional tools and skills based on need to solve business problems.
In terms of investigating the data for quality, how would you suggest going about doing that if you can't extract the data out of the system in your example to investigate large samples of the data? It sounds like it'd be highly manual and require looking at individual rows and columns of data directly within the system.
For this scenario, I could have extracted it in smaller chunks (using the application itself) and then investigated the data further BEFORE even building the bot. Would have had a better sense at how accurate the data was and could have saw early enough that the data was bad.
There is always a way to extract the data. Sometimes it requires working with your IT partners or a vendor. Other times, you may need to learn a new tool and find a creative way to collect it yourself. One step towards becoming a great analyst is moving from the mindset of, 'what data can we access,' to, 'how can we access or acquire the data necessary to solve the business need.'
@@LukeBarousse Agree with data exploration on a sample before pulling en masse for new data sources. Ideally, once you trust a data source, data engineers will develop a pipeline to enable access to the data in an easy to use and reusable format and add it to your data catalog.
What? Uhh... Why not both? Get a job in Data that actually pays well. I'm making it my goal to make lots of money before I hit 35, because by the time I'm 35, I'd already be too bored to live. Edit: What's wrong with asking question? I'm more scared of getting idiots as my superiors since I know I have to ask them questions on what to do and more often than not they'd just say "You're the smart kid, figure it out yourself". My social anxiety can't beat my desire for money. Learning new tools? Well, might as well think of it as a side quest in a video game. I actually prefer working in Excel and SQL since I don't like coding that much. It hurts my brain. (I use Python, never used R before) Negotiation? That is a useful skill, I'll admit. It saved my ass many times. But ultimately, do I wanna be a Data Analyst then? or an Engineer? I honestly just want a good paying job so I can relax a little (school sucks but i need that degree...)
@@LukeBarousse My passion is in making a profit and somehow looking at data tables is fun. Numbers never lie. From a table (easier when visualized), you can see how the numbers tell a story. For example, if you see a sales chart of a toy company, you can see if the toys are something regularly bought or they're nothing but a fad. A fad never lasts, but I would love to learn how to predict how long a trend would go. Easier to maximize profit that way. Unfortunately data gathering/collecting can be a bish. For example, some games are targeted towards the younger audience (Pokemon, for example), and yet most of the people playing it are adults who are living through their nostalgia. Which means, we could take an assumption that people with buying power at this point of time are looking for nostalgia. Which is why I think data with an age groups column can be quite annoying to do. Of course there's some silver linings, such as the targeted audience vs actual audience argument. But in general, the ability to read the market is crucial. With that said, I honestly don't know if I ever will specialize in a subject since I'm someone who's easily bored (but when the money and working time amount are right, I'll fine a way to not be bored despite the same old routine). Hmm, am I dreaming too big? I honestly don't see any hope of getting any good paying Data or anything IT related jobs since people in my country are still pretty ignorant about technology. Which is why I mentioned that my worst nightmare would be being stuck in a dead end job with terrible pay, terrible hours, toxic environment, and stupid superiors. Sometimes I wonder if the HR know what they're looking for instead of just copy-pasting every single IT department skill they could find into the Job Description. . . . . . Did I go too far on my rant?
As a hiring manager, I'm willing to train those who have a natural curiosity and the inclination to proactively explore problems until they find a solution. Finding great ways to learn and grow on your own time demonstrates to me that if I provide you access to training and experienced professionals then you will make the most of it, then apply it to help our organization. Life is 10% what happens to you and 90% the attitude you choose to take. Have a positive attitude, be intentional about learning something new and useful every day, then follow your dreams.
@@benjamincarter6095 Don’t get this the wrong way but that’s what I’ve seen and that doesn’t mean I don’t have a positive attitude or sth. Actually, I’m just pointing out something that happens quite often. As for showing my ability to learn I’ve build a personal portfolio, developed APIs hosted on my github, made POC for data pipelines and know I’m also working a python library related to anomaly detection. The issue with all this is that not all companies are invested in training their employees. I’m telling from experience.
@@analisamelojete1966 You are not wrong about that, and it sounds like you are doing all the right things. Keep applying for positions at good companies, and things will eventually work out. In the meantime, I can understand the frustration. Best of luck!
Love the video. As an accountant, I am not getting the job satisfaction I crave, I see myself loving the IT world. I decided to switch careers, and Data Analyst was the point of interest. So I discussed with a friend and he suggested I enroll for Data Science with Udemy. I became sort of confused (been that I am new in this field). What would be your advice? Cos I desperately need one :)
Hi Luke, I'm actually a finance graduate, worked in a bank and turned photographer, then videographer and also a WordPress developer. Now that I'm 36, is it too late to start as a data analyst?
Heck no it's not! I didn't transition into Data Analytics until my 30's so I think you are just fine. It's all about the value you can provide and not the age of your body.
Never too late man! Don't worry about your age. Career changes at any stage of life are the norm now. It's very common. I'm in my 30s and looking at a few different options myself as I feel it's time for a change. I've a friend (37) who landed just his dream job in UX after years as a chef. It's all about what you can bring to a company, not how many miles are on the clock! Go for it dude!
Hi Luke, I am struggling to determine a future career. I am wondering if you could give me your thoughts on a potential path I might like to go down. Currently, I am working as a lab technician in a biochemistry lab, studying yeast genetics and translational machinery. However, I have always wanted to work with neuroscience and study emotion, cognition and memory. In addition, I have always loved math and wanted to become an engineer but in my undergraduate schooling I decided to go with a biochemistry degree to try and pursue a medical doctorate. Unfortunately, my ambition and drive to continue into medical school fizzled away and I never took the mCAT. So, I am currently thinking of trying to use data science or data analytics inside of a medical institution to try and explore, refine and develop neurological disease therapies or use data science or analytics to engineer therapies or technology to aid in neurological disorders. Do you have any knowledge or experience with data science/analytics in medicine? Do you know anyone with any experience in the medical field? Any help would be greatly appreciated. Thanks!
What you are talking about using data science for here in medicine seems really viable and like an awesome way to use data in this field. I would think there are many opportunities for this, but I don't know of any personally as I don't work in medicine. So sorry for this. I highly recommend checking out linkedin and searching for jobs with some of the keywords you outlined above to see what the potential job market is like for this. If you're passionate about this than i'd pursue it! 🙌🏼
Do most data analyst not work on end to end projects ? I work from everything on python, sql to front end and data pipeline… This is my first job and I am few months into it.
It really depends, at larger companies you get more specific on your roles and work on a piece of the project. Whereas in smaller companies, you typically are working on a full end to end project similar to you.
You are doing the work of a team. Not uncommon, and great experience. Do you have a mentor at work to learn from, or are you applying what you know and teaching yourself new tools and skills as needed to solve new problems? Either way, good for you!
@@benjamincarter6095 Hey, thanks for the positivity. The answer your question, a bit of both. While I can reach out if I get stuck, most of the times I do my best based on my intuition and skillset. I try to have someone look over my work, but in a lot of cases, I am the only one who has worked on it, so others don't have adequate context. It used to get very overwhelming and still sometimes does, but the people are nice so I survive... :)
Data Nerds! What's your biggest issue with working as a data analyst? (or even learning to be one?)
Knowing what skills to develop to stay current.
Getting my organization to make the necessary investments to implement better data solutions. Since they won’t, now it’s building out the skill set to go somewhere that will.
@@HoosierHorn Yeah, me too. Stuck using Google Sheets cause even Excel seems to be too complex to share within organization. Made an education plan for myself, gonna try and learn Power BI to start with and start pushing that withing organization. If nothing, off I go to try and find greener pastures.
For me, definitely getting quality feedback. I work with Marketing & Sales teams a lot, even though there's some Riskmanagement involved there too (iGaming industry) and within my organization we barely have any meetings. So it's basically expected of me to either make really short video presentations or somehow make the Dashboard or Report to be super simple.
Of course, more often than not I either don't get any feedback whatsoever apart from a thumbs-up on Slack or "please make it shorter" --- Without even describing which aspect may have been useful and which one not.
Boss is happy, and basically the only person that will give feedback but.... It's driving me crazy. I find it impossible to improve or get greater insight into problems with this company culture.
@@ivankatalinic2881 When of the pains... and joys... of working for a larger company. Ugh I feel your pain all too well, Ivan!
Data analytics is a great career. It has its a share of downsides, but those can be mitigated by joining the right company/team. One thing I'd like to tell aspiring analysts- be aware of letting the 'analyst mindset' creep in to your personal life. It happens slowly over years.. Soon you will be making spreadsheets and trying to quantify everything. While thinking like that has its benefits, there are many downsides.
Such a very true point, Jonathan! Thanks for sharing this! 🙌🏼
Huh? Everything can be quantified. Everyone has value, some are just higher than other and the numbers would be different from people to people because everyone has their own standards. But what matters is how much you value yourself.
What are the downsides?
@@sunshine1004 IMO, although it’s the nature of it, can at times be extremely tedious. Some companies do not have a great data culture, and it can lead to many hours of work just to be able to begin work on a project. It can be very frustrating to chase down a bug in poorly written code or to discover fundamental flaws in the data preventing you from answering a question.
Wait, I already do that. Does that mean data analytics is my calling, or will this just make things worse?
There’s always a temptation to build something great and beautiful but you need to be prepared that your management often doesn’t need it. Working with data is like an art.
Very much agree!! So much like an Art when it comes to building solutions. Thanks for this Serhii!!
in every software development this is the case
Nothing is more frustrating than coming up with a working solution and management kills the idea.
@@akin242002 So very true!
@@akin242002 Just grab some popcorn and watch as everything crash and burn, then laugh at management's face when the dust settles.
6:18 speaking on the anxiety portion, back in 2018 (when I got my first analyst role) I had extreme anxiety to the point where I was completely uncomfortable talking to people on the phone. However, over the years talking with a bunch of people in different teams it has significantly improved my social anxiety. That's not to say that it's completely gone, but I no longer fear (as much) talking to people these days.
Nowadays in 2022 I manage the data behind our finance team's labor plan so I have to have weekly meetings with finance stakeholders and usually executives 1-2 times per year, so I've gotten much more comfortable.
Zach, thanks for sharing this! It's awesome to hear how you worked on this over the years and tthat you've seen an improvement in being more comfortable with controlling social anxiety! This was motivating to read, so thank you!
This video represents my work haha. I have been through many of those. Rejection wasn’t easy, I must admit. I love the job so the lesson is to continue improving to create better value and to be able to prove it to management in words they understand (and also learning that management can be right about their decisions even if it hurts our pride).
I am believer that the most fundamental skills for a data nerd are social skills and constant learning. As Luke says, we need to communicate to find out what the team and the business needs and we then need to communicate our solution in words that the team and management understand and those usually aren’t the tech words we all know and love.
So very much agree with this, José!! Loved your perspective on this.
Communication skills and learning is such an imperative part of this process and when you can talk in a manner that your teammates understand, success happens! Thanks again!
Isn't any job requires you to provide values to the company? Otherwise you're nothing but a walking and breathing waste of space and oxygen that is asking for the pink slip.
Data Analyst is like being an artist with one key difference. As a data analyst, non data people don't care about your work, but you make a good living. As an artist, people admire artwork as magic and talent, but its hard to make a living
Interesting perspective!
If you can find a business partner who fully buys in to becoming data driven, with your assistance their area will outperform and the cause will be noticable. This tends to make other business partners request your assistance. Focus on what you can measure that they have the power to improve.
Yea I'm lucky to work for a data driven company where my work is valued. I was more so referring to the general public . I make art too and all my friends and fam love seeing and talking about my art , but get nausea when I bring up my enthusiasm for data lol
As an aspiring data analyst with every odd stacked against him, I appreciate this video very much. I'm still not deterred from my mission 🙏 Good shit Bro
As someone who has been a data analyst at a corporation for almost a decade, I feel you hit the nail on the head with most of this video. Nice work giving people insight into the job!
Thanks so much for this!! Hopefully we can convince more people to become data analysts! 🙌🏼
Haha the intro is so hilarious! Very well done! 👍Actually Ken is a very nice boss who even told you what you were getting into LOL. Definitely relate to all the points you mentioned, Luke. I'd like to add one more point here from my experience that a lot of time in my life has been dedicated to waiting for data to run as well haha.. just a reality of working in big data projects.
Hey Thu Vu!! 👋🏼 Love your channel!!
Agree on Ken being a very nice boss, I'm actually very much lucky to have him! Or at least he tells me that.. 🤣 jk
Also great point on the running data pipelines!! So true!
@@LukeBarousse Hey Luke, thanks for checking out my channel! I'm so glad you liked it 😄. Agreed, I can imagine you two would work together very well haha. Ken definitely reminds me of one of those smart and perfect colleagues at my work 🤓
Haha I feel that too much. The most difficult part I've encountered is changing metrics. I spent two months just gathering requirements, literally no building, because they kept changing what they wanted.
Ugh, I can unfortunately relate all to well with your pain, Jordan! But that's what keeps this job interesting!
An honest look at being a DA. I know the intro was in good jest, but it was always painfully accurate too haha. Surprised to see that I came in at the upper end of DA salary on my first job in the field. But Luke isn't lying, I have to show up and fight for my job every day, and provide value. I also think your bit on Python is true, as much as I would love to learn it right now, for the first three years or so, I need to focus purely on the tools I use every day: Tableau, Excel, and a little SQL. This was the honest hard truth some needed to hear.
Ken may have made the interview feel a little 'too real'. 😂🤣
And thanks for sharing this perspective, Travis!! Glad you can confirm the Python portion and that I'm not alone on this claim. I am a little worried about the backlash from the python and r lovers tho... 😂
@@LukeBarousse some had to say it :) Don't shoot the messenger
@@TravisTraps 🤣🙌🏼
Three years may be a stretch. It should take a couple of weeks to learn to write SQL queries reasonably well, same for the basics of a BI tool. Excel takes a few months. For all tools, your proficiency will continue to increase the more use cases you apply them to. I tend to push new analysts fresh from academia to start learning Python after 3-6 months, and support them taking time each week to learn and practice. Data Camp is a great introduction, and you can start learning for free. I like that it has hands on coding examples that you can actually run to see the results. Only a browser is required, not a python install. Start by learning the Pandas library. It is like a mix of SQL and Excel, and many other packages work well with dataframes. Best of luck!
@@benjamincarter6095 I appreciate the dialogue and challenging me to push my timeline forward. I'll accelerate my path a bit: I should be able to come better than proficient in Tableau / Excel / SQL within this calendar year. I appreciate the tips on Python too, and like your roadmap on skills/python/timeline too, thank you for helping
Wow, I was rewatching this and trying to see how I can improve my content and I realized that you included me! Thank you so much
🤣😂 haha! Just added a card in this video for your video! 🙌🏼
I totally relate to this! Thru the course of time, I developed the skill to create a story and nonstop patience in observation to backup my claims to make sure my proposed solution will be used. Not to mention the empathy, making sure we are connected to our stakeholders emotionally for them to fully trust your work because they know that you understood their challenges. Most importantly, make sure that if our stakeholders find it hard to understand what you are saying, we need to level down our vocabulary to a level that they would comprehend so it would make sense. Happy analyzing folks! This is a great content!
Thanks for sharing this!
Hi Luke, another fine video. Excellent perspective. I can't wait to start my career as a data analyst. I mean really Luke, it's all so immensely fascinating. Thanks again man for posting such good content.
Heck yeah!! So glad you enjoyed this one John! Good luck in your journey!! 🙌🏼
Hi Luke, I also like that you have a sense of humour. Everyone knows that data is serious stuff. But you find a way to not take yourself super serious. And when you are serious, we get that. Keep on man. It's very helpful.
Currently I am almost midway to my Data Analytics course. Watching this video confirmed some of the things I am anticipating to encounter when I finally start working. And no I'm not discourage. And I seemed to look forward to it.
As always, great video Luke! Thank you!!!
In regard to "what tool we are working with or learning" poll. Programming has the highest score probably because it's the hardest among other tools to learn and thus has the highest priority. Anyways, thanks for another great video as always!
Thank you four your insights!! I'm working as an economist at an university, but I'm considering more and more (for many different reasons) to change my career path towards data science
No problem at all! Glad I could provide a view into this field for you!
That's cool, I've always been interested into economy. Even thought about changing my career path towards economy.
There are two famous latin american economists called Axel Kaiser and Javier Milei. I think they are good exponents of latin american economic thought and are making the youth interested in economy.
@@mamneo2 Thanks for sharing this!
Economists are very welcome in data science, because they are known to be good with statistics
@@pro-on6wq Thanks for sharing this!! This is great to know
Thank you Luke! I very much enjoy the seemingly doomy videos like these, as they show me the real and sometimes painful aspects of the job. Although you list some discouraging things on this list, I feel like it makes me even more motivated to make the most out of it and pursue my dreams!
thanks so much for this!! as someone who is looking to make a career swap this was super insightful and even encouraging! made me realize what I value in a career and data analysis is looking really great right now!
Great video! I agree with basically everything here. I’ve found that if you know SQL then that can be an easy why to up your initial salary a bit.
As far as stakeholders having strong opinions on which charts you should use (looking at you finance people 😅), I generally create the exact dashboard the stakeholder asks for and then add my ideas. When I present the dashboard, I start off with what they asked for, make they’re they’re satisfied with that, then say something like “I put something together last night that I think might help” and show them the extras. Sometimes it works sometimes it doesn’t haha
Shashank!! My dude! Thanks for checking this video out!
Also, I very much like your perspective on how you deliver a dashboard: 1) you give them what they want and 2) you provide them with a little something extra 😉. This is definitely a more viable approach for delivering your solutions 🙌🏼
If anybody wants another perspective on becoming a data analyst check out Shashank's video on it:
th-cam.com/video/-AbAm4t4FYQ/w-d-xo.html
Great video. I'm starting to learn SQL and I see a number of options: T-SQL, MySQL, PostgreSQL etc what are the differences and which will you recommend I learn?
Tsql is only used with Microsoft SQL.
MySQL and Postgre, are more widely used and have lots of integrations and tools.
PostgreSQL has more options for large databases, some similar to Oracle SQL, without the licensing and old software garbage.
I would recommend getting a course with Postgre and test building a few projects with it, then comparing it to MySQL.
The next step would probably be mongodb (nosql) or influx (time series)
In my opinion, it does not matter which System you are learning on. The basic commands are always very similar. I like prostgres but i learned SQL on sqlite and Microsoft SQL. The gap is not that big and IT should not prevent you from start learning. Good luck
Hey Nathan, It looks like there are great answers above from @username & @Peter_Silie. I agree with the fact that it doesn't matter as much about the database management system you pick (Microsoft SQL, MySQL, POstgreSQL), but instead it matters more that you know how to write SQL syntax (which is basically the same in all these different database management systems).
I would focus on learning SQL syntax. From there pick a common database management system and start building!
@@LukeBarousse Thanks for your response and others. I am also in the same situation. Learning PostgreSQL and wondering if my learning is comprehensive.
Now I understand better. Thanks👍
@@aimenyaugba6892 Heck yeah! Glad we could help here in the comments!!
Reinforcing the minds and the reality. Thank you. It was soothing to hear. I did want to avoid the problems you mention as an mfg engineer but it's good to learn that I will encounter them in every job and that it's ok. Dont get frustrated there will be better days.
There will always be better days!! Very much agree with this!! 🙌🏼
The intro gave me anxiety. Haha! Great video, there's some really good insight here and some valuable takeaway of the commitment needed to be a data analyst.
Oh hech yeah!! And sorry the interview gave you anxiety, I promise it isn't that bad! 🤣 That Ken Jee!!
I find a lot of what may deter someone is actually positive and can strengthen a person's character instead. It's part of the reason why I'm pursuing a data analyst role and teaching myself technical skills right now. However, I am curious about maintaining a healthy work-life balance or just not getting too burnt out. I would love your input on this. I'm like you where job satisfaction is very important, and I actually was planning on just using this career to build up my actual passion on the side. Basically having a fair income while trying to not be a literal starving artist lol
Yeah, I feel your pain, I struggle with this healthy work-life balance and not being burnt out as well. Unfortunately, I don't have a winning answer to this and instead, this is a struggle that many of us are trying to figure out.
Company culture is everything when it comes to work life balance. Remember that you are interviewing the company as much as they are interviewing you. Ask questions about the culture and work life balance. If you meet individual contributors at the company, ask what their average workday is like and what they enjoy most about their job and their company. If possible, either before or after the interview, talk to a person in the lowest level position your can identify and approach. How a company treats easily replaceable employees, and what those employees think of their company,speaks volumes to the quality of the culture.
Really interesting video. I’m trying to change careers at 41 and think that data analyst is a likely entry level position to get my foot in the door with.
I think it's a great choice as well, I transitioned in my 30's so I think it's viable at any age!
@@LukeBarousse hey Luke... How did was your experience when you transitioned? You must have had a lot of experience in some other tech and becoming sort of a fresher again and competing to those younger professionals who has already been working in that field, how did you manage that? Did you ever have doubts that all those years of experience would go to waste and did starting something new at that point of career by leaving a path where you are already well settled gave you anxiety or self doubts?
@@ABHITECHNOCRAT - Luke has got quite a few other videos that cover some i that. I’d recommend a look there.
@@ABHITECHNOCRAT Yeah I actually made a video on it: th-cam.com/video/3Ao2FV1r5-8/w-d-xo.html
But to answer your question more specifically, I had A TON of doubts of starting in this career. Mainly I had spent 7 years of my life in another unrelated career and was afraid it would go to waste. BUT I figured out how to take advantage of this experience instead and apply it in my new role. Hope this helps shed some light on this!
@@LukeBarousse I'm a new subscriber and haven't noticed this video. Thank you for linking it! I'm an introvert as well and in my 30s trying to transition to data, so it was very motivating!
I’m really considering becoming a data analyst, as maths and calculations were never my strength. I have a degree in psychology and main transferable skills was statistics, but when I hear people from economics and computer background commenting I feel so intimidated 😅
Your videos have so much value that every time I watch them, I get one thing to study in order to make better decisions in my daily work with data. Thanks, @Luke.
Heck yeah! Thanks for the kind words Tito!
While Microsoft Excel might be the most demanded skill for data analysts. from the perspective of users of the data analysis that is, it creates a nightmare in terms of "one source of truth." Each person can modify the Microsoft Excel spreadsheet or workbook. Eventually, nobody can agree on the outcomes produced by the various modified versions , each held by a single individual. An interactive dashboard, with clearly defined functionality and restricted ways to "tamper with the outcome," in my opinion, is a superior way to let users "play" with the data.
Very much agree with your pains! I've experienced such similar issues in my job, it can be soooo frustrating.
I actually made a whole video on this topic: th-cam.com/video/3TBwY4VjLX8/w-d-xo.html
Strongly recommend that all analysts don't rely on excel for this reason, and use jupyter notebooks instead. They are deterministic/reproducible, and can be checked in to version control.
@@Jaybearno Yeah I can very much agree with this. Unfortunately, sometimes we have to use the same tools that our teammates use. #Excel 😭
Excel should not be the primary source for any key data. If there are any data silos, integration should occur using appropriate tools. Work to develop the data maturity of your company, including data governance appropriate for your size and complexity.
@@benjamincarter6095 fortunately I am not an employee of any company so their disasters are on them. I can only offer fact-based advice; any client is free to ignore it at their peril.
As to Microsoft Excel, my comment was focused on end-users adding formulae and/or calculation cells (row-wise or column-wise), and playing "what-if" games with the data which was intended to be static...that is, no connection back to the data source(s). Dashboards can and should directly connect to the source data albeit non-operational, non-line-of-business databases, APIs, etc. that could adversely impact the production environment.
Don't expect to start by showing something new that will revolutionise the company. Expect to show management what they already know, but give them a little understanding why. Then after years of doing that, they will trust you enough to show them something new.
Also its ok that some projects don't go anywhere. It's great to confirm that the company is sailing the right course and no action is required opposed to costly knee jerk reactions.
I liked these insights, Daniel! Very much agree about with your first statement and like how you use Buy-in to get management to adapt to your ideas. Thankks for this!
You have to walk before you run. Depends on the level of data literacy and maturity of the company as to what they will expect and accept. Trust is paramount, never let it slip.
@@benjamincarter6095 I can really appreciate this!
Your content creation skills is also amazing , i subed directly , good luck
I want to emphasize something that was not said in the video.
Domain Knowledge.
I was a Mechanical Engineering in manufacturing that switched to data analyst in health insurance. It was one of the most stressful job since I had to learn about the entire healthcare industry and its process. My supervisor told me that the analyst should be the smartest person in the room with the ability to answer all the questions management throws at you. I know that everyone's experience is different but im just saying what my transition was like. I switched to being a data engineer in manufacturing and never been more happier.
Thanks for sharing this point on Domain Knowledge. Very much agree that this is a very needed skill for data analysts!
As introvert to introvert i'm absolutely agree with you, so thank you for sharing and confirming my thoughts.☺
🙌🏼
Great video and great insights! Actually this video makes me want to start pursuing a career in data even more.
Aw thanks! And that may have been my ulterior motive 😈
Ahaha yeah, those insights actually gave us some kind of guideline on how to prepare for a career start in data analytics. Thanks!
I strongly agree on the part about "A job may have different tools than the ones you prefer or have experience using".
I trained for Excel, MySQL, Python, and GCP. Now I may need to know Azure and Java for work. Not a big fan of Azure as IAAS, but the job requires it.
Yep, all comes down to what the job demands! Thanks for sharing your experience with this, very helpful for others to understand!
Love ur job, always keep on learning, improving and analyzing ur work (any work) with INTEGRITY and every job will be fun
Heck yeah it will!! Thanks for sharing this 🙌🏼
Well said
I keep getting ads before these videos from my statistics professor. Weird
Unfortunately salary is more important than job satisfaction. Thinking like that means you are probably making more than the average salary in your area. Living in Miami the average salary is 50k but entry level analyst are making over 60k; I feel that if you are making over the average salary you are on good living conditions.
Thank you for sharing the info
No problem at all!! 🙌🏼
thank you Luke ,i am a graduate data analyst with Coursera , what's your recommendation for the next courses i need to prepare myself . Big fan of yours Cheers.
Aww thanks so much for this! Have you seen this video on courses I recommended:
th-cam.com/video/aqRxZSrJLEc/w-d-xo.html
Thanks so much for the content guys.
So, you telling me that you could have been doing a great job and show something new but still get rejected by your bosses. In that case, what is true success for you(and all) as DA? What are you looking for to end your day and feel like "i did a great job today/this week/this month"?
thank you this was really informative. im doing the google analytics career certificate right now.
I actually got to practice some python at work this week, nothing has come of it yet but it satisfied my itch of starting to solve a particular problem
Awesome! Gotta start somewhere and the fact that you took the effort to start in the first place is the hardest part. Keep it up! 🙌🏼
Wakeup criteria: New video from Luke and Mister Ken!
😂 Glad you tuned in Al!! We're gonna have to all do a skit at some point! 🙌🏼
@@LukeBarousse you know I'm always camera ready...
great video! some valid points! thanks for sharing
Glad it was helpful!
I guess I must be the exception. I just landed my first data analyst position. There were two rounds of interviews and in both I had to complete technical tasks in Python.
Interesting, thanks for sharing this! I do think that Python is a popular tool for Data Analysts, but yeah from my research it appears that SQL and Excel are more popular. Either way... YOU GOT THE JOB!! Congrats my dude!!
@@LukeBarousse Thank you!! And thanks for the video, it made me even more excited about this new role!
Congrats! Best of luck!
Great approach for the reality, thanks a lot for sharing!
Heck yeah! Glad you tuned in!! 🙌🏼
Very good video and advice, thank you.
I observe that a person needs to be heavy into mathematics inside of calculus and understand how to apply those skills into Excel/SQL/maybe Python as a gift from god once you reach that level -- not to mention investigative skills that drive you to dig in and find "things" bad/good, and become a gambler do the distance and then test your full blown skill sets at the Tables!
Great video; more valuable because of its close links with the applied fields of the company management.
Thanks for this, I didn't even thinking about how it links to these aspects.
Could you make a video comparing data analyst with business analytics? Most universities have programs like MS in Business analytics but the curriculum is pretty much that of a data analyst.
Let me see what I can do about this as I think this is a very important topic! Thanks for sharing this!
I am currently doing an MSc in business analytics and applying for graduate data analyst roles. From what we've learnt, it's exactly what the data analyst role asks for
@@fergusoh5092 which university are you enrolled in?
@@rudroroy1054 I don't want to say exactly for privacy reasons but it's a top 10 uni in UK on complete university ranking
The job descriptions are synonymous. Business analyst may imply a focus on a specific business function (department) rather than an organizational focus. Always ask about the scope of the position early if it is not clear from reading the JD.
Both of you guys are my biggest inspirations man.
Thanks you my dude!!
The cinematography...next level
TBH I spent a little bit too much time editing... and not enough time building dashboards... probably why I encountered all these issues in the video 🤣
@@LukeBarousse Maybe it's time to go the way of Joma. Build the Luke Cinematic Universe
@@SeattleDataGuy 😜🤫
TBF Luke. The stakeholders issue happens well, everywhere. Sometimes less is better, especially in my line of work.
Yep, agree! 🙌🏼 very common issue and all comes back to those communication skills.
What I get from this video is, whatever the world portrayed data analyst as a cool job, it's actually the same as the other job. Keep
humble is the key to strive and survive from the pressure.
Boom! 🙌🏼 Very much agree!!
I haven't being in that ground yet. But I learn to demystifying data jobs from now, so I don't put my expectation too high and become sour if it is not as I expected.
If you get stuck at a company where your job is not what you think it should be, first try to enact the change you want to see. This may take years, but if you see signs that change is possible and at least some areas are receptive to your efforts then this path can lead to a very rewarding experience and career. If you spend a year of being intentional in your efforts to lead change and all you experience is roadblocks, then there is a cultural issue that will be very challenging to overcome. In this case, develop your personal network and consider looking for another position with a new company. Share your efforts to lead change during your interview. A great data and analytics manager will appreciate your proactive approach, and may even commiserate since they likely have similar experiences.
@@benjamincarter6095 Well said Benjamin!! 🙌🏼
This video is very, veeeery good. Congrats man !
Heck yeah, thanks Fernando!!
Interesting - im considering switching from psychology to data analysis. in psychology i got comfy with R and we got a nice overview of statistical approaches for testing distributions, compare group, data prediction with regressions and principal component analysis. What i actually would like to do is: use my psych background to gather insights based upon already proven scientific concepts, but im a bit afraid that as a data analyst actually i would maybe even work below some mba or psychogy-person who then just gives me the task while all my conceptual knowledge in the field wouldnt count much and i maybe would even earn less? (i guess the manager of the data scientist earns more?)
Hey Predro! 👋🏼 It sounds like you want to provide data analytics in a psych-type role. Which I think you can totally do. Data analytics (and data science in general) is needed in so many fields to start digging into the data and gain insights. I wouldn't focus too much on finding a role titled "Data Analyst". What you are looking for may not always be called that so I would more look for Psych-roles that match your interest in data analytics.
Regarding whether you'll be working below somebody is really up to what job you choose. I think in your case you just need to be creative in looking for these types of jobs and opportunities and making sure that the job itself relates to your background.
Want a job? I need someone familiar with behavioral psychology, statistics and some basic coding experience. Working on projects to improve our understanding of customer preferences and life journeys, with the goal of personalizing user experiences and predicting major life events. Training and access to a seasoned team will catch you up on any areas you feel deficient. Always interested in recruiting new talent with a wide array of skills and experiences! Let me know if you are interested and we'll figure out a way to talk.
Great video :) It totally does not feel that you are an introvert, though! Probably your work on your communicating skills pays off :)
Aw thanks for this Joanna! Ha, if you met me in real life you would notice immediately that i'm an introvert 🤣 but yes! def have been working on my communication skills.
Hey Luke, I'm now to your channel. I'm currently preparing my exam for database fundamentals. Does data analyst also use EER schematic's. Also learning SQL is really fun! :)
They could when exploring databases, but only just the basics. Other than that I don't have much interaction with these shematics.
bro, its great that you can choose a job based off passions but most people get jobs for the money, so yeah im gonna become whatever employee that gets paid well cause the money i make will satisfy me by not being poor. Passions come outside of work hours.
Grate content. Thanx Luke 🙂
Thanks so much for this! 🙌🏼
So true. Great video and information
Thanks for this, Noah!!
$43-67k? Is it really that low? I thought it was at least $75k starting these days
Google is averaging at around $67 from their research and this data was taken from another reputable site as well.
Granted this is "entry-level"
Thank you for the lesson. I'm curious: do you stand up in front of your computer during your working day??
It feel how important this video is
Wow!
Thank you!
Aww thank you so much for this! Glad you thought it was important!
Another great video, I'm learning so much from these and from the comments section too, thank you.
I wanted to ask if there are particular resources/courses or platforms that folks would recommend for excel in particular? I know I could learn it from a number of places, but I'm wondering if there are any courses or resources that have stood out to folks? Cheers.
So as I go down the Luke Barousse rabbit hole I discovered an answer to my question! th-cam.com/video/aqRxZSrJLEc/w-d-xo.html Thanks Luke!
Heck yeah!! Just the video I was gonna share. (Hahah love this “luke Barousse rabbit hole” 😂)
Becoming a Data Analyst involves physical pain? Yes, it's true, if you torture the data long enough you can make it confess to anything.
Very true, Robert 🤣
I am planning to do my Masters in Business Analytics in the US to get into the field of Data analytics/science. I want to ensure that I get a great job at a decent firm in the US. I will be starting my master's in Fall 22. What do you suggest I do or divert my focus to for a better chance of landing jobs once I'm in my master's degree? I have experience as a data analyst for 3 years.
I'd start with building up your portfolio and also your online presence in the data analytics community. It's great to have a degree, but can showcase experience to an employer (through a portfolio) I found that you can have the most success!
I like data analysis, but mostly for personal use. I feel like it’s a passion of mine, but if I take on a full time corporate job where I have to solve problems I’m not interested in, I feel like it will ruin it for me. I think I just don’t like the corporate setting, corporate politics. I might go the upwork route for its flexibility and options. What do you think about this?
Free lancing is def a popular option for this as well, so yeah I think this is a viable option if you have a fear of ruining your passion.
Thanks for the perspective
No problem, Xavier!! 🙌🏼
This video was amazing don't ever stop sharing your amazing
Aw thanks for this Warren!!
Very well-put-together video.
Thanks for this LeRoy!!
Great video😍, where can I practice the skills I learned on real data?
Aww thanks so much for this!!
It really depends on what tool you want to dive into! I recommend using the Google Data Analytics certificate to find out what your interest is in and then using a tool to dive in to practice skills on the data.
Data Camp is a great starting point for free. From there, many free resources exist for data sets of various sizes which you can download and use to continue learning. Ideally, if you have the resources and the patience to follow step by step instructions, setup a SQL server. Then dump multiple tables from a few source into tables in a data base. Explore this data with various tools, including SQL, Excel, Python, R, Power BI and Tableau. Get a sense of which tool works best for different use cases. I wish colleges had this environment available to all students, with use cases loaded into databases related to various subjects. You can use this setup to continue to learn and experiment even after you have a job.
he says a month of his life was wasted 6:00 because the project was rejected. He still gets paid for his work though right?
Helping others: receiving a phone call at 5pm to quickly join a meeting, mid way with no context, to explain what a median average is.
🤣yup... gotta love our job sometimes
since you mentioned the influence of an individual on entry level job I, i guess like in most cases,any job ..you wouldn't get to have much of opinion or influence mostly it's you do the job and learn more to develop certain skill set to go further , so yeah that doesn't apply on data analyst only anyway xD thanks for sharing your insights
Thanks Sam!
Hey Luke, I am pretty like your style in general. You turn the Data Analyst job to be an interesting topic! How you learn those editing skill? Udemy?
Thanks so much for this... and actually learned most by skills from TH-cam, just like data analytics there are a lot of great resources out there!
Luke Thanks for the information; I will not pursue to be Data Analyst as I planned; I will stick with being a genitor - much better...
Glad this could help with your decision!! 🙌🏼
My favorite is, "Other duties as assigned"....
Mr. Ken likes his work finished on-time and/or ahead of schedule... so I gotta focus on getting those duties done!
I hate work as data analyst, but I really like job as data engineer.
I hate being constantly with stakeholders in useless meetings... Am introvert, I feel totally drained after those meetings
I share your pain with pointless meetings.
Same here, i am a stammerer , constant communication would be very hard for me . But is they any way we can a be a data engineer without first being a data analyst?
@@succeeder3044 sure, the role is not the same. Data analysts work with data that data engineers create.
@@ejmsp thanks for your response. Please can i get your email to private chat you? I want to go into the data engineer field, i need some guidance.
@@succeeder3044 i can't share my personal emails here, but if you want, share yours, i'll reach you out
I have a BA in Psychology. So I was wondering if Data Science could be a nice Career change and also something that could add to my existing skills. Any body have any comments about it?
I’m coming to this channel from an entry level developer (mern stack) perspective. Just trying to use coding somehow in a job.
I think it’s possible to use your coding skills in this type of job, if you’re interested in data analytics.
@Luke Barousse, tnx for the video. What Coursera course would you recommend someone starting from zero? Like just basic Excel understanding.. Thanks in advance!
I would recommend the Google certificate for those just starting to wanting to enter this field of data analytics
Sounds awesome. My work offers in house training for Data Analytics. Figure do that and then get a computer science degree later to get the big bucks.
I like the idea of taking advantage of the in-house training. It will help you figure out if you like this field!
Sounds like you work at a great company, or at least one devoted to improving data maturity. Congrats! You will get out of the training what you put into it. Look for opportunities to apply what you learn early and often. Early on, share your work with someone in analytics and ask them to review it and offer suggestions for improvement. This will help you build confidence and take your learning to the next level while also gaining exposure to experts who are obviously interested in identifying internal talent. It will also ensure your analysis is reviewed and reduce the likelihood of errors in your finished product. Best of luck!
To be fair, a lot of the problems you mentioned are shared across most jobs.
Yep I can see that
I totally agree, Me as a project manager is making only 2000USD monthly in Dubai and facing more problem than the video displayed
Agreed, Excel is much more repeatable if you want to run it on the average pc without all the fancy tools!
Heck yeah! 🙌🏼
Great explanation, thank you....
IMO you should not use music as a background, even if it low volume, because it's a bit disturb my concentration....
I don't know about other, but I need extra focus in listening people who speak English, maybe because its not my mother tounge, idk....
Anyway it's a great video, thanks a lot for the explanation 👍🏻
Thanks for sharing this! I agree with what you are saying so let me see what I can do for future videos. I do like to have some music (and I did spend extra time in this video trying to put it low enough... but apparently that wasn't enough 🤣)
Thanks for watching!
I'm just confused between doing the CompTIA trifecta and going for IT support or becoming a data analyst.. I just want a job where I can find work-life balance and avoid overwhelming stress that I'm dealing with in my current job
Great Video Luke sir
Aww thanks so much for this Kuntal!! 🙌🏼
Great video!
Glad you enjoyed it Aimenya!!
Do you ever use python for data analysis at work? I ask because I mostly use it for data cleaning and ETL. Coming into the field, I realized it's not used much for analysis at least where I work
Interesting to hear how you are using Python for your job!
So I've been in a few roles and only my most recent one did I actually use Python. Mainly I found that I needed to use the same tools that my team was using so that way my work would live on after I left.
Not sure if you saw this video but I talk about this more here; th-cam.com/video/Zcy-ND_4ydQ/w-d-xo.html
I manage a data analytics team. Python, SQL, Excel and Power BI are all wonderful tools. Each tool has strengths and weaknesses. Use the right tool to get the job done. Research and learn additional tools and skills based on need to solve business problems.
Off topic...what are your thoughts on the EdX Harvard Professional Certificate in Data Science? Love your insight and your videos - Cheers!
I've only briefly checked it out and it seems like a good option. For data analysts though, my top recommendation is still the Google Certificate.
In terms of investigating the data for quality, how would you suggest going about doing that if you can't extract the data out of the system in your example to investigate large samples of the data? It sounds like it'd be highly manual and require looking at individual rows and columns of data directly within the system.
For this scenario, I could have extracted it in smaller chunks (using the application itself) and then investigated the data further BEFORE even building the bot. Would have had a better sense at how accurate the data was and could have saw early enough that the data was bad.
@@LukeBarousse Makes sense, thanks for the reply!
@@LukeBarousse So you have to build bots also?
There is always a way to extract the data. Sometimes it requires working with your IT partners or a vendor. Other times, you may need to learn a new tool and find a creative way to collect it yourself. One step towards becoming a great analyst is moving from the mindset of, 'what data can we access,' to, 'how can we access or acquire the data necessary to solve the business need.'
@@LukeBarousse Agree with data exploration on a sample before pulling en masse for new data sources. Ideally, once you trust a data source, data engineers will develop a pipeline to enable access to the data in an easy to use and reusable format and add it to your data catalog.
What? Uhh... Why not both? Get a job in Data that actually pays well. I'm making it my goal to make lots of money before I hit 35, because by the time I'm 35, I'd already be too bored to live.
Edit:
What's wrong with asking question? I'm more scared of getting idiots as my superiors since I know I have to ask them questions on what to do and more often than not they'd just say "You're the smart kid, figure it out yourself". My social anxiety can't beat my desire for money.
Learning new tools? Well, might as well think of it as a side quest in a video game.
I actually prefer working in Excel and SQL since I don't like coding that much. It hurts my brain. (I use Python, never used R before)
Negotiation? That is a useful skill, I'll admit. It saved my ass many times.
But ultimately, do I wanna be a Data Analyst then? or an Engineer? I honestly just want a good paying job so I can relax a little (school sucks but i need that degree...)
There are def high paying job options in Data, so I think you'll be in luck. My main point was just to not do it for the money but for the passion.
@@LukeBarousse My passion is in making a profit and somehow looking at data tables is fun.
Numbers never lie. From a table (easier when visualized), you can see how the numbers tell a story.
For example, if you see a sales chart of a toy company, you can see if the toys are something regularly bought or they're nothing but a fad. A fad never lasts, but I would love to learn how to predict how long a trend would go. Easier to maximize profit that way. Unfortunately data gathering/collecting can be a bish. For example, some games are targeted towards the younger audience (Pokemon, for example), and yet most of the people playing it are adults who are living through their nostalgia.
Which means, we could take an assumption that people with buying power at this point of time are looking for nostalgia.
Which is why I think data with an age groups column can be quite annoying to do.
Of course there's some silver linings, such as the targeted audience vs actual audience argument.
But in general, the ability to read the market is crucial.
With that said, I honestly don't know if I ever will specialize in a subject since I'm someone who's easily bored (but when the money and working time amount are right, I'll fine a way to not be bored despite the same old routine).
Hmm, am I dreaming too big? I honestly don't see any hope of getting any good paying Data or anything IT related jobs since people in my country are still pretty ignorant about technology.
Which is why I mentioned that my worst nightmare would be being stuck in a dead end job with terrible pay, terrible hours, toxic environment, and stupid superiors.
Sometimes I wonder if the HR know what they're looking for instead of just copy-pasting every single IT department skill they could find into the Job Description.
.
.
.
.
.
Did I go too far on my rant?
Biggest issue is not getting hired by a company because they’re unwilling to provide some training.
Yeah I can very much appreciate this. Companies need to also be willing to invest in training.
As a hiring manager, I'm willing to train those who have a natural curiosity and the inclination to proactively explore problems until they find a solution. Finding great ways to learn and grow on your own time demonstrates to me that if I provide you access to training and experienced professionals then you will make the most of it, then apply it to help our organization. Life is 10% what happens to you and 90% the attitude you choose to take. Have a positive attitude, be intentional about learning something new and useful every day, then follow your dreams.
@@benjamincarter6095 Don’t get this the wrong way but that’s what I’ve seen and that doesn’t mean I don’t have a positive attitude or sth. Actually, I’m just pointing out something that happens quite often.
As for showing my ability to learn I’ve build a personal portfolio, developed APIs hosted on my github, made POC for data pipelines and know I’m also working a python library related to anomaly detection.
The issue with all this is that not all companies are invested in training their employees. I’m telling from experience.
@@analisamelojete1966 You are not wrong about that, and it sounds like you are doing all the right things. Keep applying for positions at good companies, and things will eventually work out. In the meantime, I can understand the frustration. Best of luck!
@@benjamincarter6095 Yup, thank U so much!
Love the video. As an accountant, I am not getting the job satisfaction I crave, I see myself loving the IT world. I decided to switch careers, and Data Analyst was the point of interest. So I discussed with a friend and he suggested I enroll for Data Science with Udemy. I became sort of confused (been that I am new in this field). What would be your advice? Cos I desperately need one :)
I would say start with a project and judge if you have a passion for this field. You won't really know if you like it until you try it.
Hi Luke, I'm actually a finance graduate, worked in a bank and turned photographer, then videographer and also a WordPress developer. Now that I'm 36, is it too late to start as a data analyst?
Heck no it's not! I didn't transition into Data Analytics until my 30's so I think you are just fine. It's all about the value you can provide and not the age of your body.
@@LukeBarousse Thank you so much Luke, this answer simply exceeded my expectations, it's all about value
Never too late man! Don't worry about your age. Career changes at any stage of life are the norm now. It's very common. I'm in my 30s and looking at a few different options myself as I feel it's time for a change. I've a friend (37) who landed just his dream job in UX after years as a chef. It's all about what you can bring to a company, not how many miles are on the clock! Go for it dude!
@@RC-fi8nn Love this positive motivation! 🙌🏼
@@LukeBarousse thanks man! :)
Hi Luke,
I am struggling to determine a future career. I am wondering if you could give me your thoughts on a potential path I might like to go down.
Currently, I am working as a lab technician in a biochemistry lab, studying yeast genetics and translational machinery. However, I have always wanted to work with neuroscience and study emotion, cognition and memory.
In addition, I have always loved math and wanted to become an engineer but in my undergraduate schooling I decided to go with a biochemistry degree to try and pursue a medical doctorate. Unfortunately, my ambition and drive to continue into medical school fizzled away and I never took the mCAT.
So, I am currently thinking of trying to use data science or data analytics inside of a medical institution to try and explore, refine and develop neurological disease therapies or use data science or analytics to engineer therapies or technology to aid in neurological disorders.
Do you have any knowledge or experience with data science/analytics in medicine? Do you know anyone with any experience in the medical field? Any help would be greatly appreciated.
Thanks!
What you are talking about using data science for here in medicine seems really viable and like an awesome way to use data in this field. I would think there are many opportunities for this, but I don't know of any personally as I don't work in medicine. So sorry for this.
I highly recommend checking out linkedin and searching for jobs with some of the keywords you outlined above to see what the potential job market is like for this.
If you're passionate about this than i'd pursue it! 🙌🏼
Do most data analyst not work on end to end projects ? I work from everything on python, sql to front end and data pipeline…
This is my first job and I am few months into it.
It really depends, at larger companies you get more specific on your roles and work on a piece of the project. Whereas in smaller companies, you typically are working on a full end to end project similar to you.
You are doing the work of a team. Not uncommon, and great experience. Do you have a mentor at work to learn from, or are you applying what you know and teaching yourself new tools and skills as needed to solve new problems? Either way, good for you!
@@benjamincarter6095 Hey, thanks for the positivity. The answer your question, a bit of both. While I can reach out if I get stuck, most of the times I do my best based on my intuition and skillset. I try to have someone look over my work, but in a lot of cases, I am the only one who has worked on it, so others don't have adequate context. It used to get very overwhelming and still sometimes does, but the people are nice so I survive... :)
Hey Luke, you'd make a good actor man.