Data Analyst Certification Course Training at ExcelR Overview
Data Analyst Certification Course Training
at ExcelR
Get the data analyst course with Excel, Tableau, SQL & Power BI in collaboration with IBM
Duration | 160 hours |
Total fee | ₹39,999 |
Mode of learning | Online |
Credential | Certificate |
Data Analyst Certification Course Training
Table of content
Data Analyst Certification Course Training at ExcelR Highlights
Data Analyst Certification Course Training
at ExcelR
- 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
Read more
Data Analyst Certification Course Training at ExcelR Course details
Data Analyst Certification Course Training
at ExcelR
Skills you will learn
What are the course deliverables?
- 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
More about this course
- 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
Data Analyst Certification Course Training
at ExcelR
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
View Other 40 Courses
S
Shraddha Bhat
Data Analyst Certification Course Training
Offered by ExcelR
5
Learning Experience: The course is very good with practical knowledge of ms Excel, powerbi, tableau, python and SQL
Faculty: I couldn't give 10/10 for faculty
It is all about the data analytics
Course Support: I got certificate and internship also the placement
Reviewed on 4 Mar 2023Read More
S
Sukanya Sanjay Patil
Data Analyst Certification Course Training
Offered by ExcelR
5
Learning Experience: Good
Faculty: Good
I was able to change my job and domain due to this certifications
Reviewed on 24 Feb 2023Read More
M
Mohini Sampat Deshmukh
Data Analyst Certification Course Training
Offered by ExcelR
4
Learning Experience: excellent Trainers and procedure...but needs improvement in placement
Faculty: Superb
Assignment, projectetc
Course Support: It gives me full knowledge of relevant field
Reviewed on 11 Feb 2023Read More
T
Tushar Subhash Dhokane
Data Analyst Certification Course Training
Offered by ExcelR
5
Learning Experience: Wide range of content, focused syllabus on every aspect of data analytics
Faculty: Faculty comes up with great corporate knowledge, which really helps students as they get to learn keeping a practical situations in corporate in mind
Course includes assignments, projects and internship. Assignment question cover almost every important aspects in a particular course e.g. Advance Excel, PowerBI, SQL, Python and R
Course Support: It helped me gaining knowledge about more advanced concepts
Reviewed on 6 Feb 2023Read More
S
Shubham Nagpure
Data Analyst Certification Course Training
Offered by ExcelR
5
Learning Experience: Filter Data by reviewing reports and performance indicators to identify and correct code problems Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis and prediction Developed custom retail BI and analytics solutions, plus Power BI reporting visualizations and assessing Client value ROI (Return of Investment) through tailored RFM Customer segmentation. Discovered the seasonality of the raw data by plotting the smoothed period gram through the spectral domain approach using R. Machine Learning/AI -Forecasted the competition results by predicting the winning percentages for the likelihood of each possible matchup. Developing and maintaining databases, data systems – reorganizing data in a readable format. Using automated tools to extract data from primary and secondary sources. Proficient in understanding business requirement and translating them into technical requirements. Preparing final analysis reports for the stakeholders to understand the dataanalysis steps, enabling them to take important decisions based on various facts and trends.
Faculty: faculty was also good,lecture quality was also good
Building predictive and decision models using machine learning algorithms for various business study cases with optimizations and evaluation techniques. Analyzed large and imbalanced datasets by performing machine learning techniques to provide data insights, optimistic solutions, and strategic directions for making data driven decisions. Used various Machine learning & Deep Learning models. Worked with text data with text mining techniques including text extraction, cleaning, pattern identifications, categorizations, and entity recognitions. End-to-end deployment of ML and NLP solutions on web-based frameworks like Streamlit
Course Support: it supported me good enough
Reviewed on 3 Feb 2023Read More
View All 31 Reviews
Data Analyst Certification Course Training at ExcelR Frequently Asked Questions
Data Analyst Certification Course Training
at ExcelR
Data Analyst Certification Course Training
at ExcelR
Student Forum
Anything you would want to ask experts?
Data Analyst Certification Course Training at ExcelR Contact Information
Data Analyst Certification Course Training
at ExcelR
Address
#49, 1st Floor, 27th Main,
1st Cross, Behind Tata Motors,
BTM 1st stage
Bangalore ( Karnataka)
Phone
Email
Go to College Website ->