Hands-On Financial Modeling with Microsoft Excel 2019. Build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019

Shmuel Oluwa

Financial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Microsoft Excel 2019 explores terminologies of financial modeling with the help of Excel.This book will provides you with an overview of the steps you should follow to build an integrated financial model. You will explore the design principles, functions, and techniques of building models in a practical manner. Starting with the key concepts of Excel, such as formulas and functions, you will learn about referencing frameworks and other advanced components for building financial models. Later chapters will help you understand your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. The book takes an intuitive approach to model testing and covers best practices and practical use cases.By the end of this book, you will have examined the data from various use cases, and have the skills you need to build financial models to extract the information required to make informed business decisions.

Hands-On G Suite for Administrators. Build and manage any business on top of the Google Cloud infrastructure

Cesar Anton Dorantes

Hands-On G Suite for Administrators is a comprehensive hands-on guide to G Suite Administration that will prepare you with all you need to know to become a certified G Suite Administrator, ready to handle all the business scales, from a small office to a large enterprise. You will start by learning the main features, tools, and services from G Suite for Business and then, you will explore all it has to offer and the best practices, so you can make the most out of it. We will explore G Suite tools in depth so you and your team get everything you need -combination of tools, settings and practices- to succeed in an intuitive, safe and collaborative way. While learning G Suite tools you will also learn how to use Google Sites and App Maker, to create from your corporate site to internal tools, live reports that seamlessly integrate with live documents, and advanced Google Services.Finally, you will learn how to set up, analyze and enforce Security, Privacy for your business and how to efficiently troubleshoot a wide variety of issues.

Hands-On Infrastructure Monitoring with Prometheus. Implement and scale queries, dashboards, and alerting across machines and containers

Joel Bastos, Pedro Araújo

Prometheus is an open source monitoring system. It provides a modern time series database, a robust query language, several metric visualization possibilities, and a reliable alerting solution for traditional and cloud-native infrastructure.This book covers the fundamental concepts of monitoring and explores Prometheus architecture, its data model, and how metric aggregation works. Multiple test environments are included to help explore different configuration scenarios, such as the use of various exporters and integrations. You’ll delve into PromQL, supported by several examples, and then apply that knowledge to alerting and recording rules, as well as how to test them. After that, alert routing with Alertmanager and creating visualizations with Grafana is thoroughly covered. In addition, this book covers several service discovery mechanisms and even provides an example of how to create your own. Finally, you’ll learn about Prometheus federation, cross-sharding aggregation, and also long-term storage with the help of Thanos.By the end of this book, you’ll be able to implement and scale Prometheus as a full monitoring system on-premises, in cloud environments, in standalone instances, or using container orchestration with Kubernetes.

Hands-On Internet of Things with Blynk. Build on the power of Blynk to configure smart devices and build exciting IoT projects

Pradeeka Seneviratne

Blynk, known as the most user-friendly IoT platform, provides a way to build mobile applications in minutes. With the Blynk drag-n-drop mobile app builder, anyone can build amazing IoT applications with minimal resources and effort, on hardware ranging from prototyping platforms such as Arduino and Raspberry Pi 3 to industrial-grade ESP8266, Intel, Sierra Wireless, Particle, Texas Instruments, and a few others.This book uses Raspberry Pi as the main hardware platform and C/C++ to write sketches to build projects. The first part of this book shows how to set up a development environment with various hardware combinations and required software. Then you will build your first IoT application with Blynk using various hardware combinations and connectivity types such as Ethernet and Wi-Fi. Then you'll use and configure various widgets (control, display, notification, interface, time input, and some advanced widgets) with Blynk App Builder to build applications. Towards the end, you will learn how to connect with and use built-in sensors on Android and iOS mobile devices. Finally you will learn how to build a robot that can be controlled with a Blynk app through the Blynk cloud and personal server.By the end of this book, you will have hands-on experience building IoT applications using Blynk.

Hands-On Kubernetes on Azure. Run your applications securely and at scale on the most widely adopted orchestration platform

