Название: Ultimate Excel with Power Query and ChatGPT: Master MS Excel's Dynamic Lookup Functions, Generative AI, and Power Query to Navigate Data, Solve Complex Tasks and Optimize Productivity
Автор: Crispo Mwangi
Издательство: Orange Education Pvt Ltd, AVA
Год: December 2023
Страниц: 228
Язык: английский
Формат: True/Retail EPUB
Размер: 12,4 MB

Transform Your MS Excel Skills with this Ultimate Guide for Professional Success. The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel's lookup functions. The book dives deep into Excel's lookup universe, offering a meticulous exploration of over 100 techniques. Each method is presented with clarity and precision, making even the most complex lookup scenarios comprehensible. From traditional functions to innovative problem-solving approaches, this book equips you with versatile tools to navigate any data challenge efficiently. What sets this book apart is its focus on job roles. You'll discover techniques that directly enhance productivity, streamline data management tasks, and elevate your efficiency in Excel-related responsibilities. With a comprehensive, engaging, and interactive approach, it transforms learning Excel formulas into a journey of building practical data lookup expertise. The book is tailored to address specific needs within different job roles, making it accessible and beneficial for a wide range of readers. If you are a working professional seeking to improve your Excel data lookup skills, a student in search of an interactive approach to Excel formulas, managers looking to make data-driven decisions or data analysts aiming to refine their skills or simply looking to start your career in data analysis, this book is for you.

Название: MongoDB Fundamentals
Автор: Theophilus Edet
Издательство: CompreQuest Books
Серия: Mastering Database Management Series
Год: 2023
Страниц: 333
Язык: английский
Формат: pdf
Размер: 28.8 MB

Unlock the Power of Data in the Digital Age with "MongoDB Fundamentals"! In the ever-evolving landscape of modern website development, data is the backbone of innovation. Meet MongoDB, the game-changer that empowers developers to revolutionize the way they conceive, store, and retrieve information. This comprehensive guide unravels the depths of MongoDB, offering a roadmap for harnessing its capabilities to propel your applications to new heights. Why MongoDB in Modern Website Development? Traditional databases are like rigid blueprints, constraining your creativity and adaptability. Enter MongoDB, the NoSQL database that flips the script. Its document-oriented, schema-less design allows developers to sculpt data structures as fluidly as their ideas evolve. Whether you're crafting a dynamic e-commerce platform, a responsive mobile app, or a data-intensive analytics system, MongoDB's flexibility is your secret weapon. Dear Developer, the time is now to embrace the rare benefits of MongoDB in your applications. This book is your gateway to understanding and implementing MongoDB's capabilities. Let go of the constraints of traditional databases and step into a world where your creativity knows no bounds. Dive into the fundamentals, experiment with concepts, and see MongoDB in action. This isn't just a guide; it's your hands-on companion to unlocking MongoDB's full potential.

Название: Excel: от новичка до продвинутого пользователя
Автор: Осипов Е.А., Александрова И.Л., Филиппова И.А.
Издательство: Казань: Казанский федеральный университет
Год: 2022
Формат: pdf
Страниц: 72
Размер: 13 mb
Язык: Русский

Данное пособие составлено в соответствии с современной структурой изучения дисциплин и является дополнением к курсу «Excel: от новичка до продвинутого пользователя». В пособии рассмотрены задачи по работе с табличными данными, математическими и логическими функциями, построению графиков и диаграмм с применением табличного редактора Microsoft Excel 2021 из пакета прикладного программного обеспечения Microsoft Office 2021 под управлением операционной системы Windows.

Название: Hardware and Software Projects Troubleshooting: How Effective Requirements Writing Can Save the Day, 2nd Edition
Автор: George Koelsch
Издательство: Apress
Год: 2023
Страниц: 561
Язык: английский
Формат: pdf
Размер: 10.2 MB

Learn how to create good requirements when designing hardware and software systems. While this book emphasizes writing traditional “shall” statements, it also provides guidance on use case design and creating user stories in support of agile methodologies. The book surveys modelling techniques and various tools that support requirements collection and analysis. You’ll learn to manage requirements, including discussions of document types and digital approaches using spreadsheets, generic databases, and dedicated requirements tools. Good, clear examples are presented, many related to real-world work the author has performed during his career. More importantly, you will learn how these techniques can prevent the problems that occur during requirements development. Most of all, you will learn how good requirements governance will greatly increase the success of development projects by getting all people involved to eliminate the adverse impacts to requirements throughout the development lifecycle. Writing requirements is the most crucial aspect of systems engineering (SE). In this book, you will learn the best way to accomplish this. You will explore the requirements world, you will use the best tools, and you will learn to employ these tools. This book is intended for those of you who consider yourselves as beginners or maybe advancing to an intermediate level.

Название: Сбор данных в Интернете на языке R
Автор: Храмов Д.А.
Издательство: Москва
Год: 2017
Cтраниц: 280
Формат: pdf (ocr)
Размер: 47 мб
Язык: русский

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

