The Basics of Data Analysis – Part 1
This course offers a clear and accessible introduction to the fundamentals of data analysis. It helps you discover the types of data, the main steps of their preparation and analysis, as well as the essential tools to organise, the
Create your free account
How the course works
Each lesson is a structured text, illustrated with examples and diagrams, followed by a quiz that is automatically graded. You progress at your own pace, and your notes stay attached to the lesson in which you took them.
-
Gain a solid command of the fundamentals of data analysis
-
Identify and understand the different types of data
-
Know how to organise, prepare and analyse data
-
Use suitable tools to make effective use of data
-
Develop the ability to interpret the results and to make informed decisions
-
Data Analyst: collects, prepares and analyzes data to support decision-making.
-
Data Analyst Assistant: takes part in preparing, processing and interpreting data.
-
Research Officer: carries out analyses and produces reports based on data.
-
BI Analyst: turns data into indicators and dashboards that are useful for steering performance.
-
Data quality analyst: monitors the quality, consistency and reliability of data.
-
Marketing analyst: uses data to understand behaviours and trends.
-
Business analyst: analyses sales performance and identifies opportunities.
-
Data consultant: supports organisations in exploiting and analysing their data.
-
Reporting specialist: designs reports and visualisations to make performance tracking easier.
Accessibility

You have a disability and wish to take a training course with us? This email address is dedicated to you: contact@datagoz.com . For any other situation, don't hesitate to contact us to assess how to ensure a learning experience.
How do I finance my training?
Certificate of completion: at the end of this course, you will receive a DATAGOZ certificate of completion, issued in your name and verifiable online.
The DATAGOZ team wishes you a great training!
11 chapters, 52 lessons
- 4. Developing an analytical vision of datasubscribers
- 4. Understanding fields and the different data typessubscribers
- 4. Creating new data using operations and functionssubscribers
- 4. Mastering the syntax of data analysis toolssubscribers
- 4. Discovering the main SQL statementssubscribers
- 4. Practical exercise: interpreting an SQL querysubscribers
- 4. Solution to the exercise: interpreting an SQL querysubscribers
- 5. Interpreting existing data effectivelysubscribers
- 5. Identifying and collecting available data sourcessubscribers
- 5. Mastering the basics of data cleaningsubscribers
- 5. Analysing data flows and associated processessubscribers
- 5. Mastering joins between multiple data sourcessubscribers
- 5. Putting joins into practice with Microsoft Accesssubscribers
- 5. Practical exercise: create a join between two tablessubscribers
- 5. Solution to the exercise: using joins in Accesssubscribers
- 6. Understanding the CRISP-DM methodology to structure a data projectsubscribers
- 6. Mistakes to avoid in a data analysis projectsubscribers
- 6. Exploring and analysing an Excel datasetsubscribers
- 6. Mastering the fundamentals of data visualisationsubscribers
- 6. Using structured tables in Excel to analyse datasubscribers
- 8. Discover the ETL process to integrate and add value to datasubscribers
- 8. Automate data cleaning with Excel macrossubscribers
- 8. Master data cleaning with Power Querysubscribers
- 8. Activate and use Power Pivot in Excelsubscribers
- 8. Build a data model with Power Pivotsubscribers
- 8. Create and use key performance indicators (KPIs) with Power Pivotsubscribers
- 8. Practice renaming column headers with Power Querysubscribers
- 8. Reproduce the renaming of column headers with Power Querysubscribers
- 9. Transform and convert data efficiently with Power Querysubscribers
- 9. Identify and remove duplicates in datasubscribers
- 9. Standardize data using find and replace valuessubscribers
- 9. Explore Power BI, the data analysis and visualization toolsubscribers
- 9. Explore time series analysis with Excelsubscribers
- 9. Use PivotTables to analyze datasubscribers
- 9. Use the Analysis ToolPak statistical add-in in Excelsubscribers
- 9. Practice simple linear regression with Excelsubscribers
Everything that comes with the lessons
How long, depending on your availability
What you get at the end
Once the course is completed, the certificate is issued in your name. Its code allows a recruiter to verify it in just a few seconds.
This is not a diploma or a professional certification; it is verifiable proof that you have followed and successfully completed this course.
Who writes this course
A clear, hands-on teaching approach, with concrete examples to help you learn effectively.
Before you start
Start this course today
4 open lessons, no credit card required. You'll see the level and tone before deciding.