Data Analyst Course Curriculum
This Data Analyst Course is taught from fundamentals to more advanced concepts.
Build Your Own Static Website
This course helps you build a strong foundation on web technologies such as HTML, CSS. With this, you will create and publish simple and beautiful websites from scratch.
- Importance of Frontend
- Fundamentals
- Syntax
- Debugging
- Tweaking Code
- Getting Started
- HTML Elements
- HTML Headings
- HTML Paragraphs
- HTML Button
- HTML Attributes
- HTML Images
- HTML Hyperlinks
- HTML Containers
- HTML Lists
- CSS Rulesets
- CSS Properties
- CSS Colors
- CSS Units
- CSS Box Model
- CSS Margins
- CSS Paddings
- CSS Borders
- Carousel
- Embedding Videos
Tourism Website
Build your Tourism Website by using HTML5, CSS3 and Bootstrap
Build Your Own Responsive Website
This course helps you build a strong foundation on web technologies such as HTML, CSS and Bootstrap. With this, you can create a responsive web application which runs smoothly across all the devices like desktop, tablet, and mobile.
- Block vs inline elements
- CSS Selectors
- Class Selector
- CSS Specificity
- Id Selector
- CSS Inheritance
- Type Selector
- CSS Cascading
Food Munch
Build a responsive Food Munch website using HTML5, CSS3 and Bootstrap Grid System.
- Container
- Row
- Column
- Display Utilities
- Flex Utilities
- Sizing Utilities
- Spacing Utilities
- Colors
- Navbar
- Buttons
Ecommerce Website
Build a responsive Ecommerce website using HTML5, CSS3 and Bootstrap Grid System
Programming Foundations with Python
You will learn the fundamental concepts of programming and gain the confidence to code in Python. You will learn to write programs and use the right data structures to solve problems and build modular software with Object-Oriented Principles.
- Operators, Datatypes & Variables
- Strings & Numbers
- Conditional Statements
- Loops
- String Methods
- Functions
Introduction to Databases
Learn about the incredibly prevalent databases today. Through this course, you'll develop strong fundamentals and be proficient in concepts related to Databases and DBMS. Most importantly, you'll also be able to perform powerful queries on databases using SQL.
- Introduction
- SQL
- Aggregation, Relationships,Join
- Querying
- ACID Properties
Data Analyst
Build a strong understanding of data analysis techniques, tools and methodologies. Become an expert in uncovering insights and patterns from complex data sets. Create a portfolio of projects that describe your abilities and skills in data analysis.
- Overview of Data Analytics
- Opportunities and Careers paths in Data Analytics
- Roles and responsibilities of a Data Analyst
- Data Analytics Case Studies
- Fundamentals of Data Visualization
- Introduction to Power BI
- Data Visualization using Power BI
- Slicers and Filters in Power BI
- Interactive Visualisations in Power BI
- Creating Paginated Reports
- Creating Dashboards in Power BI
- Data Cleaning Techniques
- Data Transformation Techniques
- Introduction to Power Query
- Data Types and Filters in Power Query
- Inbuilt Column and Row Transformations
- Creating a Query in Power Query
- Combining Two Data Sets
- Introduction and Techniques to Data Modelling
- Creating Measures in DAX
- DAX Functions
- Introduction to Power BI Service
- Collaboration using Power BI
- Creating Dashboards using Power BI Cloud/Service
- Publishing Your Dashboard
- Introduction to NumPy and Pandas
- Indexing and Slicing NumPy arrays
- Indexing and Filtering Pandas data frames and series
- Modifying Pandas data frames and Series
- Fundamentals of Tableau
- Essential Design Principles for Visualization with Tableau
- Creating Dashboards and Interactive Reports in Tableau
Building Captivating dashboards from different datasets across E-Commerce, Fintech, Health Tech etc.,