Data Analysis

Data Analysis

AMD0
Categories:

About this course

Nowdays data analysts are considered to be one of the most required specialists. In any field, the main decisions are made based on data analytics.

“Data analyst preparation” course introduces you to the basics of data analytics for handling of massive databases. This course is designed to provide you the basic techniques of data analysis, modeling, learn how to present data effectively, explore data for insights.

The purpose of the training is that the participants obtain a new profession and gain a deeper knowledge of the Data Analytics.

Who can participate?
The training is for beginner data analysts, who are new to the field and seek to gain a deeper knowledge of the field.

The course description

  1. Introduction to Data analysis
  • What is data analysis
  • Top Tools used in Data Analysis
  1. Descriptive Statistics
  • What is Descriptive Statistics?
  • Univariate analysis
  1. Introduction to SQL
  • Relational Database
  • Management Systems (RDBMS)
  • Getting Started with SQL Server
  • Introduction to SQL Server Basics
  1. Getting Started with SQL Server
  • Operations with tables, set operations
  • Grouping Data
  1. Working with Data
  • Subqueries / Correlated Subqueries
  • Common Table Expressions (CTE)
  • Pivot
  • Modifying Data
  • Data Definition
  • Data Types
  • Constraints
  • Expressions
  1. Data Analysis
  • Deploying Data to MS Excel
  • Advanced Excel Functions and Formulas
  • Pivot Tables
  • Power Pivot
  1. Dynamic Dashboards
  • Building Dynamic dashboards in Excel
  1. Business Intelligence
  • Introduction to Business Intelligence
  • Business Intelligence tools
  1. Power BI
  • Getting started with Power BI
  • Building Relationships
  • Visualizations
  1. Data Analysis Expressions (DAX)
  • DAX
  • Measures

The main results
At the end of the training the participants will be able to

  • freely import, clean, manipulate and analyze data
  • build data analysis models
  • build interactive dashboards
  • have a good command of MS Excel, MS SQL Server Studio, and MS Power BI
  • knowledge of Data Analysis Expressions (DAX)

Requirements

  • Basic command of MS Excel
  • Basic Statistics
  • Basic English language knowledge for understanding the terminology and materials
  • Analytical thinking

Schedule

Program start: September 7
Duration: 32 hours, 16 classes 

Days: Wednesday, Friday 19:00-21:00

Your Investment
89.000 AMD

Trainer

Lena Mamikonyan  https://www.linkedin.com/in/lena-mamikonyan-2a2539107/

Lena has 8+ years experience in financial and banking sector.

  • She worked in ACRA Credit Reporting CJSC as a Senior Specialist at Reporting Division, than as a Head of Reporting Division. Previously Lena was a Manager of Programs in the Union of Credit Organizations of the Republic of Armenia.
  • Lena participated in various trainings concerning data analysis, for example as “MySQL for Data Analytics and Business Intelligence”.
  • Organized “Application of Econometric Models Using STATA for Addressing Economic Questions”, “Models for Deterministic (Point) and Stochastic (Interval) Forecasting ” trainings by ICARE foundation.
  • Lena also teaches Business statistics, Agribusiness Analysis and Forecasting, Business Management Applications courses in Armenian National Agrarian University