builds web applications and information portals for both ..

1
Building a PPT from the ActiveInterface web pages

• Chris HarringtonActive Interface, Inc.

2

• Welcome
• Active Interface, Inc. builds web applications
  and information portals for both established
  companies and for Internet startups. We also
  provide customization and integration services
  across the entire Microsoft Windows product line.
  Our client list includes
•   Marconi Technical Education
•   CIBC World Markets
•   Cellomics
•   Marshall Marketing Communications
•   AccuWeather
•   Cancellation.com
•   MortgageRamp
•   SalesGene

3

• PowerPoint Automation Toolkit
•  
• The PowerPoint Automation Toolkit facilitates the
  automated generation of PowerPoint presentation
  from structured and unstructured data sources.
  The different modules which comprise the Toolkit
  include
•  
•   Presentation optimizer Reduces size of
  presentations by optimizing graphics. Can achieve
  100 to 1 compression factor. Helps control
  PowerPoint bloat and reduce download size and
  bandwidth usage.
•   Presentation decomposer Decomposes a
  presentation into component slides and graphics.
  Slides are placed in a repository along with
  slide metadata, where they can be used to create
  new presentations (see Generators below)
•   Presentation generator (desktop) A desktop
  PowerPoint generator.
•   Presentation generator (server) A web server
  based PowerPoint generator
• The presentation generator builds presentations
  which can include static slides and dynamic
  slides. Dynamic slides can contain charts or
  graphics whose features are based upon queries to
  SQL Server or Analysis Services.

4

• ExcelETL Desktop ETL with Excel
•  
• Excel ETL is a Microsoft Excel-based desktop ETL
  solution. In several of our project, we have had
  the need to take data received in Excel or CSV
  format and send this data to a data warehouse
  staging database. Excel ETL is a generic
  framework for accomplishing this task.
•  
• Several modules comprise Excel ETL
•  
• An XML configuration file which captures the
  requirements of the data staging process
• An Excel add-in with which the user interacts
• A staging database generator
• A web service middle tier
• These modules combined allow a user to
• Manually or automatically map Excel columns to
  database fields
• Validate the sheet against the constraints of the
  database
• Cleans and conform strings and flags
• Upload the sheet to the staging database

5
News and Noteworthy   September 28-October 1,
2004 Attended and presented at SQLPASS 2004
Community Summit. See my presentation November
1, 2004 Relauch of company site and ThinOLAP
blog November 8, 2004 Launch of East Liberty
Development web site - constructed with ThinCMS