August, 2003



Send TechConnections to a Friend now! Forward to a Friend!

August Training Solutions


CSTA Program
Classroom Training:
August 21: DC area

Web based Training:
Includes the following five training modules, each 75 minutes long. Start times are ET (Eastern Time)
Platforms: August 4 at 11:00 am
Development: August 4 at 12:45 pm
Files and Databases: August 4 at 2:15pm
Communications: August 5 at 11:00 am
Applications: August 5 at 12:45 pm

Additional Web based Training:
General Knowledge
Understanding IT Jobs: August 5 at 2:15 pm

Specific Technology
Business Intelligence: August 5 at 3:45 pm
Embedded Systems: August 6 at 11:00 am
Wireless Technology: August 6 at 12:00 noon
Networking: August 4 at 3:45 pm
System Software: August 6 at 1:15 pm

Go to SemCo Enterprises to get details or register.

Also on the Web - the recorded TechRef demo. If you work with technology, you really need to view this demo. You'll see all the functionality of TechRef, and how easy it is to subscribe and use! You can get answers to all your technical questions - and it's just a click away. You've got to see it to believe it! Go to the TechRef Demo now.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

TechKnowledge


Analytics, Scorecards, Portals, Dashboards

Part of BI (Business Intelligence)


Business Intelligence remains high on the list of hot technologies – even with the IT slowdown BI has become a competitive necessity.

Business intelligence products do four things:
  • They provide access to good data,
  • Enhance the user's ability to work with the data,
  • Include analytic applications that use industry standards and best practices, and
  • Provide presentation options so users can communicate their findings to others.

    In addition, they are categorized as back-end, front-end products, or analytic products. Back-end BI products make the data available and include ETL (Extract, Transform, and Load) software, data warehouses, data marts, and OLAP (OnLine Analytical Processing) servers. Front-end BI tools extract knowledge and insight from the prepared data and include reporting, query, on-line analysis and exploration, visualization, decision modeling and planning, and data mining tools. But it's the newer products that have recently enhanced BI. Analytic software, scorecards, portals and dashboards all belong in the BI arena.

    Analytic software works with specific business processes and is used to improve these processes. For example, a marketing campaign management analytic could use a data mart, online query and data mining tools, and campaign management tools. With this information, users can analyze customer information, identify opportunity segments, and then initiate campaigns to targeted customers. Another example, clickstream analytic software tracks data on how visitors move through Web sites and is used to improve the site by making infrequently visited pages easier to access, or moving key information from these pages to other pages that are clicked on more frequently. Over half of the analytic software used today is customized for specific businesses and/or companies.

    Scorecarding is a form of analytic software that is used to quantify the value of information based on business processes. Some ways that value can be calculated include analyzing who used the information, how often it is accessed, and whether the information causes a change in the business process. This can be extremely helpful in prioritizing services or products a business offers and deciding what areas should be upgraded or enhanced. It can help answer business questions such as "Who are our best customers?" by attaching a value to parameters such as
  • how many products a customer buys
  • how much money does a customer spend
  • what is the profit margin for the money spent
  • how many returns does a customer make, or
  • how many visits it took to make a sale.
    In fact, once there is value attached to information, information can actually be sold as a stand-alone product.

    A portal site and a dashboard are actually very similar. A dashboard assembles information from many sources and integrates it on a screen as if it came from a single source. For example, business analytic software could present a screen that shows information available from Customer, Sales, Product, Store, and Marketing Campaign data sources. Users could then run queries combining data from all these sources to understand who was buying what, in which store(s), during what times, etc. Dashboard software was originally developed by Hewlett-Packard and used to communicate with the operating system. Now, dashboards are part of many knowledge management systems and provide the user interface to business data and procedures. The term is often used with business or corporate portals.

    Portals present an easy way to get to data and are high-level Websites that allow browsers a one-stop location to start Web searches. They're often called gateway sites, as they provide a gateway to other sites. There are various kinds of portals. AOL and Yahoo are general interest portals. Other portals have been built around specific interests such as sports, women's issues, the stock market, etc. Companies are building their own portals called EIPs (Enterprise Information Portals) as gateways to their own applications, documents, reports, etc. as well as Internet sites. And, portals are used to search for data from both the Internet and internal sources and interface with dashboards for analytical queries.

    (BI) Business Intelligence software was really not possible until the last few years. Computers were not fast enough, and disks were neither big enough nor fast enough. It really wasn't possible to build systems that worked with unstructured data, which is what BI needs to do. Well, it's possible now! And BI is today's hottest application.

    Back to top


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    CSTA 2003


    CSTA (Computers: Systems, Terms and Acronyms) our flagship seminar, is completely dynamic – it changes with technology and almost every session includes new information. Beginning in August, we're introducing a major update! CSTA 2003 is now a one-day session. And, YES! We are covering in one day what we used to do in two.

    The 1990s produced incredible changes in IT – the use of PCs and the Internet is virtually universal in today's business world. Because everyone's so used to computers, we can take less time to explain some of the technology, but there's a more important reason. The pervasiveness of the Internet allowed us to create TechRef – our online database of computer technology. This database contains not just current technology, but also legacy information and future plan announcements. It's updated 24/7, so, during training, we can refer to TechRef for coverage of legacy systems and details on uncommon areas of technology. This enables us to cover today's technical environment in a shorter time. Everyone who attends CSTA, whether in a classroom setting or over the Web, receives a one-year subscription to TechRef and can use it for review, further information, keeping up with technology, and asking questions (TechRef includes a built-in email function for any technical question you have after training).

    So:

  • CSTA 2003 takes less time so you're not out of the office for two days
  • You can attend a one-day classroom session away from the office, or
  • Attend five instructor-led Web sessions from home or office
  • You receive complete follow-up support including:
    TechRef (online database)
    TechConnections (monthly e-newsletter), and
    eMail Support for technical questions following training.
    We're very excited about CSTA 2003. The updated class saves you time and money – and still provides you with complete coverage and full technical support. The Internet has made this possible, and we've taken full advantage! Check it out!

    Back to top


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    TechCheck


    1. Delta Airlines is making technical news by an exploratory use of wireless technology. What is Delta using wireless for?

    2. What do Jaguar and Panther have in common?

    3. Which of the following does not belong?

    (a) distribution
    (b) flavor
    (c) release
    (d) vocabulary

    4. What databases does SAP support for use with its application software?

    5. What is UnitedLinuX?


    Back to top


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Short GIS (Geographic Information System) Vocabulary


    GIS systems combine such things as demographics, corporate revenues, and taxes with maps. The maps allow geographically pertinent information to be incorporated into standard company information processing. These systems work with spatial information and actually are special-purpose digital databases holding spatial data. In addition to the database, GISs contain subsystems for: 1) data input; 2) data storage, retrieval, and representation; 3) data management, transformation, and analysis; and 4) data reporting and product generation. The systems contain both the database with geographic data already in the database, and the processing systems.

    DEM (Digital Elevation Model) Data architecture. An exchange format developed by the United States Geological Survey for geographical and topographical data.

    DLG (Digital Line Graph) Data used in GIS (Geographic Information System) products. A digital map developed from the information printed on USGS (United States Geological Survey) topographical quadrangle maps.

    geocoding Process of assigning map coordinates to data such as customer or store addresses. Used to develop GIS (Graphical Information System) software.

    geodata Data that identifies the geographical location and characteristics of natural or man-made features and boundaries of the earth. Geodata represent abstractions of real-world entities, such as roads, buildings, vehicles, lakes, forests and countries.

    GPS (Global Positioning System) Communications. Network and location system. Uses GPS satellites to communicate with GPS chips in handsets. Developed for the military for navigation and surveying, GPS can determine location very precisely.

    raster Data architecture. Used in geoprocessing to refer to digital geographic databases built from 'grid cells' in a matrix. Many satellites transmit raster images of the earth's surface. Reflectance of sunlight at a certain wavelength is measured for each cell in an image.

    SDTS (Spatial Data Transfer Standard) Communications standard used to define the transfer of digital spatial data between diverse computer systems. Works with spatial data referencing, georeferencing, and other associated metadata.

    spatial data Spatial data is data that pertains to the space occupied by objects and is described by points, lines, rectangles, surfaces, volumes and etc. It defines geographical structures such as cities, rivers, roads, mountains, etc. and is used in GIS (Geographic Information Systems) applications, environmental monitoring, and business analysis systems.

    TIGER (Topologically Integrated Geographic Encoding and Referencing file) GIS data. Type of Digital map developed by the U.S. Bureau of the Census for the 1990 population census. TIGER maps are available for every county in the United States and for the millions of census blocks in urban areas. Used in many GIS (Geographic Information System) packages.


    Back to top


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Answers to TechCheck


    1. Delta's actually using wireless technology to track baggage. RFIDs (Radio Frequency Identification Devices) are used by IT in configuration management. An RFID tag is placed on a physical asset and sends a signal to a reader which inputs information on all the devices to an asset management system. This is used to keep track of assets which are not connected to a computer system. While it's fairly easy to track hardware and software, non-connected devices such as medical equipment in a hospital or mobile cell phones are much harder to track. Delta is testing the use of RFIDs to track baggage in place of the currently used bar codes.

    2. Both are versions of Apple's Mac OS X operating system: Jaguar is 10.2, released in 2002, and Panther is 10.3 released in 2003. Mac OS X is, by the way, pronounced "Mac Oh-Ess-Ten," the "X" is really a ten!

    3. (c) does not belong. (a), (b), and (d) are all versions of the same software written by different vendors or groups: different versions of Linux are called distributions, different versions of Unix are called flavors, and different versions of XML are called vocabularies. Releases are different versions of software by the same vendor or group, usually upgrades to the software.

    4. SAP customers can use its own database, SAP DB, which was turned over to mySQL in 2003, so the four choices are mySQL, Oracle, DB2, and SQL Server.

    5. UnitedLinux is a Linux distribution supported by four vendors:

  • Connectiva S.A. in Latin America,
  • SuSE Linux AG in Germany,
  • The SCO Group in the U.S.,
  • Turbolinux Inc. in Japan.
    These vendors all market the same Linux and work together for open standards. They want to present a streamlined Linux that makes it easy for other software vendors to write software for the platform.


    Back to top


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  •    
    Contents
    August Training Solutions
    SemCo's Newsletter
    Teaser
    TechKnowledge
    CSTA 2003
    TechCheck
    Short GIS (Geographic Information System) Vocabulary
    Archived Editions
    Answers to TechCheck

       
    SemCo's Newsletter

    TechConnections is SemCo's free monthly newsletter that features important IT articles and a unique perspective on IT for the non-technical professional.


       
    Teaser

    Everything in IT starts out expensive, but IT can claim the biggest price drop that has ever occured. What product, technology, or service in IT has accounted for biggest price drop ever encountered in all commerce throughout all history?


    TechConnections Archived Editions

    If you receive the Text version of this newsletter, you can go to Archives to view the HTML version and/or print.

    Just click the link to find TechConnections Archived Editions.


    ARCHIVES


    Back to top

    Contact us at:

    SemCo Enterprises, Inc.
    407.830.5400
    semco@semcoenterprises.com
    http://www.semcoenterprises.com

    Copyright © 2003
    All Rights Reserved


    To no longer receive information from us, click here or reply to this message with the word unsubscribe as the subject of the message