Название: Data Science and Machine Learning Applications in Subsurface Engineering
Автор: Daniel Asante Otchere
Издательство: CRC Press
Год: 2024
Страниц: 322
Язык: английский
Формат: pdf (true)
Размер: 27.5 MB

The utilization of Machine Learning (ML) techniques to understand hidden patterns and build data-driven predictive models from complex multivariate datasets is rapidly increasing in many applied science and engineering disciplines, including geo-energy. Motivated by these developments,Machine Learning Applications in Subsurface Energy Resource Management presents a current snapshot of the state of the art and future outlook for ML applications to manage subsurface energy resources (e.g., oil and gas, geologic carbon sequestration, and geothermal energy). It is known that many articles and texts prevent the reader from reproducing the results either because the data were not freely available or because the software was inaccessible, or only available for purchase. Therefore, it was my goal to be as hands-on as possible in stating the methods used, enabling the readers to reproduce the results and extend the methodology to their own data. Furthermore, the authors opted to use the Python language, an open-access software, for all stages of the Machine Learning process. Most of the chapters contain links to the data sets, Python notebooks, and software used here to reproduce the analyses in each chapter. I selected Python as the computational engine of this book for several reasons. First, Python is freely available for multiple operating systems. I encourage you to take the time to compare each of your solutions with the results in this book. Performing this comparison may help you become more familiar with a technique you could have used to solve a specific problem more efficiently.

Название: Querying Databricks with Spark SQL: Leverage SQL to query and analyze Big Data for insights
Автор: Adam Aspin
Издательство: BPB Publications
Год: 2024
Страниц: 638
Язык: английский
Формат: epub (true)
Размер: 37.4 MB

A practical guide to using Spark SQL to perform complex queries on your Databricks data. Databricks stands out as a widely embraced platform dedicated to the creation of data lakes. Within its framework, it extends support to a specialized version of Structured Query Language (SQL) known as Spark SQL. If you are interested in learning more about how to use Spark SQL to analyze data in a data lake, then this book is for you. The book covers everything from basic queries to complex data-processing tasks. It begins with an introduction to SQL and Spark. It then covers the basics of SQL, including data types, operators, and clauses. The next few chapters focus on filtering, aggregation, and calculation. Additionally, it covers dates and times, formatting output, and using logic in your queries. It also covers joining tables, subqueries, derived tables, and common table expressions. Additionally, it discusses correlated subqueries, joining and filtering datasets, using SQL in calculations, segmenting and classifying data, rolling analysis, and analyzing data over time. The book concludes with a chapter on advanced data presentation. Data is the lifeblood of the enterprise. Whether “Big Data” or the data stored in classic databases, it is queried using a variant of Structured Query Language (SQL). So, simply put, SQL is key to data analysis.

Название: A Power BI Compendium: Answers to 65 Commonly Asked Questions on Power BI
Автор: Alison Box
Издательство: Apress
Год: 2023
Страниц: 362
Язык: английский
Формат: pdf (true), epub
Размер: 69.9 MB

Are you a reasonably competent Power BI user but still struggling to generate reports that truly tell the story of your data? Or do you simply want to extend your knowledge of Power BI by exploring more complex areas of visualizations, data modelling, DAX, and Power Query? If so, this book is for you. This book serves as a comprehensive resource for users to implement more challenging visuals, build better data models, use DAX with more confidence, and execute more complex queries so they can find and share important insights into their data. The contents of the chapters are in a question-and-answer format that explore everyday data analysis scenarios in Power BI. These questions have been generated from the author’s own client base and from commonly sought-for information from the Power BI community. They cover a wide and diverse range of topics that many Power BI users often struggle to get to grips with or don’t fully understand. After working through this book, you will have extended your knowledge of Power BI to an expert level, alleviating your existing frustrations and so enabling you to design Power BI reports where you are no longer limited by your lack of knowledge or experience.

Название: SAP S/4HANA Asset Management: Configure, Equip, and Manage your Enterprise
Автор: Rajesh Ojha, Chandan Mohan Jaiswal
Издательство: Apress
Год: 2023
Страниц: 400
Язык: английский
Формат: pdf (true), epub
Размер: 33.4 MB

S/4HANA empowers enterprises to take big steps towards digitalization, innovation, and being mobile-friendly. This book is a concise guide to SAP S/4HANA Asset Management and will help you begin leveraging the platform’s capabilities quickly and efficiently. SAP S/4HANA Asset Management begins with an overview of the platform and its structure. You will learn how it can help with data storage and analysis, business processes, and reporting and analytics. As the book progresses, you will gain insight into single, time-based, performance-based, and multiple counter-based strategy plans. Any project is incomplete without a budget, and this book will help you understand how to use SAP S/4HANA to create and manage yours. The book’s real-life examples of asset management from contemporary industries reinforce each concept you learn, and its coverage of newer technologies and offerings in S/4HANA Asset Management will give you a sense of the immense potential offered by the platform. SAP S/4HANA Asset Management software is designed to encompass all the essential functionalities that can be utilized to address all the aspects as outlined.

