We may earn an affiliate commission when you visit our partners.
Course image
Google Career Certificates

Il s'agit du cinquième cours du certificat Google Data Analytics. Ces cours vous permettront d’acquérir les compétences dont vous avez besoin pour postuler les emplois d’analyste de données de niveau junior. Dans ce cours, vous explorerez la phase d’« analyse » du processus d'analyse des données. Vous prendrez ce que vous avez appris jusqu'ici et l'appliquerez à votre analyse pour donner un sens aux données que vous avez collectées. Vous apprendrez à organiser et à formater vos données à l'aide de feuilles de calcul et de SQL pour vous aider à regarder et à penser à vos données de différentes manières. Vous découvrirez également comment effectuer des calculs complexes sur vos données pour atteindre des objectifs commerciaux. Vous apprendrez à utiliser des formules, des fonctions et des requêtes SQL pour mener à bien votre analyse. Des analystes de données actuellement chez Google vous instruiront et vous fourniront des moyens pratiques d’accomplir les tâches courantes des analystes de données, avec les meilleurs outils et ressources.

Read more

Il s'agit du cinquième cours du certificat Google Data Analytics. Ces cours vous permettront d’acquérir les compétences dont vous avez besoin pour postuler les emplois d’analyste de données de niveau junior. Dans ce cours, vous explorerez la phase d’« analyse » du processus d'analyse des données. Vous prendrez ce que vous avez appris jusqu'ici et l'appliquerez à votre analyse pour donner un sens aux données que vous avez collectées. Vous apprendrez à organiser et à formater vos données à l'aide de feuilles de calcul et de SQL pour vous aider à regarder et à penser à vos données de différentes manières. Vous découvrirez également comment effectuer des calculs complexes sur vos données pour atteindre des objectifs commerciaux. Vous apprendrez à utiliser des formules, des fonctions et des requêtes SQL pour mener à bien votre analyse. Des analystes de données actuellement chez Google vous instruiront et vous fourniront des moyens pratiques d’accomplir les tâches courantes des analystes de données, avec les meilleurs outils et ressources.

Les participants qui terminent cette formation certifiante seront préparés à postuler à des emplois d’analyste de données de niveau junior. Aucune expérience préalable n’est nécessaire.

D’ici la fin de ce cours, vous :

- apprendrez à organiser les données pour les analyser ;

- découvrirez les processus de formatage et d'ajustement des données ;

- comprendrez comment agréger des données dans des feuilles de calcul et en utilisant SQL ;

- utiliserez des formules et des fonctions dans des feuilles de calcul pour les calculs de données ;

- apprendrez à effectuer des calculs à l'aide de requêtes SQL.

Enroll now

What's inside

Syllabus

Organiser les données pour commencer l'analyse
L'organisation des données facilite leur utilisation dans votre analyse. Dans cette partie du cours, vous apprendrez l'importance d'organiser vos données grâce au tri et au filtrage. Vous explorerez ces processus à la fois dans les feuilles de calcul et dans les SQL, alors que vous continuez à préparer vos données pour l'analyse.
Read more
Mise en forme et ajustement des données
Au fur et à mesure que vous vous rapprochez de l'analyse de vos données, vous souhaiterez que les données soient formatées et prêtes à l'emploi. Dans cette partie du cours, vous apprendrez tout sur la conversion et la mise en forme des données, y compris la façon dont les requêtes SQL peuvent vous aider à combiner des données. Vous découvrirez également la valeur des commentaires et du soutien de vos collègues et comment cela peut conduire à de nouveaux apprentissages que vous pouvez appliquer à votre travail.
Agrégation des données pour l'analyse
Dans le cadre de votre analyse, vous devrez souvent combiner des données afin d'obtenir des informations et d'atteindre des objectifs commerciaux. Dans cette partie du cours, vous explorerez les fonctions, les procédures et la syntaxe impliquées dans la combinaison ou l'agrégation de données. Vous apprendrez à le faire à partir de plusieurs cellules dans des feuilles de calcul et de plusieurs tables de base de données à l'aide de requêtes SQL.
Exécuter des calculs de données
Les calculs sont l'une des tâches les plus courantes effectuées par les analystes de données au cours de l'analyse. Dans cette partie du cours, vous allez examiner les formules, les fonctions et les tableaux croisés dynamiques des feuilles de calcul et des requêtes en SQL qui vous aideront tous à effectuer vos calculs. Vous découvrirez également les avantages de l'utilisation de SQL pour gérer les tableaux temporaires.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Conçu pour les débutants, il n'exige aucune expérience préalable
Développe des compétences requises pour postuler à des emplois d'analyste de données de niveau débutant
Enseigne comment organiser et formater des données à l'aide de feuilles de calcul et SQL
Guide les apprenants dans l'exécution de calculs complexes

