ÿþ<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"> <META NAME="Generator" CONTENT="NetObjects Fusion 5.0.2 for Windows"> <TITLE>Better Business Methods LLC: Services->Data Warehousing</TITLE> <SCRIPT> <!-- function F_loadRollover(){} function F_roll(){} //--> </SCRIPT> <SCRIPT LANGUAGE="JavaScript1.2" SRC="../../../rollover.js"></SCRIPT> <NOLAYER> <STYLE ID="NOF_STYLE_SHEET"> <!-- DIV#LayoutRegion3LYR { position:relative; visibility:inherit; top:0; left:0; width:794; height:106; z-index:1; cursor:hand; } DIV#Picture1LYR { position:absolute; visibility:inherit; top:3; left:104; width:564; height:69; z-index:1 } DIV#LayoutRegion10LYR { position:absolute; visibility:inherit; background-color: #006699; top:74; left:0; width:794; height:32; z-index:2 } DIV#NavigationBar1LYR { position:absolute; visibility:inherit; top:0; left:0; width:784; height:32; z-index:1 } DIV#Table33LYR { position:absolute; visibility:inherit; top:53; left:634; width:157; height:20; z-index:3 } DIV#Picture28LYR { position:absolute; visibility:inherit; top:0; left:0; width:70; height:70; z-index:4 } --> </STYLE> </NOLAYER> </HEAD> <BODY BGCOLOR="#FFFFFF" TEXT="#000000" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=794 NOF=LY> <TR VALIGN=TOP ALIGN=LEFT> <TD HEIGHT=106 WIDTH=794><DIV ID="LayoutRegion3LYR"><ILAYER ID="LayoutRegion3LYR" VISIBILITY=INHERIT WIDTH=794 HEIGHT=106 Z-INDEX=1><DIV ID="Picture1LYR"><LAYER ID="Picture1LYR" VISIBILITY=INHERIT TOP=3 LEFT=104 WIDTH=564 HEIGHT=69 Z-INDEX=1><IMG ID="Picture1" HEIGHT=69 WIDTH=564 SRC="../../../Main/BBM.jpg" BORDER=0></LAYER></DIV><DIV ID="LayoutRegion10LYR"><LAYER ID="LayoutRegion10LYR" VISIBILITY=INHERIT TOP=74 LEFT=0 WIDTH=794 HEIGHT=32 Z-INDEX=2 bgcolor="#006699"> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=794 HEIGHT=32 NOF="LayoutRegion10"> <TR ALIGN=LEFT VALIGN=TOP> <TD><DIV ID="NavigationBar1LYR"><LAYER ID="NavigationBar1LYR" VISIBILITY=INHERIT TOP=0 LEFT=0 WIDTH=784 HEIGHT=32 Z-INDEX=1> <TABLE ID="NavigationBar1" BORDER=0 CELLSPACING=0 CELLPADDING=0 NOF=NB_FYHS WIDTH=784> <TR VALIGN=TOP ALIGN=LEFT> <TD WIDTH=112><A HREF="../../../Main/main.html" onMouseOver="F_roll('NavigationButton1',1)" onMouseOut="F_roll('NavigationButton1',0)"><IMG ID="NavigationButton1" NAME="NavigationButton1" HEIGHT=32 WIDTH=112 SRC="../../../Home_Ns1_18.gif" onLoad="F_loadRollover(this,'Home_NRs2_18.gif')" BORDER=0 ALT="Home"></A></TD> <TD WIDTH=112><A HREF="../../../Main/About_Us/about_us.html" onMouseOver="F_roll('NavigationButton2',1)" onMouseOut="F_roll('NavigationButton2',0)"><IMG ID="NavigationButton2" NAME="NavigationButton2" HEIGHT=32 WIDTH=112 SRC="../../../_Ns1_27.gif" onLoad="F_loadRollover(this,'_NRs2_27.gif')" BORDER=0 ALT="About Us"></A></TD> <TD WIDTH=112><A HREF="../../../Main/Services/services.html" onMouseOver="F_roll('NavigationButton3',1)" onMouseOut="F_roll('NavigationButton3',0)"><IMG ID="NavigationButton3" NAME="NavigationButton3" HEIGHT=32 WIDTH=112 SRC="../../../_Ns1_23.gif" onLoad="F_loadRollover(this,'_NRs2_23.gif')" BORDER=0 ALT="Services"></A></TD> <TD WIDTH=112><A HREF="../../../Main/Approach/approach.html" onMouseOver="F_roll('NavigationButton4',1)" onMouseOut="F_roll('NavigationButton4',0)"><IMG ID="NavigationButton4" NAME="NavigationButton4" HEIGHT=32 WIDTH=112 SRC="../../../Our_Approach_Ns1_17.gif" onLoad="F_loadRollover(this,'Our_Approach_NRs2_17.gif')" BORDER=0 ALT="Our Approach"></A></TD> <TD WIDTH=112><A HREF="../../../Main/Careers/careers.html" onMouseOver="F_roll('NavigationButton6',1)" onMouseOut="F_roll('NavigationButton6',0)"><IMG ID="NavigationButton6" NAME="NavigationButton6" HEIGHT=32 WIDTH=112 SRC="../../../_Ns1_25.gif" onLoad="F_loadRollover(this,'_NRs2_25.gif')" BORDER=0 ALT="Careers"></A></TD> <TD WIDTH=112 HEIGHT=32><A HREF="../../../Main/Contact_us/contact_us.html" onMouseOver="F_roll('NavigationButton7',1)" onMouseOut="F_roll('NavigationButton7',0)"><IMG ID="NavigationButton7" NAME="NavigationButton7" HEIGHT=32 WIDTH=112 SRC="../../../_Ns1_26.gif" onLoad="F_loadRollover(this,'_NRs2_26.gif')" BORDER=0 ALT="Contact us"></A></TD> </TR> </TABLE> </LAYER></DIV></TD> </TR> </TABLE> </LAYER></DIV><DIV ID="Table33LYR"><LAYER ID="Table33LYR" VISIBILITY=INHERIT TOP=53 LEFT=634 WIDTH=157 HEIGHT=20 Z-INDEX=3> <SCRIPT LANGUAGE="JavaScript"> <!-- Begin Stamp = new Date(); document.write('&nbsp;&nbsp;<font size="1" face="verdana" color="#CFC800"><B>' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getYear() + '</B></font>&nbsp;&nbsp;&nbsp;'); var Hours; var Mins; var Time; Hours = Stamp.getHours(); if (Hours >= 12) { Time = " P.M."; } else { Time = " A.M."; } if (Hours > 12) { Hours -= 12; } if (Hours == 0) { Hours = 12; } Mins = Stamp.getMinutes(); if (Mins < 10) { Mins = "0" + Mins; } document.write('<font size="1" face="verdana" color="#CFC800"><B>' + Hours + ":" + Mins + Time + '</B></font>'); // End --> </SCRIPT> <TABLE ID="Table33" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%"> <TR> <TD WIDTH=157 HEIGHT=20> <P></P> </TD> </TR> <TR> <TD> <P></P> </TD> </TR> </TABLE> </LAYER></DIV><DIV ID="Picture28LYR"><LAYER ID="Picture28LYR" VISIBILITY=INHERIT TOP=0 LEFT=0 WIDTH=70 HEIGHT=70 Z-INDEX=4><IMG ID="Picture28" HEIGHT=70 WIDTH=70 SRC="../../../Main/logo-3in-small.jpg" BORDER=0></LAYER></DIV> </ILAYER></DIV> </TD> </TR> </TABLE> <TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=790 NOF=LY> <TR VALIGN=TOP ALIGN=LEFT> <TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=24 NOF=LY> <TR VALIGN=TOP ALIGN=LEFT> <TD HEIGHT=1100 WIDTH=24> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=24 HEIGHT=1100 bgcolor="#006699" NOF="LayoutRegion4"> <TR ALIGN=LEFT VALIGN=TOP> <TD>&nbsp;</TD> </TR> </TABLE> </TD> </TR> </TABLE> </TD> <TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766 NOF=LY> <TR VALIGN=TOP ALIGN=LEFT> <TD WIDTH=8 HEIGHT=7><IMG SRC="../../../clearpixel.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD> <TD WIDTH=121><IMG SRC="../../../clearpixel.gif" WIDTH=121 HEIGHT=1 BORDER=0></TD> <TD></TD> <TD WIDTH=196><IMG SRC="../../../clearpixel.gif" WIDTH=196 HEIGHT=1 BORDER=0></TD> </TR> <TR VALIGN=TOP ALIGN=LEFT> <TD COLSPAN=2 HEIGHT=56></TD> <TD ALIGN=CENTER VALIGN=MIDDLE WIDTH=441><IMG ID="Picture26" HEIGHT=56 WIDTH=441 SRC="../../../Main/Services/Data_Warehousing/datawarehousing.gif" BORDER=0></TD> <TD></TD> </TR> <TR VALIGN=TOP ALIGN=LEFT> <TD COLSPAN=4 HEIGHT=2></TD> </TR> <TR VALIGN=TOP ALIGN=LEFT> <TD HEIGHT=873></TD> <TD COLSPAN=3 WIDTH=758> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=758 HEIGHT=873 bgcolor="#99CCFF" NOF="LayoutRegion12"> <TR ALIGN=LEFT VALIGN=TOP> <TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=753 NOF="LayoutRegion12"> <TR VALIGN=TOP ALIGN=LEFT> <TD WIDTH=8 HEIGHT=9><IMG SRC="../../../clearpixel.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD> <TD WIDTH=745><IMG SRC="../../../clearpixel.gif" WIDTH=745 HEIGHT=1 BORDER=0></TD> </TR> <TR VALIGN=TOP ALIGN=LEFT> <TD></TD> <TD WIDTH=745> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Data Requirements<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">BBM will utilize any existing legacy systems as well as your conventional ERP system for the original data, and work with your staff to define your needs with respect to critical business initiatives at hand. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Dimensional Model<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Once the data requirements are established, BBM will begin working on the dimensional model, using ERwin, or other standard entity relationship modeling packages. BBM uses this model to identify fact tables, the associated conforming dimensions, attributes, as well as the hierarchical drill paths. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Extraction, Transformation, Load<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Using a front-end application, such as Informatica, for the ETL tool (Extraction, Transformation, and Load), data integrity issues can be uncovered early in the BDLC to properly set and manage expectations relative to the installation of an Enterprise Data Warehouse. It is important to have all data issues resolved prior to moving forward, and BBM offers assistance in getting to this resolution. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Staging<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">BBM creates the data model and maps the data from a staging area to perspective data marts. The data that is to be staged is extracted from the legacy system in its original format. The mart contains data that has been migrated from this staging area based on the transformation rules. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Data Validation<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">BBM uses SQL Navigator or another type of validation query tool, to validate the accuracy of the data. It is important to focus on data accuracy and integrity, as this step will identify errors that could ultimately give our clients bad data. Errors identified here could be a result of the processes completed prior to its passing to the data mart, or it could be due to incomplete requirements. For this reason it is important to have thorough data requirements in the initial stages of the project. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Reporting<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Once the staged data matches the original data within the legacy and/or ERP system, we move forward. The reporting tool is brought into play at this time. BBM can use MicroStrategy, Cognos, Brio, or whatever tool is desired, to generate the defined reports. Part of the requirements gathering phase identified the various types of information needed by the users. This information is used to create and generate the necessary reports. Most report tools allow the user to review or alter the information generated to give more detailed results. The client, with BBM s assistance, will ensure the accuracy of the information reported. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">User Documentation<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">User documentation can be developed in many formats, including Microsoft Word and/or HTML, if the client wishes it to be web-enabled. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Training and Support<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">The key to the success of this implementation is to allow you to move forward and expand the process as needed. BBM will train you in all aspects of the data warehouse to enable you to move forward. We will be there to support you if the need should arise. </FONT></P> <P><B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">Success!<BR></FONT></B><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">BBM wants to be a part of your successful Enterprise Data Warehouse implementation. We have what it takes to get you there. We want you to have the right data, in the right format, at the right time</FONT><FONT SIZE="-2" FACE="Trebuchet MS,Arial,Helvetica,sans-serif">.</FONT></P> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </TD> </TR> </TABLE> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=793 NOF=LY> <TR VALIGN=TOP ALIGN=LEFT> <TD HEIGHT=24 WIDTH=793> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=793 HEIGHT=24 bgcolor="#006699" NOF="LayoutRegion11"> <TR ALIGN=LEFT VALIGN=TOP> <TD> <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=690 NOF="LayoutRegion11"> <TR VALIGN=TOP ALIGN=LEFT> <TD WIDTH=141 HEIGHT=3><IMG SRC="../../../clearpixel.gif" WIDTH=141 HEIGHT=1 BORDER=0></TD> <TD WIDTH=549><IMG SRC="../../../clearpixel.gif" WIDTH=549 HEIGHT=1 BORDER=0></TD> </TR> <TR VALIGN=TOP ALIGN=LEFT> <TD></TD> <TD WIDTH=549> <P ALIGN=CENTER><FONT COLOR="#0033FF"><U></U></FONT><FONT COLOR="#FFFFFF" SIZE="-2" FACE="Verdana,Tahoma,Arial,Helvetica,sans-serif">Copyright&#169; Better Business Methods LLC 1997-2009 All Rights Reserved. </FONT><FONT COLOR="#FFFFFF" SIZE="-2" FACE="Verdana,Tahoma,Arial,Helvetica,sans-serif"><a style="color:#FFFFFF" href="../../terms_of_use/terms_of_use.html" target="_blank">Terms of use</a></FONT></P> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </BODY> </HTML>