Название: Excel BI and Dashboards in 7 Days: Build interactive dashboards for powerful data visualization and insights
Автор: Jared Poli
Издательство: BPB Publications
Год: 2024
Страниц: 330
Язык: английский
Формат: pdf, epub
Размер: 19.2 MB

Using MS Excel for powerful exploration, manipulation, and data visualization. Everyone thinks of Excel differently, and its full potential is often untapped. Businesses tend to decide to invest heavily in proper BI tools, perhaps wrongfully assuming that Excel has a minimal role in that industry. Excel can be used effectively to collect, refresh, transform, and visualize your data in beautiful and eye-catching ways. This book covers building those skills and unlocking Excel and your potential in just seven days. The book explores the process of cleaning your data to ensure accuracy, using formulas to enhance and prepare the same for PivotTables. It will also help you understand how to use data visualization to create clear charts to communicate insights effectively and construct interactive dashboards for user exploration, including elements like slicers and timelines. The book also dives into discovering design principles for easy-to-understand dashboards, while gaining knowledge on maintaining and updating them for ongoing usability. Understanding the full power behind Excel will allow you to improve your spreadsheet game and prove that you can do it all with one industry standard tool and this book. This book is for everyone who wants to be a powerful user of Excel, finance teams, sales and marketing teams, MIS Analysts, BI aspirants, and all those who work with Excel sheets daily and want to refine that skill set into something more practical.

Название: Digital and Technological Solutions: Exploring the foundations of digitization
Автор: Faheem Syeed Masoodi, Zubair Sayeed Masoodi, Khalid Bashir Dar
Издательство: BPB Publications
Год: 2024
Страниц: 411
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Understanding the basics of digital systems and technology is important in today’s rapidly evolving world. This book Digital and Technologicals Solutions: Exploring the foundations of digitization covers the essential concepts that form the backbone of digital systems. This book teaches digital systems, exploring number systems, logic gates, and computer architecture. It covers hardware, software (system and application), and operating systems. Network fundamentals like LANs, WANs, routers, and the internet are addressed. Information systems used in organizations, including e-commerce and digital marketing, are explained. The book examines digital payments (UPI, e-wallets) and cybersecurity measures. Finally, emerging technologies like cloud computing, big data, IoT, VR, blockchain, robotics, AI, and 3D printing are introduced. The Chapter 1 provides an introduction to computer systems and their workings, starting with an overview of the generations of computers. It explores the basic components of a computer system and discusses computer system architecture. The chapter also delves into software, including its definition and types such as system software and application software. It further covers operating systems, their functions, and different types including batch, multi-user, and real-time systems. Popular operating systems like MS DOS, Windows, macOS, Linux, Android, and iOS are highlighted. Additionally, the chapter introduces algorithms and flowcharts as essential tools in computer programming.

Название: Mastering Marketing Data Science: A Comprehensive Guide for Today's Marketers
Автор: Iain Brown
Издательство: Wiley
Год: 2024
Страниц: 432
Язык: английский
Формат: epub (true)
Размер: 13.0 MB

Unlock the Power of dаta: Transform Your Marketing Strategies with Data Science. In the digital age, understanding the symbiosis between marketing and data science is not just an advantage; it's a necessity. In Mastering Marketing Data Science: A Comprehensive Guide for Today's Marketers, Dr. Iain Brown, a leading expert in data science and marketing analytics, offers a comprehensive journey through the cutting-edge methodologies and applications that are defining the future of marketing. This book bridges the gap between theoretical data science concepts and their practical applications in marketing, providing readers with the tools and insights needed to elevate their strategies in a data-driven world. Whether you're a master's student, a marketing professional, or a data scientist keen on applying your skills in a marketing context, this guide will empower you with a deep understanding of marketing data science principles and the competence to apply these principles effectively. Marketing Data Science equips organizations with the power to make data-driven decisions, optimize marketing expenditures, elevate customer experiences, and secure a competitive edge. By harnessing advanced techniques, such as Machine Learning (see Chapter 5), natural language processing (NLP) (see Chapter 6), and Big Data analytics (see Chapter 11), marketing data scientists can discover latent opportunities, foresee customer behavior, and devise personalized marketing strategies that resonate with target audiences. Engage with real-world examples, hands-on exercises in both Python & SAS, and actionable insights to apply in your marketing campaigns.

