Blog.kakheti.net

irakli rostomaSvili

iraklirostomashvili@gmail.com

sainformacio sistemis SeqmnisTvis mniSneloviania sworad moxdes gagebuli da Semdeg ki Camoyalibebuli damkveTis mier sistemis moTxovnebi, Zalian xSiria SemTxveva rodesac damkveTis moTxovnebi ar emTxveva Seqmnil sistemas, romeli mizeziTad organizaciebi xSirad aRmoCndebian problemis winaSe, iReben arasasurvel Sedegs da dakarguli aqvT dro, resursi da Tanxa.

arasasurveli Sedegebis Tavidan asacileblad arsebobs sistemis Seqmnis sxvadasxva meTodologiebi, romlebic Seiqmna saukeTeso gamocdilebebis gaTvaliswinebiT da warmatebiT gamoiyeneba sistemebis SeqmnaSi, erT-erTi yvelaze popularuli aris– “Agile” sistemis Seqmnis meTodologia.

“Agile” meTodologia gamoiyeneba sistemis Seqnisas da igi aris cikluri iteraciuli evoluciuri procesi, meTodlogia mdgomreobs imaSi, rom mudmivad aTanxmebs SemkveTTan, sistemis Seqmnis dros saTiTao cikls, da Semdeg etepaze ise gadadis, rom raime Secdoma ar iyos gaparuli. sistemis Seqmnis procesis cikli aseTia:

· moTxonilebis mogroveba/Camoyalibeba/gadamowmeba - samuSao Seqvedrebis dros TanamSromloba damkveTan da im pirebTan vinc uSualod muSaoben am sferoSi, da momavalSi gamoiyeneben sistemas.)

· sitemis moTxovnilebebis analizi da dizaini,

· Sesrulaba

· testireba

TanamSromlobiTi/samuSao Seqvedrebis mizania Camoyalibdes/gadamowmdes sistemis moTxovnebi, funqciebi, gadamowmdes Tu ki sistemis moTxovnebi swored iseTia rogorc aris saWiro da damtkicebis SemTxvevaSi moxda misi Sesruleba. Ppirvel etapze moxdeba mTeli Sesasrulebeli samuSaos mxolod 10 procentis gakeTeba, da yoveli wamratebiTi Sesrulebis ciklis dros moemateba 10-15 procenti da ase 100% miaRwevs. sistemis Seqmnisas mxolod 10 prconetiT dawyebas aqvs Tavisi upiratesobebi, gaadvilebs gaparuli Secdomebis gasworebas, Tuki moTxovnilebebi Seicvleba, ufro advili iqneba misi gadakeTeba axal moTxovnebis Sesabamisad, romelsac ufro naklebi dro dasWirdeba. 10% igulisxmeba yvelaze mniSnelovani komponetebi ra aris sistemiTvis, biznes saqmianobisTvis, da igeba sistemis Conxi, romlezec nel nela daemateba da daemateba sistemis sxva komponentebic.

sistemis Seqmnis samuSao procesi mocavs:

· sistemis moTxovnilebebis mogroveba (TanamSromlobis da samuSao Sexvedrebis dros)

· procesebis da funqciebis Camoyalibeba rac unda hqondes sistemas (TanamSromlobis da samuSao Secvedrebis dros)

· saTiTao procesiis aRwera (dokumentacis) – scenaris dawera, rom naTeli iyos Camoyalibebuli saTiTao sistemis funqia/procesi Tu ras akeTebs, rogor akTebs, ra mimdevrobiT, da a.S.

· sistemis modelireba (“dizain modeli” gakeTeba )

· gadamowmeba, da damtkiceba SemqveTis mier

· Seruleba

· testireba

Summary Document Irakli Rostomashvili

Key words:

