Transcript: Presented by Leticia Ramos Introduction Objective This dashboard was made to show results of an IVR (Interactive voice response) operation on an Call Center Data science is an interdisciplinary field that uses scientific methods, processes, algorithms and systems to extract knowledge and insights from data in various forms, both structured and unstructured. Data science is a "concept to unify statistics, data analysis, machine learning and their related methods" in order to "understand and analyze actual phenomena" with data. It employs techniques and theories drawn from many fields within the context of mathematics, statistics, information science, and computer science. Database A database is an organized collection of data, stored and accessed electronically. Database designers typically organize the data to model aspects of reality in a way that supports processes requiring information. A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. (Sometimes a DBMS is loosely referred to as a "database".) A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases. A database is generally stored in a DBMS-specific format which is not portable, but different DBMSs can share data by using standards such as SQL and ODBC or JDBC. Dashboard A dashboard is an information management tool that visually tracks, analyzes and displays key performance indicators (KPI), metrics and key data points to monitor the health of a business, department or specific process. They are customizable to meet the specific needs of a department and company. Behind the scenes, a dashboard connects to your files, attachments, services and API’s, but on the surface displays all this data in the form of tables, line charts, bar charts and gauges. A data dashboard is the most efficient way to track multiple data sources because it provides a central location for businesses to monitor and analyze performance. Real-time monitoring reduces the hours of analyzing and long line of communication that previously challenged businesses. Programming language A programming language is a set of commands, instructions, and other syntax use to create a software program. Languages that programmers use to write code are called "high-level languages." This code can be compiled into a "low-level language," which is recognized directly by the computer hardware. Data scientist A person employed to analyze and interpret complex digital data, such as the usage statistics of a website, especially in order to assist a business in its decision-making. Python is an interpreted high-level programming language for general-purpose programming. Created by Guido van Rossum and first released in 1991, Python has a design philosophy that emphasizes code readability, notably using significant whitespace. We start with a date treatment, the process of this treatment clear all the accumulated data every first day of the month, that’s because the dashboard was made to show monthly results of an IVR (Interactive voice response) operation. Keywords in Python programming language We cannot use a keyword as variable name, function name or any other identifier. They are used to define the syntax and structure of the Python language. In Python, keywords are case sensitive. There are 33 keywords in Python 3.3. This number can vary slightly in course of time. All the keywords except True, False and None are in lowercase and they must be written as it is. After that we create a function that we can identify on the code beginning with the reserved word def, this function treat a specifically field on our available data that came in seconds, as we can see we use “format” to return this seconds in a structure that is more pleasing to the human eyes and easier to understand without mathematical calculations. We also created a def to remove outliers, means the values that take of the values that is out of the line, like too big and little values. The next def returns the quantity of head count, the number of agents that are logged on the platform To measure and sum all the data available, we perform a query to the CASSANDRA database, also within a function. We define dictionaries where we will store the totals returned from the query and call the function created data_date, storing it in a single variable we start to scan the result of this variable with a loop "FOR"and store the contents separately in new variables we add the totals returned in each dictionary previously defined with the "setdefault" method In this part of the code we access the totals of each setdefault and separate them to fill in all the boxes We do the same with the data from the screw chart And finally, in the variable "data", we leave everything in a dictionary accessible for the front end to work with the data at the time of creating the dashboard A bit of
Transcript: • "Logi Info has been a game-changing platform for us. I was able to create cohesive app and we now have happier customers and are delivering more product." Brian Hanley, Sr. Applications Programmer, Gopher Resource Case Study & Live Demo Welcome Why Business Intelligence? Why Logi Analytics? Case Study & Live Demo Questions Why Logi Analytics? What will you create? Easily access any type of data (Database, XML file) No complex data models Reduce time and effort Why BI? No per user fees Flexible licensing model for unlimited end users and for all deployment needs Offer a free, 15-day, fully functional trial license for new users Unified platform allows all components work together seamlessly Easy to maintain and manage even the most advanced BI projects Connect to Any Data Source The New York Mets executive team is in need of a dashboard analytics solution to better understand merchandise sales around the country. In addition, they would like to focus on the top selling products and customer demographics to develop a promotional campaign to increase sales. Our Customers Love Us! Users can start building dashboards and reports in days Code-free way to create dashboards and reports Eliminate Guesswork Historical Data, Real Time Data Accurate Forecast Quickly Identify Trends Excel Spreadsheets are obsolete find outliers within seconds Improve Efficiency/Streamline Operations Do more with less Higher productivity + Reduce Costs=Success! Fast & Easy to Use Great Value Pain Points All reports are in excel today. Static reports with no interactivity. Need better visuals Ease of use Self Service From www.logianalytics.com Questions? Easy to Manage Fast and Easy to Use Connect to Any Data Source Great Value Easy to Manage Our Customers Love Us! Agenda
Transcript: Q1: Retirement Hot Topics objectives Phase III marketing opportunities X Top tier 50% Key trades 4 Tweets audiences measurables Phase II What are the key takeaways? What is the purpose of this media initiative? What are the results? key messages How will we measure success? When does the initiative begin? How does this news align with the marketing strategy? results Phase I Who is the intended audience(s)? PR Checklist
Transcript: 2011 2012 2013 "3,441 families are still waiting for affordable childcare in your community..." 1) Cleanliness of my room 2) Availability and helpfulness of the Food Services Staff is: 3) Do you feel safe in the home? "I feel safe" 96% 98% Long Term Care and Services for Seniors Division Resident Satisfaction Ratings (2011) Right now.....over 3,400 families with children are financially relying on Ontario Works in your community. 93% The Digital Dashboard Overall Rating: Social Services Department Using data to tell stories.... Income and Employment Support Division Social Services Department
Transcript: Present Solve All Problem by EmpowerU Present user name password user name password user name password You can find which school in problem user name password
Transcript: Vision 2020 Know-How Rework of Intranet Search functionality Know-How system Milestones this period : Budget approval for pilot Milestones next period : Scope and approach for pilot agreed Workflow Upgrade Milestones this period : Function Booking Form (FBF) development complete New production environment installed Milestones next period : FBF live CMI workflow analysis complete Desktop Upgrade Milestones this period : Exchange Design and Migration plan agreed Exchange Hardware installed in NY and NH Test extract of archive email for import to Mimecast Windows 8 requirements document issued Microsoft licence agreement Milestones next period : Mimecast Import Windows 8 design agreed Exchange pilot / live in NY Office and Data Centre Moves New Haven : Delayed - date tbc Reworking plans to use an off-site data centre Would allow equipment already ordered for the move to be installed and used now Hong Kong : Will be before NH move. ( September ? ) Equipment to be moved to an off-site data centre in advance EU Data Centre : Agreeing contract with preferred supplier Network design agreed Project managers appointed yuiop Design & Build May Optimises traffic and provides security Pilot Oct Apr The VDI design …. Aug Links user to their desktop and applications Design & Build Each work stream has a full requirements/design cycle – no assumptions Exchange upgrade – straightforward technology upgrade to latest version, taking opportunity to move from Enterprise Vault to Mimecast Desktop upgrade – likely to be far more radical, with heavy use of VDI ( next slide) Remote access – a variant of the desktop Lync 2013 – at early design stage, but again, likely to use VDI Deploy chosen consultants could not start for 4 weeks + mimecast deliberation Feb average per day orange line = oustanding/backlog much of backlog are bookings / service requests / new joiners we don't 'feel' as busy as last summer Testing All Applications (200+) Project Aims / benefits ( all from the PID ) Resources and approach - Technology 2013 The Desktop Upgrade Project consists of several work streams Replacing Windows XP with Windows 8 Replacing Office 2003 with Office 2013 Testing and Replacing all other Applications Replacing Remote Access System Replacing the Email System and Introducing Mimecast Archiving Implementing Lync 2013 Sept in the data centre Jun Aim : we use lots of metrics to manage ourselves to report some of those metrics to a wider audience to give a better understanding of what we are doing to make us more accountable to get ideas on what you might want reported / find interesting Agenda : projects services resources Deploy Service As now – databases and fileshares Design & Build in the data centre Design & Upgrade to Office 2013 Implement Lync 2013 Upgrade Remote Access user device ( PC) A 'Major Incident' is a service failure that impacts users (even if it is just one or two) MIs reflect the age of our systems, their complexity and how well we run them We want to drive down MIs and to do this we concentrate on understanding what caused the problem - and doing something about it Improved PC boot times and login times, Improved performance of Outlook and FileSite, where possible, Improved desktop stability, including improvements in the configuration and reliability of user profiles, Most common issues on current Snag List to be addressed, where possible, Consistent user experience in “home” offices, when travelling to other offices, and when working remotely, Clear and streamlined process with better performance for visitors logging on in remote offices, Faster turnaround for the rebuild of PCs and installation of applications through reduced imaging time and minimal manual intervention, Location aware printing, such that the default printer is automatically detected based on the physical location of the PC, thereby avoiding issues with users printing to their “home” office printer when working in an alternative location, Fully supported versions of the desktop operating system, Microsoft Office applications and back-end email (Exchange) infrastructure. Deployment of Lync 2013 unified communication platform and the adoption of Instant Messaging and Presence as business tools. Mar Sketches Projects started to include US stats Deploy Workstreams IT department - dashboard Management of resources Deploy IT Projects a bit hard to track / average Martin H left 'lost' Craig W to Windows project took a while to get backfill About to get a second student Runs the desktop or application Stores the desktop and application Pilot Jul Design & Build BTT 2014 Test & Upgrade global training stats : peaks during rollouts currently ~ 2.5 trainers lots of 1:1 training expenditure against budget Upgrade Email to Exchange 2010 Timescales User device - Runs Citrix receiver Nov Deploy Design & Build Vision 2020 filesite rollout 16 OB power outage New Haven Move Whitehill billing replacement SCCM software distribution (IT) Concep electronic mailshots user
Transcript: Dashboard Overview CLOUD PLATFORM REAL TIME GRAPH CHART 01. 02. Units Time(Hourly) 00.00 01.00 DAILY MONTHLY Units DAYs Day 1 Day 31 AMOUNT OF SALES HISTORICAL DATA PER DAY Amount Of Sales /Day 01/01/2018 12/01/2018 DD/MM/YYYY Drink 1 Drink 2 Drink 3 Total PER MONTH Amount Of Sales /Month 01/2018 MM/YYYY Drink 1 Drink 2 Drink 3 Total MACHINE'S STATUS MACHINE'S STATUS Temp Set point Water Temp Status Water Level Status WATER CUP STATUS CUPS CUP User Input Button Reset To Max Price Per Cup POWDER POWDER STATUS Powder 1 Powder 2 Powder 3 RECIPES RECIPES Button : Switch Recipes
Transcript: Yearly Report Components If this spreadsheet is needed, it is available This spreadsheet is used to show the same core stats but for positions instead of pages. This will highlight key positions in a page that the presenter may want to bring attention to. This graph doesn’t always have to show depressing numbers and can also show positives when a page dramatically improves in performance due to key positions. Monthly Spreadsheet Part 1 Viewability Dashboard Template Suggestion Yearly Spreadsheet for overall site | Spreadsheet can be used for Individual Pages Overall What can we get from this spreadsheet? The stats shown here are stats we have great influence in. The data presented in this spreadsheet can be pulled from Viewability Diagnostic Metric. Analyzing these data and seeing its year long trend can show us when our site performed at its best, or when our site performed sub par. Because These data are at a lower level, we may need an adviser from a viewability expert to advice us on what is the best course of action. The excel spreadsheets made for this report have two levels in the monthly reports and two levels in the yearly reports The Monthly reports focus on Page specifics (1st chart) and Position specifics (2nd chart). The Yearly reports focus on Overall performance and Page performance over the past 12 months. Which is important in looking at trends for that year. These are the things that I think is Important to note in the higher level monthly and yearly. This will highlight overall site and page performance over the year which is helpful to see when and where things go right and or wrong in the larger scheme. Monthly Spreadsheet Part 2 Kim Brian Fadul At the very top level we can see the most important things. Impressions, In-view rate and MOAT score. We do not cover a lower level at this point for it is not always necessary. MOAT change highlights the change in performance from the previous month. Depending on the severity of the change, a second spreadsheet can be pulled.
Description: For grant requests, funding pitches, program proposals, or any other kind of education or nonprofit presentation, this Prezi template is the way to generate interest and momentum. Like all Prezi education templates and Prezi nonprofit templates, it’s easily customizable.
Description: Impactful presentations need stunning visuals and a meaningful metaphor to show high-level concepts and the smaller details. This customizable presentation template uses a classic world map visual to help you navigate complex information while staying grounded in your presentation’s core message.
Description: How do you stand out from the stacks of resumes on your prospective employer’s desk? With a Prezi resume template, of course! Create your own “Prezume” and and impress them with your cutting-edge dynamism and cool. All Prezi presentation templates are easy to customize.
Now you can make any subject more engaging and memorable