Название: PostgreSQL Mistakes and How to Avoid Them (Final Release)
Автор: Jimmy Angelakos
Издательство: Manning Publications
Год: 2025
Страниц: 234
Язык: английский
Формат: pdf (true), epub
Размер: 15.5 MB

Recognize and avoid these common PostgreSQL mistakes! The best mistakes to learn from are ones made by other people! In PostgreSQL Mistakes and How To Avoid Them you'll explore dozens of common PostgreSQL errors so you can easily avoid them in your own projects, learning proactively why certain approaches fail and others succeed. As PostgreSQL continues its rise as a leading open source database, mastering its intricacies is crucial.PostgreSQL Mistakes and How To Avoid Them is full of tested best practices to ensure top performance, and future-proof your database systems for seamless change and growth. Each of the mistakes is carefully described and accompanied by a demo, along with an explanation that expands your knowledge of PostgreSQL internals and helps you to build a stronger mental model of how the database engine works. Fixing mistakes in PostgreSQL databases can be time-consuming and risky—especially when you're making live changes to an in-use system. Fortunately, you can learn from the mistakes other Postgres pros have already made! For PostgreSQL database administrators and application developers.

Название: 96 Common Challenges in Power Query: Practical Solutions for Mastering Data Transformation in Excel and Power BI
Автор: Omid Motamedisedeh
Издательство: Apress
Год: 2025
Страниц: 675
Язык: английский
Формат: pdf
Размер: 35.8 MB

This comprehensive guide is designed to address the most frequent and challenging issues faced by users of Power Query, a powerful data transformation tool integrated into Excel, Power BI, and Microsoft Azure. By tackling 96 real-world problems with practical, step-by-step solutions, this book is an essential resource for data analysts, Excel enthusiasts, and Power BI professionals. It aims to enhance your data transformation skills and improve efficiency in handling complex data sets. Structured into 12 chapters, the book covers specific areas of Power Query such as data extraction, referencing, column splitting and merging, sorting and filtering, and pivoting and unpivoting tables. You will learn to combine data from Excel files with varying column names, handle multi-row headers, perform advanced filtering, and manage missing values using techniques such as linear interpolation and K-nearest neighbors (K-NN) imputation. Additionally, it covers crucial topics such as error-handling strategies, custom function creation, and the integration of Python and R with Power Query.

Название: MATLAB 3-D Visualization (R2025a)
Автор: MathWorks
Издательство: The MathWorks, Inc.
Год: March 2025
Страниц: 116
Язык: английский
Формат: pdf (true), epub
Размер: 10.1 MB

MATLAB graphics defines a surface by the z-coordinates of points above a rectangular grid in the x-y plane. The plot is formed by joining adjacent points with straight lines. Surface plots are useful for visualizing matrices that are too large to display in numerical form and for graphing functions of two variables. MATLAB can create different forms of surface plots. Mesh plots are wire-frame surfaces that color only the lines connecting the defining points. Surface plots display both the connecting lines and the faces of the surface in color.

Название: Data Preparation for AI and Analytics (MEAP V03)
Автор: Benoît Cayla
Издательство: Manning
Год: 2025
Формат: pdf, epub
Страниц: 327
Размер: 15.0 Мб
Язык: английский

Excellent data quality makes for excellent data insights! The Data Preparation for AI and Analytics is a practical guide to cleaning and organizing the messy, tangled data you’ll encounter in the real world. You’ll learn techniques you can use to get your data ready for almost any task—from reports and analysis, to building machine learning models.

Название: Секреты поведения людей
Автор(ы): Таранов П.С.
Издательство: Фаир-Пресс
Год: 1998
Страниц: 545
Формат: DJVU
Размер: 11 Мб
Язык: русский

Эта книга для тех, кто любит трудиться и кому по роду занятий необходимы осторожность в риске, дальновидность в мудрости, возвышенность в благоразумии.

Название: Data Analysis Excel Book: The Complete Microsoft Excel Guide to Master Powerful Techniques to Drive Data Insights and Smart Decisions
Автор: Harjit Suman
Издательство: Independently published
Год: 2025
Страниц: 209
Язык: английский
Формат: epub
Размер: 18.4 MB

