Название: Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021 (Short & Spicy)
Автор: Ina Koys
Издательство: Independently published
Год: 2023
Язык: английский
Формат: epub (true)
Размер: 10.2 MB

Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF(), Database functions and the new, cutting-edge ones like SWITCH() and the brand new, very convenient XLOOKUP(). Excel worksheets often contain huge datasets. All important information is somewhere within them; finding it is a whole different thing. And once it’s found it may need some processing. Therefore, we’ll be covering known, less known, and brand-new ways of filtering, evaluation with database functions and a number of ways to query, applying custom conditions. To get it done, there’s a set of different possibilities, traditional ones and also the cutting-edge ones, so far confined to the users of Excel 365. All are explained with examples and their specific benefits and downsides.

Название: Основы проектирования баз данных
Автор(ы): Голицына О.Л., Партыка Т.Л., Попов И.И.
Издательство: Форум
Год: 2021
Страниц: 417
Формат: PDF
Размер: 101 Мб
Язык: русский

В учебном пособии рассматриваются основные подходы и направления развития систем баз данных. Анализируются классические машинно-ориентированные формы представления информации и данных. Рассматриваются типовые модели физической и логической организации данных.

Название: Linux For Beginners – 15th Edition 2023
Издательство: Papercut
Год: 2023
Страниц: 88
Качество: хорошее
Формат: PDF
Размер: 64,3 MB
Язык: английский

This book contains detailed information about Linux, its main features and capabilities. You will learn how to install Linux on your computer, work with the command line, manage users and files, as well as create network connections and configure various services. The book also provides real examples of programs you can create with Bash scripts. This book is an excellent resource for beginner Linux programmers and will be useful for both professionals and amateurs. In it, you'll find everything you need to get started in the world of Linux programming and build amazing apps.

Название: The Way of dаta: From Technology to Applications
Автор: Wu Hequan, Zheng Weimin
Издательство: World Scientific Publishing
Год: 2023
Страниц: 200
Язык: английский
Формат: pdf (true)
Размер: 18.9 MB

Everyone is already in the era of Big Data. It is gradually changing people's lifestyles. Therefore, it is necessary to explore the development path of Big Data, balance the relationship between technology, policy, and the market, so that it can better serve human society.This comprehensive book introduces what Big Data is, Big Data processing systems, Big Data management technologies, and Big Data analysis methods in an easy-to-understand language. It explains the specific applications of Big Data in smart government affairs, economic development, and the improvement of people's livelihood and welfare. Big Data, as described by Gartner, the world’s leading IT research and advisory firm, is a massive, high-growth, and diverse information asset that requires new processing models to provide greater decision-making, insight discovery, and process optimization.

Название: SQL и процедурно-ориентированные языки (2-е изд.)
Автор: Баженова И.Ю.
Издательство: М.: НОУ "Интуит"
Год: 2016
Страниц: 166
ISBN: 5-94774-539-9
Формат: PDF
Размер: 12.8 Мб
Язык: русский

Язык SQL предназначен для доступа к информации и управления реляционной базой данных. Управление различными реляционными базами данных осуществляют программы, называемые СУБД - системы управления базами данных (DBMS - DataBase Management System). Сама реляционная база данных представляет собой хранилище определенным образом организованной информации и СУБД.

Название: Power BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data
Автор: Alan Murray
Издательство: BPB Publications
Год: 2023
Страниц: 536
Язык: английский
Формат: pdf (true)
Размер: 28.1 MB

Power BI is a powerful Business Intelligence tool developed by Microsoft that helps you connect, analyze, and visualize data from a wide range of sources. If you are looking to gain a solid understanding of Power BI, then this book is for you. This book starts by covering the fundamentals of using the tool. It then teaches you how to import data from various sources, use DAX calculations, and take advantage of many visualization and filtering features in Power BI to create visually appealing and informative reports. Finally, the book covers different ways to share your Power BI reports and dashboards with others. By learning Power BI, you can stay ahead of the competition and gain a competitive edge in the field of data analysis and visualization. Learning Power BI will give you the edge over others who still use over-priced, rigid, and limited tools. The Microsoft data platform is the leader in the analytics and BI market. This book will demonstrate the demand for data analytics skills by businesses today, where you can find work and what employers will expect from you. It then takes you on a practical guide to Microsoft Power BI. No prior knowledge is required. This is a comprehensive beginners guide to Power BI.

