Название: Analyzing US Census dаta: Methods, Maps, and Models in R
Автор: Kyle Walker
Издательство: CRC Press
Серия: The R Series
Год: 2023
Страниц: 378
Язык: английский
Формат: pdf (true)
Размер: 147.7 MB

Census data are widely used by practitioners to understand demographic change, allocate resources, address inequalities, and make sound business decisions. Until recently, projects using US Census data have required proficiency with multiple web interfaces and software platforms to prepare, map, and present data products. This book introduces readers to tools in the R programming language for accessing and analyzing Census data, helping analysts manage these types of projects in a single computing environment. R is one of the most popular programming languages and software environments for statistical computing and is the focus of this book with respect to software applications. This section introduces some basics of working with R and covers some terminology that will help readers work through the sections of this book. The tidyverse ecosystem developed by RStudio is one of the most popular frameworks for data analysis in R and attempts to respond to problems introduced by package fragmentation. The tidyverse consists of a series of R packages designed to address common data analysis tasks (data wrangling, data reshaping, and data visualization, among many others) using a consistent syntax.

Название: MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide with 900 Practice Test Questions: Exam MD-100 and Exam MD-101, 2nd Edition
Автор: William Panek
Издательство: Sybex
Год: 2023
Страниц: 971
Язык: английский
Формат: pdf (true)
Размер: 30.1 MB

Complete, UPDATED study guide for MCA Modern Desktop Administrator certification exams, MD-100 and MD-101. Covers new Windows 11, services, technologies, and more! MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide, Second Edition, is your all-in-one guide to preparing for the exams that will earn you the MCA Modern Desktop Administrator certification! In this book, well-known Windows guru and five-time Microsoft MVP, William Panek, guides you through the latest versions of the Windows Client exam (MD-100) and the Managing Modern Desktops exam (MD-101). This one-stop resource covers 100% of the objectives for both exams, providing real world scenarios, hands-on exercises, and challenging review questions. You’ll also dive deeper into some of the more complex topics and technologies, including deploying, maintaining, and upgrading Windows; managing devices and data; configuring storage and connectivity; managing apps and data; and more.

Название: SQLite Internals : How The World's Most Used Database Works
Автор: Abdur-Rahmaan Janhangeer
Издательство: Leanpub
Год: 2023-01-02
Язык: английский
Формат: pdf (true), mobi, epub
Размер: 10.2 MB

SQLite is famous for it's ubiquity. This book is a deep dive into the mechanisms that drive it! To all SQLite lovers. This book discusses SQLite internals in depth. SQLite is a file-based database which is extremely reliable and stable. It is the world’s most used database. It’s used on military devices, on planes (the A350 for instance) and in space. The codebase and mechanisms it uses is extremely complex. The seemingly simple nature of it and adoption makes a good case for deep diving into in a fascinating piece of software. It also implemented many features years ahead of popular databases like partial indexes. It’s pronounced S-Q-L-ite, like mineral. SQLite is notorious for implenting a bunch of functionalities from scratch. It’s a daring, amazing, bold and crazy spirit which requires confidence and professionalism.

Название: SAS Essentials: Mastering SAS for Data Analytics, 3rd Edition
Автор: Alan C. Elliott, Wayne A. Woodward
Издательство: Wiley
Год: 2023
Страниц: 576
Язык: английский
Формат: pdf (true)
Размер: 15.8 MB

Valuable step-by-step introduction to using SAS statistical software as a foundational approach to data analysis and interpretation. Presenting a straightforward introduction from the ground up, SAS® Essentials illustrates SAS using hands-on learning techniques and numerous real-world examples; keeping different experience levels in mind, the highly qualified author team has developed the book over 25 years of teaching introductory SAS courses. This book introduces data manipulation, statistical techniques, and the SAS programming language, including SAS macros, reporting results in tables, and factor analysis, as well as sections on character functions, variable manipulation, and merging, appending, and updating files. It features self-contained chapters to enhance the learning process and includes programming approaches for the latest version of the SAS platform.

Название: Data Mesh in Action (Final Release)
Автор: Jacek Majchrzak, Sven Balnojan, Marian Siwiak
Издательство: Manning Publications
Год: 2023
Страниц: 330
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

Revolutionize the way your organization approaches data with a data mesh! This new decentralized architecture outpaces monolithic lakes and warehouses and can work for a company of any size. Data Mesh in Action teaches you pragmatic ways to decentralize your data and organize it into an effective data mesh. You’ll start by building a minimum viable data product, which you’ll expand into a self-service data platform, chapter-by-chapter. You’ll love the book’s unique “sliders” that adjust the mesh to meet your specific needs. You’ll also learn processes and leadership techniques that will change the way you and your colleagues think about data. For data professionals. Requires no specific programming stack or data platform.

