Data Analytics
78 consultations
Description
This course introduces participants to data analytics methods and tools, from data collection and cleaning to visualization and interpretation for decision-making. It covers the industry's essential tools (advanced Excel, SQL, Power BI) as well as an introduction to programming languages used in data analysis.
Objectifs pédagogiques
Understand the fundamentals of data analytics and its role in business Collect, clean, and structure datasets Use advanced Excel for data analysis and processing Query databases using SQL Create dashboards and visualizations with Power BI Introduce participants to programming basics for data (Python) Interpret results and formulate relevant recommendations
Programme détaillé
-Introduction to data analytics and its business impact -Data lifecycle: collection, cleaning, structuring -Advanced Excel: pivot tables, complex formulas, macros -Introduction to relational databases -SQL language: queries, joins, aggregations -Introduction to Power BI: data connection and modeling -Creating dashboards and visual reports -Introduction to Python for data (Pandas, NumPy libraries) -Descriptive statistics and data interpretation -Best practices in data visualization and storytelling -End-to-end case study and practical project -Presentation and reporting of results
Prérequis
-Level BAC/BAC+ -Regular use of a computer and office tools is recommended. -Basic math skills (simple statistics) Advantages (provided by EPA) Expert trainers from the data industry Work on real datasets and hands-on projects Certificate of completion issued by EPA Personalized support throughout the training program Post-training follow-up and career support Access to a network of partner companies and alumni in the data/tech sector Career opportunities Data analyst Statistical analyst Business intelligence (BI) analyst Reporting and dashboard specialist Data and decision-support consultant Junior/associate data scientist