The technique of regression analysis is used so often in business and economics today that an understanding of its use is necessary for almost everyone engaged in the field. This book covers essential elements of building and understanding regression models in a business/economic context in an intuitive manner. The book provides a non-theoretical treatment that is accessible to readers with even a limited statistical background. This book describes exactly how regression models are developed and evaluated. The data used in the book are the kind of data managers are faced with in the real world. The book provides instructions and screen shots for using Microsoft Excel to build business/economic regression models. Upon completion, the reader will be able to interpret the output of the regression models and evaluate the models for accuracy and shortcomings.

Beginning R, Second Edition is a hands-on book showing how to use the R language, write and save R scripts, read in data files, and write custom statistical functions as well as use built in functions. This book shows the use of R in specific cases such as one-way ANOVA analysis, linear and logistic regression, data visualization, parallel processing, bootstrapping, and more. It takes a hands-on, example-based approach incorporating best practices with clear explanations of the statistics being done. It has been completely re-written since the first edition to make use of the latest packages and features in R version 3. R is a powerful open-source language and programming environment for statistics and has become the de facto standard for doing, teaching, and learning computational statistics. R is both an object-oriented language and a functional language that is easy to learn, easy to use, and completely free. A large community of dedicated R users and programmers provides an excellent source of R code, functions, and data sets, with a constantly evolving ecosystem of packages providing new functionality for data analysis. R has also become popular in commercial use at companies such as Microsoft, Google, and Oracle. Your investment in learning R is sure to pay off in the long term as R continues to grow into the go to language for data analysis and research.

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft’s Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps. While Beginning Big Data with Power BI and Excel 2013 covers prominent tools such as Hadoop and the NoSQL databases, it recognizes that most small and medium-sized businesses don’t have the Big Data processing needs of a Netflix, Target, or Facebook. Instead, it shows how to import data and use the self-service analytics available in Excel with Power BI. As you’ll see through the book’s numerous case examples, these tools—which you already know how to use—can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects. Through instruction, insight, advice, and case studies, Beginning Big Data with Power BI and Excel 2013 will show you how to: Import and mash up data from web pages, SQL and NoSQL databases, the Azure Marketplace and other sources. Tap into the analytical power of PivotTables and PivotCharts and develop relational data models to track trends and make predictions based on a wide range of data. Understand basic statistics and use Excel with PowerBI to do sophisticated statistical analysis—including identifying trends and correlations. Use SQL within Excel to do sophisticated queries across multiple tables, including NoSQL databases. Create complex formulas to solve real-world business problems using Data Analysis Expressions (DAX).

Compared to the speed and convenience of major web search engines, most business intelligence (BI) products are slow, stiff, and unresponsive. Business leaders today often wait days or weeks to get BI reports on inquiries about customers, products, or markets. But the latest BI products show that a significant change is taking place—a change led by search. This O’Reilly report examines three recent products with intelligent search capabilities: the ThoughtSpot Analytical Search Appliance, Microsoft’s Power BI service, and an offering from Adatao. You’ll learn how these products can provide you with answers and visualizations as quickly as questions come to mind. You’ll investigate: The convergence of BI and search What a search-driven user experience looks like The intelligence required for analytical search Data sources and their associated data modeling requirements Turning on-the-fly calculations into visualizations Applying enterprise scale and security to search

Mastering R has never been easier Picking up R can be tough, even for seasoned statisticians and data analysts. R For Dummies, 2nd Edition provides a quick and painless way to master all the R you'll ever need. Requiring no prior programming experience and packed with tons of practical examples, step-by-step exercises, and sample code, this friendly and accessible guide shows you how to know your way around lists, data frames, and other R data structures, while learning to interact with other programs, such as Microsoft Excel. You'll learn how to reshape and manipulate data, merge data sets, split and combine data, perform calculations on vectors and arrays, and so much more. R is an open source statistical environment and programming language that has become very popular in varied fields for the management and analysis of data. R provides a wide array of statistical and graphical techniques, and has become the standard among statisticians for software development and data analysis. R For Dummies, 2nd Edition takes the intimidation out of working with R and arms you with the knowledge and know-how to master the programming language of choice among statisticians and data analysts worldwide. Covers downloading, installing, and configuring R Includes tips for getting data in and out of R Offers advice on fitting regression models and ANOVA Provides helpful hints for working with graphics R For Dummies, 2nd Edition is an ideal introduction to R for complete beginners, as well as an excellent technical reference for experienced R programmers.