Название: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming
Автор: Bill Karwin
Издательство: Pragmatic Bookshelf
Год: November 2022 (Version: P1.0)
Страниц: 379
Язык: английский
Формат: pdf (true), epub, mobi
Размер: 10.2 MB, 10.2 MB

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins. No matter which platform, framework, or language you use, the database is the foundation of your application, and the SQL database language is the standard for working with it. Antipatterns are solutions that look simple at the surface, but soon mire you down with needless work. Learn to identify these traps, and craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead to poor performance and quality, and master the principles that make SQL a powerful and flexible tool for handling data and logic.

Название: Data Analytics: A Theoretical and Practical View from the EDISON Project
Автор: Juan J. Cuadrado-Gallego, Yuri Demchenko
Издательство: Springer
Год: 2023
Страниц: 486
Язык: английский
Формат: pdf
Размер: 10.1 MB

Building upon the knowledge introduced in The Data Science Framework, this book provides a comprehensive and detailed examination of each aspect of Data Analytics, both from a theoretical and practical standpoint. The book explains representative algorithms associated with different techniques, from their theoretical foundations to their implementation and use with software tools. Designed as a textbook for a Data Analytics Fundamentals course, it is divided into seven chapters to correspond with 16 weeks of lessons, including both theoretical and practical exercises. Each chapter is dedicated to a lesson, allowing readers to dive deep into each topic with detailed explanations and examples. Readers will learn the theoretical concepts and then immediately apply them to practical exercises to reinforce their knowledge. And in the lab sessions, readers will learn the ins and outs of the R environment and Data Science methodology to solve exercises with the R language. With detailed solutions provided for all examples and exercises, readers can use this book to study and master data analytics on their own. Whether you're a student, professional, or simply curious about data analytics, this book is a must-have for anyone looking to expand their knowledge in this exciting field.

Название: EXCEL 2023: The Practical Step-by-Step Manual of Microsoft Excel for Learning Basic and Advanced Features, Formulas, and Charts with Easy and Clear Examples | From Beginner to Advanced in 7 days
Автор: Alan Roberts
Издательство: Bonus Liber Publishing
Год: January 2023
Страниц: 248
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Welcome to “Excel 2023 - From Beginner to Advanced in 7 days”, the ultimate guide to mastering Microsoft Excel in just one week! Are you tired of feeling lost and overwhelmed when it comes to using Excel? Do you struggle to create and format spreadsheets, perform calculations, and analyze data? If so, then this book is for you. You'll learn everything you need to know to become an Excel expert in just 7 days. With our help, you may learn the essentials of MS Excel and get started right away. Everything from the fundamentals, such as data sorting and cell formatting, to more advanced functions, such as making charts and graphs, will be covered. You'll also discover why learning this software is so important—it can help you in a variety of ways! You can use Excel to present information, organize data for analysis, create sophisticated spreadsheets with numbers or text, and so on. I am confident that at the end of this guide, you will have a clearer understanding and be able to achieve all of these things and more.

Название: Культин Microsoft Excel 2010. Самое необходимое
Автор: Культин Н.Б., Цой Л.Б.
Издательство: БХВ-Петербург
Год: 2010
Страниц: 208
Формат: PDF
Размер: 10.3 Мб
Язык: русский

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

Название: Windows Vista + Microsoft Office 2007. Самоучитель
Автор(ы): Минеева Н.А. и др.
Издательство: НиТ
Год: 2008
Страниц: 592
Формат: PDF
Размер: 58 Мб
Язык: русский

В этой книге рассматриваются два самых главных программных пакета, которые вышли совсем недавно и с которыми должен быть знаком каждый пользователь ПК: новейшая операционная система Windows Vista и офисный пакет последнего поколения Microsoft Office 2007. В первой части книги вы найдете все, что нужно для эффективной работы с Windows Vista: установка и настройка системы, фирменный трехмерный интерфейс, работа с файлами и папками, особенности и специальные возможности системы как, например, встроенный центр развлечений Windows Media Center, функция Родительского контроля, позволяющая разграничить работу на компьютере, и т.д. Вторая часть книги посвящена программам, входящим в состав офисного пакета Microsoft Office 2007.

Название: Изучаем SQL и MySQL: С легкостью извлекайте данные и манипулируйте ими с помощью команд SQL
Автор: Паджанкар А.
Издательство: BPB Publications
Год: 2023
Формат: pdf, djvu
Размер: 10 Мб
Качество: Хорошее
Язык: Русский

Эта книга представлят собой пошаговое руководство, которое поможет вам с легкостью управлять данными в реляционной базе данных MySQL или MariaDB с помощью SQL-запросов.Книга начинается со знакомства с концепций систем управления реляционными базами данных и SQL (языка структурированных запросов). Первые несколько глав содержат определения и краткое объяснение всех важных понятий. Они также охватывают описание роцесса установки MariaDB и MySQL в среде Windows и Raspberry Pi, а также настройку различных инструментов, используемых для подключения серверам MySQL и MariaDB.