Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Data Engineering with dbt - A practical guide to building a cloud-based pragmatic and dependable data platform with SQL - cover

Data Engineering with dbt - A practical guide to building a cloud-based pragmatic and dependable data platform with SQL

Roberto Zagni

Publisher: Packt Publishing

  • 0
  • 1
  • 0

Summary

dbt Cloud helps professional analytics engineers automate the application of powerful and proven patterns to transform data from ingestion to delivery, enabling real DataOps.
This book begins by introducing you to dbt and its role in the data stack, along with how it uses simple SQL to build your data platform, helping you and your team work better together. You’ll find out how to leverage data modeling, data quality, master data management, and more to build a simple-to-understand and future-proof solution. As you advance, you’ll explore the modern data stack, understand how data-related careers are changing, and see how dbt enables this transition into the emerging role of an analytics engineer. The chapters help you build a sample project using the free version of dbt Cloud, Snowflake, and GitHub to create a professional DevOps setup with continuous integration, automated deployment, ELT run, scheduling, and monitoring, solving practical cases you encounter in your daily work.
By the end of this dbt book, you’ll be able to build an end-to-end pragmatic data platform by ingesting data exported from your source systems, coding the needed transformations, including master data and the desired business rules, and building well-formed dimensional models or wide tables that’ll enable you to build reports with the BI tool of your choice.
Available since: 06/30/2023.
Print length: 578 pages.

