Название: 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.

Название: Excel 2023: From Beginner to Expert in 7 Days with a comprehensive, illustrated guide covering all functions and formulas with simple, clear examples
Автор: Alan Dinkins
Издательство: Independently published
Год: 2023
Страниц: 110
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Unlock the Power of Excel 2023: Transform Your Data Skills from Novice to Ninja in Just 7 Days! Are you overwhelmed by the vast capabilities of Excel and unsure where to start? Do you wish to harness the full potential of Excel for your professional growth, but feel bogged down by its complexity? Or perhaps you're seeking a comprehensive guide that not only introduces you to the basics but also dives deep into advanced tricks, ensuring you're equipped for any Excel challenge? Introducing "Excel 2023: From Beginner to Expert in 7 Days" - Your one-stop solution to mastering the world's most powerful spreadsheet software! Excel 2023 is not just another software; it's a game-changer. When wielded right, it can skyrocket your efficiency, make data analysis a breeze, and turn you into the go-to person for any data-related task. But, without the right guidance, it can seem daunting. This meticulously crafted guideis designed with one goal in mind: To take you, regardless of your starting point, to Excel mastery. Whether you're a newbie just starting out or someone looking to refine their skills, this book has got you covered.

Название: The Complete Linux Coding Manual - 19th Edition, 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Страниц: 148
Язык: английский
Формат: pdf
Размер: 76.2 MB

Linux присутствует повсюду. Она используется в Интернете в качестве основной операционной системы для серверов Web, на ней работают космические корабли, она является операционной системой для самых быстрых суперкомпьютеров в мире, она используется в "умных" телевизорах и мобильных устройствах. Почему? Потому что она сверхстабильна, молниеносна и совершенно бесплатна. Однако Linux - это не просто бесплатная операционная система. Ее уникальная конфигурация позволяет пользователю настраивать и персонализировать ОС по своему усмотрению. Пользователь Linux может менять внешний вид своей операционной системы от одного дня к другому, устанавливать тысячи свободно распространяемых приложений и программ и возвращать контроль над своим компьютером. Linux - это свобода. Свобода от "замкнутого сада" других ограничивающих операционных систем, свобода выбора того, что вы хотите видеть на своем компьютере, свобода изменять его и использовать по своему усмотрению.

Название: 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.

Название: Using and Administering Linux: Volume 1: Zero to SysAdmin: Getting Started, 2nd Edition
Автор: David Both
Издательство: Apress
Год: 2023
Страниц: 667
Язык: английский
Формат: pdf, epub
Размер: 29.0 MB

Learn to be a Linux sysadmin and an expert user of the Linux operating system, even with no previous Linux experience. This second edition of the popular and highly rated Linux self-study training course has been fully updated to Fedora Linux 37 with expanded and revised content and figures as well new chapters on the BTRFS file system, using Zram for swap, NetworkManager, automation with Ansible, and systemd. Like the previous version, this edition has been reviewed for technical accuracy by a highly respected Linux expert and will prepare you to manage complex systems with ease and equip you for a new career. It has also been reviewed by a student who took this course to ensure its readability and flow for those with little or no previous experience with Linux. In this first volume of the training course series, you will learn about operating systems in general and Linux in particular, and explore the Linux philosophy for SysAdmins in preparation for the rest of the course. This book provides you with the tools necessary for mastering user management; installing, updating, and deleting software; and using command line tools to do performance tuning and basic problem determination.

Название: Building Real-Time Analytics Systems: From Events to Insights with Apache Kafka and Apache Pinot (Final)
Автор: Mark Needham
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 218
Язык: английский
Формат: True EPUB (Retail Copy)
Размер: 10.1 MB

