Business Improvement Plan/Data Analytics For Vista Concept Dimensions

Project Background:

Vista Concept Dimensions is a plan work on giving structural administrations to individual customers and building industry rehearses. At VCD we offer the accompanying administrations:

• Urban Design

• Building Design

• 3-D Concept Drawings and Visualizations Council Planning/Building Approvals documentation

• Development Documentation

• Extend Management

• Introduction Drawings

• Transformation of paper media/pdf information to AutoCAD DWG

They were founded in 2009 with exhortate about suburbia and on the off chance that we shall have a particular suburb, where they can conceptualize the waitlist lands with additional properties and give you an understanding with respect to speculation openings. Leave the diligent work to us and we can help you from Land Selection till hand-over, so we can proceed with your everyday routine effortless. We are additionally connected with different experts from different businesses like Engineers, Surveyors, Builders, Real estate, Financial Advisors, and so on so you can rest guaranteed that every one of your questions will be replied.

The contact person for Vista Concept Dimensions:

• Client Name: Ashutosh Vadnere
• Client Email: [email protected]
• Client mobile No: 0421769253

• Vista Concept Dimensions Construction Company is providing services such as architectural design for residential houses and commercial offices, building development, property extensions home renovations and now the company is upgrading the present business processes.
• First of all, company focuses on changing business processes so it can help easily to understand business processes.
• Secondly, company need to update business processes like during work period client get information through mail or messages before allocated dates that can help to client next processes or work.
• Vista Concept Dimensions Company using Microsoft Excel to store business related data for individual customers, therefor it is difficult to find information about particular customers and it is time consuming method.
• Now they currently using Microsoft Excel to store data rather we are going to use IBM Watson which is more worth to satisfy our motive.
• By using this tool, business process can be improved by utilizing less amount of time.  
• Moreover, that all new updates help to vista concept dimension company to improving current business processes and providing quality of work to the client.

Low Level Requirements

• Concept design:

The customer (defined as the one who wants to build a house/office) approaches the Vista Concept Designers to have an architectural plan to suit their needs and budget. Documents includes quotation for construction contracts, ordering material, scheduling, organising these are the files are included which are in different formats. The new business intelligence tool helps the client to organise the files and documents.

The files and documents used by the client

• Council approval:

Documents, processes (creating architectural plan according to the council rules), parties involved (Council office, customer, designer).

• Engineer approval:

Sketch of proposed work, site photos, permission from land lord and council. Relevant engineering standard details.

• Organise truss documents:

Roof frame and signed by register builder

• Building approval

 Value of new building, building permits documents, details of applicant, details of applicant.

• Ordering materials
• Laying foundation
• Starting construction
• Utilities like electrical, water and gas
• Roofing
• Rough plumbing
• Lighting and electrical connections
• Flooring and
• Tiling
• Painting
• Shelving
• Finishing electrical and lighting
• Making modifications
• Handing over the building

Every individual construction project contains these files which the client using in different formats and storing in different locations.

IT Support:

• These files are to be organized, stored and retrieved in a single access for analyzing the parameters and processes involved in construction.
• Designing a dashboard for accessing all the files.

The houses/offices built around Adelaide metropolitan area.  Regulatory requirements may vary (slightly if not hugely) between councils.  Meeting regulatory requirements imposed by each council with the help of IT or Business Information Systems (BIS).

 Starting from concept design to the handing over the building to the customer each project generates data and stored in various locations.  The data includes but not limited to plans, approvals, emails, tenders, quotations, orders, invoices.  Tracking of the data related to each project;

• tracking data related to each subcontractor across projects;
• tracking data related to each week to keep track of weekly transactions;
• tracking data related to each council to reduce the time approaching the council;

Work tracking: Different projects would be at different stages.  Keeping track of the work related to each project.

Searching: Searching for work you need using IT instead of manually visiting each folder looking for a file.

Report Generation:  Generating reports for each project/week/subcontractor etc. 

Vista company requires a business intelligence tool to replace their existing manual business process of handling and managing their overused manual data entry process to overcome cost, time and errors occurrence caused by their traditional methods of business operation described in introduction.

These problems can be solved by providing single cloud backend system that allows business intelligence to operate using (i) Cloud technology, (ii) On-premises system that allows client to interact with the cloud system and mobile application to provide (iii) Advanced analytics.