Save this course

Save Analyser les données pour répondre aux questions to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Analyser les données pour répondre aux questions with these activities:
Review Data Organization Basics
Review how to organize data before beginning analysis, including sorting and filtering techniques, to prepare for the organizing activities covered in this course.
Browse courses on Data Organization
Show steps
  • Review sorting algorithms
  • Review filtering techniques
Read Data Science for Business
This book provides a comprehensive overview of data science concepts and techniques, which will help you build a strong foundation for your data analytics journey.
Show steps
  • Read the introduction and first chapter to get an overview of the book's structure and key concepts
  • Focus on understanding the concepts of data collection, cleaning, and analysis
  • Work through the exercises and examples to practice applying the concepts
Solve data analysis practice problems
Solving practice problems will help you develop your analytical skills and reinforce the concepts you've learned.
Browse courses on Data Analysis
Show steps
  • Find a collection of data analysis practice problems online or in textbooks
  • Choose a problem and carefully read the instructions
  • Solve the problem using the appropriate techniques and tools
  • Check your solution against the provided answer key
12 other activities
Expand to see all activities and additional details
Show all 15 activities
Participate in a data analysis study group
Participating in a data analysis study group will provide opportunities for collaboration, discussion, and peer support.
Browse courses on Data Analysis
Show steps
  • Find or form a study group with other students taking this course
  • Set regular meeting times and establish a study schedule
  • Review course material together, discuss concepts, and work on assignments
  • Provide support to each other and hold each other accountable
Practice Data Formatting and Transformation
Practice converting and formatting data, including using SQL queries, to reinforce skills learned during the data formatting and transformation section of this course.
Browse courses on Data Formatting
Show steps
  • Convert data from one format to another
  • Transform data using SQL queries
  • Practice combining data from multiple sources
Join a Data Analysis Study Group
Collaborate with peers to discuss course concepts, solve problems, and share insights, strengthening your understanding of the material and improving your communication skills.
Browse courses on Data Analysis
Show steps
  • Find a study group or create your own
  • Establish ground rules and meeting schedule
  • Actively participate in discussions and activities
Attend a Data Analysis Workshop
Participate in a hands-on workshop to enhance your understanding of data analysis techniques and tools, complementing the theoretical knowledge gained in this course.
Browse courses on Data Analysis
Show steps
  • Find a relevant workshop
  • Register for the workshop
  • Attend the workshop and actively participate
Attend a data analysis workshop
Attending a data analysis workshop will provide hands-on experience and exposure to industry best practices.
Browse courses on Data Analysis
Show steps
  • Research and identify data analysis workshops that align with your interests
  • Register for a workshop and prepare any necessary materials
  • Attend the workshop, actively participate in activities and discussions
  • Take notes and ask questions to maximize your learning
Build a data visualization dashboard
Creating a data visualization dashboard will allow you to apply the data analysis techniques you've learned to present insights in a visually appealing and interactive way.
Browse courses on Data Visualization
Show steps
  • Identify the key metrics and insights you want to communicate
  • Choose an appropriate data visualization tool and gather the necessary data
  • Design and build the dashboard, ensuring it's user-friendly and visually appealing
  • Present your dashboard to stakeholders and gather feedback
Learn Advanced SQL Techniques
Explore advanced SQL techniques, such as using subqueries and window functions, to enhance your ability to perform complex data analysis covered later in this course.
Browse courses on SQL
Show steps
  • Find a tutorial on advanced SQL
  • Follow the tutorial and complete exercises
  • Apply new skills to course projects
Follow tutorials on advanced data analysis techniques
Following tutorials on advanced data analysis techniques will extend your knowledge and skills beyond the scope of this course.
Browse courses on Data Analysis
Show steps
  • Identify a specific advanced data analysis technique you want to learn
  • Find a reputable tutorial or online course that covers the technique
  • Follow the tutorial step-by-step, completing any exercises or assignments
  • Apply the technique to a real-world dataset
Explore Advanced Data Manipulation Techniques in SQL
Delve deeper into SQL by learning advanced data manipulation techniques, including working with hierarchies and recursive queries, to enhance your data preparation and analysis capabilities.
Browse courses on SQL
Show steps
  • Find resources on advanced SQL data manipulation
  • Follow tutorials or take courses to learn new techniques
  • Practice using these techniques on your own data