Название: SQL. Pocket guide, 4-е издание
Автор: Элис Жао
Издательство: Спринт Бук
Год: 2024
Формат: pdf
Страниц: 320
Размер: 12,7 Мб
Язык: русский

Если вы аналитик или инженер по обработке данных и используете SQL, популярный карманный справочник станет для вас идеальным помощником. Найдите множество примеров, раскрывающих все сложности языка, а также ключевые аспекты SQL при его использовании в Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL и SQLite. В обновленном издании Элис Жао описывает, как в этих СУБД используется SQL для формирования запросов и внесения изменений в базу. Получите подробную информацию о типах данных и их преобразованиях, синтаксисе регулярных выражений, оконных функциях, операторах PIVOT и UNPIVOT и многом другом.

Название: Deploying Juniper Data Centers with EVPN VXLAN (Final)
Автор: Aninda Chatterjee
Издательство: Addison-Wesley Professional/Pearson Education
Год: 2024
Страниц: 689
Язык: английский
Формат: pdf (true)
Размер: 19.6 MB

Learn to deploy Juniper Data Centers with EVPN VXLAN and master the only intent-based multivendor solution for deploying and monitoring EVPN-based VXLAN fabrics! Deploying Juniper Data Centers with EVPN VXLAN is designed for engineers and architects designing, deploying, and/or maintaining small to large data centers. This book will increase productivity and streamline processing and communication by helping you understand BGP EVPNbased VXLAN, data center design and deployment using Junos, and interconnecting multiple data centers for various deployment applications. Aninda Chatterjees straightforward prose and industry experience also gives you the foundational knowledge necessary for Juniper Data Center certification from the JNCIA-DC to the JNCIE-DC. The books structure is unique in its chapter-by-chapter approach with one-pager quick reference guides at the end of the book. The author also puts theory to practice using a combination of packet captures and packet walks. Junos OS is a network operating system with a modular software architecture, developed on top of FreeBSD, which is an open-source operating system. Services run as daemons in their own protected memory space.

Название: Command Line : A Modern Introduction
Автор: Petr Stribny
Издательство: Independently published
Год: 2023
Язык: английский
Формат: pdf (true), epub
Размер: 10.1 MB

Graphical user interfaces lowered the barrier to using computers for many people and enabled new applications. However, in software development and system administration, Command Line Interfaces (CLIs) are still widely used. Users input text commands individually in a command line interface, often receiving a text output after each executed command. Terminal User Interfaces (TUIs) are used by interactive programs while operating within a text-based terminal. Think of two-pane file managers or text editors that work over the whole terminal screen. There are several text-based shells that we can use, but the most common and useful to know is Bourne Again SHell, known as Bash. It is the shell commonly associated with Linux since it is installed by default on most Linux distributions, such as Ubuntu or Fedora. Another popular shell is Z shell (Zsh), now the default shell on macOS. While Bash is an excellent choice for scripting thanks to its ubiquity, Zsh is used by developers and sysadmins for its interactivity and configurability. Fish shell is also gaining popularity, being designed to be a user-friendly shell with good defaults. However, it is less compatible with the other mentioned shells. Windows operating system also has its shell called PowerShell. For software developers, sysadmins and data scientists. For anyone who needs to control Linux or BSD systems like personal computers, servers, virtual machines and containers.

Название: An Introduction to Spatial Data Science with GeoDa, Volume 1: Exploring Spatial Data
Автор: Luc Anselin
Издательство: CRC Press
Год: 2024
Страниц: 453
Язык: английский
Формат: pdf (true)
Размер: 20.4 MB

This book is the first in a two-volume series that introduces the field of Spatial Data Science. It offers an accessible overview of the methodology of exploratory spatial data analysis. It also constitutes the definitive user’s guide for the widely adopted GeoDa open-source software for spatial analysis. Leveraging a large number of real-world empirical illustrations, readers will gain an understanding of the main concepts and techniques, using dynamic graphics for thematic mapping, statistical graphing, and, most centrally, the analysis of spatial autocorrelation. Key to this analysis is the concept of local indicators of spatial association, pioneered by the author and recently extended to the analysis of multivariate data. The focus of the book is on intuitive methods to discover interesting patterns in spatial data. It offers a progression from basic data manipulation through description and exploration to the identification of clusters and outliers by means of local spatial autocorrelation analysis. A distinctive approach is to spatialize intrinsically non-spatial methods by means of linking and brushing with a range of map representations, including several that are unique to the GeoDa software. The book also represents the most in-depth treatment of local spatial autocorrelation and its visualization and interpretation by means of GeoDa. The libgeoda library has a clearly defined Application Programming Interface (API), which allows other C++ code to access its functionality directly. In fact, this is what currently happens under the hood for part of desktop GeoDa, and in the experimental web-GeoDa (jsgeoda, implemented through jаvascript). In addition to achieving a more flexible interaction with different graphical user interface implementations, the API also allows other software, such as R or Python programs to access the functionality through well-defined wrapper code.

