Data Analysis: Junior Data Analyst Training Overview:
Data Analysis is one of the most sought-after professions in recent times due to technological advancements in data gathering and interpretation. The demand for the skill and the limited supply of it has created opportunities for skilled data analysts to earn lots of money in salary and commission.
Learning Data Analysis for Junior Developers will give you practical experience in Data Analysis using Microsoft Excel. The course is designed to equip participants with the skills and knowledge required to analyze, visualize, clean up, and interpret data effectively.
This program is designed to prepare junior data analysts for success in their roles by providing a comprehensive understanding of data analysis techniques, problem-solving skills, and effective communication and storytelling. Participants will gain hands-on experience in data collection, analysis, visualization, and reporting while learning to convey their insights compellingly. Through a series of hands-on projects and case studies, students will learn essential Excel functions, various data analysis tools, data cleaning and manipulation techniques, statistical analysis, and data visualization methods.
Data Analysis: Junior Data Analyst Training Course Outline:
Module 1: Introduction to Data Analysis
- Highlights of Data Analytics
- Data Strategy using the Convo Model
- Data Quality Framework
- Overview of Data Analytics Workflow
Module 2: Introduction To Excel
- Introduction to Excel functions, Sum if, Count if, Sum-ifs, concat etc.
- Working with Table calculation & Naming Arrays in Excel
- Learn how to search user information in a table using Lookup functions
- Group records and make logical comparisons with nested if statements
Module 3: Handling Data with Excel
- Load, Data Cleaning and Data Transformation with Power Query Editor
- Debugging Connection Errors in Power Query Editor
- Creating Relationships and Modelling multiple tables with Power Pivot
- Descriptive Analysis using the Data Analytics tool Pak
- Exploratory Data Analysis with Power Pivot
- Creating Calculated fields using DAX in Power pivot
Module 4: Data Reporting and Data Visualization with Excel
- Use Charts and visual aids for Impactful visual perception & visual storytelling
- Create dashboards for visualizing business data and storytelling with data
- Use dashboard actions to create interactions within storyboards
Module 5: Introduction to Power Bi Desktop, Handling Data & Modelling with Power BI
- Working and designing Power Bi Canvas
- Load, Data Cleaning and Data Transformation with Power Query Editor
- Building a Comprehensive Data Model, Date Tables and Bridge tables in Power Bi
- Connecting Multiple tables and creating Relationships in PowerBi desktop
Module 6: Introduction to Data Analytic Expressions
- Introduction to measures & tables using DAX
- Creating KPIs and metrics for Business decision-making
Module 7: Data Reporting and Data Visualization with Power Bi
- Introduction to Data Visualization and Power Bi
- Creating Dashboards to Visualize KPIS and Metircs to enhance business decisions
Module 8: Effective Communication of Data Findings
- Tailoring communication to technical and non-technical audiences.
- Presenting data findings with impact.
- Communication tools and best practices.
- Become Job Ready
- Become an expert in the field.
- Increase earning potential.
I am Deborah Osilade, I am a Data Analyst and an Instructor at Piston and Fusion Business Academy. I love leveraging data to create high-quality data-intelligent solutions. I enjoy working on building Predictive Models, Financial models and designing Dashboards solutions. My specialization and core skills are in Finance, Data Science & Machine Learning. I have a Post Graduate Diploma in Data Science and Business Analysis from the University of Texas at Austin and a B.A. Accounting and Finance degree from Middlesex University. My proficiency with data science tools spans Programming Language for Data Science, Data visualization, and Data management tools.
Data Analysis: Junior Data Analyst Training Course Fees & Dates for Upcoming Classroom Classes In 2024
| Classroom | Virtual | |
| Date | 18th Apr – 10th May, 2024 | 18th Apr – 10th May, 2024 |
| Fees | ₦250,000 | ₦250,000 |
| Training Days | Thurs & Fri | Thurs & Fri |
| Training Time | 1pm – 4pm | 8am – 11am |
| Location | 123a Obadina street Lagos | Zoom & Microsoft Teams |
Course FAQ
Related Courses
