Litgu.ru - Литературный Гуру

Название: Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
Автор: Bill Jelen
Издательство: Microsoft Press/Pearson Education
Год: 2025
Страниц: 915
Язык: английский
Формат: epub
Размер: 93.0 MB

Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if youve never created a pivot table before, this book will help you leverage their flexibility and analytical powerand includes exploration of new array functions and Copilot capabilities in analysis creation. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (MrExcel) shares practical recipes for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks youll find nowhere else. With a pivot table, you can transform one million rows of transactional data into a summary report in seconds. If you can drag a mouse, you can create a pivot table. In addition to quickly summarizing and calculating data, pivot tables enable you to change your analysis on the fly by simply moving fields from one area of a report to another. Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online or on the Desktop.

Название: Mastering the Snowflake SQL API with Laravel 10: A Comprehensive Guide to Data Cloud Integrated Development
Автор: Ronald Steelman
Издательство: Apress
Год: 2024
Страниц: 134
Язык: английский
Формат: pdf
Размер: 43.7 MB

This book is your essential guide to mastering Snowflake’s SQL API, offering a comprehensive understanding of this powerful tool. In today’s data-driven world, robust, flexible, and scalable solutions are crucial, and Snowflake’s Data Cloud platform is a game-changer in cloud data warehousing and analytics. The book includes examples using both Snowflake and the Laravel PHP Framework, assuming basic knowledge of SQL and Laravel. Key topics include SQL API development, SQL basics, advanced techniques, data security, performance tuning, best practices for data warehousing, integrations, real-world use cases, future trends in data analytics, and leveraging PHP in Laravel for dynamic web applications. This book equips you with the skills to unlock insights, make data-driven decisions, and stay ahead in your industry.

Название: 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.

Название: Математическая теория баз данных
Автор(ы): В.Б. Кудрявцев, Э.Э. Гасанов, А.С. Подколзин
Издательство: Юрайт
Год: 2024
Страниц: 145
Формат: PDF
Размер: 12 Мб
Язык: русский

Предлагаемая книга написана на основе специальных курсов "Теория баз данных" и "Интеллектуальные системы", читаемых на кафедре математической теории интеллектуальных систем механико-математического факультета МГУ имени М. В. Ломоносова.
Книга рассчитана на студентов, аспирантов и специалистов в области математической кибернетики, дискретной математики и информатики.

Название: 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.

Название: 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.