Max graduated from the University of Michigan with a degree in Economics. Upon graduation, he completed a two year Fellowship program called Venture For America where he developed a passion for entrepreneurship. He joined the DealCloud team as an implementation analyst, and is now their lead Sales Engineer.
For most firms, generating these reports means putting together an excel spreadsheet and spending time to properly sort and format the report every time it needs to be created. Why Excel? What other options do you really have?
“Garbage in, garbage out” is a saying used to describe the need to ensure clean data goes into a system so that clean data can be reported out. It even has its own wikipedia page.
The reality though is that its hard to ensure that everything going into a CRM is clean, especially when potentially dozens of people are adding data to it regularly. Things like adding contacts and companies often leads to having duplicate records, which adds to data sprawl and difficulty in reporting fully or accurately.
There are times though where Excel just won’t cut it for what you are trying to report on. Rows and Columns are great, but not for when you need to create something that incorporates specific formatting, logos, or anything else Microsoft Word handles well.
Excel is so ingrained in the daily process of the private capital markets, it would be nearly impossible to replace it as the workhorse for analysis and reporting. Many CRM systems offer the ability to export data seen on screen to Excel, but with 3 important caveats:
Dashboards – probably the most popular buzzword used by software companies to describe how simple and easy to consume data is from their platform. What’s not to like? Dashboards can roll up vital information, they can surface information you might not be aware of, and they look cool.
The problem with Dashboards in most generic CRM systems is they are incredibly limiting in what you can display. Some quick examples from widely used generic CRM: