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.
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!
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 😂
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). 🤟
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.
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.
There are a lot of videos on TH-cam for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc
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.
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!
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
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
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” 😂😂
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.
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?
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/
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 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.
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?
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?
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.
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...
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.
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!
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.
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! I am an entry level data analysts and i have learned excel and tableau and i have created a portfolio on them. Right now i am learning sql. My question is how can i get an entry level data analysts job. Any tips will be greatly appreciated
2 or 3 months full time to have a good foundation. if you need help you can check out my new course loresowhat.com/data-analyst-mastercourse-the-complete-journey/
![[LIVE] ย้อนวันวานกับนางเอกยุค 90's #คุยให้เด็กมันฟัง EP.42 (8/6/67)](http://i.ytimg.com/vi/MslQDdFwULE/mqdefault.jpg)
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.
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.
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
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 🙏
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.
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
Finally, someone with a calm voice 😂
Ahaha it was needed 😅
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 👌
Time spent in looking for data set is unimaginable
I'm totally with you ahaha
How many time? I mean two three days?
Your voice so soothing, it made me feel okay to calm down and listen quietly rather than blasting my volume LOl
Thanksssss
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
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 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 🙂
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 TH-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 ?
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 🙂
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.
You should start an asmr channel. I'd listen to it all day
Ahahaha
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!
your voice is so calm..
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
Came here for information and insight, didn't leave.. I love your voice
So glad Rubi!
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
Number 2 extremely and totally agree 😅 i dont work with clean data, i clean data first...
ahahah glad this reasonates with you 🙂
Yo this was 🔥 thanks for the insight lore
Appreciate it 🎉
Glad you enjoyed ✨
Thank you for the useful information.
glad you like it 😀
Thanks 👍
He's spot on! I hate being a DA and it's only my salary keeps me stuck doing it.
I feel you ahah 😝
Hi Lore, this is really informative 🌸
Glad it was helpful!
This is the realest video on the career
glad you like it thankssss
Your voice is soothing
ahaha thanks, doing my best
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 🤩
Extremely helpful
Glad it helped
GLAD A.I WILL REPLACE MOST HARSH JOB😊😊😊
😏
“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
Thank you
Your welcome 🙏
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
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
Me the whole video: pressing headphones to my ears
ahahaha sorry for that, didn't have a mic 🙂
This is so true
ahah welcome aboard 😀
Hmmm - interesting and excellent insight
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
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
You need to do voiceovers!!! 🔥🔥🔥
ahaah will think of that as my next step in my career
Spot on dude
😉
Data Analyst: “where is this data?”
Client: “nobody knows…” 🤷🏻♂️
Sad story for data analysts 😅
This is informative.. but would love to understand more about what it entails
Sure let me know if you have any specific questions 👍
Fix the volume. We can turn down if we need
Will do thanks for the feedback 😉
The most ASMR tech short off all time.. 😂
haahahahaha
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?
This does not scare me away. I still want to be a data analyst
Let’s gooo then
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
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/
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
Very true!!!
Glad you agree Russell 🙌
Is there anything to do with microsoft power bi ?
What you mean by that?
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
😂😂the last line
ahah do you agree?
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.
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!
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 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
Low sound bro
thanks, will keep in mind for the next ones 😅
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.
I spend so much time in excel with the data 😭😩
Same here Maria, I feel you 🤣🥲
How much work pressure? Maria data analysis
Amigazoo, muchas gracias por estos videos son realmente de mucha ayuda
Thanks 🙏
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...
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 👍
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.
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 👍
value added
Glad you liked it 😉
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
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?
❤❤❤
Good to see you in the channel 🙂
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
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
Love ur voice
Ahah thanks 🙏
I really wish I was smart enough to do this
you are definitely smart enough!!!!!!
Is the career time worth the pay?
In my humble opinion yes, very good pay 💰
how much bruh@@loresowhat
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 👍
True
glad you agree 🙂
Hello! I am an entry level data analysts and i have learned excel and tableau and i have created a portfolio on them. Right now i am learning sql.
My question is how can i get an entry level data analysts job. Any tips will be greatly appreciated
Nice work! and happy to mentor if you need help, you can text me on ig
@@loresowhat ok thanks for the reply
Facts!!!!!!
you got it!!
Averagely how long does it take to learn Data Analytics?
2 or 3 months full time to have a good foundation. if you need help you can check out my new course loresowhat.com/data-analyst-mastercourse-the-complete-journey/
Italians have the same accent as Argentines when they speak English lol😂
ahaha you are not the first person telling me ahah
oh my I need to master excel hehe
You got ittttt 🙂
Wow, I will not be doing this !!!
there are pros and cons
Más argentino que maradona. Jaja gracias por el video. Exelente video
😂
Unfortunately, It's a true story, also in my strange work's reality.
glad it reasonates Giuseppe 🙂
R u completely remote or do u do presentations in front of people ?
not remote so mainly in the office
Well this is very off putting, but at the same time we NEED to hear this!
exactly, there are pros and cons
This just scared me not to attemptb😢😂
oh no!! it is still a very good career path in my opinion
Hy will u please recommend any online course to become data analyst with its tenure and fee?
Hey you might want to check my channel, I made a whole video about the courses I recommend 👍
@@loresowhat oh thanx
Hello can u plz tell me which is best Acca or data scientistplzzzz can u tell me???
this depends on your taste right? there is no right answer cause those are two different fields and both could be good career options
Is it just data entry stuff??
Nahh much more than that