Название: Data Analysis and Optimization: In Honor of Boris Mirkin's 80th Birthday
Автор: Boris Goldengorin, Sergei Kuznetsov
Издательство: Springer
Год: 2023
Страниц: 447
Язык: английский
Формат: pdf (true)
Размер: 14.7 MB

This book presents the state-of-the-art in the emerging field of Data Science and includes models for layered security with applications in the protection of sites―such as large gathering places―through high-stake decision-making tasks. Such tasks include cancer diagnostics, self-driving cars, and others where wrong decisions can possibly have catastrophic consequences. The manipulability of aggregation procedures for the case of large numbers of voters is analyzed from a theoretical point of view and justified by computational experiments involving at least an order of magnitude larger number of voters. Many tree-type structures are considered: from phylogenetic trees representing the main patterns of vertical descent through consensus trees and super- trees widely used in evolutionary studies to combine phylogenetic information contained in individual gene trees. The statistical part of this book studies an impact of data mining and modeling on predictability assessment of time series. New notions of mean values based on ideas of multicriteria optimization are compared to their conventional definitions leading to fresh algorithmic approaches. To summarize, the book presents methods for automated analysis of patterns and models for data of different nature with applications ranging from scientific discovery to business intelligence and analytics. The style of the written chapters allows to recommend this book for senior undergraduate and graduate data mining courses providing a broad yet in-depth review integrating novel concepts from Machine Learning and statistics.

Название: Unlocking dbt: Design and Deploy Transformations in Your Cloud Data Warehouse
Автор: Cameron Cyr, Dustin Dorsey
Издательство: Apress
Год: 2023
Страниц: 368
Язык: английский
Формат: pdf (true), epub
Размер: 11.1 MB

This book shows how dbt is used to build data transformation pipelines that enable dependency management and allow for version control and automated testing. It explains how dbt is revolutionizing data transformation and the advantages that a command-line tool like dbt provides over and above the use of database stored procedures and other ETL and ELT tools that handle data transformations. At its simplest definition, dbt (or data build tool) is an open source data transformation tool commonly used for modeling data in data warehouses. It enables data professionals comfortable writing SQL to transform data in their warehouses more effectively. At a more granular level, it is a tool that has a development framework that combines modular SQL with software engineering best practices to create a better, faster, and more reliable data transformation experience. Modular SQL refers to the practice of breaking down SQL code into smaller, reusable chunks so that it can be more easily maintained, tested, and reused. Other best practices that dbt lends itself well to include version control, documentation, DevOps, and so on. For current and aspiring data professionals, including architects, developers, analysts, engineers, data scientists, and consultants who are beginning the journey of using dbt as part of their data pipeline’s transformation layer.

Название: Predictive Safety Analytics: Reducing Risk through Modeling and Machine Learning
Автор: Robert Stevens
Издательство: CRC Press
Год: 2024
Страниц: 99
Язык: английский
Формат: pdf (true), djvu
Размер: 10.2 MB

Nearly all our safety data collection and reporting systems are backwardlooking: incident reports; dashboards; compliance monitoring systems; and so on. This book shows how we can use safety data in a forward-looking, predictive sense. Predictive Safety Analytics: Reducing Risk through Modeling and Machine Learning contains real use cases where organizations have reduced incidents by employing predictive analytics to foresee and mitigate future risks. It discusses how Predictive Safety Analytics is an opportunity to break through the plateau problem where safety rate improvements have stagnated in many organizations. The book presents how the use of data, coupled with advanced analytical techniques, including machine learning, has become a proven and successful innovation. Emphasis is placed on how the book can “meet you where you are” by illuminating a path to get there, starting with simple data the organization likely already has. Highlights of the book are the real examples and case studies that will assist in generating thoughts and ideas for what might work for individual readers and how they can adapt the information to their particular situations. Data scientists speak of their workflow in terms of a pipeline. In fact, many modern software tools for data science build upon this concept to manage the tasks associated with building models. There is a myriad of ways pipelines are put forth, and no one scheme rules them all. Python is a broad programming language with strengths in manipulating data. A large variety of “libraries” are available that are purpose-driven, such as implementing a specific Machine Learning algorithm or a collection of algorithms.

Название: SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Автор: Angelo Bobak
Издательство: Apress
Год: 2023
Страниц: 1069
Язык: английский
Формат: pdf
Размер: 84.1 MB

This is a book on applying Microsoft SQL Server aggregate, analytical, and ranking functions across various industries for the purpose of statistical, reporting, analytical, and historical performance analysis using a series of built-in SQL Server functions affectionately known as the window functions! No, not window functions like the ones used in the C# or other Microsoft Windows application programming. They are called window functions because they implement windows into the data set generated by a query. These windows allow you to control where the functions are applied in the data by creating partitions in the query data set. “What’s a partition?” you might ask. This is a key concept you need to understand to get the most out of this book. Suppose you have a data set that has six rows for product category A and six rows for product category B. Each row has a column that stores sales values that you wish to analyze. The data set can be divided into two sections, one for each product category. These are the partitions that the window functions use. For intermediate to advanced SQL Server developers and data architects.

Название: Mastering SQL Joins: A Quick Handbook On Mastering SQL Joins With Practical Exercises
Автор: Dane Wade
Издательство: DataCeps
Год: 2023
Язык: английский
Формат: pdf, epub
Размер: 11.5 MB

