What do data analysts DO?! Here's a project walkthrough for an entry level data analyst! This goes b

Рет қаралды 487,930

11 ай бұрын

What do data analysts DO?! Here's a project walkthrough for an entry level data analyst! This goes by fast because we're on tiktok, it's okay if you need to pause or rewatch for it to make sense. Any data analytics project essentially boils down to: 1. Locate the data using SQL 2. Select the data using SQL 3. Visualize the data using Tableau 4. Explain the results via email, in a PowerPoint, in a meeting... whatever works for that particular project. For all my recommended resources on how to learn this for FREE, start my free course! 🥰
Check out the FREE data analytics course in my profile 🥰
**If the video got cut off it's because of the 60sec limit on Shorts, you can watch the full video on my TikTok @charlottechaze

Пікірлер: 254

@shantanuchatterji1828 9 ай бұрын

DA here, you skipped the part where: 1. Your boss never asks you a question that direct. It’s usually vague and you have to develop an interrogation technique to get that info out of them. 2. Oh wouldn’t it be so nice if all the data was in one table, never is, never clean, and has a bunch of acronyms that have 0 documentation. 3. Please, please do not just do a select * of everything, you see there are these things called querying/computation costs which will make your data engineer pull their hair out. 4. And finally, once you provide the analysis in a nice dashboard with filters and visuals, your boss will say “nice, can you get me that on excel”

@packrunnerjohnny 8 ай бұрын

Sounds about right😂😂

@bodi.a.r 8 ай бұрын

Thanks for the reality check. Apart from that, can you explain the part about point 3 where you brought in computational costs? What does that mean?

@harrymandel 8 ай бұрын

correct!

@GmeansG 8 ай бұрын

Computational costs?

@pinkmark4047 8 ай бұрын

Also a data analyst here. You summed it up perfectly.

@MattIn3rtia 10 ай бұрын

Yeh, but the reality is usually more like... "what were our sales numbers last year, the data's spread across 3 databases because of the tech migration last year, and Aaron in finance thinks there's been double tracking since we rolled out GA4, so can you iron that out and reduce the total to account for the average value of order returns, but only for new customers, from France."

@Fran-uj9jw 8 ай бұрын

Yeah this sounds just about right 🤣

@noiz1762 8 ай бұрын

Sick. Tbh sounds great

@owenedgson7302 8 ай бұрын

This is spot on. Especially the tech migration... do you work at the same company as me?? haha

@Virg034 7 ай бұрын

Sounds like I need to choose a different field to study 😭

@ci6516 6 ай бұрын

This actually makes me very happy because my intro to database class covers all this including normlization and design . Next year we get to use if statements and while loops for complex queries with many many tables

@kubetail12 6 ай бұрын

At this rate, I think I just want to flip burgers for a living.

@mr.savageryt2613 4 ай бұрын

This just randomly burst me up ahahaha

@TheRussianRob 4 ай бұрын

it can be fun for a while, especially working with friends, but it sucks to realize all u can afford for an hour of your work is a burger (sometimes not even).

@kubetail12 4 ай бұрын

@@TheRussianRob I should provide some context. I have an engineering PhD and I been struggling to get job industry in fields like engineering, data science, and R&D. I do have an engineering job but it entry level and they keep me on the production floor.

@sawney3963 3 ай бұрын

@@kubetail12please don’t give up searching

@TheRussianRob 3 ай бұрын

@@kubetail12 respect and good luck to you!

@kraftp 8 ай бұрын

Now if only entry level/ junior positions still existed

@riomouris4767 2 ай бұрын

I saw a junior data analyst role the other day with a 2-7 year experience requirement 😂 We can only dream

@b.bergeron8769 7 ай бұрын

Just.... ask the accountants for the figures.

@sumrahdin7434 6 ай бұрын

Exactly

@DelightfulPager-ro4nw 5 ай бұрын

Exactly that

@niwnoom 5 ай бұрын

i came here to find out whether i wanna be a business or a data analyst, and i choose databases over human interactions every day ty, all i needed

@Stonk5331 10 ай бұрын

ehhhhm nope, this kind of tasks would go to the junior data analyst to see if they can use a computer

@CharlotteChazeBreakIntoTech 8 ай бұрын

this is an entry level example!

@harrymandel 8 ай бұрын

haha - yup!

@chermichelle3 8 ай бұрын

@@CharlotteChazeBreakIntoTech people love to be quick to try and make a point. But his response literally validated your video. Lol.

