Control employees load and monitor quality of service at a service centre
Retrive data from switchboard server (Informix)
Data procesing (complex logics)
Generate data mart to serve the rporting requirements
Research by type of centre, employee name, date, load.
|
|
Employees efficiency system - Throuputs|Costs
Retrieve data from time clock
Input throuputs by employees - touch screen
Import suppliers invoices to cost centres
Generate data mart feeding reports
|
|
Investments portfolio management and reporting
Bloomberg data feeds, stock prices and currencies
Companies, Accounts, Investment Types and Currencies
Dashboards and reports
Users credentials
|
|
Products' revenues' centre
Analyse deals by:
Customer, Dealer, Agent, SKU, Supplier, Time Dimension
Import and enrich DOS files Data from various tables
|
|
Manage contributions - Filantrop Fund
Development in Excel 2003 and migration to newer versions
Monitor donations, Projects over time and installations
|
|
Filter data with Pivot Tables and Slicers:
Slice and Dice data by multiple criteria
Pivot tables allow a cubic - multi dimension data structure in excel
|
|
|