Название: Эффективная работа в Microsoft Excel
Автор: Мюррей А.
Издательство: Москвa
Год: 2021
Cтраниц: 275
Формат: pdf
Размер: 30 мб
Язык: русский

В книге обсуждаются продвинутые техники работы в табличном редакторе Microsoft Excel, о которых знают не все пользователи и которые заметно ускоряют выполнение стандартных операций.

Название: Excel Hacker: Advanced Excel with Python
Автор: Hayden Van Der Post
Издательство: Reactive Publishing
Год: 2023
Формат: epub, pdf
Страниц: 200
Размер: 15.2 Мб
Язык: английский

Unleash the Power of Data with "Excel Hacker: Advanced Excel with Python". Are you ready to transform your career and become a data wizard? Dive into the world of data analysis, automation, and machine learning with "Excel Hacker: Advanced Excel with Python." This groundbreaking guide is your ticket to mastering Excel like never before.

Название: Vector Databases for Enterprise AI: Semantic Retrieval Systems for RAG, Search, and AI Applications
Автор: Emma McGrattan
Издательство: O’Reilly Media, Inc.
Год: 2026
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Enterprise Generative AI has reached a turning point. Pilots have proven the models work. What's struggling is the infrastructure underneath them. Semantic search, RAG, and agentic workflows require data retrieval based on meaning and similarity, not keywords and exact matches. Better models won't fix an architecture that was never designed for this kind of reasoning. Enterprise data platforms are shaped by who and what consumes data. For most of their history, that consumer was human. Analysts wrote SQL queries, applications executed deterministic transactions, and dashboards reflected predefined metrics. The systems we built, including databases, search engines, and pipelines, were optimized for precision, predictability, and structure. Those assumptions held for decades, and they still matter today. The adoption of large language models (LLMs) and AI-driven applications introduces a different kind of consumer. This shift does not make traditional databases obsolete, but it does expose clear limits to how they support semantic access to information. Vector databases are an architectural response to this shift. By storing and retrieving embeddings (numerical representations that capture the meaning of text, images, or other data), vector databases enable AI systems to find relevant data without relying solely on schema or exact matches.

Название: Optimizing Your Apache Iceberg Lakehouse: Improving Performance and Scalability (Early Release)
Автор: Lester Martin
Издательство: O’Reilly Media, Inc.
Год: 2026-04-22
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

Iceberg data lakehouse architecture leverages the widely accepted Apache Iceberg open table format to deliver superior features through enhanced metadata handling. But understanding Iceberg conceptually is only the beginning. To benefit from its architecture, you need to know how it works, how to apply it to real tasks, and how to optimize it effectively. It’s time to dig deeper into the architecture underlying Apache Iceberg. Like all data lakehouse table formats, Iceberg is built on the model of collocating many large files with the same file format and logical structure in a repository, accessed as if they were a traditional RDBMS table. Unlike RDBMS technologies, data lakehouses clearly separate storage from compute. A repository full of data files and scalable processing capacity is not enough for lakehouses; we need metadata to complete the picture.

Название: Statistical Hypothesis Testing with Microsoft Office Excel, Second Edition
Автор: Robert Hirsch
Издательство: Springer
Год: 2026
Страниц: 116
Язык: английский
Формат: pdf (true), epub
Размер: 10.5 MB

This book provides a comprehensive treatment of the logic behind hypothesis testing. This updated edition covers frequentist (classical) and Bayesian approaches to interpretation of the results of a statistical hypothesis test. In a new chapter, nonparametric hypothesis testing is also discussed. The author describes the most commonly used statistical tests and provides instructions for how to perform them using Microsoft Office Excel. Readers will learn how to interpret P-values under a variety of conditions including a single hypothesis test, a collection of hypothesis tests, and tests performed on accumulating data. This new edition includes the chi-square test as a method for nominal data. The author provides frameworks for how to plan the size of a sample and how to select which test to use for a data set. This second edition will be of interest to researchers, graduate students, and anyone who has to interpret the results of statistical analyses.

Название: Big dаta: Modern Tools and Techniques
Автор: Bahaaeddin Alareeni
Издательство: Springer
Серия: Studies in Big Data
Год: 2026
Страниц: 381
Язык: английский
Формат: pdf (true), epub
Размер: 41.3 MB