(i) Cloud technology:

• IBM Watson technology stack
• Pentaho
• Informatica
• SSIS

(ii) On permission system / Local client:

• Dashboard
• Excel integration: Allow client to import and export excels
• Data discovery or Search

(iii) Advanced analytics:

• Data interrogation
• Data visualization
• Reporting

Task:

Stakeholder Name	Contact detail EMAIL	Role	Responsibilities	How could stakeholders Contribute to the project
Ashutosh Vadnere	[email protected]	Project Client	· Coordinate activities, resources, equipment and information. · May also be financier and eventual owner.	Provide resources and all data need to implement
Naga Dasari	[email protected]	Project Supervisor	· Reviewing the project up to date. · Supervise the methodologies used to implement the system. · Feedback to key stake holders.	Help or guide how to improve project work
Bobbili Sai Kumar Reddy	[email protected]	Project Manager	· Planning and monitoring the project work. · Adopting and applying appropriate technical and quality strategies and standards. · Allocate the tasks to the team members.	Manager is responsible for project planning and activity Co-ordination and co-operation of group members
Nukala Narsimha Reddy	[email protected]	Data Analyst	· Mining the business data. · Perform statistical analysis of business data.	select appropriate tools and methodology
Hiral Patel	[email protected]	Researcher & Documentation	· Helping to identify · Sources of research. · Coordinate resources and tools to promote collaboration. · Develops and maintains requirements documentation	Verifying information related project, select standard format for report
Jay Kumar Patel	[email protected]	Business Process Analysis	· Monitor and measure the effectiveness of processes. · Identify, document and analyse business rules. · Collate feedback on process performance.	Re-engineering business process

As per the requirements Vista Dimensions wishes to make conceptual design along with various approval from admin panel. The IT support as well regulatory support shall be given for day to day activities of the project implementation.  The vision of the venture is to coordinate the information which shall help Vista concept dimensions to apply the construction concept with better facts and figures available to them. The other useful terminologies which shall set the design team in construction design projects are:

• The BI system designed should give the capacity to penetrate down, bore over, and cut up.
• It shall give the capacity to indicate hierarchical chains of importance and show execution scorecards for each authoritative unit.
• This system might empower part based access to data to Vista Dimensions team.
• It should give capacities to course cautions to business clients as per client characterized parameters.
• This BI system shall empower joining of information from numerous different sources

• The new BI system shall maintain quality services and recommending potential optimization business process such as construction design, 3 D based framework etc.
• The process to retrieve any file shall be very smooth in  the new system.
• The BI tool framework shall allow to conduct periodic reviews to ensure consistent value delivery.
• This redesign of business procedure to enhance general organization effectiveness.

• It shall allow to enhance the present business handle by prescribing business intelligence tool.
• The of Information Technologies terminologies shall help vista Dimensions in better coordination with their clients, employee and government administrations.
• This shall facilitate the process in which their business process shall have better government certifications for construction projects.
• This shall be useful for various manual data analysis process run in the Excel format, which shall give us better analysis report based on sales, material exported and imported.
• They reengineering process shall be used model various data modelling activities for better support and analysis.

The Dashboard designed for Vista Dimensions shall be having following functionalities:

• The dashboard designed shall sets up an unmistakable linkage between business procedures, the center business forms by means of which the techniques are executed, as well as BI-driven business change openings for projects, which is the reason for a providing BI business case that is convincing to the business partners;
• It shall distinguishes plus unmistakably portrays what business data, explanatory apparatuses and strategies, and choice support is required by the business to acknowledge BI-driven change chances to administration forms, client forms as well as operational procedures;
• It shall showcase the fundamental contribution to the way toward characterizing particular BI extends and organizing those tasks in view of key criteria, for example, business effect and time-to-market;
• It shall be giving us the methods for adjusting business knowledge, business prepare change and adjusted scorecard activities;
• The dashboard designed shall drives key information engineering choices;
• It shall also be giving the premise to end-to-end traceability between BI prerequisites affirmed by business clients and the conveyed information stores and BI applications; and

• Gives a key pattern against which the execution of the BI activity can be measured.

The scope for which business role shall be customized for different time horizon along with level of detail as well as point of view defined for various reports in BI dashboard. The terminologies are explained below:

