1 / 13

Excel-Based Solutions For Large Data Systems by Douglas M. Smith / Abundant Solutions

Excel-Based Solutions For Large Data Systems by Douglas M. Smith / Abundant Solutions.

ronia
Download Presentation

Excel-Based Solutions For Large Data Systems by Douglas M. Smith / Abundant Solutions

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. Excel-Based Solutions For Large Data Systemsby Douglas M. Smith / Abundant Solutions Data can be extracted from large data systems (mainframe, AS/400, Oracle, Axapta, etc.) and imported into Excel for further consolidation and manipulation. Excel-based applications can seamlessly import the data, and provide end users with powerful tools for analysis, summarization and reporting. These tools will be completely customized to meet the user’s needs and will be easily maintainable. The interface will be graphically oriented and will require little, if any, data entry by the user. Examples of Excel-based applications are shown on subsequent pages. These applications can also work as standalone products or can import data from other systems and sources. Contact Information Douglas M. Smith doug@abundant-solutions.com Abundant Solutions 6813 Foxfire Place www.abundant-solutions.com Raleigh, NC 27615

  2. Excel-Based Solutions Overview System/DB Output Download file extracts from System / Database to Excel. Work with IT to determine data sets needed for tools based on end user input. Excel Process the data in Excel into tools for end users and management based on their input. Sales Forecasting Salesman Tools Executive Information Systems Financial Reporting Score Cards The tools will provide new functionality and greatly reduce existing efforts to produce information. Overall process improvement will improve efficiency and lower costs, as well as provide better tools for running business operations.

  3. Sales & Marketing / Forecasting Tools • Home Page control panel • Imports / processes data with one button • Buttons to navigate and process • Dropdown boxes for effortless selection • Visual coding for easy evaluation • Professional formatting • Automatically updated graphics

  4. Forecasting / Economic Tools • Raw data import / export routines • Multiple processing options • Vary economic parameters • Point & click interface • Quick run time • Built-in error validation and error checking

  5. Resource Tools • Point & click interface • Instant results • Data updated without program changes • Email output to requestor • Links to other programs

  6. Resource Tools

  7. Reporting Tools • No keystrokes involved • Complex calculations • Reports updated automatically • Graphics updated automatically • Reads imported data • Near instant reports • Adverse results can be highlighted • Can be auto-distributed by email

  8. Analysis Tools • No keystrokes involved • Reads data tables • Color coding for legibility • Printer-friendly output

  9. Administrative Tools • Standalone application • Point & click interface • Logs and analyzes data • Timestamps data

  10. Technical Tools • Highly complex analysis is possible • Makes configuration decisions • Custom toolbars and buttons • Easily work through different scenarios This tool determines the number of phone switches required based on desired lines and traffic. Then it consolidates the first set of switches into a second set of switches.

  11. Budget Tools • Manage by Cost Center, Activity, etc. • Multiple rollup options • Forecasting calculated and charted • Summaries and statistics calculated

  12. Minimal data entry • Calculates partial month amounts • Can be used for forecasting changes • Summaries and statistics calculated Budget Tools

  13. Credentials • Twenty years of spreadsheet experience • Engineering degree and IT experience • Authored a spreadsheet tutorial column for SoftDisk magazine • Software reviewed in PC Magazine, MacUser, MacWorld • Competed in International Software Developer Competitions • Won a special award for “Spreadsheet Wizardry” in international competition • Excel MVP Certification from Brainbench.com • Developed the Excel 2000 interactive exam for Brainbench.com • Published commercial spreadsheet-based income tax software • Developed Excel-based applications for:

More Related