Gain deep insight into real-time analytics, including the features of these systems and the problems they solve. With this practical book, data engineers at organizations that use event-processing systems such as Kafka, Google Pub/Sub, and AWS Kinesis will learn how to analyze data streams in real time. The faster you derive insights, the quicker you can spot changes in your business and act accordingly. Author Mark Needham from StarTree provides an overview of the real-time analytics space and an understanding of what goes into building real-time applications. The book's second part offers a series of hands-on tutorials that show you how to combine multiple software products to build real-time analytics applications for an imaginary pizza delivery service. Tools and platforms such as Apache Kafka (for data streaming), Apache Flink (stream processing), Apache Pinot (data analytics) and Apache Superset (data visualization) provide an excellent foundation for real-time analytics and have seen a tremendous uptake over the last years. At the same time, getting started with implementing your first use cases can be challenging, and you might ask yourself questions such as these: Which tools to choose for which purpose? How to put the individual pieces together for a coherent solution?

Название: Interaction Data Analytics: Methods, Tools, and Applications
Автор: Vagner Figueredo de Santana
Издательство: Leanpub
Год: 2023-04-16
Язык: английский
Формат: pdf (true)
Размер: 17.4 MB

Most of the analytics tools available focus on assessing customer clicks, but have you ever thought about how little we know about what happens in between clicks? In this book we present methods, tools, and applications so that you can start uncovering the value of multiple interaction data available when people interact with computing systems. Interaction logs are present in the most diverse platforms, from mainframes to mobile devices. Interaction data analytics gained visibility with the advent of e-commerce in the late 90s. Analytics in e-commerce aims at analyzing the most viewed/bought products, the origin of accesses, or even understanding why users gave up on buying something. These goals promoted the development of multiple tools in the area. However, when we analyze these tools considering detailed interaction data beyond click streams –with user experience, accessibility, and usability in mind–, few tools allow evaluators to get details about how a given interaction occurred. This book aims at supporting software engineers, software architects, developers, designers, HCI (Human-Computer Interaction) practitioners, and Data Scientists to consider nuances and particular characteristics of interaction logs, surpassing challenges, and gaining insights from these interaction traces as much as possible, always having accessibility and usability in mind.

Название: Windows 11 Kickstart: A Comprehensive & Handy Guide For Beginners and Seniors
Автор: Anand Narayanaswamy
Издательство: Leanpub
Год: 2023
Страниц: 285
Язык: английский
Формат: pdf (true)
Размер: 14.1 MB

Windows 11 Kickstart teaches all the core aspects of Windows 11 operating system in a simple style. The book is designed to serve as a perfect study material for beginners and students including senior citizens who would like to learn the nuances of Windows 11 without any assistance. Windows 11 Kickstart teaches all the core aspects of the Windows 11 operating system in a simple style. The book is designed to serve as a perfect study material for beginners and students including senior citizens who would like to learn the nuances of Windows 11 without any assistance. The Windows 11 Kickstart book is supplemented with plenty of images. Moreover, the additional content inside boxes amplifies the learning process to great extent. The book also provides a short history of Microsoft Windows operating system and the computer basics. Towards the end of reading this book, readers will be able to work with Windows 11 quickly with maximum productivity.

Название: Pro Exchange Administration: Understanding On-premises and Hybrid Exchange Deployments, 3rd Edition
Автор: Jaap Wesselius. Michel de Rooij
Издательство: Apress
Год: 2023
Страниц: 941
Язык: английский
Формат: pdf, epub
Размер: 24.1 MB

Move to the current version of Exchange Server, whether it be stand-alone, on-premises, or in a hybrid configuration with Exchange Online. This book provides background information on Exchange 2019, and teaches you how to bring it up to date and keep it up to date in a consistent state. The book starts with an introduction to Exchange Server, Active Directory, Exchange Online, and Azure Active Directory (AD). It takes you through designing and installing Exchange Server and guides you in managing it. You will learn Microsoft 365 integration with Azure AD in your Exchange Server. Moving to Exchange Online, Mail Flow, and authentication are discussed so you will better understand hybrid transport. The book shows you how to secure your Exchange Server with Azure App Proxy, message hygiene, and multi-factor authentication. Also covered are compliance needs for business firms such as backup and restore, message records management, auditing, and information rights management. After reading this book, you will not only be able to install, configure, and maintain Exchange Server, but you will also know how to secure and monitor the environment.