BUSN 6251 Notes

o Data o Format o Formulas  ISO 8601 codified standard o Date format = YYYY-MM-DD o All dates MUST spell out the month  No hard coding constants in formulas  Everything after the “=” sign MUST be a cell reference  Press <CRTL>~ to show formulas  Use style sheets for consistent formatting  Use sperate sheets to group similar kinds of information  Assumptions, calculations and results should be on sperate sheets o Link them together  Check formatting o Use error traps with IF statements or validation o Green error in cell means check error warning  Reduce the amount of new formulas or things into a spreadsheet, by putting in $ signs, copying formulas, etc.  Use blocks or modularize your spreadsheets  Never hardcode numbers in formula The Tao of Excel  Tao o Simplicity o Traceability o Consistency o Adaptability o Ease of use  Document must be printable  Leverage standard templates  Formate the spreadsheet o Title and description of workbook is located in upper left corner o Name spreadsheeted tabs o Remove gridlines o Always save workbook with A1 as the active cell o Print format must be printer ready o Clear cell labels o Format all work as numbers o Never hide columns or rows, group them instead o Create hyper link for footnotes  Use formula whenever you can  Separate the data

o Plot each of Bob's three controllable or decision variables and use their respective slopes to inform your recommendations. o Produce a two-way data table to inform your final recommendations.  The WHY? o We need to help Bob determine when he should retire  The WHAT? o We will build model and create a video presentation for Bob  The HOW? o Using excel  The GOAL? o Create movie o 4 min 30 seconds – max 5 min 30 seconds o Must have slides  Slide 1  Title slide  Name  Date  Whatever info you want  First impressions are important  Slide 2  Must be assumptions and data  Summarize assumptions you made  Insights into data used that drive the model  Last Slide  Summary and recommendations to Bob Module 6: Simulation—A Framework for Analyzing Risk  Risk is the potential loss of unintentional outcome o Uncertainty of the future  Risk analysis o Step one  Estimate the risk  The risk value = probability of event x cost that it happens o Step 2  Identify threats  Human  Operational  Reputational

AHP  Identify goal  Identify criteria  Identifty alternatives  Calculate results & determine relative importance Data Envelope Analysis (DEA)  Determines the most efficient  Relative ranking  How does it work o Identify the inputs o Identify the outputs o Outcome of DEA model Module 11: Dashboards & Visualizations  Why are visualizations so important? COMMUNICATION  to provide real-time visualizations of a variety of key performance indicators (KPIs) on their journey in monitoring and improving their performance. Dashboards consolidate a series of visuals. These allow you to quickly see what you are doing right and where you need to improve  They can be helpful anytime you want to: o Provide a quick overview of a topic. o Explain a complex process. o Display research findings or survey data. o Compare and contrast multiple options. o Raise awareness about an issue or cause.  Marketers use infographics to build brand awareness and boost engagement.  A data dashboard is an information management tool that visually tracks, analyzes, and displays key performance indicators (KPIs), metrics, and key data points to monitor the health of a business, department, or specific process.  Data-driven dashboards replace traditional reports, and if connected to live data they will be real-time snapshots of a company's financial health.