Data Analyst Certification Course Training offered by ExcelR
4.6 /5Data Analyst Certification Course Training at ExcelR Overview
Duration | 160 hours |
Total fee | ₹39,999 |
Mode of learning | Online |
Credential | Certificate |
Data Analyst Certification Course Training at ExcelR Highlights
- Get Certified through our world class Data Analyst Certification Course powered by IBM
- Participants will be provided support related to placements which will include resume building and much more
- Program provides the industry best certified trainers
- Get an opportunity work on live projects from various industries
- Get 50+ assignments covering 100+ hours to practice the theoretical concepts
- Get extensive post training support
Data Analyst Certification Course Training at ExcelR Course details
- The course covers technologies like Excel, Advanced Excel and Tableau
- It also covers SQL, Power BI, Basics of R & Python
- Apart from the theory classes, there are hands-on assignments and projects
- Participants will be provide with recorded live sessions of their instructor led live classes
- With every concept that is taught, a related assignment will be given to ensure hands on experience
- ExcelR and tech conglomerate IBM have collaborated to provide quality upskilling opportunities to students and tech professionals
- The Course has been crafted to suit both, the market needs and for those interested in building their career in a tech domain that is not dominated by coding
- The course has been meticulously designed from basics to advanced topics to ensure that even the freshers can master the concepts easily
- The students will be allowed to work on live projects to get hands on training
Data Analyst Certification Course Training at ExcelR Curriculum
Topics To Be Covered
Business Statistics
Excel: Basics to Advanced
SQL
Tableau
Power BI
SAS
R Basics
Python Basics
Business Statistics
Data Types, Measure Of central tendency, Measures of Dispersion
Graphical Techniques, Skewness & Kurtosis, Box Plot
Descriptive Stats
Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
Introduction to Hypothesis Testing
Hypothesis Testing (2 proportion test, 2 t sample t test)
Anova and Chisquare
Data Cleaning
Imputation Techniques
Scatter Diagram
Correlation Analysis
Advanced Excel
Advanced Excel 'Basic
Sorting and Filtering Data
Data Validations
Text Function
Function & Formula
Pivot Tables
SQL
Types of Constraints
Relational Integrity Constraints
Key Constraints
Domain Constraints
Referential Integrity
Types Of Constraints
Primary and Foreign Keys
Application of Indexes
Checking Constraints
Tableau
Age of Big data
Why Data visualization Important
Understanding data
Examples of Data visualizations in Action
Different data visualizations
Principles of Visualizations
Design Principles
Best Practices
Data Viz Inspiration
Basics Of R
Introduction of R
Data Types
Data Structures
Decision Making Statements
Conditional Loops
Flow Control Statements
If Statements
For loops
While Loops
Other courses offered by ExcelR
Student Forum
Anything you would want to ask experts?
Data Analyst Certification Course Training at ExcelR Contact Information
#49, 1st Floor, 27th Main,
1st Cross, Behind Tata Motors,
BTM 1st stage
Bangalore ( Karnataka)