IIBA Endorsed Certified Data Analyst
Course Methodology
This course uses Excel for analyzing complex datasets. Participants will collaborate on analyzing a real-world business case and will be expected to present their data-driven insights in a simulated board meeting.
Course Objectives
By the end of the course, participants will be able to:
-
Explain the importance of data analysis and the role of a data analyst in informing business decisions
-
Define business problems with data analytics tools and identify relevant data for them
-
Clean data and use descriptive statistics on it to describe business problems
-
Explain the reasons for business problems with data analysis diagnosis tools
-
Develop a solid data-driven presentation to offer compelling business recommendations
Target Audience
Analysts and professionals who are looking to build their data analysis skills as well as those who are interested in improving their decision-making capabilities based on data-driven insights.
Target Competencies
- Analytical thinking
- Sourcing data
- Cleaning data
- Validating data
- Structuring data
- Analyzing data
- Data visualization
Course Outline
- Fundamentals of Data Analysis
- Goal of data analytics
- Corporate decision-making malpractices
- Decision-making spectrum
- Emotional vs. rational corporate decisions
- Types of analytics methods
- Data analytics lifecycle
- Competencies of data analysts
- Problem Definition and Data Collection
- Defining the business problem or opportunity
- Business problems as data analysis questions
- Business problems as objectives
- Developing objectives using KPIs
- Collecting data
- Qualitative and quantitative data
- Planning data collection
- Defining the business problem or opportunity
- Data Cleaning and Descriptive Analysis
- Data cleaning operations
- Handling missing/duplicate data
- Replacing missing data and outliers
- Descriptive statistics
- Key components of descriptive statistics
- Measures of central tendency
- Measures of dispersion
- Data sampling
- Data cleaning operations
- Diagnostic and Predictive Analytics
- Diagnostic analytics
- Techniques used in diagnostic analysis
- Drill-down diagnostic analytics
- Correlation diagnostic analytics
- Regression diagnostic and predictive analytics
- Formulating hypotheses
- Hypothesis testing and statistical significance
- Data-Driven Business Recommendations
- Univariate visualizations (single variable)
- Bivariate visualizations (two variables)
- Multivariate visualizations (three or more variables)
- Specialized visualizations
- Business recommendations
- Storytelling elements
- Data-driven stories
Face to Face Courses
Ready to advance your career?
Join thousands of professionals who have already enhanced their skills with Al Mawred.
Register for this course