Professional Data Analyst — From raw data to decision-ready insights
A complete professional pathway for turning raw data into reliable analysis, useful metrics and recommendations that business teams can act on.
A Data Analyst turns data from multiple sources into reliable information that helps an organization understand what is happening, measure performance and make better decisions. The role involves framing business questions, checking data quality, building analyses and metrics, and communicating results clearly to decision-makers.
This pathway teaches the full workflow: decision framing, data quality and preparation, Excel, SQL, Power Query, analytical modeling, Power BI, decision-oriented statistics, Python/pandas, APIs and automation. You will also learn to test and reconcile results, document analyses, govern metrics and defend professional recommendations with evidence.
metiers_prof_data_analyst_outcome
15 courses • 150 interactive lessons • 45 to 75 hours of conversational learning
Best offer
Pack Complet — Data Analyst
399,00 € excl. VAT
Savings : 124,80 €
74,70 €
64,90 excl. VAT
Savings : 9,80 €
Understand the Data Analyst role and frame a decision
Adopt a professional Data Analyst mindset and turn a business request into a measurable analytical question.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
No advanced prerequisite. Everyday computer skills and an interest in data analysis or problem solving are sufficient to start.
- Understand the Data Analyst role in the organization and how it works with business teams
- Distinguish the stated request, the underlying problem, and the decision that needs support
- Select relevant indicators and distinguish metrics, KPIs, targets, and alert thresholds
- Professional workshop: scope an analysis end to end and obtain validation of the analytical question
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: scope an analysis end to end and obtain validation of the analytical question
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
24,90 € excl. VAT
Understand, structure and assess data
Read a dataset’s structure, understand its origin and assess its quality before starting any analysis.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
No advanced prerequisite. Everyday computer skills and an interest in data analysis or problem solving are sufficient to start.
- Understand the data lifecycle: collection, storage, transformation, use, and retention
- Determine a table’s grain and detect changes in granularity
- Profile a dataset and prioritize anomalies
- Professional workshop: audit a deliberately inconsistent customer-and-orders file
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: audit a deliberately inconsistent customer-and-orders file
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
24,90 € excl. VAT
Analyze with Excel, descriptive statistics and visualization
Explore a dataset, validate calculations and communicate an initial conclusion using Excel and appropriate visualizations.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
No advanced prerequisite. Everyday computer skills and an interest in data analysis or problem solving are sufficient to start.
- Turn an Excel range into an analysis-ready table and validate data types
- Use lookup functions to match and reconcile data
- Choose and design the right visualization: key message, visual hierarchy, comparisons, scales, and chart bias
- Professional workshop: produce an initial analysis note from a raw file
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: produce an initial analysis note from a raw file
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
24,90 € excl. VAT
89,70 €
76,90 excl. VAT
Savings : 12,80 €
Query a relational database with SQL
Understand the relational model and write reliable SQL queries to filter, transform and aggregate data.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Understand tables, rows, columns, keys, and relationships in a relational database
- Combine filters, logical operators, lists, and ranges
- Handle NULL correctly and distinguish missing values, zero, and empty strings
- Professional workshop: build and validate a SQL sales report
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: build and validate a SQL sales report
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
29,90 € excl. VAT
Master joins and build maintainable SQL queries
Combine multiple tables without double counting and structure complex SQL logic so it remains readable and maintainable.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Understand what joins do and choose the right starting table
- Interpret one-to-one, one-to-many, and many-to-many cardinalities
- Use subqueries and CTEs to make complex SQL readable and maintainable
- Professional workshop: build a multi-table customer-product analysis without duplication
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: build a multi-table customer-product analysis without duplication
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
29,90 € excl. VAT
Prepare multi-source data with Power Query
Build a reproducible preparation workflow from files, databases and analytical data warehouses.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Import and profile data from files, relational databases, and cloud data warehouses such as BigQuery or Snowflake using Power Query or another suitable connector
- Build repeatable data-cleaning rules instead of relying on manual fixes
- Merge and append queries while validating matches
- Professional workshop: consolidate omnichannel sales from three different sources
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: consolidate omnichannel sales from three different sources
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
29,90 € excl. VAT
104,70 €
89,90 excl. VAT
Savings : 14,80 €
Build an analytical model and DAX measures
Organize data in a star schema and build consistent business measures in Power BI.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Build a star schema with fact tables, dimensions, and a calendar
- Validate the granularity of each table before creating relationships
- Create business measures in Power BI and understand calculated columns versus measures
- Professional workshop: model sales, targets, and calendar data, then build the key measures
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: model sales, targets, and calendar data, then build the key measures
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
34,90 € excl. VAT
Design and validate a decision-oriented Power BI dashboard
Create a clear, interactive and reconciled Power BI report that business users can genuinely use to make decisions.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Identify a dashboard’s audience, decision, and frequency of use
- Choose visuals for comparison, change over time, distribution, or composition
- Validate a dashboard by reconciling it with source data
- Professional workshop: build a complete operational performance dashboard
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: build a complete operational performance dashboard
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
34,90 € excl. VAT
Analyze time, funnels, cohorts and segments
Explore behavior and performance changes by combining time analysis, conversion, retention and segmentation.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Prepare a time dimension and distinguish event date, processing date, and reference date
- Build a funnel and measure conversion rates between stages
- Segment a population using relevant business criteria
- Professional workshop: analyze a conversion drop and defend several competing hypotheses
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: analyze a conversion drop and defend several competing hypotheses
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
34,90 € excl. VAT
119,70 €
101,90 excl. VAT
Savings : 17,80 €
Master decision-oriented statistics and experimentation
Quantify uncertainty, test hypotheses and interpret experiments without overstating what the evidence supports.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Connect a statistical question to a business decision and the cost of being wrong
- Build and interpret a confidence interval
- Analyze an A/B test correctly: metric, sample size, duration, significance, and bias
- Professional workshop: design, audit, and defend an experimentation protocol
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: design, audit, and defend an experimentation protocol
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
39,90 € excl. VAT
Build reproducible analyses with Python and pandas
Use Python and pandas to prepare, transform and validate data within a reproducible analytics project.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Set up an isolated Python environment and document its dependencies
- Clean missing values, duplicates, and formatting issues with pandas
- Use groupby and aggregation functions without losing the intended granularity
- Professional workshop: build a controlled pandas pipeline from raw data
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: build a controlled pandas pipeline from raw data
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
39,90 € excl. VAT
Automate data flows, APIs and analytical monitoring
Automate a robust and observable analytics workflow that handles failures without publishing invalid results.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Automate data imports from files and APIs, consistency checks, and result exports with Python
- Handle timeouts, outages, quotas, and retry logic
- Build blocking controls and warning controls
- Professional workshop: automate a daily report with controls, alerts, and recovery
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: automate a daily report with controls, alerts, and recovery
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
39,90 € excl. VAT
135,00 €
114,90 excl. VAT
Savings : 20,10 €
Industrialize, test and maintain an analytics solution
Make analytical work versioned, tested, performant, observable and maintainable in an enterprise environment.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Structure and version an analytics project with Git: sources, transformations, models, reporting, branches, and change history
- Automate quality controls and rejected-data handling with SQL and Python
- Use generative AI in a controlled way to assist with SQL, Python, documentation, and anomaly investigation, with systematic verification of outputs
- Professional workshop: turn a fragile reporting process into a governed analytics product
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: turn a fragile reporting process into a governed analytics product
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
45,00 € excl. VAT
Govern, secure and drive adoption of an analytics product
Define responsibilities, protect data and embed an analytics product in sustainable, compliant business use.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Understand data-governance roles and decision-making bodies
- Implement access rights and distribution rules appropriate for sensitive data
- Organize maintenance, refresh frequency, and service commitments
- Professional workshop: build the governance dossier for a sensitive analytics product
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: build the governance dossier for a sensitive analytics product
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
45,00 € excl. VAT
Lead an analytics engagement and defend a decision
Own an end-to-end analytics engagement, prioritize value, validate the solution and defend an executive recommendation.
Course information
Data, reporting, finance, operations and performance professionals who want to perform or strengthen the practical skills of a Data Analyst.
You should already master the pathway foundations or have equivalent experience. Advanced courses build on methods, tools and controls introduced earlier.
- Qualify a strategic request and identify the decision that actually needs support
- Prioritize an analytics backlog by value, effort, risk, and frequency of use
- Build a quantified recommendation with scenarios, impacts, and assumptions
- Final project: deliver a complete decision analysis, dashboard, controls, versioned work, and executive presentation
- Apply the course methods and tools to a representative professional situation.
- Produce a usable and verifiable outcome by combining the concepts covered: deliver a complete decision analysis, dashboard, controls, versioned work, and executive presentation
- Check the quality of data, results, evidence or decisions before communication or implementation.
- Document the approach, explain limitations and defend the choices made to a professional stakeholder.
3 to 5 h
45,00 € excl. VAT