Business Intelligence Reporting

Project Yoda

This is an OLAP (Online Analytical Processing) application for OPSCON’s MoveItNow Suite.
Using this application you can generate reports and charts for various performance indicators.

Platforms:

Screen Shots

Data Sets – Pre-Aggregated

Within the database there are a number of pre-aggregated tables. These tables are used to summarize some key performance indicators (KPI) based on calendar months.

  • Customer
    • Customer
    • Charge Codes
    • Business Source
    • Commodity
    • Department
      • Department
      • Charge Codes
    • Postal Code
      • Postal Code
      • Day of Month
      • Day of Week
    • Province
    • Payment History
      • Life
      • By Year
  • Department
    • Department
    • Charge Codes
    • Commodity
    • Postal Code
      • Postal Code
      • Day of Month
      • Day of Week
    • Province
  • Sales Person
    • Sales Person
    • Charge Codes
    • Business Source
    • Commodity
    • Customer
      • Charge Codes
    • Department
      • Department
      • Charge Codes
    • Postal Code
    • Province
  • Warehouse
  • Data Sets – Other

    Also exposed are: All Orders, Warehouse Inventory, Vehicle Maintenance, and Trailer Maintenance.
    These data sets are not pre-aggregated so you have complete access to all the exposed fields.
    You can also make your own queries.

    Postal Codes

    Since the system records the full postal code in the pre-aggregated tables, the cube can get quite large.
    You can group postal codes together to define an area.
    Postal Code Groups are loaded from text files so you can have Customer specific groups.
    Since all the Toronto, ON, Canada postal codes start with the letter M you can group them together into a Toronto group.
    This way the cube shows just a single line for the group rather than each postal code within.

    News

    Comments are closed