|
|
|
|
|
|
by bshipp
1077 days ago
|
|
|
I enjoy using SQL but the idea of using it instead of Excel to visually explore and manipulate data makes me wince. I can do without Word or PowerPoint but Excel, despite all its data handling warts, remains an exceptionally powerful tool for quick one-off data explorations. I prefer combining SQL with Excel by generating a query that gets most of what I want inside the database and then importing it into excel's powerquery to further explore the individual vectors. |
|
|
For so many one-off data importing jobs I just end up generating SQL in Excel after using the text import wizard to get the data into Excel.
It's kinda stupid but it just works so well most of the time. If I sense I might do it again I tend to script it in something more proper tho.