Название: Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition
Автор: Daniil Maslyuk, Gil Raviv
Издательство: Microsoft Press/Pearson Education
Год: 2025
Страниц: 634
Язык: английский
Формат: epub
Размер: 34.9 MB

Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you’re using Power BI, Excel, or other Microsoft products, Power Query’s capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you’ll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you’ll possess the expertise to handle any data and convert it into actionable insights. Power BI, Excel, Fabric, and Power Platform share a game-changing data connectivity and transformation technology, Power Query, that empowers any person with basic Excel skills to perform and automate data importing, reshaping, and cleansing. With simple UI clicks and a unified user experience across wide variety of data sources and formats, you can resolve any data preparation challenge and become a master data wrangler.

Название: Interactive and Dynamic Dashboard: Design Principles
Автор: A. Vadivel, K. Meena, P. Sumathy, Henry Selvaraj, P. Shanmugavadivu
Издательство: CRC Press
Год: 2025
Страниц: 302
Язык: английский
Формат: pdf (true)
Размер: 54.8 MB

The text comprehensively discusses the representation of visual data and design principles of interactive and dynamic dashboards. It further covers the theoretical concept of inference and Machine Learning algorithms for making the concepts clear to the reader. The book illustrates important topics such as data testing a parametric hypothesis, data testing a non-parametric hypothesis, exploratory data analysis, outlier detection and interpretation. A dynamic interactive dashboard is a vital resource in a variety of fields, such as business, finance, healthcare, and education, since it enables users to interact with data in real-­time. With the ability to update data in real-­time or on a regular basis, dynamic interactive dashboards guarantee that users always have access to the most recent information. A well-­liked Python framework called Plotly Dash was created especially for creating interactive dashboards and data visualizations that are accessible online. It makes use of Plotly.js’s capabilities to produce aesthetically pleasing graphs and charts with a great degree of customization and interactivity.

Название: Linux-Code fur Einsteiger - Dezember 2024
Издательство: Papercut Limited
Год / месяц: Dezember 2024
Страниц: 84
Формат: PDF
Размер: 44,6 MB
Язык: немецкий

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

Название: Chromebook Tricks and Tips - 13th Edition 2024
Издательство: Papercut
Год: 2024
Страниц: 98
Формат: PDF
Размер: 64,5 MB
Язык: English

Chromebook Tricks and Tips is the one stop user guide for the new Google powered laptop computer adopter or those want to learn everything you’ll need to get started with Google’s hardware. This independent manual is crammed with helpful guides and step-by-step fully illustrated tutorials, written in plain easy to follow English. Over the pages of this publication you will clearly learn everything you need to know about your Chromebook and it’s apps. With this unofficial instruction manual at your side no problem will be unsolvable, no question unanswered as you learn, explore and enhance your Google Chromebook user experience.

Название: DuckDB: Up and Running: Fast Data Analytics and Reporting
Автор: Wei-Meng Lee
Издательство: O’Reilly Media, Inc.
Год: 2025
Страниц: 381
Язык: английский
Формат: epub
Размер: 22.5 MB

DuckDB, an open source in-process database created for OLAP workloads, provides key advantages over more mainstream OLAP solutions: It's embeddable and optimized for analytics. It also integrates well with Python and is compatible with SQL, giving you the performance and flexibility of SQL right within your Python environment. This handy guide shows you how to get started with this versatile and powerful tool. Author Wei-Meng Lee takes developers and data professionals through DuckDB's primary features and functions, best practices, and practical examples of how you can use DuckDB for a variety of data analytics tasks. You'll also dive into specific topics, including how to import data into DuckDB, work with tables, perform exploratory data analysis, visualize data, perform spatial analysis, and use DuckDB with JSON files, Polars, and JupySQL.

Название: Automated Data Analytics: Combining Human Creativity and AI Power Using ChatGPT
Автор: Soraya Sedkaoui
Издательство: Wiley-ISTE
Год: 2024
Страниц: 243
Язык: английский
Формат: pdf (true), epub (true)
Размер: 16.5 MB

