Monthly Archives July 2012

Seven Tips to Successfully Start Your BI System

Posted by admin on July 31, 2012  /   Posted in BI and Custom Development, Business, Data Best Practices

Given a mountain of data that comes from different sources in different flavors, it could be a daunting prospect to get them all in line.  Here are seven simple steps that could help you wade through the first phase of implementing a successful BI process that will not only solve the immediate problems, but also grow with your company.

  1. Trace your steps backwards, begin with the reports that you have to have in order to run your business.  Do not start with the data itself.  A lot of BI implementations make this mistake, which will soon overwhelms anyone involved and contributes to a slow-start.
  2. Identify two types of reports: Those that are very important for strategic decision making (annual bank loan reports, ISO certifications, etc.) and those that are important for tactical everyday decisions (daily status report, daily manufacturing job schedule, warehouse inventory, customer returns, etc.)
  3. Split your attention into the two types of report you identify above.  Pick one report from each type, and work on both at the same time.  By working on two different sets of data types simultaneously, you will gain more insight on how to transform the existing data to satisfy both types of reports.  Failing to do this, will cause you to backtrack a lot, and that means wasted effort.
  4. Use of your Time Dimension table. This is the lookup table consisting of different facts about one measure of time (usually a day).  In a lot of BI projects, people neglected to use this very useful table, opting to create complex SQL queries, which ends up being error prone, difficult to maintain, and a big time waster.
  5. Be mindful of your database’s idiosyncrasies.  Know what NULL values mean in a field, especially the ones that will be part of a calculation. Know what it means to say BETWEEN two dates.  And no, Non-SQL databases are not immune to these quirks.  They are just as susceptible to unfamiliar and untested usages.
  6. Prepare two identical databases that contain your BI tables. Setup two instances of your ETL building each database separately. This way you can switch back and forth when you are testing or having to re-run the ETL in the middle of a busy day.
  7. You will not catch every bug, and there is no perfect the BI system. Test, and re-check your tests, that’s why you have two identical databases.  BI is an ongoing process, therefore it is important to come up with a good system and an implementer who understands this.

By following these simple steps and precaution, you will minimize a lot of backtracking in the middle of the project.  And more importantly, by starting the project the right way, you will avoid burn out and frustration that will have more adverse impact on the quality of the data at the end of the process.

Enterprise Resource Planning (ERP) and Why You Should Care

Posted by admin on July 17, 2012  /   Posted in BI and Custom Development, Business

No matter the size of your organization, if its revenue is growing, sooner or later you will benefit from a more consolidated approach to managing your business data.

An ERP system is designed to provide a consistent user interface to an integrated database backend where data from different functional departments within your organization will be processed and stored.

A typical ERP system is configured to handle typical business functions (usually handled by personnel in each department) such as: Accounting, Orders and Invoices management, Customer and Vendor Relations, Manufacturing, Shipping and Logistics, Warehouse and Inventory management, etc.

An exceptional ERP system, however, is also marked by the ease-of-use and just as important: Easy to customize and modify. Not all businesses operates the same way, in fact, none of them really are.

So to summarize some obvious benefits:

  • Lower software license costs
  • Less time consumed in import/export data formats between applications
  • Reduce redundant data entry
  • Increase in speed and clarity in data flow and personnel workflow
  • Increase in data accessibility among different functional departments
  • System-wide upgrades and enhancements
  • Simplified new personnel training

To illustrate the above benefits, here is an excellent presentation by OpenERP.

In summary, for a healthy organizations (especially not so healthy ones), a move to adapt an ERP system can lead to what every organization needs: Cost reduction and increased productivity.

There is but one thing between these benefits and your company, the effort that it took to choose and implement an ERP system.


We serve businesses of any type and size
Contact Us Today