@CraigThePoet 7 ай бұрын

Lol exactly

@doritos7134 6 ай бұрын

😂😂😂 I’m a junior analyst don’t do me like this

@jaeen7665 11 ай бұрын

Haha...here's a tip from a data analyst at a top 5 tech company. Literally, as part of my annual evaluation, 75% of my job is interacting with stakeholders. Learn softskills and be curious.

@mad1337nes 10 ай бұрын

Part of the problem (you're it)

@harrymandel 8 ай бұрын

The hardest part - yes. I love to work with computers not people.

@kwill6948 8 ай бұрын

@@mad1337nes explain

@kennylissylifestyle 7 ай бұрын

Please can you be my mentor. I’m a university student from Nigeria and I want to learn data analysis.

@CoryTheSimmons 5 ай бұрын

"muh soft skills" 🤢

@yishihara55527 5 ай бұрын

Imagine all this data presented in Japanese corporate reports with explanations and business strategies. My job is to translate it all. I've had days where I could stop for 36 hours straight due to tight deadlines and suddenly having more work piled on. Most days are between 12 and 18 hours.

@kibzod6040 6 ай бұрын

The comment section is waaaay more informative than the video. Thanks for putting the video, i got soo many answers from the comment section

@Murtaza010 11 ай бұрын

I am just switching my career into data analysis. I have started learning SQL, Power BI, Excel, and Tableau. This short video was helpful for me to know about the non-technological part of this job i.e., something not related to tools and answering "why" and not "how." I needed a mix of both. Subscribing the channel! 👍

@picklenickil 10 ай бұрын

Tell me honestly if you can give me an example of using mean median and mode in real life and don't give it here.. tell yourself.. the answer may help you figure out if this is the right job for you.

@cagataysilverwind33 10 ай бұрын

@@picklenickilsorry mate I was also told him to check AI tools but admin deleted my comment. It seems like now its your turn =)

@adamzeller7979 10 ай бұрын

@@picklenickilI can think of a million different times I'd use mean median and mode

@brontoab1 5 ай бұрын

@@picklenickilI have a mean of 2 bathroom visits per each work day. The median number of screams while taking a dump at work is 3. The mode of the number of people in the men's room is 4.

@AlastorDarkAngel 8 ай бұрын

Sounds like the career for me! I understand this is an entry level example but doing this from home sounds like bliss

@blockchainbreakdown2009 10 ай бұрын

I'm working through a SQL workbook right now. My problem is my schedule is so hectic that I usually have a week or 2 on and a week or 2 off studying, and every time I go a few days off I feel like I forget everything.

@brandonwarfield5611 9 ай бұрын

Could you give me the name of the workbook your working from. Can I get it from amazon. If you don't mind, please!

@mjs2320 10 ай бұрын

Or just log into your CRM and it’s literally in the sales dashboard which is the first thing you’ll see.

@quinnhogan545 10 ай бұрын

Who is gonna configure that for you? Who do you think built any CRM data model?

@ravenoftheredsky 10 ай бұрын

Better to gather the raw data and scrub if you are allowed and have the time

@slothner943 10 ай бұрын

Lol 😂 its like saying car mechanics isnt needed because you only need to turn the car on 😂😂

@MattIn3rtia 10 ай бұрын

Ha. That's funny, but there are a lot of companies that don't store their sales data in hubspot

@purpsonus 10 ай бұрын

@@wt2219tbf in many companies, a person must have both skills in data analysis and data engineering. At least from my experience. Yea of course a monkey could do what she said, but you need to know the other stuff to make money. Probably different in a large company where they do hire monkeys for data analysis 😂

@JeredtheShy 10 ай бұрын

Oh yeah I can definitely use public stock stuff for practice data

@papamaples617 3 ай бұрын

Yeah cause Oracle tables are always clearly named with logical joins

@makemoneywithjoannaleyan 6 ай бұрын

great tip! Thanks for sharing your insights.

@saritaGupta3699. 11 ай бұрын

Thank you so much love from India 🇮🇳❤❤

@carlodelfavero401 9 ай бұрын

Basically sales manager Monday morning

@ThEDyLnCaLi 5 ай бұрын

You missed the part where you realize this table has none of the variables your looking for, so you have to spend time investigating how these tables and fields are calculated. Then spend more time validating than actually generating the report. Oh yea, last step: realize the new variables you cane up with don't align with what youd expect to see in the validation phase so you return back the the analysis phase and repeat the process. One additional step for extra credit: Turn the project in to the necessary stakeholders, and get asked for additional requirements that are out of scope

