Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Data Exploration and Preparation with BigQuery

You're reading from   Data Exploration and Preparation with BigQuery A practical guide to cleaning, transforming, and analyzing data for business insights

Arrow left icon
Product type Paperback
Published in Nov 2023
Publisher Packt
ISBN-13 9781805125266
Length 264 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Mike Kahn Mike Kahn
Author Profile Icon Mike Kahn
Mike Kahn
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

Preface 1. Part 1: Introduction to BigQuery
2. Chapter 1: Introducing BigQuery and Its Components FREE CHAPTER 3. Chapter 2: BigQuery Organization and Design 4. Part 2: Data Exploration with BigQuery
5. Chapter 3: Exploring Data in BigQuery 6. Chapter 4: Loading and Transforming Data 7. Chapter 5: Querying BigQuery Data 8. Chapter 6: Exploring Data with Notebooks 9. Chapter 7: Further Exploring and Visualizing Data 10. Part 3: Data Preparation with BigQuery
11. Chapter 8: An Overview of Data Preparation Tools 12. Chapter 9: Cleansing and Transforming Data 13. Chapter 10: Best Practices for Data Preparation, Optimization, and Cost Control 14. Part 4: Hands-On and Conclusion
15. Chapter 11: Hands-On Exercise – Analyzing Advertising Data 16. Chapter 12: Hands-On Exercise – Analyzing Transportation Data 17. Chapter 13: Hands-On Exercise – Analyzing Customer Support Data 18. Chapter 14: Summary and Future Directions 19. Index 20. Other Books You May Enjoy

Introducing BigQuery and Its Components

BigQuery is a fully managed serverless data warehouse that helps users and enterprises manage and analyze data with SQL. It includes features for data sharing, machine learning, geospatial analysis, and business intelligence.

In this chapter, you will be introduced to BigQuery and how the service operates. By gaining an understanding of how this service is delivered and how it functions, you will be able to use BigQuery more effectively.

This chapter will introduce and describe the first two, most critical steps of data analysis: data exploration and data preparation. By the end of this chapter, you will have a solid foundational understanding of BigQuery and how to begin preparing data to make it more useful and insightful.

In this chapter, we’re going to cover the following main topics:

  • What is BigQuery?
  • How does BigQuery work?
  • BigQuery administration and access
  • BigQuery best practices and cost management...
You have been reading a chapter from
Data Exploration and Preparation with BigQuery
Published in: Nov 2023
Publisher: Packt
ISBN-13: 9781805125266
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime