We looked at Coefficient because the Membership system we are using for the Cambridge 50+ Woodworkers club is great but is very weak on reporting, and we need a fast way to get our data out of our MySQL Db and into Excel. We were impressed with what we found.
The installation was seamless. Once we entered our Db credentials, we connected securely and could see our tables. Once we selected our tables, the import into Excel was very efficient. Our Db is small, the largest table only has about 5,000 rows, but we were still surprised that the import time just took just a few seconds.
With the tables in Excel, we were now able to create the relationships we needed and start developing our reports. The process from getting set up to seeing our first report took less than a day.
We scheduled daily refreshes so that we knew that our reports would be accurate up to the day prior which is more than adequate for our needs.
Before retirement I worked in the design and development of enterprise e-commerce systems. There were times we could have really used a product like Coefficient to be able to produce ad-hos reports quickly. I highly recommend this product. Review collected by and hosted on G2.com.
As with any product, there are downsides, but I can honestly say that to date, we have not found any . I suspect we might run into something, but for now it's up and running smoothy and have had no issues. Review collected by and hosted on G2.com.
Eric, it's so great to hear you've had such a good experience with our MySQL connector for Excel! Thanks for sharing your story. I also WISH that something like Coefficient had been around my entire career. It's definitely one of those... "where has this been all my life" kind of tools! -Hannah
The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user.
Validated through a business email account
Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate.