This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision making.
(39 avis)
Ce que vous apprendrez
Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.
Analyze, Clean and transform your data in BigQuery with SQL.
Ingest new BigQuery datasets, and use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
Use Dataform to develop scalable data transformation pipelines in BigQuery.
Détails à connaître
Ajouter à votre profil LinkedIn
Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées
Obtenez un certificat professionnel
Ajoutez cette qualification à votre profil LinkedIn ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance
Il y a 9 modules dans ce cours
This module introduces the course agenda.
Inclus
1 vidéo
In the first module, we look at analytics challenges faced by data analysts and compare big data on-premises versus on the Cloud. We then introduce BigQuery, which is Google Cloud’s enterprise data warehouse, and review its features that make BigQuery a great option for your data analytics needs. And finally, we’ll learn from real-world use cases of companies transformed through analytics on the Cloud.
Inclus
5 vidéos
This module is all about exploring your data with SQL, or structured query language. We go from very simple select statements to more complex queries that explore various datasets.
Inclus
9 vidéos3 éléments d'application
In this module, we discuss principles about data integrity, and then we look at how to use SQL to clean, prepare, and transform your data. The last section of this module also briefly introduces other products like Dataprep, Cloud Data Fusion, Dataflow, Dataproc, and Dataform that can help with data preparation and transformation.
Inclus
4 vidéos
This module talks about ingesting and storing data into BigQuery native storage. We discuss when to use Extract and Load, versus Extract, Load and Transform, versus Extract Transform and Load approaches for loading data into BigQuery.We also cover external data sources, where you can run your query in BigQuery, but the data is hosted outside of BigQuery.
Inclus
6 vidéos2 éléments d'application
This module is where all that hard work around ingesting, cleaning, preparing, and transforming your data comes to fruition as you get to visualize insights from your data by building insightful dashboards and reports. We start off with a little visualization theory and some best practices, and then look at tools, like Looker Studio and Connected Sheets, that can connect to BigQuery and help create impactful visualizations to capture and convey your insights. Although SQL is a powerful query language, programming languages such as Python, Java, or R provide syntaxes and a large array of built-in statistical functions that data analysts might find more expressive and easier to manipulate for certain types of data analysis. Such tools include open source web-based applications like Jupyter Notebooks, and so we discuss these as well.
Inclus
8 vidéos2 éléments d'application
Creating, maintaining, and versioning SQL pipelines is a lot of hard work. And many times, data analysts have to use multiple tools to achieve this. So in this module, we introduce Dataform, a new product that offers a unified end-to-end experience to develop, version control, and orchestrate SQL pipelines in BigQuery.
Inclus
5 vidéos1 élément d'application
In this module, we will start off by talking about what BigQuery Studio is, and the reason we built it. Next, we describe in a little more detail all the great capabilities that come with BigQuery Studio. In the end, we wrap up the module with a demo to walk you through the cool features and show you how to use it.
Inclus
7 vidéos1 élément d'application
This module recaps the key topics covered in the course.
Inclus
1 vidéo
Instructeur
Offert par
Recommandé si vous êtes intéressé(e) par Cloud Computing
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Avis des étudiants
Affichage de 3 sur 39
39 avis
- 5 stars
64,10 %
- 4 stars
28,20 %
- 3 stars
2,56 %
- 2 stars
5,12 %
- 1 star
0 %
Révisé le 25 avr. 2024
Ouvrez de nouvelles portes avec Coursera Plus
Accès illimité à plus de 7 000 cours de renommée internationale, à des projets pratiques et à des programmes de certificats reconnus sur le marché du travail, tous inclus dans votre abonnement
Faites progresser votre carrière avec un diplôme en ligne
Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne
Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires
Améliorez les compétences de vos employés pour exceller dans l’économie numérique
Foire Aux Questions
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.