Название: The Ultimate Guide to Functions in Power Query: Turn Raw Data into Actionable Insights
Автор: Omid Motamedisedeh
Издательство: Apress
Год: 2024
Страниц: 410
Язык: английский
Формат: pdf, epub
Размер: 10.2 MB

This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions. The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along with detailed explanations of how to use each of them. You’ll see how to leverage power functions to process and transform large datasets from various sources and learn advanced techniques such as creating custom functions and using conditional statements. The book also covers best practices for using functions, including tips on how to optimize query performance and troubleshoot common errors. Using practical example applications, Author Omid Motamedisedeh demonstrates how to optimize your data processing workflows, saving time and boosting productivity. By the end of the book, readers will have a deep understanding of Power Query functions and be able to apply their knowledge to a wide range of data analysis tasks. For anyone who wants to learn how to use functions in Power Query to transform and analyze data. This includes data analysts, business analysts, Excel users, and data scientists. Readers should have a basic understanding of Excel and data analysis concepts, but may be new to Power Query and functions.

Название: Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization's Data, 4th Edition
Автор: Michelle Malcher, Darl Kuhn
Издательство: Apress
Год: 2024
Страниц: 600
Язык: английский
Формат: pdf, epub
Размер: 20.6 MB

Master Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you’ll need to perform to keep your databases stable, tuned, and running. The book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls. Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You’ll learn how to look at data optimization from the standpoint of data analysis and Machine Learning so that you can be seen as a key player in preparing your organization’s data for those type of activities. This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of Machine Learning and analytics technologies.

Название: Kafka Troubleshooting in Production: Stabilizing Kafka Clusters in the Cloud and On-premises
Автор: Elad Eldor
Издательство: Apress
Год: 2023
Страниц: 229
Язык: английский
Формат: pdf
Размер: 10.1 MB

This book provides Kafka administrators, site reliability engineers, and DataOps and DevOps practitioners with a list of real production issues that can occur in Kafka clusters and how to solve them. The production issues covered are assembled into a comprehensive troubleshooting guide for those engineers who are responsible for the stability and performance of Kafka clusters in production, whether those clusters are deployed in the cloud or on-premises. This book teaches you how to detect and troubleshoot the issues, and eventually how to prevent them. Kafka stability is hard to achieve, especially in high throughput environments, and the purpose of this book is not only to make troubleshooting easier, but also to prevent production issues from occurring in the first place. The guidance in this book is drawn from the author's years of experience in helping clients and internal customers diagnose and resolve knotty production problems and stabilize their Kafka environments. The book is organized into recipe-style troubleshooting checklists that field engineers can easily follow when under pressure to fix an unstable cluster. This is the book you will want by your side when the stakes are high, and your job is on the line. For site reliability engineers tasked with maintaining stability of Kafka clusters, Kafka administrators who troubleshoot production issues around Kafka, DevOps and DataOps experts who are involved with provisioning Kafka (whether on-premises or in the cloud), developers of Kafka consumers and producers who wish to learn more about Kafka.

Название: AI-Based Data Analytics: Applications for Business Management
Автор: Kiran Chaudhary, Mansaf Alam
Издательство: CRC Press
Год: 2024
Страниц: 261
Язык: английский
Формат: pdf (true)
Размер: 13.6 MB

This book covers various topics related to marketing and business analytics. It explores how organizations can increase their profits by making better decisions in a timely manner through the use of data analytics. This book is meant for students, practitioners, industry professionals, researchers, and academics working in the field of commerce and marketing, Big Data analytics, and organizational decision-making. This book is focused on Artificial Intelligence (AI), Data Analytics, Sentiment Analysis for social media, and various approaches to AI in Business Management. This is an emerging field that can increase the performance management domain to improve understanding of business and marketing dynamics that can lead to better strategic decision-making. In this book, we have also given a variety of marketing and business analytics strategies to solve market and organizational challenges. The use of AI in business and marketing analytics can help to create value by proper allocation of all available resources. By using various techniques and tools of Big Data analytics, we can improve the performance of the business. Data analytics is a vast discipline that encompasses a variety of methodologies and technologies. Predictive analytics, data mining, Machine Learning (ML), and Natural Language Processing (NLP) are included.

Название: Business Statistics Using Excel: A Complete Course in Data Analytics
Автор: R. Panneerselvam
Издательство: Routledge
Год: 2024
Страниц: 694
Язык: английский
Формат: pdf (true)
Размер: 50.2 MB

This book gives readers a hands-on understanding of Excel-assisted statistical techniques to take effective business decisions. It showcases applications of the tools and techniques of statistics for analysing business data from the domain of business statistics. The volume provides an exhaustive introduction to the application of statistics in solving business problems and implementing data analytics for effective decision making in all kinds of business situations around the world. With an emphasis on simplicity in presentation of concepts of statistical methods and associated Excel functions, the volume explores the implementation of Excel functions through well-defined sequences of steps. Comprehensive in scope and simple in approach, this book will be key for students and researchers of business studies, business administration, economics, finance, commerce, data analytics/science, and Computer Science. This will also serve as useful guidebook for business executives and working professionals across the globe.

