I’m getting a new work laptop next week: Hooray!! ??
I’m going to have to install A LOT of software: Opportunity! ??
Problem: I have a lot of meetings next week, and I don’t want to be distracted by installing a bunch of different pieces throughout the day.
Solution: Chocolatey! ??
What is Chocolatey?
“Chocolatey is a package manager for Windows (like apt-get or yum but for Windows). It was designed to be a decentralized framework for quickly installing applications and tools that you need”
(excerpted from Chocolatey.org)
How does it work?
First you install Chocolatey, then you install the packages (very similar to installing a PowerShell module).
What the heck does this have to do with Business Intelligence? Well, it takes a lot of different pieces of software for me to do my work as a Business Intelligence Developer. Although in the future, with VS Code & Azure Data Studio, some of these smaller pieces of software may turn into extensions for those editors. Who knows? But if you take a look at line #9 of the script below, that single line of code will install Power BI Desktop for me.
I took a look through the list of Chocolatey Packages and found a ton of stuff I use. Unfortunately I didn’t find packages for any of the following tools:
- DAX Studio
- DAX Formatter
- Power BI Helper
What am I missing?
As I mentioned, I already found packages for a lot of software I already have installed. My question to you is: What packages am I missing that a Business Intelligence Developer who is starting to work with Databricks, should have?
Please comment with a link to the package!
Want to give it a try?
If you have never tried Chocolatey before, the steps are pretty simple.
- 1) Open PowerShell as an Administrator.
- 2) Run the first line of this Gist I embedded (below).
- 3) pick any line of code below and install one of those packages.
I plan to keep this Gist public, and update it with more packages as I find /am told about them.
Cheers!
The post What Chocolatey Packages Does a Business Intelligence Developer Need? first appeared on SQLvariations: SQL Server, a little PowerShell, maybe some Power BI.
