dbt (data build tool) vs Visual Studio IDE

• Transforms data for easy and quick reporting
• Optimizes report speed and performance
• Able to schedule

Read full review

• Since Microsoft offers a free Community Edition of the IDE many of our new developers have used it at home or school and are very familiar with the user interface, requiring little training to move up to the paid, enterprise-friendly editions we use.
• The online community support for Visual Studio is outstanding, as solid or better than any other commercial or open-source project software.
• Microsoft continuously keeps the product up to date and has maintained a history of doing so. They use it internally for their own development so there is little chance it will ever fall out of favor and become unsupported.

Read full review

• Deployment and sharing of generated documentation outside of dbt cloud could be simplified.
• Make the artifacts generated by dbt easier to consume (build log, test results, manifest) for use in analytics and ops.

Read full review

• Certain settings and features can sometimes be challenging to locate. The interface isn't always intuitive.
• Sometimes there are too many ways to do the same thing. For example, users can quickly add a new workspace in Source Control Explorer when a local path shows as "Not Mapped," but it doesn't indicate that the user might want to check the dropdown list of workspaces. The shortcut of creating a new workspace by clicking on the "Not Mapped" link can lead to developers creating too many workspaces and causing workspace management to become unwieldy. If the shortcut link were removed, the user would be forced to use the Workspace dropdown. While it can add an extra step to the process, workspaces would be managed more easily, and this would enforce consistency. At the very least, there should be a high-level administrative setting to hide the shortcut link.

Read full review

• dbt has reduced our time to insight dramatically.
• dbt has allowed us to leverage packages and analytics from our other vendors (Fivetran).
• dbt has empowered our Analysts to build and manage their own models without adding more engineering resources.

Read full review

• We've had hundreds of hours saved by the rapid development that Visual Studio provides.
• We've lost some time in the Xamarin updates. However, being cross platform, we ultimately saved tons of time not having to create separate apps for iOS and Android.

Read full review