Название: Analytics Engineering with SQL and dbt: Building Meaningful Data Models at Scale
Автор: Rui Pedro Machado, Helder Russa
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 324
Язык: английский
Формат: pdf (true)
Размер: 10.3 MB

With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. dbt (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI developers, and data scientists how to create a true self-service transformation platform through the use of dynamic SQL. Authors Rui Machado from Monstarlab and Helder Russa from Jumia show you how to quickly deliver new data products by focusing more on value delivery and less on architectural and engineering aspects. If you know your business well and have the technical skills to model raw data into clean, well-defined datasets, you'll learn how to design and deliver data models without any technical influence. This book is designed for professionals, students, and enthusiasts dealing with the complex world of data management and analytics. Whether you’re an experienced veteran reminiscing about the basic principles of data modeling or an aspiring analyst keen to understand the transformation from business intelligence to contemporary analytics engineering, our storytelling assures clearness and direction.

Название: Excel: Your No-Fuss Guide to Mastering Functions, Formulas, and Charts: Step-by-Step Instructions and Expert Tips for Rapid Learning | From Beginner to Advanced in 7 Days
Автор: Derek Collins
Издательство: Chapter Zero
Год: 2023
Страниц: 301
Язык: английский
Формат: pdf
Размер: 43.8 MB

Are you overwhelmed by the complexity of Excel, fearing it's too intricate to master on your own? Do you feel that enhancing your Excel skills is essential to excel in your career, but don't know where to start? If so, this book is designed for you. You'll learn everything you need to know to master MS Excel in just one week. Here's what’s inside: Day 1: Excel Essentials - Dive into Excel's interface with an in-depth exploration of the Ribbon, Quick Access Toolbar, Formula Bar, and more. Master basic operations and elevate your data entry game. Day 2: Mastering Formulas and Functions - Grasp Excel's formula syntax and discover a wealth of functions from SUM to advanced logical operators, all with clear, practical examples. Day 3: Data Management - Learn to sort, filter, and visually enhance your datasets. Understand conditional formatting and manage large datasets with ease. Day 4: Data Visualization - Unleash the power of visual storytelling with Excel's charting capabilities. Learn to choose and customize charts that make your data come alive. Day 5: Intermediate Techniques - Discover the magic of lookup functions, pivot tables, and advanced conditional formatting. Understand array formulas and explore dynamic arrays. Day 6: Advanced Features - Collaborate efficiently, automate with Macros, and delve into Power Query and Power Pivot. Elevate your charting techniques to a professional level. Day 7: Excel Mastery - Optimize your workflow, learn handy keyboard shortcuts, and integrate Excel with other Office applications. Plus, explore Excel security and mobile capabilities.

Название: Mapping the Enterprise: Modeling the Enterprise as Services with Enterprise Canvas
Автор: Tom Graves
Издательство: Apress
Год: 2024
Страниц: 369
Язык: английский
Формат: pdf
Размер: 11.0 MB

One of the hardest tasks strategists and enterprise architects face is mapping an enterprise in a form that creates and supports making sense of the whole. This book introduces an alternate approach to create consistency at every level by modelling the enterprise as services with the Enterprise Canvas. This new model type that can be used to describe just about anything in any area and at any level of the enterprise, and that acts as a consistent frame for all the other models that we need in our architectures. It is also simple enough to scribble on the back of a napkin - and engage all of your stakeholders in the enterprise-scale conversations you need. There is also a simple notation for Enterprise Canvas that is suitable for use in service-design toolsets. The book teaches the use of architectural techniques to describe any aspect of the enterprise. It will help you identify the business reasons and business value for every activity, and you will also learn how to align strategy, tactics and operations to enterprise vision and values. By the end of this book, you will understand how an enterprise works as a web of services, and what needs to be done to make your enterprise work in the best possible way. For Enterprise architects, Business architects, IT architects and process designers.

Название: Learning VMware Workstation for Windows: Implementing and Managing VMware's Desktop Hypervisor Solution
Автор: Peter von Oven
Издательство: Apress
Год: 2024
Страниц: 507
Язык: английский
Формат: pdf
Размер: 31.0 MB

Master VMware Workstation to create and run virtual machines, containers, and Kubernetes clusters simultaneously on physical devices without having to reformat or dual boot the underlying device. This book provides a practical, step-by-step guide to creating and managing virtual machines using VMware Workstation, a software solution that provides a type-2 hypervisor, or desktop hypervisor, that runs on x64 Windows and Linux-based operating systems. This book focuses on the Windows version. You’ll start with an overview of hypervisors and desktop hypervisors. You'll then look at resources, such as CPU, memory, and networking, and how they are configured in a virtual environment. In the final chapters, you’ll learn how to configure Workstation Pro to run and manage virtual machines before going on to build example virtual machines, including how to build a nested vSphere environment. Once built you’ll see how to manage these virtual machines, before finally upgrading your VMware Workstation Pro environment. In the end, you’ll learn how to build and manage different virtual machines running on different operating systems and build an ESXi lab environment with VMware Workstation. For developers, IT professionals that remote, home, and BYOD.

Название: Системы управления бизнес-процессами и административными регламентами на примере свободной программы RunaWFE
Автор: Михеев А.Г.
Издательство: ДМК
Год: 2016 - 2-е изд.
Cтраниц: 336
Формат: pdf (ocr)
Размер: 19 мб
Язык: русский

В книге описан процессный подход к организации управления предприятием. Даны основы проектирования бизнес-процессов. Подробно рассмотрены исполнимые бизнес-процессы, предполагающие непосредственное их исполнение в компьютерной среде предприятия. Представлено описание основных элементов систем управления бизнес-процессами и административными регламентами.

Название: Introduction to Data Science
Автор: Gaoyan Ou, Zhanxing Zhu, Bin Dong
Издательство: World Scientific Publishing
Год: 2024
Страниц: 445
Язык: английский
Формат: pdf (true)
Размер: 32.9 MB

Data Science is an emerging discipline which emphasizes the cultivation of Big Data talents with interdisciplinary ability. The book systematically introduces the basic contents of Data Science, including data preprocessing and basic methods of data analysis, handling special problems (e.g. text analysis), Deep Learning, and distributed systems. In addition to systematically introducing the basic content of Data Science from a theoretical point of view, the book also provides a large number of data analysis practice cases. Its purpose is to comprehensively introduce models and algorithms in Data Science from a technical point of view. This book systematically introduces the basic theoretical content of Data Science, including data preprocessing, basic methods of data analysis, processing of special problems (such as text analysis), Deep Learning, and distributed systems. In addition, this book provides a large number of case studies for data analysis application practice. Students can conduct practical training and interact with data on the iData-Course platform.

Название: Ultimate Excel with Power Query and ChatGPT: Master MS Excel's Dynamic Lookup Functions, Generative AI, and Power Query to Navigate Data, Solve Complex Tasks and Optimize Productivity
Автор: Crispo Mwangi
Издательство: Orange Education Pvt Ltd, AVA
Год: December 2023
Страниц: 228
Язык: английский
Формат: True/Retail EPUB
Размер: 12,4 MB

Transform Your MS Excel Skills with this Ultimate Guide for Professional Success. The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel's lookup functions. The book dives deep into Excel's lookup universe, offering a meticulous exploration of over 100 techniques. Each method is presented with clarity and precision, making even the most complex lookup scenarios comprehensible. From traditional functions to innovative problem-solving approaches, this book equips you with versatile tools to navigate any data challenge efficiently. What sets this book apart is its focus on job roles. You'll discover techniques that directly enhance productivity, streamline data management tasks, and elevate your efficiency in Excel-related responsibilities. With a comprehensive, engaging, and interactive approach, it transforms learning Excel formulas into a journey of building practical data lookup expertise. The book is tailored to address specific needs within different job roles, making it accessible and beneficial for a wide range of readers. If you are a working professional seeking to improve your Excel data lookup skills, a student in search of an interactive approach to Excel formulas, managers looking to make data-driven decisions or data analysts aiming to refine their skills or simply looking to start your career in data analysis, this book is for you.

Название: MongoDB Fundamentals
Автор: Theophilus Edet
Издательство: CompreQuest Books
Серия: Mastering Database Management Series
Год: 2023
Страниц: 333
Язык: английский
Формат: pdf
Размер: 28.8 MB

Unlock the Power of Data in the Digital Age with "MongoDB Fundamentals"! In the ever-evolving landscape of modern website development, data is the backbone of innovation. Meet MongoDB, the game-changer that empowers developers to revolutionize the way they conceive, store, and retrieve information. This comprehensive guide unravels the depths of MongoDB, offering a roadmap for harnessing its capabilities to propel your applications to new heights. Why MongoDB in Modern Website Development? Traditional databases are like rigid blueprints, constraining your creativity and adaptability. Enter MongoDB, the NoSQL database that flips the script. Its document-oriented, schema-less design allows developers to sculpt data structures as fluidly as their ideas evolve. Whether you're crafting a dynamic e-commerce platform, a responsive mobile app, or a data-intensive analytics system, MongoDB's flexibility is your secret weapon. Dear Developer, the time is now to embrace the rare benefits of MongoDB in your applications. This book is your gateway to understanding and implementing MongoDB's capabilities. Let go of the constraints of traditional databases and step into a world where your creativity knows no bounds. Dive into the fundamentals, experiment with concepts, and see MongoDB in action. This isn't just a guide; it's your hands-on companion to unlocking MongoDB's full potential.

Название: Hardware and Software Projects Troubleshooting: How Effective Requirements Writing Can Save the Day, 2nd Edition
Автор: George Koelsch
Издательство: Apress
Год: 2023
Страниц: 561
Язык: английский
Формат: pdf
Размер: 10.2 MB

Learn how to create good requirements when designing hardware and software systems. While this book emphasizes writing traditional “shall” statements, it also provides guidance on use case design and creating user stories in support of agile methodologies. The book surveys modelling techniques and various tools that support requirements collection and analysis. You’ll learn to manage requirements, including discussions of document types and digital approaches using spreadsheets, generic databases, and dedicated requirements tools. Good, clear examples are presented, many related to real-world work the author has performed during his career. More importantly, you will learn how these techniques can prevent the problems that occur during requirements development. Most of all, you will learn how good requirements governance will greatly increase the success of development projects by getting all people involved to eliminate the adverse impacts to requirements throughout the development lifecycle. Writing requirements is the most crucial aspect of systems engineering (SE). In this book, you will learn the best way to accomplish this. You will explore the requirements world, you will use the best tools, and you will learn to employ these tools. This book is intended for those of you who consider yourselves as beginners or maybe advancing to an intermediate level.

Название: Indexing Beyond the Basics
Автор: Tobias Petry
Издательство: Independently published
Год: 2023
Язык: английский
Формат: pdf (true), epub
Размер: 20.7 MB

Learn to create indexes for your slow queries by following simple principles. Hi! I'm Tobias Petry, a full stack developer who used to suck at writing fast database queries. Whenever I had a slow query, I needed to ask more advanced developers for help and hope they had time for me. Like everyone, I always wished I could solve those problems on my own. But even after reading some tutorials I didn't get any closer to my goal. The number of queries I couldn't optimize by far exceeded the ones I could make faster. So I learned everything about databases over the next 10+ years from countless books, conferences, trainings, articles and much practice. Finally, I could fix any slow query entirely without help. But during my consulting work I found that most developers still face the same problem. The reason database indexes are still not understood by developers is the depth of the existing content. Whether it is books, articles or videos - they all have their own problems that limit the ability to understand database indexing. You are a developer who can write SQL queries but struggle with creating the correct indexes to make them fast. Neither do you have the time or interest to learn this topic in weeks - a couple evenings on the couch should be enough. You also just want to learn the practical knowledge necessary to complete your task and move on to other things. The content should avoid any technical complex database implementation details - you want the core information quickly, concisely and understandably.