Master simple-to-complex techniques for transporting and managing data between SAS and Excel William Benjamin's Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently describes many of the options and methods that enable a SAS programmer to transport data between SAS and Excel. The book includes examples that all levels of SAS and Excel users can apply to their everyday programming tasks. Because the book makes no assumptions about the skill levels of either SAS or Excel users, it has a wide-ranging application, providing detailed instructions about how to apply the techniques shown. It contains sections that gather instructional and syntactical information together that are otherwise widely dispersed, and it provides detailed examples about how to apply the software to everyday applications. These examples enable novice users and power developers alike the chance to expand their capabilities and enhance their skillsets. By moving from simple-to-complex applications and examples, the layout of the book allows it to be used as both a training and a reference tool. Excel users and SAS programmers are presented with tools that will assist in the integration of SAS and Excel processes in order to automate reporting and programming interfaces. This enables programming staff to request their own reports or processes and, in turn, support a much larger community.

This second edition of Business Applications of Multiple Regression describes the use of the statistical procedure called multiple regression in business situations, including forecasting and understanding the relationships between variables. The book assumes a basic understanding of statistics but reviews correlation analysis and simple regression to prepare the reader to understand and use multiple regression. The techniques described in the book are illustrated using both Microsoft Excel and a professional statistical program. Along the way, several real-world data sets are analyzed in detail to better prepare the reader for working with actual data in a business environment. This book will be a useful guide to managers at all levels who need to understand and make decisions based on data analysis performed using multiple regression. It also provides the beginning analyst with the detailed understanding required to use multiple regression to analyze data sets.

Concise, thoroughly class-tested primer that features basic statistical concepts in the concepts in the context of analytics, resampling, and the bootstrap A uniquely developed presentation of key statistical topics, Introductory Statistics and Analytics: A Resampling Perspective provides an accessible approach to statistical analytics, resampling, and the bootstrap for readers with various levels of exposure to basic probability and statistics. Originally class-tested at one of the first online learning companies in the discipline, www.statistics.com, the book primarily focuses on applications of statistical concepts developed via resampling, with a background discussion of mathematical theory. This feature stresses statistical literacy and understanding, which demonstrates the fundamental basis for statistical inference and demystifies traditional formulas. The book begins with illustrations that have the essential statistical topics interwoven throughout before moving on to demonstrate the proper design of studies. Meeting all of the Guidelines for Assessment and Instruction in Statistics Education (GAISE) requirements for an introductory statistics course, Introductory Statistics and Analytics: A Resampling Perspective also includes: Over 300 "Try It Yourself" exercises and intermittent practice questions, which challenge readers at multiple levels to investigate and explore key statistical concepts Numerous interactive links designed to provide solutions to exercises and further information on crucial concepts Linkages that connect statistics to the rapidly growing field of data science Multiple discussions of various software systems, such as Microsoft Office Excel®, StatCrunch, and R, to develop and analyze data Areas of concern and/or contrasting points-of-view indicated through the use of "Caution" icons Introductory Statistics and Analytics: A Resampling Perspective is an excellent primary textbook for courses in preliminary statistics as well as a supplement for courses in upper-level statistics and related fields, such as biostatistics and econometrics. The book is also a general reference for readers interested in revisiting the value of statistics.

Related Content Even You Can Learn Statistics, Fourth Edition, is now available with new and expanded content. Thought you couldn’t learn statistics? You can – and you will! Even You Can Learn Statistics and Analytics, Third Edition is the practical, up-to-date introduction to statistics – for everyone! Now fully updated for "big data" analytics and the newest applications, it'll teach you all the statistical techniques you’ll need for finance, marketing, quality, science, social science, and more – one easy step at a time. Simple jargon-free explanations help you understand every technique, and extensive practical examples and worked problems give you all the hands-on practice you'll need. This edition contains more practical examples than ever – all updated for the newest versions of Microsoft Excel. You'll find downloadable practice files, templates, data sets, and sample models – including complete solutions you can put right to work! Learn how to do all this, and more: Apply statistical techniques to analyze huge data sets and transform them into valuable knowledge Construct and interpret statistical charts and tables with Excel or OpenOffice.org Calc 3 Work with mean, median, mode, standard deviation, Z scores, skewness, and other descriptive statistics Use probability and probability distributions Work with sampling distributions and confidence intervals Test hypotheses with Z, t, chi-square, ANOVA, and other techniques Perform powerful regression analysis and modeling Use multiple regression to develop models that contain several independent variables Master specific statistical techniques for quality and Six Sigma programs Hate math? No sweat. You’ll be amazed at how little you need. Like math? Optional "Equation Blackboard" sections reveal the mathematical foundations of statistics right before your eyes. If you need to understand, evaluate, or use statistics in business, academia, or anywhere else, this is the book you've been searching for!

