Advertisement
business analytics with excel pdf: Using Excel for Business Analysis Danielle Stein Fairhurst, 2015-05-18 This is a guide to building financial models for business proposals, to evaluate opportunities, or to craft financial reports. It covers the principles and best practices of financial modelling, including the Excel tools, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors. |
business analytics with excel pdf: Data Analysis Using SQL and Excel Gordon S. Linoff, 2010-09-16 Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like. |
business analytics with excel pdf: Microsoft Excel 2010 Wayne L. Winston, 2011 An award-winning business professor and corporate consultant shares the best of his real-world experience in this practical, scenario-focused guide--fully updated for Excel 2010. |
business analytics with excel pdf: Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) Wayne Winston, 2021-12-17 Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel—and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook |
business analytics with excel pdf: Business Data Analysis Using Excel David Whigham, 2007-01-11 Taking a thematic approach to the use of Excel spreadsheets in introductory business data analysis, this text has been designed to explain the overall nature of what is to be achieved and also instruction in how it is to be done. The learning approach is highly interactive and enables students to develop an understanding of the power of Excel in allowing both analysis of business data sets and in the flexible preparation of graphs, charts and tables for inclusion in reports and essays. The text is supported by an online resource centre with self marking exercises that can be used by instructors for formative and summative assessment, and a series of PowerPoint files containing all of the illustrated worksheets and figures. |
business analytics with excel pdf: Introducing Microsoft Power BI Alberto Ferrari, Marco Russo, 2016-07-07 This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:http://aka.ms/analyzingdata/details. Learn more about Power BI at https://powerbi.microsoft.com/. |
business analytics with excel pdf: Excel Data Analysis Hector Guerrero, 2018-12-14 This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations. |
business analytics with excel pdf: Excel 2019 for Marketing Statistics Thomas J. Quirk, Eric Rhiney, 2021-02-23 This book shows the capabilities of Microsoft Excel in teaching marketing statistics effectively. It is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical marketing problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in marketing courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Marketing Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. In this new edition, each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand marketing problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned. |
business analytics with excel pdf: Microsoft Excel 2013 Data Analysis and Business Modeling Wayne Winston, 2014-01-15 Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in |
business analytics with excel pdf: Microsoft Excel 2019 Data Analysis and Business Modeling Wayne Winston, 2019-03-28 Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. Solve real business problems with Excel—and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics Use PowerQuery or Get & Transform to connect, combine, and refine data sources Leverage Office 365’s new Geography and Stock data types and six new functions Illuminate insights from geographic and temporal data with 3D Maps Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts Use Excel trend curves, multiple regression, and exponential smoothing Delve into key financial, statistical, and time functions Master all of Excel’s great charts Quickly create forecasts from historical time-based data Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams Run Monte Carlo simulations on stock prices and bidding models Learn about basic probability and Bayes’ Theorem Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook Automate repetitive analytics tasks by using macros |
business analytics with excel pdf: Microsoft Business Intelligence Tools for Excel Analysts Michael Alexander, Jared Decker, Bernard Wehbe, 2014-05-05 Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you. |
business analytics with excel pdf: Microsoft Excel and Business Data Analysis for the Busy Professional Michael Olafusi, 2016-08-22 Microsoft Excel is the world's most used business intelligence tool. Its knowledge is even compulsory for an MBA degree and the investment world depends greatly on it. This book is aimed at making you extremely good in using Microsoft Excel for business data analysis; teaching you with companion videos and practice files. It's intended for Sales Managers, Financial Analysts, Business Analysts, Data Analysts, MIS Analysts, HR Executives and frequent Excel users. It is written by Michael Olafusi a three time Microsoft Excel MVP (most valuable professional) and a full-time Microsoft Excel consultant. He is the founder of UrBizEdge, a business data analysis and Microsoft Excel consulting firm. He has trained hundreds of business professionals on Microsoft Excel and has used the experience gained from interacting with them both during such trainings and while consulting for companies to write this excellent guide for the busy professional who needs the improved work productivity Microsoft Excel provides. |
business analytics with excel pdf: Marketing Analytics Wayne L. Winston, 2014-01-08 Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoid high-risk customers Helps you forecast sales and improve response rates for marketing campaigns Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel. |
business analytics with excel pdf: Business Analysis with Microsoft Excel Conrad George Carlberg, 2002 Take control of the bottom line using expert techniques and Excel's powerful financial capabilities! Whether you own a small business or work for a large corporation; whether you are looking for help making financial and business decisions -- this book is for you. Business Analysis with Microsoft Excel, Second Editionprovides in-depth information that will maximize your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions. |
business analytics with excel pdf: Excel 2016 Bible John Walkenbach, 2015-10-09 The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance. |
business analytics with excel pdf: An Introduction to Business Analytics Ger Koole, 2019 Business Analytics (BA) is about turning data into decisions. This book covers the full range of BA topics, including statistics, machine learning and optimization, in a way that makes them accessible to a broader audience. Decision makers will gain enough insight into the subject to have meaningful discussions with machine learning specialists, and those starting out as data scientists will benefit from an overview of the field and take their first steps as business analytics specialist. Through this book and the various exercises included, you will be equipped with an understanding of BA, while learning R, a popular tool for statistics and machine learning. |
business analytics with excel pdf: Data Analysis with Microsoft Excel Kenneth N. Berk, Patrick Carey, 2009 The latest book from Cengage Learning on Data Analysis with Microsoft« ExcelÖ |
business analytics with excel pdf: Using Excel for Business and Financial Modelling Danielle Stein Fairhurst, 2019-03-25 A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. • Provides the perfect mix of practice and theory • Helps you become a DIY Excel modelling specialist • Includes updates for Excel 2019/365 and Excel for Mac • May be used as an accompaniment to the author’s online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling. |
business analytics with excel pdf: Exploratory Data Analysis in Business and Economics Thomas Cleff, 2013-11-12 In a world in which we are constantly surrounded by data, figures, and statistics, it is imperative to understand and to be able to use quantitative methods. Statistical models and methods are among the most important tools in economic analysis, decision-making and business planning. This textbook, “Exploratory Data Analysis in Business and Economics”, aims to familiarise students of economics and business as well as practitioners in firms with the basic principles, techniques, and applications of descriptive statistics and data analysis. Drawing on practical examples from business settings, it demonstrates the basic descriptive methods of univariate and bivariate analysis. The textbook covers a range of subject matter, from data collection and scaling to the presentation and univariate analysis of quantitative data, and also includes analytic procedures for assessing bivariate relationships. It does not confine itself to presenting descriptive statistics, but also addresses the use of computer programmes such as Excel, SPSS, and STATA, thus treating all of the topics typically covered in a university course on descriptive statistics. The German edition of this textbook is one of the “bestsellers” on the German market for literature in statistics. |
business analytics with excel pdf: Essentials of Business Analytics Bhimasankaram Pochiraju, Sridhar Seshadri, 2019-07-10 This comprehensive edited volume is the first of its kind, designed to serve as a textbook for long-duration business analytics programs. It can also be used as a guide to the field by practitioners. The book has contributions from experts in top universities and industry. The editors have taken extreme care to ensure continuity across the chapters. The material is organized into three parts: A) Tools, B) Models and C) Applications. In Part A, the tools used by business analysts are described in detail. In Part B, these tools are applied to construct models used to solve business problems. Part C contains detailed applications in various functional areas of business and several case studies. Supporting material can be found in the appendices that develop the pre-requisites for the main text. Every chapter has a business orientation. Typically, each chapter begins with the description of business problems that are transformed into data questions; and methodology is developed to solve these questions. Data analysis is conducted using widely used software, the output and results are clearly explained at each stage of development. These are finally transformed into a business solution. The companion website provides examples, data sets and sample code for each chapter. |
business analytics with excel pdf: Business Analytics for Managers Gert Laursen, Jesper Thorlund, 2010-07-13 While business analytics sounds like a complex subject, this book provides a clear and non-intimidating overview of the topic. Following its advice will ensure that your organization knows the analytics it needs to succeed, and uses them in the service of key strategies and business processes. You too can go beyond reporting!—Thomas H. Davenport, President's Distinguished Professor of IT and Management, Babson College; coauthor, Analytics at Work: Smarter Decisions, Better Results Deliver the right decision support to the right people at the right time Filled with examples and forward-thinking guidance from renowned BA leaders Gert Laursen and Jesper Thorlund, Business Analytics for Managers offers powerful techniques for making increasingly advanced use of information in order to survive any market conditions. Take a look inside and find: Proven guidance on developing an information strategy Tips for supporting your company's ability to innovate in the future by using analytics Practical insights for planning and implementing BA How to use information as a strategic asset Why BA is the next stepping-stone for companies in the information age today Discussion on BA's ever-increasing role Improve your business's decision making. Align your business processes with your business's objectives. Drive your company into a prosperous future. Taking BA from buzzword to enormous value-maker, Business Analytics for Managers helps you do it all with workable solutions that will add tremendous value to your business. |
business analytics with excel pdf: Decision Analytics Conrad George Carlberg, 2013 Explains how to distil big data into manageable sets and use them to optimise business and investment decisions. Reveals techniques to improve a wide range of decisions, and use simple Excel charts to grasp the results. Includes downloadable Excel workbooks to adapt to your own requirements. |
business analytics with excel pdf: Business Analytics Principles, Concepts, and Applications with SAS Marc J. Schniederjans, Dara G. Schniederjans, Christopher M. Starkey, 2014-10-07 Responding to a shortage of effective content for teaching business analytics, this text offers a complete, integrated package of knowledge for newcomers to the subject. The authors present an up-to-date view of what business analytics is, why it is so valuable, and most importantly, how it is used. They combine essential conceptual content with clear explanations of the tools, techniques, and methodologies actually used to implement modern business analytics initiatives. Business Analytics Principles, Concepts, and Applications with SAS offers a proven step-wise approach to designing an analytics program, and successfully integrating it into your organization, so it effectively provides intelligence for competitive advantage in decision making. Using step-by-step examples, the authors identify common challenges that can be addressed by business analytics, illustrate each type of analytics (descriptive, prescriptive, and predictive), and guide users in undertaking their own projects. Illustrating the real-world use of statistical, information systems, and management science methodologies, these examples help readers successfully apply the methods they are learning. Unlike most competitive guides, Business Analytics Principles, Concepts, and Applications with SAS demonstrates the use of SAS software, permitting instructors to spend less time teaching software and more time focusing on business analytics itself. |
business analytics with excel pdf: Data Mining for Business Analytics Galit Shmueli, Peter C. Bruce, Nitin R. Patel, 2016-04-18 An applied approach to data mining and predictive analytics with clear exposition, hands-on exercises, and real-life case studies. Readers will work with all of the standard data mining methods using the Microsoft® Office Excel® add-in XLMiner® to develop predictive models and learn how to obtain business value from Big Data. Featuring updated topical coverage on text mining, social network analysis, collaborative filtering, ensemble methods, uplift modeling and more, the Third Edition also includes: Real-world examples to build a theoretical and practical understanding of key data mining methods End-of-chapter exercises that help readers better understand the presented material Data-rich case studies to illustrate various applications of data mining techniques Completely new chapters on social network analysis and text mining A companion site with additional data sets, instructors material that include solutions to exercises and case studies, and Microsoft PowerPoint® slides https://www.dataminingbook.com Free 140-day license to use XLMiner for Education software Data Mining for Business Analytics: Concepts, Techniques, and Applications in XLMiner®, Third Edition is an ideal textbook for upper-undergraduate and graduate-level courses as well as professional programs on data mining, predictive modeling, and Big Data analytics. The new edition is also a unique reference for analysts, researchers, and practitioners working with predictive analytics in the fields of business, finance, marketing, computer science, and information technology. Praise for the Second Edition ...full of vivid and thought-provoking anecdotes... needs to be read by anyone with a serious interest in research and marketing.– Research Magazine Shmueli et al. have done a wonderful job in presenting the field of data mining - a welcome addition to the literature. – ComputingReviews.com Excellent choice for business analysts...The book is a perfect fit for its intended audience. – Keith McCormick, Consultant and Author of SPSS Statistics For Dummies, Third Edition and SPSS Statistics for Data Analysis and Visualization Galit Shmueli, PhD, is Distinguished Professor at National Tsing Hua University’s Institute of Service Science. She has designed and instructed data mining courses since 2004 at University of Maryland, Statistics.com, The Indian School of Business, and National Tsing Hua University, Taiwan. Professor Shmueli is known for her research and teaching in business analytics, with a focus on statistical and data mining methods in information systems and healthcare. She has authored over 70 journal articles, books, textbooks and book chapters. Peter C. Bruce is President and Founder of the Institute for Statistics Education at www.statistics.com. He has written multiple journal articles and is the developer of Resampling Stats software. He is the author of Introductory Statistics and Analytics: A Resampling Perspective, also published by Wiley. Nitin R. Patel, PhD, is Chairman and cofounder of Cytel, Inc., based in Cambridge, Massachusetts. A Fellow of the American Statistical Association, Dr. Patel has also served as a Visiting Professor at the Massachusetts Institute of Technology and at Harvard University. He is a Fellow of the Computer Society of India and was a professor at the Indian Institute of Management, Ahmedabad for 15 years. |
business analytics with excel pdf: Statistical Analysis Conrad Carlberg, 2014-04-04 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 |
business analytics with excel pdf: Predictive Analytics Conrad Carlberg, 2017-07-13 EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS! Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. Learn the “how” and “why” of using data to make better decisions, and choose the right technique for each problem Capture live real-time data from diverse sources, including third-party websites Use logistic regression to predict behaviors such as “will buy” versus “won’t buy” Distinguish random data bounces from real, fundamental changes Forecast time series with smoothing and regression Account for trends and seasonality via Holt-Winters smoothing Prevent trends from running out of control over long time horizons Construct more accurate predictions by using Solver Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning Handle complex consumer choice problems with advanced logistic regression Benchmark Excel results against R results |
business analytics with excel pdf: Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel Chris Sorensen, 2018-04-28 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam. Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully consume, transform, model, and visualize data with Excel 2016. Coverage includes: Importing data from external data sources Working with Power Query Designing and implementing transformations Applying business rules Cleansing data Creating performance KPIs And much more Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not one-size-fits-all content Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of what if? scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro's job role For more information on Exam 70-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning. |
business analytics with excel pdf: The Definitive Guide to DAX Alberto Ferrari, Marco Russo, 2015-10-14 This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio |
business analytics with excel pdf: Business Analytics Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, 2020-03-10 Present the full range of analytics -- from descriptive and predictive to prescriptive analytics -- with Camm/Cochran/Fry/Ohlmann's market-leading BUSINESS ANALYTICS, 4E. Clear, step-by-step instructions teach students how to use Excel, Tableau, R and JMP Pro to solve more advanced analytics concepts. As instructor, you have the flexibility to choose your preferred software for teaching concepts. Extensive solutions to problems and cases save grading time, while providing students with critical practice. This edition covers topics beyond the traditional quantitative concepts, such as data visualization and data mining, which are increasingly important in today's analytical problem solving. In addition, MindTap and WebAssign customizable digital course solutions offer an interactive eBook, auto-graded exercises from the printed book, algorithmic practice problems with solutions and Exploring Analytics visualizations to strengthen students' understanding of course concepts. |
business analytics with excel pdf: Collect, Combine, and Transform Data Using Power Query in Excel and Power BI Gil Raviv, 2018-10-08 Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you’re finished, you’ll be ready to wrangle any data–and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query · Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI · Solve common data preparation problems with a few mouse clicks and simple formula edits · Combine data from multiple sources, multiple queries, and mismatched tables · Master basic and advanced techniques for unpivoting tables · Customize transformations and build flexible data mashups with the M formula language · Address collaboration challenges with Power Query · Gain crucial insights into text feeds · Streamline complex social network analytics so you can do it yourself For all information workers, analysts, and any Excel user who wants to solve their own business intelligence problems. |
business analytics with excel pdf: PowerPivot for Business Intelligence Using Excel and SharePoint Barry Ralston, 2011-07-14 PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence |
business analytics with excel pdf: Profit Driven Business Analytics Wouter Verbeke, Bart Baesens, Cristian Bravo, 2017-10-09 Maximize profit and optimize decisions with advanced business analytics Profit-Driven Business Analytics provides actionable guidance on optimizing the use of data to add value and drive better business. Combining theoretical and technical insights into daily operations and long-term strategy, this book acts as a development manual for practitioners seeking to conceive, develop, and manage advanced analytical models. Detailed discussion delves into the wide range of analytical approaches and modeling techniques that can help maximize business payoff, and the author team draws upon their recent research to share deep insight about optimal strategy. Real-life case studies and examples illustrate these techniques at work, and provide clear guidance for implementation in your own organization. From step-by-step instruction on data handling, to analytical fine-tuning, to evaluating results, this guide provides invaluable guidance for practitioners seeking to reap the advantages of true business analytics. Despite widespread discussion surrounding the value of data in decision making, few businesses have adopted advanced analytic techniques in any meaningful way. This book shows you how to delve deeper into the data and discover what it can do for your business. Reinforce basic analytics to maximize profits Adopt the tools and techniques of successful integration Implement more advanced analytics with a value-centric approach Fine-tune analytical information to optimize business decisions Both data stored and streamed has been increasing at an exponential rate, and failing to use it to the fullest advantage equates to leaving money on the table. From bolstering current efforts to implementing a full-scale analytics initiative, the vast majority of businesses will see greater profit by applying advanced methods. Profit-Driven Business Analytics provides a practical guidebook and reference for adopting real business analytics techniques. |
business analytics with excel pdf: Data Mining for Business Analytics Galit Shmueli, Peter C. Bruce, Peter Gedeck, Nitin R. Patel, 2019-10-14 Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python presents an applied approach to data mining concepts and methods, using Python software for illustration Readers will learn how to implement a variety of popular data mining algorithms in Python (a free and open-source software) to tackle business problems and opportunities. This is the sixth version of this successful text, and the first using Python. It covers both statistical and machine learning algorithms for prediction, classification, visualization, dimension reduction, recommender systems, clustering, text mining and network analysis. It also includes: A new co-author, Peter Gedeck, who brings both experience teaching business analytics courses using Python, and expertise in the application of machine learning methods to the drug-discovery process A new section on ethical issues in data mining Updates and new material based on feedback from instructors teaching MBA, undergraduate, diploma and executive courses, and from their students More than a dozen case studies demonstrating applications for the data mining techniques described End-of-chapter exercises that help readers gauge and expand their comprehension and competency of the material presented A companion website with more than two dozen data sets, and instructor materials including exercise solutions, PowerPoint slides, and case solutions Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python is an ideal textbook for graduate and upper-undergraduate level courses in data mining, predictive analytics, and business analytics. This new edition is also an excellent reference for analysts, researchers, and practitioners working with quantitative methods in the fields of business, finance, marketing, computer science, and information technology. “This book has by far the most comprehensive review of business analytics methods that I have ever seen, covering everything from classical approaches such as linear and logistic regression, through to modern methods like neural networks, bagging and boosting, and even much more business specific procedures such as social network analysis and text mining. If not the bible, it is at the least a definitive manual on the subject.” —Gareth M. James, University of Southern California and co-author (with Witten, Hastie and Tibshirani) of the best-selling book An Introduction to Statistical Learning, with Applications in R |
business analytics with excel pdf: Financial Analysis with Microsoft Excel Timothy R. Mayes, Todd M. Shank, 1996 Start mastering the tool that finance professionals depend upon every day. FINANCIAL ANALYSIS WITH MICROSOFT EXCEL covers all the topics you'll see in a corporate finance course: financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. Plus, it's easy-to-read and full of study tools that will help you succeed in class. |
business analytics with excel pdf: Analyzing Business Data with Excel Gerald Knight, 2006-01-03 As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues. Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following: Statistics Pivot tables Workload forecasting Modeling Measuring quality Monitoring complex systems Queuing Optimizing Importing data If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them. |
business analytics with excel pdf: DATA ANALYSIS AND BUSINESS MODELLING USING MICROSOFT EXCEL Hansa Lysander Manohar, 2017-03-30 |
business analytics with excel pdf: Data Mining for Business Intelligence Galit Shmueli, Nitin R. Patel, Peter C. Bruce, 2006-12-11 Learn how to develop models for classification, prediction, and customer segmentation with the help of Data Mining for Business Intelligence In today's world, businesses are becoming more capable of accessing their ideal consumers, and an understanding of data mining contributes to this success. Data Mining for Business Intelligence, which was developed from a course taught at the Massachusetts Institute of Technology's Sloan School of Management, and the University of Maryland's Smith School of Business, uses real data and actual cases to illustrate the applicability of data mining intelligence to the development of successful business models. Featuring XLMiner, the Microsoft Office Excel add-in, this book allows readers to follow along and implement algorithms at their own speed, with a minimal learning curve. In addition, students and practitioners of data mining techniques are presented with hands-on, business-oriented applications. An abundant amount of exercises and examples are provided to motivate learning and understanding. Data Mining for Business Intelligence: Provides both a theoretical and practical understanding of the key methods of classification, prediction, reduction, exploration, and affinity analysis Features a business decision-making context for these key methods Illustrates the application and interpretation of these methods using real business cases and data This book helps readers understand the beneficial relationship that can be established between data mining and smart business practices, and is an excellent learning tool for creating valuable strategies and making wiser business decisions. |
business analytics with excel pdf: Business Analytics with Management Science Models and Methods Arben Asllani, 2015 This book is about prescriptive analytics. It provides business practitioners and students with a selected set of management science and optimization techniques and discusses the fundamental concepts, methods, and models needed to understand and implement these techniques in the era of Big Data. A large number of management science models exist in the body of literature today. These models include optimization techniques or heuristics, static or dynamic programming, and deterministic or stochastic modeling. The topics selected in this book, mathematical programming and simulation modeling, are believed to be among the most popular management science tools, as they can be used to solve a majority of business optimization problems. Over the years, these techniques have become the weapon of choice for decision makers and practitioners when dealing with complex business systems. |
business analytics with excel pdf: Business Analytics, Global Edition James R. Evans, 2016-01-29 A balanced and holistic approach to business analytics 'Business Analytics', teaches the fundamental concepts of the emerging field of business analytics and provides vital tools in understanding how data analysis works in today's organizations. Students will learn to apply basic business analytics principles, communicate with analytics professionals, and effectively use and interpret analytic models to make better business decisions. |
business analytics with excel pdf: Applied Business Statistics 5e Trevor Wegner, 2020 Applied Business Statistics 5e is an introductory and intermediate Statistics text for students of Management. Its business applications-oriented approach aims to teach Management students how statistics (or data analytics) can be used as a valuable decision-support tool in any discipline of management practice. |
B.Com (Business Analytics) - Osmania University
B.Com (Business Analytics) Syllabus (CBCS) (w.e.f. 2020–2021) FACULTY OF COMMERCE OSMANIA UNIVERSITY HYDERABAD - 500 007 T.S. Faculty of Commerce OU 2 B.COM …
Predictive Analytics: Microsoft® Excel - pearsoncmg.com
able branches to analytics: decision and predictive: Decision analytics has to do with classifying (mainly) people into segments of interest to the analyst. This branch of analytics depends heav …
Introduction to Business Data Analytics: Organizational View
Business Data Analytics as a Set of Practices and Technologies . Business data analytics is also considered a set of practices and technologies required to perform the analytics work itself. …
BBA (BUSINESS ANALYTICS) (CBCS) SYLLABUS - Osmania …
DSC 403 Predictive Business Analytics (Practical EXCEL) 3T+4P 5 1 ½ 50 U + 35 L+15I Total Semester Credits 27 25 . 4 BBA (CBCS) OU III YEAR SEMESTER V Course Code Course …
Business Analytics - GBV
Business Analytics Third Edition Jeffrey D. Camm James J. Goch ran Michael J. Fry Jeffrey W. Ohlmann David R. Anderson Dennis J. Sweeney Thomas A. Williams ... 2.3 Modifying Data in …
Chapter 2 Strategic Intent of a Business - MITSDE
forecast outcomes, offer decision options and show alternative business impact. This analytics help enterprises to take decisions on how to take advantage of a future scenario or reduce a …
Business Analytics Methods, Models, and Decisions James …
Evolution of Business Analytics 6 Analytic Foundations 6 • Modern Business Analytics 7 • Software Support and Spreadsheet Technology 9 Analytics in Practice: Social Media Analytics …
Business Analytics with Excel and R - dheconsulting.ca
Day 1 –Business Analytics with Excel. Day 2 teaches intermediate to advanced-level features and functions of Microsoft Excel. Participants will learn how to use formulas, work with scenarios …
Advanced Analytics with Power BI - info.microsoft.com
tools that exist today, business leaders are able to dive into their own analytics and uncover powerful insights. Microsoft Power BI brings advanced analytics to the daily business decision …
MASTERS PROGRAMME DEPARTMENT OF MASTER OF …
I ABOUT EXCEL 1. 1 Introduction, Uses of Excel, New functions and features of excel 2007 2. 8 Getting started with excel: Opening a blank or new workbook, general organization 3. …
GSB519: BUSINESS ANALYTICS TOOLS ONLINE SYLLABUS
have 105 minutes to complete 35 questions. Excel should be used for calculations on this exam. o PART II (Excel) - An Excel-based component that will be completed externally and submitted …
Data Analysis Using SQL and Excel® - Wiley Online Library
Data Center. Juice Analytics inspired the example for Worksheet bar charts in Chapter 5 (and thanks to Alex Wimbush, who pointed me in their direction). Edwin Straver of Frontline …
CURRICULUM AND SYLLABUS - shcollege.ac.in
Business Analytics course in Sacred Heart College is intended to empower professionals employed in the areas of Finance, Analytics, Economics, Statistics, Computer Science, …
DATA MINING FOR BUSINESS ANALYTICS - content.e …
DATA MINING FOR BUSINESS ANALYTICS Concepts, Techniques, and Applications in R Galit Shmueli Peter C. Bruce Inbal Yahav Nitin R. Patel Kenneth C. Lichtendahl, Jr.
INTRODUCTION BUSINESS ANALYTICS
BUSINESS ANALYTICS More than ever before, organizations are able to collect massive amounts of data in an ever-increasingly complex decision-making environment. Analytics is a …
Computer Lab - Practical Question Bank FACULTY OF …
B.Com (Business Analytics) CBCS Semester - II w.e.f. 2020-21 DATA ANALYTICS ESSENTIALS - Paper: 203 Time: 60 Minutes Record : 10 Viva-voce : 10 ... Using Ms-Excel, create a list of 10 …
Statistics for Business - nibmehub.com
“Generating Excel Graphs”. Associated with this paragraph are several Excel screens giving the stepwise procedure to develop graphs from a particular set of data. I have chosen Excel as the …
Introduction to Statistical Computing in Microsoft Excel - Rice …
Since we are using Excel, the best-case scenario will be if the data is in Excel format already. However, for the sake of education, suppose we have the “next-best-case” scenario of the data …
Business Analytics with Python - University of Southern …
Business Analytics with Python Course Learning Objectives: By the end of this course, students should be able to: 1) Identify core components of a business where analytics or prediction can …
Business Analytics Syllabus - Moallemi
B6101 Business Analytics Fall 2014 Business Analytics Syllabus Course Description Business analytics refers to the ways in which enterprises such as businesses, non-profits, and ... This …
Leveraging analytics to help manufacturing company …
business operations while driving powerful business insights. Project Goal: Gathering and filtering usable data was an elongated process with traditional IT infrastructure system. Identifying …
7.B.Com (Business Analytics) - Kakatiya University
)dfxow\ ri &rpphufh %xvlqhvv 0dqdjhphqw .dndwl\d 8qlyhuvlw\ ã â ã â ã â ã
Data analysis and visualization with Power BI Desktop
In this exercise, we import data from Excel to Power BI desktop. Please, follow the screenshots From the top menu choose “Get Data” -> Excel Open the file: Sample Dataset Cars.xlsx …
MSc Business Analytics - universityofgalway.ie
The MSc Business Analytics provides students with the skills and knowledge to manage and develop business analytics within organisations. The programme is designed as a specialist …
Predictive Business Analytics Using Excel: Exercise 2
Predictive Business Analytics Using Excel: Exercise 2 The demand for electricity over the period 2008 to 2014 is stored in eletricitydemand.txt file located at the Business Analytics website: …
Business performance Analytics - Dynamics 365 Community
Business performance analytics Presenter(s): Jinnie Wong –PRINCIPAL PRODUCT MANAGER Rishabh Agarwal –SR. SOFTWARE ENGINEERING MANAGER Co-Presenter(s)/Q&A: ... • …
How to Work with Excel Report and Interactive Analysis - SAP …
Business One 9.2 PL00 and later; SAP Business One analytics 1.2 powered by SAP HANA and later; and SAP Business One 9.2 PL00, version for SAP HANA. 1.2 2016-02-26 Guide updated …
Business Analytics Using R - A Practical Approach
iii Contents at a Glance About the Authors xv
CHAPTER 1 Introduction to Statistics and Business Analytics
The primary objective of Chapter 1 is to introduce you to the world of statistics and analytics, thereby enabling you to: 5. Define important business analytics terms including big data, …
Sample Chapters from Microsoft Excel 2010: Data Analysis …
Chapter 22 The OFFSET Function Questions answered in this chapter: How can I create a reference to a range of cells that is a specified number of rows and columns from a cell or …
Human Resources Analytics for Business Managers
business goals. Creating the HR Analytics platform The next three chapters provide an explanation of how to create the scope and platform for the successful implementation of …
Business Analytics - GBV
Business Analytics Methods, Models, and Decisions James R. Evans : University of Cincinnati PEARSON Boston Columbus Indianapolis New York San Francisco Upper Saddle River ...
HR DATA ANALYTICS - osc.gov.jm
Data Analytics is the process of organizing raw data to be able to make meaningful decisions out of the information. When used, data analytics can contribute to the optimization of performance …
Introduction to Business Analytics - McGraw Hill Education
Introduction to Business Analytics recognizes that students need to develop the skills to ask the right questions, learn to use common workplace tools (such as Excel®, Tableau®, and Power …
DATA ANALYSIS AND ANALYTICS USING SPREADSHEET …
ANALYTICS USING SPREADSHEET COURSE CODE: R22MBAB2 COMPILED BY Dr. V. HIMA BINDHU. ... Unit-I:Worksheets andSpreadsheetsBasics . Ms-Excel Introduction: Uses of Excel …
Advancing into Analytics - bayanbox.ir
stop by at stringfestanalytics.com; I still post regularly on Excel and analytics more generally. As I began to learn more about Excel, my interest spread to other analytics tools and techniques. …
CPA ADVANCD LEVEL PRACTICAL PAPER NO. CA 35P: …
PRACTICAL PAPER NO. CA 35P: BUSINESS AND DATA ANALYTICS (COMPUTER-BASED EXAMINATION). NOTIONAL HOURS: 240 Recommended tool: Excel, R UNIT DESCRIPTION …
Supply Chain and Analytics - University of Missouri–St. Louis
of topics in the areas of supply chain management and business analytics. It offers comprehensive supply chain programs at the undergraduate, Master and PhD levels. The …
Understanding Business Analytics Success and Impact: A …
business analytics. Keywords: Business analytics, Grounded Theory, Success factors, Qualitative. 1. INTRODUCTION Business analytics refers to the generation and use of knowledge and …
Data and Analytics Academy Curriculum 2020 - PwC
It gives participants an opportunity to demonstrate their business strategic thinking, communication, and acquired analytics skills. Business cases across various industries and …
How to Excel in Analytical Decision Modeling - IJHEM
How to Excel in Analytical Decision Modeling SUDHAKAR D. DESHMUKH Kellogg School of Management, Northwestern University Evanston, U. S. A. This paper outlines a course in …
Using Excel to Integrate Data Analytics into the Management …
There is an ongoing discussion about Excel being a “legacy” technology no longer adequate to handle Big Data. Research indicates, however, that accounting pro-fessionals resist adopting …
ENGINEERING COLLEGE
3. Hansa Lysander Manohar, “Data Analysis and Business Modelling using MS Excel, PHI Learning private Ltd, 2017 4. William J. Stevenson, Ceyhun Ozgur, ‘Introduction to …
Even You Can Learn Statistics and Analytics - pearsoncmg.com
for teaching computer applications in a business context. A frequent partici-pant in the Decision Sciences Institute’s Making Statistics for More Effective in School of Business mini …
Course Outline BUSINESS ANALYTICS - Amrita Vishwa …
This course gives an introduction to the area of business analytics. Business Analytics (BA) is generally understood as the extensive use of data, mathematical and statistical models using …
Data Mining for Business Analytics: Concepts, Techniques, …
An applied approach to data mining and predictive analytics with clear exposition, hands-on exercises, and real-life case studies. Readers will work with all of the standard data mining …
Analytics and Reporting for SAP Business One - SAP Online …
Export to PDF, XML, and MS Excel License One Crystal Reports designer included per SAP Business One customer Viewer license granted for all users ... Pervasive Analytics SAP …
Galit Shmueli Peter C. Bruce Nitin R. Patel - ciando
• For Excel 2007, always download SolverSetup. In Excel 2010, choose File > Help and look in the lower right. In Excel 2016 and Excel 2013, choose File > Account > About Excel and look at …
New Doc 12-08-2023 10 - Andhra University
DATA ANALYSIS WITH MS EXCEL l: Introduction to Business Analytics: Benefits of Business Analytics, Types of Data — Unit — Structured, Semi Structured and Unstructured, Application …
Business Intelligence - Entendendo BI
mais fácil do que eu percorri para ter esse conhecimento. Esse foi o grande motivo para a criação da minha página Entendendo BI. Neste e-book vou tentar resumir para você tudo aquilo que é …