dbt vs. Salesforce Data Cloud

dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python.

Incentivized

Being a mid sized organization, the costing is achievable, but can’t say for those of startups. So I believe not suitable for small scale organizations and very well suited for large data analytics companies to gain market. Also, the maintenance is slightly difficulty and support for the product is comparatively slower than other similar products.

• user experience makes it easy to work with SQL and version control
• customer success team and the dbt (data build tool) community help establish best practices
• thorough and clear documentation

• Analysing customer trends
• Detailing information to gain market
• Reporting and analytics
• Improved security
• Providing data analytical tools and less scope of error

• Slow load times of the dbt cloud environment (they're working on it via a new UI though)
• More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros

Incentivized

• Very expensive
• Does not integrate with HubSpot (another CRM). We have tried many times and it does not seem to connect
• Sometimes the website will load very slow where other websites are much quicker

Incentivized

dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.

Incentivized

it is easy to use after you get the hang of it. If you have an internal team of developers you will be able to maximise the usage a lot better. I would recommend it to people who need to organise data in a more unified way but I can’t speak to it from an infrastructure perspective as I’m not from the infrastructure team

Incentivized

Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.

Incentivized

I like Salesforce Data Cloud because like mentioned before, it is easy to use, easy to generate reports, create workflows, keep track of customer data, sales data, house data, etc. You can also import excel sheets with customer data as well and it will create the fields for you which is nice

Incentivized

• In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers.
• We are using it continually for the past year with no issues.
• Sorry, I don't have ROI numbers but the impact was huge.

Incentivized

• Salesforce Data Cloud has a positive impact on me as a realtor because it is easy to generate reports on customer data and see what is needed to be bumped to the next level. We have to earn a certain commission by the end of the year and it makes it easy to see how close you are
• It has a positive impact on keeping track of customers because it is nice to have it all in one place which is a nice time saver
• I like that you can even see customer info from other agents making it nice to compare and try and pass others
• Makes the customers journey smooth sailing because everything is in one place

Incentivized