Fundamentals of Analytics Engineering

Fundamentals of Analytics Engineering
Author: Dumky De Wilde
Publisher: Packt Publishing Ltd
Total Pages: 332
Release: 2024-03-29
Genre: Computers
ISBN: 1837632111

Gain a holistic understanding of the analytics engineering lifecycle by integrating principles from both data analysis and engineering Key Features Discover how analytics engineering aligns with your organization's data strategy Access insights shared by a team of seven industry experts Tackle common analytics engineering problems faced by modern businesses Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionWritten by a team of 7 industry experts, Fundamentals of Analytics Engineering will introduce you to everything from foundational concepts to advanced skills to get started as an analytics engineer. After conquering data ingestion and techniques for data quality and scalability, you’ll learn about techniques such as data cleaning transformation, data modeling, SQL query optimization and reuse, and serving data across different platforms. Armed with this knowledge, you will implement a simple data platform from ingestion to visualization, using tools like Airbyte Cloud, Google BigQuery, dbt, and Tableau. You’ll also get to grips with strategies for data integrity with a focus on data quality and observability, along with collaborative coding practices like version control with Git. You’ll learn about advanced principles like CI/CD, automating workflows, gathering, scoping, and documenting business requirements, as well as data governance. By the end of this book, you’ll be armed with the essential techniques and best practices for developing scalable analytics solutions from end to end.What you will learn Design and implement data pipelines from ingestion to serving data Explore best practices for data modeling and schema design Scale data processing with cloud based analytics platforms and tools Understand the principles of data quality management and data governance Streamline code base with best practices like collaborative coding, version control, reviews and standards Automate and orchestrate data pipelines Drive business adoption with effective scoping and prioritization of analytics use cases Who this book is for This book is for data engineers and data analysts considering pivoting their careers into analytics engineering. Analytics engineers who want to upskill and search for gaps in their knowledge will also find this book helpful, as will other data professionals who want to understand the value of analytics engineering in their organization's journey toward data maturity. To get the most out of this book, you should have a basic understanding of data analysis and engineering concepts such as data cleaning, visualization, ETL and data warehousing.

Fundamentals of Data Engineering

Fundamentals of Data Engineering
Author: Joe Reis
Publisher: "O'Reilly Media, Inc."
Total Pages: 446
Release: 2022-06-22
Genre: Computers
ISBN: 1098108272

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle. Authors Joe Reis and Matt Housley walk you through the data engineering lifecycle and show you how to stitch together a variety of cloud technologies to serve the needs of downstream data consumers. You'll understand how to apply the concepts of data generation, ingestion, orchestration, transformation, storage, and governance that are critical in any data environment regardless of the underlying technology. This book will help you: Get a concise overview of the entire data engineering landscape Assess data engineering problems using an end-to-end framework of best practices Cut through marketing hype when choosing data technologies, architecture, and processes Use the data engineering lifecycle to design and build a robust architecture Incorporate data governance and security across the data engineering lifecycle

Data Pipelines Pocket Reference

Data Pipelines Pocket Reference
Author: James Densmore
Publisher: O'Reilly Media
Total Pages: 277
Release: 2021-02-10
Genre: Computers
ISBN: 1492087807

Data pipelines are the foundation for success in data analytics. Moving data from numerous diverse sources and transforming it to provide context is the difference between having data and actually gaining value from it. This pocket reference defines data pipelines and explains how they work in today's modern data stack. You'll learn common considerations and key decision points when implementing pipelines, such as batch versus streaming data ingestion and build versus buy. This book addresses the most common decisions made by data professionals and discusses foundational concepts that apply to open source frameworks, commercial products, and homegrown solutions. You'll learn: What a data pipeline is and how it works How data is moved and processed on modern data infrastructure, including cloud platforms Common tools and products used by data engineers to build pipelines How pipelines support analytics and reporting needs Considerations for pipeline maintenance, testing, and alerting