Название: Руководство по диагностике и устранению проблем в Oracle
Автор: Фарук Т., Олт М., Португал П., Хури М., Хуссейн С. Дж., Чупрински Дж., Хэррисон Г.
Издательство: Москва
Год: 2017
Cтраниц: 500
Формат: pdf (ocr)
Размер: 16 мб
Язык: русский

Книга предоставляет исчерпывающие и актуальные рекомендации по обеспечению надежной и эффективной работы СУБД Oracle в сложных производственных корпоративных средах. Семь ведущих экспертов по Oracle объединили свои усилия, чтобы создать не имеющий аналогов сборник испытанных решений, практических примеров и пошаговых описаний процедур для Oracle версий 12c, 11g и более поздних.

Название: Indexing Beyond the Basics
Автор: Tobias Petry
Издательство: Independently published
Год: 2023
Язык: английский
Формат: pdf (true), epub
Размер: 20.7 MB

Learn to create indexes for your slow queries by following simple principles. Hi! I'm Tobias Petry, a full stack developer who used to suck at writing fast database queries. Whenever I had a slow query, I needed to ask more advanced developers for help and hope they had time for me. Like everyone, I always wished I could solve those problems on my own. But even after reading some tutorials I didn't get any closer to my goal. The number of queries I couldn't optimize by far exceeded the ones I could make faster. So I learned everything about databases over the next 10+ years from countless books, conferences, trainings, articles and much practice. Finally, I could fix any slow query entirely without help. But during my consulting work I found that most developers still face the same problem. The reason database indexes are still not understood by developers is the depth of the existing content. Whether it is books, articles or videos - they all have their own problems that limit the ability to understand database indexing. You are a developer who can write SQL queries but struggle with creating the correct indexes to make them fast. Neither do you have the time or interest to learn this topic in weeks - a couple evenings on the couch should be enough. You also just want to learn the practical knowledge necessary to complete your task and move on to other things. The content should avoid any technical complex database implementation details - you want the core information quickly, concisely and understandably.

Название: ADO.NET Data Access Technology With C#
Автор: Theophilus Edet
Издательство: CompreQuest Books
Серия: Mastering Database Management Series
Год: 2023
Страниц: 482
Язык: английский
Формат: pdf
Размер: 33.2 MB

Unlock the full potential of data access and supercharge your C# skills with our comprehensive course on ADO.NET. With 24 modules carefully crafted to guide you, this course empowers you to become a data-driven application development expert. Explore the intricacies of connecting to databases, master the art of working with data providers, and dive deep into Entity Framework. Discover the power of asynchronous data access and real-world case studies that put your skills to the test. Security is paramount in data access, and we'll show you the ropes in data access security, covering everything from authentication to encryption. But that's not all – we're taking you beyond the horizon with insights into emerging data access technologies, cloud-based data access, and the transformative world of serverless and microservices architecture. Your journey begins now. Enroll and embark on a transformational experience that will set you on the path to data mastery with C#. Don't miss out on this opportunity to take your skills to the next level.

Название: Getting Started with Enterprise Architecture: A Practical and Pragmatic Approach to Learning the Basics of Enterprise Architecture
Автор: Eric Jager
Издательство: Apress
Год: 2023
Страниц: 280
Язык: английский
Формат: pdf
Размер: 10.2 MB

Implement a basic enterprise architecture from start to finish using a four stage wheel-based approach. Aided by real-world examples, this book shows what elements are needed for the initial implementation of a fundamental enterprise architecture. The book's pragmatic approach keeps existing architecture frameworks and methodologies in mind while providing instructions that are readable and applicable to all. The Enterprise Architecture Implementation Wheel builds on the methodology of existing architecture frameworks and allows you to apply the theory more pragmatically and closer to the reality that an architect encounters in daily practice. While the main focus of the book is the actual steps taken to design an enterprise architecture, other important topics include architecture origin, definition, domains, visualization, and roles. Getting Started with Enterprise Architecture is the ideal handbook for the architect who is asked to implement an Enterprise Architecture in an existing organization. For enterprise architects, project managers and executives.

Название: BPF: профессиональная оценка производительности
Автор: Грегг Брендан
Издательство: Питер
Год: 2024
Формат: pdf
Страниц: 880
Размер: 12,2 Мб
Язык: русский

Инструменты оценки производительности на основе BPF дают беспрецедентную возможность анализа систем и приложений. Вы сможете улучшить производительность, устранить проблемы в коде, повысить безопасность и сократить расходы. Книга «BPF: профессиональная оценка производительности» — ваш незаменимый гайд по применению этих инструментов. Брендан Грегг — эксперт и пионер проекта BPF — представляет более 150 готовых инструментов анализа и отладки, рекомендации по их применению, а также пошаговые инструкции по разработке ваших собственных инструментов. Вы узнаете, как анализировать процессоры, память, дисковый ввод/вывод, файловую систему, сети, языки программирования, приложения, контейнеры, гипервизоры, безопасность и ядро. Вы сможете выработать глубокое понимание того, как улучшить буквально любую Linux-систему или приложение.