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 😂
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.
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.
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.
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.
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.
There are a lot of videos on RU-vid for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc
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.
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
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!
“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!!
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/
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
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” 😂😂
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
the reaction to me making a powerBI report will drill through and row level security: 😐 those same people reacting to me making a pivot table in excel on a call: 🤯🥳🥵🥵
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?
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...
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.
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!
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
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.
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/
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.
Uhm..im finishing my masters degree in big data analytics in 6 months. I had never used excel before (i come from healthcare), nor am i using it now, it’s all sql and py.. is it of paramount importance to get a job? Do you find it a stressful job overall?
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.
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
Hey there! Data analysis courses can be totally worth it if you're looking to build or sharpen your skills. Choose a course that fits your current skill level and future goals.
Hey Intisar! Absolutely, being an introvert doesn't limit your career choices. Data Analyst roles often involve a lot of individual focused work like coding, data cleaning, and analysis - things that many introverts might find enjoyable. However, keep in mind that you'll also need to communicate your findings to others, often through presentations or reports. But don't worry, these are skills that can be learned and developed over time.