Название: The Complete Linux Coding Manual - 3rd Edition 2023
Издательство: Papercut Limited
Год: 2023
Страниц: 148
Формат: PDF
Размер: 119 MB
Язык: English

Discover everything you need to know to master coding with the Linux OS! Those who have adopted the open source world into their digital life have found this remarkable operating system, and the available free programs it offers, a breath of fresh air. Linux offers the user a fast, secure environment, free from bloated software, to work and play on. Not only are you able to configure it to your own personal tastes, you can also enjoy a superb everyday desktop operating system that’s developed by a community of like-minded users. So join our team of experts as they take you through new guides and tutorials to help you build your knowledge with each new issue.

Название: Office 365 with SharePoint Online Cookbook Solutions: Maximize your productivity with Office 365 and SharePoint Online
Автор: Alex Pollard
Издательство: BPB Publications
Год: 2023
Страниц: 442
Язык: английский
Формат: pdf (true)
Размер: 41.2 MB

In this book, you will get an in-depth understanding of the Microsoft Office 365 (O365) platform from various angles such as Implementations, Set Up, Administrations, Out of the Box (OOB) development, custom solutions development, and business process automation. We will start with a high-level platform overview and what it is used for and then slowly continue diving deeper into the topic and have some practice samples. We will also look at a wide variety of technologies and techniques associated with O365 and induced applications scuh as SharePoint, OneDrive, Exchange, Teams, and so on. The book will be useful to people who are learning about Microsoft Office 365 as well as professionals who would like to switch their focus from other similar platforms or want to enhance O365 knowledge. You will learn how to use technologies and frameworks such as PowerApps, Power Automate, SharePoint Designer, InfoPath, Office 365 Admin center, SQL and Security and Compliance center, as well as React, SPFX, PnP and PowerShell. Microsoft 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you’ll get to grips with enabling workspace collaboration using Microsoft SharePoint Online, Teams, and the Power Platform.

Название: The Complete Windows 10 User Manual - 3rd Edition, 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Страниц: 148
Формат: PDF
Язык: английский
Размер: 106 MB

Everything you need to master Windows 10. Fully updated to include the best features of Windows 10, this is your complete guide to getting the best from the most popular operating system in the world, powering over 900 million devices. This complete manual for Windows 10 features hundreds of tutorials, guides and tips, making it the best way to get more from Windows 10 every time you use it. Our carefully selected guides, tips and tutorials cover everything, from using the core apps and features to keeping your PC safe and making more of Windows 10. Inside we show you everything you need to know to get started with Microsoft's latest operating system. No matter if you are a long time PC user or a complete Windows novice booting up your first laptop, there is something new to learn inside!

Название: Building an Event-Driven Data Mesh: Patterns for Designing and Building Event-Driven Architectures (Final Release)
Автор: Adam Bellemare
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 262
Язык: английский
Формат: True PDF, True EPUB (Retail Copy)
Размер: 13.7 MB

The exponential growth of data combined with the need to derive real-time business value is a critical issue today. An event-driven data mesh can power real-time operational and analytical workloads, all from a single set of data product streams. With practical real-world examples, this book shows you how to successfully design and build an event-driven data mesh. Data mesh is a fundamental shift in the way we think about, create, share, and use data. We promote data to a first-class citizen by carefully curating and crafting it into data products, supported with the same level of care and commitment as any other business product. Consumers can discover and select the data products they need for their own use cases, relying upon the commitment of the data product producer to maintain and support it. At its heart, data mesh is as much about technological reorganization as it is about the renegotiation of social contracts, responsibilities, and expectations.