7 Steps to Get Your First Business Intelligence Analyst Job | BI For Beginners

[@LearnBI]

🚀 BI CAREER STARTER PROGRAM 🚀 A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS. Your new career starts here 👉🏻 geni.us/bicsp

[@hajrakhan5094]

I've also been hearing that you need some skills in Python as well to extract or connect to data sources from applications. How important is that for a beginner position do you think?

[@merdrama]

😊😊😊0😊😊qq😊😊😊😊qq😊0😊0😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊

[@merdrama]

😊😊😊😊

[@SubatomicStrangelet]

Great tips. I followed these, and I landed a job with a comms company. If anyone is interested, I learned the following things: 1. Excel, including VBA. I was surprised how many companies wanted VBA skills. 2. I learned Power BI. 90% of companies in my region run an MS stack. 3. SQL. I didn't learn the ins-and-outs, just the parts for querying and modifying data.

[@LearnBI]

Thanks for sharing! Great information for anyone looking to get started 🙏🏻

[@ImmigrantB1]

Thanks for sharing. I'm currently in the Army and will be getting out in 2026. I just started an Excel course on Udemy and I'm on my second SQL course in Udemy. (Don't want to name-drop any Udemy instructors here since I don't have permission from this YT channel). I'm also planning on taking a Power BI course at some point. Two questions for you: 1. Did anyone ask you for a certification? 2. How good was your portfolio and do you mind sharing it?

[@HeyMikeyLikesIt2]

@@ImmigrantB1stay in the Army, retire. Jobs with pensions, and medical benefits are becoming rare.

[@diogocoutinho1670]

@@ImmigrantB1hello friend! It depends on the entry level. Most company’s ask for excel+power bi+ SQL and then specifics regarding the company ( finances for a financial company, etc ). I’ve been working in the area for 3 years already

[@gwest40]

@@ImmigrantB1 - Stay Army if you can and retire as the other poster mentioned. If there are no data analytics jobs in the Army, check out the Air Force. If you leave active duty, JUST KEEP DRILLING!! Army Reserves, Air National Guard, etc.

[@chetanswami7736]

To young generation this channel is pure guide lines 👍

[@LearnBI]

Thank you, friend

[@shardieb]

Thank you very much Adam. Your knowledge, generosity of spirit, the content itself, and of course the way you explain things are clear and concise. Your videos really keep me engaged and invested.

[@LearnBI]

Thank you for your feedback, it means a lot. And I just noticed your superthanks as well, that's very kind of you 🙏🏻

[@sharonjuwah]

Thank you so much for the detailed breakdown. Side note: The picture quality is also amazing. Kept me reeled in till the end.

[@LearnBI]

You're welcome!

[@analucianunez]

many thanks!! im from Peru and was looking the steps to become a bi analyst, your video is really useful

[@LearnBI]

Glad it was helpful!

[@tarelakentebe465]

Was wondering how I could build a portfolio, this was much needed

[@LearnBI]

We’ll probably do a more in depth video for building a stocks dashboard in 2022 so don’t forget to subscribe!

[@edwarddubois7046]

Great stuff. Thanks!

[@inspisiavideos8542]

Great content! I got out of college this year and nothing of the real world tech needs to get a job was taught. Anyways, I got an internship as Software Engineer and was extended till the end of this year. Right now, I’m looking for any sort of income from a tech job and found this channel. I probably have 2 months before I’m out of savings so I’m using all the available time I have to study to study SQL and probably a course of AWS or get a coding job but just coding is not enough that’s why this is helpful

[@inspisiavideos8542]

any suggestions might help please

[@LearnBI]

My suggestions are mostly Inn the video 😉

[@vamostimow]

i feel you..colleges are mostly bs

[@zweiklangmusic]

Great YT Channel, thanks for the advice.

[@LearnBI]

You’re welcome!

[@VeritasVincitur]

Amazing Video ! Many thanks 🎉

[@LearnBI]

My pleasure

[@vusinkuna453]

Thanks for these tips. I find them very useful in shaping my career ambitions.

[@LearnBI]

You’re welcome, glad to help.

[@Moh-xj4ms]

Thanks Adam for that very interesting video!

[@LearnBI]

Glad you enjoyed it!

[@sanchitgupta9539]

This was very helpful, so many questions in my mind that you answered. thank you!

[@LearnBI]

Glad it was helpful!

[@juanoctaviohurtadocaraball6214]

Gracias, muy buena info

[@Khan-mc3gi]

Thanks alot very useful info.

[@LearnBI]

Glad it was helpful!

[@lilyyuno7673]

This is great, i never thought about building a portfolio

[@LearnBI]

If you want to stand out from the crowd, you'll need to build the best one you can.

[@manarabdellaoui]