@basilicon. 9 ай бұрын

im no data analyst (im more into machine learning) but ive heard a lot of what data analysts do is draw conclusions from data. lets say you take all those points on from the database and you turn them into some kind of graph. in some cases you have to then explain to non data analysts what different trends in data mean (such as a rise of sales with time, etc). some trends in data are very difficult to visualize though. imagine trying to make a diagram which shows how 5 different variables relate with one other one; it would typically difficult to find and probably even harder to understand semantically.

@thatoneguy8894 8 ай бұрын

Lol leaving the payment info (credit card numbers) visible is top tier. Gonna go order me a new pair of boots!

@aliveandwell3958 6 ай бұрын

OMG I just noticed that. 😵‍💫

@Same_ol_jee 5 ай бұрын

😂😂😂😂😂😂

@ninadbhoir2878 5 ай бұрын

I wish if knowing just this would land me a job

@addi4prez 10 ай бұрын

Why do you have sales for different months in different tables? Just standardise the rows and put them all in one table for easier querying across larger timeframes

@TimeLady8 9 ай бұрын

As a bookkeeper, I'd pull a Profit and Loss and/or a Sales by Product/Service Summary.

@RenardThatch 8 ай бұрын

Tldr at a fundamental level it's just searching at an advanced level, bonus points if you get to write data to the table and do testing for product integrations.

@rickylino1267 8 ай бұрын

I get what she’s trying to do but it can be very misleading for newbies… it’s like telling people Print(“Hello World”) is all Python coding is about.

@d0cn0tes 4 ай бұрын

Agreed… she not building and just using view of 2021 figures However I do applaud her effort

@shuvampal7290 9 ай бұрын

It's pain. If a project need 14 days to complete, out of these 14 days 10 are require to understand the data, it's granularity, each col calculation, unpivot the data, clean it, trim it, create view, check the view then finally create your desire project

@vinodgujja4268 11 ай бұрын

Wish the underlying database is as simple as that and if so all data analysts would loose jobs with genAI

@postapocalypticnewsradio 8 ай бұрын

I didn't know this was a job. I want this job. Where do I go to acquire this career?

@osiris7945 7 ай бұрын

do you have any videos that related to what tools DA beginners need in order to run their task & solving a problem? thanks!

@prakharchawla 5 ай бұрын

This is what anyone with Salesforce access can do on excel. Loll if DA is this no one is paying them anything.

@westervoorde 10 ай бұрын

Or.....1500 rows of code because all business processes where never designee with data analytics in mind 😅

@m77mo65 9 ай бұрын

Thats true, you would work with db 90% and 10% python or any like..

@blacklight3330 6 күн бұрын

Basically, you just replace an accountant

@mthompson863 4 ай бұрын

I'd like to ask the question? What would be the best direction to going about obtaining the necessary training for this as Microsoft no longer offers their dba certs?

@sterlingphoenix71 7 ай бұрын

With sql studio the data you will need to answer the question comes from synchronizing the sql software with actual company data?

@IronCardinal181 9 ай бұрын

Data Analyst RULE!!!

@loveobviously 11 ай бұрын

I’ve always wanted to know that too. I’m like this seems like a cool job but I have no idea what I do like I need to actually visually see it.

@andresitomanuel 10 ай бұрын

Learn sql,excel and python for data analytics. Then learn stuff like power bi or tablou for data visualization.

@farzanhussain9427 5 ай бұрын

She made a PPT for this. This is how you would know she is a real Analyst.😁

@mdshahadatkabir7536 8 ай бұрын

make more video like this please what data analyst do,how to become, Daily in life. life from Bangladesh 🇧🇩

@boops5249 9 ай бұрын

Is the problem statement depends on the stakeholders or the data analyst also needs to do that on their own sometimes ?

@snappypanda8258 6 ай бұрын

Stupid question but why did you put the command on the 3rd line or does it not matter where you put it?

@idcrafter-cgi 10 ай бұрын

why not like make a script and add an Large language model to it that is fine tuned on your past reports to get money without lifting a finger

@archiewoosung5062 6 ай бұрын

Why would you have a table called sales2021 rather than have a table called sales with a column for the date? Would the sales table really include details for the 'cost'?

@fred0356 5 ай бұрын

Your using sql just write a program to bring that data in useful.

@msm782 6 ай бұрын

That select * 😂…

@swankyshivy 3 ай бұрын