Название: An Introduction to Spatial Data Science with GeoDa: Volume 2: Clustering Spatial Data
Автор: Luc Anselin
Издательство: CRC Press
Год: 2024
Страниц: 238
Язык: английский
Формат: pdf (true)
Размер: 34.7 MB

This book is the second in a two-volume series that introduces the field of spatial Data Science. It moves beyond pure data exploration to the organization of observations into meaningful groups, i.e., spatial clustering. This constitutes an important component of so-called Unsupervised Learning, a major aspect of modern Machine Learning. The distinctive aspects of the book are both to explore ways to spatialize classic clustering methods through linked maps and graphs, as well as the explicit introduction of spatial contiguity constraints into clustering algorithms. Leveraging a large number of real-world empirical illustrations, readers will gain an understanding of the main concepts and techniques and their relative advantages and disadvantages. The book also constitutes the definitive user’s guide for these methods as implemented in the GeoDa open source software for spatial analysis. It is organized into three major parts, dealing with dimension reduction (principal components, multidimensional scaling, stochastic network embedding), classic clustering methods (hierarchical clustering, k-means, k-medians, k-medoids and spectral clustering), and spatially constrained clustering methods (both hierarchical and partitioning). It closes with an assessment of spatial and non-spatial cluster properties.

Название: VMware vSphere Essentials: A Practical Approach to vSphere Deployment and Management
Автор: Luciano Patrão
Издательство: Apress
Год: 2024
Страниц: 708
Язык: английский
Формат: pdf
Размер: 27.2 MB

This book fills a vacuum in the market for high-quality information on a VMware vSphere system and offers a thorough introduction to VMware virtualization. Written for novices and those seeking more information about vSphere, this book walks you through its key concepts and technology, such as vSphere infrastructure creation, maintenance, and performance for beginners and advanced users. You'll take a step-by-step approach to guarantee you grasp the fundamental concepts and practical procedures required to construct and manage virtual machines in a VMware vSphere system. You'll explore the key components of vSphere with detail and explanation for each feature, including the hypervisor, networking, storage, and high availability, unravelling their intricacies and highlighting best practices. Virtualization is a revolutionary concept, abstracting away the differences between actual hardware and its digital counterparts. It allows multiple virtual machines to exist on one physical computer, using hardware abstraction and a hypervisor. This boosts efficiency, scalability, and adaptability in managing applications and environments. With various kinds of virtualization available, this technology has many advantages, such as reduced expenses, optimized resource use, and simplified administration. For system administrators, advanced vSphere administrators, and IT professionals pursuing VMware certifications.

Название: Visualize This: The FlowingData Guide to Design, Visualization, and Statistics, 2nd Edition
Автор: Nathan Yau
Издательство: Wiley
Год: 2024
Страниц: 385
Язык: английский
Формат: pdf (true)
Размер: 46.7 MB

One of the most influential data visualization books—updated with new techniques, technologies, and examples. Visualize This demonstrates how to explain data visually, so that you can present and communicate information in a way that is appealing and easy to understand. Today, there is a continuous flow of data available to answer almost any question. Thoughtful charts, maps, and analysis can help us make sense of this data. But the data does not speak for itself. As leading data expert Nathan Yau explains in this book, graphics provide little value unless they are built upon a firm understanding of the data behind them. Visualize This teaches you a data-first approach from a practical point of view. You'll start by exploring what your data has to say, and then you'll design visualizations that are both remarkable and meaningful. With this book, you'll discover what tools are available to you without becoming overwhelmed with options. You'll be exposed to a variety of software and code and jump right into real-world datasets so that you can learn visualization by doing. Details tools that can be used to visualize data graphics for reports, presentations, and stories, for the web or for print, with major updates for the latest R packages, Python libraries, jаvascript libraries, illustration software, and point-and-click applications.