When it comes to discovering glitches inherent in complex systems—be it a railway or banking, chemical production, medical, manufacturing, or inventory control system—developing a simulation of a system can identify problems with less time, effort, and disruption than it would take to employ the original. Advantageous to both academic and industrial practitioners, Discrete and Continuous Simulation: Theory and Practice offers a detailed view of simulation that is useful in several fields of study. This text concentrates on the simulation of complex systems, covering the basics in detail and exploring the diverse aspects, including continuous event simulation and optimization with simulation. It explores the connections between discrete and continuous simulation, and applies a specific focus to simulation in the supply chain and manufacturing field. It discusses the Monte Carlo simulation, which is the basic and traditional form of simulation. It addresses future trends and technologies for simulation, with particular emphasis given to .NET technologies and cloud computing, and proposes various simulation optimization algorithms from existing literature. Includes chapters on input modeling and hybrid simulation Introduces general probability theory Contains a chapter on Microsoft ® Excel ™ and MATLAB ®/Simulink ® Discusses various probability distributions required for simulation Describes essential random number generators Discrete and Continuous Simulation: Theory and Practice defines the simulation of complex systems. This text benefits academic researchers in industrial/manufacturing/systems engineering, computer sciences, operations research, and researchers in transportation, operations management, healthcare systems, and human–machine systems.

" Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren't going to be possible from just the GUI interface that is covered in most other books. You'll have full command of the GUI, and you'll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. " Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide introduces you to Microsoft's BI tools and systems. You'll gain hands-on experience building solutions that handle data warehousing, reporting, and predictive analytics. With step-by-step tutorials, you'll be equipped to transform data into actionable insights. What this Book will help me do Understand and implement multidimensional data models using SSAS and MDX. Write and use DAX queries and leverage SSAS tabular models effectively. Improve and maintain data integrity using MDS and DQS tools. Design and develop polished, insightful dashboards and reports using PerformancePoint, Power View, and SSRS. Explore advanced data analysis features, such as Power Query, Power Map, and basic data mining techniques. Author(s) Abolfazl Radgoudarzi and Reza Rad are experienced practitioners and educators in the field of business intelligence. They specialize in SQL Server BI technologies and have extensive careers helping organizations harness data for decision-making. Their approach combines clear explanations with practical examples, ensuring readers can effectively apply what they learn. Who is it for? This book is ideal for database developers, system analysts, and IT professionals looking to build strong foundations in Microsoft SQL Server's BI technologies. Beginners in business intelligence or data management will find the topics accessible. Intermediate practitioners will expand their ability to build complete BI solutions. It's designed for anyone eager to develop skills in data modeling, analysis, and visualization.

Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

Enhance your SAS ODS output with this collection of basic to novel ideas.

SAS Output Delivery System (ODS) expert Kevin D. Smith has compiled a cookbook-style collection of his top ODS tips and techniques to teach you how to bring your reports to a new level and inspire you to see ODS in a new light.

This collection of code techniques showcases some of the most interesting and unusual methods you can use to enhance your reports within the SAS Output Delivery System. It includes general ODS tips, as well as techniques for styles, enhancing tabular output, ODS HTML, ODS PDF, ODS Microsoft Excel destinations, and ODS DOCUMENT.

Smith offers tips based on his own extensive knowledge of ODS, as well as those inspired by questions that frequently come up in his interactions with SAS users. There are simple techniques for beginners who have a minimal amount of ODS knowledge and advanced tips for the more adventurous SAS user. Together, these helpful methods provide a strong foundation for your ODS development and inspiration for building on and creating new, even more advanced techniques on your own.

