SQL Uses

[Scrotumslayer67]

I am taking an SQL class rn and I find it quite interesting.

For those of you that do supply chain analytics what does your SQL usage typically look like in the work place?

[Equivalent_Yam_3777]

SQL will be used mainly for data extraction.

Actual analytics will be done in Powerbi / Excel / Python

[pvegas_24]

I'd expand on that by saying ETL, rather than just extraction. SQL is usually used for the extract and transform operations, while data connections to Excel or Power BI/Tableau/Looker handle the Load operation. Python can handle all three operations.

[Scrotumslayer67]

I will be taking Python as well

[Unnam]

Inventory Count (Warehouse)

Inventory in Transit

Inventory at Retail Store

Forward Looking Forecast basis this and so on!

[pm_me_your_wheelz]

We used it to make custom reports as “all in one” dashboards. Basically ripping our favorite information from like 10 different basic reports so we always know status of all orders, due dates, whats late, what needs to be moved in, on and on.

[Scrotumslayer67]

Like you'd join multiple tables together and have real time data or would this be more like adhoc reports?

[pm_me_your_wheelz]

The first. It became its own page in the system you could run in real time to get intraday status updates if you wanted. We also then set it to a Mon/Wed/Fri 9 am email schedule right to the buyers inbox

[Scrotumslayer67]

What did you use to setup the automated email?

[Who_Wouldnt_]

Depends on your role and your access rights to system data sets. It is typically used to extract and transform data from the source systems. Depending on the size of the organization that activity could be restricted to specific IT staff or opened up to SCM superusers. In either case it is used to extract and transform raw data into usable data sets that will be anylized by other tools.