Master business modeling and analysis techniques with Microsoft Excel 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. A lot has changed in Office 365 since the previous edition. This new edition covers new functions (STOCKHISTORY, LET, LAMBDA, XLOOKUP) and new array functions. It also covers the new Data types t...

Step by step, students will learn how to transform simple tables into full analytical models of immense power. They will master data modeling through a collection of realistic scenarios of increasing sophistication. For each, the authors start with a simple "naïve" model that can't provide robust solutions. Next, they guide readers to update and improve the model, so it can deliver the knowledge and insights they really need.

Exam Ref DA-100 Analyzing Data with Microsoft Power BI offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on specific areas of expertise modern IT professionals need to demonstrate real-world mastery of Power BI data analysis and visualization. Coverage includes:

- Preparing data: acquiring, profiling, cleaning, transforming, and loading data

- Modeling data: designing and developing data mo...

Master business modeling and analysis techniques with Microsoft Excel 2019, 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.

Business Intelligence, Analytics, Data Science, and AI is your guide to the business-related impact of artificial intelligence, data science and analytics, designed to prepare you for a managerial role. The text's vignettes and cases feature modern companies and non-profit organizations and illustrate capabilities, costs and justifications of BI across various business units. With coverage of many data science/AI applications, you'll explore tools, then learn from various organizations' exper...

Telling you 'everything you need to know' to help your organization implement DevOps on the Microsoft platform, this book teaches how to use Visual Studio, Visual Studio Team Services and Azure to implement a complete DevOps process, including how to introduce DevOps to your organization and how to overcome problems.

Teaching students both the theory and practice of GIS using Arc GIS Pro.

Discovering GIS and ArcGIS Pro provides students with hands-on work with GIS software, while explaining the process behind each application. This text teaches students how to combine GIS concepts with ArcGIS Pro software skills, preparing them for successful careers in the real world. Each chapter focuses on using a variety of ArcGIS tools in a real-world context from calculating the distance between two library branches...

Student Study Guide With IBM (R) SPSS (R) Workbook for Research Methods, Statistics, and Applications 3e gives students opportunities to practice and apply their knowledge. Written by the authors of the main text, this study guide follows the textbook and offers practice quizzes, in-depth exercises, research application questions, and instructions and exercises for SPSS.

Understanding Statistics in Psychology with SPSS, eighth edition, offers students a trusted, straightforward, and engaging way of learning to do statistical analyses confidently using SPSS. Comprehensive and practical, the text is organised into short accessible chapters, making it the ideal text for undergraduate psychology students needing to get to grips with statistics in class or independently. Clear diagrams and full colour screenshots from SPSS make the text suitable for beginners whil...

This book integrates theoretical advances and empirical data on Enterprise Governance in Information Technology (EGIT) with practical applications based on numerous case examples. The third revised edition of Enterprise Governance of Information Technology provides professionals and students with the most recent research advancements as well as an in-depth discussion of the recently-introduced Control Objectives for Information and Related Technologies (COBIT) 2019 framework which can be used...