dbt vs. Sisense

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.

Incentivized

I believe Sisense is perfectly suited for any organization of any size that have access to the proper resources, as the tool is very expensive. The data connectors come in all shapes and sizes out of the box, which allows a great deal of data control within the ElastiCubes. Additionally, while the platform only runs on Windows platforms, the web application can be accessed on any client: mobile, Apple, Windows, etc. This allows a much more flexible user experience, resulting in data and dashboards reaching further than any other tool.

Incentivized

• dbt supports version control through GIT, this allows teams to collaborate and track the data transformation logic.
• dbt allows us to build data models which helps to break complex transformation logic into simple and smaller logic.
• dbt is completely based on SQL which allows data analyst and data engineers to build the transformation logic.
• dbt can be easily integrated with snowflake.

Incentivized

• Customization - lots of supported and community plugins available. Users can also adjust the look and feel through JavaScript.
• Innovation - Sisense is continuing to push the envelope by developing new features through Sisense Labs.
• Customer support - the commitment to excellent customer service and ensuring organizations get the most out of their investment.

Incentivized

• Field-level lineage (currently at table level)
• Documentation inheritance - if a field is documented the downstream field of the same name could inherit the doc info
• Adding python model support (in beta now)

Incentivized

• The usability of the application on mobile devices needs some improvement, especially navigation and filtering.
• Dashboards that are created by multiple users can be a bit of a hassle to share by Admins.
• If you need to embed dashboards into your website, you are require to buy a license separate from the user and platform license. This is a norm on most BI visualization tools, but Sisense can seem a bit on the high side, cost-wide.

I think the business and myself as a user has come to rely on SiSense as a dashboarding and quick ad-hoc reporting tool. I am hoping to integrate SiSense dashboards into more parts of the business in the future. We have reduced our report turn-around time for the most part from hours/days to minutes and in some cases almost the speed of thought. Reports are also easier on the eye and more easily distributed. I would also like to say that the support and professionalism from the SiSense team has been excellent.

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

New V5 is ground floor of an exciting collection of possibilities. Weekly Sisense developers come up with new functionality that they share with us in their forums. The move to HTML5 has been pleasing in that widgets auto size themselves into appropriate forms in the board but everyone of them can be popped out to full page size to be looked at in more detail

There are very few situations when there is unexpected downtime. Mostly during development, new dashboard implementation and during upgrades. other then that there were very few crashes.

SiSense is usually performing better then other solutions even if going for complex reports/dashboards(of course within reasonable frames). I haven't noticed any bad influence on other systems, usually if something happens it stays within SiSense.

SiSense's support ninjas are very knowledgeable and are exceptionally responsive. So far, all of the issues we ran into were resolved within minimum time. My sense of dealing with the support staff at SiSense is that they are very focused on not just answering your immediate question, but also to delve into the cause of the matter.

Easy and free training that allowed us quickly understand basics in SiSense and start using them. More advanced features requires some browsing through SiSense forums, but there is always support to help, and SiSense support is one of the best whith which I worked so far.

Many examples, videos and scenarios which you try on your own right away. This combined with in-person training gives you enough to utilize most of SiSense's power.

Remember to migrate the plugins. The documentation however is pretty straight forward.

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.

Incentivized

1) Easy to use, really, there is nothing too much to say. The set up is easy and not confusing. You can use it internally or externally.

2) Customer Service, having spoken to various product reps from similar industry. Sisense rep provides you with the best support to get started, and it is really appreciated.

Product is quite easily scalable. The whole installation can be easily moved to stronger machine if needed.

• Simplified our BI layer for faster load times
• Increased the quality of data reaching our end users
• Makes complex transformations manageable

Incentivized

• Report development time is reduced from 2~3 days to 2~3 hours.
• Report querying time is improved from 0.5~10 mins to 2~30 seconds.
• A 2-staff team delivers 10 times the BI output that we did on the old system.
• We were able to deliver BI and data analysis for all business functions instead of a very limited group of users