July 13 was a great day at the IT Pro Camp hosted by Keiser University in Ft. Lauderdale (http://itprocamp.com/southflorida/south-florida-it-pro-camp/). I was honored to represent 3Deers and do a presentation on utilizing Microsoft Excel as a front end tool for Business Intelligence.
Many people do not realize that you can use Excel to directly access a SQL, Access or other database. 3Deers finds that Excel is an amazing tool and the reports are easy to create, maintain, and (best of all) clients love them and use them! Our presentation at the IT ProCamp spoke on this topic.
We had a great turnout and response from folks that came to the event. People asked if we would publish our notes on our wedsite. Below is a PDF file of the presentation on Excel For Business Intelligence, as requested. The presentation / demonstration used a simple access database with ZIP Codes and an excel spreadsheet where we connected to bring in the data. I am happy to share the database and spreadsheet to anyone interested. To get a copy of the documents, please send me a note through our contact form (https://www.3deers.com/who-we-are/contact-us/).
Our thanks to Keiser University for hosting and Sherlock Tech for organizing the event. There was a great gathering of the speakers the night before and we really appreciated how well everything went on Saturday.
Perry T Patterson
For those not able to attend or anyone looking for a speaker at a business event, please let us know. We are always to share our concepts of how easy it is to get useful information from almost any database management system. Whetheryou are using SQL, Access or even FoxPro, Microsoft Excel is a premier took for Business Intelligence Reporting. Your users will thank your, your accountants will thank you and your BOSS will thank you!