The Art of Computer Modeling for Business Analytics


Book Description

Companies today routinely utilize computer models to help make decisions. These models take many forms, from simple spreadsheets to sophisticated computer simulations. The chief underlying reason for constructing a model is to assess the impact of a decision on business performance. Based on that assessment, model users will make recommendations and take actions. The tacit assumption is that the model captures the relevant factors at a sufficient level of detail to make accurate projections. The validity of the model thus depends on a host of judgments that the model builder makes in constructing the model—some transparent, others implicit. These judgments are what make building a computer model more of an art than a science. This book is about constructing and using computer models to help decision makers in the business world make more informed decisions. It is intended to provide useful case studies for individuals who are interested in building effective decision models—ones that will get used to drive important business decisions. The goal is to demonstrate how to build effective models quickly and inexpensively, using software that is widely available and often free. It is a practical guide, informed by the author’s experience building such models for an array of businesses in diverse industries.




Business Decision Making, Second Edition


Book Description

How do executives make decisions? Are their decisions conscious or unconscious? Can they explain each decision they make? What tools can they use to improve their decision-making process? These are some of the questions this book addresses. During the past 35 years, as an entrepreneur and senior executive of several medium-sized Canadian hi-tech businesses, the author noticed that his decision-making processes were often based either on experience or on advice received from colleagues. Seldom were the decisions based on formal or informal academic-based methods. There is no substitute for years of experience in any human endeavor. However, tapping into some of the methods and lessons learned from personal experience can result in useful principles for others to follow. These principles are very useful, especially for entrepreneurs interested in building their businesses or executives looking for some additional help in acquiring a better decision-making mousetrap.




Decision Analysis for Managers, Second Edition


Book Description

Everybody has to make decisions-they are unavoidable. However, we receive little or no education or training on how to make decisions. Business decisions are difficult: which people to hire, which product lines or facilities to expand, which proposal to accept, how much R&D to invest in, which environmental projects are high priority, etc. Personal decisions (college, getting married, changing jobs, buying a house, retiring, dealing with a health problem) can be even more difficult. This book gives you the tools you need toÉClarify and reach alignment on goals and objectives; Understand trade-offs associated with reaching those objectives; Develop and examine alternatives; Systematically analyze the effects of risk and uncertainty, and; Maximize the chances of achieving your goals. Success (getting what you want) depends on luck and good decision-making. You can't control your luck, but you can maximize your odds by making the best possible decisions, and this book gets you there. The author organizes and presents otherwise formal decision-making tools in an intuitively understandable fashion. The presentation is informal, but the concepts and tools are research-based and formally accepted. Whether you are a business owner, a manager or team leader, or a senior professional, these tools will help both your personal and your business life.




Conducting Survey Research


Book Description

Creating a powerful and impactful survey is no easy feat; even experienced survey researchers struggle to eliminate bias and create robust questionnaire designs. Through case studies, real-life examples, and multiple data visualization graphics, Conducting Survey Research offers a unique how to guide on creating a survey. Throughout its seven chapters, the text enables readers to build relevant, unbiased, and purposeful survey questions. The text highlights common mistakes in survey research (e.g., using the appropriate sample size and survey administration mode), and demonstrates how to interpret survey data and report findings. While numerous online survey platforms exist, the text reviews features of some of the most popular ones to help readers decide which best meet their needs. The world of survey research is extensive. While this text offers a great introduction to the survey research world, it only covers the tip of the iceberg. For those interested in delving deeper into the topic, JAF Associates offers onsite, on-demand, instructor-led, and self-paced learning modules covering the content of this text, and more.




Data Visualization, Volume I


Book Description

Data visualization involves graphical and visual tools used in data analysis and decision making. The emphasis in this book is on recent trends and applications of visualization tools using conventional and big data. These tools are widely used in data visualization and quality improvement to analyze, enhance, and improve the quality of products and services. Data visualization is an easy way to obtain a first look at the data visually. The book provides a collection of visual and graphical tools widely used to gain an insight into the data before applying more complex analysis. The focus is on the key application areas of these tools including business process improvement, business data analysis, health care, finance, manufacturing, engineering, process improvement, and Lean Six Sigma. The key areas of application include data and data analysis concepts, recent trends in data visualization and ÒBig Data,Ó widely used charts and graphs and their applications, analysis of the relationships between two or more variables graphically using scatterplots, bubble graphs, matrix plots, etc., data visualization with big data, computer applications and implementation of widely used graphical and visual tools, and computer instructions to create the graphics presented along with the data files.




An Introduction to Survey Research, Volume I


Book Description

Survey research is a powerful tool used in business, health care, government, and other fields that seek to understand how and why individuals behave the way they do. Properly conducted, surveys can provide accurate insights into areas such as attitudes, opinions, motivations, and values that serve as the drivers of individual behavior. This two-volume set is intended to introduce fundamentals of good survey research to students and practitioners of the survey process as well as end users of survey information. It describes key survey components needed to design, understand, and use surveys effectively and avoid the pitfalls stemming from bad survey construction and inappropriate methods. In this first volume, the authors concentrate on the fundamentals of survey development and design as well as provide a review of key components in survey.




MS Excel, Second Edition


Book Description

MS Excel is one of the most powerful tools available to a business manager. In this book, the author provides an advanced level of skill sets and brings actionable insights to the user. Hence, the material in this version has been organized as follows: Financial functions; Conditional math and statistical functions; Data analysis; Decision making; Data cleaning and use of macros; Auditors. The objective is to give readers a flavor of how the vast array of functions can be used to make life easier and more efficient. Amazing results can be achieved by mastering Excel at a basic level. Readers who execute the given functions on a workbook simultaneously and experience the journey will find the learning curve the steepest.




The Art of Computer Systems Performance Analysis


Book Description

Based on the author's experience in industry, this book focuses on simple techniques for solving everyday problems in systems design and analysis. All techniques are covered in a non-mathematical way, so that no statistics expertise is necessary.




MS Excel


Book Description

MS Excel: Let's advance to the Next Level is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. The author offers to make life easier for a data analyst, thus, it will be of relevance to students, academicians, the ones pursuing corporate careers as well as entrepreneurs preparing business plans for their startups. The book explains a wide array of complex functions, ranging from V-LOOKUP to MATCH/INDEX and pivot tables in very practical, simple, and implementable manner. The segments on conditional formatting and printing tricks will help the reader present the output to stakeholders in a more efficient manner. Do try the features Excel has on offer for controlling data input as well as creating checks and balances to ensure cell/sheet/file-level security.




Demand Prediction in Retail


Book Description

From data collection to evaluation and visualization of prediction results, this book provides a comprehensive overview of the process of predicting demand for retailers. Each step is illustrated with the relevant code and implementation details to demystify how historical data can be leveraged to predict future demand. The tools and methods presented can be applied to most retail settings, both online and brick-and-mortar, such as fashion, electronics, groceries, and furniture. This book is intended to help students in business analytics and data scientists better master how to leverage data for predicting demand in retail applications. It can also be used as a guide for supply chain practitioners who are interested in predicting demand. It enables readers to understand how to leverage data to predict future demand, how to clean and pre-process the data to make it suitable for predictive analytics, what the common caveats are in terms of implementation and how to assess prediction accuracy.