Skip to content

Latest commit

 

History

History
112 lines (86 loc) · 3.72 KB

README.md

File metadata and controls

112 lines (86 loc) · 3.72 KB

What is Data Analysis?

The process of collecting and processing the raw data and preparing the required statistics are what data analysts do. Their job responsibilities rotate around this and it’s likely less typical than that of a Data Scientist. However, they play a very major role in taking business decisions (that being taken based on their extracted data and stats) and identifying the pain points of customers that eventually helps businesses in changing their approach for better growth.

Responsibilities of Data Analyst

Well, that depends upon the type of organization that you’ll be working on because nowadays every industry is looking out for such professionals despite their size (small-medium-large). Although, some of the key responsibility includes:

  • To develop and analyze the report
  • To manage master data right (create -> update -> delete)
  • To support the data warehousing in inspecting the reporting requirements.
  • To troubleshoot the reporting DB environment and reports.
  • Coordinating with developers, and engineers to gather insight for improvement and making modifications for data governance.
  • Use of statistical tools to interpret data sets, and to follow any ongoing trend that could be valuable.

Why Data Analyst?

Being a Data Analyst you will be working on real-life problem-solving scenarios and with this fast-paced, evolving technology, the demand for Data Analysts has grown enormously. Moving with this pace of advancement, the competition is growing every day and companies require new methods to compete for their existence and that’s what Data Analysts do.

Let’s understand in some simple ways:

  • Being a Data Analyst, you’ll be working closely with the raw data and will generate valuable insights that will help companies to decide their future goals.
  • If you’re someone who likes thinking out of the box then you are the perfect fit for this domain. Data Analysts help organizations to work with both business and data closely. This eventually maximizes the output for generating more business values.

RoadMap

1.Python

  • Syntax, Variables, Data Types, Conditionals
  • Loops, Functions, Built-in Functions
  • Data Structures- Lists, Tuples, Sets, Dictionaries
  • OOP- Classes, Inheritance, Objects
  • file handling ,exception handling
  • Python -Pandas,Numpy,Matplotlib,Seaborn

2. Mathematics and Statistics

  • Mathematics
  • Calculus
  • Standard Deviation
  • System of Linear Equation
  • Matrix Operation
  • Inverse
  • Transpose
  • Solving Linear Equation using Gaussian Elimination
  • Row Echelon Form
  • Matrix Approximation
  • Vector Operations
  • Linear Mappings
  • Linear Algebra
  • Probability

3.Statistics

  • Mean, Standard Deviation, and Variance.
  • Descriptive and Inferential Statistics
  • Probability Theory and Distribution
  • Sampling Distribution
  • Linear Regression
  • Sample Error and True Error
  • Bias Vs Variance and Its Trade-Off
  • Hypothesis Testing
  • Confidence Intervals
  • Correlation and Covariance
  • Correlation Coefficient
  • Covariance Matrix
  • Pearson Correlation
  • Spearman’s Rank Correlation Measure
  • Kendall Rank Correlation Measure
  • Robust Correlations

4.Excel

Begineer to Advance complete understanding

5.SQL

  • Basic SQL command
  • Groupng and Aggregation
  • Joins and Indexing
  • Subqueris
  • Modifying and Analysing data
  • Windows functions
  • Triggers and Store Procedure
  • Vews,locks,CTE

6.ETL Tools( Power BI)

  • Collect the data
  • Clean the data
  • create relationship amoung the data
  • Create visuals.
  • Publish(using gateways )

Basic Skills Required

Knowledge of ETL which is extract>transfor>Load

  • Problem Solving
  • Database Knowledge
  • Data Wrangling
  • Data Collection
  • Data Cleaning
  • Data Visualization

Tools

  • MS Excel
  • Tableau
  • Power BI
  • Python IDLE
  • DBMS