(888) 685-3101 ext. 2

Business Intelligence &
Data Warehousing Services

We help our customers on full lifecycle BI/DW
projects including assessments, roadmaps,
implementations, training, and more.

Assessment

Your company may have built a business intelligence/data warehousing solution, or implemented a BI tool several years ago—but its performance is declining.

Typical Situation

Your company may have built a business intelligence/data warehousing solution, or implemented a BI tool several years ago—but its performance is declining. Report running and data loading may be slow, or you may be experiencing breakdowns or crashes. Sound familiar?

An XTIVIA BI Assessment will focus on the following areas:

  • Strategic Alignment: Are you capturing BI in and around areas that directly influence the way you do business? If not, the lack of alignment may result in an unnecessary waste of resources and/or declining success over time.
  • Information Use + Analysis: How ready is your organization to use analytical frameworks and quantitative analysis as a means to improve business performance?
  • BI Portfolio Management: Do you have or effectively use BI Portfolio Management to manage ROI on BI initiatives?
  • Technical Readiness: How ready is your organization from a technical perspective?

The XTIVIA Approach

Using a small team of BI experts, XTIVIA will:

  • Review existing documentation and interview key stakeholders
  • Assess systems/processes to determine the cause(s) of the issue(s)
  • Review your company’s business and technical requirements
  • Assess your business, IT and project team resources and skills
  • Review existing data, information, technology and product architectures
  • Recommend necessary steps to improve your company’s BI environment

Engaging with XTIVIA

XTIVIA’s BI Assessment projects typically require 1–4 senior-level resources for 2–8 weeks, depending on the size, scope and complexity of your company’s situation. Deliverables include:

  • Recommendations to fix the problem
  • A roadmap to guide you to success
  • Cost estimates for implementation
  • Proposal to implement the solution

Not sure where your organization falls on the spectrum of BI “maturity?” TDWI defines a company’s usage of business intelligence in the following terms:

    1. Prenatal: Have implemented production reporting
    2. Infant: Consume BI mostly via spreadsheets or spreadmarts
    3. Child: Have built and regularly use subject-matter data marts
    4. Teenager: Have implemented data warehouses without enterprise-wide scope
    5. Adult: Have implemented data warehouses with enterprise-wide scope
    6. Sage: Have implemented enterprise-wide DW with analytical services

Ready to get started? Contact us today!

Roadmaps

You have a BI system in place—but reports are difficult to produce, take a lot of manual effort, contain questionable accuracy and can’t be produced in a timely manner.

Typical Situation

You have a BI system in place—but reports are difficult to produce, take a lot of manual effort, contain questionable accuracy and can’t be produced in a timely manner. It’s difficult and time-consuming to get information, and users may be unsure where to go for the data they need. Your enterprise recognizes the need to more effectively manage information.

The XTIVIA Approach

Using a small team of BI experts, XTIVIA will review existing documentation, interview key stakeholders, assess existing systems and processes and prioritize business strategies and needs. Then, using this information, we will design a BI solution to meet the unique needs of your enterprise—including a roadmap to guide you to your recommended solution.

Engaging with XTIVIA

Assessment and roadmap development projects typically require 1–4 senior-level resources for 2–8 weeks, depending on the size, scope, and complexity of your situation. Deliverables include:

    • Target business intelligence architecture
    • Roadmap to guide you to success
    • Cost estimates for implementation
    • Personnel recommendations
    • Proposal to implement the solution
ROADMAP | REFERENCE ARCHITECTURE | PROGRAM PLAN

1. PLAN

2. ORGANIZE

3. ASSESS

U

Solution Implementation

Your company knows exactly what kind of BI or DW solution you need to build and implement, but you simply don’t have the in-house expertise or bandwidth to get it done.

Typical Situation

Your company knows exactly what kind of BI or DW solution you need to build and implement, but you simply don’t have the in-house expertise or bandwidth to get it done.

The XTIVIA Approach

XTIVIA will use a complete team of BI professionals to fully design, build, and implement your BI or DW solution. Our project teams will cover the following roles:

  • Project Manager
  • BI Solution Architect
  • Data Architect
  • Data Modeler
  • ETL Developers
  • Report Developers
  • Development DBA
  • Product Testers

