jps services
  • Home Page
  • GIS Training Courses
    • QGIS Training Courses
    • ArcGIS Training Courses
    • MapInfo Pro Training Courses >
      • MapBasic Training Course
  • About
  • Blog

Solving everyday business problems with readily available software solutions

12/2/2013

0 Comments

 
Most problems which arise in a business environment can be solved with a mix of common sense and appropriate software solutions. Some problems are industry specific and require a programmer with specific knowledge of that specialist area. Other problems are more general and merely require a modicum of practical application. Within the business environment many users of general office solutions such as word processors and spread sheets often generate their own templates to solve solutions. As most programmers are aware the end user probably knows best what their requirements are. Sometimes the user becomes frustrated if a so called professional solution doesn't meet his requirements. On occasions the solution is created by the user through either a word processor or spread sheet application. It may not be as elegant as a programmer's output but if it does the job then it can be a better option that possibly waiting months for an official solution to materialise.

The fact that word processors and spread sheets have become common place means that most office workers tend to take their use for granted and do not appreciate the power that these products hold for them if correctly applied. Gone are the days when producing a perfectly typed document was only the remit of the typing pool. Now, with word processors everyone can produce perfect documents either from scratch or through templates. There is no excuse for spelling errors or the like as these can be quickly highlighted by the software. Similarly spread sheets have enabled many an accounts department to generate many different kinds of forms to calculate all manner of general purpose tasks performed within the business arena. What was once only the domain of the largest and most powerful organisations some thirty years ago is now readily available to anyone with a basic personal computer.

By combining various general office software tools such as word processors, spreadsheets, database applications end users have often managed to solve complex problems without calling in the IT department. Over time these office software tools have become more user friendly so that creating customised applications has become easier.
Databases such as Access have also become more user friendly and other similar programs have enabled users to create solutions which can link databases to other applications. The use of databases within the office environment is now common place and has for the most part replaced the card index systems which preceded software solutions in managing data.
Databases are also the key to understanding all types of different data. By linking queries of data to spreadsheets and then creating charts it is possible to get a better understanding of what the data is trying to tell us. Again linking several databases enables users to better understand how processes need to be handled. Prior to the humble personal computer trying to make sense of thousands of different pieces of information would have required many hours of tedious work or the application of a mainframe computer. Now we have the power within our grasp to analyse all manner of data and quickly display it with a variety of charting options.

Linking databases to a GIS system is yet another way of interpreting data. Sometimes data displayed within a map can give a better understanding of a problem to your audience that just displaying a standard chart would not achieve. However, unlike word processors, spreadsheets and databases GIS systems are not yet as widely utilised as they could be within a general business environment. There are possibly several reasons for this. GIS is still seen by many organisations as a specialist solution and not a general business tool. GIS is sometimes perceived to be more difficult to learn than word processors and similar programs. GIS is also perceived to be an expensive option when compared to other more general office solutions. So all these hurdles lead to GIS systems often being the domain of the specialist rather than another tool available to everyone within the office environment. There are several solutions to this dilemma. One would be for the main suppliers of GIS systems to make their software financially attractive for even the smallest of organisations. However that would not appear to be an option at the present time. 
 
Some organisations have solved their business software application requirements, when cost has been a barrier to progress, by turning to open source solutions. This has helped many disparate organisations to reduce the ongoing costs of software solutions sometimes involving many thousands of users. In these organisations their main costs have been in training and customisation. They would of course of had these costs with a proprietary solution plus the considerable additional cost of the software and upgrades as they became available. 
 
Within the GIS arena there are a number of open source solutions which can be integrated with other more generalised office software solutions such as word processors and spreadsheets. One solution which is currently gaining more users is Quantum GIS. This GIS software solution offers most of the functionality of more well known proprietary solutions and is just as easy to use and customise.

Quantum GIS can also load data from most GIS systems and therefore could be used to either replace or complement other GIS systems within an organisation. Like MapInfo and ArcGIS many training options for Quantum GIS are available. You can learn to use the software through users guides, on-line videos and instructor led training. Whatever method you prefer you will find that implementing GIS within your organisation will be a worthwhile process.




0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Author

    Joe Short BSc has been involved with various mapping solutions for over twenty years.  If you are considering implementing a GIS  or have ArcGIS Pro, MapInfo Pro or QGIS training requirements, jps services would be happy to be of assistance to your organisation. 

    Archives

    April 2020
    March 2020
    October 2019
    September 2019
    August 2019
    July 2019
    March 2019
    November 2018
    October 2018
    August 2018
    July 2018
    November 2017
    October 2017
    September 2017
    July 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    May 2016
    February 2016
    September 2015
    August 2015
    April 2015
    February 2015
    November 2014
    October 2014
    July 2014
    June 2014
    May 2014
    March 2014
    February 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    June 2013
    May 2013
    April 2013
    February 2013
    December 2012
    October 2012
    September 2012
    August 2012
    July 2012

    Categories

    All
    Arc Gis
    Arcview
    Autodesk
    Cad
    Gis Training
    Local Government
    Mapbasic
    Mapinfo
    Quantum Gis
    Relational Databases
    Saga Gis

    RSS Feed