Название: Excel: Power Query for Advanced
Автор: Saskia Giessen
Издательство: bookboon.com
Год: 2022
Страниц: 101
Язык: английский
Формат: epub
Размер: 10.1 MB

This manual was written to accompany our seminar on Microsoft Power Query. Its target audience is users who need to import external data into Excel or transform data into Excel before further processing. The exercises in the book are easy to understand and can be adapted with little effort to your own needs. Power Query has very comprehensive feature set which is also easy to use. The software can do a great deal of work for you without requiring any programming skills. The output of Power Query is a list that you can then use for further analysis in Excel or in the data model of PowerPivot. Power Query is integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data. It offers you many other useful commands for data transformation. The chapter Many useful tools in Power Query teaches you how to detect and remove duplicates. You will find more than 400 functions in Power Query. Some of them are discussed in this manual. You will also learn about the better and faster alternative to the VLOOKUP() function.

Название: Excel Power Query, An Introduction: Business Intelligence Part I
Автор: Duncan Williamson
Издательство: bookboon.com
Год: 2022
Страниц: 167
Язык: английский
Формат: epub
Размер: 10.1 MB

The aim of this book is to introduce you to the world of Power Query in Excel. You will find myriad features and techniques in Query and you will see how straighforward it is to get to grips with them. By the end of this book, you will have worked on many real-life data sets and their solution. For example, how to clean your dirty data. You will be able to use your data sources over and over again in many useful ways. Moreover, Query is automated Excel ... everything you do is really a template that Query will apply every time you update or change your dаta: incredible in its simplicity! Power Query is a data connectivity and transformation technology in Microsoft Excel, Power BI, and other Microsoft products. It empowers any person to connect to a rich set of external data sources and even local data in a spreadsheet and collect, combine and transform the data by using a simple user interface.

Название: Building Solutions with the Microsoft Power Platform: Solving Everyday Problems in the Enterprise (Final Release)
Автор: Jason Rivera
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 350
Язык: английский
Формат: epub (true)
Размер: 25.3 MB

With the accelerating speed of business and the increasing dependence on technology, companies today are significantly changing the way they build in-house business solutions. Many now use low-code and no code technologies to help them deal with specific issues, but that's just the beginning. With this practical guide, power users and developers will discover ways to resolve everyday challenges by building end-to-end solutions with the Microsoft Power Platform. Author Jason Rivera, who specializes in SharePoint and the Microsoft 365 solution architecture, provides a comprehensive overview of how to use the Power Platform to build end-to-end solutions that address tactical business needs. By learning key components of the platform, including Power Apps, Power Automate, and Power BI, you'll be able to build low-code and no code applications, automate repeatable business processes, and create interactive reports from available data.

Название: Embedded Analytics: Integrating Analysis with the Business Workflow (3rd Early Release)
Автор: Donald Farmer, Jim Horbury
Издательство: O’Reilly Media, Inc.
Год: 2023-01-04
Язык: английский
Формат: epub, mobi
Размер: 10.2 MB

Over the past 10 years, data analytics and data visualization have become essential components of an enterprise information strategy. And yet, the adoption of data analytics has remained remarkably static, reaching no more than 30% of potential users. This book explores the most important techniques for taking that adoption further: embedding analytics into the workflow of our everyday operations. Most of us are familiar today with Business Intelligence (BI). At one time, it was a new and exciting capability, but now, thanks to self-service technologies, the cloud and the power of in-memory processing, richly featured analytic applications, data visualisations, reports and dashboards are available to almost any business user who wants wants them. The aim of embedding is to integrate visualisations, dashboards, reports and even predictive analytics or Artificial Intelligence (AI) capabilities inside your everyday business applications.

Название: Visual Data Insights Using SAS ODS Graphics: A Guide to Communication-Effective Data Visualization
Автор: LeRoy Bessler
Издательство: Apress
Год: 2023
Страниц: 627
Язык: английский
Формат: epub (true)
Размер: 95.96 MB

SAS ODS graphics users will learn in this book how to visually understand and communicate the significance of data to deliver images for quick and easy insight, with precise numbers. The data visualization tool used is SAS ODS Graphics, but the principles are software independent, relevant for any tool. Graphs can make it unnecessarily difficult to understand the data, can confuse the viewer, or can mislead the viewer. If a graph needs an explanation, it has failed to communicate. The book presents examples of bar charts, pie charts, and trend lines or time series plots, the graph types commonly used in business, other organizations, and the media for visual insight into data. Newer graphs are also included: dot plots, needle plots, waterfall charts, butterfly charts, heat maps, bubble plots, step plots, high-low plots, and donut charts. In addition, there are basic tools of statistics: scatter plots, box plots, histograms, fit and confidence plots, and distributions.