thank you very much for this incredible video

[@LearnBI]

My pleasure!

[@basunnaidu55]

VERY GOOD CLARITY.

[@bernicetorres8384]

Great video, thank you!

[@LearnBI]

You’re welcome!

[@edisonjoy5427]

Love love love man youre my man ❤️ Thanks for this valuable video

[@LearnBI]

I appreciate that!

[@tobiobafemi5208]

You're amazing! off to learn SQL i go!!

[@LearnBI]

You'll crush it!

[@wellingtonmoreira115]

great video!

[@beibeima524]

Great sharing, Thanks!

[@LearnBI]

Thanks for watching!

[@robensonjoseph8906]

I really appreciate this video

[@LearnBI]

Glad you like it!

[@MahsaMohtavi-jt9df]

Great , thanks

[@Fai9alYT]

6:47 in step 4 Is Excel considered a bi-tool that I can rely on? And Can i use excel as a BI tool and move to power BI after I specialised in the excel and I want additional features ?

[@LearnBI]

Excel is not a BI tool, it is spreadsheet software. Its main use in BI is for data preparation or as a data source that you work with.

[@Fai9alYT]

@ i saw some people making dashboards from excel

[@LearnBI]

5 Reasons You SHOULDN'T USE EXCEL To Build Dashboards kzbin.info/www/bejne/o6ndpJiEiZWDnac

[@siddharth5355]

This is gold!!

[@LearnBI]

Glad you like it

[@alesterdcosta7343]

Thank you so much for this video, it’s very well explained! 😀🙏 I would like to ask a question since I am currently pursuing a graduate program in Business Analytics; is Business Intelligence a great career choice for atleast the next 5-10 years?

[@LearnBI]

Yes, definitely

[@Soulenergy31]

8:20 portafolio of data projects

[@joshdee7639]

Cool video man! I have a question if ya dont mind, what types of questions do you find yourself researching answers to when youre looking at a dataset? Ive got about 8 or 9 Tableau viz's, and the one thing i always struggle with is finding something type of question to answer with the data

[@LearnBI]

Although BI does aim to answer specific questions through the insights gained by visualising data, its main focus is to help companies monitor their activity through constantly updating dashboards. I think you are talking more about data exploration which isn't really the subject of this video

[@robinnn777]

Very helpful! I would love to learn more about what a portfolio should actually look like. Do you have any resources about that? (Like should it be a website ? A powerpoint? Should it just be screenshots of dashboards built? How do you show SQL work in a portfolio?)

[@LearnBI]

I plan on creating more content on creating portfolios in the coming year. Watch this space!

[@ryanbaker2762]

I would like to know about the sql part too

[@behrad9712]

Thank you so much 👌🙏

[@LearnBI]

You’re welcome!

[@johnbellebenaning1666]

Great Thanks!!!!

[@LearnBI]

You're welcome!

[@oksanamaslianka1305]

Thank you so much!

[@LearnBI]

You're welcome!

[@kalmkrew]

Hey, I have a bi analyst interview coming up and I'm only self taught in sql and pbi with one project for each in my portfolio. How do I effectively speak to being a beginner but still show I put out the necessary effort to get up to speed? I have a portfolio Web that houses my projects. Thanks

[@LearnBI]

I’d say that if you only have 2 projects in your portfolio, that’s probably not enough and the interviewer might ask why there aren’t more. You need to show that you are capable of dealing with different kinds of data. Why not connect to the sample google analytics data that’s freely available? support.google.com/analytics/answer/6367342?hl=en#zippy=%2Cin-this-article

[@sabrina.natalie]

Hi Sire. If you feel comfortable, do you mind giving us an updated. It’s been a couple of months since you’ve written this comment, and I’m interested to know how your experience has been! 💕

[@kalmkrew]

Oh hey guys, I actually didn't get the job unfortunately. They told me my interview was good and they appreciated my energy, however, someone was just better 😅

[@start-upvilla]

Hello I'd love to connect with you, please is that gonna be possible? I have lots to talk about

[@uyamagidiwana6709]

@@LearnBIhow many projects do you recommend we have ?

[@dinmasdiary4977]

Thanks for this video

[@LearnBI]

You’re welcome

I loved your video!

[@LearnBI]

Thank you!

[@mayurnarayan1]

Great content , can you make a video on market basket analysis and also video tutorials on tableau , thanks ❤️

[@LearnBI]

Market basket is my list for 2022

[@dhruvshetty2127]

Great video

[@LearnBI]

Thanks!

[@silkyslim2111]

Thank you!

[@LearnBI]

You're welcome!

[@moutazeldeib9481]

Thanks a lot for your valuable information, I am following your channel and I liked the video of the difference between data scientist and BI analyst, but I am inquiring about the role of data analyst? Could you please give us an example or explanation about it?

