PROJECT PROGRESS REPORT TITLE: BUSINESS IMPROVEMENT PLAN/DATA ANALYTICS FOR VISTA CONCEPT DIMENSIONS CLIENT: VISTA CONCEPT DIMINISIONS PROJECT SUPERVISOR: Dr. NAGA DASARI Team Name: CONCEPT SQUAD Student Name Student ID BOBBILI SAI KUMAR REDDY 30308581 JAYKUMAR PATEL 30320385 HIRAL PATEL 30319689 NARSIMHA REDDY NUKALA 30311066 TABLE OF CONTENTS: Project Background Client Introduction Client Requirements Stakeholder Analysis Project Goals Feasibility study Methodology Standards Tools Communication, Change and Risk Management Plan SWOT Analysis Gap Analysis Project Milestones References CLIENT INTRODUCTION: VISTA CONCEPT DIMENSIONS Client Name: Ashutosh Vadnere Client Email: [email protected] Client mobile No: 0421769253 PROJECT BACKGROUND: ⦁ 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. CLIENT 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. Meeting regulatory requirements: 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). Tracking Data and Documents: 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; Billing options: Keep tracking of billing 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. HIGH LEVEL REQUIREMENT 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. Vista company want to change business process as Update automated way 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 STAKEHOLDER ANALYSIS: 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 PROJECT GOALS: The data situated in various records it is hard to keep up information connections and to recover information in the present frame. The vision of the venture is to coordinate the information and make it less demanding for the customer to recover without investing much energy and exertion. The use of BI tool helps to deal with the business forms and give administrations to the client in brief period which is useful in sparing time. Business handle reengineering with the assistance of business intelligence can help him to enhance execution supportability and kill ineffective exercises and in addition diminish costs. BUSINESS PROCESS ANALYSIS: ⦁ Maintain quality services and recommending potential optimization. ⦁ The current problem is time take in order to organize and retrieve files. ⦁ Conducting periodic reviews to ensure consistent value delivery. ⦁ Redesigning business procedure to enhance general organization effectiveness. BUSINESS PROCESS REENGINEERING: ⦁ Enhancing the present business handle by prescribing business intelligence tool. ⦁ Use of IT by construction firms leading to improvements in coordination. ⦁ Designing and facilitating of a series of intervention. ⦁ Developing of the principal business prepare models for the work process of the development extend. ⦁ Providing a basic quality considering and focusing of business towards powerful and long term arrangement. DASHBOARDS: ⦁ Dashboards have become a standard business displaying information about the entire client project data. ⦁ Dashboard is the information management tool which is use to track the data of business. ⦁ Displaying the overall multiple view of construction projects. ⦁ Providing a high level broad and long term view of performance. FEASIBILITY STUDY: PROJECT DESCRIPTION: 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 METHODOLOGY: The methodology is the common research strategy that includes the way in which implementation to be undertaken and there are various methodologies in order to gather and analyze the data. The foundation for all our research solution involves a through and proven, step methodologies besides review articles published in magazines and on web and discuss professional. REQUIREMENTS GATHERING: ⦁ 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. STANDARDS: 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 IBMWATSON ANALYTICS 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. 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. JUSTIFICATION FOR SELECTION OF THE TOOL: 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. WATSON ANALYTICS OFFERINGS: 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 PREPARATION: 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: 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. CLOUD BASED SERVICE: 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: ⦁ 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. PENTAHO FEATURES: ⦁ 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: BUSINESS ANALYTICS: 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, CHANGE AND RISK MANAGEMENT PLAN 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 SWOT ANALYSIS: 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 GAP ANALYSIS: 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. PROJECT MILESTONES: 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                       GANTT CHART: 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).