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

Название: SAP Analytics Cloud Performance Optimization Guide
Автор: Erik Bertram, Carl Dannenhauer, Melanie Holzapfel, Sandra Loop
Издательство: Rheinwerk Publishing/SAP Press
Год: 2023
Страниц: 310
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

Frustrated with slow performance in SAP Analytics Cloud? This guide is your answer! Learn the basics of solution performance and optimization and then start making your adjustments: get the story builder and analytics designer apps running smoothly, fine-tune your backend settings, and follow best practices for viewing dashboards. With detailed examples of performance improvements throughout, this book has everything you need for an optimal SAP Analytics Cloud experience! Whether you are new to SAP Analytics Cloud or are already a skilled app designer or developer does not really matter because all groups might find different aspects that they might not have known before on how to optimize the dashboard performance. All these tips and tricks are also closely aligned with our in-house development organization, which means that you get hands-on information directly from the right source. Thus, what you can expect is a book that provides technical insights into performance optimizations while guiding you through building the correct dashboard step by step.

Название: ChatGPT Cheat Sheet for Data Science
Автор: DataCamp
Издательство: DataCamp
Год: 2023
Язык: английский
Формат: pdf
Размер: 29.4 MB

In this cheat sheet, gain access to 60+ ChatGPT prompts for data science tasks. ChatGPT has taken the (data) world by storm and is growing to be one of the more useful tools out there across a variety of tasks. In this cheat sheet, we'll focus on useful prompts data scientists can use in ChatGPT as part of their data workflows.

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