1 / 13

AGENDA

AGENDA. OVERVIEW. CUSTOMERS. SOLUTIONS. ACQUISITION. Windows 7 Tips and Tricks/Microsoft Excel Automation (Graphing, Formulas, Pivot Tables, Dashboarding). AGENDA. OVERVIEW. CUSTOMERS. SOLUTIONS. ACQUISITION. Agenda. Microsoft Desktop Tools Overview Microsoft Desktop Tools Overview

Download Presentation

AGENDA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Windows 7 Tips and Tricks/Microsoft Excel Automation (Graphing, Formulas, Pivot Tables, Dashboarding)

  2. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Agenda • Microsoft Desktop Tools Overview • Microsoft Desktop Tools Overview • Windows 7 • Snap, Shake, Snip, and PSR • Microsoft Office • Realm of the Possible • Dashboards, Command Wide Pivot Tables, Automated Traveler Notification • Pivot Tables • Graphing Formulas • Dashboarding • Mail Merge

  3. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Desktop Tools Overview Desktop Tools Data Warehousing BI & DSS Professional Services Application Development The Desktop Tools development methodology is a powerful way to maximize the use of existing Microsoft Office applications and Enterprise systems through validated data integration, reporting, and analysis. High-powered decision support tools and executive dashboards:Hardware Cost – $0 Software Cost – $0 With our mature method for implementing Desktop Tools, you can streamline your decision making process and have instant access to critical information without the hassle of heavy acquisition costs and lengthy implementation schedules.

  4. CUSTOMERS AGENDA OVERVIEW SOLUTIONS ACQUISITION Microsoft Desktop Tools Users AIR FORCE ARMY DoD/JOINT Commercial NGB DON-AA ABO 25th ID PACOM Air Force SOUTHCOM AFRICOM USFOR-A USASOC

  5. CUSTOMERS AGENDA OVERVIEW SOLUTIONS ACQUISITION National Guard Users AIR FORCE ARMY DoD/JOINT Commercial ANGRC USPFO-NY USPFO-WY USPFO-NJ USPFO-GA HI ANG USPFO-TN USPFO-IL USPFO-MD USPFO-OH

  6. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Features and Benefits Desktop Tools Data Warehousing BI & DSS Professional Services Application Development • Avoid manual data collection – time consuming and error prone • Get controlled access to the data needed: when you want, the way you want it • Provide customer organizations with accurate and timely reports on financials, manpower, personnel, travel, etc.. • Reliable and Proven system design capable of growing with organization’s mission • Automate and standardize current business processes to meet continuous process improvement objectives • Directly access necessary data for analysis using MS Office products you already own • Reduce level of effort needed for year end closeout • Lessens stress on transactional systems – one pull, many benefit • Enhances auditability, transparency, and ability to accurately forecast

  7. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Desktop Tools Architecture Feeds/Pulls* Outbound Microsoft Desktop Tools Engine STARS/Navy-ERP/FASTDATA/PBIS-IT Power Pivots (Ad Hoc & Canned Reports) Direct CRIS/GFEBS/STANFINS/ GCSS-A Financial Management DCPS/SNAP/PBAS Slide Deck (Dashboard & Reports) GTC/DTS/GPC PBUSE/LIW/LMP/GCSS-A Mail Merge (Automated E-mail Notification) PD2/FPDS/SPS Other Data Sources SLDCADA/DDRW/CIS Direct Timely Daily Update Process

  8. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Return On Investment Desktop Tools Data Warehousing BI & DSS Professional Services Application Development C3 In the three years before we began providing our Desktop Tools services, USASOC averaged $35M/year – money that was lost to the command.  In FY11 and FY12 it was $5.4M and $4.3M respectively.  The USASOC Comptroller states “the MS Desktop Tools process saves each of his 150+ analysts about 3-5 hours a day in data retrieval alone” ***99,000+ extra hours spent on analysis in one year***

  9. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Travel ODL Tracker & Notification Desktop Tools Data Warehousing BI & DSS Professional Services Application Development • Automated Traveler Notification/Travel ODL Tracker • Automated Delinquent Traveler Notification • ODL Tracker Functionality Specifically designed for Delinquent Travel Orders/Advances Manual Process Teksouth Approach

  10. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Unsubmitted Voucher Cost Savings Desktop Tools Data Warehousing BI & DSS Professional Services Application Development

  11. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Unsubmitted Voucher Examples Desktop Tools Data Warehousing BI & DSS Professional Services Application Development The MS Word Mail Merge capability allows technicians to automatically send individual memos to delinquent travelers through email at the touch of a button. The Travel ODL allows technicians to keep comments on delinquent travelers as orders are added, dropped, and modified in the accounting system.

  12. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Manpower Reports Desktop Tools Data Warehousing BI & DSS Professional Services Application Development The Microsoft Desktop Tools is flexible enough to handle an type of data integration solution. The example dashboard view shows EPS’s/OPR’s metrics integrated from two different personnel systems, vPC-GR and MilPDS. We customize our solutions to meet our customer requirements. Above, the user can click on any of the dashboard buttons for a by-name listing.

  13. AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Contact Us Brandon Pittman Director Business Development – Huntsville (256) 604-6946 brandon.pittman@teksouth.com Joseph Nizolak Vice President Business Development (703) 915-3353 joe.nizolak@teksouth.com Joshua Cherkinsky Director of Business Development – Washington DC (202) 236-4877 joshua.cherkinsky@teksouth.com www.teksouth.com (800) 842-1470

More Related