Business improvement plan analytics for vista concept dimensions and purpose of project is data analytics and business process engineering. Team concept squad members are monitoring project work, using appropriate methodologies, mining business data perform statistical analysis and make easily business process in lowest cost as well as save time.

• Goals:Focusing on the client requirements mainly data analytics, data mining, visualization and creating dashboard

• Timeline– depending project requirement’s estimated to complete in 3months

• Costs and Budgeting– usage of tool may cost to the client $40/month for IBM Watson it helps the client in time saving and creating dashboard helps analyze all the files at one place

• Resources–our approach is qualitative approach where requirement gathering, documents from client and data analysis

Observations–as per the client requirement in suggesting tools he mentioned free tool but including with IBM Watson we are suggesting pentaho for client we move forwards according to client interest

The methodologies we shall be incubating for this business intelligence project for Vista Dimensions are:

At the point when information is put away as a set or framework of numbers, it is exact yet hard to decipher. For instance, are deals going up, down or holding relentless? When taking a gander at more than one measurement of the information, this turns out to be considerably harder. Subsequently the perception of information in graphs is a helpful approach to promptly see how to translate the information.

Information mining is a PC bolstered technique to uncover beforehand obscure or unnoticed relations among information elements. Information mining methods are utilized as a part of a bunch of ways: shopping crate examination, estimation of items customers purchase together with a specific end goal to advance different items; in the keeping money segment, customer chance appraisal is utilized to assess whether the customer is probably going to pay back the advance in light of authentic information; in the protection area, misrepresentation location in light of behavioral and recorded information; in solution and wellbeing, investigation of difficulties or potentially regular maladies may lessen the danger of cross contaminations.

Configuration, calendar and era of the execution, deals, compromise and reserve funds reports is a range where BI devices help business clients. Reports yield by BI apparatuses effectively accumulate and exhibit data to bolster the administration, arranging and basic leadership handle. Once the report is outlined it can be consequently send to a predefined appropriation list in the required shape displaying every day/week by week/month to month insights.

About all information stockrooms and all undertaking information have a period measurement. For instance, item deals, telephone calls, understanding hospitalizations, and so forth. It is critical to uncover the adjustments in client conduct in time, connection between items, or changes in deal contracts in light of advertising advancement. In light of the authentic information, we may likewise attempt to anticipate future patterns or results.

Answer:

OLAP is best known for the OLAP-3D squares which give a perception of multidimensional information. OLAP 3D squares show measurements on the 3D square edges. The qualities in the 3D shape speak to the deliberate. The client can explore through OLAP 3D squares utilizing drill-up, – down and – crosswise over components. The bore up usefulness empowers the client to effectively zoom out to more coarse-grained points of interest. On the other hand, penetrate down presentations the data with more subtle elements. At last, penetrating crosswise over implies that the client can explore to another OLAP solid shape to see the relations on another dimension(s). All the usefulness is given progressively.

Factual investigation utilizes the mathematic establishments to qualify the criticalness and dependability of the watched relations. The most intriguing components are circulation investigation, certainty interims. Measurable investigation is utilized for conceiving and examining the outcomes from information mining. 

• Collecting Data From Individuals:

Data is collected from the client and stakeholders regarding the project requirements. The unstructured interview is gain to understanding of the present work situation regarding the problems for the project.

• Data Analysis:We had gone through the analysis of the data of present business process of vista concept dimensions. Collected detailed information and requirements from the present business process which helps us for the validating the requirements completeness.

• Observation Technique:

As per timeline of the project the project team observes the detailed business flow of VCD in order to get full understanding of different aspects of the workflow which makes the project team to implement business process of VCD in easier way to make client suitable for the business process.

• Interviews

• Interviews can be led face to face or via phone

• Interviews should be possible formally (organized), semi-organized, or casually

• Questions ought to be centered, clear, and empower open-finished reactions

• Interviews are principally subjective in nature

• Polls and Surveys

Reactions can be broke down with quantitative techniques by appointing numerical esteems to Likert-sort scales

• Results are for the most part less demanding (than subjective procedures) to break down

• Pretest/Posttest can be thought about and examined

• Perceptions

• Allows for the investigation of the flow of a circumstance, recurrence checks of target practices, or different practices as shown by requirements of the assessment

