Название: Pivot for office workers: Using Excel 365 and 2021
Автор: Ina Koys
Издательство: Computertrainerin.de
Серия: Short & Spicy, vol. 16
Год: 2023
Страниц: 95
Язык: английский
Формат: epub (true)
Размер: 11.4 MB

In today's offices, much time is spent finding and structuring information in given data. Pivot Tables and Charts are the tool of choice to get it done. Their result often looks impressive, making people think it takes tremendous skills setting them up. It doesn’t! They’re easy, if only you know what result you’re looking for. In this booklet you learn everything to transform a simple Excel list to a telling Pivot Table and Chart!

Название: Database Design Using Entity- Relationship Diagrams, 3rd Edition
Автор: Sikha Saha Bagui, Richard Walsh Earp
Издательство: CRC Press
Год: 2023
Страниц: 500
Язык: английский
Формат: epub (true), mobi
Размер: 13.6 MB

Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in data modeling and mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Third Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of data modeling through ER diagramming. Building on the success of the bestselling first and second editions, this accessible text includes a new chapter on the relational model and functional dependencies. It also includes expanded chapters on Enhanced Entity-Relationship (EER) diagrams and reverse mapping. It uses cutting-edge case studies and examples to help readers master database development basics and defines ER and EER diagramming in terms of requirements (end user requests) and specifications (designer feedback to those requests), facilitating agile database development.

Название: Power BI: моделирование на экспертном уровне. Построение оптимальных моделей данных с использованием Power BI
Автор: Сохейл Бахши
Издательство: ДМК Прессs
Год: 2022
Страниц: 492
Язык: русский
Формат: pdf
Размер: 51.7 MB

Microsoft Power BI является одним из наиболее популярных инструментов бизнес-аналитики на рынке программного обеспечения для настольных и облачных решений. Книга, которую вы держите в руках, может стать вашим проводником в мир моделирования данных в целом и применительно к Power BI. Вы узнаете, как подключаться к данным в различных источниках, объединять их при помощи связей и строить полноценные модели данных. Из книги вы поймете, как использовать принципы моделирования данных и техники навигации для определения связей между сущностями и создания модели данных, после чего мы перейдем к вопросам определения новых метрик и выполнения пользовательских вычислений с использованием особенностей модели. С течением глав сложность и эффективность моделей данных будет увеличиваться, и вы научитесь использовать язык запросов DAX, а также новые техники моделирования. К концу книги вы будете обладать всеми необходимыми знаниями для структурирования и обработки данных, поступающих из разных источников, и создания на их основе полноценных моделей данных, пригодных для построения отчетов и проведения полноценного анализа данных.

Название: Office 365 for IT Pros (2023 Edition): The Ultimate Guide to Mastering Microsoft's Cloud Office System, Ninth Edition
Автор: Tony Redmond
Издательство: Redmond & Associates
Год: 2022
Страниц: 3137
Язык: английский
Формат: epub
Размер: 27.9 MB

Why buy separate books to learn about Microsoft 365, SharePoint Online, Exchange Online, OneDrive for Business, Microsoft Teams, eDiscovery, Information Protection, Compliance, and PowerShell? Office 365 for IT Pros covers all these topics and much more. Intensely practical and offering the most up-to-date coverage of its topics, Office 365 for IT Pros (2023 edition) is essential reading if you want to maximize your use of the Microsoft 365 cloud productivity service. An Office 365 tenant administrator might have to cope with five hundred individual changes annually. Office 365 for IT Pros is the only book covering tenant management refreshed monthly with updated information as changes appear in Exchange Online, SharePoint Online, Planner, Teams, Azure AD, and other important components. Until the next edition is published, your subscription allows you to download monthly updates to keep pace with developments in Office 365, meaning that Office 365 for IT Pros continues to be a valuable reference long after you first read it. Everyone involved in running an Office 365 tenant should have at least a passing acquaintance with PowerShell (and probably the Microsoft Graph APIs). We include many examples of using PowerShell across the book to help readers understand the value of being able to automate operations.

Название: Creating HTML Reports in Windows PowerShell
Автор: Don Jones, The DevOps Collective, Inc.
Издательство: Leanpub
Год: 2018-10-28
Язык: английский
Формат: pdf (true), epub, mobi
Размер: 10.2 MB

Learn to create beautifully formatted, multi-section HTML reports in PowerShell! Learn to properly use ConvertTo-HTML to produce multi-section, well-formed HTML reports but then go further with a custom EnhancedHTML module! Produce beautiful, color-coded, dynamic, multi-section reports easily and quickly. First, understand that PowerShell isn’t limited to creating reports in HTML. But I like HTML because it’s flexible, can be easily e-mailed, and can be more easily made to look pretty than a plain-text report. But before you dive in, you do need to know a bit about how HTML works. You’ll also notice that this HTML is pretty “clean,” as opposed to, say, the HTML output by Microsoft Word. This HTML doesn’t have a lot of visual information embedded in it, like colors or fonts. That’s good, because it follows correct HTML practices of separating formatting information from the document structure. It’s disappointing at first, because your HTML pages look really, really boring. But we’re going to fix that, also. In order to help the narrative in this book stay focused, I’m going to start with a single example. In that example, we’re going to retrieve multiple bits of information about a remote computer, and format it all into a pretty, dynamic HTML report. Hopefully, you’ll be able to focus on the techniques I’m showing you, and adapt those to your own specific needs.

Название: Microsoft Azure Storage: The Definitive Guide
Автор: Avinash Valiramani
Издательство: Microsoft Press/Pearson Education
Год: 2024
Страниц: 432
Язык: английский
Формат: epub (true)
Размер: 41.1 MB

