Название: Оконные функции в T-SQL: По ту сторону анализа данных
Автор: Ицик Бен-Ган
Издательство: ДМК Пресс
Год: 2022
Страниц: 343
Язык: русский
Формат: pdf
Размер: 66.3 MB

В этой книге на конкретных примерах рассматриваются все типы оконных функций: агрегатные, ранжирующие, статистические, а также функции смещения и функции упорядоченного набора. Вы узнаете, как использовать оконные функции для повышения эффективности запросов, которые раньше писали с применением предикатов; освоить концепцию работы с окнами в SQL и строить запросы наиболее эффективным образом; умело использовать опции секционирования, упорядочивания и определения границ окна; оптимизировать оконные функции с использованием индексов и пакетного режима; применять оконные функции для решения распространенных бизнес-задач.

Название: Predicting the Unknown: The History and Future of Data Science and Artificial Intelligence
Автор: Stylianos Kampakis
Издательство: Apress
Год: 2023
Страниц: 270
Язык: английский
Формат: pdf
Размер: 38.8 MB

As a society, we’re in a constant struggle to control uncertainty and predict the unknown. Quite often, we think of scientific fields and theories as being separate from each other. But a more careful investigation can uncover the common thread that ties many of those together. From ChatGPT, to Amazon’s Alexa, to Apple’s Siri, Data Science, and Computer Science have become part of our lives. In the meantime, the demand for data scientists has grown, as the field has been increasingly called the “sexiest profession.” This book attempts to specifically cover this gap in literature between Data Science, Machine Learning and Artificial Intelligence (AI). How was uncertainty approached historically, and how has it evolved since? What schools of thought exist in philosophy, mathematics, and engineering, and what role did they play in the development of Data Science? It uses the history of Data Science as a stepping stone to explain what the future might hold.

Название: Learn SQL in a Month of Lunches (MEAP v8)
Автор: Jeff Iannucci
Издательство: Manning Publications
Год: 2023
Страниц: 192
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! Structured Query Language (SQL) is the standard way to get specific datasets out of large relational databases. If you use Excel, Tableau, or PowerBI to crunch business data, you’ve probably seen a lot of SQL already. And guess what? It’s easy to master the most useful parts of SQL! In just a few quick lessons, you can learn to write your own queries, modify existing SQL statements, and add a new superpower to your bag of tricks. Learn SQL in a Month of Lunches introduces you to the most useful parts of SQL for business data analysis. This practical book gives you instantly-useful techniques starting from the first short chapter. 25-year SQL veteran Jeff Iannucci makes SQL a snap through hands-on lab exercises, relevant code examples, and easy-to-understand language.

Название: Everyday Data Visualization (MEAP v4)
Автор: Desiree Abbott
Издательство: Manning Publications
Год: 2023
Страниц: 238
Язык: английский
Формат: pdf, epub
Размер: 25.8 MB

Radically improve the quality of the data visualizations you do every day by mastering core principles of color, typography, chart types, data storytelling, and more! In Everyday Data Visualization you’ll learn important design principles for the most common data visualizations. Everyday Data Visualization is a field guide for design techniques that will improve the charts, reports, and data dashboards you build every day. The foundation of data visualization is storytelling, and this book gives you the tools you need to start telling those stories with clarity, precision, and flair! You’ll learn how human brains perceive and process information, master modern accessibility standards, get the basics of color theory and typography, and more!

Название: Exam Ref DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Автор: Daniil Maslyuk, Justin Frebault
Издательство: Microsoft Press/Pearson Education
Год: 2024
Страниц: 734
Язык: английский
Формат: epub
Размер: 22.8 MB

Prepare for Microsoft Exam DP-500 and demonstrate your real-world ability to design, create, and deploy enterprise-scale data analytics solutions. Designed for business intelligence developers, architects, data analysts, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Enterprise Data Analyst Associate level. Exam DP-500 focuses on knowledge needed to govern and administer data analytics environments; integrate analytics platforms into existing IT infrastructure; manage the analytics development lifecycle; query data with Azure Synapse Analytics; ingest and transform data with Power BI; design and build tabular models; optimize enterprise-scale data models; explore data with Azure Synapse Analytics; and visualize data with Power BI.