Название: Exploring macOS: A Journey Through the Mac Ecosystem
Автор: Sagar Rastogi, Jasdeep Singh
Издательство: Apress
Год: 2023
Страниц: 365
Язык: английский
Формат: pdf
Размер: 17.0 MB

If you are a new to the Apple macOS ecosystem and want to get started using it for your enterprise, this is the book for you. You will learn how to navigate the Mac operating system, including an introduction to macOS and its fundamentals, management settings, reinstallation process, and usability. The book also provides tutorials which can be used for troubleshooting networks, configuration, and to ease Windows users’ transition to the Mac world. Additionally, it provides detailed information about managing Mac devices using Jamf Pro within organizations, as well as basic and advanced automation scripting. By the time you finish Apple Enterprise Management, you will have a detailed understanding of macOS and its functionality, how to manage Mac devices for enterprise use, and the role Jamf Pro plays in managing and securing Mac devices effectively whilse providing a seamless user experience. For helpdesk consultants, remote desktop support professionals, system engineers, macOS Apple desktop administrators, enterprise Apple macOS desktop architects, Jamf system engineers, and digital workplace engineers.

Название: Delta Lake: Up and Running: Modern Data Lakehouse Architectures with Delta Lake (Final)
Автор: Bennie Haelen, Dan Davis
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 267
Язык: английский
Формат: pdf (true), epub (true)
Размер: 12.3 MB

With the surge in Big Data and AI, organizations can rapidly create data products. However, the effectiveness of their analytics and Machine Learning models depends on the data's quality. Delta Lake's open source format offers a robust lakehouse framework over platforms like Amazon S3, ADLS, and GCS. This practical book shows data engineers, data scientists, and data analysts how to get Delta Lake and its features up and running. The ultimate goal of building data pipelines and applications is to gain insights from data. You'll understand how your storage solution choice determines the robustness and performance of the data pipeline, from raw data to insights. The code examples in the book range from snippets that can be used in a PySpark shell to those designed to be run with a complete end-to-end notebook. In this book, all code snippets will be in Python, SQL, and, where necessary, shell commands.

Название: Windows 11 Tricks and Tips - 9th Edition, 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Язык: английский
Формат: pdf
Размер: 32.2 MB

Книга "Советы и рекомендации по работе с Windows 11" - это универсальное руководство для начинающих пользователей настольных компьютеров и ноутбуков, а также для тех, кто хочет узнать все необходимое для начала работы с операционной системой Microsoft. Это отдельное руководство содержит множество полезных советов и иллюстрированных пошаговых инструкций, написанных на понятном английском языке. Понимание операционной системы, под управлением которой работает ваш компьютер или приложение, позволит узнать все, что нужно знать о компьютере или приложении. С помощью этого неофициального руководства вы сможете изучить, исследовать и усовершенствовать Windows 11 для решения любых задач.

Название: Access 365 Project Book : Hands-On Database Creation
Автор: Julitta Korol
Издательство: Mercury Learning and Information
Год: 2024
Страниц: 469
Язык: английский
Формат: pdf (true)
Размер: 33.9 MB

This is a project book that guides you through the process of building a traditional Access desktop database that uses one Access database as the front-end (queries, reports, and forms) and another Access database to contain the tables and data. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network. When you build a database correctly at the outset, later this database can be migrated to another system with fewer issues and fewer objects that need to be redone. Microsoft Access has been the top database management solution for individuals and businesses for over two decades. Many of today’s database systems started as small Access databases or were ported from Microsoft Excel spreadsheets. With Microsoft’s commitment to continuing the development of the product, Access keeps getting better with each new update. Across all types and sizes of organizations, people continue to utilize Access to collect, track, and analyze data from multiple sources and build useful forms and reports. Non-devel-opers are creating various Access databases because with Access they can quickly move forward and get their job done without requiring much support from the IT (Information Technology) department. Access 365 Project Book: Hands-On Database Creation is a hands-on database project that guides you through the process of building a traditional Access desktop database that is later split into two files: a back-end database that contains tables with data, and a front-end database that contains forms, reports, queries, macros, and code modules.

Название: Building a Data Culture: The Usage and Flow Data Culture Model
Автор: Gary W. Griffin, David Holcomb
Издательство: Apress
Год: 2023
Страниц: 235
Язык: английский
Формат: pdf
Размер: 25.0 MB

In today's fast-paced digital landscape, organizations face an ever-increasing volume of data that holds immense potential for driving business success. However, many businesses struggle to harness this potential due to a lack of understanding and effective utilization of data within their culture. This book is a comprehensive guide that unveils the transformative power of data and provides actionable insights to cultivate a data-driven organizational culture. The book emphasizes data strategy and data governance's pivotal role in cultivating a mature data culture using practical insights, frameworks, and best practices. This approach ensures robust data culture structures that uphold data integrity, accessibility, and accountability. These structures operate on the people, processes, and technology through analytics, literacy, governance, process management, and data inventory management. For professionals and leaders across various industries who are interested in building a data culture within their organizations. The typical reader may have a background in data management, analytics, business intelligence, or technology, but the book is designed to be accessible to a wide range of readers with varying levels of expertise.