Master best practices for success with all aspects of Azure cloud storage. For cloud environments to operate and scale as they should, their storage components must be designed and configured well. Now, there’s a complete, best-practice guide to designing, deploying, and managing Azure storage services for maximum performance, scalability, and value. Leading cloud consultant Avinash Valiramani shows how to make the most of Azure storage tools and services to reduce downtime, avoid unnecessary costs, simplify management, and maintain excellent performance no matter how large you scale. You’ll fi nd detailed, expert coverage of Azure blob, fi le, queue storage, managed disks, Data Share, Data Box, and more. Whatever your role in delivering efficient, reliable cloud services, this deep dive will help you make the most of your Azure investment. Azure Blob Storage supports various programming languages, including .NET, Python, Node.js, PHP, Java, and Ruby. This enables developers to integrate Azure Blob Storage to meet the needs of various applications to extend or replace the existing underlying storage. For all IT, cloud, infrastructure, storage, and virtualization administrators or architects at all levels of Azure experience

Название: Docs-as-Ecosystem: The Community Approach to Engineering Documentation
Автор: Alejandra Quetzalli
Издательство: Apress
Год: 2023
Страниц: 236
Язык: английский
Формат: pdf
Размер: 12.8 MB

Investing in engineering documentation (Docs) means investing in community user experience. This book teaches readers how mastering the docs-as-code ecosystem empowers communities to understand better their favorite products and Open-Source (OSS) technologies better. Author Alejandra Quetzalli believes that “docs-as-ecosystem” represents a more comprehensive and collaborative approach to documentation development than “docsas- code” because it recognizes that documentation is more than just code. Docs involve technical writing, design, community feedback, community management, accessibility, SEO, UX, and today… even Artificial Intelligence tools! The word ecosystem promotes a paradigm where we treat documentation as a complex and dynamic system that must be managed and nurtured. In this book, you’ll acquire practical skills such as creating public style guides, incorporating responsive and accessible design, designing user flows and information architecture, retrieving user feedback, and setting up Docs analytics. You’ll learn to identify the difference in work processes between maintaining Docs for a product versus an OSS technology. You’ll discover the secrets to managing technical writers and OSS contributions, all while building a thriving Docs community. To end on a futuristic note, you’ll discover why technical writers who harness Artificial Intelligence (AI) tools (i.e., ChatGPT) need not fear a robot uprising anytime soon.

Название: High-Performance Data Architectures: How to Maximize Your Business with a Cloud-Based Database
Автор: Joe McKendrick, Ed Huang
Издательство: O’Reilly Media, Inc.
Год: 2023-08-04
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.2 MB

By choosing the right database, you can maximize your business potential, improve performance, increase efficiency, and gain a competitive edge. This insightful report examines the benefits of using a simplified data architecture containing cloud-based HTAP (hybrid transactional and analytical processing) database capabilities. You'll learn how this data architecture can help data engineers and data decision makers focus on what matters most: growing your business. Relational databases helped in discovering and understanding trends within the business but were expensive in terms of multiuser or per-processor licensing, as well as difficult to set up and maintain. SQL itself required a robust understanding of its structure and commands. Seeking to avoid the complexity of building SQL-based queries for relational databases, along with their restrictions, a new breed of databases emerged: not only SQL (NoSQL) databases. The first generation of NoSQL databases focused on key-value stores (Berkeley DB and similar), text searching (Elasticsearch), and later document stores such as CouchDB and MongoDB.

Название: MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203
Автор: Benjamin Perkins
Издательство: Sybex
Год: 2023
Страниц: 1008
Язык: английский
Формат: epub (true)
Размер: 84.9 MB

Prepare for the Azure Data Engineering certification―and an exciting new career in analytics―with this must-have study aide In the MCA Microsoft Certified Associate Azure Data Engineer Study Exam DP-203 , accomplished data engineer and tech educator Benjamin Perkins delivers a hands-on, practical guide to preparing for the challenging Azure Data Engineer certification and for a new career in an exciting and growing field of tech. In the book, you’ll explore all the objectives covered on the DP-203 exam while learning the job roles and responsibilities of a newly minted Azure data engineer. From integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions, you’ll get up to speed quickly and efficiently with Sybex’s easy-to-use study aids and tools. This Study Guide also A one-of-a-kind study aid designed to help you get straight to the crucial material you need to succeed on the exam and on the job, the MCA Microsoft Certified Associate Azure Data Engineer Study Exam DP-203 belongs on the bookshelves of anyone hoping to increase their data analytics skills, advance their data engineering career with an in-demand certification, or hoping to make a career change into a popular new area of tech.

Название: The Big Book of PowerShell Gotchas
Автор: Don Jones, The DevOps Collective, Inc.
Издательство: Leanpub
Год: 2018-10-28
Язык: английский
Формат: pdf (true), epub
Размер: 13.5 MB

PowerShell is full of "gotchas" - little things that just get in your way and are hard to figure out on your own. This short book is intended to help you figure them out and avoid them. One tricky thing is understanding that there are a certain number of commands that come with PowerShell, _while _most commands do not. Every new version of PowerShell includes at least a few new commands. For example, Start-Job appeared for the first time in PowerShell v2, while Invoke-AsWorkflow was introduced in PowerShell v3. What confuses people is that a new version of PowerShell also tends to correspond with a new version of the Windows operating system? and the OS itself comes with hundreds of commands. For example, you may have used Get-SmbShare for the first time in Windows Server 2012, which included PowerShell v3. But Get-SmbShare is part of the operating system, not part of PowerShell. That is, you won’t have Get-SmbShare on every system that has PowerShell v3 or later, because the command isn’t a “feature of PowerShell,” it’s a “feature of Windows.” So? where do you get commands?