EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Introduction to Data Analytics (1 day Python & Excel)

Course outline

1 day

Duration

1 day

What you will learn

  • Get familiar with essential concepts of Data Analytics, Data Science, Artificial Intelligence, and Machine Learning
  • Practically understand how to map a business problem in your organization into an analytics solution
  • Learn how to build the in-house data analytics team in your organization
  • Know what kind of training or skills people need to build a successful data science team
  • Data cleaning as a pre-processing step towards making the data more consistent and high quality for data analysis
  • Explore various visualization techniques for bivariate and multivariate analysis

1. Introduction

  • Data Analytics and the applications for analytics
  • Types of Analytics
  • Exploratory Analytics: Concept, Usage, Techniques and Tools
  • Predictive Analytics: Concept, Usage, Techniques and Tools
  • Prescriptive Analytics: Concept, Usage, Techniques and Tools
  • Data Analytics team members and their roles and expected qualifications
  • How to differentiate the Data Scientists, Data Analysts, and Data Engineers?
  • How to identify the project objectives in your organization using SMART methodology?
  • 2. Data Types and Sources
  • How to prepare the right data for your data analytics project?
  • Data Repositories
  • Different Types of File Formats
  • How to design an ETL in Data Analytics Projects
  • What is Data Democratization?
  • Big Data and its applications
  • Introduction to Big Data concepts and technologies
  • Data vs. Information vs. Actionable Insights
  • 3. Data Cleaning and preparation
  • Types of Variables
  • Variable Characteristics
  • Missing Data Imputation
  • Variable transformation
  • Outlier Engineering
  • Feature Scaling
  • Engineering Date-Time
  • 4. Introduction to Data Visualizations using python
  • What is Data Visualization and Dashboarding Softwares?
  • Some Theoretical Principles Behind Data Visualization
  • Storytelling in Data Analysis
  • Histograms-Visualize the Distribution of Continuous Numerical Variables
  • Boxplots-Visualize the Distribution of Continuous Numerical Variables
  • Scatter Plot-Visualize the Relationship Between 2 Continuous Variables
  • Bar Plot
  • Pie Chart
  • Line Chart

Programme scope, delivery arrangements and suitability are confirmed during enquiry.