What does the software or service do well? Even though Domo may have some heavy lifting at first to get everything setup just right, what it ends up accomplishing for you is unparalleled by anyone else in the industry. There's a reason they're financed by BlackRock and other large investment firms. They have revolutionized the BI world. Everything you need is in one place, cloud-hosted, highly available, with limitless capability and connectors to anything you need including custom connectors as an option.
What does the software or service not do well? Other than the really high price tag (which it friggin deserves btw), data flows are much easier when sources have a well built and RESTful API. We use ADP for HR internally, and they have one of the worst API's ever created in the history of mankind. So when we needed to connect to their data, they were going to have to charge us for them to higher a vendor to make our own data available to us externally. This is admittedly not Domo's fault, but is part of the lay of the land when you have a tool that can ingest all the data in the world you need for reporting.
What do you wish you had known about the software or service before using? Pricing and the different forms of licensing can be confusing to understand at best. When we first spoke to Domo they only mentioned the existence of full licenses, which we couldn't afford for everyone, and it took a lot of prying to finally find out there are at least 5 different licensing models that each of your users can be using with much cheaper pricing options than the full licenses.
Have you used a competitor to the software or service? If so, how does it compare? We started off originally with Microsoft SSRS and Power Bi, then we moved to Sisense, and finally ended up with Domo. Sisense was a great first step for us to be able to restructure and organize all our data in our DW, but their support was terrible since all their high level techs were only in Israel and we'd have to wait until their timezone came online for any critical issues. Domo has been a Cadillac breeze by comparison - just with a fitting high price tag to boot.