• Good hotspot for giving extra data about a specific gathering, can utilize video to give documentation

• Can deliver subjective (e.g., story information) and quantitative information (e.g., recurrence tallies, mean length of connections, and instructional time)

• Center Groups

An encouraged gathering meeting with people that have something in like manner

• Gathers data about consolidated points of view and suppositions

• Responses are frequently coded into classes and dissected specifically

• Ethnographies, Oral History, and Case Studies Involves concentrate a solitary wonder

• Examines individuals in their characteristic settings

• Uses a mix of strategies, for example, perception, meets, and overviews

• Ethnography is a more all encompassing way to deal with assessment

• Researcher can turn into a perplexing variable

• Archives and Records
• Consists of inspecting existing information as databases, meeting minutes, reports, participation logs, monetary records, pamphlets, and so on.
• This can be a modest approach to accumulate data yet might be a deficient information source

We follow some guidelines in order to make an effective suggestion for improvising the business process through business intelligence. These are some critical analysis or some models we have focused in order to suggest the business intelligence.

Reliability:

How this project is going to be reliable, without any issues it depends on the tool how effective it will be for his existing business process.

Usability:

How this new business intelligence tool helps him, like the easier to use, the easier to understand? This depends on client satisfaction.

Functionality:

How effectively it is working, does the project reaching the objectives of the client. The procedures define everything.

Portability:

Does the project is compatible, whether it is open source are not this makes more important requirement in developing any application or business intelligence tool.

Maintainability:

IT depends on quality of the application you use that measure the and speed with which a framework can be reestablished to operational status if any failure occurs.

These standards are maintained according to the ACS standards this project contains all the specification mentioned by ACS

It is the next generation, machine learned-enabled user experience, were we can create the automated data pattern detection and accepts the natural language query, it can handle both IT authored data or business user content data. Their main design patterns which helps in easier use for user. It provides strong vision particularly providing innovative analytics.     

IBM also has IBMSPSS predictive analytics and data science experience. It also has cognos analytics it provides as hosted solution via IBM cloud. It provides complex cloud based services along with guidance and data prediction. IBM Watson analytics can refine, explore, predict and assemble the data.

Client Introduction:

In addition to achieving vista concept dimensions’ business client through the free choice, Watson Analytics additionally guarantees availability through representation and self-benefit usefulness. Since Vista Concept Dimensions don’t have sufficient energy to spend in investigation applications to dissect the information, they require an answer that can rapidly give them bits of knowledge. Watson Analytics accomplishes this via naturally creating examinations in view of relationships that the framework distinguishes from the inputted information.

In addition to achieving vista concept dimensions’ business client through the free choice, Watson Analytics additionally guarantees availability through representation and self-benefit usefulness. Since Vista Concept Dimensions don’t have sufficient energy to spend in investigation applications to dissect the information, they require an answer that can rapidly give them bits of knowledge. Watson Analytics accomplishes this via naturally creating examinations in view of relationships that the framework distinguishes from the inputted information. At the point when all data is coordinated into a BI application, it winds up noticeably intellectual Business processes. A subjective business application can be utilized to robotize business forms that arrangement with a lot of information and complex choices made by learning laborers who must choose the most ideal option among a few answers.

With subjective processes, the result of the procedure is characterized however not how to accomplish it. Or maybe, its support for intellectual investigation over organized and unstructured data sources empowers it to consistently find, learn and utilize new data to accomplish the characterized procedure result. The procedure is found, learned and altered considering aggregated information and experience. Consequently, the consequences of subjective examination decide prepare execution—when, what and how a move is made, and whom ought to be reached. As new data winds up noticeably accessible, the game-plan changes in like manner.

At present, intellectual processes is being connected in data escalated enterprises where multi-structure information are critical to realize better choices and where the vista dimensions are learning specialists who settle on choices in view of their master information of a specific space. Subjective investigation improves them specialists.

This type of analytics does the Subjective investigation when it is still in its initial stages- – and it is in no way, shape or form a swap for customary data and examination programs. Yet, for associations, that need to discover ongoing answers covered up inside enormous measures of different information, getting a kick off on building subjective examination capacities [into business processes] could be a shrewd move.”.

	Free	Personal	Professional