what will happen if they asking a question and the data points dont exist

@abhinandanagrawal3568 10 ай бұрын

Hi Lots of love from India I also aspire to be data analytics and I am currently pursuing it. Please make a video on more such topics as this is so much fascinating.

@mohitmahajan7624 6 ай бұрын

Hey dude, from which source u r learning? And are u from Non-technical background meanwhile i m stepping to complete my graduation in 2-3 months and plans to learn Data Analyst so if u also light me then it's really helpfull 😊

@abhinandanagrawal3568 6 ай бұрын

@@mohitmahajan7624 I am doing it from IIT Madras and just will say that do it. It is interesting if you are loving the numbers and it fascinates you then go for it Strengthen your calculus and statistics to strengthen your base

@mohitmahajan7624 6 ай бұрын

@@abhinandanagrawal3568 Yes Bhai♥️, firstly thankyou so mch for such precious points bt i m persuing Bcom degree nd what's the criteria to enter in IIT or any other well known institute for non technical background students.? Becoz in this specific field i m totally new one Is it only the way to learn this all skills & what's the scope to gain the good position in MNC's.💯 😊"Thanks in advance. "

@abhinandanagrawal3568 6 ай бұрын

@@mohitmahajan7624 so u can pursue data science degree by enrolling in online degree courses offered by IITs like Madras and also recently by guwahati this will be best for you Also before joining the degree courses ssee the syllabus and pyq for the clarity

@mohitmahajan7624 6 ай бұрын

@@abhinandanagrawal3568 ok bhai bt what is the duration of the course? Nd are u doing data analyst or data science in IIT Madras? Wht abt Fess structure? Is it worth to enroll online? & wht kind (%) supportive role play by the IIT ( online course) in our interview and Package process for a fresher without any prior experience ?

@ladidadu 11 ай бұрын

i got seasick watching that video :D

@adamzachary6947 5 ай бұрын

Aren’t you guys have something more advanced like synapse analytics, or data factory or big query or other data warehouse solutions that does all that with a single click & powerBI dashboard

@pablorodriguez6318 10 ай бұрын

I am a data analyst and didn't know about it

@bms4654 9 ай бұрын

Wait you left out some random old employee sends you his spreadsheet with random formulas and hidden columns for you to use as your source data... Oh and six columns named the same but with "old", "older", "oldest" and the favorite "test oldest"

@SobaBTW 8 ай бұрын

Homie your house alone is worth more than my house, car and PC combined. I'm sure the money is worth it.

@FINALB 7 ай бұрын

This seems more like a business accountant task to do.

@himynameisryan 7 ай бұрын

I thought data analysts used windows due to the better version of excell I’m a Mac user and always avoided data analysis for that exact reason

@artimasblackmour4638 8 ай бұрын

When you got to the sales data table you should of said “this sounds like the answer but it isn’t. Someone created this table years ago and due to the spaghetti code of due to adding products, the data is all messed up!”

@mostafagalal1584 Ай бұрын

He asks for profit and u don’t have cost in the table saying that this is all the information u need, u r fired lol

@GGGONEXT67 8 ай бұрын

Im an engineer but i work with a lot of data and analysis type projects. Sometimes im the only engineer and its funny to write like 10 lines of code and call it a day

@harrymandel 8 ай бұрын

I see it every day and it bits me...I want the job damn it!

@GGGONEXT67 8 ай бұрын

@harrymandel 😅😅 it's always fun to be in meetings and they say "shout out me *me for doing such a great job on this new sales algorithm!" And I'm just thinking don't clap for me clap for chat gtp and all the time I spent texting

@dew-me7266 11 ай бұрын

This job should not need a degree it’s so basic

@joejoe850 10 ай бұрын

It doesn't need a degree. And she just gave a very stupidly simple task. Actual data analytics work is more difficult.

@l.p.7585 10 ай бұрын

The demo 'task' is the 5 minute job on the back of whole projects. How df did the database get populated in the first place

@darienford860 9 ай бұрын

You can literally get a Power BI or Salesforce certification and qualify for these positions. She just gave you an example of one simply task

@kushis4ever 8 ай бұрын

I have been a data analyst all my career life, I didn't know

@kushis4ever 7 ай бұрын

Exact. Been going in and out of backend so many years spilling out on sheets for users to enjoy.

@joserocha-perez5218 9 ай бұрын

Mostly data cleaning because of messy business processes

@AhmedHemaz 5 ай бұрын

