What I love about it is my degree is in Criminology I had to take statistics a class and have used excel countless times in both college and in other jobs. And yet, they wanna hit me with some BS about I need a certificate ? They can kiss my ass, if I trained myself in graphic design- I know I can do this!
Hey I’ve got some really great news to share with you, Jesus Christ, the Son of God, died on a cross and resurrected on the third day so you may all have eternal life. If you believe and repent of your sins and put your faith and trust in Him as you would a parachute jumping off a plane at 25000 feet up in the air, He will give you eternal life in heaven as a free gift and I promise you, He will change your life forever as He did mine. He is the ONLY way to heaven and He loves you all. Please think deeply about this with urgency because this is your eternal life and soul, you don’t know when you could die, meaning you could die at any moment, so please consider this with all your heart. If anyone tells you that Jesus isn’t the only way, they are lying to you and they don’t care about your future.
Ive been an analyst for over a decade. I mostly use Excel because VBA is a thing. And, since its all part of the Microsoft Office suite, you can make Excel VBA pull and clean your data, build a PowerPoint, and send it in an email lol. I do all my regression analysis and simulations in Excel and never have had an issue. I despise power bi. Id rather just convert all the data into tables in excel and then use pivot charts and add slicers.
So true, I will add one final point, stakeholders will want to know everything, all in one visual, at all times, with 100% accuracy, aggregated every way possible. I love my job and all the people I work with over 15 years - but this has been the one thing I have not gotten used to just yet 😂
How to add value? First, ID what the top-5 driving things are that are eating your company's lunch, so to speak. Then, ID the variables that goes into them and see what is within human control. If its out of human control, then dont worry about it. If it is something you can control, then assess the potential risks/rewards of changing it. Recommend the change, measure the results, do continuous follow-ups, etc.
Thank you!!! 15 years in BI, also mostly doing advanced SQL, Excel and prototyping to get the requirements right. As he said in the video a lot of time needed to get either access or the right data, because most of the time documentation is not available or outdated and the information you need is in the head of the functional managers. Also no installing software on corporate machines so you are usually stuck with Excel. A lot of companies think they are so innovative and in control, but in the end you're still doing a lot of adhoc requests. SSBI & Analytics is slowly gaining some footing here in NL. So, thank you for this video. Edit: Something I had trouble with for a long time is people pressuring and stressing me to deliver because of specific deadlines. You work hard, long hours, do the impossible, and then the requester tells you that they totally forgot or it's no longer needed. Or you learn that the request has been laying for weeks on the requester's desk; even legal ones. After such a long time in the industry, I've learned to manage this much better by interrogating the requester basically regarding the deadline and managing expectations. Also, make sure everything has a paper trail (email). 🤟
@@AJ-ib4oy yup tableau is still hands down the best in the market. Fk Power BI, and I highly discourage people from wasting time learning this crappy unfinished product.
I truly believe you. This reminds me so much of my experiences with financial audit. You can spend a lot of time prepping before you being the actual work.
This is so true, though I'm lucky in that most of my day is spent in Tableau. But there is a lot of working with clients on what questions they want answered, and a lot of the time they think they know what they want when in reality it's something totally different after speaking with them. Love this job though. Never want to give up this career.
This! Exactly! You have to get to know the person too in order to better ascertain what they really want. 🤣 With some clients, a lot of people skills and people management is involved.
The fact that you gave a lot of clear insights in a very short time. Now I know what it'll be like when I begin working as the experience may be different from when learning.
There are a lot of videos on UA-cam for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc
SO many people learn such advance tools but forget the real goat of analytics: Excel. You think you know excel until you start using it to solve problems, I was the exact same. I work as a analyst in a MSO company and let me tell you, please get good in excel first, you dont need to master it but you need to be intermediate at it to land an entry level job. Its very rare you will actually use a lot of python or sql in an entry level position
100% agree, the developers will often do the bulk of any coding and an entry level position will need to be able to define requirements/examples in excel in a way that makes sense from a developer type of view. I have analysts that do some basic mcode, dax or sql etc but they are often just supplying examples to the developers who will rewrite in a more efficient way, i want my analysts to pull out meaningful insight into the data and identify new ways of presenting it to operational staff etc and the execs in ways they can understand it and the data presented in a way that can actually be useful, the big bosses (with data or finance backgrounds) will often want back up data in excel/pivots even though its in a fancy dashboard
Strongly disagree with both of the points here (as a mgr of data analytics w/ > 10 years experience...). By all means, be proficient in intermediate-level Excel, but your goal should be to do as little as possible in Excel over time because it's less repeatable, auditable, and scalable. Nested formulas and connecting multiple workbooks quickly get large and messy. The roles where there are analysts handing things off to a 'SQL Developer' to make more efficient, etc. is quickly on the way out. In the age of tools that make advanced analytics more accessible (building data flow pipelines, dashboards, etc, etc.), having data personas is a flawed, dated concept. It was the bane of my existence 5+ years ago, and everything since has been a breath of fresh air as democratization of data and tools becomes the new standard. The analytics you're describing are what typical business (non-technical) users will be doing themselves, while the data analysts will need to adapt to a broader technical skillset.
@@nashdashflashthis is the only sane comment I've seen, I don't understand how these people or companies rely on Excel, sounds like an unreproducible mess. I use R SAS and Python daily and only use Excel to store data or lists.
I manage to avoid using excel in my roll, mostly because I already spent 3 hours clensing my data using code that exporting to excel only to discover that the one date I need but didn't fully clense is stored as such a weird text string excel cannot convert it easily after half an hour of excel manipulation is deeply frustrating- but adding a fix 5 lines above where you were working is simple
yep coding languages like Python or R offer more flexibility and scalability for data cleaning and manipulation than Excel. They allow for easy changes in your data processing flow, which can save a lot of time. Excel may still be handy for quick analyses or for those not comfortable with coding, but if code-based work suits your needs better, that's the way to go!
When finding data with sql the program has to be synced with the company you work for? I’m assuming the data isn’t stored with sql but has to come from somewhere. It’s not like I can buy an sql software and answers any businesses question without having direct access to their data and then using sql to search, mine and clean the data.
“Nobody knows what the data is”? What is the data that needs to be worked on? Or retrieved? How do you attain the data from meetings? Thanks for sharing!!
I have a question. Do we need more data analyst? I’m so lost on what I want to do as a career but I know I’d like to do research and help people. I was going to do nursing but with my job, I don’t have any time to go to nursing school. So I have to find a computer job. Is this a career that will meet people all the time? Is it worth joining? I hope your reply 🤞
hey yes a data analyst at the end of the day will have the goal to help a business or people more in general and the connection with otherrs is also there as you won't work alone for sure
What do you recommend for newbies to get experience with data analytics that’s having trouble looking for a job as a business analyst or data analyst? Are there volunteer opportunities or freelance work that we must do to be more marketable applying for a job in this field?
I would check out my course to build a stunning data portfolio,or as you said try with volunteer and freelance loresowhat.com/data-analyst-mastercourse-the-complete-journey/
The worst part is when you try to suggest a cleaner way to store the data by using unique identifiers for each row for example, and you get told "No, just do it how we always do it" Makes life harder for everyone but they don't see it smh
Excel is the “JavaScript” of analytics apps: Whatever is written in another language will eventually be written in JS. Swap “written” for “analyzed” & “JS” with “Excel” 😂😂
Hey Lore Amazing video But I have Question and Issue to discuss with you that I have Problem communicating with the stakeholders or Clients face to face But I can communicate thorugh emails or anything related And I understand business analyst have to do this Part but As for a Data Analyst Who have issue with face to face meetings One Can do that or Survive in Data Analyst Job and Thankyu
All all this is the OTHER part of your data analyst education. When you get used to the endless meetings and the messy data, you will be a true data analyst!
Honestly, if you’re using Excel for data analysis, your business doesn’t have enough data for an analyst. Excel is sooo slow when there’s a lot of info in it. That’s why Power BI, Tableau, Python, and SQL exist. If you’re getting a data analysis job that only requires Excel, your not doing it right.
Been looking for a video like this to see whether or not data analytics is the right path to take. Just recently graduated with a degree in math and a computer science minor and have been stuck figuring out a final path to take. Are there any more advice or tips to looking into data analytics or any other IT field related jobs? Many thanks :)
I would suggest to go for a development field rather than data field. If you have interest in exploring data field than I would suggest going for data engineering rather than data analytics.
Hey could you please guide which path I should follow as i have to start from zero. Though I'm in first semester of MBA (Analytics and Data science) and i have access of coursera. Which particular courses I should enroll for?
I did work for a company with a dedicated sql programming team and a QA team that pulled and prepped my data, so I focused on the modeling part. We were like an efficient factory, it was nice. I don't know why more companies don't organize their data science departments like this.
@@loresowhat I hear data scientists repeat "90% of our work is data prep & cleaning, only 10% is modeling." That seems too heavy on the data side. Modeling is hard work & complex as well! Maintaining knowledge of new & old techniques, testing & comparing different models is a full time job.
Meanwhile Data Scientists just employ large language models and general AGI via convolutional neural networks and transformers to automate the data engineering and wrangling plus the data analysis process all together. Thus saving time for tasks that require critical thinking. Like utilizing the data to build models that can predict conditions and thus prepare the company for a more efficient encounter in the future.
100% as everyone will expect you to be at least intermediate (able to combine if/and/or into a single cell etc) to be able to solve problems, i had a Tableau developer in my team who had never used excel, so he had gone away and drafted some ideas and test some theory in Tableau that probably took a few hours, that we could’ve done in excel in a few minutes on a call, once he came to report in, I showed him how to do it in Excel, and he was quite surprised how much quicker the process was
Gosh I am actually in this crossroad now. How do I start helping my client from scratch. I feel I have the knowledge but not that I am actaully about to work, I don't know where to start and what tools to use.
Hi Lore, I am planning to apply for internship in data analytics. But I was told by my college that I need to pick a domain or niche like business analytics etc. I only have computer science background. What should I do?
AI is a super powerful tool that will transform the data analyst role but by no mean it will make it disappear. There is too much creative work involved for AI to replace a data analyst...
Is it true that Data analysts have to gain access to the data by talking to clients? Or does that depend on how big the company is that you're working for?
Great question Ifeoluwa.. Data analytics involves analyzing raw data to find trends and answer questions. This can be applied to many fields, from healthcare to marketing to finance. On the other hand, financial analysis is a specific type of data analysis that focuses on financial data. It involves interpreting financial statements, forecasting business, industry, or economic conditions, and making investment recommendations. And yes, having skills in data analytics can definitely help you become a better financial analyst. In fact, many financial analysts use data analytics to interpret and predict financial trends and outcomes. Let me know if this helps.
Hello sir, your words really matches from my experience friend he works in data analysis 😊 and as he also says that mostly excel is used so I'm from non technical background I have learnt basic Python, but just learning python is get far more difficult to me I'm thing now just by learning excel I can apply for a job is this right decision of mine?: Or I need to learn remaining SQL and Tableau
Hi! Your friend is correct that Excel is a widely used tool in many industries for data analysis. However, the skillset required for a data analyst varies widely based on the specific role and industry. While some positions may primarily use Excel, others might require proficiency in SQL for database querying, Python or R for more complex analyses, or Tableau for data visualization.
@@loresowhat bro, if I go from non technical background do I get job ? And is there scope in that and few people giving fear that because of ai it jobs are lossing so please guide me
I am currently taking an associate cert in Data mining and analytics and its like 16 months total but am 3months in and still dont know what am doing, are there like first steps youd advice me to start with as i continue learning this skills since i have no prior knowledge on languages or just coding in general
sure, let me gice you some tips here: Learn key concepts of data analytics including data types, databases, data cleaning, and basic statistics. Start with Python. It's beginner-friendly and widely used in data analytics. You can find free resources online. Get hands-on. Apply what you've learned in small projects or exercises. Practice SQL. It's vital for querying databases. Learn to use data visualization tools like Tableau. Repeat and expand. Keep learning, practicing, and challenging yourself with more complex problems. Get involved in the community. Use platforms like Kaggle to learn and interact with others. Document your journey. Keep a portfolio of your projects, which will be helpful when job hunting.
Me brewing coffee at 8am knowing I studied computer science to get paid to make pivot tables in Excel...
Ahaha I feel you 😂
What I love about it is my degree is in Criminology I had to take statistics a class and have used excel countless times in both college and in other jobs.
And yet, they wanna hit me with some BS about I need a certificate ? They can kiss my ass, if I trained myself in graphic design- I know I can do this!
@@gemmagemma-wx2bsyou go girl -Bob
You can use your computer science knowledge and apply it to other sub manifestations, data science is just one aspect of the computing realm.
@@gemmagemma-wx2bs,
Why i feel that am listening to a bedtime story
Your voice is calm
😂😂😂
@@loresowhat copilot 365 and chat gpt can kill your job
He sounds so beautiful 😂
😂😂😂
Hey I’ve got some really great news to share with you, Jesus Christ, the Son of God, died on a cross and resurrected on the third day so you may all have eternal life. If you believe and repent of your sins and put your faith and trust in Him as you would a parachute jumping off a plane at 25000 feet up in the air, He will give you eternal life in heaven as a free gift and I promise you, He will change your life forever as He did mine. He is the ONLY way to heaven and He loves you all. Please think deeply about this with urgency because this is your eternal life and soul, you don’t know when you could die, meaning you could die at any moment, so please consider this with all your heart. If anyone tells you that Jesus isn’t the only way, they are lying to you and they don’t care about your future.
This is the most accurate information I’ve heard in a long time lol. Every single point is so true!!! ❤️
Wow thanks for the nice words 🙏
Yesss Excel is basically the master shifu of data analysis
you got it!!!!!
@@loresowhatSo why did power bi and what not become a thing if excel was fine in the first place? I don't get it 😩
@@fpfpfpfppfPower BI is simple to use and is better for dashboarding than Excel. In short, Power bi exists for data visualization.
I don't understand how y'all use Excel instead of programming like R or Python
Ive been an analyst for over a decade. I mostly use Excel because VBA is a thing. And, since its all part of the Microsoft Office suite, you can make Excel VBA pull and clean your data, build a PowerPoint, and send it in an email lol. I do all my regression analysis and simulations in Excel and never have had an issue.
I despise power bi. Id rather just convert all the data into tables in excel and then use pivot charts and add slicers.
Finally, someone with a calm voice 😂
Ahaha it was needed 😅
So true, I will add one final point, stakeholders will want to know everything, all in one visual, at all times, with 100% accuracy, aggregated every way possible. I love my job and all the people I work with over 15 years - but this has been the one thing I have not gotten used to just yet 😂
Absolutely! The demands of stakeholders can often feel like they're looking for a magical one-size-fits-all solution ahah
All comes with experience. Anticipating the questions your customers will ask before they ask them lol.
Video idea: how to add value to a business in X industry, as a data scientist/analyst.
thanks a lot Samuel, I put this in my list 👌
How to add value? First, ID what the top-5 driving things are that are eating your company's lunch, so to speak. Then, ID the variables that goes into them and see what is within human control. If its out of human control, then dont worry about it. If it is something you can control, then assess the potential risks/rewards of changing it. Recommend the change, measure the results, do continuous follow-ups, etc.
Thank you!!! 15 years in BI, also mostly doing advanced SQL, Excel and prototyping to get the requirements right. As he said in the video a lot of time needed to get either access or the right data, because most of the time documentation is not available or outdated and the information you need is in the head of the functional managers. Also no installing software on corporate machines so you are usually stuck with Excel. A lot of companies think they are so innovative and in control, but in the end you're still doing a lot of adhoc requests. SSBI & Analytics is slowly gaining some footing here in NL. So, thank you for this video.
Edit: Something I had trouble with for a long time is people pressuring and stressing me to deliver because of specific deadlines. You work hard, long hours, do the impossible, and then the requester tells you that they totally forgot or it's no longer needed. Or you learn that the request has been laying for weeks on the requester's desk; even legal ones. After such a long time in the industry, I've learned to manage this much better by interrogating the requester basically regarding the deadline and managing expectations. Also, make sure everything has a paper trail (email). 🤟
sooooo accurate!!! thanks for the great comment 🙂
Nah BI sucks, switch to tableau. Guarantee it will be your proudest decision.
Power BI is half baked. They should’ve finished making it before releasing it.
@@AJ-ib4oy yup tableau is still hands down the best in the market. Fk Power BI, and I highly discourage people from wasting time learning this crappy unfinished product.
Time spent in looking for data set is unimaginable
I'm totally with you ahaha
How many time? I mean two three days?
I truly believe you. This reminds me so much of my experiences with financial audit. You can spend a lot of time prepping before you being the actual work.
so glad to see this reasonates with you 🙂
This is so true, though I'm lucky in that most of my day is spent in Tableau. But there is a lot of working with clients on what questions they want answered, and a lot of the time they think they know what they want when in reality it's something totally different after speaking with them. Love this job though. Never want to give up this career.
amazing comment and definitely going through exactly what you said myself too
This sounds so much like the execs I dealt with as a network engineer 😂
I'm planning on studying this and I would appreciate insight on the job market, and expirience...
This! Exactly! You have to get to know the person too in order to better ascertain what they really want. 🤣 With some clients, a lot of people skills and people management is involved.
Hello , how can i go about learning data analytics
Your voice so soothing, it made me feel okay to calm down and listen quietly rather than blasting my volume LOl
Thanksssss
I love his voice. So calm and reassuring 🤧
ahahah thanks 😇
Thanks for the info. Just save me from the unreal expectations.
Glad I could help!
I think I've finally found that perfect channel.
Thanks for the precise clarity bro
Oh wow thanks for the comment 🙂 what is it that you like?
The fact that you gave a lot of clear insights in a very short time.
Now I know what it'll be like when I begin working as the experience may be different from when learning.
@@frederickdestinergolden3996 so glad to hear, keep me posted with your progress 🙂
I think it also depends on how big and mature (in terms of data) the company is
Totally agree 👍
There are a lot of videos on UA-cam for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc
Great idea thanks for that 👍
This is very accurate to my experience so far doing data and business analytics.
😉
So it sucks ?
@@obijuankenobi420 It doesn't suck, it's just reality. Clerical errors and relatively outdated info is natural and expected for many data sets.
@@SuperAwesomeReasons Dont you just use programs to find the errors ?
You should start an asmr channel. I'd listen to it all day
Ahahaha
SO many people learn such advance tools but forget the real goat of analytics: Excel. You think you know excel until you start using it to solve problems, I was the exact same. I work as a analyst in a MSO company and let me tell you, please get good in excel first, you dont need to master it but you need to be intermediate at it to land an entry level job. Its very rare you will actually use a lot of python or sql in an entry level position
100% agree, the developers will often do the bulk of any coding and an entry level position will need to be able to define requirements/examples in excel in a way that makes sense from a developer type of view.
I have analysts that do some basic mcode, dax or sql etc but they are often just supplying examples to the developers who will rewrite in a more efficient way, i want my analysts to pull out meaningful insight into the data and identify new ways of presenting it to operational staff etc and the execs in ways they can understand it and the data presented in a way that can actually be useful, the big bosses (with data or finance backgrounds) will often want back up data in excel/pivots even though its in a fancy dashboard
Strongly disagree with both of the points here (as a mgr of data analytics w/ > 10 years experience...). By all means, be proficient in intermediate-level Excel, but your goal should be to do as little as possible in Excel over time because it's less repeatable, auditable, and scalable. Nested formulas and connecting multiple workbooks quickly get large and messy.
The roles where there are analysts handing things off to a 'SQL Developer' to make more efficient, etc. is quickly on the way out. In the age of tools that make advanced analytics more accessible (building data flow pipelines, dashboards, etc, etc.), having data personas is a flawed, dated concept. It was the bane of my existence 5+ years ago, and everything since has been a breath of fresh air as democratization of data and tools becomes the new standard.
The analytics you're describing are what typical business (non-technical) users will be doing themselves, while the data analysts will need to adapt to a broader technical skillset.
@@nashdashflashthis is the only sane comment I've seen, I don't understand how these people or companies rely on Excel, sounds like an unreproducible mess. I use R SAS and Python daily and only use Excel to store data or lists.
Came here for information and insight, didn't leave.. I love your voice
So glad Rubi!
I manage to avoid using excel in my roll, mostly because I already spent 3 hours clensing my data using code that exporting to excel only to discover that the one date I need but didn't fully clense is stored as such a weird text string excel cannot convert it easily after half an hour of excel manipulation is deeply frustrating- but adding a fix 5 lines above where you were working is simple
yep coding languages like Python or R offer more flexibility and scalability for data cleaning and manipulation than Excel. They allow for easy changes in your data processing flow, which can save a lot of time. Excel may still be handy for quick analyses or for those not comfortable with coding, but if code-based work suits your needs better, that's the way to go!
You speak so softly that even after full volume it feels a bit like whisper.
Ahah thanks for the feedback, still newbie here and will try to improve 😉
Nice. Thank you for this. This actually answered my question I posted in another site
Glad it’s helpful 🙂 what was your question initially?
When finding data with sql the program has to be synced with the company you work for? I’m assuming the data isn’t stored with sql but has to come from somewhere. It’s not like I can buy an sql software and answers any businesses question without having direct access to their data and then using sql to search, mine and clean the data.
@@sterlingphoenix71 you got it, you need to connect to their data yes 👍
Your #2 point answered my question
This is the realest video on the career
glad you like it thankssss
Number 2 extremely and totally agree 😅 i dont work with clean data, i clean data first...
ahahah glad this reasonates with you 🙂
He's spot on! I hate being a DA and it's only my salary keeps me stuck doing it.
I feel you ahah 😝
“Nobody knows what the data is”? What is the data that needs to be worked on? Or retrieved? How do you attain the data from meetings?
Thanks for sharing!!
this is something that you would need to ask around in the company or ask your manager for help
I have a question. Do we need more data analyst? I’m so lost on what I want to do as a career but I know I’d like to do research and help people. I was going to do nursing but with my job, I don’t have any time to go to nursing school. So I have to find a computer job. Is this a career that will meet people all the time? Is it worth joining?
I hope your reply 🤞
hey yes a data analyst at the end of the day will have the goal to help a business or people more in general and the connection with otherrs is also there as you won't work alone for sure
What do you recommend for newbies to get experience with data analytics that’s having trouble looking for a job as a business analyst or data analyst? Are there volunteer opportunities or freelance work that we must do to be more marketable applying for a job in this field?
I would check out my course to build a stunning data portfolio,or as you said try with volunteer and freelance loresowhat.com/data-analyst-mastercourse-the-complete-journey/
i simply learned Ms excel and g sheet, got selected for hr analysis. want to point out that learning the other tools is really important
Thanks for the comment and well done 🤩
Me the whole video: pressing headphones to my ears
ahahaha sorry for that, didn't have a mic 🙂
your voice is so calm..
😂😂the last line
ahah do you agree?
Thank you for the useful information.
glad you like it 😀
This is informative.. but would love to understand more about what it entails
Sure let me know if you have any specific questions 👍
Data Analyst: “where is this data?”
Client: “nobody knows…” 🤷🏻♂️
Sad story for data analysts 😅
Hi Lore, this is really informative 🌸
Glad it was helpful!
You need to do voiceovers!!! 🔥🔥🔥
ahaah will think of that as my next step in my career
Your voice is soothing
ahaha thanks, doing my best
GLAD A.I WILL REPLACE MOST HARSH JOB😊😊😊
😏
The most ASMR tech short off all time.. 😂
haahahahaha
Yo this was 🔥 thanks for the insight lore
Appreciate it 🎉
Glad you enjoyed ✨
The worst part is when you try to suggest a cleaner way to store the data by using unique identifiers for each row for example, and you get told "No, just do it how we always do it"
Makes life harder for everyone but they don't see it smh
Totally with you 😅
Can you elaborate more?
so glad i work in Education lol, we go through SSID lol
Extremely helpful
Glad it helped
Excel is the “JavaScript” of analytics apps: Whatever is written in another language will eventually be written in JS.
Swap “written” for “analyzed” & “JS” with “Excel” 😂😂
Ahah that was sharp! That is often the case unfortunately
I read the whole thing about the certification and they did say excel or sheets is used. They also said python isn’t used.
not sure how followed this comment sorry
Hey Lore Amazing video But I have Question and Issue to discuss with you that I have Problem communicating with the stakeholders or Clients face to face But I can communicate thorugh emails or anything related And I understand business analyst have to do this Part but As for a Data Analyst Who have issue with face to face meetings One Can do that or Survive in Data Analyst Job and Thankyu
Thank you
Your welcome 🙏
Thanks 👍
Spot on dude
😉
Its less that they dont know where the data where it is and more they usually dont even know what they're asking for.
wow I cannot agree more ahah
Fix the volume. We can turn down if we need
Will do thanks for the feedback 😉
Does this job pay well?
I have a CE Bachelor’s degree and i wanna start learning data analysis, is the payment worth it?
pays very well yes 🙂
This is so true
ahah welcome aboard 😀
This does not scare me away. I still want to be a data analyst
Let’s gooo then
Lmfaooo 😭 this part
do you agree?
Italians have the same accent as Argentines when they speak English lol😂
ahaha you are not the first person telling me ahah
All all this is the OTHER part of your data analyst education. When you get used to the endless meetings and the messy data, you will be a true data analyst!
Totally agree 👍
Hmmm - interesting and excellent insight
🙂
Honestly, if you’re using Excel for data analysis, your business doesn’t have enough data for an analyst. Excel is sooo slow when there’s a lot of info in it. That’s why Power BI, Tableau, Python, and SQL exist.
If you’re getting a data analysis job that only requires Excel, your not doing it right.
Been looking for a video like this to see whether or not data analytics is the right path to take. Just recently graduated with a degree in math and a computer science minor and have been stuck figuring out a final path to take. Are there any more advice or tips to looking into data analytics or any other IT field related jobs? Many thanks :)
it's a good career path in my opinion so my advice would be to practice on a project and see if you like it or not
I would suggest to go for a development field rather than data field. If you have interest in exploring data field than I would suggest going for data engineering rather than data analytics.
@@spark.99by development you mean business wise?
just graduated from the Google data analysis course and excited to start on this career path. This was a great insight of what to expect.
Glad it helps 🙂
Hey could you please guide which path I should follow as i have to start from zero. Though I'm in first semester of MBA (Analytics and Data science) and i have access of coursera. Which particular courses I should enroll for?
I did work for a company with a dedicated sql programming team and a QA team that pulled and prepped my data, so I focused on the modeling part.
We were like an efficient factory, it was nice. I don't know why more companies don't organize their data science departments like this.
Glad you had that experience cause totally agree with you, most companies are not well organized
@@loresowhat I hear data scientists repeat "90% of our work is data prep & cleaning, only 10% is modeling."
That seems too heavy on the data side. Modeling is hard work & complex as well! Maintaining knowledge of new & old techniques, testing & comparing different models is a full time job.
Meanwhile Data Scientists just employ large language models and general AGI via convolutional neural networks and transformers to automate the data engineering and wrangling plus the data analysis process all together.
Thus saving time for tasks that require critical thinking. Like utilizing the data to build models that can predict conditions and thus prepare the company for a more efficient encounter in the future.
Please I want to learn more can you explain more please
never heard a data scientist doing all of that ahaha
increase the volume
i thought my speaker was broken
sorry about that, this was one of my first videos so hopefully in the recent ones the audio is better
damn this sounds like a fucking sick job dude, thanks for taking away all the bullshit!
Ahah glad it was helpful 👍
Love ur voice
Ahah thanks 🙏
Low sound bro
thanks, will keep in mind for the next ones 😅
value added
Glad you liked it 😉
So it’s a bad job there should be a different job for a person who collects the data this is stupid that’s not the job I’m looking for
Some companies are better organised than others so thankfully this is not happening everywhere
@@loresowhat I was interested in this but I think I will go with machine learning engineering this seems like call centre job with more work.
Very true!!!
Glad you agree Russell 🙌
Can i get job as a data analyst without a degree ? And as a fresher too ....
absolutely, you just need a powerful portfolio 🙂
I spend so much time in excel with the data 😭😩
Same here Maria, I feel you 🤣🥲
How much work pressure? Maria data analysis
So to get into data analytics as a non IT background person, I need to master excel skill first?
yep, I'd recommend to get comfortable with Excel before jumping on other more complex tools
100% as everyone will expect you to be at least intermediate (able to combine if/and/or into a single cell etc) to be able to solve problems, i had a Tableau developer in my team who had never used excel, so he had gone away and drafted some ideas and test some theory in Tableau that probably took a few hours, that we could’ve done in excel in a few minutes on a call, once he came to report in, I showed him how to do it in Excel, and he was quite surprised how much quicker the process was
I just started a course I'm not sure if I'm smart enough to do this I don't really understand exactly
It’s normal to feel insecure and that is when you learn the most and push yourself to the limit so keep it up
Gosh I am actually in this crossroad now. How do I start helping my client from scratch. I feel I have the knowledge but not that I am actaully about to work, I don't know where to start and what tools to use.
just go for it!!! I'm sure you can do it and it has to feel uncomfortable at the start, this is when you learn the most!
Thank you so much @@loresowhat . Wish there's a way to communicate with you. I have a million questions.
Más argentino que maradona. Jaja gracias por el video. Exelente video
😂
oh my I need to master excel hehe
You got ittttt 🙂
Hi Lore, I am planning to apply for internship in data analytics. But I was told by my college that I need to pick a domain or niche like business analytics etc. I only have computer science background. What should I do?
Hey reach out to me on Instagram at loresowhat
Thanks for the information.
Do i know ai will replace data analyst jobs. Its pretty much in hype, whats your opinion on this
AI is a super powerful tool that will transform the data analyst role but by no mean it will make it disappear. There is too much creative work involved for AI to replace a data analyst...
Is there anything to do with microsoft power bi ?
What you mean by that?
Stakeholders? Some people own the company. Some people work for it. Everyone else is irrelevant, particularly tyrants in Switzerland.
straight to the point
I'm not hearing a word... You need to do a bedtime podcast
ahaha that can be a good plan for 2024. I got a mic now so should be better
So true
glad you like it 🙂
Is it true that Data analysts have to gain access to the data by talking to clients? Or does that depend on how big the company is that you're working for?
It really depends on the project. Sometimes the data is readily available and sometimes it’s just a nightmare to get it…
@@loresowhat thank you for your reply!
how much do you earn per year excluding bonuses
I earn 6 figures base in pounds but I’m not able to share the exact figure here
@@loresowhat so your saying it varies?
omg im stuying data an now
Let’s gooo
True 😂
🙂
Please can you differentiate data analytics from financial analysis? And does data analytics help someone becoming a financial analyst?
Great question Ifeoluwa.. Data analytics involves analyzing raw data to find trends and answer questions. This can be applied to many fields, from healthcare to marketing to finance.
On the other hand, financial analysis is a specific type of data analysis that focuses on financial data. It involves interpreting financial statements, forecasting business, industry, or economic conditions, and making investment recommendations.
And yes, having skills in data analytics can definitely help you become a better financial analyst. In fact, many financial analysts use data analytics to interpret and predict financial trends and outcomes. Let me know if this helps.
@@loresowhat yes it does. Thank you so much
Is the career time worth the pay?
In my humble opinion yes, very good pay 💰
how much bruh@@loresowhat
You can still use python and sql, and convert the files to an excel format right?? I find easier to use sql and python than excel
Yep I do that too 👍
I really wish I was smart enough to do this
you are definitely smart enough!!!!!!
Well this is very off putting, but at the same time we NEED to hear this!
exactly, there are pros and cons
Hello sir, your words really matches from my experience friend he works in data analysis 😊 and as he also says that mostly excel is used so I'm from non technical background I have learnt basic Python, but just learning python is get far more difficult to me I'm thing now just by learning excel I can apply for a job is this right decision of mine?: Or I need to learn remaining SQL and Tableau
Hi! Your friend is correct that Excel is a widely used tool in many industries for data analysis. However, the skillset required for a data analyst varies widely based on the specific role and industry. While some positions may primarily use Excel, others might require proficiency in SQL for database querying, Python or R for more complex analyses, or Tableau for data visualization.
@@loresowhat bro, if I go from non technical background do I get job ?
And is there scope in that and few people giving fear that because of ai it jobs are lossing so please guide me
Wow, I will not be doing this !!!
there are pros and cons
So excel is better than googles and how much different is it I’m just wondering because I’m interested in this feild
if you mean excel vs google spreadsheet then yes, excel is probably better for data analysis
I am currently taking an associate cert in Data mining and analytics and its like 16 months total but am 3months in and still dont know what am doing, are there like first steps youd advice me to start with as i continue learning this skills since i have no prior knowledge on languages or just coding in general
sure, let me gice you some tips here:
Learn key concepts of data analytics including data types, databases, data cleaning, and basic statistics.
Start with Python. It's beginner-friendly and widely used in data analytics. You can find free resources online.
Get hands-on. Apply what you've learned in small projects or exercises.
Practice SQL. It's vital for querying databases.
Learn to use data visualization tools like Tableau.
Repeat and expand. Keep learning, practicing, and challenging yourself with more complex problems.
Get involved in the community. Use platforms like Kaggle to learn and interact with others.
Document your journey. Keep a portfolio of your projects, which will be helpful when job hunting.
Unfortunately, It's a true story, also in my strange work's reality.
glad it reasonates Giuseppe 🙂
How can I get hired on as a data analyst? I have some Google certs but very little experience
Work on a portfolio and build credibility with your resume and Linkedin, if you text me on instagram I can help 👍