Learn to clean, model and present data: Excel, SQL, Power Query, Power BI and DAX, with datasets close to real business situations, to produce dashboards and analyses that support decisions.
Who it is for : Professionals, accountants, managers, students, data profiles.
11 course(s) shown
Core concepts: structured data, CSV and Excel files, data quality, missing values, basic statistics and first visualizations.
Clean your data, use formulas, tables and pivot tables, and build charts for a first analysis.
Query a database: SELECT, WHERE, ORDER BY, GROUP BY, aggregations, joins and subqueries, with the basics of databases.
Understand the role of indicators, data sources and dashboards in steering a business.
Import Excel or CSV files, clean them with Power Query, build a data model and create an interactive Power BI dashboard from realistic business data.
Design a solid data model (relationships, star schema) and write DAX measures for your indicators.
Import, clean, transform and combine data sources in a reproducible way before analysis.
Combine Excel and Power BI to prepare data, track indicators and produce management reports.
A complete path to become operational in data analysis: clean data in Excel, query it with SQL, model it, build a Power BI dashboard and draw useful business conclusions.
Choose the right chart, structure a dashboard and present your results in a readable, honest way.
Descriptive statistics, distributions, correlations and inference concepts useful for interpreting data.
No course matches these filters. Change your search or reset the filters.
Describe your need: we will point you to the right course or build a program adapted to your team.