Thanks so much for the thoughtful comments! Feel free to connect with me on 📷instagram: instagram.com/agathaakang/ and through my 📬newsletter: agathakang.com/subscribe (free resume template in link)

@haroldolu

4 ай бұрын

Hi Agatha, do you have template of the design document you use

@fang-wenhsiao2696

4 ай бұрын

Same here! please make a video about how to work on the design document 🙏

@agathakang

4 ай бұрын

​@@haroldolu hey this is on my list! Let me work on putting together an example with a video and template to share with you guys

@agathakang

4 ай бұрын

@@fang-wenhsiao2696 Yes! I'll work on putting together a template and video for you guys!

@fang-wenhsiao2696

4 ай бұрын

thank you!!@@agathakang

Data analyst: part detective, part magician, turning numbers into trends and coffee into insights!

@agathakang

Ай бұрын

Exactly!! 🙌

Honestly, managing other people's unrealistic expectations and lack of direct clarity in their communication (often not even knowing what they themselves want) and presenting layered and complex patterns and hypotheticals as simple, "user-friendly" concepts is already my full-time job as an autistic person just living in society, so tbh I feel like I'm built for this. 😅

I'm a data analysis and just making 60k and my work has me on 6 different projects. I rarely have any energy left at the end of the day. Not all employers are made equal...

@joshwilliam178

Ай бұрын

Can you be my mentor please, I just got into studying data analyst, currently learning excel and SQL. I would appreciate a mentor to guide me and give me various tips and help, I can also help with doing some of the little task if you have any for me. I would really appreciate the knowledge and impact

@supernova622

10 күн бұрын

​@@joshwilliam178asking someone to be your mentor on the comment where they lament being overworked and exhausted is... a choice.

@backtoasimplelife

4 күн бұрын

...is completely disconnected. ​@@supernova622

Having jumped into learn data analysis to change careers I have noticed something. Learning the tools is fine. Understanding the hypothesis or problem question makes sense. Maybe you've done it already, but I haven't really seen anyone make a portfolio project showing a problem, and how their dashboards solves it. I think it's hard when practicing with kaggle data to find a problem and solve it. When learning I practiced the usual orders customers shipping type queries, but they never really explain what they would do in the office with the results. Maybe those get emailed in a report? I don't really know. I finally get that they are practicing with 20 lines to teach us the basics, when in reality it might be 100,000 rows. Thank you for your videos, honest insight, and resume template. I really appreciate your work!!!

@agathakang

4 ай бұрын

Hey this is really good feedback! I tried to incorporate it in this video with how a dashboard solves a problem and how it is used by the company: kzread.info/dash/bejne/g3yNt7d7kdrYnsY.htmlsi=xgXK0aA0KFjvZ0ky I hope it helps!

Agatha, thank you for your videos and the time you put on them. As someone who is currently working on changing careers you paint a pretty good picture of what to expect. Would love to see a video about ways in which you have improved your soft skills.

The Design Document was interesting. I’m learning SQL and Tableau to make a shift into Data and this was very informative. Thanks

I similarly have 10 years as an analyst and now Business Intelligence Manager -- I found this incredibly helpful in articulating what I do. I've always struggled with my elevator pitch, "What do you do?". Thanks for the assist!

Thank you for this video! I am on the path of becoming a data professional. My goal is to switch over from tech support specialist roles! Your videos help me gauge how to further my growth and development. I love the part where you including design documentation. Thank you again!

Great insights into the realities of being a data analyst! Thanks for sharing your experiences and shedding light on the profession's true challenges and rewards. Very informative and eye-opening!

hi Agatha, nice content, I'm also a Data Analyst from Indonesia and what you tell in this video is very similar with my work, thankyou for sharing this 👍

Thank you so much for this! I’m currently thinking of switching careers. Even though my job is challenging, I believe it will help me strengthen my soft skills as well as executive presence. Thank you again!

very insightful as an aspiring data analyst. thank you agatha!

Love your smile and composure on the camera