This book shows how to transform Big Data, AI, and digital technologies into powerful tools for smarter decisions, stronger strategies, and sustainable growth. Data is everywhere—but only those who know how to use it can truly lead. This book aims to bridge the gap between data abundance and data intelligence. It offers a clear, practical roadmap for navigating the complexities of Big Data, Artificial Intelligence, Machine Learning, and digital transformation. More than just a technical manual, it serves as a strategic guide for business leaders, analysts, and professionals seeking to unlock the full value of their data assets. Packed with real-world examples and practical insights, it equips leaders, analysts, and professionals to navigate today’s data-driven world with clarity and confidence. Whether in finance, marketing, or digital banking, this book reveals how data can be your greatest asset for innovation and success.

Название: Understanding dаta: A 21st Century Approach to Statistics and Data Science
Автор: Alan Garfinkel, Yina Guo
Издательство: Springer
Год: 2026
Страниц: 674
Язык: английский
Формат: pdf (true)
Размер: 182.7 MB

This text introduces statistics to beginning students in a distinctly original and non-traditional way. It assumes minimal mathematical or statistical background, yet offers substantial depth that will also engage experienced practitioners. Motivated by the growing call to move beyond the statistical practices and concepts that contributed to the current “reproducibility crisis,” the book encourages readers to rethink what statistics is, how it is used, and how it should be taught. Instead of memorizing formulas that were derived as approximations under unrealistic assumptions, modern computing enables us to simulate scenarios thousands of times in seconds and simply count outcomes. Taking this computational approach as fundamental, the book provides thorough coverage of the material, including describing and presenting data, two-group and multi-group comparisons, correlation, regression, statistical power and Bayesianism, deliberately forgoing many standard techniques in favor of simulation-based methods. The text is filled with worked examples using real data, computer code (examples in Python), and practical guidance for presenting results effectively. Diagrams and figures enhance readability, and the resampling illustrations in particular provide intuitive visual cues that clarify the underlying processes.

Название: Linux Mint 20 Self Help Guide, 2nd Edition: Unofficial and Compatible With All Linux Mint 20 Versions
Автор: Morgan Partridge
Издательство: Independently published
Год: 2022
Страниц: 535
Язык: английский
Формат: epub
Размер: 12.5 MB

Updating Linux Mint 20.03; Audio Editors; Cloud Backup; Cloud Office Suites; Communication; Compatibility Layers (WINE); Cryptocurrency Wallets; Data Recovery; Desktop Environments; Download Managers; Ebook Readers; Elder Gaming; File Compression and Extraction; Image Editors; Internet Video Broadcasting; Media Player; Modern Gaming (WINE, Lutris, Steam et all.); Music On Demand Streaming; Music Players; PDF Readers; Remote Working...

Название: MATLAB Database Toolbox User's Guide (R2025b)
Автор: MathWorks
Издательство: The MathWorks, Inc.
Год: September 2025
Страниц: 1400
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

Exchange data with relational and nonrelational databases. Database Toolbox provides functions and an app for exchanging data with relational and nonrelational databases. It enables this exchange by automatically converting between database and MATLAB data types. Database Toolbox provides functions and an app for interacting with relational and NoSQL databases. The toolbox supports any ODBC-compliant or JDBC-compliant relational database and provides NoSQL support for Apache Cassandra, MongoDB, and Neo4j. Native interfaces for MySQL, PostgreSQL, and SQLite provide functionality that streamlines interaction with your database. The interfaces ship with third-party drivers that connect to your database in deployed and cloud environments without additional setup or installation. Database Toolbox provides direct read and write workflows for novice users and fine-grained control for advanced users who are familiar with SQL. With the Database Explorer app, you can explore relational data interactively and generate MATLAB code to automate or operationalize database workflows.

Название: New Perspectives Microsoft 365 Excel Comprehensive, First Edition
Автор: Patrick Carey
Издательство: Cengage Learning
Год: 2025
Страниц: 863
Язык: английский
Формат: pdf (true)
Размер: 58.2 MB

Using a unique in-depth, case-based approach, Carey's NEW PERSPECTIVES MICROSOFT 365 EXCEL COMPREHENSIVE, FIRST EDITION, thoroughly prepares you for the Microsoft Office Specialist (MOS) certification exam and success in your future career. As you apply Microsoft Office skills to real-world business scenarios based on data from market insights, you will sharpen your critical-thinking and problem-solving skills. Professional skills, tips and insights incorporated throughout provide context and relevancy to real-world practice. The text also offers updated coverage of Microsoft 365 features as well as enhanced support for Mac users. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) digital resources provide interactive study tools to help maximize your study time -- and results.