Master Excel Like a Pro – Unlock Hidden Data Insights and Make Smarter Decisions! Are you tired of struggling with Excel, feeling overwhelmed by complex data, or unsure how to turn raw numbers into powerful insights? This Excel book is your ultimate solution. This book is designed to help you harness the full potential of Excel for data analysis, from basic techniques to advanced automation using VBA. Through practical examples, step-by-step instructions, and real-world case studies, this book will guide you through the essential tools and techniques needed to clean, organise, and analyse data efficiently. Whether you're working with financial reports, sales data, or supply chain metrics, you will gain the confidence to extract meaningful insights and make data-driven decisions with ease. Whether you're an intermediate or advanced Excel user, a professional looking to sharpen your data skills, or a student aiming to master data-driven decision-making, this Excel guide will transform the way you work with data.

Название: MongoDB in Action: Building on the Atlas Data Platform, Third Edition (MEAP v8)
Автор: Arek Borucki
Издательство: Manning Publications
Год: 2025
Страниц: 772
Язык: английский
Формат: pdf, epub
Размер: 19.2 MB

Deliver flexible, scalable, and high-performance data storage that's perfect for AI and other modern applications with MongoDB 8.0 and MongoDB Atlas Multi-cloud Developer Data Platform. In MongoDB in Action, Third Edition you'll find comprehensive coverage of the latest version of MongoDB 8.0 and the powerful MongoDB Atlas Multi-cloud Developer Data Platform. Learn how to deliver data flexibility with MongoDB's schema-less design, make your apps scalable with its sharding capabilities, power full text and semantic search, use the Retrieval Augmented Generation pattern, implement powerful stream processing, and more. This totally revised new edition delivers engaging hands-on tutorials and examples that put MongoDB into action! One of the key projects in this book will guide you through building an AI chatbot using the Retrieval-Augmented Generation (RAG) model with MongoDB Atlas, LangChain and OpenAI. For readers of all experience levels. If you're a beginner, you'll be carefully and quickly brought up to speed with MongoDB. If you're a Mongo veteran, you'll benefit from the book's practical insights into the latest features of MongoDB 8.0 and Atlas Multi-cloud Developer Data Platform.

Название: MUMPS СУБД. Практика применения и опыт программирования
Автор: Каратаев Е.
Издательство: СОЛОН-Пресс
Год: 2018
Cтраниц: 550
Формат: pdf
Размер: 48 мб
Язык: русский

Книга описывает среду исполнения, принципы организации данных в MUMPS системах и технические вопросы их применения. Описываются языковые средства, принципы обработки ошибок, алгоритмика работы с индексами, принципы внешнего взаимодействия и многое другое. Книга может быть полезна как квалифицированным разработчикам в виде справочника, так и изучающим компьютерные технологии.

Название: Microsoft Word and Excel Simplified: The Ultimate Beginner’s Guide : Master Essential Functions to Write, Organize, Boost Productivity, Data Management, and Analyze with Confidence and Ease
Автор: David Twain
Издательство: Independently published
Год: 2025
Страниц: 206
Язык: английский
Формат: epub
Размер: 10.1 MB

Master Essential Functions to Write, Organize, Boost Productivity, Manage Data, and Analyze with Confidence and Ease! Struggling with Microsoft Word or Excel? Want to create professional documents and powerful spreadsheets with ease? This step-by-step guide is designed for absolute beginners and anyone looking to sharpen their skills! Microsoft Word is a word processing application developed by Microsoft. It is part of the Microsoft Office Suite and is designed to help users create, edit, format, and share text-based documents. Whether it’s a simple letter, an academic paper, a professional resume, or a marketing brochure, Word provides tools for a variety of tasks. Microsoft Excel is a powerful spreadsheet software program used for organizing, analyzing, and visualizing data. It is part of the Microsoft Office Suite and is widely used across different industries for tasks such as financial analysis, data management, budgeting, and project planning. Excel allows you to store data in cells that are organized into rows and columns. With Excel, you can perform complex calculations, create charts and graphs, and automate tasks through macros and advanced functions. Whether you’re a student, a professional, or someone who just wants to get better at Word and Excel, this guide unlocks the power of both tools in a simple and practical way.

Название: Визуализация данных при помощи дашбордов и отчетов в Excel
Автор: Куслейка Д.
Издательство: ДMK
Год: 2021 (2022)
Cтраниц: 338
Формат: pdf
Размер: 19 мб
Язык: русский

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