Other books that might interest you

  • Lean Leadership and Management - A Practical Guide to Streamlining Success - cover

    Lean Leadership and Management -...

    Jacob Richardson

    • 0
    • 0
    • 0
    "Lean Leadership and Management: A Practical Guide to Streamlining Success" serves as a comprehensive manual for leaders looking to implement lean principles in their organizations effectively. This guide breaks down the theoretical underpinnings of lean methodologies into actionable strategies, demonstrating how leaders can cultivate environments that embrace continuous improvement, efficiency, and customer-centricity. 
    The book starts with a deep dive into the fundamentals of lean thinking, explaining the core principles such as value stream mapping, waste elimination, and the continuous improvement process known as Kaizen. It emphasizes how these principles are not just tools but part of a broader philosophical approach to management that requires a change in mindset from top leadership levels down to frontline employees. 
    One of the standout features of the guide is its focus on the role of leadership in lean transformations. It argues that successful lean implementation is less about the tools and techniques and more about the behavior and commitment of the leaders. The book presents the traits of effective lean leaders—such as humility, curiosity, and empathy—and illustrates how these qualities are crucial in fostering a culture that is open to change and continuous improvement. 
    Practical case studies are scattered throughout the text, providing real-world examples of challenges and solutions in implementing lean strategies. These case studies help bridge the gap between theory and practice, showing readers how various concepts can be applied in different organizational contexts. Additionally, the guide includes templates and checklists to help leaders assess their current practices, plan lean initiatives, and measure their progress over time. 
     
    Show book
  • The Ward - The Life and Loss of Toronto’s First Immigrant Neighbourhood - cover

    The Ward - The Life and Loss of...

    John Lorinc, Michael McClelland,...

    • 0
    • 0
    • 0
    The story of the growth and destruction of Toronto's first 'priority neighbourhood.'
       
    From the 1840s until the Second World War, waves of newcomers who migrated to Toronto – Irish, Jewish, Italian, African American and Chinese, among others – landed in 'The Ward.' Crammed with rundown housing and immigrant-owned businesses, this area, bordered by College and Queen, University and Yonge streets, was home to bootleggers, Chinese bachelors, workers from the nearby Eaton';s garment factories and hard-working peddlers. But the City considered it a slum, and bulldozed the area in the late 1950s to make way for a new civic square.
       
    The Ward finally tells the diverse stories of this extraordinary and resilient neighbourhood through archival photos and contributions from a wide array of voices, including historians, politicians, architects, story-tellers, journalists and descendants of Ward residents. Their perspectives on playgrounds, tuberculosis, sex workers, newsies and even bathing bring The Ward to life and, in the process, raise important questions about how contemporary cities handle immigration, poverty and the geography of difference.
       
    ‘The Ward shines a light on one of Toronto's most historically significant and most forgotten neighbourhoods. Instead of a straight history, the book's editors opted to present the Ward through multiple short essays, each with its own unique point of view. The result is a fascinating and varied look at an area that once concurrently defined the city and acted as its biggest shame. As a result of the Ward's eventual razing, there are few artifacts left to teach newer generations about this important part of Toronto's history. This book helps correct that.’
       
    – 2016 Toronto Book Awards Jury Citation
       
    '[The Ward] should be of interest to Canadians anywhere, reminding us that we all came from some place else.'
       
    – Michael Enright, CBC Sunday Edition
       
    Contents & Contributors
       
    Introduction – John Lorinc
       
    Searching for the Old Ward – Shawn Micallef
       
    No Place Like Home – Howard Akler
       
    Beforethe Ward: Macauleytown – Stephen A. Otto
       
    My Grandmother the Bootlegger – Howard Moscoe
       
    Against All Odds: The Chinese Laundry – Arlene Chan
       
    VJ Day – Arlene Chan
       
    Merle Foster's Studio: 'A Spot Of Enchantment' – Terry Murray
       
    Missionary Work: The Fight for Jewish Souls – Ellen Scheinberg
       
    King of the Ward – Myer Siemiatycki
       
    Where the Rich Went for Vice – Michael Redhill
       
    A Fresh Start: Black Toronto in the 19th Century – Karolyn Smardz Frost
       
    Policing the Lord’s Day – Mariana Valverde
       
    'The Maniac Chinaman' – Edward Keenan
       
    Elsie's Story – Patte Roseban
       
    Lawren Harris's Ward Period – Jim Burant
       
    'Fool's Paradise': Hastings' Anti-Slum Crusade – John Lorinc
       
    Strange Brew: The Underground Economy of Blind Pigs – Ellen Scheinberg
       
    The Consulate, the Padroni and the Labourers – Andrea Addario
       
    Excerpt: The Italians in Toronto – Emily P. Weaver
       
    Arthur Goss: Documenting Hardship– Stephen Bulger
       
    Fresh Air: The Fight Against TB – Cathy Crowe
       
    The Stone Yard – Gaetan Heroux
       
    William James: Toronto's First Photojournalist – Vincenzo Pietropaolo
       
    The Avenue Not Taken – Michael McClelland
       
    Timothy Eaton’s Stern Fortifications – Michael Valpy
       
    Settling In: Central Neighbourhood House – Ratna Omidvar & Ranjit Bhaskar
       
    Toronto’s Girl with the Curls – Ellen Scheinberg
       
    Chinese Cafés: Survival and Danger – Ellen Scheinberg & Paul Yee
       
    Defiance and Divisions: The Great Eaton's Strike – Ruth A. Frager
       
    Elizabeth Street: What the City Directories Reveal – Denise Balkissoon
       
    Growing Up on Walton Street – Cynthia MacDougall
       
    Revitalizing George Street: The Ward's Lessons – Alina Chatterjee & Derek Ballantyne
       
    Taking Care of Business in the Ward &ndash Ellen Scheinberg
       
    'A Magnificent Dome': The Great University Avenue Synagogue – Jack Lipinsky
       
    Reading the Ward: The Inevitability of Loss – Kim Storey & James Brown
       
    Toronto’s First Little Italy – John Lorinc
       
    The Elizabeth Street Playground, Revisited – Bruce Kidd
       
    Divided Loyalties – Sandra Shaul
       
    Crowded by Any Measure – John Lorinc
       
    A Peddler and His Cart: TheWard’s Rag Trade – Deena Nathanson
       
    Toronto's Original Tenement: Wineberg Apartments – Richard Dennis
       
    Excerpt: Tom Thomson's Diary – Tom Thomson
       
    An Untimely Death – Brian Banks
       
    Paper Pushers – Ellen Scheinberg 
       
    The BMR's Wake-Up Call – Laurie Monsebraaten
       
    Excerpt: Report of the Medical Health Officer … – Charles J. Hastings
       
    Dr. Clarke's Clinic – Thelma Wheatley
       
    Slum-Free: The Suburban Ideal – Richard Harris
       
    The Glionna Clan and Toronto's First Little Italy – John E. Zucchi
       
    'The Hipp' – Michael Posner
       
    Before Yorkville– John Lorinc
       
    Sex Work and the Ward’s Bachelor Society – Elise Chenier
       
    Public Baths: Schvitzing on Centre Avenue – Ellen Scheinberg
       
    The Health Advocates: McKeown on Hastings – John Lorinc
       
    Remembering Toronto's First Chinatown – Kristyn Wong-Tam
       
    Tabula Rasa – Mark Kingwell
       
    Unrealized Renewal  – J. David Hulchanski
       
    A Short History of the 'Civic Square' Expropriation – John Lorinc
       
    Storytelling is Part of the Story – Tatum Taylor
       
    How We Think About What (Little) Survives – Patrick Cummins
       
    Institutional Memory – Scott James & Victor Russell
       
    Alternative Histories – MichaelMcClelland
    Show book
  • Sustainability Environment Territory and Society - Exploring the Critical Nexus of People Place and Planet - cover

    Sustainability Environment...

    Leonardo Flach

    • 0
    • 0
    • 0
    Why do our best-laid plans for a sustainable future so often fall short? What is the invisible thread connecting a city's design to social justice, and environmental policy to the very ground beneath our feet? 
    Sustainability, Environment, Territory, and Society unravels the critical, often overlooked, links between the world's greatest challenges. Guided by the expert analysis of Dr. Leonardo Flach, this audiobook moves beyond the headlines to offer a foundational understanding of the systems that shape our world. 
    You will discover:How geographical territories are not just maps, but arenas of power that dictate environmental outcomes.The surprising ways social structures and inequalities can accelerate or halt ecological collapse.A clear, interdisciplinary framework to analyze and solve complex environmental and social problems. 
    For students, policymakers, activists, and any engaged citizen striving to build a more equitable and sustainable future, this audiobook is not just essential listening - it is the key to understanding how these powerful forces are profoundly interconnected. Stop seeing the problems in isolation and start seeing the whole picture.
    Show book
  • Agile Manifesto - Unpacking the Agile Manifesto for Modern Development - cover

    Agile Manifesto - Unpacking the...

    Jacob Richardson

    • 0
    • 0
    • 0
    Dive into the essence of Agile methodologies with "Agile Manifesto: Unpacking the Agile Manifesto for Modern Development." This comprehensive guide explores each of the core values and principles declared in the Agile Manifesto, providing a deep and actionable understanding tailored for today's dynamic development environments. 
    In February 2001, seventeen software developers crafted the Agile Manifesto to address the inefficiencies of traditional software development practices. They proposed a revolutionary approach centered around flexibility, collaboration, and customer satisfaction. This book revisits these foundational ideas, breaking down complex concepts into practical applications, from small teams to large enterprises. 
    "Agile Manifesto" offers:In-depth analysis of the four core values and twelve principles of Agile.Practical insights on implementing Agile practices such as Scrum, Kanban, and XP within your teams.Strategies for effectively using Agile tools and technologies that enhance collaboration and productivity.Guidance on navigating challenges in distributed teams and scaling Agile methodologies across large organizations.Perspectives on the future of Agile, including its application beyond software development. 
    Whether you are a software developer, project manager, or business leader seeking to instill flexibility and efficiency in your projects, this book provides the tools and knowledge to effectively implement Agile practices. Through real-world case studies, expert interviews, and a clear, engaging narrative, "Agile Manifesto" is an essential resource for anyone looking to foster a truly Agile environment in the modern workplace. Rediscover the Agile Manifesto and transform your approach to software development and beyond. 
     
    Show book
  • Coastal Waves and Forest Birds - Nature's Melodies for Peaceful Meditation - cover

    Coastal Waves and Forest Birds -...

    Greg Cetus

    • 0
    • 0
    • 0
    Dive into tranquillity with "Coastal Waves and Forest Birds," an immersive audio experience blending the soothing rhythm of ocean waves with the gentle chirping of forest birds. Find solace in the harmonious union of nature's symphony, as the calming sounds of the coast meet the serene melodies of the forest. Perfect for meditation, let the gentle waves and bird songs guide you to a state of inner peace and relaxation.
    Show book
  • Time Song - Searching for Doggerland - cover

    Time Song - Searching for...

    Julia Blackburn

    • 0
    • 0
    • 0
    SHORTLISTED FOR THE WAINWRIGHT PRIZE AND THE HESSELL-TILTMAN PRIZEA journey told through stories and songs into Doggerland, the ancient region that once joined the east coast of England to Holland. Time Song tells of the creation, the existence and the loss of a country now called Doggerland, a huge and fertile area that once connected the entire east coast of England with mainland Europe, until it was finally submerged by rising sea levels around 5000 BC.  Blackburn mixes fragments from her own life with a series of eighteen 'songs' and all sorts of stories about the places and the people she meets in her quest to get closer to an understanding of Doggerland. She sees the footprints of early humans fossilised in the soft mud of an estuary alongside the scattered pockmarks made by rain falling eight thousand years ago. She visits a cave where the remnants of a Neanderthal meal have turned to stone. In Denmark she sits beside Tollund Man who seems to be about to wake from a dream, even though he has lain in a peat bog since the start of the Iron Age.
    Show book