Название: Business Database Technology: Theories and Design Process of Relational Databases, SQL, Introduction to OLAP, Overview of NoSQL Databases, 2nd Edition
Автор: Shouhong Wang, Hai Wang
Издательство: Universal Publishers
Год: 2022
Страниц: 280
Язык: английский
Формат: epub (true)
Размер: 26.5 MB

Business Database Technology provides essential knowledge of database technology for four-year college/university business students who study information technology and data resource management. Students will learn basic data structure techniques in databases, relational database model, design and implementation of relational databases, normalization, SQL, physical relational database design techniques, database administration, relational databases in computer networks, data warehouses, overview of OLAP (online analytical processing), and introduction to NoSQL databases. A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the relational data model. Previously, NoSQL referred to “non-relational” or “non-SQL”, but it actually means “Not only SQL”.

Название: Самоучитель Mac OS X Mavericks: Новая операционная система от А до Я
Автор: Райтман М.
Издательство: М.: Эксмо
Год: 2014
Cтраниц: 480
Формат: pdf
Размер: 12 мб
Язык: русский

Новая операционная система Mac OS X Mavericks стала еще мощнее и разнообразнее. В ней появились новые функции и приложения. Наша книга позволит в полной мере освоить все возможности этой новой операционной системы, от установки ее на компьютер до более сложных моментов работы, с которыми даже опытные пользователи вряд ли смогут разобраться самостоятельно несмотря на удобный и интуитивно понятный интерфейс.

Название: Mastering Salesforce Reports and Dashboards: Drive Business Decisions with Your CRM Data (Final Release)
Автор: David Carnes
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 341
Язык: английский
Формат: epub (true)
Размер: 38.1 MB

Effective, repeatable, and insightful analytics are key to ROI in customer relationship management systems. Many organizations, however, lack the automated reporting tools they need to run their businesses and instead choose to massage the data in Excel. But there's a better way. Salesforce's standard reporting tools provide a rich set of features that, when combined, support a wide variety of analytics needs. This practical introduction covers all the aspects and features you need to be successful with Salesforce reports and dashboards. Author David Carnes, chairman and chief evangelist for OpFocus, shows executives, end users, and report and dashboard superusers what analytics are possible, which features report writers should ask to be enabled, and which settings and permissions system administrators need to activate.

Название: Decision Support System and Automated Negotiations
Автор: Debajyoti Mukhopadhyay, Archana Chougule, Sheetal Vij
Издательство: CRC Press
Год: 2023
Страниц: 240
Язык: английский
Формат: pdf (true)
Размер: 21.8 MB

Decision support systems are developed for integrated pest and disease management and nutrition management using open-source technologies as Java, Android, and low-cost hardware devices like Arduino micro controller. This text discusses the techniques to convert agricultural knowledge in the context of ontology and assist grape growers by providing this knowledge through decision support system. Many solutions are available for sensing environmental parameters. For using environmental readings for decision support, sensors need to be boarded on fields and be connected to computerized systems for measurement recording and manipulation. Arduino is an open- source platform for implementing wireless sensor networks. Using Arduino microcontroller, sensor inputs are read and sent to server using some connectivity technique like Wi-Fi, Zigbee or GPRS. Programs can be written to read inputs and to write outputs to connected devices using Arduino IDE. Instructions can be sent on microcontrollers of Arduino kit to get the work done. ESP8266 is a Wi-Fi module which can be used for transferring sensor outputs to server machines through GPRS or Zigbee. It can be mounted on Arduino microcontroller and programmed using AT commands.

Название: Microsoft Word 2021 Tutorial
Автор: Catherine N. Githui
Издательство: Independently published
Год: 2023
Страниц: 429
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Are you ready to unlock the full potential of Microsoft Word 2021? Look no further! Introducing "Master Microsoft Word 2021: The Ultimate Tutorial Handbook," your comprehensive guide to mastering the ins and outs of this powerful word processing software. In this tutorial book, you will discover step-by-step instructions, insider tips, and expert techniques to elevate your document creation skills to new heights. Whether you're a beginner or an experienced user, this handbook is designed to empower you with the knowledge and tools you need to create professional documents effortlessly. From formatting text and paragraphs to working with images and objects, this tutorial book covers it all. Learn how to create visually stunning documents, harness advanced formatting options, and leverage time-saving features to boost your productivity. Unleash your creativity as you explore the art of tables, charts, and document design, ensuring your data and ideas are presented with clarity and impact.