Price	$0	$40	$110
Number of users	1	1	2 or more
Files and excel files	Yes	Yes	Yes
Access to more sources of data	No	Yes	Yes
Social media access	No	Yes	Yes
Share datasets, refined datasets, Explorations, Predictions and views	No	No	yes

Data can be added easily through local file, connection via online and drag & drop files. As we are using the data files which are of Excel sheets and .CSV the files can be drag and dropped in the tool. The tool has access to PDFs log files and text files with just one click. The re and undo for data change can be done on one click.

Data integration helps to transfer structured and unstructured data into the system in scalable platform. It is the combination of technical and business process which combines data from different sources which helps to maintain quality and valuable information. Data integration maintains trusted data which is understandable so the company will be consistent and governed individual time. 

Meeting regulatory requirements:

Depending on the utility, new paradigm emerging and day to day IT issues that they lack time and resources to formulate long term solutions for overcoming these issues the cloud based IBM is an efficient way to store the data and to have exponential growth in data volume.

• Pentaho is a standout amongst the most dependable and stable for business knowledge stage as a result of its simple learning and for indicating more on what to do as opposed to how to do.
• The instrument has one of a kind capacity for brushing the information combination with scientific handling and it significance in accelerating the outcomes forms for accomplishing information perception permitting the customer for clever business choices which prompts the coveted outcomes.
• Pentaho is likewise intended to work well with the iOS or android stages empowering the customer for a smooth ordeal from the tablets or cell phones.
• The most recent adaptation 7.0 which is released in the year 2016 which joins information mix and business investigation servers.
• It holds up coordinated explanatory work stream with the visual information get to and ability for getting to enormous information.
• Pentaho is the open source BI tool.
• Modular for flexibility and easy customization. Dramatically lower upfront and ongoing costs.

ü Data Integration	ü Predictive Analysis
ü Business Analytics	ü User Friendly Interface
ü Big Data Analytics	ü Interactive Reporting
ü Ad hoc analysis	ü Performance Measurements
ü OLAP	ü Intuitive Dashboards

Some of features which are used in the project as per the client requirements are:

Pentaho modern, simplified an interactive approach which helps business user to access, discover and blend all types and size of data. With the advanced analytics and predictive modelling. Where client can examine and picture information effectively for himself without the assistance of the IT proficient.

Interactive Reporting:

Pentaho interactive reporting helps the client to add the elements to the report layout easily and quickly. Features include in interactive reporting font selection, column resizing and sorting, ability to rename the headers. Has the ability to output the reports as HTML, PDF, CSV, Excel files. For the interactive report the metadata model is used.

Data Integration:

Data integration which helps the client to ingesting, blending the data and filtering the data from any data source. Pentaho allows users to add a different data files form different data sources to produce the best quality of data.

Pentaho Dashboard Designer:

Dashboard Designer enables client to make dashboards. The dashboard contains a few distinct reports united inside on one screen. Creating a dashboard by choosing the design, subject, and substance you need to show.  Including any sort of reports, outside pages, or dashboard inward components (graphs and information network) that get to Pentaho Metadata information sources. Add dynamic channel controls drive content inside a dashboard utilizing other dashboard content

Communication

In project during project execution communication is vital factor for getting better output in business process less time and better ways. About my project all stakeholder communication in various ways such as:

Client Meeting:

In project according to client requirements updating business process that time directly face to face meeting with client in the month two times.

Team Meeting:

Updating business process next process, selecting best tools or methodologies for project team member’s weekly meeting through getting understanding related work each other’s.

Social Media:

Our team created a group in WhatsApp group for discussing project related process. Thus social media helps to easily and quickly contact to team members anytime all days.

Email:

Also in project all stakeholders connected through email. For example, need to arrange client meeting so team directly mail to client, need supervisor guidance, sending work, getting feedback in report contact through mail. Also team via mail dividing work tasks, show work to each other, and getting important notes related project.    

Change Management

Change management includes project change and organizational change that both are effect the project progress. For example, in project change directly affect project such change project cost, time and quality of work.

Risk Management Plan

• Sometime due to project and organization changes create risk in project. Risk is anything that may impact the project team’s ability to achieve the general project success measures and the specific project stakeholder priorities. Few thinks affect the project management and create project risk such as:
• Quality and time management
• Task completion by team members in time.
• Resources

Strengths:

