Big data and analysis
ITECH3000 Big Data Analysis Report Presentation ITECH1103 Big Data Analysis Report Presentation Jessica Colantuono & Robert Andersen BACKGROUND Why Is Analysis Important? Analysis is important for every business/firm/corporation To increase productivity and, therefore, revenue Gain valuable business insights Uphold reputation Remain competitive Improve overall operations IMPORTANCE OF ANALYSIS TO SAN FRANCISCO FIRE DEPARTMENT Dealing with the lives of people Continual operational improvement is paramount Image reteieved from: https://twitter.com/sffdpio ANALYSIS & RECOMMENDATIONS Call Type, Number of Calls and Call Time: (Top and bottom three call types) ANALYSIS & RECOMMENDATIONS Call Type, Number of Calls and Call Time: Majority of calls are within the Medical Incident call type Cut down call time Have operators review the questions they ask Training within certain primary actions in accordance with the primary situation (chart next slide) ANALYSIS & RECOMMENDATIONS Call Type, Number of Calls and Call Time: (Primary Action Taken in order of the Primary Situation) ANALYSIS & RECOMMENDATIONS Resource & Time Management: (Number of Calls during the week) (Calls During the Day VS at Night) ANALYSIS & RECOMMENDATIONS Resource & Time Management: Higher number of staff during the date time shift, especially for Saturdays during the day is needed ANALYSIS & RECOMMENDATIONS Neighbourhood Focus: (Number of legitimate calls) (Number of Calls Overall) Tenderloin Lincoln Park ANALYSIS & RECOMMENDATIONS Neighbourhood Focus: ANALYSIS & RECOMMENDATIONS Neighbourhood Focus: ‘Tenderloin’ with most calls overall Lincoln Park with least number of calls (low priority) ‘Tenderloin’ with most legitimate calls (high priority) ‘None’ area has most false alarms ‘Mission’ area with most false alarms that has an identified area (‘None’ is assumed to be unidentified areas) ANALYSIS & RECOMMENDATIONS Neighbourhood Focus: Investigation why ‘Tenderloin’ has such a high number of calls and how to minimise this number Ensure operators are identifying the area of calls, especially those that are false alarms Educating the ‘Tenderloin’ and ‘Mission’ area in regard to fire safety Revaluate the penalty fees for false alarms under the San Francisco Fire Department code ANALYSIS & RECOMMENDATIONS Battalion Dispatch Time: (Battalion Dispatch Time for Non-Life-Threatening & Life-Threatening calls) (Average Dispatch Time by Battalion) ANALYSIS & RECOMMENDATIONS Battalion Dispatch Time: B99 with slowest average dispatch time B04 with fastest average dispatch time B100 has no calls Review processes and training levels of B99 and take advice from B04 to improve dispatch time for B99 B100 may be an inactive battalion or there may be an error in the data, which needs to be amended SUMMARY Call Type, Number of Calls and Call Time Large number of medical incidents Reduce call time Resource & Time Management Better use of time and resources based on the needs of the City More insight as to where funding for training and equipment should be allocated SUMMARY Neighbourhood Focus Some neighbourhoods have a higher need for services Further Fire Safety education required for particular areas Battalion Dispatch Time Average dispatch time between battalions differs Battalions can learn from each other to improve operations REFERENCES San Francisco Data. (2017). Fire Department Calls for Service | DataSF | City and County of San Francisco. [online] Available at: https://data.sfgov.org/Public-Safety/Fire-Department-Calls-for-Service/nuek-vuh3/data [Accessed 2 Oct. 2017]. San Francisco Fire Department Display Photo. (2010). Retrieved from https://twitter.com/sffdpio 1 Overview of BI Solution Developed for Walton Supermarket Jane McCarthy, 2015 TABLE OF CONTENTS SECTION PAGE 1. BACKGROUND AND PROJECT OBJECTIVES (done by Jane McCarthy) ………….…… ........... 2 2. SOLUTION OVERVIEW (done by Jane McCarthy) ……………………………….……. .................... 2 3. TECHNOLOGY SELECTED (done by Jane McCarthy) ……………….…… .................................. 3 4. SOLUTION DETAILS (done by Jane McCarthy) ………………….....................…… ................. 4 • Dashboards • Executive Dashboard • Sales Dashboard • Marketing Dashboard • Analytical Exploration Tool 5. INSIGHTS AND RECOMMENDATIONS (done by Jane McCarthy) .............…… ........... 11 6. LIST OF REFERENCES (done by Jane McCarthy) …………………....................…… .............. 16 2 BACKGROUND AND PROJECT OBJECTIVES Walton Supermarket recently engaged McCarthy BI Solutions (MBI) to design and deliver a Business Intelligence (BI) Solution to help the company drive performance uplift. This report provides detail of the solution developed along with some recommendations based on analysis of spend by Walton’s loyalty customers over the last 3 years. Walton Supermarket (Walton’s) is a large supermarket chain based in the USA, with retail operations extending to Canada and Mexico. Walton’s have a retail presence in a total of 33 cities across the three countries. Walton’s is currently facing a number of sales challenges driven by intense competition from companies like Aldi. Historically, Walton’s has enjoyed strong growth and impressive market share, but the economic climate has given budget-oriented supermarket chains a competitive edge. In order to maintain market share and ensure continued growth in this competitive environment, Walton’s must now develop new strategies. Walton’s recognise that an effective BI solution is a strategic imperative to help inform future strategies. It would allow them to maintain clear line of sight of business performance, risks and opportunities, and to enable timely, targeted action to achieve business objectives. MBI has therefore been engaged to deliver a BI solution to support this. Walton’s have outlined a number of key objectives for the BI solution, specifically: • To provide Walton’s Executive Team with visibility of sales trends and business performance across all Walton Supermarket stores • To provide insight into performance drivers and opportunities to improve business outcomes • To provide insight into Walton Supermarket customers and their buying behaviour • To inform strategic decisions to drive performance uplift SOLUTION OVERVIEW MBI have adhered to best practices in the design and development of a BI solution that will address Walton’s key current challenges, as well as enable continued enhancements and expansion over time to ensure sustainable and scalable value generation. The solution will enable data-driven decision-making to improve business outcomes by providing the right information to the right people at the right time and in the right way. Walton’s, like any large organisation, comprises a diverse range of stakeholders with different information needs. In order to ensure the right information is provided to each of these stakeholders in the right way, MBI has developed a multifaceted solution that aligns to the needs of each individual stakeholder and user group. MBI identified four key stakeholder groups requiring BI capability across the Walton’s organisation: 1. Senior Executives 2. Marketing 3. Sales Teams 4. Product Functions 3 MBI consulted with representatives from each of these areas to understand their key business objectives and how they preferred to consume information. A tailored BI solution was then developed for each group. With the new capability, users in each stakeholder group will have ready access to the information that is most important to their specific business objectives, enabling them to monitor performance and make data-driven decisions to improve future outcomes. The overall BI solution comprises four key elements, which in combination deliver a best practice BI capability that will enable Walton’s to mitigate risks from competitors, drive performance uplift and meet business targets. A summary of the elements of the solution and the key audiences for each is provided in Table 1. More detail about the purpose and content of each element can be found in the ‘Solution Detail’ section of this report. Solution Purpose Key Audience(s) Executive Dashboard At a glance snapshot of business performance, providing visibility of areas of over and under performance and enabling informed strategic decision- making • Walton’s Executive Team Sales Dashboard Provide visibility of sales performance and trends by location and product. Enable drill-down to investigate performance within specific geographies and product categories • Sales Executives • Store Managers • Product Managers Marketing Dashboard Provide visibility of performance by customer segment, informing marketing activity and promotional offers • Marketing Executives • Marketing Teams • Sales Functions • Product Managers Data Discovery Tool Enable ad-hoc data discovery by power users to answer key business questions and inform strategic decisions • BI team • Marketing • Product Functions Table 1: BI Solution Overview TECHOLOGY SELECTED The BI solution has been developed using IBM Watson Analytics (Watson). Watson was selected after careful assessment against a number of key requirements developed by MBI in collaboration with Walton’s Executive and Technology teams. As shown in table 2, Watson satisfied all key assessment criteria making it a suitable choice for Walton’s BI capability. 4 Criteria Assessment Notes Ease of implementation Cloud-based solution enables easy and rapid implementation Low cost $80 per user is significantly cheaper than alternative BI tools Mobile capability Dashboards and analytical tools are accessible via desktop and mobile devices with no extra development required, ensuring data is available when and where users need it Ease of use Intuitive interface ensures even users with no background in data or analysis will be able to use the capability with minimal training Scalability Cloud-based solution can be scaled across the organisation Speed to insight Cognitive analytical capability delivers insight within minutes of loading a dataset Future proof IBM are continuously rolling out enhancements which will ensure Walton’s can continue to evolve the BI capability over time Table 2: BI Capability Scorecard used to assess suitability of Watson Analytics SOLUTION DETAILS Dashboards To cater for senior executives and leaders of Walton’s marketing, sales and product functions, MBI have developed a set of dashboards as a key part of the total BI solution. According to Gartner, a leading information technology research and