• Services

    Proof of Concept 


    This is a 3-10 day limited scope engagement involving the customer and SeeMoreData Professional Services where a senior / principal BI-Plus consultant will be on-site working with the customer to deliver the following:

    Initial setup, install & configuration of the environment.
    Understanding the task to be solved and the customer's need.
    Understanding the customer’s data distribution and data model.
    Creation of the reports that have been specified in the POC Statement of Work.
    Optional (time-permitting) on-the-job training for the customer’s technical staff, as the customer is expected to provide a technical and business resource to be available for the duration of the engagement.
    Training of small group of end users for whom the proof-of-concept was to be performed.

    BI-Plus Consulting 


    SeeMoreData is a Solution Provider Services Company.

    We not only provide you with the tools to be self-sufficient, but we also recognize that we are going to know how to use our toolset to your best advantage better than anyone else. We are also in touch with our engineering division. the benefit to you is lightning-fast turnaround and immediate on-the-spot knowledge.

    Our professional services staff are absolute experts at BI implementations and that is basically our core business.

    We have created the toolset to be as easy to use as possible, but if you do not want to use your own technical resources and prefer to ‘outsource’ the development of reports to us, we provide a fully inclusive consultancy. We can also augment your existing technical staff for those periods when the backlog seems high and the resources seem low.

    Our consulting services can be used to help you to optimize report and query performance, the creation of customer stored procedures, Java stored procedures or to assist with the optimization of the SeeMoreData environment. We treat our customers as the partners to us that you are.

    Your success is our success. Please contact us for specific details.

    Advanced SQL for IT Professionals 


    This is a 4 day course and once completed, gives the attendee the knowledge to be ranked amongst the top 1% in the world when it comes to SQL skills. Topics covered:
    1. Complex joins
    2. Correlated subqueries and performance considerations.
    3. Analytic functions (rollup, cube, rank over (partition by, etc))
    4. Pivot queries
    5. Summaries and groupings
    6. Appropriate usage of stored procedures and functions.
    7. Type conversion / casting
    8. Hierarchies
    9. In-line views
    10. Subsets
    11. Appropriate Temporary table usage
    12. Ability to generate SQL solutions to complex problems in Oracle, DB2 and Sql Server
    The classes will have bias towards Oracle and SQL Server incorporating ANSI-92 SQL.