Depending on the size of the project, each team member may fill more than one role; alternatively, it may take several people to fill one role. We provide our own proven development methodology and work closely with you through full implementation.

Engaging with XTIVIA

Development projects typically require 4–10 personnel resources with appropriate skill sets for 3–12 months, depending on the size, scope, and complexity of the solution. Deliverables include:

    • A production-ready BI or DW solution
    • Detailed system documentation
    • Training for support personnel
    • Training for company employees
    • Change management support

Training

Your company has talented people, but they haven’t been exposed to BI. You believe that with the right training, your in-house team can manage your Business Intelligence.

Typical Situation

Your company has talented people, but they haven’t been exposed to BI. You believe that with the right training, your in-house team can manage your Business Intelligence.

The XTIVIA Approach

We have a large selection of BI- and DW-related topics that we teach to our clients on a regular basis. We also have certified instructors who teach at TDWI. XTIVIA provides on-site training session from half-day to several days, depending on your company’s needs.

Engaging with XTIVIA

All XTIVIA teaching engagements include a subject-matter expert coming to your location to provide training for the agreed-upon time period. You will be charged a flat fee that covers class preparation, materials, and on-site instruction.

Data Warehousing Blog

Reporting Queries Best Practices and Mistakes to Avoid

Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this performance issue could be caused by report queries. Here are some of the most important thing to consider when writing...

Efficient ETL Development via Biml and BimlScript

It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy data from source systems and transform it before loading it in to the data warehouse. Many of the ETL processes,...

Backup Strategies For Sql Server Data Warehouses

This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...

A Road Map Is Required for a Successful BI Program

What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it.   Imagine business teams would...

Keep it in Memory, Don’t Forget

20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don't remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...

Profiling Data with SSIS

SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the Profile Task,...

SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files

Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source to .CSV files, Excel spreadsheets, and MS Access databases. Recently, I had a customer request setting up sample data...

Rerunning Jobs in Talend Open Studio

When running jobs which are dependent on external sources (dropping of a file in an ftp folder), it may be necessary to run a multiple times till the file is found and the job run for that day. One way to do this is to insert a row into a log table which will hold the...

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...

Oracle Looping Chain of Synonyms. ORA-01775

So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms - Basically means that you created a synonym...

Top 10 Things to Know Before Starting Statistical Analysis

1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential techniques allow us to estimate and draw conclusions about populations from samples 2. Data can be formally categorized in three...

Versioning for Talend Open Studio

Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you...
Data Warehousing Blog

Jasper Reports Design Best Practice

Jasper Reports is a reporting application that is simple to use, install, manage, and deploy. Its versatility gives us an option to deploy it to a...

Reporting Queries Best Practices and Mistakes to Avoid

Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this...

Efficient ETL Development via Biml and BimlScript

It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy...

Backup Strategies For Sql Server Data Warehouses

This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data...

A Road Map Is Required for a Successful BI Program

What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data,...

Keep it in Memory, Don’t Forget

20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don't remember the HDD capacity – I believe it was around 120MB...

Profiling Data with SSIS

SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the...

SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files

Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source...

Rerunning Jobs in Talend Open Studio

When running jobs which are dependent on external sources (dropping of a file in an ftp folder), it may be necessary to run a multiple times till...

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration...

Oracle Looping Chain of Synonyms. ORA-01775

So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a...

Top 10 Things to Know Before Starting Statistical Analysis

1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential...

Let's Talk Today!

No obligation, no pressure. We're easy to talk with and you might be surprised at how much you can learn about your project by speaking with our experts.

XTIVIA CORPORATE OFFICE
304 South 8th Street, Suite 201
Colorado Springs, CO 80905 USA

Additional offices in New York, New Jersey,
Missouri, Texas, Virginia, and Hyderabad, India.

USA toll free: 888-685-3101, ext. 2
International: +1 719-685-3100, ext. 2
Fax: +1 719-685-3400

Complete the form to hear from us.

XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.

Share This