more-arw search

Q&A Forum

Looking for a Business Intelligence Software Recommendation - No Vendors Please

Mollie Mossman's Profile

We have a legacy AS 400 (Microsoft) and a newly created data warehouse but need to get a quick to implement dashboard up for ourpresentations to the CEO. What software have you evaluated and can recommend? Thank you, proformative peers. --Fellow CPA CMA & CFO from Texas

Answers

S McDowell
Title: Controller
Company: SCI Electronics
LinkedIn Profile
(Controller, SCI Electronics) |

Power Pivot. It's free, but learning it will take some time. Look it up on MS website. Also look at this website: www.powerpivitpro.com

J Mankal
Title: BSA
Company: jmankal@assoc.com
(BSA, jmankal@assoc.com) |

it's powerpivotpro.

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

Mollie,

PowerPivot (watch the typo in the URL provided above) may do the trick, but it may not be needed or possible. It is a slick tool when it's called for, and when you have the right teacher it doesn't take more than 15 minutes to learn.

Normally I recommend tweaking the accounting system to be able to produce a dashboard. In this case it may make sense to export to Excel, update from your last data dump, and have a tool standing at the ready which automatically produces the KPIs and trends that you need.

Before I recommend Excel tools and techniques, I'd want to know more about the structure of your data, your KPIs, and how you like to view those KPIs. PowerPivot may be what you need, but its availability depends on what version of Excel you're using. You might find useful any combination of PowerPivot, regular PivotTables, formulas, graphs, sparklines, and formulas.

Let's talk, CPA to CPA.

Regards,
Jaime

Jaime Campbell, CPA, CGMA, MBA
Chief Financial Officer | Tier One Services, LLC
"Entrepreneurship Evolved"
jcampbellcpaattieroneservices [dot] net

1489 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.