Transcript: WELCOME Beta Metrics Dashboard Webinar Role Call Matthew Heilman Implementation Consultant L & D WELCOME To review,analyze and learn best practices using the new Metrics Dashboard Tabs GOAL WHAT IS IT? The new Metrics Dashboard is for portal administrators. This new data hub will display vital information to help you maintain a functioning mentoring portal. WHAT IS IT? You have always had access to a wealth of information found in your mentoring portal. The new Metrics Dashboard offers all of this information in one, tab-organized spot. Instead of having to run and create multiple reports, you can now quickly glide through pertinent and relevant data to have a more informed understanding of your mentoring portal. BUT...WHY? THE WIDGETS Mentoring Activity Goals Login and Registration Profiles Messages THE WIDGETS NEXT STEPS NEXT STEPS Review your tabs Identify if anything is an issue Meet with your account manager for further discussion/feedback
Transcript: Wong Li Ong 22791 BIS Agilent Technologies LDA SIP Presentation SIP Presentation Wong Li Ong BIS 22791 Introduction Project Titles Project Some of the projects I have done ATP Report (Automation) Dashboard Automation System ATP Report Automation Auto pull data from SAP Auto Send email to specific recipient CRDD Pre-Alert Report CRDD Pre-Alert Report Auto pull data from SAP CRDD Tools CRDD Tool Automated converting of Excel Charts to PowerPoint Dashboard Automation System Help users to create the dashboard My SIP My Project Dashboard Automation System Problem Statement THE PROBLEM Don't have visualization platform Time-consuming Difficulties in root cause analysis Objectives Objectives Data Visualization Acts an performance and metrics tracker (KPI) To track the trend and plan for forecast Example of Dashboard in Excel Methodology Waterfall Model Requirements Gathering Step 1: Requirements Gathering Discuss with my buddy about the necessary requirements of a dashboard Self-learning to explore the function of a dashboard that used for analysis purpose Design Automation template Step 2: Design of Automation Template This automation template enable users to create dashboard based on their data sources Automation Template Implementation #1 #2 #3 Step 3: Implementation Working File Pulling data from SAP Dashboard Automation System Phases Phases of this System Phase 1 Phase 1: Data Source Pull data from SAP(Automation) Matching data from different files Raw Data ready for creating dashboard Data from SAP Data match from different file Phase 2 Phase 2: Dashboad Designing Enable users to create 2 dashboard Enable users to choose number of charts and chart type Enable users to preview the chart type Insert Slicer for data filtering Dashboard Created Enable users to write the comment at the textbox provided Few buttons with function provided at the dashboard Automation Template Dashboard Page User Guidlines User Guidelines Step 1: Open workbook with data sources Step 2: Select number of charts Step 3: Select data fields & chart type Step 4: Select Slicer(Optional) Step 5: Press "Create dashboard" button Automation Template Dashboard Workbook Demo Demo Conclusion & Recommendation Conclusion & Recommendation Conlusion Conclusion What I have learnt? Improve my programming skills Supply Chain knowledge such as on time delivery and SAP function Data Analysis skills Impact of this System Improve the data visualization process Automated some process to minize the manual jobs & avoid human error enable users to track the KPI and historical performance Before VS After 10 minutes VS 30 seconds Non-standardized steps VS Standardized steps Not flexible VS Flexible Recommendation Recommendation Able to create combochart Able to refresh data with one click Working file automation Phase 3 (Big Data Connection) Interactive & Predictive Analysis Q & A
Transcript: huddle Mrs. Rossi huddle to crowd together crowd huddle separate
Transcript: Determine the drivers Report on each driver regularly Tweak the equation Find better fuel Find more efficiency Facilitate the right question Help decide what to predict Assist with data mining Help create an equation Interpret the drivers and weights Find dashboards that predict Tell the story What's the "one" thing? Analytics "They are asking all the wrong questions. And if I say it to anybody, I'm ostracized. I'm a leper. So that's why I'm cagey about this with you." This is where most attempts fall short Dependent Variable (what you're predicting) What data do you have? Where are you going? Part 1 “They are asking all the wrong questions.” Moneyball Flight Plan What data do you need? Analytics, Data Metrics & Dashboards A pilot cares about 4 or 5 gauges, the rest are there "just in case". Can I Help? What does the data tell you? The Right Fuel Monitoring If you know what to predict (dependent variable) then finding what beta weights that "drive" the equation is easy peasy..... BUT Where are you going? Where are you going? Part 2 Location So? If you had magic crystal ball, what would you most like to predict? What keeps you up at nite? What does your boss look at most closely? "People who run ball clubs, they think in terms of buying players. Your goal shouldn't be to buy players, your goal should be to buy wins. And in order to buy wins, you need to buy runs." Data Mining Dashboard Drivers (Dashboard Wannabes) Curly: Do you know what the secret of life is? Curly: This. Mitch: Your finger? Curly: One thing. Just one thing. You stick to that and the rest don't mean *$&%. Mitch: But, what is the "one thing?" Curly: That's what you have to find out. – City Slickers Summary Ask the right question Decide what you want to predict Find the best data to predict Find the right tool to predict Train the right data owners Create a good equation Make the dashboard Continually improve Tools Head count needed? Lifetime value? Customer satisfaction? Department value? Controlling spend? Understanding our customers? Processing the raw materials The Right Fuel If you can make a picture of the situation, then more people will understand. Tell the Story Tips to Get Started Start with your own gold Get a professional data geologist Find the right tools Process the data Flight Plan What's Your Mission? Focus on the data that affects your prediction with the weights provided by analysis Mind mapping Data visualization Graphical facilitation Thought maps
Transcript: headcount gender profile hierarchy structure leadership groups age profile etc Agree an approach Small team to design metric 1 F&A + 1 P&L owner from AUST and EMEA Initial test in Australia & EMEA Present approach to HRGC Adapt for Global context Aim for FY13 implementation value added per employee minus average cost per employee times workforce size (# of employees) Already measured globally Focus on robust numbers Alignment of definitions Roll into Seth's initiative Productivity People Productivity Quantify effort required to calculate new measure Test for so what Pilot usefulness as measure to improve productivity Report findings to HRGC An Example: Retention Foundational Metrics: Many approaches used globally Focus for this initiative Agree an approach Service Profit Chain as framework Kick off with 3 key metrics Use Global Mercer Measure Annual remeasure Add quarterly barometer measure One or two questions only Poll 1/4 of employees each quarter Circulate draft definitions for Voluntary Turnover measure by email for input Work wit hSeth to deploy globally Human Capital Dashboard Engagement + Retention Here is something small... Next Steps: Engagement: Human Capital Dashboard Predictive So... HRGC agree on quarterly measure Talk to India re: how to deploy quarterly measure 30 Next Steps: Productivity New metric Consider Boston Consulting Group "Workonomics" framework 3 levers of "people" productivity Isolate employee- generated revenue Engagement Foundational Use Turnover Measure 12mth voluntary rolling turnover Measured monthly Agree definition for "voluntary" Next Steps: Retention Service Profit Value Chain Predictive Metrics:
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: ...and don't spin too much. QUESTIONS? how will you react? Prezi Tutorial Add powerpoint slides if appropriate Melissa Nesbitt, solution engineer Executives Plan your story. Choose a template or create your own! ERP CRM BPC APO BW Other Systems Excel Data Reporting/Flexible Fast Views What-if Capability Capacity Planning Dashboard Metrics/Alerts Workflow Example Goals & Objectives Keep jumps short... Demand Planning Ad-Hoc Reporting & Dashboards Finance ad-hoc, real-time reporting leveraging SAP HANA Today's Agenda: what's the best decision? powered by SAP HANA sales and operations planning sharp, sudden increase in demand Supply Planning Introductions Company Goals & Challenges SAP S&OP Overview S&OP Demo --------------------------------------------- Prezi Tutorial Click anywhere to add text It makes people dizzy.
Transcript: Metrics Dashboards Question... Here's an example using web metrics Thanks for watching! ANY IDEAS??? Just like this! Answer... Andrew Shear Service Performance Metrics A dashboard focuses attention on the metrics that affect your company’s success. Managers do not have to weed through pages of unnecessary data that are not meaningful. (Why Use Dashboard Metrics, n.d.) Click the image for a closer look! Here is another example They are all together on a dashboard. This gives you the BIG PICTURE! This is exactly what a metrics dashboard does. References Metrics dashboard design [White paper]. (n.d.). Retrieved from PureShare website: http://www.pureshare.com/resources/ resource_files/pureshare_dashboard_design.pdf Why use dashboard metrics [White paper]. (n.d.). Retrieved from RKM Research & Communications website: http://www.rkm-research.com/downloads/Why-Dashboard.pdf "Good metrics dashboards show key performance indicators in context so that they are meaningful, and present them in a way that allows users to instantly understand the significance of the information." (Metrics Dashboard Design, n.d.) They all tell you how your car is functioning, but they don't give you a clear picture. Unless... Click the image for a closer look! Click the image for a closer look! What do you think the following have in common? A dashboard allows sharing of key information between different departments, or "one stop shopping". (Why Use Dashboard Metrics, n.d.)
Description: Add some color to your quarterly business review with this vibrant business presentation template. The bold visuals in this business template will make your next QBR a memorable one.
Description: The sky’s the limit. Boost your new sales initiative into orbit with an engaging and compelling SKO presentation. This template features a effective sales kickoff theme that makes it easy to be engaging. Like all Prezi SKO templates, it’s fully customizable with your own information.
Description: Catch the eye and engage the imagination with this cool-looking Prezi proposal template. The bold, bright design and highly dynamic theme all but guarantee success for your next sales or marketing proposal. All Prezi presentation templates are easily customized.
Now you can make any subject more engaging and memorable