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...

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...

Updated for Excel 2002, this text offers Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with an introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.

Description All aspects of software development and deployment become painfully slow. The solution is to adopt the microservice architecture. This architecture accelerates software development and enables continuous delivery and deployment of complex software applications.

Microservice Patterns teaches enterprise developers and architects how to build applications with the microservice architecture. This book also teaches readers how to refactor a monolithic application to a microservice arch...

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...

Cyber-solutions to real-world business problems

Artificial Intelligence in Practice is a fascinating look into how companies use AI and machine learning to solve problems. Presenting 50 case studies of actual situations, this book demonstrates practical applications to issues faced by businesses around the globe. The rapidly evolving field of artificial intelligence has expanded beyond research labs and computer science departments and made its way into the mainstream business environment. Ar...