[@LearnBI]

Here’s a helpful article that explains it: www.coursera.org/articles/data-analyst-vs-data-scientist-whats-the-difference

[@jessicas4640]

Hi there! Should portfolio not include actual dashboards created in a work environment? Sample sets will suffice?

[@LearnBI]

If you’re applying for your first BI analyst job then you’re not going to have dashboards created in a work environment. Sample sets are fine 👍🏻

[@psanders4754]

excel maybe more important than sql, power pivot can basically transform sql data

[@LearnBI]

Excel is definitely not more important than SQL. Just because a tool can do something that doesn't make it the right tool.

[@psanders4754]

@@LearnBI every organization is different there is no one size fits all model. But a spreadsheet is a constant in every org.

[@LearnBI]

I agree totally with your last comment but, with respect, it still misses the point. SQL and Excel and totally different things and most data generated by a business is collected in SQL databases. The majority of the data a business possesses in Excel files has been exported from a SQL database to begin with. The whole video is about 7 steps to your first BI analyst job. To become a BI analyst you cannot not learn SQL, it's just not possible. You need both Excel and SQL which is why I said initially that Excel is definitely not more important than SQL.

[@nasirullad3113]

Great content! Can you suggest some good online bi courses that covers all the required topics. It will be a great help for me.

[@LearnBI]

Glad you like the content. Personally I would follow my advice from step 7. Subscribe to a learning platform like Skillshare or Udemy and take all the courses you want. If you want something that will give you certification at the end, try the Google Data Analytics course on Coursera (all links to these are in the description). Good luck!

[@Saleem__786]

Great video but I saw some roles that involves Data Warehousing. Is that a more advanced skill?

[@LearnBI]

Good question. More often than not, data warehouses are just glorified sql relational databases so knowing how to create them and the tables in them is half the battle. But, depending on the size of the company, it’s often the job of the IT department to set up data warehouses. Leaving you to carry out your analyst tasks.

[@Saleem__786]

@@LearnBI thanks. Also a lot of roles in my area want technologies like SSIS and SSAS. I just like to ask, I know Data Warehouses are created in a way to be used for analysis and you analyse these DWs in SSAS. but can you analyse normal relational databases in SSAS? Do companies do that?

[@LearnBI]

SSIS and SSAS are both Microsoft SQL Server tools. SQL Server is a RDBMS like MySQL or PostgreSQL. So those tools are specific to SQL Server only.

[@Saleem__786]

@@LearnBIok. do you have more videos on Data Warehousing concepts. I'm having a hard time understanding what topics like OLTP, OLAP, Tabular Model, Multidimensional Model are. This is my take but correct me if i'm wrong SSAS is used to analyse a data warehouse. A data warehouse is data that is stored from different sources, but it's stored differently like it has fact side and a dimension side. i don't know what those means. You can use a tabular model, which is built on relationships or you can use a multidimensional OLAP, which is built on dimensions. Tabular is a newer method.

[@LearnBI]

It seems like you’re getting yourself overly confused with technical jargon and concepts. This is the kind of stuff you would need to know if you wanted to become an engineer or data architect but not an analyst.

[@klaudiak6615]

I conduct data collection, cleanup, and analysis as a microbiologist, any advice on how to break into tech from more of a health role? I got the google analytics certificate, have experience in excel, google sheets, tableau, and SQL. How can I stand out against the the business/Econ applicants?

[@LearnBI]

I think the fact that you already have the skills you do will put you ahead of a lot of candidates. What you would just need to show, other than a portfolio containing business-related projects, is your passion for working with business data and helping companies to grow and evolve using data.

[@coalblacksmith]

Great video. What do you think of cloud certificates such as Microsoft Azure's? Are they any helpful in landing a job? Thanks.

[@LearnBI]

It wouldn’t hurt but you’d be better off learning something that isn’t vendor specific, more general learning. It also depends on what job you’re looking for. If it’s BI analyst then it wouldn’t be my priority.

[@coalblacksmith]

@@LearnBI been looking for an entry level role but everyone says I got no hands on xp...

[@LearnBI]

Have you created a portfolio with different projects? That demonstrates that you know how to work with and present data.

[@coalblacksmith]

@@LearnBI it's my next goal after having watched your videos :)

[@AmericanPie-z6b]

Do you think that for bi analyst job , it is necessary to have degree like traditional degrees btech , mba and sortta other?

[@LearnBI]

The answer to your question is will depend on a lot of different factors. Most large corporations will require that employees have been to college and earned a degree for a BI Analyst position. Some will require a related degree, some won't. Some will require previous experience and some won't (for entry-level positions). Smaller organisations might not require a degree but look for experience instead, some will look for both. You definitely don't need an MBA. But you do need a project portfolio that showcases your work and acquired skills.