This book is part of the SAS Press program.

"Expert Cube Development with SSAS Multidimensional Models" is a comprehensive guide designed for professionals looking to elevate their competence in creating and optimizing SSAS cube solutions. Focused on the multidimensional model, this book provides a detailed, pragmatic approach to delivering high-performance Business Intelligence solutions. What this Book will help me do Master the core features of multidimensional modeling with SSAS. Develop efficient and scalable OLAP cubes for business analysis. Implement advanced calculations and measures using MDX. Optimize and troubleshoot SSAS performance for real-world scenarios. Integrate SSAS models for insightful data visualization. Author(s) The authors of this book are seasoned SSAS consultants and developers, each with years of hands-on experience working with Microsoft Analysis Services in enterprise environments. Their deep understanding of multidimensional modeling shines through in this detailed and well-structured book, providing readers with not only practical guidance but also invaluable tips drawn from real-world projects. Who is it for? This book is tailored for BI developers and data professionals who already have some familiarity with Microsoft Analysis Services and want to deepen their expertise in SSAS multidimensional models. It is ideal for those looking to enhance their ability to design, implement, and optimize robust cube solutions for complex business scenarios. With step-by-step tutorials, it caters to intermediate to advanced learners seeking to take their SSAS skills to the next level.

This book, "Microsoft Visio 2013 Business Process Diagramming and Validation," is your comprehensive guide to leveraging the features of Microsoft Visio 2013 Professional for creating and validating structured diagrams. Through practical tutorials and code examples, it helps you master process diagramming and validation techniques for a range of business needs. What this Book will help me do Understand and utilize structured diagram functionality including basic and cross-functional flowcharts. Develop and apply custom validation rules to ensure diagram correctness and compliance using Visio 2013. Create and use advanced tools such as the Rules Tools add-on to enhance diagram validation. Learn to integrate Visio with platforms like SharePoint 2013 and Office365. Gain technical skills to build, publish, and share Visio templates and rule sets. Author(s) The authors of this book bring rich technical expertise in Microsoft Visio and business process management. They have extensive experience developing user-focused tutorials and tools, ensuring you gain both theoretical knowledge and practical skills. Their accessible writing makes complex topics approachable for a variety of learners. Who is it for? This book is for Microsoft Visio 2013 Professional Edition users who want to advance their skills in diagramming and validation. It's ideal for professionals who seek to improve diagram compliance and efficiency, including developers, analysts, and project managers. If you're already familiar with Visio basics, this book will take your skills to the next level by introducing advanced techniques for automation and standardization.

Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful "Summary" that precede each chapter to look for help on a specific topic.

The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language using discussion and numerous real-world examples.

This book is part of the SAS Press program.

Now that people are aware that data can make the difference in an election or a business model, data science as an occupation is gaining ground. But how can you get started working in a wide-ranging, interdisciplinary field that’s so clouded in hype? This insightful book, based on Columbia University’s Introduction to Data Science class, tells you what you need to know. In many of these chapter-long lectures, data scientists from companies such as Google, Microsoft, and eBay share new algorithms, methods, and models by presenting case studies and the code they use. If you’re familiar with linear algebra, probability, and statistics, and have programming experience, this book is an ideal introduction to data science. Topics include: Statistical inference, exploratory data analysis, and the data science process Algorithms Spam filters, Naive Bayes, and data wrangling Logistic regression Financial modeling Recommendation engines and causality Data visualization Social networks and data journalism Data engineering, MapReduce, Pregel, and Hadoop Doing Data Science is collaboration between course instructor Rachel Schutt, Senior VP of Data Science at News Corp, and data science consultant Cathy O’Neil, a senior data scientist at Johnson Research Labs, who attended and blogged about the course.

Make the most of Visio 2013– without becoming a technical expert! This book is the fastest way to master Visio and use it to build powerful, useful diagrams, org charts, and flowcharts of all kinds! Even if you’ve never used Visio before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Visio has never, ever been this simple! Who knew how simple Visio 2013 could be? This is the easiest, most practical beginner’s guide to using Microsoft Visio 2013...simple, reliable instructions for doing everything you really want to do! Here’s a small sample of what you’ll learn: Master new tools for creating intuitive, visually appealing diagrams Learn high-efficiency touch features for Windows 8 and tablets Create business and engineering diagrams, flowcharts, maps, floor plans, network diagrams, schedules, and more Instantly set or change diagram designs with enhanced templates and themes Simplify diagramming with built-in shapes and stencils–or create your own Craft more sophisticated diagrams with containers, callouts, screentips, and layers Import external images, from SVG graphics to AutoCAD drawings Visually present Excel spreadsheet data in Visio drawings Dynamically update diagrams with real-time data to support better decision-making Share diagrams to improve team collaboration