Are you overwhelmed by SQL Joins?? Do you struggle to understand the concept of different SQL Joins? If Yes, then keep reading... Understanding the concept of SQL Joins is indeed a challenging task for many people. Combining data from multiple datasets and creating advanced queries leads to frustration and confusion. All you need is a resource that simplifies SQL joins and provides ample opportunities for practice. "Mastering SQL Joins: A Quick Handbook On Mastering SQL Joins With Practical Exercises" is your ultimate solution. This short handbook has everything you want to know about SQL as well as the hands-on challenges that'll equip you with skills to succeed. This book is not another dense theory-packed boring textbook filled with only technical jargon and fluff, which you need a computer science degree to understand. This is not just a textbook; this is an interactive practical handbook!

Название: Statistics and Data Science for Teachers
Автор: Anna Bargagliotti, Christine Franklin
Издательство: American Statistical Association
Год: 2021
Страниц: 248
Язык: английский
Формат: pdf
Размер: 34.9 MB

A main goal of Statistics and Data Science for Teachers is to provide teacher educators with a resource to guide entire courses and professional development, or portions of courses and professional development when preparing teachers of all school level grade levels to teach the foundations of statistics and data science in their classrooms. In supporting the spirit of Pre-K–12 Guidelines for Assessment and Instruction in Statistics Education II (GAISE II): A Framework for Statistics and Data Science Education, this book presents statistical ideas through investigations and engagement with the statistical problem-solving process of formulating statistical investigative questions, collecting/considering data, analyzing data, and interpreting results. The book is organized into three sections: 1) “Statistics as a Problem-Solving Process”; 2) “Toward Data Science”; 3) “Probability Unpacked”. Within each of these sections, standard topics of descriptive statistics, associations and relationships, distributions, probability, and sampling distributions are all developed.

Название: Halo data: Understanding and Leveraging the Value of your Data
Автор: Caroline Carruthers, Peter Jackson
Издательство: Facet Publishing
Год: 2023
Страниц: 180
Язык: английский
Формат: pdf, epub (true), mobi
Размер: 10.1 MB

The past two decades have seen an explosion both in the volume of data we use, and our understanding of its management. However, while techniques and technology for manipulating data have advanced rapidly in this time, the concepts around the value of our data have not. This lack of progress has made it increasingly difficult for organisations to understand the value in their data, the value of their data and how exploit that value. Halo Data proposes a paradigm shift in methodology for organisations to properly appreciate and leverage the value of their data. Written by an author team with many years' experience in data strategy, management and technology, the book will first review the current state of our understanding of data. This opening will demonstrate the limitations of this status quo, including a discussion on metadata and its limitations, data monetisation and data-driven business models. Following this, the book will present a new concept and framework for understanding and quantifying value in an organisation's data and a practical methodology for using this in practice. Ideal for data leaders and executives who are looking to leverage the data at their fingertips.

Название: Реляционные базы данных в примерах. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 1.0.24)
Страниц: 425
Язык: русский
Формат: pdf, djvu
Размер: 16.1 MB

Эта книга посвящена практическому взгляду на реляционную теорию и проектирование реляционных баз данных. Здесь не рассматриваются такие фундаментальные основы, как реляционная алгебра и реляционное счисление, но с множеством примеров и пояснений показаны основные понятия и подходы, необходимые для проектирования баз данных. Все схемы баз данных в этой книге приведены в нотации UML 2.1, созданы с использованием Sparx Enterprise Architect и (если речь идёт об уровнях проектирования, для которых это актуально) ориентированы на MySQL 8.0, Microsoft SQL Server 2019, Oracle 18c. Скорее всего, приведённые решения будут успешно работать на более новых версиях этих СУБД, но не на более старых.

Название: Работа с MySQL, MS SQL Server и Oracle в примерах. 2-е издание. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 2.0.28)
Страниц: 592
Язык: русский
Формат: pdf
Размер: 10.4 MB

Основное внимание в книге уделено практике использования SQL для решения типовых задач. В ней не рассматривается теория реляционных баз данных (предполагается, что вы с ней знакомы или сможете найти недостающую информацию), но представлено более 500 SQL-запросов: от базового выбора до использования представлений, триггеров, хранимых процедур и функций. Все примеры представлены в виде постановки и решения задач с использованием MySQL, MS SQL Server и Oracle, даны описания и анализ типичных ошибок. Все решения работают на MySQL Community Server 8.x, Microsoft SQL Server Express 2019 и Oracle 18c Express Edition и могут работать с более новыми версиями этих СУБД, но не будут работать со старыми версиями.

Название: Designing and Implementing Cloud-native Applications Using Microsoft Azure Cosmos DB: Study Companion for the DP-420 Exam
Автор: Steve Flowers
Издательство: Apress
Год: 2023
Страниц: 204
Язык: английский
Формат: pdf
Размер: 10.1 MB

This book will help prepare you for the Microsoft DP-420 exam. Whether you are new to Azure Cosmos DB or have experience working with the platform, Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB is organized to address the specific skills measured in the DP-420 exam. The topics covered include NoSQL models, code, and real-world scenarios aimed at helping you to understand and solve the case studies included in the exam. Beyond the exam, this book will assist you in your journey to adopt Microsoft Azure Cosmos DB for your own projects. You’ll learn what makes Azure Cosmos DB such a robust NoSQL service, as well as how NoSQL approaches help enable modern applications. You’ll also get practical guidance for your own implementations. The topics covered in this book are essential to knowing how to leverage the Cosmos DB service and provide best practices that will guide you to success both on the exam and in your career.