How I Use SQL as a BI Analyst

[@jhazpetersen7008]

Finally, a more sound and grounded explanation

[@alexgry4763]

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.

[@LearnBI]

Don't forget to give the video a thumbs up while you're here 👍🏻

[@blakevorwerk4732]

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!

[@LearnBI]

You're not the first to ask about this so maybe I'll put together a quick video this week 👍🏻

[@AliAli-xt6ow]

Hi, this is helpful. I just started Data Analyst self learning. Done excel and power BI but stuck with SQL..

[@LearnBI]

Glad it was helpful!

[@tombarrows5332]

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?

[@LearnBI]

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.

[@apamwamba]

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.

[@carlospelay9642]

​@@apamwambaI'm curious about your statement that sql can still be useful in writing more sophisticated queries even in the context of a PowerBI /PowerQuery environment. A re you referring writing dax to create measures or using some other tool to incorporate sql code into the data preparation flow? Thanks.

[@ampagetech2624]

The easiest work horse for such data wrangling is the humble msaccess - it can connect to any data source that has an odbc driver. With that you can do amaazing transformations of daaata using its very eaasy query GUI. Summarizing , creating new sub datasets , creating new fks and joining - ay thing you can think of in sql can be done with its GUI

[@LearnBI]

An interesting take

[@alannahsteevens5102]

Why would you use SQL rather than DAX and M in Power BI? Just a general question

[@apamwamba]

SQL = SELECT FROM WHERE GROUP BY HAVING ORDER BY + JOINS + TVCs + CTEs + WINDOW FUNCTIONS....etc Then you are good to go

[@mehmetsaka5261]

Thank you for all great information you share with us...

[@LearnBI]

My pleasure!

[@flickhunter8900]

Hi I want to become a business analyst. CAn you make a vide on essential operators only required for business analyst?

[@LearnBI]

Not my area of expertise I'm afraid

[@werapatmalikhao6016]

It's help me a lot for work as BI analyst Thank you

[@LearnBI]

It's my pleasure

[@DanielHernandezCa]

Thank you, I am still waiting for a real example explained as it should explain for a 12 years old

[@CharlesMartel829]

I just ask Chat GPT and copy and paste.

[@LearnBI]

Genius

[@richardduncan3403]

I love lamp .... and SQL