• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
    • Websites / Hosting
      • Author’s Sites
      • Boutique Websites
      • Corporate Websites
      • Open Source CMS
      • Quick and Dirty Websites
    • SQL Databases / VBA Automation
    • GIS / Market Research
    • Government/Planning
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Clients
  • Articles
  • Contact Us

SQL Databases / VBA Automation

FSI has more than twenty years of experience in database applications and custom reporting for large and small corporations.

We have developed a specialized approach as an alternative to expensive Business Intelligence (BI) software such as Business Objects or Cognos.   Our solution will leverage your existing software investment in a DBMS and Microsoft Office, and build an automated reporting system that will serve decision support and operations.  Time and time again we have seen expensive Business Intelligence solutions go underutilized when management and operations just want the reports in highly formatted (filtered, fixed, colorized, etc.) Excel files.

We have specific knowledge with market research and customer data, particularly in the financial sector.

We have many thousand lines of code in SQL and Visual Basic (for applications) to automate repetitive processes in Excel, Access and PowerPoint.  We have built solutions for large systems utilizing server-based procedures to do the heavy lifting and Visual Basic (VBA) to deliver beautifully formatted, custom reports.  An entire reporting system can be scheduled to serve hundreds of reports to multiple internal clients. This is Business Intelligence that will actually be used at a fraction of the cost.

CASE STUDIES

  • Automating PowerPoint
    Populating data-rich PowerPoint presentations (Phoenix Healthcare).
  • Daily Makeover
    Automating web analytics using Excel VBA
  • Migrating Survey Panel Data
    Database migration of panel data (MediaMark Research Inc.).
  • Automating “Rogue” Reports
    Automating complex Excel reports using corporate data (JP Morgan Chase).

PARTNERS

  • TNG Research
    Media research and database development

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.

Finding Solutions

We work with you to make things faster, easier and better.

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2021 · Foster Solutions (FSI) · All Rights Reserved

Back to top