Fundamentals of Machine Learning for Predictive Data Analytics, second edition

Fundamentals of Machine Learning for Predictive Data Analytics, second edition
Author: John D. Kelleher
Publisher: MIT Press
Total Pages: 853
Release: 2020-10-20
Genre: Computers
ISBN: 0262361108

The second edition of a comprehensive introduction to machine learning approaches used in predictive data analytics, covering both theory and practice. Machine learning is often used to build predictive models by extracting patterns from large datasets. These models are used in predictive data analytics applications including price prediction, risk assessment, predicting customer behavior, and document classification. This introductory textbook offers a detailed and focused treatment of the most important machine learning approaches used in predictive data analytics, covering both theoretical concepts and practical applications. Technical and mathematical material is augmented with explanatory worked examples, and case studies illustrate the application of these models in the broader business context. This second edition covers recent developments in machine learning, especially in a new chapter on deep learning, and two new chapters that go beyond predictive analytics to cover unsupervised learning and reinforcement learning.

Fundamentals of Data Analytics

Fundamentals of Data Analytics
Author: Rudolf Mathar
Publisher: Springer Nature
Total Pages: 131
Release: 2020-09-15
Genre: Mathematics
ISBN: 3030568318

This book introduces the basic methodologies for successful data analytics. Matrix optimization and approximation are explained in detail and extensively applied to dimensionality reduction by principal component analysis and multidimensional scaling. Diffusion maps and spectral clustering are derived as powerful tools. The methodological overlap between data science and machine learning is emphasized by demonstrating how data science is used for classification as well as supervised and unsupervised learning.

Analytics Engineering with SQL and Dbt

Analytics Engineering with SQL and Dbt
Author: Rui Pedro Machado
Publisher: "O'Reilly Media, Inc."
Total Pages: 324
Release: 2023-12-08
Genre: Computers
ISBN: 1098142357

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 Hélder 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. With this book, you'll learn: What dbt is and how a dbt project is structured How dbt fits into the data engineering and analytics worlds How to collaborate on building data models The main tools and architectures for building useful, functional data models How to fit dbt into data warehousing and laking architecture How to build tests for data transformations

Data Analytics for Engineering and Construction Project Risk Management

Data Analytics for Engineering and Construction Project Risk Management
Author: Ivan Damnjanovic
Publisher: Springer
Total Pages: 382
Release: 2019-05-23
Genre: Technology & Engineering
ISBN: 3030142515

This book provides a step-by-step guidance on how to implement analytical methods in project risk management. The text focuses on engineering design and construction projects and as such is suitable for graduate students in engineering, construction, or project management, as well as practitioners aiming to develop, improve, and/or simplify corporate project management processes. The book places emphasis on building data-driven models for additive-incremental risks, where data can be collected on project sites, assembled from queries of corporate databases, and/or generated using procedures for eliciting experts’ judgments. While the presented models are mathematically inspired, they are nothing beyond what an engineering graduate is expected to know: some algebra, a little calculus, a little statistics, and, especially, undergraduate-level understanding of the probability theory. The book is organized in three parts and fourteen chapters. In Part I the authors provide the general introduction to risk and uncertainty analysis applied to engineering construction projects. The basic formulations and the methods for risk assessment used during project planning phase are discussed in Part II, while in Part III the authors present the methods for monitoring and (re)assessment of risks during project execution.

Big Data Fundamentals

Big Data Fundamentals
Author: Thomas Erl
Publisher: Prentice Hall
Total Pages: 424
Release: 2015-12-29
Genre: Computers
ISBN: 0134291204

