Course Outline
Introduction to Data Management
- Overview of data handling and storage
- Database fundamentals and table creation
- Introduction to relational models
Basic Data Analysis Techniques
- Descriptive statistics and distributions
- Histograms and control charts
- Data stratification and processing
Data Modeling for Decision-Making
- Intro to data modeling concepts
- Calendar tables and hierarchies
- Field relationships and table joins
Dynamic Reporting Tools
- Using Excel, Power Query and DAX
- Creating dashboards in Excel
- Editing and sourcing data with Power Pivot
Applied Statistical Techniques
- Basic regression and classification
- Prediction models and interpretation
- Practical data analysis scenarios
Introduction to Data Science Concepts
- Data science fundamentals
- Tools for pattern and trend detection
- Simple machine learning techniques
Data-Driven Decision-Making
- Evaluating reports for decisions
- Communicating results effectively
- Case studies and real-world applications
Summary and Next Steps
Requirements
- An understanding of basic computer operations
- Experience with spreadsheets and basic data formats
- Familiarity with Microsoft Office tools
Audience
- Environmental protection managers
- Data engineers and analysts
- Professionals seeking data-driven decision-making tools
Testimonials (4)
I liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.
Cristian Tudose - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Actual application of spotfire and all basic functions.
Michael Capili - STMicroelectronics, Inc.
Course - Introduction to Spotfire
Real world knowledge from someone in the industry
Matthew Cerbas - Shield Consulting Solutions, Inc.
Course - Grafana
I genuinely enjoyed the lots of labs and practices.