Excel For Business Intelligence – SQL Presentation

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 (http://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
Principal Consultant

Simply scroll through the PDF or open using Adobe PDF Reader.
Were you at the event? Please leave your comments and feedback below. We would love to hear from everyone that took the time out of their busy life to attend.

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!

Bookmark the permalink.

About Perry Patterson

The web is your brochure, your vision, your voice. I work with the leaders of your company to optimize your sales, operational efficiencies and internet presence. I am an expert in eCommerce marketing, development and distribution. I’ll manage your programing, business concepts and logistics from beginning to end. I look beyond just placing a presence on the web, but at how you can satisfy the complete client experience with your business. 3Deers.com … Time Well Represented.

Leave a Reply