I wanted to take some time to go over the varied software tools I have made use of both previously as a Software Engineer and currently in my role as a Data Analyst – several of course, overlap!
Note that a large portion of my career has been in a Microsoft-centered IT department, aside from our Oracle back-end.
Starting more in the role of a Software Engineer, previously I used the following in my day-to-day:
- Visual Studio Enterprise 2019 (v16)
- Toad for Oracle Xpert (v14)
- Visual Studio Code (v1.60)
- Notepad++
- Ditto Clipboard
- Chocolatey Package Manager
- QTTabBar File Explorer extension
- Azure DevOps
- CatLight Action Center for Developers
- NuGet .NET Package Manager
- Git Version Control
Having served so long on the Development Team as a Software Engineer, I still use a lot of the same tools as the need arises. This saves time waiting for someone else to find an answer I can readily get to myself, and insight into a lot of our common business workflows.
Now as a Data Analyst however, I spend a lot more time using the following:
- Power BI Report Server (January 2021)
- Power BI Desktop (January 2021)
- Microsoft Report Builder (v15)
- SQL Server Management Studio (v18)
- Toad Data Point (v5)
- Oracle SQL Developer (v20)
- ZoomIt
- Windows Terminal
- Oracle Business Intelligence
And of course there are several I have on my to-do list to investigate further in the future:
- Dax Studio (v2)
- Tabular Editor (3)