[@ukaszdugozima816]

Your video is really useful for beginners! Could you please tell me about Python especially NumPy, Pandas, Matplotlib and Seaborn? are these libraries useful for Business Intelligence Analyst? Do you have any views on it ?

[@LearnBI]

For Business Intelligence you don't need to know Python because most BI projects don't call for the kinds of analysis that Python is built for. In BI you'll be mostly aggregating and visualising business data using SQL and BI tools that were built for BI. If you want to become a data scientist then you'll definitely need to study Python but that's a different channel 😁

[@vivekr4118]

MSc in business and psychology can support a business analyst career in Germany. Is there any eligibility for a business analyst career and what skills are required for getting a job on that? Is it possible to start a career as a business analyst in Germany with an MSc in business and psychology?

[@LearnBI]

BI Analyst is not the same as a Business Analyst so it's not my area of expertise.

[@abdelrahmanmalekgenedy8751]

good job bro

[@LearnBI]

Thanks

[@Focus_Concentration_Music]

Is Qliksense a good tool to master? I am currently working in a company that uses it but not sure whether to master it completely. Great video btw. Thanks

[@LearnBI]

Yes, Qlik is one of the major players in the self-service BI space. Not as popular as Tableau or Power BI but that makes it more valuable as a skill IMO. Also, once you master one BI tool, you'll quickly be able to master others when called upon to use them.

[@Focus_Concentration_Music]

@@LearnBI Thank you for your input👍

[@hazemelbatawy1242]

awesome vedio

[@LearnBI]

Thank you!

[@ShajJan-r4u]

My job is hiring for a bi, but the job description says they need someone good at r and sas. Is there a big learning curve to learning these compared to SQL? Does it sound like they are looking for a data analyst and a bi together?

[@LearnBI]

R is not a BI tool, more for general data analysis. I’d say the learning curve is similar to SQL.

[@saswatiroy7755]

Very informative video. Adam can you please suggest which course is better for a beginner who is into self learning- Google BI professional certificate OR IBM BI foundation on Coursera? Or do you suggest any other couse from any other platform for beginners who wants to be job ready. Kindly help

[@LearnBI]

What is your goal?

[@bachirtobbeche7904]

can a BI analyste work as a freelancer if so which plateforme

[@LearnBI]

Freelance would be more of a BI consultant. As a consultant you would be required to work with the client’s chosen platform or suggest one that best suits their needs. May I suggest you check out this video : What Does A BI Consultant Do? | Business Intelligence for Beginners kzbin.info/www/bejne/kJiWf4avZaago6c

[@Aurossa]

It udemy everyone! At 10:19

[@LearnBI]

All part of my subliminal messaging campaign! 👿 Otherwise known as en editing error 😂

[@mohammedawaytoumi6828]

what about ETL tool ?

[@LearnBI]

Yes, this is a good suggestion. However, for your first BI ANALYST job, I'm not sure you'd be expected to have this skill. Because there are so many different ETL tools and they work in very different ways, you could never be sure that the company you're applying to would use the ETL you've learned. Best to stick to the basic, globally-recognised skills like SQL and Excel. There will always be learning on the job of the tools specific to the company you're hired by.

[@ketsune23]

Do you think AI will replace Analysts in a near future?

[@LearnBI]

Depends on what you mean by ‘near’ but I think we’re safe for a while yet.

[@shashank6096]

How to get freelance projects?

[@LearnBI]

I think the better question to ask is “why would any business want to employ me to handle their BI project?” Whether your services as a freelance will be perceived as valuable will depend on your experience and what you can offer. Do you have a project portfolio?

[@shashank6096]

@@LearnBI can you help me with that! I do have a portfolio Do you have Instagram?

[@LearnBI]

I wish I had time to mentor everyone who asked but I simply don’t have the time. That’s why I put my knowledge into easy to understand videos so that I can help the most amount of people. All I can tell you is to follow my advice for building a portfolio and creating social proof. Then create a service offer that is professional and attractive. You could try contacting small businesses in your area who maybe haven’t thought about BI and propose a dashboard package for their social media. That’s just one example, use your imagination 😉

[@carlosalonsogonzalezgomez2645]

I'm studying industrial engineer, I can be a business intelligence analyst? I'm so confused:(

[@LearnBI]

Industrial engineering has very little/nothing to do with Business Intelligence. But that doesn’t mean you can’t study BI to become an analyst

[@irbazahsan8229]

Traning our subconcious mind 😏?

[@LearnBI]

Subliminal messaging 👍🏻

[@arianaamores7147]

Truly helpful

[@colebarrett515]

Thanks so much!

[@LearnBI]

You’re welcome!