• Involves the collection and evaluation of key data.
• After collection of data and analyzation the company capabilities in these areas are assessed.
• Gaining experience in usage of tool.
• Dashboards are the easy to use for end users.

Weakness:

• Budget allocation for the professional tool.
• Lack of adequate resources.
• Sometimes requires multidimensional data for modelling.

Opportunities:

• Views opportunities as significant new business initiatives available for health care organization.
• Allows for real time business intelligence without a data warehouse.
• Cloud computing is an additional for the data storage.
• Increased in funding helps the organization to develop sharing datasets and access to more sources of data.

Threats:

• Ethical issues
• Security
• Maintenance cost for the tool

Present:

Present we are analyzing all the data of the client as client main requirement is data analysis and business process reengineering. We have selected two tools which helps client to analyze and visualize and create dash board. The tools are IBM WATSON& PENTAHOO which are open source BI.

To Be Achieved:

To show the working of the tool by producing some prototype. How it is will be useful for his current business process and how it makes easy in use of his data from unstructured data and which helps in decision making. 

How ?

We are going to do some analysis on the tool its reputation and risks, and verify with data of the  client. Going through in depth about the working of tool to make it easy to client and help us to produce better result and show him how it will be beneficial to client. Right now we are going through data analysis.

Task Name	Start	End	Duration (days)
FUNCTIONALTIES	16.07.2017	23.07.2017	8
ASSIGN RESOURCES	24.07.2017	03.08.2017	10
DATA ANALYSIS	04.08.2017	14.09.2017	40
CREATING DASHBOARDS	15.09.2017	30.09.2017	15
TESTING	01.10.2017	05.10.2017	5
IDENFYING RISK	06.10.2017	12.10.2017	7
PROTOTYPE	13.10.2017	19.10.2017	6
DOCUMENTATION	20.10.2017	03.11.2017	14
PROJECT DELIVERY	04.11.2017	25.11.2017	21

ACTIVITY	ACTUAL START	ACTUAL DURATION	PERCENT COMPLETE	PERIODS
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22
Project Kick off	7/16/2017	4	0%
Requirement Gathering	7/21/2017	6	0%
Finalization of Requirements	7/28/2017	5	0%
Project planning	8/3/2017	6	0%
Data collection methods	8/9/2017	8	0%
	8/17/2017	6	0%
Finalization of data collected	8/23/2017	3	0%
Design and Prototyping	8/26/2017	35	0%
Design finalization	10/1/2017	25	0%
Testing and Integration of Dashboard	10/26/2017	7	0%

References:

Chang, V. (2014). The business intelligence as a service in the cloud. Future Generation Computer Systems, 37, 512-534.

Chung, P. T., & Chung, S. H. (2013, May). On data integration and data mining for developing business intelligence. In Systems, Applications and Technology Conference (LISAT), 2013 IEEE Long Island (pp. 1-6). IEEE.

IBM Watson Analytics. (2017). Ibm.com. Retrieved 17 May 2017, from https://www.ibm.com/in-en/marketplace/watson-analytics

Isik, Ö., Jones, M. C., & Sidorova, A. (2013). Business intelligence success: The roles of BI capabilities and decision environments. Information & Management, 50(1), 13-23.

Laursen, G. H., & Thorlund, J. (2016). Business analytics for managers: Taking business intelligence beyond reporting. John Wiley & Sons.

Lessard, L., & Eric, S. K. (2014). Value Cocreation Modeling: Supporting the Analysis and Design of B2B Service Engagements through Agent Orientation and Business Intelligence. In iStar.

Marín-Ortega, P. M., Dmitriyev, V., Abilov, M., & Gómez, J. M. (2014). ELTA: New Approach in Designing Business Intelligence Solutions in Era of Big Data. Procedia Technology, 16, 667-674.

Maté, A., Trujillo, J., García, F., Serrano, M., & Piattini, M. (2016). Empowering global software development with business intelligence. Information and Software Technology, 76, 81-91.

Al-Tmeemy, S. M. H. M., Abdul-Rahman, H., & Harun, Z. (2011). Future criteria for success of building projects in Malaysia. International Journal of Project Management, 29(3), 337-348.

Parvan, K. (2012). Estimating the impact of Building Information Modeling (BIM) utilization on building project performance (Doctoral dissertation).