Data analytics is a crucial process in today’s data-driven world. It involves collecting, cleaning, transforming and analyzing data to uncover useful information, insights, trends and patterns which inform business strategy, decision-making and process optimization. Traditionally, data analytics was a manual process requiring data scientists and analysts to prepare and process data before analyzing them. This was both tedious and time-consuming. The advent of machine learning and Artificial Intelligence (AI) has transformed data analytics by automating some parts of the process. Generative AI models, like ChatGPT, are at the forefront of this automation revolution in data analytics. These large language models can understand human prompts and generate coherent and human-like textual responses. They are trained with massive text datasets, enabling them to perform a variety of language-based tasks. Generative models, such as ChatGPT, can be fine-tuned for specific applications, including data analytics.

Название: Data & AI Imperative: Designing Strategies for Exponential Growth
Автор: Lillian Pierson
Издательство: Wiley
Год: 2025
Страниц: 352
Язык: английский
Формат: True/Retail EPUB
Размер: 10.1 MB

Unlock predictable bottom line growth through tailored data and AI strategies. In The Data & AI Imperative: Designing Strategies for Exponential Growth, celebrated data-driven growth leader, Lillian Pierson, delivers a masterclass in developing custom strategies to harness the full potential of data and AI within your organization. This book offers a clear, actionable roadmap for leveraging your company's data and technology assets to drive significant, reliable growth. This book covers data landscape analysis, use case identification, planning and strategy development, implementation oversight, and evaluation and scaling of data initiatives. It focuses on applying pre-trained generative AI models rather than developing custom LLMs, which are costly and complex. Using a tested framework, the book guides you in aligning data resources with business objectives, selecting impactful use cases, crafting effective strategies, and ensuring successful execution and scaling of AI initiatives.

Название: Mastering VMware Cloud Disaster Recovery and Ransomware Resilience: A Practical Guide on VMware Cloud Disaster and Ransomware Recovery SaaS Solution
Автор: Christophe Lombard
Издательство: Apress
Год: 2024
Страниц: 195
Язык: английский
Формат: pdf
Размер: 11.7 MB

Examine the complexities of detecting ransomware and the potential rocky road to recover after it has infected a system environment. This book addresses the topic of Disaster and Ransomware Recovery in the VMware Cloud. You'll start by examining the challenge of implementing a robust disaster recovery solution, and how to address it through a Disaster Recovery-as-a-service (DRaaS) approach. The book then introduces the basics of the VMware Live Cyber Recovery solution and how it is fully integrated with VMware Cloud on AWS to offer an easy-to-use SaaS-based solution with a pay-as-you-go model for a faster recovery at a very low TCO. It also provides a technical deep dive into VMware Live Cyber Recovery architecture by detailing the features and capabilities of the solution including the concepts of Protected Sites, Protection Groups, Disaster Recovery Plans, and Failover testing.

Название: PostgreSQL Skills Development on Cloud: A Practical Guide to Database Management with AWS and Azure
Автор: Venkateswara Vadlamani
Издательство: Apress
Год: 2024
Страниц: 584
Язык: английский
Формат: pdf
Размер: 31.7 MB

This book provides a comprehensive approach to manage PostgreSQL cluster databases on Amazon Web Services and Azure Web Services on the cloud, as well as in Docker and container environments on a Red Hat operating system. The book is superior to existing literature and official documentation for Postgres, Amazon Web Services, Azure Web Services, and the Red Hat operating system that encompass several thousand pages. This book condenses all the fundamental and essential concepts you need to manage a PostgreSQL cluster into a one-stop guide that is perfect for newcomers to Postgres database administration. Each chapter of the book provides historical context and documents version changes of the PostgreSQL cluster, elucidates practical "how-to" methods, and includes illustrations and key word definitions, practices for application, a summary of key learnings, and questions to reinforce understanding. The book also outlines a clear study objective with a weekly learning schedule and hundreds of practice exercises, along with questions and answers. With its comprehensive and practical approach, this book will help you gain the confidence to manage all aspects of a PostgreSQL cluster in critical production environments so you can better support your organization's database infrastructure on the cloud and in containers.

Название: Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case
Автор: Lukas Vileikis
Издательство: Apress
Год: 2024
Страниц: 382
Язык: английский
Формат: pdf (true), epub
Размер: 22.8 MB

Your MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security―and that’s only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or security by uncovering what causes databases to break in the first place. At its core, this book provides you with the knowledge necessary for you to break your database instances so you can better optimize it for performance and secure it from data breaches. In other words, you’ll discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this book will help you keep it working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best MySQL configurations, among other essential skills. For database administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL.