Sigma

Avantages

The speed with which I'm able to pull together disparate data and generate some useful insights.

The Dashboard functionality has been particularly useful in creating reporting our teams can use with customers and prospects.

Inconvénients

Version management and permissions. It's hard to keep everyone looking at the same version of a document, to view data, a document is created and generically named, so our folder system is getting very full and hard to navigate. Additionally, there's no way to tell if another user will be able to see a given document without asking them to try viewing it, and there's no way for them to request view access to that document.

Avantages

Ease of use, especially the ability to write custom SQL queries to build datasets and reports. The visualization builder is also very user friendly and has made throwing together dashboards for internal or external use significantly easier. Saves me and my colleagues a ton of time!

Inconvénients

There have been some features identified by the team that we need for Enterprise-level software that were missing, many have been addressed though. A major bugbear of mine is that the filters don't seem to react to each other if there are multiple on a dashboard, they filter independently of other inputs.

Avantages

I like how customizable it is. From a good basic report I can move things around to suit my needs. In addition it has many options for how to export, which is great as I use excel for more complex files & google sheets for collaborating & sharing findings.

Inconvénients

Load times to get to a report or filter can be killer for some reports that pull from many data sources, and have large amounts of information. The permissions are a bit annoying when a report is created for me by an admin, but I am the report owner (as it was made for my department), but I can't make my own changes (w/o admin privlidges) and archive the main one. In these cases, I have to request the admin to make the changes, or make a copy and publish my own report and again contact the admin to delete or move the report so that mine is the one the team goes to first.

Avantages

- You can easily add data sources, and then create datasets with the columns you need
- It also lets you format the columns and process the data by using formulas, very similar to what you would do in a spreadsheet, but more streamlined
- You can easily join different datasets and filter data
- The new dashboards are very easy to use, with a clear interface to add widgets, filters and views
- They also have quick and effective customer support

Inconvénients

- It can be a little intimidating if you are not familiar with spreadsheets

Avantages

Is an easy to use software, I liked that it's very fast, I don't have to wait to start seeing the data

Inconvénients

It needs more features, specially to migrate the worksheets to different environments, also it has a very limited number of functions. Sometimes the error messages are not very descriptives, so we can't know what's happening or how to solve it (we had a worksheet with an error like: "the joins are not efficient", something like that, so that message was kind of useless)