Rule number 1 Don’t use select * 😂

@reptilezsweden 4 ай бұрын

It's fine for a one off query on a smaller database

@reptilezsweden 4 ай бұрын

Your what software? Sequel?

@tunamuda 6 ай бұрын

As data analyst, i spend 80% my time just for data cleaning and 20% to analize😅

@AJAY7509 3 ай бұрын

Man in done with cleaning,extracting🤣🤣🤣🤣 creating pipe lines.but still it pays well I'm sick

@visionentertainment8006 4 ай бұрын

All that sales information should be implemented into Excel

@dgpreston5593 5 ай бұрын

Where do I send the check? 😮😢😂😅😊

@bobbyd1658 9 ай бұрын

Sounds so boring

@sandeepsahu8743 9 ай бұрын

I know how to boil eggs, maybe I am chef😊

@shoaibullahferoz1560 6 ай бұрын

Not performance issues with *

@CoryTheSimmons 5 ай бұрын

You know when the "tech worker making a video about their job" has an iced coffee in their hand, they are going to know the bare minimum about that job.

@changeplease7056 4 ай бұрын

😂😂😂

@idontknow9985 10 ай бұрын

so basic SQL is all you need?

@stephanrobert5593 7 ай бұрын

Basic sql?

@thespencerowen 9 ай бұрын

And this is how you bring down the production database. I sure hope you are limiting your queries.

@oompalumpus699 23 күн бұрын

If you sort the comments by date, you can see how a huge fraction of the comments are coming from the ignorant. Data analytics is less about the tools and more about the ability to sort information and determine the correct conclusion. It's the reason why a lot of programmers never go beyond the basics. None of them develop basic analytical skills.

@DelightfulPager-ro4nw 5 ай бұрын

Also, data analytics and data analysis are two seperate things

@inspira. 5 ай бұрын

What is the difference

@DelightfulPager-ro4nw 5 ай бұрын

@@inspira. Google

@symbioticparasite6268 9 ай бұрын

Yeaaa ..... Real hard scenario here .....

@CharlotteChazeBreakIntoTech 8 ай бұрын

This is an entry level example! I help people get their very first data analyst jobs

@symbioticparasite6268 8 ай бұрын

@@CharlotteChazeBreakIntoTech I'm a teacher at college, so me2.

@lakshmiprabhakarkoppolu9100 10 ай бұрын

Comment for better teach🎉

@whosestone 22 күн бұрын

Nah, it's on 5 excel sheets. One is in SharePoint, 4 are on personal One drives. 1 is on a desktop. Oh, and the dates are not in date format. Ok kids, have fun!

@TheDcotton24 10 ай бұрын

Do u need to kno code?

@beanboi-uc6fr 10 ай бұрын

Chandler Bing type shit

@socj1000 10 ай бұрын

So a data analyst is basically the Lord or Lady of the SQL?

@user-su2kw1gu5i 10 ай бұрын

Yes

@user-su2kw1gu5i 9 ай бұрын

@@darienford860 95% of tasks in real business it is SQL. It is more clear and faster way. Python only for some math modelling. Of course you can use Python pandas for all data manipulation but it is not good way.

@emmanuelalva6597 4 ай бұрын

When it comes to finding and exporting data yes. When it comes to managing the data base definitely not unless you work at a smaller company.

@mchannel1365 10 ай бұрын

😅😅😅 Nice 👌

@Thepeoplereact 8 ай бұрын

Are boot camps worth it?

@kaldo_kaldo 7 ай бұрын

Apparently I'm a data analyst and I didn't know it

@bryannpaulmiranda1947 4 ай бұрын

But then, you still need to refine the data because there are values that are broken haha

@AhmedAlhaj 9 ай бұрын

Bro that's completely misguiding explanation.. Data Analysts do far more than that.

@CharlotteChazeBreakIntoTech 8 ай бұрын

This is what they do at entry level!

@AhmedAlhaj 8 ай бұрын

i would love to see what each level actually do@@CharlotteChazeBreakIntoTech

@malcolmjelani3588 4 ай бұрын

Data analysts are bums.

@rfooseball 10 ай бұрын

If you have a table in your DB called 'Sales2021', someone who sort of knows what they're doing already did your job for you. If my analyst created a table like this in our reporting database, they wouldn't have a job anymore. Being a data analyst is like driving a car. Knowing how to drive a car doesn't make you any more capable of getting to your final destination if you don't have a map or know how to explore the city/town you're in. Databases are NEVER this obvious.