Thank u so much for ur helpful sharing ♥️ happy new year wish u all the best Alaga 🍓

@agathakang

4 ай бұрын

Thanks so much and happy new year to you too!

awesome video💓 U r sharing real life experience that actually feels real 😅. watching your videos makes me feel like getting advice from a close friend in person, someone who shares every nooks and corners. please share about how you manage everything in life in the aspects of planning

@agathakang

4 ай бұрын

First comment :) thanks so much! I want to share more of my real experiences as a data analyst with you guys so I'm glad this was helpful!

very encouraging and honest, please keep it up agatha you are such a blessing

@agathakang

Ай бұрын

🙏 thank you so much and so glad the video was helpful!!

I love the mentorship you have provided but just deep dive into little technical details for beginner data analyst.

Great video, I'm looking to get into this career.

Wonderful video and quite informative! Thank you for a clear understanding of what you do (: im coming from an HR background and looking into people analytics. Although it's a bit different, I believe the same skills would be transferable.

Informative video - you have a great smile!

Thanks for the video. I'm 38 just finished Google data analytics certificate. I was thinking of taking the more advanced courses but after watching your video I believe it isn't worth it and I should go down another road. Thank you so much! I feel like you saved me a lot of time.

@BlaqueKotton

3 ай бұрын

I was wondering the same thing. By a different road do you mean a different career path or just going straight to applying for jobs?

@businessman6104

3 ай бұрын

​@@BlaqueKottoncareer path. I'm going to take project management course then take it from there. I feel like perscholas is more practical for someone my age. If I was in my 20s I'd be all over the data analyst course, but at 38, it just feels like it would take too long to get a good job in that field.

@Canadian-Boi-

2 ай бұрын

She just told you the salary is 100-200k after your certificate and you are turned off it now? :S

@JackFate76

Ай бұрын

@@businessman6104 Maybe actually learn something like baking or carpenting or something. The things you are looking at are all BS jobs.

@businessman6104

Ай бұрын

​​​@@JackFate76baking ot carpentry? Gee thanks for the advice. I'll be fine. Only thing bullshit is your trash advice

Thank you so much for all the information.

@agathakang

4 ай бұрын

You are so welcome!

Thank you so much for all the information.😊

@agathakang

4 ай бұрын

You are so welcome! 🤗

Wow! first hand information, thanks

Thank you! I am considering a career switch and your video has really helped me to stay convinced about it!

@agathakang

25 күн бұрын

You’re welcome! So happy to hear it helped

Thank you for your video! I am about to graduate with my masters in applied data science next week and this gave me more clarity that I’m going for the right role for me!

We need the video of the differences between data analysis data engineering and data science. Thanks for your effort really great video!

@agathakang

4 ай бұрын

Thanks so much 😀 and yes adding it to the list!

I'm currently in school for supply chain and operations management, there is a LARGE influence of data, excel, creating visualizations. The more I learn about it, the more I can see how incredibly important it is for data analysts to exist. I became very interested in the field and now strongly considering becoming at least a junior data analyst

your videos are so so helpful thank you!!

@agathakang

4 ай бұрын

You’re so welcome! Thanks for watching!

New subscriber here and first watched video of yours. As a 24 year old switching from a sales background to becoming a DA or BA, this is such great video. Going to watch your other videos!

@agathakang

3 ай бұрын

❤️ thanks so much for watching! So glad the video is helpful!

i love the way you explain things i hope you made guided project for us with sql and power bi and python

Hey! Have been loving your videos as they’ve been helping me in my journey to become a data professional. You’ve mentioned your design/workflow document in a video before - are you able to share a template version of that?

The “What is the realistic life” like part is spot on! Overall very good overview.

@agathakang

Ай бұрын

Glad you relate!! Thanks for watching!

Definitely would like to know more about salaries, great vid!

I would love to know more about how you decided to start your career as a data analyst. You mentioned work-life balance as a factor, but you didn't mention a solid reason. Speaking for myself, I got interested in data analysis because I was good at focusing on neglected details like observing ingredients or calories on food products. Fortunately, I had experience using Excel in college which helped me take my data analysis journey to the next level with pivot tables, querying data, data visualization, and so on. I suggest that you create a video on why you chose data analysis as a career.

What qualifications and/or certifications do you think would be best to get started? I have a business degree and advanced/high level excel experience and I'm trying to learn R and Python currently. What would you recommend for a beginner transitioning from that background? Enjoyed your video. Very well presented. thank you

Learning how to train stakeholders to explain what they're trying to accomplish versus telling me what they want was huge for me. Great video!

@agathakang

2 ай бұрын

This one took me time to learn too! Glad it was helpful!!

Hello! this is very informative. I would like to also see the different job titles or domains.

I’ve been thinking about becoming a data analyst but I have a few concerns about what kind of data analyst and if it’s right for me. My main concerns are having enough time to pursue my hobbies. Which I don’t expect to goof around so much once I’m in the workforce, but I want to carry my hobbies into adulthood. I am also concerned that my ADHD could impact my performance, but I think training and getting experience with activities related to data analysis could solve that question. My main reasons for being interested in this job is because I think it would suit me well, and the paycheck can hopefully fund my interests and hobbies as well as every day life. It also seems to allow flexibility in lifestyle since you can work remotely. Does anyone have advice on how to find what kind of data analyst would be best?

Thanks for this video. I’m currently a Revenue Cycle analyst and want to transition into a healthcare or data analyst. But you’re right, the work life balance is the best part plus a good income.

@agathakang

4 ай бұрын

Agreed! A career is only worth it if you can still enjoy your life 😄 work life balance is so important!

Hi Agatha, Just loved this video! As a person who is waiting to get a data analyst job, this video motivates me. This is the first time I am watching a video of yours ! Love at first sight.. ❤

@agathakang

3 ай бұрын

So glad this video was helpful and you enjoyed it. Thanks for watching! ❤

Hi Agatha, can you put together a video that explains the knowledge a junior data analyst should have in terms of statistics. I did an assessment which totally wrecked my confidence in my skills. I didnt know much about P-value and methods of doing analytics, and what are the most common metrics that are used to measure performance. please help :(

@apamwamba

3 ай бұрын

P-Value is best learnt by looking at a picture of say two tailed and one tailed hypothesis testing. The actual definition puts me off but the pictures make it more intuitive.stats.oarc.ucla.edu/other/mult-pkg/faq/general/faq-what-are-the-differences-between-one-tailed-and-two-tailed-tests/#:~:text=In%20this%20example%2C%20the%20two,of%20our%20choice%20of%20tails.

Hey Agatha, I found your idea for Design Document is fantastic; do you have to have a video that explains it further? Or some sort of a template to start with? I struggles with documenting it in writings and it take a while to dug what the report or excel is all about from my subconscious.

Salary video would be fantastic.

@agathakang

3 ай бұрын

Yes this is definitely on the list! I have one comparing 5 different data salaries in the next 2 weeks and will do a dedicated salary video and talk about what it encompasses

@49erman2

2 ай бұрын

Plenty out there man

@marmalar

Ай бұрын

This really sounds like she will not disclose her own salary. I am really tired of people being uncomfortable with disclosing their actual numbers.

Hi Agatha thanks for sharing .. just want to ask you how many months of under training,learning u say that u ready for this career and u can apply for a data analytics job? Thanks for answering the question ... Im taking a data science course for the 3rd month now

You touched on reporting briefly, I am curious what that looks like? Do you have to present your reports to groups of people? I interested in the technical aspect of the job and am fine with small group conversations, but speaking to a group as a presenter is my worst nightmare.

You are beautiful and beautifully explained what I needed to know about being data analyst.

As a high school drop out who later obtained a ged to go to college only to realize I’d be better off teaching myself my career that’s best fit for me, definitely enjoyed this video, gave me the confidence to research more in depth and also most importantly make the career change I need in my life rn thanks for the video.

I love that you posted this 4 days ago as I have recently caught an interest in becoming a data analyst. Definitely gonna research a lot and study some basics before I go to school for it. Thank you for this!

@agathakang

4 ай бұрын

You’re so welcome! Glad it was helpful!

Hey it would be really helpful if you can tell me if becoming a data scientist is hard or not,i am currently in my 3 year of my college and trying to learn more about this field,did you hit any obstacles and if so how did you overcome it

honestly this the field I really want to specialized on

Yes, also a salary video just on your career and also if you did negotiate how do you negotiate your salary due to the fact you were new to the industry I’m getting into US UI design and I’ll be new but I have a lot of digital marketing and social media marketing experience and I want to know like how would you negotiate properly for a higher salary closer to 80,000 to 6 figures

I think a separate video on Salary alone would be great and highly solicited! Thanks in adv.

@agathakang

3 ай бұрын

Yes salary video has been requested a lot! Will work on one and see how I can make it valuable for you!

All good stuff! Yes to managing unrealistic expectations and they really don’t know what they want sometimes - in all jobs!

@agathakang

4 ай бұрын

Thank you for watching ♥️

Hi @agathakang, do you have any advice for getting started as a Data analyst? I have a masters in a computational science that includes data analytics as well as a few projects under my belt but I get looked over for entry level jobs because I don't have any experience :/

very helpful . id love to know more on what i should work on first.. i signed up for a short course on Tableau, let me know if im on the right track. thanks alot , much love from singapore.

Is there a lot of math in this job and what is the level of math difficulty?

I have a lot of analysis and visualization skills but very little pipeline/engineering skills. Do you have any recommendations on how to add these skills to my toolskit?

Thanks for sharing. If anyone has any tips for a teacher looking into this field and project management, I'd be really appreciative. I'm currently a teacher looking into a new field. I feel that I have quite a skill set I can readily transfer, considering my job the last several years has been analyzing data, creating a plan, and responding to the data in order to achieve results for my stakeholders.

great video. im looking for a job career change for myself,. mortgage is dying business.

Im starting some courses in data analysis. Do you need to fully learn SQL and Python, or just learn a bit?

The hard skill of a data analyst is more likely about the variables change and doing some graphs for a specfic group of the dataset

Can you make a series how to develop from zero to full data analyst? Am trying to learn thin and power bi. Not sure if on the right track.

Hey ma'am This video is really helpful for me as I am thinking for majoring big data analytics in the near future it cleared all my doubts and every question I had Also I would really need your help here as in is there any community of data scientists or like a discord server or something like that where I can meet experienced and skilled data analyst like you and have a good talk and a better idea how to start from zero. Thank you!!

I am learning sql and tableau and honestly I love it even if I’m still learning and don’t understand everything.

@agathakang

3 ай бұрын

I love this! you don’t have to be an expert and you’re on the right path of “doing” ❤️

Hi @agathakang Agatha, thanks for sharing what it's like to be a Data Analyst in the real world, I would like to ask what software you use in putting the scope of work you showcase in this video together, I know it's not a word document, but I find it quite fascinating, and I will like to add it to my toolbox, as I'm looking forward to landing my first job as a Data Analyst sooner than later.

@agathakang

3 ай бұрын

Hey! I was using quip - which is just a cloud based word document. It's good for working collaboratively with teams. You can check it out and I find it helps because it's a cloud based tool to access anywhere

@KanmiTitusFx

3 ай бұрын

Hi@@agathakang, thanks for the swift reply, oh it's even better getting to know it's a cloud-based word document, I will definitely check it out.

Watching from Africa....can you suggest a better career between data science and data analyst

I hope you make at least 75k

I love being a data analyst! I couldn’t think of a better profession. I’ve never have problem with urgent tasks, my bosses always set the boundaries to protect the team, so WLB was amazing since the beginning

@Lolahahaha11

Ай бұрын

This is due to the culture at your company, and definitely not the job.

@anapslima

Ай бұрын

@@Lolahahaha11 I have the same environment in three different companies. My guess is that I have worked in structured data departments, with processes in place. If I was the only data analyst or working in a decentralized data structure, things could be different

What is the difference between IT business analyst vs business analyst?

guys i wanna move into this role but don't know how to start, i have zero software background

Data analyst and cybersecurity. I can't decide which to choose.

I think the important distinction in that salary, is that that is FAANG salaries. You're looking at $60-$100k outside of those.

@anunucha

18 күн бұрын

Yeah agreed, with the add on that I've typically seen business analysts paid more. I've even seen (and experienced lol) 45k-65k in the non-profit sector.

Please make a video on salary!

Are you concerned that AI is coming for your job? Honest question. I am studying data analytics and so far I don't see much AI wont be able to do two years from now.

What were the resources you studied while transitioning into data Analytics? And were you learning while working in the business consulting firm?

@agathakang

4 ай бұрын

Hey! I used datacamp (link in description) and linkedin learning as resources. I used basic excel and only select sql statements when I was a consultant so I had to study on my own to get to an intermediate level and prep for the data analyst interviews.

I hope they pay you a combined salary of a DA, DE, and BIA if you have to fix a data pipeline, find the raw data, clean the data, understand the business problems they need you to solve, then reporting it in a visualization/report. Thanks for sharing.

@agathakang

2 ай бұрын

haha you would think they would pay a BIE more than all those roles! The pay is more than a DA as yes you have to do data pipeline work but less than a DE as a DE has more technical back end work

I absolutely love your videos. Could you do a video on data science versus data engineer versus data analyst any clothes some rolls responsibility skills are tech Nicole saw for skills that you need to have in each category and also because you said you do data engineering along with your job too so if you would want to get another job because you apply to data engineering jobs because you have the experience?

@agathakang

3 ай бұрын

Hey thank you! I just filmed a video on this comparing 5 different data jobs. Video will be out in next 2 weeks. And yes my role is a combination of data engineer/data analyst so I could apply to data engineering jobs too. You really have to look at the job description more than the title to see what the role will be

Only thing I disagree with is anyone can be a data analyst. I’m a project coordinator dealing with similar situations on a smaller scale and it’s definitely not for everyone. A lot of people would have a mental breakdown when you have so many demands flying at you. Glad they pay these people well they deserve it!

Sorry I’m a bit confused about the work-life balance aspect. At one point you said when the day is basically over more work can come in unexpectedly. On the other hand you said you prefer this career path because if you make plans to go out with friends for dinner you can count on being able to make the dinner.. so which one applies more now? Do you only have to stay in longer and cancel evening plans rarley? Sorry but this aspect is important to me, so I’d like to know more detail about this matter!

@agathakang

Ай бұрын

The work life balance is generally good. Sometimes there are days I do have to unexpectedly work late but as you get better setting boundaries at work there will be less of those times and more work life balance

Nice content! Please make a video about work flow? Thank you! :)

@agathakang

4 ай бұрын

You’re welcome! I go through a more detailed workflow here kzread.info/dash/bejne/g3yNt7d7kdrYnsY.htmlsi=4H8_wJ55-RpkjO1s

@johannpauldalingay1512

4 ай бұрын

Thank you! ❤

Omg this video

Hi, I enrolled in a bootcamp of data analytics. Can I work in a different country after experience? If yes, how many years of experience is considered ‘good’ to be able to work outside?

@agathakang

4 ай бұрын

Hey! That really depends on the company. I would say having at least 2 years experience in general shows that you can do the job regardless of whether you’re in the country or not.

I can understand the feeling, Getting last minute upgradation (such a irritating issue) 😑😑

@agathakang Do you need to have a computer science degree to have a career as a data analyst? BTW I found this video very informative and insightful.

@agathakang

3 ай бұрын

Hey! No I don’t have a computer science degree either and skills are becoming more important than the degree itself. Glad the video was helpful!

@dianaandrade7229

3 ай бұрын

Thank you so much for answering my question.@@agathakang ❤

New guy here - do you (typically) make major financial business decision based on the data you see? Or you send the data to the company director (or similar)

@agathakang

Күн бұрын

Hey! Typically I don’t make the business decisions rather I provide the data that enables the leadership to make data driven decisions for the company

I’m not a data analysts but work with a lot of data. I’d be lost without Power Query in Excel. Unfortunately, as a Mac person, the Excel for the Mac doesn’t have Power Query. In your video and in a few by others, you use a Mac. Do you have a need for Power Query?

@agathakang

2 ай бұрын

Honestly I don’t use much of excel on my job today so having a Mac is no problem for me. It really varies by what tools the job requires but I use mostly sql and cloud tools so a Mac works fine

The phrase “fire drill” took on a whole new meaning after becoming a data analyst.😅

@agathakang

4 ай бұрын

Haha 😆 I can relate!

pls reply. hey Agatha, can u rate a python 1 out 10, how much is use in data analysis field.

@agathakang

4 ай бұрын

Hey it depends on what type of data analyst/industry/tools available that you will use python. Even within my team, I have seen some team members use python for almost everything whereas others barely use it. Personally, in my role I don't use much python for data analysis and use it more for data engineering tasks like loading data.

🎉

can you say what your salary is? thx

I can confirm that we get asked for reports last minute and even before the information is available. So a partner wants the report about this months project spending and it's still the current month, LOL. So yeah he asked "early" but the info won't be available for days and then it's crunch time. And yes, they also call you at 5 PM and say they to price a project by the end of day so they can present it at dinner with the client... 🤣

Your description of being a data analyst and dealing with unrealistic expectations is a lot like being the only researcher on a team of colleagues who possess limited quantitative skills. They frequently have no idea how much work it takes to produce a "simple graph" (or map). They just think you push three buttons and viola! Data analyzed. They don't understand the data collection process (e.g., running surveys using an actual random sampling procedure, or even just finding administrative data sets), limitations of the data, processing/cleaning the data and so on. Especially if you are doing something new. Thanks for the opportunity to commiserate.

@agathakang

3 ай бұрын

Yes! Sounds like we have the same type of job lol my job entails a lot of research too and data analysis sounds simple but really it’s not!

Can you tell me which one is easy to job role data engineer or data analyst?

@GagandeepSingh-vd9hd

4 ай бұрын

Data analyst

@agathakang

4 ай бұрын

Data analyst is easier as there’s more technical skills you’ll have to know to get hired as a data engineer

How do YOU manage those stakeholder expectations ? I can see a lot of last minute or late nights because of their unreasonable expectations

@agathakang

3 ай бұрын

Good question! This is something I still struggle with but I've learned that having a system for ad hoc work to be submitted and prioritized really eliminates the last minute asks because it is understood by everyone including the stakeholders that the work has to be prioritized through a proper sprint and not just done last minute.

@MichelleLe-om3fv

3 ай бұрын

@agathakang thank you ! Wondering if you can elaborate on this more in a video ? Maybe also discuss how you deal with stakeholders (ahem* aka egos) and if they have issues with your analysis results 🤔

What skills do you usually use most of the time as a data analyst?

@agathakang

3 ай бұрын

The top 2 skills would be SQL and communication. I use SQL pretty much everyday and the job does require communicating with your stakeholders and teammates

@apamwamba

2 ай бұрын

@@agathakang Interesting. So what would you say are your top advanced SQL techniques that you mostly use for Data Analytics

There's no way we'd take a request and work at night outside working hours in France, stakeholders or not, wait until the next day and THEN, we can discuss about it.

@agathakang

Күн бұрын

The work life balance is so much better outside the US and especially in European countries. I definitely wish we embraced that type of work culture here

This is spot on for sure….This helps my wife understand that im not a lazy bum

Salary Video would be great I seen videos where they talk about salary and is discouraging.

@agathakang

3 ай бұрын

Hey, salary really varies by location, experience, and industry but I'm surprised that what you've seen is discouraging. I have a video coming up on 5 diff data salaries and am going to do a dedicated video on this topic!