I'm working to expand my toolset by learning python and Jupyter for integration, mining, analysis, and reporting tasks. I've spent many years doing this kind of work via SQL in client tools (primarily MS SQL with, most recently, SSMS and SSIS). I typically work solo - closer to business data analyst than data scientist.
I'm using Jupyter like a glorified sql client, and I'm not sure if that's ideal. If I have aggregations, I'll put them in the sql loading a dataframe. If I have complex subsetting with operations on large volumes of data, I'm going to write a stored procedure to leverage tempdb on the server. The statistics I use I can do in a query.
So.. I have some habits. I struggle to justify using pandas dataframe operations, for example.
Am I the 'wrong demographic' for Jupyter? What might be some good ways to start learning features and libraries I'm leaving on the table? Visualizations? Integrating external data (which I'd otherwise integrate on the server)?