130 likes | 254 Views
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
E N D
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 • 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
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.
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
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
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
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
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***
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
AGENDA OVERVIEW CUSTOMERS SOLUTIONS ACQUISITION Unsubmitted Voucher Cost Savings Desktop Tools Data Warehousing BI & DSS Professional Services Application Development
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.
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.
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