Hive vs. Smartsheet

Hive is a powerful tool for data analysis and management that is well-suited for a wide range of scenarios. Here are some specific examples of scenarios where Hive might be particularly well-suited: Data warehousing: Hive is often used as a data warehousing platform, allowing users to store and analyze large amounts of structured and semi-structured data. It is especially good at handling data that is too large to be stored and analyzed on a single machine, and supports a wide variety of data formats. Batch processing: Hive is designed for batch processing of large datasets, making it well-suited for tasks such as data ETL (extract, transform, load), data cleansing, and data aggregation.Simple queries on large datasets: Hive is optimized for simple queries on large datasets, making it a good choice for tasks such as data exploration and summary statistics. Data transformation: Hive allows users to perform data transformations and manipulations using custom scripts written in Java, Python, or other programming languages. This can be useful for tasks such as data cleansing, data aggregation, and data transformation. On the other hand, here are some specific examples of scenarios where Hive might be less appropriate: Real-time queries: Hive is a batch-oriented system, which means that it is designed to process large amounts of data in a batch mode rather than in real-time. While it is possible to use Hive for real-time queries, it may not be the most efficient choice for this type of workload. Complex queries: Hive is optimized for simple queries on large datasets, but may struggle with more complex queries or queries that require multiple joins or subqueries.Very large datasets: While Hive is designed to scale horizontally and can handle large amounts of data, it may not scale as well as some other tools for very large datasets or complex workloads.

Incentivized

Smartsheet shines for collaboration. When you have multiple people involved with planning events Smartsheet makes it easy to share and collaborate. For instance, multiple people can be in Smartsheet working at the same time. Also setting permissions for exactly those who need to know is quite easy with Smartsheet. For data analytics and general spreadsheet purposes Excel is better but for project management and event planning Smartsheet is superior

Incentivized

• Simplicity, it offers a clean environment without risking the outcome. An example of this are the timesheets that allow a fast way to keep track of progress
• Interaction, the different options make it faster and easier to interact and collaborate in the development of a product. An example of this would be Hive Notes for meetings
• The different visualisations it offers allow to explore the best ways to affront your projects. I really like the Gantt mappings view to understand who can be contacted at each point

Incentivized

• Its hard to overstate the value of familiarity. Being able to use a tool that has some familiarity takes away the time needed to train and orient employees on a new tool and allows an organization to hit the ground running.
• Smartsheet covers most of the basics of a project management tool, the usual tasks, milestones and project viewing options.
• For data viewing, you get multiple data viewing options including a calendar view (good for marketing teams and those who work around scheduling), Kanban, Gaant etc

Incentivized

• Organizing tasks by assignees could be better. It's a little cumbersome to check off each person you want. Can you group these?
• I don't really use any view besides task view. Is there something better I could be using?
• It would be nice if attachments showed up in a nicer format, maybe with a preview?

Incentivized

• Smartsheet set up is similar to Excel, yet when you upload an Excel file, things like conditional formatting are lost. Smartsheet has its own conditional formatting, and you have to reinstate the rules. It would be great if those would apply automatically once a file is uploaded
• Some Smartsheet management and access rules can take some tweaking to work properly. This may be a case of offering more info to admins so they can apply these better and with more efficiency

Incentivized

It definitely meets our needs as far as organizing and archiving our tasks and files. As we train more staff to view it, I see opportunities for more improvement, which I am sure this program can handle. I look forward to seeing continued improvement from Smartsheet on their capabilities and functionality.

Incentivized

Its a easy tool, the best way to organize the workflow but has room for more improvements.

Smartsheet is very easy to learn. However, while I have been able to pick it easily, Microsoft Excel and Project super users that I have trained on Smartsheet get bogged down in the differences and can find it frustrating. Explaining the differences ahead of time and why Smartsheet is being chosen instead of a different software seems to counteract those reactions

Incentivized

Our CSR is easily accessible and they have support built into the app itself. They also have a pretty robust support site. We also took advantage of the free trial and learned so much by putting Hive through the paces and figuring out the best way to mold it to our needs.

Incentivized

I give this rating because it fills a niche in the market. MS Project scares many away from proper task management but there are limited tools our there, especially cloud-based that are mobile-friendly. Smartsheet fills this market gap, especially for small to medium-sized businesses. IT is not fair to compare it to MS Project, but fairer to see what gaps it fills.

Incentivized

It's absolutely paramount to take a few minutes to actually play with the software. It's nearly impossible to do anything wrong or make a mistake which cannot be fixed easily. Under the help menu is Live Training option. After you familiarize yourself with the commands, watch the live training for some in depth understanding of how to make the software fit your needs perfectly.

Hive is a bit different than Jira and Monday, which I used mostly. Overall does a great job managing project and helps with team communication. Removes dependency of asking team members for updates by going to conference rooms. With Hive, the team updates the status, and we can easily track it.

Incentivized

Jira and Redmine are much more robust and technologically advanced project management solutions. I enjoy using either when managing a very large project. However, I prefer to use Smartsheet for my smaller to medium sized projects. As for Google Drive - I would say that Google sheets and Smartsheet are almost identical in my opinion when it comes to functionality. Personally I prefer to manage smaller projects via Google Drive, but it is a personal preference!

Incentivized

• Workflow Management will help you better move your projects along which saves time and money.
• Time tracking will allow you to better manage the hours and keep your contractors accountable.
• Overall visibility of projects allow you to keep your margins down and combat "bleeding" and hidden costs or surprises.

Incentivized

• This has really opened up collaboration across teams. A lot less working in silos.
• It hasn't fully replaced any one tool so it means having to go to another place. Hopefully, we can eliminate a tool or two in the next six months.

Incentivized