How to Become a Business Intelligence Analyst
ฝัง
- เผยแพร่เมื่อ 4 มิ.ย. 2024
- 👉Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: bit.ly/47Eh6d5
In this video, we’ll look at who the BI analyst is, what they do, and how much zeroes are stacked on the end of their salary. Finally, we’ll discuss what skills and academic background will help you become one.
So, who is the BI analyst and what makes them so special?
BI analysts are fierce business performance ninjas who possess a blend of business vision, consultant abilities and profound understanding of data. They join forces with senior management to shape and develop a data strategy. Analysis of Key Performance Indicators (KPIs), accurate overview of business performance and identifying areas that need improvement are also specialties in the BI analyst’s domain.
And what exactly do BI analysts do?
Well, they focus primarily on analyses and reporting of past historical data. Once the relevant data is in the hands of the BI Analyst (that’s… monthly revenue, customer, sales volume, etc.), they must quantify the observations, calculate KPIs, and examine the measures to extract insights.
Of course, the most important aspect of a BI analyst’s job is to continually improve their company’s competitive positioning. Therefore, they examine their competitors, data trends, seasonality, and other random effects to quickly identify issues and best practices.
On top of that, they create killer graphs and dashboards to review major decisions and measure effectiveness. So, in a word, if you want to have an impact on the business world, become a BI analyst.
Well, maybe that’s easier said than done. But let’s see how much a BI analyst makes per year, maybe that’ll have some inspirational effect on you…
► Consider hitting the SUBSCRIBE button if you LIKE the content: th-cam.com/users/365DataScie...
► VISIT our website: bit.ly/365ds
🤝 Connect with us LinkedIn: / 365datascience
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: • How to Become a... (Da...
#BusinessIntelligence #BIanalyst #DataScience
![ไม่ต้องมีที่ที่ให้ฉันอยู่ แต่ขอแค่มีฉันอยู่ก็พอ (Spaceless) - getsunova [SHORT FILM]](http://i.ytimg.com/vi/MuT0d_cvJkc/mqdefault.jpg)
🚀Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sGBk7a
i got my bachelors in statistics and somehow i am a junior BI Analyst now. dont know why there are so few people in my field. this job is great :D
I’m 19 should I invest in it?
@@suhaskm5822 hey Suhas, why do you think one has to be interested in programming in order to work with this?
I am bachelor of science in statistics but i do not have any ideas in business intellegence
i am looking for internship in Bi I am doing business analysis and I just finish database certificate
@@jeanyracaza3735 I’m taking 365 data science, but the program is well organized is to understand with all these bz words
I want this guy to write my resume. He’s an expert at making mundane, simple things sound damn near heroic.
Damn right! 3 minutes into it and I had already cut off my right leg, fashioned a musket from the thigh bone, and was on my way to the frontier!!! :)
That's funny.. To be honest I didn't quite gather the courage to do the same after watching it the first time. I did however, after I read your comment, watch it again and perform the same operation just to join you on the frontier. Just curious... How did you manage to stop the bleeding and did you grind the musket? Had to get an ambulance to pick me up and my musket isn't nearly sharp enough :(
For anyone looking in 2022, this is still a great role! If you are someone who can explain technical concepts in an easy to manage manner, this is THE role for you. This is the key to being a great BI Analyst, and then Senior, Lead, Manager etc. You have the ability to communicate above and below your technical level, you will do wonders.
It's for those people who like being heroes. Because when things go well, no one really thanks their BI team. But if something goes wrong, they are the first people to hear about it lol. I love it! And I hope you do too!
Hey!! I am interested in this career and want to know more can you please guide me on this?
we call it shit cleaner in the toilet.
thank you for making this. clear cut answers to a few questions I had.
anther nice video! the specials are your best series,keep it up 365!
In short, a BI analyst is a guy who can sum up a lot of data, then out of that make business decisions.
Sorry to be offtopic but does someone know a tool to get back into an instagram account??
I stupidly lost my login password. I would appreciate any assistance you can give me
@@elibryce7297 like really
Sorry but... Decision make a government of company) anyway, this boy can give clear and understandable info about everything related with company
Correct
I'm a BI Architect with no coding skills in Python, R or Java etc
Actually I'm Bachelors in Mech Engg & Masters in Applied Engg & Tech Mgmt.
I build apps or dashboard on a particular tool using clients data which is obviously all over the place-Creating a data model is biggest headache.
You can be a BI Dev/Analyst/Architect, not that hard...
BTW, with 5 yrs exp I earn in 6 figures.
It's all about what tool you select for a BI. As we know tools come and go so it's risky....
hey! thank you for comment based on your personal experience. can you share, which BI tools do you usually use at work?
@@aliesenturov7292 Salam, I use QlikView & Qlik Sense BI tool. You can find many tutorials on TH-cam.
Try this channel, it is good for start
th-cam.com/users/shilpan9166
Install Qlik into your laptop, it is free to use & download some dummy data in excel or csv format to learn/experiment.
One year late, but I really want you to reply to my comment. I'm currently in my last year of bachelor's in Business administration with IT major. I really want to do with Data analytics or financial analytics. I have a hard time coding. Can you please guide me through what kind of internships should I opt for? And how do you start from a fresher level
Very instructional and insightful. Thanks 🙏🏿
Thanks for the sharing! Keep up the great work!
Great video, guys! Looking forward to the next 365 special!
Great video,was wondering what to focus after my MBA in IT
GREAT JOB!
Thanks! Sir
Waiting for more videos on POWERBI
This is great. As one that wants to build a career in the Finance world. I think this right here would help me prepare well
Beautifully done.. !
Nice video may be i will give it a thought to take up the BI analyst path.
Thank you very much for this helpful video!
Nice explanation, Another question, what are the differences between BI Developer, Business Analyst, Quantitive Analyst, Database Developer, Database Administrator, Statistician, Data Visualization Analyst and Machine Learning Scientist ?
Many thanks in advance!
Described Exactly as per current industry situation / standard
Great video thanks you so much for your upload
Thanks for being so positive
When will you guys have a data engineering course?
I have been thinking of another skill to add to what i have, i think this is it ..
To sum up. Data is good buy our content. Save 8 minutes.
To work as project manager, some of companies they require some one who have project management certificate, MBA will be advantage + computer science or data science or it..etc .
Great video ☑️
I liked it very much thank you. and I habe subscribed
1:11 love this momment
365 Data Science is the best place to check out data science career videos! Thanks, guys!
Good video!!
Thank you
Hi, that was really great, detailed and concise. Thanks
I'm a university student, with some data science experience but I have a lot of drawbacks in the soft skill, especially writing and communication skill. Any advice on how to improve?
Thank you!!!!!
Great video
well done.
Skip to 2:14 if want to get past the sales pitch.
which path should I be pursuing with master's in accounting and also with accounting experience? I am from Poland.
So how long is the program for ? I would like to take it up, if it matches my timeline.
Want videos about how to plot various graph in R program......
Why interning in a financial institute specifically will help at the beginning of a BI Analyst career? Would like to know the logic behind please.
Love from my heart
Are you guys on Udemy? I would love to have your course but my job has the learning on few places.
Yes they are on udemy
This is a great video, but salary averages from the UK are way off
So I learned a little R in school but I’d need to dive deeper, or should I start with Python first?
Hello,
I have ubuntu os, should I switch to windows in order to do analysis in future?
I'm not good with programming. But I think I fit to be a good BI analyst.
Well yeah, that's what we expected
Those UK salaries in the video are way off. A BI Analyst with around 4 years experience can expect to earn over £40k, dependent on skill set and sector.
Why is there such a huge difference in US and UK salaries ? Love your channel.
This would more likely to be something that applies to all areas, not just this one, a matter related to the country. Healthcare for example, is free in the UK while it is quite expensive in the US, so it is natural that salaries do not need to be as high since some expenses in the UK do not exist.
Is Microsoft certification like MCSA: BI reporting useful in job seeking? Anyone knows? Thanks
Certifications help... showing projects you have been part of or completed on your own would go further in my opinion. Depends on employer etc
Your first step should be finding a "job", any job that
that produces those type of reports daily.
They use these reports as a strategic resource.
Secondly, this "job"? You will work this job at entry-level.
No, you won't be working as a data analyst. You need to realistically understand how this entry-level job ties into data analysis before applying your tech skills.
Once you understand the needs of the job after proving ground as an operational decision-maker, then 100% you'll ride shotgun as an analyst internship/no internship.
Already holding this certification, with 2 years of experience in data analysis. Honestly , for me it has not been that helpful despite having all the relevant skills. I would highly recommend having a personal website showcasing your portfolio with projects using all the tools mentioned here (I would also add the Microsoft stack SSRS, SSIS , SSAS). But the main thing is networking and fine-tuning your resume according to the job you will apply (most HR barely recognize what the skills mean and the job requirements are, so you need to pass the AI scanning your CV entry process). Good luck
Hrvoje Sipina I see. I guess I’ll working on this path, 🙏 thanks for the answer
drippin wet Thank you sooo much for this advice, I think this is the best path for me right now. However, the only job type that produce these reports based on knowledge is junior business analyst...
wow, very cool !
Glad you think so!
Those salaries are completely wrong for UK. I am a BI DEVELOPER and it's quite a lot more than 29k for 3 years experience, particularly if you work in finance and know the Microsoft stack with tSQL. Tableau is being pushed out by Power BI. SSIS, SSRS, SSAS fundamental.
Big Thanks.
Great video ........
I have a feeling my experience in the US Navy Intelligence field correlates best with this job especially since it was a trend analysis and impact based work.
The question I have, can you become a BI analyst without the degree given a background like this?
Damion Spearman As someone who was intel in the Marine Corps and now as a contractor, I have BI Analyst recruiters reach out to me all the time. Even they seem to think that the skills transfer well.
@@vinchetti_spaghetti what's your skill level in coding?
The training and ideology we undergo in Intel is definitely strong for impact and assessment analysis. Especially with at least Navy we prioritize history trend analysis and predict based off that and known factors so I like to think it's a good substitute for the degree
@@grotwurksmekshop6607 My coding experience in minimal. I know SQL and HTML basics, but no Python or anything usually associated with Data Science. I am an Excel whiz thought.
When people ask me what I do, I usually tell them I am a Data Analyst as my job requires me to maintain a SQL database of SIGACTs, and create trend products in Excel.
@@vinchetti_spaghetti hmmm that is a good way of explaining it. Hmmmm I need to learn sql
Vincent Mayville - it’s best to have a wide range of coding skills. SQL proficiency is a must, as is a solid grasp of how relational databases work. You’ll see a lot of jobs talk about ‘The Microsoft BI Stack’ which incorporates SSRS, SSIS etc. The more languages you can code in, the better. I first started coding in SAS base, of which SQL is a sub language via Proc SQL. Then there is Python, which is free to use at home so you can start learning that at any time. ETL is a major component of the job. Finally you’ll need proficiency in a couple of the main BI Tools for dashboard production. Tableau, Power BI, Qlik and for the more statistically powered reports, SAS Visual Analytics.
I was wondering when you guys talk about doing an internship in the financial industry, I am a bit confused about what kind of jobs you are talking about. Could you maybe elaborate on that?
Maybe they meant a financial analysis to crate budget dashboards, reporting and etc. Most of the time they use Excel, Excel VBA, Power BI.
4:05 salary you are welcome
Learning coding is not as difficult as many think. Coming from mathematics background, I had little programming skills. In 3 months after my grad (2017), I taught myself Excel (considering learning functions: sumifs, if, vlookup/index,so much more). Then I landed my first job as production analyst in a manufacturing industry untill Covid19 broke out and get laid off (now looking for a job). 3 years later, I am very comfortable with ; PYTHON, R , SQL and Excel (advanced)
As I am looking for a job, I am learning from edx , udemy and udicity. My focus is Data science related courses. Every related video I see in TH-cam, I cant resist not watching it. I hope one day I land a job as Data scientists.
Any updates?
I know this post is quite old but I'd love to connect on LinkedIn. I'm trying to become a BI analyst myself.
Thankyou sir nice greatone
if you want to be a business analyst, which programming language should you first learn ? (I am new to any language)
I googled this question, HTML , R , SQL, Python showed up. A bit overwhelmed, what should be my first step?
R or python. R is more focused on data analysis, python can basically do the same thing as R, but it is slightly complicated to code because python is not designed only for statistics. So python has more potential, R is more focused on statistics. You can forget HTML, it is for web designers. SQL is a database language. You should learn it after you've already analyzed some sets of data
Kindly make a video on data analyst
Hi there! You can check out our How to Become a Data Analyst Intern video bit.ly/34xr7cS if you are new to the field or maybe take a look at the How to Become a Data Analyst in 2020 video: bit.ly/3d5xpok
We hope these will help you!
My math skills are weak and I have a Business Admin degree, should I look into BI jobs? Thanks.
Iam very interested to learn Power BI. I need online course beginner
I'm studying industrial engineer, is a a good área for my career?
Safe and sound
Do i get a dependable certificate afteri finish the 365?
Classical Indian literature rocks 🤣
Proud Indian 🇮🇳
Please Answer me,
What's the difference between business intelligence analysts and business analysts?
Slightly differentiate with each other. Business analyst using tools which is getting data and reporting, visualising. Tools include Excel, Tableau or Power BI, SQL. BI analysts on the other hand, sometimes get data a little bit deeper (generally seniority level) with help of Hadoop , Python or R. But most of the time job offers mention them in the same field. Like this Busines Analyst/BI Analyst.
4:10 Sorry but as an istatistician, I would like to see median instead of average.
That UK salary sounds absolutely awful. Why is it so much lower that the US average (£49,000)?
Hardley waited two minutes to get over with the sales pitch lol
Time required??
Does anyone know where can i offer my service as a BI analyst as a freelance?
Juan Ignacio maybe try Upwork or some other freelance website. Good luck!
When did BI become data science?
BI, Data Analysis, ML, AI all are the part of Modern Data Science
They start with BI later in the video. I thought the same thing as you did.
it goes like this : data analyst , business analyst , business inteligence analyst , business inteligence developer , data scientist , machine learning , artificial intelligence
It's one step along many to become a data scientist. That's what I got out of this.
It's more of a hybrid between a business professional and an IT expert/programmer.
I don't have the academic background but i have certification of completion, please what is the way forward?
Using any of the tools mentioned in the video well in a business environment likely requires connecting them to a database and using information obtained from the database and from other sources. If you don't have access to a SQL server, I recommend setting one up to practice with. There are plenty of free online data sources you can use to populate a reasonable number of interconnected tables. Practice using each tool to access and analyze data from the db. Use the tools for exploratory analysis, to better understand the data, then practice creating visualizations that quickly impart something important from the data to anyone who sees them. Show them to several people you know and ask them to tell you what they think the visualizations mean. Learn from the differences between what they interpret the visualizations to mean and what you intended them to convey. One skill that is hard to learn outside of a work environment is asking god questions to understand what information people need to make good data driven decisions. Practice listening more in your day to day conversations and asking good questions to encourage people to share more information. Be willing to take an entry level position at a good company in a field you know or are interested in, even if it is not as an analyst, and look for opportunities to demonstrate your skills and advance internally. Without a related degree, this is one of the best ways to break into the field. I hope some of this helps. I wish you the best of luck!
@Anmol Dilip Datacamp and Coursera are pretty reasonable. I recommend starting with Datacamp due to their interactive learning style, and if you are dedicated to using it frequently it is worth paying for a month or two which is actually pretty inexpensive.
If you have an inquisitive nature and analytical mind, figuring it out from there should be more fun than frustrating. You should have enough of an idea of what you are doing to set out problems you want to try to solve, then solve them. Either use public data sets or scrape some, which, like most things, you can figure out how to do pretty quickly by asking google or github. Good public data sources for learning relational databases:
github.com/awesomedata/awesome-public-datasets
If you want to build models, you may want to look into some additional stats classes and read whitepapers on whichever models you are considering.
Sir, how to i jion this course?❤
2:40
Why doesn't your Data Science Course have Power BI?
How is uk just 29000 after 1-4 years. I seen many job postings that offer 45-55000
Saleem Ali - yes 45 - 55k is more realistic with 4 years experience. I’ve been in the field for around 10 years and wouldn’t have carried on for just £29k !!
And most of them dont want Tableau but SSRS and SSIS
0:53 What's wrong with it?
I think i just felt in love
What is KPI?
A KPI is a Key Performance Indicator. You can learn more about it in our Business Analytics course, check out the description of the video to find a special offer for enrolling in our program!
These UK salaries look way off. £29-30K is closer to what you'll get at entry level (in London anyway) not after 1-4 years experience. Why upload a video without doing some research first?
QlikView / Sense
Cognos
Etl
Data Warehouse
Lol, all the buzz words
whats qlikview and why am i scared of allowing cookies?
**how MANY zeros
for me ...5
How many indian are watching this??
oh... it's an ad. Nevermind then.
It would be great to have the person in your video be a woman as well
that was hard to watch. i feel violated
UK Salaries way off
Hahae so good
I have all the skills and academic background but no one wants to hire me
musa abdullahi no working experience?
In the same boat right here buddy lol
Rita Z 3 years
@@atbu092
What did you do in your job?
That sounds impossible to never get any job offer
@@atbu092 start your own firm.
Just because you know how to use tools doesn't mean you can be a data scientist. This is ridiculous.
Classical Indian literature hahahaha
Lost get
Bi will land you a office-job
Hahahaha contemporary dance and drama qualified
Salary is too low
Bi analyst....lol
That's funny why? Bi= business intelligence
A bisexual analyst?