The smart way to learn Microsoft Visio 2013—one step at a time! Experience learning made easy—and quickly teach yourself how to create professional-looking business and technical diagrams with Visio 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them! Create dynamic organization charts with Visio Make charts with wizards or build them by hand Build drawings using Visio themes and effects Use data-driven drawings in Microsoft SharePoint Import, manipulate, and visualize business data Draw and then execute SharePoint 2013 workflows

Introducing the tools of statistics and probability from the ground up An understanding of statistical tools is essential for engineers and scientists who often need to deal with data analysis over the course of their work. Statistics and Probability with Applications for Engineers and Scientists walks readers through a wide range of popular statistical techniques, explaining step-by-step how to generate, analyze, and interpret data for diverse applications in engineering and the natural sciences. Unique among books of this kind, Statistics and Probability with Applications for Engineers and Scientists covers descriptive statistics first, then goes on to discuss the fundamentals of probability theory. Along with case studies, examples, and real-world data sets, the book incorporates clear instructions on how to use the statistical packages Minitab and Microsoft Office Excel to analyze various data sets. The book also features: Detailed discussions on sampling distributions, statistical estimation of population parameters, hypothesis testing, reliability theory, statistical quality control including Phase I and Phase II control charts, and process capability indices A clear presentation of nonparametric methods and simple and multiple linear regression methods, as well as a brief discussion on logistic regression method Comprehensive guidance on the design of experiments, including randomized block designs, one- and two-way layout designs, Latin square designs, random effects and mixed effects models, factorial and fractional factorial designs, and response surface methodology A companion website containing data sets for Minitab and Microsoft Office Excel, as well as JMP routines and results Assuming no background in probability and statistics, Statistics and Probability with Applications for Engineers and Scientists features a unique, yet tried-and-true, approach that is ideal for all undergraduate students as well as statistical practitioners who analyze and illustrate real-world data in engineering and the natural sciences.

Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®

CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. • Create, customize, and change your pivot tables and pivot charts • Transform gigantic data sets into crystal-clear summary reports • Summarize and analyze data even faster with new Excel 2013 recommended pivot tables • Instantly highlight your most (and least) profitable customers, products, or regions • Quickly filter pivot tables using slicers • Use dynamic dashboards using Power View to see exactly where your business stands right now • Revamp analyses on the fly by simply dragging and dropping fields • Build dynamic self-service reporting systems your entire team can use • Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets • Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013

Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations. Covers Excel 2010 back to Excel 2003 Shows how to develop consensus on strategy and operational plans with the executive teams Details steps in creating tactical action plans Gives step-by-step guidance in creating the most powerful management dashboards Puts over ten years of experience in one book Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.

Have you ever used SAS Enterprise Guide and found yourself wishing that it had that one specific feature, something that you know would make it the perfect tool for your work or industry? You don't have to settle for just the "out of the box" features; you can add your own capabilities with SAS custom tasks!

Chris Hemedinger's new book takes you step-by-step through the process of creating custom tasks for use in SAS Enterprise Guide and SAS Add-In for Microsoft Office. Using standard off-the-shelf development tools for Microsoft .NET, you'll learn how you can hook in your custom processes and make them available to a wide range of SAS users. In the first part of the book, you'll learn how to use the development environment and the programming interfaces provided by SAS to create, test, and deploy new custom tasks. You'll learn about the services that the SAS Enterprise Guide framework offers, including data access, the ability to run SAS programs, and integration of your custom results into a SAS Enterprise Guide project.

In the second part of the book, Hemedinger provides a variety of useful, field-tested and ready-to-run examples—complete with C# and Visual Basic .NET source code. Each example highlights different programming techniques that you can apply immediately within your own custom tasks. The book also addresses important aspects of .NET programming, such as debugging, exception handling, threading models, and user interface design.

This book is part of the SAS Press program.