Alteryx Platform vs. Bugzilla vs. dbt

I would 100% recommend Alteryx to a friend, for me its friendly interface is the best, it has all the tools I need without the headache that programming is. It can be used for simple or complex analysis, so honestly, I don’t see a scenario where it wouldn’t suit. I’ve used Alteryx to make simple things I could do in Excel, for example, but it was less complex and faster to do in Alteryx, so why not? Its a very versatile tool.

Incentivized

Buzilla is easy to use and provides basic functionality to use as a bug tracking tool. If big size attachments are allowed it would have been great. Also with Bugzilla home->Test management area is improved by allowing multiple sections it would be awesome!

Incentivized

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

• Pulling data from multiple disparate data sources.
• Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
• Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.

• Open source! No license fee involved, no limit to the number of licenses.
• Easy to install and maintain. Installation is very easy and hardly needs any maintenance efforts, except when migrating from one version to other. Each project can have its own group of users.
• Includes all the core features/fields that are needed to log a software bug/issue.
• Multiple attachments are possible, supports various formats.
• Good for reporting. Filtering mechanism lets you query bugs by various parameters.

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

• Steeper Learning Curve: Alteryx can have a steep learning curve for users who are new to the platform or have limited experience with data analytics. Enhancements to the user interface and user onboarding resources could help make the learning process more intuitive and accessible to a wider range of users.
• Enhanced Data Visualization Capabilities: Alteryx offers basic data visualization capabilities, but there is room for improvement in terms of advanced visualizations and interactive dashboarding features. Adding more sophisticated chart types, interactive widgets, and customization options would enhance the data visualization capabilities within the platform.
• Improved Error Handling and Debugging: Alteryx provides error handling mechanisms, but enhancing the error reporting and debugging capabilities would be beneficial. Improved error messages, better visibility into data flow, and debugging tools could help users troubleshoot and resolve issues more efficiently.

Incentivized

• Cloud Based. I'd like to see bugzilla be cloud based. The company I currently work with made a final decision to change db's for this specific reason. Due to the frequency of travel in this company, they need access to bugzilla from differing national / international locations.
• Larger File Attachments. I believe the limit of a bugzilla content upload is 4 megabytes. For many of our video'd issues, this file size is simply impractical without the additional effort exertion on video compressor applications.

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

We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.

For future projects I will look at something that is hosted in the cloud that I don't have to manage. I would also like something that has a more modern feel to allow my customers to use it as well as my employees.

Incentivized

I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.

Incentivized

This is a pretty straightforward system. You put in the bug details, a ticket is created, the team is notified. The user interface reflects this very simple and straightforward flow. It's certainly much easier than trying to track bugs with using Excel and email.

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

I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.

I used it.

Incentivized

I already gave the example of journal entries created in less than a second. What else can I tell you about.... I can tell you those 2 journal entries have historically had to be split into separate accounting systems so the outputs had to be very different (D365 vs Intacct) such that they are exactly ready for uploading. I can tell you I used to have some tire and battery queries hitting a line item detail table and they took hours to run UNTIL I asked IT for a view in SQL and now they're ready in about 5 minutes total. I guess I'd say if anything does take a long time - do some research with others and figure out what would speed them up

Incentivized

I like this rating.

Incentivized

Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions

Incentivized

Since it is open source, it doesn't have customer service. However, the amount of information on forums is vast. If you can wade through it, you'll get what you need

Incentivized

1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person

Incentivized

I know it.

Incentivized

Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...

Incentivized

There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.

Implementation was pretty simple. Particularly because the product cannot be customized so there is not much to do apart from getting it up and running.

Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.

Incentivized

We migrated away from the whole suite of Rational tools because of their massive complexity around administration and inflexibility regarding workflows. In addition, the suite was insanely expensive, and users hated the usability of the tools. We evaluated, and liked JIRA, but because the organization was looking for cost savings, we ended up going with Bugzilla and it's FOSS model so as to avoid ongoing costs.

Incentivized

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

Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.

I used it

Incentivized

• Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
• Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
• Product development - allowed my firm to create products that we have been able to market and sell to clients.

Incentivized

• It has made the SDLC process more efficient. Bugs were logged and tracked in emails or in Excel sheets leading to slow communication and at time version issues with multiple files. Being an online tool, Bugzilla solved those issues, improved communication, instant status updates and improved efficiency.
• We have used Bugzilla with a lot of federal goverment agencies (DHS, CMS, SAMHSA, CDC, HHS etc). Project Directors adn Principle Investigators were at times given access to Bugzilla which provided a snapshot of open vs closed issues.
• Some groups would resist using Bugzilla with the email reminders being the main reason. Turning off or reminding them of features where we can 'control' email notification helped a lot.

Incentivized

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

Incentivized