Contribute to an open-source data analysis project
Contributing to an open-source data analysis project will provide practical experience and insights into real-world data analysis workflows.
Browse courses on Data Analysis
Show steps
  • Identify an open-source data analysis project that interests you
  • Join the project's community and familiarize yourself with their codebase
  • Identify an area where you can contribute, such as bug fixing or feature development
  • Submit a pull request with your contributions and actively engage in code reviews
Create a Data Visualization Dashboard
Combine knowledge of data organization, formatting, and analysis to create a visual representation of your data, showcasing your skills in communicating insights from data.
Browse courses on Data Visualization
Show steps
  • Gather and prepare your data
  • Choose a data visualization tool
  • Design and create your dashboard
  • Present your dashboard to others
Tutor Junior Data Analysts
Reinforce your understanding of course concepts by sharing your knowledge with junior data analysts, providing guidance and support while enhancing your communication and leadership skills.
Browse courses on Data Analysis
Show steps
  • Find opportunities to tutor junior data analysts
  • Prepare materials and lesson plans
  • Deliver tutoring sessions and provide feedback

Career center

Learners who complete Analyser les données pour répondre aux questions will develop knowledge and skills that may be useful to these careers:
Data Analyst
A Data Analyst takes raw data and turns it into insights that can help businesses make better decisions. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Business Analyst
A Business Analyst helps businesses understand their data and make better decisions. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Data Scientist
A Data Scientist uses data to solve business problems. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Machine Learning Engineer
A Machine Learning Engineer builds and deploys machine learning models. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Data Engineer
A Data Engineer builds and maintains data pipelines. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Risk Analyst
A Risk Analyst uses data to identify and manage risks. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Actuary
An Actuary uses data to assess and manage financial risks. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Epidemiologist
An Epidemiologist uses data to investigate and control the spread of disease. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
UX Researcher
A UX Researcher uses data to improve the user experience of products and services. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Market Researcher
A Market Researcher collects and analyzes data about consumers and markets. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Data Journalist
A Data Journalist uses data to tell stories. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Operations Research Analyst
An Operations Research Analyst uses data to solve business problems. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Statistician
A Statistician collects, analyzes, and interprets data. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Software Engineer
A Software Engineer designs, develops, and maintains software systems. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.
Financial Analyst
A Financial Analyst uses data to make investment decisions. This course can help you develop the skills you need to succeed in this role by teaching you how to organize, format, and analyze data. You'll also learn how to use SQL to perform complex calculations and extract meaningful insights from your data.

Reading list

We've selected ten books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Analyser les données pour répondre aux questions.
Provides a comprehensive overview of data ethics for business. It covers all the essential concepts of data ethics, from data privacy and security to data bias and discrimination.
Provides a comprehensive overview of data science for business. It covers all the essential concepts of data science, from data management and analysis to data visualization and communication.
Provides a comprehensive overview of deep learning for business. It covers all the essential concepts of deep learning, from neural networks and deep learning architectures to deep learning applications and use cases.
Is an excellent resource for learning SQL and performing data manipulation. It is well-written and easy to follow, making it a great choice for beginners or those who need a refresher.
Provides a comprehensive overview of machine learning for business. It covers all the essential concepts of machine learning, from data preparation and modeling to model evaluation and deployment.
Provides a comprehensive overview of natural language processing for business. It covers all the essential concepts of natural language processing, from text preprocessing and feature extraction to text classification and sentiment analysis.
Comprehensive guide to data analysis with Python. It covers all the essential features of Python for data analysis, from data cleaning and preparation to data visualization and analysis.
Provides a comprehensive overview of time series analysis for business. It covers all the essential concepts of time series analysis, from time series data collection and preprocessing to time series forecasting and analysis.
Comprehensive guide to data manipulation with Pandas. It covers all the essential features of Pandas, from data cleaning and preparation to data analysis and visualization.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Analyser les données pour répondre aux questions.
Le nettoyage de données
Most relevant
Préparer les données pour l'exploration
Most relevant
Compétences Excel pour l’entreprise : les notions clés
Most relevant
Introduction à l'analyse de données à l'aide d'Excel
Most relevant
Partager des données grâce à l'art de la visualisation
Most relevant
Compétences Excel professionnelles : Intermédiaire II
Most relevant
Automatiser les tâches de cybersécurité avec Python
Most relevant
Poser des questions pour prendre des décisions basées sur...
Most relevant
Mener une recherche UX et tester les premiers concepts
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser