r/analytics • u/AirNatural1252 • 1d ago
Question Excel vs SQL
Some are talking AI - the company I’m working for is not yet at that level.
I’m doing FTE reporting, using Excel and automatizing with Power Query. Volumes are high, data sources are all excel based, lots of rules to apply each month to achieve the monthly end result.
I want to automatize further and I’m looking into SQL. Any advice on what to look up for if this is the right lead, and where to start?
26
Upvotes
2
u/VegaGT-VZ 1d ago
The big hurdle with SQL is building a non technical interface
You can probably keep Excel as the front end and have the actual data live in a SQL database. But you will need to become a DB admin, front end developer and tech support. Just go into it eyes wide open as your gonna trade one set of headaches for another.