Create a data warehouse, complete with reporting and dashboards using Google's BigQuery technology. This book takes you from the basic concepts of data warehousing through the design, build, load, and maintenance phases. You will build capabilities to capture data from the operational environment, and then mine and analyze that data for insight into making your business more successful. You will gain practical knowledge about how to use BigQuery to solve data challenges in your organization.
You will:
- Design a data warehouse for your project or organization
- Load data from a variety of external and internal sources
- Integrate other Google Cloud Platform services for more complex workflows
- Maintain and scale your data warehouse as your organization grows
- Analyze, report, and create dashboards on the information in the warehouse
- Become familiar with machine learning techniques using BigQuery ML
Autorentext
Mark Mucchetti is an industry technology leader in healthcare and ecommerce. He has been working with computers and writing software for over 30 years, starting with BASIC and Turbo C on an Intel 8088 and now using Node.js in the cloud. He has been building and managing technology groups for much of that time, combining his deep love of technical topics with his management skills to create world-class platforms. Mark has also worked in databases, release engineering, front- and back-end coding, and project management. He believes that the best decisions are made with the best data available, and that BigQuery is a great technology to increase the value and accessibility of data for business leaders on a day-to-day basis. He has seen the transformation that accurate, timely data has on an organization's ability to succeed, and wants to bring that knowledge to the world in a people-first way.
Inhalt
Part I. Building a Warehouse
1. Settling into BigQuery
2. Starting Your Warehouse Project
3. All My Data
4. Managing BigQuery Costs
Part II. Filling the Warehouse
5. Loading Data Into the Warehouse
6. Streaming Data Into the Warehouse
7. Dataflow
Part III. Using the Warehouse
8. Care and Feeding of Your Warehouse
9. Querying the Warehouse
10. Scheduling Jobs
11. Serverless Functions with GCP
12. Cloud Logging
Part IV. Maintaining the Warehouse
13. Advanced BigQuery
14. Data Governance
15. Adapting to Long-Term Change
Part V. Reporting On and Visualizing Your Data
16. Reporting
17. Dashboards and Visualization
18. Google Data Studio
Part VI. Enhancing Your Data's Potential
19. BigQuery ML
20. Jupyter Notebooks and Public Datasets
21. Conclusion
22. Appendix A: Cloud Shell and Cloud SDK
23. Appendix B: Sample Project Charter
Titel
BigQuery for Data Warehousing
Untertitel
Managed Data Analysis in the Google Cloud
Autor
EAN
9781484261866
Format
E-Book (pdf)
Hersteller
Genre
Veröffentlichung
30.09.2020
Digitaler Kopierschutz
Wasserzeichen
Dateigrösse
9.32 MB
Anzahl Seiten
525
Unerwartete Verzögerung
Ups, ein Fehler ist aufgetreten. Bitte versuchen Sie es später noch einmal.