How I Use SQL as a BI Analyst
HTML-код
- Опубликовано: 30 июн 2024
- In this video, I talk about how you use SQL as a BI analyst and bust a few myths regarding the extent to which you need to be a SQL expert to work as a BI analyst.
---------
This video isn't sponsored but it is supported by people like you who watch, like and subscribe to my content. If you like, you could also buy me a coffee ☕️
buymeacoffee.com/adamfiner
---------
START YOUR BI JOURNEY! - learnbi.online
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - geni.us/powerbi-udemy
Ultimate Guide to Looker Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Looker Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/supermetrics
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#bianalyst #sql #businessintelligence
I will add something out of my own experience. You absolutely want to be a data base owner as a Data Analyst. Of course, you don't want to mess up with the ERP system or the currently existing data warehouse. However, it is ALWAYS possible (don't believe them if they tell you otherwise) to get a small isolated database on one of the company's servers and get a database management tool installed (they are freeware so it is all about getting an IT permission). Use your database to store parts of business logic, which otherwise exist in Excel or are calculated on reporting level: alternative hierarchies, manual number patches, some alternative descriptions etc. Also if you are in need to perform a large calculation, which is slowing your reporting software down, do it in your database. That way your reporting software (I use PBI primarily) gets ready to serve data and the performance of your reports gets a big boost.
I would love to see a video tutorial on how to connect Navicat with a relational database such as MySQL or Oracle and how to use Navicat. Your videos are great! Keep up the good work, Adam!
You're not the first to ask about this so maybe I'll put together a quick video this week 👍🏻
Thank you for all great information you share with us...
My pleasure!
It's help me a lot for work as BI analyst Thank you
It's my pleasure
Hi, this is helpful. I just started Data Analyst self learning. Done excel and power BI but stuck with SQL..
Glad it was helpful!
Don't forget to give the video a thumbs up while you're here 👍🏻
Thank you, I am still waiting for a real example explained as it should explain for a 12 years old
SQL = SELECT FROM WHERE GROUP BY HAVING ORDER BY + JOINS + TVCs + CTEs + WINDOW FUNCTIONS....etc Then you are good to go
With tools like PowerQuery and PowerBI (modelling within a report) that requires no code and is very user friendly, what's the advantage of still using SQL to extract and load data? I get the impression it's achieving the same goal but adding an extra step into a pipeline?
Whereas I agree tools like the ones you mention are getting more advanced, they can only take you so far. You will still need to know SQL to manage and administer SQL databases and create more advanced queries to model your data.
SQL is critical because you can write more complex and targeted querys to power your visualization tools. It has a bunch of tools for doing this like Window Functions. With SQL the database can do much of the data processing work leading to faster rendering of the reports by your visualization tools.
I love lamp .... and SQL
Hi I want to become a business analyst. CAn you make a vide on essential operators only required for business analyst?
Not my area of expertise I'm afraid