Data Analyst Course
- Home
- Courses
- Data Analyst
Data Analyst Course Curriculum
- Day in the life of a data analyst
- What a typical data analytics project looks like
- Skills required for a data/business analyst
- Industries in analytics and brief about how work happens in each of them
- Formatting, Conditional Formatting and Important Function
- Data Cleaning and Preparation
- Analysing Data with pivot Tablets
- Dashboarding
- Business Analytics with Excel
- Data Analytics with Statistics
- Introduction to SQL
- Database Normalization and entity Relationship Model
- Working with database and tables
- Working with operator constraints and data types
- Function in SQL
- Subqueries, operator and derived tables in SQL
- Stored procedures and Triggers in SQL
- Performance Optimization and Best Practices in SQL
- Refresher
- Descriptive
- Inferential Statistics
- Basics Virtualization
- power Query
- slice and Other functions
- DAX with other formulas
- Numpy
- Pandas
- Matplotlib
- Exploratory Data Analytics
- Introduction to Tableau
- Tableau Workspace
- Types of Charts in Tableau
- Creating Charts
- Data Preparation
- Preparation Techniques
- Filters and Analytics in Tableau
- Dashboards in Tableau
- Stories in Tableau
- Scikit learning
- Bias Variance
- Evaluation Metrics
- ML Algorithms for Predictive Modeling
- ML case studies
- Master ChatGPT DAAL-E
- Mastering Prompting
- Chat GPT for Data Analytics
- Guesstimates
- Understanding importance of business metrics
- Case Studies
- Leveraging LinkedIn
- Tips and Tricks in Job Searching
- Types of roles
- Interview preparation for each role way forward
Have Any Question?
Explore our range of industry-leading courses today and take the first step towards success!