Shivakumar Gopalakrishnan, Gunther Lenz

Microsoft is now one of the most significant contributors to Kubernetes open source projects. Kubernetes helps to create, configure, and manage a cluster of virtual machines that are preconfigured to run containerized applications.This book will be your guide to performing successful container orchestration and deployment of Kubernetes clusters on Azure. You will get started by learning how to deploy and manage highly scalable applications, along with understanding how to set up a production-ready Kubernetes cluster on Azure. As you advance, you will learn how to reduce the complexity and operational overheads of managing a Kubernetes cluster on Azure.By the end of this book, you will not only be capable of deploying and managing Kubernetes clusters on Azure with ease, but also have the knowledge of best practices for working with advanced AKS concepts for complex systems.

Hands-On Machine Learning with IBM Watson. Leverage IBM Watson to implement machine learning techniques and algorithms using Python

James D. Miller

IBM Cloud is a collection of cloud computing services for data analytics using machine learning and artificial intelligence (AI). This book is a complete guide to help you become well versed with machine learning on the IBM Cloud using Python. Hands-On Machine Learning with IBM Watson starts with supervised and unsupervised machine learning concepts, in addition to providing you with an overview of IBM Cloud and Watson Machine Learning. You'll gain insights into running various techniques, such as K-means clustering, K-nearest neighbor (KNN), and time series prediction in IBM Cloud with real-world examples. The book will then help you delve into creating a Spark pipeline in Watson Studio. You will also be guided through deep learning and neural network principles on the IBM Cloud using TensorFlow. With the help of NLP techniques, you can then brush up on building a chatbot. In later chapters, you will cover three powerful case studies, including the facial expression classification platform, the automated classification of lithofacies, and the multi-biometric identity authentication platform, helping you to become well versed with these methodologies.By the end of this book, you will be ready to build efficient machine learning solutions on the IBM Cloud and draw insights from the data at hand using real-world examples.

Hands-On Microsoft Lists. Create custom data models and improve the way data is organized using Lists in Microsoft 365

Joao Ferreira, Rene Modery

Microsoft Lists is an extremely flexible and powerful platform for creating custom data models. Hands-On Microsoft Lists is an easy-to-read guide for those who want to get started with Lists, as well as those who are already familiar with the basic concepts and want to create custom and flexible Lists that are easily available through a web interface.This comprehensive introduction to Lists will show you how to get up to speed in no time with the help of practical guidance and examples. Complete with hands-on tutorials and projects, you’ll understand how to use and implement Microsoft Lists effectively. You’ll start by covering all the basic concepts that will help you to build your Microsoft Lists and get the most out of the platform. As you progress, you’ll explore how to customize Microsoft Lists layouts and forms. Later chapters will guide you through integrating Microsoft Lists with the Power Platform. Throughout the book, you’ll work with practical scenarios that you can use daily to improve the collaboration in your organization.By the end of this Microsoft book, you’ll have learned how to create custom data models to improve the way your data is put together, managed, and consumed in your workplace.

Hands-On Microsoft Teams. A practical guide to enhancing enterprise collaboration with Microsoft Teams and Microsoft 365 - Second Edition

Joao Ferreira

Microsoft Teams is a permanent fixture in the modern workplace, but many of its productivity-boosting features go unnoticed or unused. Hands-On Microsoft Teams shows you how to use Teams to its full potential through easy-to-follow practical tutorials.This guide to mastering Teams explores the platform in comprehensive detail and how it interacts with the rest of the Microsoft ecosystem to help you work efficiently and manage your resources. You'll get to grips with core functionality like setting up and managing teams, channels, chats, tabs, and meetings.You'll also learn to get the best out of Teams by adding custom apps, integrating with Microsoft 365, using PowerShell automation, and exploring useful settings you didn't know existed. Along the way, you'll be shown various real-world scenarios and how to implement solutions for them in Teams that will increase your productivity.Whether you're an administrator, manager, or team member, by the end of this book you'll be confident in using everything Microsoft Teams has to offer.