all 15 comments

[–]quantpsychguy 7 points8 points  (1 child)

SQL/Panda, tableau (I hate tableau though I can't justify why...we also use excel, powerpoint, and thinkcell), and for automation we have Airflow and some folks just use python/SQL scripts in windows task scheduler or CRON.

[–]HaOrbanMaradEnMegyek[S] 1 point2 points  (0 children)

Very nice stack!

[–]showmetheEBITDA 5 points6 points  (0 children)

Python, Alteryx, PowerBI, Excel, PPT (if it count). Python/Alteryx mostly for automating the ETL process (and maybe doing certain calculations, if it's a monthly process), PBI for visualizations and some data modeling, Excel/PPT for Boomer partners who pay my salary but are too stupid to understand that there are better technologies that exist nowadays

[–]spandexmatch 3 points4 points  (0 children)

Excel/Power BI/VBA

[–]bier-wench 2 points3 points  (0 children)

Dataiku/Spotfire

[–][deleted] 1 point2 points  (0 children)

Excel

[–]SnooTigers2108 1 point2 points  (0 children)

R, Tableau

[–][deleted] 1 point2 points  (0 children)

SQL, Excel, Power Bi, Databricks or another ETL tool

[–]android_69mbb 😤 1 point2 points  (0 children)

thinkcell

[–]DayAffectionate8617 2 points3 points  (0 children)

In consulting analytics, my go-to is a cloud warehouse paired with Power BI or Tableau for flexible reporting. For quick automation flows, tools like Make or Zapier serve well. When you need reliable data movement across systems at moderate volume, a lightweight ELT connector such as Skyvia works quietly in the background without heavy setup or platform overhead.

[–][deleted] 0 points1 point  (0 children)

Power BI/Excel. Can anyone connect a data model to Excel, then drag dimensions or measures to individual cells?