dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.
$0
per month per seat
SAS Enterprise Miner
Score9 out of 10
N/A
SAS Enterprise Miner is a data science and statistical modeling solution enabling the creation of predictive and descriptive models on very large data sources across the organization.
The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
SAS Enterprise Miner is world-class software for individuals interested in developing reproducible models in a reasonable amount of time. Perhaps the most useful part of SAS Enterprise Miner is the ability to compare models with other models without writing code. The ensemble modeling capabilities is the easiest way to do ensemble modeling I have come across. SAS Enterprise Miner is well-suited for beginning to advanced analysts who know something about advanced analytics. The software is not well-suited for analysts or companies that have little interest in advanced modeling.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Enterprise Miner is really visual and lets you do a whole lot without actually going into the detailed options. For decent results, you should really explore the different advanced options though.
The recent versions of Miner allow users to use R code in Miner. You can then compare several models and approach to get the best performing model.
The resulting data is really well displayed and easy to understand (ex: the lift graph, score ranking, etc.)
Miner has the ability to integrate custom SAS code which allows the user to add functionalities that are specific to the project.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
SAS' customer support used to be non-existent many years ago. Today, contacting SAS customer support is great. They are responsible, knowledgable, and seem to have an interest in getting the results right the first time. With that said, Enterprise Miner's online support is weak, probably because the user base is much smaller than other tools.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
SAS EM has a very great set of machine learning and predictive analytics toolsets, which helped our organization achieve its goals. We used other tools, but for us, SAS EM was the most intuitive and easy to learn the tool and it provides greater data exploration and data preparation capabilities compared to the other tools we used.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
In our organization, users were using SAS already so the learning curve was really low. Within a few weeks after the implementation, the users were already delivering models developed with SAS Enterprise Miner. It is difficult to talk about ROI as models were already being developed before. It was mostly a change of technology and it was a smooth transition.
Going with Enterprise Miner came with migration from desktop use of SAS to a server use of SAS. This created a new role of SAS administrator. This was obviously a cost but as the use of SAS increased greatly, it was expected.
From a methodology standpoint, Enterprise Miner helped greatly in the documentation of the model development which was a requirement in a few groups such as the risk groups. Having a visual "GUI-like" approach to development, the flowchart or diagram of the project in Miner was able to give users a good understanding of the approach the analyst took to develop the model.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
