Windchill Business Analytics

Project Summary

The main goal of this project is to provide a simplified interface that displays useful business metrics from a Windchill server. It utilizes HTML5's AJAX technology to update graphs and tables automatically without the need for a complete page refresh. A program runs on the server to generate XML data from the database which JavaScript reads into the webpage.

As with everything else you see on my site, I am doing this completely on my own time because I've always had a passion to design and create. Please enjoy!

Programming Journal

Main Loop

Part 01: Program Logic

Part 02: Getting Data with SQL Queries

Part 03: Automating SQL Queries

Part 04: Converting SQL REsults to XML

Part 05: Data Processing and Manipulation

Part 06: Displaying XML in HTML

Part 07: Auto Updating Displayed Data

Updates:

September 18, 2016 - Part11 Creation
September 2, 2016 - Part10 Creation
August 31, 2016 - Part 09 Creation
August 22, 2016 - Part 08 Creation
August 21, 2016 - Part 07 Creation
August 19, 2016 - Part 03 Additions
August 17, 2016 - Part 06 Creation
August 14, 2016 - Reformatting
August 12, 2016 - Initial Creation

Part 08: Hosting webpage with an existing apache Installation

Additional

Part09: Running Multiple Queries in Sequence

Part10: Calculating Data Trends

Part11: Making It Modular

Project in progress. Keep checking this page for updates.