3Deers.com, LLC
Facebook Twitter LinkedIn Mail
  Menu
Skip to content
  • Home
  • Excel for SQL Business Intelligence
    • Overview
    • How to Connect to SQL from Excel
    • Create Your First SQL Report In Excel
    • Excel Table Best Practices
    • Multiple Tables For Useful Information
    • SQL Joins for Better Table Links
    • Build Intelligence into your Business Data
    • Pivot Table Cleanup
    • Graph and Show Results
  • Who We Are
    • Perry T Patterson
    • Perry-Isms
  • Blog
  • Technical Papers
    • ExtraNet Case Study
    • eCommerce and Sales Tax
  • Contact Us

Category Archives: SQL-Excel Tips and Help

But I want it in Excel!

By admin | June 26, 2015|June 26, 2015 SQL-Excel Tips and Help
Leave a comment

Did you happen to catch one of my two classes at SQL Saturday?  My topic (which I love to speak about)… But I want it in Excel? SQL Saturday 379 was on June 13, 2015 at Nova Southeastern University, in Davie, Florida. It is always an honor to speak at my Alma Mater (graduating in… Continue reading →

SQL Connections Slow on Windows 8 and Excel

By admin | April 10, 2014|April 10, 2014 SQL-Excel Tips and Help
Leave a comment

Named Pipes.  That’s the Jeopardy answer to a question that took 3Deers a month or so to answer regarding a sever slowdown in the queries from Microsoft Excel to a SQL database.  Named (freaking) Pipes. For folks that use Excel to access SQL and do great Business Intelligence Reports (like… Continue reading →

Excel For Business Intelligence – SQL Presentation

By admin | August 1, 2013|August 1, 2013 SQL-Excel Tips and Help
Leave a comment

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… Continue reading →

IT ProCamp – Excel for Business Intelligence

By admin | July 8, 2013|July 8, 2013 SQL-Excel Tips and Help
Leave a comment

I am trilled to announce that I have been selected to speak this weekend at the South Florida IT ProCamp on Excel for Business Intelligence. Continue reading →

    • My Journey with Co-Pilot
    • SQL and Excel Tips and Tricks
    • Independents Exchange

  • IONOS Cloud and Website Hosting

  • Laptops on Sale at Amazon