CPM (Critical Path Method), PERT (Program Evaluation and Review Techniques), WBS (work breakdown structure), OBS (Oraganization Break

PMBOK (Project Management body of Knowledge) recognizes 5 basic process groups – Initiating, Planning, Executing, Monitoring and Controlling, Closing. Processes overlap and interact throughout a project or phase.

Initiation - Initiation process group consists of the processes that facilitate the formal authorization to start a new project or a project phase. To Define and authorize new project.

Initiation Process Group –consists of processes that facilitate the formal authorization to start a new project or project phase.

Planning Process group involves coordinating people and resources and to develop project management plan. It is constituent process and interactions to plan and manage a successful project. It helps gather information from sources. Planning Process Group facilitates planning across multiple processes, it decides if they need to be done and by whom. (develop project management plan -> Scope planning-> Scope definition -> Create WBS-> Activity definition -> Activity Sequencing-> Activity Sequencing -> Activity Resource Estimating -> Activity Duration Estimating -> Shdule Development -> Cost Estimation – Cost Budgeting-> Quality Planning -> Human Resource Planning-> Communication planning -> Risk Management planning -> Risk Identification -> Quality Risk Analysis ->Quality Risk Analysis ->Risk Process Planning-> Purchase and Acquisitions -> Plan Contracting).

Executive process group is used to complete the work defined in the project management plan to accomplish project’s requirements. It includes following project management processes: Direct and Manage Project Execution ->Perform Quality Asurance->Acquire Project Team -> Develop Project Team -> Information Distribution -> Request Seller Responses -> Select Sellers

Monitoring and Controlling – consists processes preformed to observe project execution so that potential problems can be identified in a timely manner and corrective action can be taken, when necessary, to control the execution of the project. It monitors and controls work being done, entire project effort, provides feedbacks between project phases, in order to implement corrective or preventive actions to bring the project compliance with the project management plan. (it revised as Pan-do-check-act circle). It includes following management processes: Monitor and Control Project Work->Integrate Change Control ->Integrated Change Control->Scope Verification->Scope Control->Schedule Control -> Const Control -> Perform Quality Control -> Mange Project Team ->Performance Reporting -> Manage Stakeholders -> Risk Monitoring and Control -> Contract Administration.

Closing process groups – verifies that the defined processes are completed, it includes following Project Management Processes: Close Project-> Contract Closure ->

There are 9 knowledge areas typical of almost all projects.

1. Project Integration Management

2. Project Scope Management

3. Project Time Management

4. Project Cost Management

5. Project Quality Management

6. Project Human Management

7. Project Communications Management

8. Project Risk Management

9. Project Procurement Management

Project integration management is the most important are, it includes the processes and activities needed to identify, define, combine, unify and coordinate the various processes and project management activities within the Project Management Process Groups. Project Integration process includes: (1) Development Project Charter, (2) Develop Preliminary Project Scope Statement, (3) Develop Project Management Plan (4) Direct and Manage Project Execution (5) Monitor and Control Project Work (6) Integrate Change Control (7) Close Project

it supports and coordinates: (1) Project plan development, (2) Project plan execution, and (3) Overall change control.

· Project Charter – primarily concerned with authorizing the project. It is a process to document business needs and the new product, service or other results that is intended to satisfy requirements.The project charter and baseline project plan provide a tactical plan for carrying out or executing the IT project. project charter serves as an agreement or contract between the project sponsor and project team—documenting the project’s MOV, defining its infrastructure, summarizing the project plan details, defining roles and responsibilities, showing project commitments, and explaining project control mechanisms.

· Develop preliminary project Scope Statement – is necessary to producing a preliminary high-level definition of the project using the Project Carter with other inputs to the Initiation processes.

· Develop Project Management Plan – documenting the actions necessary to define, prepare, integrate and coordinate all subsidiary plans into a project management plan.

· Direct and Manage Project Execution – executing the work defined in the project management plan to achieve project requirements defined in project scope statement.

· Monitor and Control Project Work - monitoring and controlling the processes required to initiate, plan, execute and close a project to meet the performance objectives defined in the project management plan.

· Integrated Change Control - reviewing all changes request, approving changes and controlling changes to the deliverables and organizational process assets.

· Close Project - finalizing all activities across all Project Processes Groups to formally close the project.

Project Scope Management includes the processes required to ensure that the project includes all the works required to complete project successfully. It primary concerned with defining and controlling what is and is not included in the project. The Project Scope Management processes include:

· Scope Planning – documents how the project scope will be defined, verified, and controlled, and how the work break down structure (WBS) will be created and defined.

· Scope Definition – development a detailed project scope statement and future project decisions.

· Create WBS – subdividing major project deliverables and project work into smaller, more manageable components.

· Scope Verification – formalizing acceptance of the completed project deliverables.

· Scope Control – controlling changes to the project scope.

Project Time Management – includes the processes required to accomplish timely completion of the project. The Project Time Management includes:

· Activity Definition – identifying the specific schedule activities that need to performed to produce various project deliverables.

· Activity Sequences – identifying and documenting dependencies among schedule activities

· Activity Resource Estimating – estimating the type and quantities of resources required to perform each schedule activity

· Activity Duration Estimating

· Schedule Development – analyzing activity sequences, durations, resources, requirements and schedule constraints to create the project schedule.

· Schedule Control –controlling the changes to schedule control.

Project Cost Management includes the processes involved the planning, estimation, budgeting and controlling costs so that the project can be completed within the approved budget. The Project Cost Management process includes:

· Cost Estimating – developing and approximation of the costs of the resources to complete project activities.

· Cost Budgeting – aggregated the estimated costs of individual activities of work packages to establish a cost baseline.

· Cost Control – influencing the factors that cost that create cost variances and controlling changes to the project budget.

Project Quantity Management includes the processes and activities of the performing organization that determine quality policies, objectives, and responsibilities so that the project will satisfy the needs for which it was undertaken. It implements the quality management system through policy and procedures, with continuous process improvement activities conducted throughout as appropriate. PQM process includes:

· Quality Planning – identifying which quality standards are relevant to the project and determine how to satisfy them

· Perform Quality Assurance – applying the planned, systematic quality activities to ensure that the project employees all processes needed to meet requirements.

· Perform Quality Control - monitoring specific project results to determine whether they comply with the relevant quality standards and identifies ways to eliminate causes of unsatisfactory performance.

Project Human Resource Management is includes the processes that organize and manage the project team. PHRM processes include:

· Human Resources Planning

· Acquire Project Team

· Develop Project Team

· Manage Project Team

Project Communication Management includes processes required to ensure timely and appropriate generation, collection, distributions, storage, retrieval and ultimate disposition of project information. Everyone involved in project should understand how communications affect the project as a whole. PCM processes include:

· Communication Planning - determining the information and communications needs of the stakeholders;

· Information distribution – making needed information available to project stakeholders in a timely manner

· Performance Reporting – collecting distribution performance information, including status reporting, progress measurements and forecasting.

· Manage Stakeholders – managing communications to satisfy stakeholders the requirements of, and resolve issues with, project stakeholders.

Project Risk Management includes processes concerned with the conducting risks management planning, identification, analysis, responses and monitoring and control on a project. The objectives of PRM is to increase probability and impact to positive impact and decrease probability and impact of adverse to the project objectives. The PRM includes:

· Risk Management planning

· Risk Identification

· Quality Risk Analysis – prioritizing risks for subsequent further analysis or action by assessing and combining their probability of occurrence and impact.

· Quantitative Risk Analysis

· Risk Response Planning

· Risk Monitoring and Control -tracking identified risks, monitoring, residual risks, identifying new risks, executing risks response plans, and evaluating their effectiveness throughout the project life cycle.

Project Procurement Management includes the processes to purchase or acquire the products, services, or results needed from outside the project team to perform the work. It includes the contract management and change control processes required to administer contracts or purchase orders issued by authorized project team members. PPM includes:

· Plan purchases and Acquisition

· Plan Contracting

· Request Seller Responses

· Select Seller – reviewing offers, choosing from among potential sellers, and negotiating a written contract with a seller.

· Contract Administration – managing contracts and relationship between the buyer and the seller, reviewing and documenting how the seller is performing or has performed to establish required corrective actions an provide a basis for future relationships with the seller, managing contracts related changes and when, appropriate, managing the contractual relationship with the outside buyer of the project.

· Contract closure -

1. Business case – In IT project Life cycle in first phase of deliverable is Business Case. Business Case is an analysis result, evaluation of quantitative and qualitative factors: Strategic alignment, Agency impact analysis, Financial analysis, Initial risk consideration, Alternatives analysis. It must be corresponding directly to measurable organization value. Business case development composed by: (1) Select core team, (2) Define Measurable Organization of Value – MOV, (3) Identify Alternatives, (4) Define Feasibility, (5) Define total cost of ownership, (6) Define total benefits of ownership, (7) Analyze alternatives, (8) Propose & support recommendation.

Work Breakdown Structure (WBS) –is the process necessary for sub dividing the major project deliverables and project work into smaller, more manageable components.

Business Intelligence Demonstration - Analysis of Court Data in the State of Tennessee
(resource:http://www.youtube.com/watch?v=-j5J7lXav7Y )

Court system
Court must be allocating resources, and resources must be wisely allocated, base of experience and informed projections.
The administrative office of the court – is responsible gaining their experience, making informed projections, and recommended allocation of resources to the supreme court. This recommendation helps the courts function effectively based on detail data received from those courts, consolidated these data, and the useful information is difficult for many reasons, including the overlapping and inconsistent jurisdiction relationships between courts and clacks who serve them, and by located state of local funded of the court system. In making each recommendation to supreme court EOC must understand how much work is being performed by each of them courts and how resource have been consumed by them by grand vision, by counting, by court type, by judge , by court, by case type, and by other variables. And what the costs are for unit work, as well as revenues court system generates.
View of data form that exists today and the form if we make decisions that we make analysis easier.
We start by looking Court House Case Management Systems. Within the court houses system Tennessee system courts use several different systems from different vendors for managing different court cases, one of them is Tennessee Court Information System or Tennessee’s software product developed for the state by local government data processing collaboration. Tennessee’s is OLTP systems, OLTP stands on Online Transaction Processing (OLTP) and relies on relation databases for storage. Hard of transactional system is detail about specific activities, in the case of Tennessee’s the details are about parties, charges, claims, fines, fees and more to apply a specific cases.
Tennessee’s uses Microsoft SQL Server 2005, and intense system product, non primarily for relation databases features and capabilities. Microsoft SQL Server reporting services is including SQL server 2005 at none additional charge. Reporting services has the ability to create and deploy attractive report from relational database, in HTML, PDF, World, Excel and other formats, with familiar tools which has similar interfaces across Microsoft line of products and users can often create reports in database systems which they for them are familiar, but the system like a Tennessee’s which has more than 400 of tables and numerous complex relationships amount SQL service reporting service and other products like, or not enough permit intuitive query design, almost all reports in this complex system require programmers, db professionals, to design the queries populate reports as a part of an application, ant these reports cannot be designed and hacked at one time. Information exist and the system like Tennessee’s , to enter the AOC questions about resource use, but there are many problems with using these data for exact the analysis, besides lack of query for this type of queries, some of them are that data is too detailed for exact the analysis, there are several vendors in court house systems that collect the information when the db designer uses deferent structure and terminology and analyze immerged. Deferent codes are used by personal in different court houses record data, even when they are using systems by the same vendors. And wants AOC does have this data, it is not unify single database, where state wide analysis can be done. Analysis would permit drilling down to the state wide data various variables in a manner would reveal trance.
• Data is too detailed;
• Data systems are from multiple vendors;
• Inconsistent coding of data
• No single database for analysis

Different way thinking about database design required in order to permit decision makers to view data for all these transactional systems in the meaning for responsive interactive way. The need for this type of thinking has resulting in a technology called Online Analytical Processes - OLAP. Microsoft SQL service analysis services is all about OLAP. Analysis services is a core component of Microsoft SQL Server 2005.
SQL Server 2005 therefore more than relational database, it is a comprehensive database platform provided enterprise class data management, with integrated Business Intelligence tools, that go well behind relation database capabilities. One of Oakwood for service offering is business Intelligence, an Oakwood believes business Intelligence (BI) approach suggested by the meander of these presentation and strongly supported by SQL Server 2005, offers the most flexibility an inside AOC analysis support data executed level. We will see how SQL Server 2005 how make all this work and how Oakwood can create SQL server 2005 Business Intelligence solutions for AOC. To demonstrate EOC Analysis executives, intuitively interact with the analysis services to Microsoft excel, to use data they may already have and ways much more helpful than previously envisioned. We start the journey at the court house, we are see analysis services is the destination. First is view intermediate form relational database called Star Schema Data Warehouse, which reformats the data from relational transactional databases.
Star schema data Warehouse takes the data from many transactional systems and copies the data to a common format with the completely deferent relational database design and a transactional system, containing many star Schema configurations, each start Schema has a central fact table, which represents an events or an currencies that has measures that are always numeric. Therefore they can be counted sum or averaged. Measures could include account of number of cases filed, the count of this positions of cases as the example of this demonstration. Or the find access per case in an analysis criminal cases, a single fact table can have many measures for dimensions, so long to protein same variable or dimensions, if important measures do not share all their dimensions and many of them will not, we can make other fact tables in the star schema data warehouses and relate those fact to the relevant dimensions, an interesting future of start schema data warehouse is that end-users intuitively understand it, they understand that they are looking at some related measures that can be sorted by relevant dimensions.
One challenge of designing and constructed the Data Warehouse is determine how to involve tables, rows, columns available. What is the measures which it find the relevant facts upon which the pays analysis and projection.
Another Challenge concerns how we will address of the existing problems that would be previously identified with existing data. Remember the one of the problems was the data was the databases from different vendors, each with her own schema, and the past translation to the common design of the data warehouse was done by writing low level database vendor and database content specific programs to do all the work, remember the data was not coded consistivly, in the several items maybe code maybe using difference court house terminology , the difference bay be small and obvious, or large and saver. There may be Misspellings of key terms or names may be presented differently for example all of these issues effect quality of data and afford necessary to transform data in the to store schema data warehouse. Performing the tasks associated moving, correcting and transforming from transactional systems to start schema data warehouses is called extraction, transformation, loading for ETL. Assuring data quality per amount, and developing ETL part of the project is the time to do it, it can last detesting at the conclusion of the project. In a perfect system information will follow one way, for ETL system to start schema data warehouse, but developing ETL process often detects errors and inconsistencies in the initial character of the data, this may result in recommendation from ETL developers for OLTP system users, or to OLTP developers to assure that earns of the tactic type not made or not concluding being made during the initial of data entry.
Loading the Star Schema Data Warehouse
• ETL = Extraction, Transformation and Loading
• Quality of data is assured during ETL phase of project
• Developing ETL of the provides feedback to users and OLTP developers to make data sources better
With tools provided by Microsoft developers now have the ability to more easily automate the importing and transformation of data for many different systems across the stay, at the Star Schema Data Warehouses at the office of EOC , part of SQL Server 2005 which exist in the automation of ETL process it is call SQL Server Integration Services or SSIS, because these tools take common issues in ETL and have predesigned components for many of them, ETL developers can focus on an attributes and tasks specific to particular project and its data. Ready degree inventing someone ETL code for each project and for each type or brand of data source. Even when the measures and dimensions are a currently specified, the short coming of store schema data warehouse is the simple queries that can give only one piece of date at a time, the intersection of a measure what a single value for each of the dimensions, in order to make competences between many values in useful way greater query ability is needed. SQL Server Analysis Services (SSAS) is the next step in our journey.
Analysis Services (SSAS) Analysis services store stores data another format called cup. The cub is a convenience because usually there were be more than 3 dimensions of variable against which we wish to aggregate to analyze the data. For demonstration, that’s consider the cub that does have only 3 dimensions. It will be the cub that measures the count of these positions of Court Cases. Long one exes we have the dimension of Time, along another we have County dimension, across the third we have Judges. To keep the cube simple, we have subset of values that these dimensions might take on, the values that the dimensions cane take on are call members, if we said one member of each dimension to a fix value, a single measure will result, but the cub is going to use many of the cells at a time which gives eight broader comparative view of a data. Because the data is pre aggregated we will able to adjust our queries of cumbrance in real time. Without having for wait 30 minutes, from report generated tool to come the all details refuge transactional database to populate the cells of the cub. That locate the cub through the Analysis Services based on data from several transit databases, that have been places in the single Star Schema Data Warehouse, this data is not an actual data, or ex actual data that has been modified during the testing. Some of the data is representing is coming from the wrong county to permit demonstration how the data can be allocated across sub dimensions and merged crossovers.
Microsoft has position Microsoft Excel is the actual user interface from Microsoft SQL Server Analysis Services , Analysis Services is Server Based SQL Server which means that users from many pieces can connect the single repository of the data, end Excel is used to make that connection. Security is based on Windows logins, and can been limited by dimensional measure down to the individuals self level. Connecting to a cub is not difficult, uses copy of excel scrat sheet for a network location which has already has configuration information defined, the details of a staffs for connecting is not important. The important area of the spreadsheet for use of spreadsheet Analysis Services is PV Table, there are places fro PV table and placing dimensions, dimensions can also be places to filter the entirely view of the data. We will place our first measure (Count) in the central area of the pv table, this cub currently have only one measure defined, we will place Time dimension, in the horizontal side of pv Table. We can select individual select for view. Putting the dimensions, next we can ask to Analysis to show the year by count and percentage.
We can save configuration of the spreadsheet as a web page, give all the interactivities of Excel, just future special activity control that is license that is part of Microsoft office, and users must have license to excel, in order to view these web pages, the users must have network connection to analysis of Services, security is still the force of by the Windows operating system , many users can view only those measures and dimensions they are authorized to view, notices that web page has similar appearance as excel, and the data that was not displayed in excel at the time spreadsheet was made is still available because of spreadsheet is connected directly to Analysis Services.
It is possible to save a portion of Analysis Services Cub to an operating system file, and this is called a local cub. This local cub can also be created using ETL technology, the advantage of local cub is no longer required network connections to an analysis services to view in the cub data within the excel, when analysis process periodically updated with additional facts or events, that process can run slides of relevant portions of a cub or cubes, and email them to the remote location that may not otherwise have access to a network to another to the Analysis Services Server, SQL Reporting Services (SSRS) mentioned previously connection with relational databases can also used to generate multi type relation report as web pages, PDF files or other formats that are more attractive for publications. Unlike the tubes with complex, relational, transactional systems, SQL Server Reporting Service is usable by end-users to generate the reports with the analysis services as the issues that is use similar presented by excel which end-users can easily grasp.
The discussion so for these presentation has focused reflecting what has happened, or what is happening now, is what we want to be able to do is to predict the future, in order to make recommendations, this cannot be done with recently, there are two tools to use test mathematical modules to help makes these projection and give them additional credibility, the field of data mining is also part of Business Intelligence and is also part of Microsoft SQL Server 2005 , using these technologies, SQL Server Analysis Services with Data Mining techniques EOC can estimated future growth the cases stated wide, their types and the counties which day they will be wild, the EOC will project how many judges court system will need next five years, as well fees would be adjusted, with the fiscal court feasibility available, supporting to work to be done, or must be extended or built, easier automatic kind of questions we want to answer and data mining means the answer them.
• How many cases will be filed annually five years from now?
• Where will they be filed?
• How many judges should there be five years from now?
• What should fees be?
• Will the physical Facilities be adequate to support the courts functions?

Concepts for Understanding Analysis Services
Type of Data Type of Database User Understanding of Databases Structure Purpose of Database How Viewed Ad Hoc Querying
Traditional Relational Limited Daily Detailed Activities Customer Application Limited
Define Key Measures and Dimensions
Automate Extraction. Transformation and Loading into Star Schema
Star Schema Data Warehouse Relational Intuitive Intermediate Step to OLAP Cube Limited Limited
Define Derived and Customer Measures and Dimensions, Define Security
Automate Processing and Deployment into OLAP Cubes
OLAP Cube Multi-
Dimensional Intuitive Decision Support Microsoft Excel Extensive

What we discover so far?
First we now that computer systems we are most accustomed to are transactional nature and store the data in relational databases, users do not typically have must of understanding of these relational databases and view the data predefined with the user interfaces, and have the ability only requery manner that has been canfield format by programmer, if we perform an analysis to discover the key data aliases , that comprise all measures and dimensions of all relevant databases and database types. We can extract this data, massage into a common format and load it in to Star Schema Data Warehouse. While designing of these Data Warehouse is often understand by end-users these presentation of data explanation as well, if there are arrived and calculated measures and dimensions such as year to year change calculations shown in the Excel demonstration formulas for these and calculations specifically subject meter of the cub must be defined, the data is an process from Schema Data Warehouses and loaded into the Analysis Services Cub, users are then generated to use data from excel, or web pages using excel like a features. If the EOC wishes to engage Oakwood System group for an analysis services project, these are steps which we will follow EOC and Oakwood will each identify Teams of person to work together on the project, personal from AOC will include the person who will currently responsible to extract data from all resources , to help to understand the data is available and being used and the questions from EOC has been asking an entering , there would also person from EOC that is consumer of these Detail data, who is responsible for assigning automatically executive recommendation to supreme court, the EOC team would include person with familiar in Technical IT Infrastructure which exist across the state to assure that all positional sources of data are included to assist in accessing data these systems and a help implement the automation ETL process and to assure success of deployment of the Analysis Service Product, EOC also chose to provide project manager.
AOC Team Members
• Court Data Analyst
• Executive making recommendations to Supreme Court
• Technical IT Infrastructure Specialist
• Project manager

Oakwood Team Members
The team assembled by Oakwood would include the Project Manager if one is not provided by the AOC who is automatic responsible for coordinating for all the work done in the schedule that has everything come together at the appropriate time for project completion, the team also will include Business Analyst , Data Warehouse Designer, Several ETL Developers and Quality Assurance Testers. One person may have more than one role in the project.
Oakwood Team Members
• Project Manager
• Business Analyst
• Data Warehouse Desingner
• ETL Programmers
• Quality Assurance personnel
After the team assembled Business Analyst will inventory all the Court Case Management System in use by courts across the State, The Business Analyst will also inventory Data Assistant use by the courts that do not directly related to Case Management but which have potential share dimensions which court case done, next Business Analyst will analyze these databases to propose candidate measures and dimensions working with the AOC Analyst to define precise those items which is most relevant the understanding the Court System from the stand point of projecting future use of the Courts in Tenancy. The automat responsibility for approving the measures and dimensions to be used for alls Executive of AOC that would be using information to make the actual recommendation to Supreme Court, the data Warehouse Designer then designs the Star Schema Data Warehouses, using ETL Developers Oakwood automatic the extraction, transaction and loading of data from these Transactional Systems and store Schema data Warehouses, there were probably be several ETL Developers working in parallel on the processes, automatic result in the parallel processing the data from deferent sources and loading of the data into the Data Warehouse database. ETL is the biggest and most complex part of the project and the place where the Project Manager skills will be most visible and valuable, the Data Warehouse designer will be assure that the quality of the data from these processes is good. ETL Developers will than automatic the transfer of the data from Data Warehouse Systems, to Analyses Services Multi type dimensional databases. As well as the processing to aggregates the data in advanced to use. The cub data can deploy to Server where accessible by other authorized and users. Quality Assurance Personnel assure correctness of the product entire Analysis Services Project at these point Oakwood would be able to make proposal to define Data Mining mast to permit mathematical projections of future utilization of resources and to discover the relations and trends that are not obvious from visual instruction of cub data.

Steps in Project
• Business Analyst inventories databases
• Business Analyst analyzes databases
• AOC Executive approves dimensions and measures
• Data Warehouse Designer designs start schema
• ETL Developers automate data transfer into star schema databases
• ETL Developers automate data transfer into star schema databases
• Data Warehouse designer assures quality of transfer into data warehouse
• ETL Developer automate Transfer and processing of data into Analysis Services
• Quality Assurance personnel assure correct functionality of entire project
• Oakwood proposes next step in data mining