“This text should be required reading for everyone in contemporary business.” --Peter Woodhull, CEO, Modus21 “The one book that clearly describes and links Big Data concepts to business utility.” --Dr. Christopher Starr, PhD “Simply, this is the best Big Data book on the market!” --Sam Rostam, Cascadian IT Group “...one of the most contemporary approaches I’ve seen to Big Data fundamentals...” --Joshua M. Davis, PhD The Definitive Plain-English Guide to Big Data for Business and Technology Professionals Big Data Fundamentals provides a pragmatic, no-nonsense introduction to Big Data. Best-selling IT author Thomas Erl and his team clearly explain key Big Data concepts, theory and terminology, as well as fundamental technologies and techniques. All coverage is supported with case study examples and numerous simple diagrams. The authors begin by explaining how Big Data can propel an organization forward by solving a spectrum of previously intractable business problems. Next, they demystify key analysis techniques and technologies and show how a Big Data solution environment can be built and integrated to offer competitive advantages. Discovering Big Data’s fundamental concepts and what makes it different from previous forms of data analysis and data science Understanding the business motivations and drivers behind Big Data adoption, from operational improvements through innovation Planning strategic, business-driven Big Data initiatives Addressing considerations such as data management, governance, and security Recognizing the 5 “V” characteristics of datasets in Big Data environments: volume, velocity, variety, veracity, and value Clarifying Big Data’s relationships with OLTP, OLAP, ETL, data warehouses, and data marts Working with Big Data in structured, unstructured, semi-structured, and metadata formats Increasing value by integrating Big Data resources with corporate performance monitoring Understanding how Big Data leverages distributed and parallel processing Using NoSQL and other technologies to meet Big Data’s distinct data processing requirements Leveraging statistical approaches of quantitative and qualitative analysis Applying computational analysis methods, including machine learning

Fundamentals of Engineering Economic Analysis

Fundamentals of Engineering Economic Analysis
Author: John A. White
Publisher: John Wiley & Sons
Total Pages: 546
Release: 2020-07-28
Genre: Technology & Engineering
ISBN: 1118881060

Fundamentals of Engineering Economic Analysis offers a powerful, visually-rich approach to the subject—delivering streamlined yet rigorous coverage of the use of economic analysis techniques in engineering design. This award-winning textbook provides an impressive array of pedagogical tools to maximize student engagement and comprehension, including learning objectives, key term definitions, comprehensive case studies, classroom discussion questions, and challenging practice problems. Clear, topically—organized chapters guide students from fundamental concepts of borrowing, lending, investing, and time value of money, to more complex topics such as capitalized and future worth, external rate of return, deprecation, and after-tax economic analysis. This fully-updated second edition features substantial new and revised content that has been thoroughly re-designed to support different learning and teaching styles. Numerous real-world vignettes demonstrate how students will use economics as practicing engineers, while plentiful illustrations, such as cash flow diagrams, reinforce student understanding of underlying concepts. Extensive digital resources now provide an immersive interactive learning environment, enabling students to use integrated tools such as Excel. The addition of the WileyPLUS platform provides tutorials, videos, animations, a complete library of Excel video lessons, and much more.

Building Data Products Introduction to Data and Analytics Engineering for Non-Programmers

Building Data Products Introduction to Data and Analytics Engineering for Non-Programmers
Author: Brian McMillan
Publisher:
Total Pages: 475
Release: 2021-07-20
Genre:
ISBN: 9781737536536

Introducing Data and Analytics Engineering to a diverse group of non-technical people requires a broad exposure to specific technical skills and tools. However, in order to be effective, everyone involved, including non-technical managers, needs to understand the larger philosophy of software development. This book covers both. If you are a manager focused on the difficulties of running a business faced with constant change and competition, this book introduces a number of ways to identify, manage, communicate, and measure what is most valuable. If you are an analyst faced with the simple fact that there are never enough hours in the day to get everything done, this book balances the typical technical demonstrations with software development philosophy and business management strategies you can use to maintain focus on delivering the things with the highest business value in a sustainable way. For seasoned engineers and educators, this book is intended to serve as an introduction to teaching the hard and soft skills needed to effectively understand the entire product lifecycle and foundational philosophies of data and analytics engineering.