The harsh reality of a Data Analyst job

  Рет қаралды 294,270

Lore So What

Lore So What

Жыл бұрын

The expectations when you start learning about data analytics are far from the reality of what actually happens on the field, let me explain why...

Пікірлер: 383
@Hawkfeet
@Hawkfeet Жыл бұрын
Why i feel that am listening to a bedtime story Your voice is calm
@loresowhat
@loresowhat Жыл бұрын
😂😂😂
@carkawalakhatulistiwa
@carkawalakhatulistiwa Жыл бұрын
​@@loresowhat copilot 365 and chat gpt can kill your job
@summertimejay3157
@summertimejay3157 Жыл бұрын
He sounds so beautiful 😂
@sidraiqbal858
@sidraiqbal858 Жыл бұрын
😂😂😂
@teamhop
@teamhop 10 ай бұрын
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.
@georgek2092
@georgek2092 9 ай бұрын
Me brewing coffee at 8am knowing I studied computer science to get paid to make pivot tables in Excel...
@loresowhat
@loresowhat 9 ай бұрын
Ahaha I feel you 😂
@gemmagemma-wx2bs
@gemmagemma-wx2bs 4 ай бұрын
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!
@aintthatright616
@aintthatright616 4 ай бұрын
@@gemmagemma-wx2bsyou go girl -Bob
@vorsybl
@vorsybl 2 ай бұрын
You can use your computer science knowledge and apply it to other sub manifestations, data science is just one aspect of the computing realm.
@TaylorLincoln401
@TaylorLincoln401 Жыл бұрын
This is the most accurate information I’ve heard in a long time lol. Every single point is so true!!! ❤️
@loresowhat
@loresowhat Жыл бұрын
Wow thanks for the nice words 🙏
@stormglass2882
@stormglass2882 5 ай бұрын
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). 🤟
@loresowhat
@loresowhat Ай бұрын
sooooo accurate!!! thanks for the great comment 🙂
@ltk7309
@ltk7309 Ай бұрын
Nah BI sucks, switch to tableau. Guarantee it will be your proudest decision.
@BummerSlug
@BummerSlug 10 ай бұрын
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 😂
@loresowhat
@loresowhat 9 ай бұрын
Absolutely! The demands of stakeholders can often feel like they're looking for a magical one-size-fits-all solution ahah
@emilyau8023
@emilyau8023 11 ай бұрын
Yesss Excel is basically the master shifu of data analysis
@loresowhat
@loresowhat 11 ай бұрын
you got it!!!!!
@fpfpfpfppf
@fpfpfpfppf 7 ай бұрын
​@@loresowhatSo why did power bi and what not become a thing if excel was fine in the first place? I don't get it 😩
@Enki._
@Enki._ 2 ай бұрын
​​@@fpfpfpfppfPower BI is simple to use and is better for dashboarding than Excel. In short, Power bi exists for data visualization.
@El_Jefe_Maestro
@El_Jefe_Maestro Ай бұрын
I don't understand how y'all use Excel instead of programming like R or Python
@Bk-Illu
@Bk-Illu Ай бұрын
Finally, someone with a calm voice 😂
@loresowhat
@loresowhat Ай бұрын
Ahaha it was needed 😅
@ArtAndTechWithNicolas
@ArtAndTechWithNicolas Жыл бұрын
Video idea: how to add value to a business in X industry, as a data scientist/analyst.
@loresowhat
@loresowhat Жыл бұрын
thanks a lot Samuel, I put this in my list 👌
@azeezakintonde430
@azeezakintonde430 Жыл бұрын
Time spent in looking for data set is unimaginable
@loresowhat
@loresowhat Жыл бұрын
I'm totally with you ahaha
@sidraiqbal858
@sidraiqbal858 Жыл бұрын
How many time? I mean two three days?
@karankaul1639
@karankaul1639 7 ай бұрын
Thanks for the info. Just save me from the unreal expectations.
@loresowhat
@loresowhat 7 ай бұрын
Glad I could help!
@julbeeyaren8483
@julbeeyaren8483 7 ай бұрын
I love his voice. So calm and reassuring 🤧
@loresowhat
@loresowhat 7 ай бұрын
ahahah thanks 😇
@TheBigBenji890
@TheBigBenji890 10 ай бұрын
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.
@loresowhat
@loresowhat 10 ай бұрын
amazing comment and definitely going through exactly what you said myself too
@nikkiem.4573
@nikkiem.4573 8 ай бұрын
This sounds so much like the execs I dealt with as a network engineer 😂
@giebbieserah4440
@giebbieserah4440 7 ай бұрын
I'm planning on studying this and I would appreciate insight on the job market, and expirience...
@stormglass2882
@stormglass2882 5 ай бұрын
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.
@michaelt.v3937
@michaelt.v3937 5 ай бұрын
Hello , how can i go about learning data analytics
@iNinjeek
@iNinjeek 6 ай бұрын
Your voice so soothing, it made me feel okay to calm down and listen quietly rather than blasting my volume LOl
@loresowhat
@loresowhat 6 ай бұрын
Thanksssss
@TheQueenIsWithin
@TheQueenIsWithin Жыл бұрын
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.
@loresowhat
@loresowhat Жыл бұрын
so glad to see this reasonates with you 🙂
@Everyone___
@Everyone___ Жыл бұрын
I think it also depends on how big and mature (in terms of data) the company is
@loresowhat
@loresowhat Жыл бұрын
Totally agree 👍
@VisualsofAyan
@VisualsofAyan Жыл бұрын
There are a lot of videos on KZbin for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc
@loresowhat
@loresowhat Жыл бұрын
Great idea thanks for that 👍
@SuperAwesomeReasons
@SuperAwesomeReasons Жыл бұрын
This is very accurate to my experience so far doing data and business analytics.
@loresowhat
@loresowhat Жыл бұрын
😉
@obijuankenobi420
@obijuankenobi420 Жыл бұрын
So it sucks ?
@SuperAwesomeReasons
@SuperAwesomeReasons Жыл бұрын
@@obijuankenobi420 It doesn't suck, it's just reality. Clerical errors and relatively outdated info is natural and expected for many data sets.
@obijuankenobi420
@obijuankenobi420 Жыл бұрын
@@SuperAwesomeReasons Dont you just use programs to find the errors ?
@frederickdestinergolden3996
@frederickdestinergolden3996 2 ай бұрын
I think I've finally found that perfect channel. Thanks for the precise clarity bro
@loresowhat
@loresowhat 2 ай бұрын
Oh wow thanks for the comment 🙂 what is it that you like?
@frederickdestinergolden3996
@frederickdestinergolden3996 2 ай бұрын
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.
@loresowhat
@loresowhat 2 ай бұрын
@@frederickdestinergolden3996 so glad to hear, keep me posted with your progress 🙂
@rubi6977
@rubi6977 10 ай бұрын
Came here for information and insight, didn't leave.. I love your voice
@loresowhat
@loresowhat 10 ай бұрын
So glad Rubi!
@mahaali89
@mahaali89 Жыл бұрын
You should start an asmr channel. I'd listen to it all day
@loresowhat
@loresowhat Жыл бұрын
Ahahaha
@sterlingphoenix71
@sterlingphoenix71 7 ай бұрын
Nice. Thank you for this. This actually answered my question I posted in another site
@loresowhat
@loresowhat 7 ай бұрын
Glad it’s helpful 🙂 what was your question initially?
@sterlingphoenix71
@sterlingphoenix71 7 ай бұрын
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.
@loresowhat
@loresowhat 7 ай бұрын
@@sterlingphoenix71 you got it, you need to connect to their data yes 👍
@sterlingphoenix71
@sterlingphoenix71 7 ай бұрын
Your #2 point answered my question
@fridayblessed9742
@fridayblessed9742 7 ай бұрын
your voice is so calm..
@ArtAndTechWithNicolas
@ArtAndTechWithNicolas Жыл бұрын
Thank you for the useful information.
@loresowhat
@loresowhat Жыл бұрын
glad you like it 😀
@vish949
@vish949 Жыл бұрын
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
@milkboccle
@milkboccle Жыл бұрын
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
@nashdashflash
@nashdashflash Жыл бұрын
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.
@El_Jefe_Maestro
@El_Jefe_Maestro Ай бұрын
​@@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.
@HolaYosoyNhi
@HolaYosoyNhi Жыл бұрын
Number 2 extremely and totally agree 😅 i dont work with clean data, i clean data first...
@loresowhat
@loresowhat Жыл бұрын
ahahah glad this reasonates with you 🙂
@muradali1231
@muradali1231 Жыл бұрын
You speak so softly that even after full volume it feels a bit like whisper.
@loresowhat
@loresowhat Жыл бұрын
Ahah thanks for the feedback, still newbie here and will try to improve 😉
@Aima952
@Aima952 11 ай бұрын
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
@loresowhat
@loresowhat 11 ай бұрын
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!
@ONE-zx3sg
@ONE-zx3sg 7 ай бұрын
Yo this was 🔥 thanks for the insight lore Appreciate it 🎉
@loresowhat
@loresowhat 7 ай бұрын
Glad you enjoyed ✨
@IArkProject
@IArkProject 11 ай бұрын
Extremely helpful
@loresowhat
@loresowhat 11 ай бұрын
Glad it helped
@parkshermoso1012
@parkshermoso1012 Жыл бұрын
This is the realest video on the career
@loresowhat
@loresowhat Жыл бұрын
glad you like it thankssss
@nabanitadasgupta
@nabanitadasgupta Жыл бұрын
Hi Lore, this is really informative 🌸
@loresowhat
@loresowhat Жыл бұрын
Glad it was helpful!
@olah8536
@olah8536 3 ай бұрын
Your voice is soothing
@loresowhat
@loresowhat Ай бұрын
ahaha thanks, doing my best
@nira3188
@nira3188 3 ай бұрын
Thanks 👍
@kabelo3231
@kabelo3231 Жыл бұрын
Thank you
@loresowhat
@loresowhat Жыл бұрын
Your welcome 🙏
@JBlue-ee9cs
@JBlue-ee9cs 7 ай бұрын
He's spot on! I hate being a DA and it's only my salary keeps me stuck doing it.
@loresowhat
@loresowhat 7 ай бұрын
I feel you ahah 😝
@Super-Sal
@Super-Sal Жыл бұрын
Spot on dude
@loresowhat
@loresowhat Жыл бұрын
😉
@onlyyoucanstopevil9024
@onlyyoucanstopevil9024 Жыл бұрын
GLAD A.I WILL REPLACE MOST HARSH JOB😊😊😊
@loresowhat
@loresowhat Жыл бұрын
😏
@keifer7813
@keifer7813 Жыл бұрын
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
@loresowhat
@loresowhat Жыл бұрын
Totally with you 😅
@PalestineWillBeFreeee
@PalestineWillBeFreeee Жыл бұрын
Can you elaborate more?
@ramonpena8491
@ramonpena8491 Жыл бұрын
so glad i work in Education lol, we go through SSID lol
@giebbieserah4440
@giebbieserah4440 7 ай бұрын
This is informative.. but would love to understand more about what it entails
@loresowhat
@loresowhat 7 ай бұрын
Sure let me know if you have any specific questions 👍
@melindamurcia1692
@melindamurcia1692 Жыл бұрын
“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!!
@loresowhat
@loresowhat Жыл бұрын
this is something that you would need to ask around in the company or ask your manager for help
@lululemonbar9110
@lululemonbar9110 4 ай бұрын
You need to do voiceovers!!! 🔥🔥🔥
@loresowhat
@loresowhat Ай бұрын
ahaah will think of that as my next step in my career
@vinipowerbi
@vinipowerbi Жыл бұрын
This is so true
@loresowhat
@loresowhat Жыл бұрын
ahah welcome aboard 😀
@olivegodwin9845
@olivegodwin9845 2 ай бұрын
😂😂the last line
@loresowhat
@loresowhat Ай бұрын
ahah do you agree?
@CesarGuevara-hb5lf
@CesarGuevara-hb5lf 8 ай бұрын
Me the whole video: pressing headphones to my ears
@loresowhat
@loresowhat 7 ай бұрын
ahahaha sorry for that, didn't have a mic 🙂
@somenmaji7078
@somenmaji7078 Жыл бұрын
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
@loresowhat
@loresowhat Жыл бұрын
Thanks for the comment and well done 🤩
@JRay2113
@JRay2113 8 күн бұрын
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” 😂😂
@loresowhat
@loresowhat 8 күн бұрын
Ahah that was sharp! That is often the case unfortunately
@JustinSeara
@JustinSeara Ай бұрын
Data Analyst: “where is this data?” Client: “nobody knows…” 🤷🏻‍♂️
@loresowhat
@loresowhat Ай бұрын
Sad story for data analysts 😅
@lyrikalinyoswiminpoo
@lyrikalinyoswiminpoo Жыл бұрын
The most ASMR tech short off all time.. 😂
@loresowhat
@loresowhat Жыл бұрын
haahahahaha
@_aaliyahkc4171
@_aaliyahkc4171 9 ай бұрын
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 🤞
@loresowhat
@loresowhat 9 ай бұрын
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
@modelopapi8617
@modelopapi8617 Жыл бұрын
Fix the volume. We can turn down if we need
@loresowhat
@loresowhat Жыл бұрын
Will do thanks for the feedback 😉
@dccd673
@dccd673 2 ай бұрын
I read the whole thing about the certification and they did say excel or sheets is used. They also said python isn’t used.
@loresowhat
@loresowhat Ай бұрын
not sure how followed this comment sorry
@holasoynico165
@holasoynico165 Жыл бұрын
Amigazoo, muchas gracias por estos videos son realmente de mucha ayuda
@loresowhat
@loresowhat Жыл бұрын
Thanks 🙏
@russellcayetano913
@russellcayetano913 Жыл бұрын
Very true!!!
@loresowhat
@loresowhat Жыл бұрын
Glad you agree Russell 🙌
@vdg6184
@vdg6184 2 ай бұрын
Its less that they dont know where the data where it is and more they usually dont even know what they're asking for.
@loresowhat
@loresowhat Ай бұрын
wow I cannot agree more ahah
@exceldemystified
@exceldemystified Жыл бұрын
value added
@loresowhat
@loresowhat Жыл бұрын
Glad you liked it 😉
@hossamamin671
@hossamamin671 Жыл бұрын
Love ur voice
@loresowhat
@loresowhat Жыл бұрын
Ahah thanks 🙏
@rotimi9501
@rotimi9501 11 ай бұрын
increase the volume i thought my speaker was broken
@loresowhat
@loresowhat 10 ай бұрын
sorry about that, this was one of my first videos so hopefully in the recent ones the audio is better
@moagitshabalala8625
@moagitshabalala8625 3 ай бұрын
Lmfaooo 😭 this part
@loresowhat
@loresowhat Ай бұрын
do you agree?
@parulandpihu9312
@parulandpihu9312 5 ай бұрын
So true
@loresowhat
@loresowhat 5 ай бұрын
glad you like it 🙂
@user-fb7rg9bh3v
@user-fb7rg9bh3v 9 ай бұрын
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 :)
@loresowhat
@loresowhat 9 ай бұрын
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
@spark.99
@spark.99 8 ай бұрын
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.
@giebbieserah4440
@giebbieserah4440 7 ай бұрын
​@@spark.99by development you mean business wise?
@IsaacAtap
@IsaacAtap 4 ай бұрын
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?
@loresowhat
@loresowhat Ай бұрын
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/
@harneet_284
@harneet_284 Жыл бұрын
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?
@loresowhat
@loresowhat Жыл бұрын
Hey reach out to me on Instagram at loresowhat
@ron101346
@ron101346 Ай бұрын
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!
@loresowhat
@loresowhat Ай бұрын
Totally agree 👍
@abrilgonzalez7892
@abrilgonzalez7892 11 ай бұрын
Más argentino que maradona. Jaja gracias por el video. Exelente video
@loresowhat
@loresowhat 11 ай бұрын
😂
@canttouchthis421
@canttouchthis421 9 ай бұрын
❤❤❤
@loresowhat
@loresowhat 9 ай бұрын
Good to see you in the channel 🙂
@shwetaaswal3383
@shwetaaswal3383 Жыл бұрын
Thanks for the information. Do i know ai will replace data analyst jobs. Its pretty much in hype, whats your opinion on this
@loresowhat
@loresowhat Жыл бұрын
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...
@JesusReigns7
@JesusReigns7 Жыл бұрын
Low sound bro
@loresowhat
@loresowhat Жыл бұрын
thanks, will keep in mind for the next ones 😅
@blkboyjoy7472
@blkboyjoy7472 Жыл бұрын
This does not scare me away. I still want to be a data analyst
@loresowhat
@loresowhat Жыл бұрын
Let’s gooo then
@AyubA-qh4by
@AyubA-qh4by Жыл бұрын
Is there anything to do with microsoft power bi ?
@loresowhat
@loresowhat Жыл бұрын
What you mean by that?
@larryobedmogaka8242
@larryobedmogaka8242 10 ай бұрын
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
@loresowhat
@loresowhat 10 ай бұрын
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.
@damianooi8261
@damianooi8261 Жыл бұрын
So to get into data analytics as a non IT background person, I need to master excel skill first?
@loresowhat
@loresowhat Жыл бұрын
yep, I'd recommend to get comfortable with Excel before jumping on other more complex tools
@milkboccle
@milkboccle Жыл бұрын
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
@dierdrecole8027
@dierdrecole8027 6 ай бұрын
I really wish I was smart enough to do this
@loresowhat
@loresowhat 5 ай бұрын
you are definitely smart enough!!!!!!
@rainerpavletic4814
@rainerpavletic4814 10 ай бұрын
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.
@loresowhat
@loresowhat 10 ай бұрын
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!
@rainerpavletic4814
@rainerpavletic4814 10 ай бұрын
Thank you so much @@loresowhat . Wish there's a way to communicate with you. I have a million questions.
@Christian-vc5qv
@Christian-vc5qv Жыл бұрын
I just started a course I'm not sure if I'm smart enough to do this I don't really understand exactly
@loresowhat
@loresowhat Жыл бұрын
It’s normal to feel insecure and that is when you learn the most and push yourself to the limit so keep it up
@Hi-ok2yc
@Hi-ok2yc 11 ай бұрын
Facts!!!!!!
@loresowhat
@loresowhat 11 ай бұрын
you got it!!
@mendozosa
@mendozosa 7 ай бұрын
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
@loresowhat
@loresowhat 7 ай бұрын
Yep I do that too 👍
@PonderP378
@PonderP378 Ай бұрын
oh my I need to master excel hehe
@loresowhat
@loresowhat Ай бұрын
You got ittttt 🙂
@annarocha9769
@annarocha9769 10 ай бұрын
True
@loresowhat
@loresowhat 10 ай бұрын
glad you agree 🙂
@user-oo5ct9tb2b
@user-oo5ct9tb2b 2 ай бұрын
Italians have the same accent as Argentines when they speak English lol😂
@loresowhat
@loresowhat Ай бұрын
ahaha you are not the first person telling me ahah
@itznikhil.k
@itznikhil.k 11 ай бұрын
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
@loresowhat
@loresowhat 11 ай бұрын
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.
@itznikhil.k
@itznikhil.k 11 ай бұрын
@@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
@aurelia160
@aurelia160 Жыл бұрын
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?
@loresowhat
@loresowhat Жыл бұрын
It really depends on the project. Sometimes the data is readily available and sometimes it’s just a nightmare to get it…
@aurelia160
@aurelia160 Жыл бұрын
@@loresowhat thank you for your reply!
@mariaserra7799
@mariaserra7799 Жыл бұрын
I spend so much time in excel with the data 😭😩
@loresowhat
@loresowhat Жыл бұрын
Same here Maria, I feel you 🤣🥲
@pinki_raghuwanshi
@pinki_raghuwanshi Жыл бұрын
How much work pressure? Maria data analysis
@jebbmolina2074
@jebbmolina2074 Жыл бұрын
omg im stuying data an now
@loresowhat
@loresowhat Жыл бұрын
Let’s gooo
@jjvs9
@jjvs9 Жыл бұрын
damn this sounds like a fucking sick job dude, thanks for taking away all the bullshit!
@loresowhat
@loresowhat Жыл бұрын
Ahah glad it was helpful 👍
@jonasortiz6652
@jonasortiz6652 4 ай бұрын
So excel is better than googles and how much different is it I’m just wondering because I’m interested in this feild
@loresowhat
@loresowhat Ай бұрын
if you mean excel vs google spreadsheet then yes, excel is probably better for data analysis
@ifeoluwaadekoya9415
@ifeoluwaadekoya9415 Жыл бұрын
Please can you differentiate data analytics from financial analysis? And does data analytics help someone becoming a financial analyst?
@loresowhat
@loresowhat Жыл бұрын
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.
@ifeoluwaadekoya9415
@ifeoluwaadekoya9415 Жыл бұрын
@@loresowhat yes it does. Thank you so much
@eddielawrence5612
@eddielawrence5612 4 ай бұрын
Averagely how long does it take to learn Data Analytics?
@loresowhat
@loresowhat Ай бұрын
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/
@migcutio9770
@migcutio9770 9 ай бұрын
How can I get hired on as a data analyst? I have some Google certs but very little experience
@loresowhat
@loresowhat 9 ай бұрын
Work on a portfolio and build credibility with your resume and Linkedin, if you text me on instagram I can help 👍
@thetruthshouldbeclear8602
@thetruthshouldbeclear8602 4 ай бұрын
Wow, I will not be doing this !!!
@loresowhat
@loresowhat Ай бұрын
there are pros and cons
@twoguys625
@twoguys625 25 күн бұрын
how much do you earn per year excluding bonuses
@loresowhat
@loresowhat 8 күн бұрын
I earn 6 figures base in pounds but I’m not able to share the exact figure here
@twoguys625
@twoguys625 6 күн бұрын
@@loresowhat so your saying it varies?
@originalpollution
@originalpollution Жыл бұрын
Is the career time worth the pay?
@loresowhat
@loresowhat Жыл бұрын
In my humble opinion yes, very good pay 💰
@RonalRomeroVergel
@RonalRomeroVergel 8 ай бұрын
how much bruh@@loresowhat
@KandisSJGroup
@KandisSJGroup 5 ай бұрын
I'm not hearing a word... You need to do a bedtime podcast
@loresowhat
@loresowhat 5 ай бұрын
ahaha that can be a good plan for 2024. I got a mic now so should be better
@giuseppeamenta1390
@giuseppeamenta1390 9 ай бұрын
Unfortunately, It's a true story, also in my strange work's reality.
@loresowhat
@loresowhat 9 ай бұрын
glad it reasonates Giuseppe 🙂
@samsonokeke6726
@samsonokeke6726 Жыл бұрын
So how do one start looking for raw data?
@loresowhat
@loresowhat Жыл бұрын
you could do webscraping to create your own dataset and then clean it up yourself, or you can even search online for datasets that are not 100% clean
@RachelLuka-wo6ee
@RachelLuka-wo6ee 29 күн бұрын
Pls can u teach me what data analytics is all about
@loresowhat
@loresowhat 8 күн бұрын
Sure, all of my videos in my channel are free and should give you a good idea 🙂
@lelachristine86
@lelachristine86 4 ай бұрын
Well this is very off putting, but at the same time we NEED to hear this!
@loresowhat
@loresowhat Ай бұрын
exactly, there are pros and cons
@Kent-hs9ln
@Kent-hs9ln 9 ай бұрын
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
@loresowhat
@loresowhat 8 ай бұрын
Nice work! and happy to mentor if you need help, you can text me on ig
@Kent-hs9ln
@Kent-hs9ln 8 ай бұрын
@@loresowhat ok thanks for the reply
@ewurabenakoomson7437
@ewurabenakoomson7437 9 ай бұрын
This just scared me not to attemptb😢😂
@loresowhat
@loresowhat 9 ай бұрын
oh no!! it is still a very good career path in my opinion
@VHMLDL
@VHMLDL 6 ай бұрын
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.
@B7k7n
@B7k7n 6 ай бұрын
Please I want to learn more can you explain more please
@loresowhat
@loresowhat Ай бұрын
never heard a data scientist doing all of that ahaha
@mochigirl23
@mochigirl23 Жыл бұрын
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.
@loresowhat
@loresowhat Жыл бұрын
Glad it helps 🙂
@Yuckyou00
@Yuckyou00 Жыл бұрын
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?
Data Analyst Certificates Are Dead
5:38
Learn with Lukas
Рет қаралды 415 М.
How I Became a Data Analyst Without Experience
7:55
Ian Klosowicz
Рет қаралды 2,2 М.
Bro be careful where you drop the ball  #learnfromkhaby  #comedy
00:19
Khaby. Lame
Рет қаралды 50 МЛН
Cat story: from hate to love! 😻 #cat #cute #kitten
00:40
Stocat
Рет қаралды 15 МЛН
Data Analyst vs Business Analyst | Which is Right for You?
8:40
Justin Shin
Рет қаралды 192 М.
How to crack a data analyst interview in 3 simple steps.
6:39
Ashwani Panwar
Рет қаралды 556
How I'd Learn Data Analytics in 2024 | 3 Month Plan
11:42
Rohan Adus
Рет қаралды 280 М.
The ONLY Data Analytics Portfolio You Need (GUARANTEED Job)
9:18
Learn with Lukas
Рет қаралды 130 М.
Data Engineer vs Data Scientist #shorts
1:00
Income Interviews
Рет қаралды 1,5 МЛН
Is Data Analyst a Good Career?
10:24
codebasics
Рет қаралды 201 М.
Exclusive: EY 2021 Power Bi Developer Interview Revealed
30:11
KSR Datavizon
Рет қаралды 321 М.
Why EVERYONE Is Struggling to Become a Data Analyst
8:03
Learn with Lukas
Рет қаралды 252 М.
Bro be careful where you drop the ball  #learnfromkhaby  #comedy
00:19
Khaby. Lame
Рет қаралды 50 МЛН