Brochure
Enquire
- How is Excel important to businesses
- Understanding the excel interface
- Basic Formatting in Excel
- Insertion and Deletion in Excel
- Data Types in Excel
- Q and A
- Thanks for your Support
- Quiz on Excel Basics
- Quiz Solution
- Applying the sort function
- Applying the filter function
- Applying the advanced filter function
- Quiz on Sort and Filter
- Quiz Solution
- Using the UPPER, LOWER and PROPER functions
- Using the LEFT, RIGHT and SEARCH functions
- Using the TRIM, CONCAT and LEN functions
- Quiz on Text functions
- Quiz Solution
- Using the MIN, MAX AVERAGE functions
- Finding the Standard deviations
- Find the percentiles of data
- Finding the Outliers present in data
- Finding the Missing values in data
- Quiz on Statistical functions
- Quiz Solution
- Using the IF function
- Using the IF ERROR function
- Applying the COUNTIF function
- Applying the SUMIF function
- Applying the AVERAGEIF function
- Quiz on Logical functions
- Quiz Solution
- Using Colorbars for formatting
- Using Colorscales for formatting
- Quiz on Conditional Formatting
- Quiz Solution
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹799
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Excel Fundamentals
Excel for Data Analysis
- Applying VLOOKUP function
- Applying HLOOKUP function
- Quiz on Lookup Functions
- Quiz Solution
- Why to use Index and Match?
- Applying Index and Match
- Quiz on Index and Match
- Quiz Solution
- Making Pivot Tables
- Making Pivot Charts
- Quiz on Pivot Tables
- Quiz Solution
- Basics of Data Visualizations
- Making Charts in Excel
- Making Dashboards
- Adding Slicers in Dashboards
- Formatting dashboards
- Quiz on Dashboards
- Quiz Solution
- Goal Seek Analysis
- Data Tables
- Scenario Management
- Quiz on What If Analysis
- Quiz Solution
- Understanding Regression
- Performing Linear Regression
- Quiz on Regression
- Quiz Solution
SQL Introduction
- Introduction to SQL
- Build your first SQL query
- Basic SQL queries Part - 1
- Basic SQL queries Part - 2
- Brain Buster Exercise
- Brain Buster Solution
- Quiz on Introduction to SQL
- Quiz Solution
- Installation
- Interface walkthrough
- Creating Required Databases
- Quiz on Installation and set up
- Quiz Solution
- Type of SQL Commands
- The SELECT Command
- Numerical Functions
- String Functions
- Exercises on String Functions
- The Having Clause
- Filtering using the Like Operator
- Quiz on DQL
- Quiz Solution
SQL Deep Dive
- Numerical Datatypes
- String Datatypes
- Constraints
- Quiz on DDL
- Quiz Solution
- Creating Databases and Tables
- Alter, Drop, and Truncate
- Insert, Update, and Delete
- Quiz on DML
- Quiz Solution
- Foreign Key
- Joins
- Left, Right, and Outer Join
- Compound Joins, and Multiple Joins
- Star Schema
- Sub Queries Part 1
- Sub Queries Part 2
- Quiz on Joins, Sub Queries & Set Operations
- Quiz Solution
- Connecting MySQL through Python
- Loading Tables into a Pandas DataFrame
- Quiz on Accessing Databases using Python
- Quiz Solution
Big Query
- What is Big query
- How Big query works
- Getting started with GCP and Big query
- Importing Dataset and Executing your first Big query
- Visualizing using Data Studio
- BI Engine
- SQL exercise on Big query
- Quiz on Introduction to Big Query
- Quiz Solution
- Use of Big query in Data Analysis
- Exploring Big query dataset on kaggle kernel
- Connecting Big query to Tableau Desktop for Visualizations
- Data Analysis project - Part 1 (Introduction and Setting up Problem statement)
- Data Analysis project - Part 2 (Exercises and Solutions)
- Quiz on Big Query for Data Analysis
- Quiz Solution
- What is Data warehouse
- Properties of modern Data warehouse
- Alternatives to Big query
- Quiz on Data warehouse
- Quiz Solution
Tableau Bootcamp
- Getting Started with Tableau
- Navigating Tableau
- Creating Your First Visualization
- Building Your First Dashboard
- Quiz on Creating your First Tableau Dashboard
- Introduction
- Dimensions and Measures
- Green & Blue Pills
- Measures Names & Values
- Working with Time Series Data
- Aggregation and Granularity
- Aggregation Options
- Show Me Toolbar
- Marks cards & Level of Detail
- Custom Shapes
- Filtering Data
- Pages Shelf
- Exercise on Building Blocks of Data Visualization
- Solution on Building Blocks of Data Visualization
- Quiz on Building Blocks of Data Visualization
- Highlight Table
- Highlight Table Bar Charts & Sorting
- Bar-in-Bar
- Histogram
- Pie Charts
- Pie Chart Exercise Solution
- Tree Map
- Bubble Chart
- Line Charts
- Area Chart
- Heat Map
- Exercise on Tableau Basic Visualization (Vietnam War Dataset)
- Solution on Tableau Basic Visualization
- Quiz on Tableau Basic Visualization
- Overview
- Theme & Workbook Level Formatting
- Axis Lines and Formatting
- Parts of the View
- Formatting Pane - Part 1
- Formatting Pane - Part 2 (Fonts, Alignment & Shading)
- Formatting Pane - Part 3 (Borders & Lines)
- Number Format
- Titles & Captions
- Mark Labels
- Styling and Customizing a Tooltip
- Visualization in Tooltip
- Editing Axis
- Annotating the Viz
- Section Exercise - Data Ink Ratio
- Section Exercise Solution - Data Ink Ratio
- Quiz on Formatting in Tableau
Python Fundamentals
- Why should you learn Python?
- Installing Python and Jupyter Notebook
- Understanding the Interface of Jupyter Notebook
- Naming Convention for variables
- Built in Data Types and Type Casting
- Scope of Variables
- Quiz on Variables and Data Types
- Quiz Solution
- Exercise on Variables and Data Types
- Solution on Variables and Data Types
- Exercise on Scope of Variables
- Solution on Scope of Variables
- Arithmetic and Assignment Operators
- Comparison, Logical, and Bitwise Operators
- Identity and Membership Operators
- Quiz on Operators
- Quiz Solution
- Exercise on Arithmetic and Assignment Operators
- Solution on Arithmetic and Assignment Operators
- Exercise on Comparison, Logical, and Bitwise Operators
- Solution on Comparison, Logical, and Bitwise Operators
- Exercise on Identity and Membership Operators
- Solution on Identity and Membership Operators
- String Formatting
- String Methods
- User Input
- Quiz on Strings
- Quiz Solution
- Exercise on Strings
- Solution on Strings
- If, elif, and else
- For and While
- Break and Continue
- Quiz on Loops and conditionals
- Quiz Solution
- Exercise on Loops and Conditionals
- Solution on Loops and Conditionals
Python for Data Science
- Introduction to datetime
- The date and time class
- The datetime class
- The timedelta class
- Quiz on Dates and Times
- Quiz Solution
- Exercise on Date and Time
- Solution on Date and Time
- Meta Characters for Regular Expressions
- Built-in Functions for Regular Expressions
- Special Characters for Regular Expressions
- Sets for Regular Expressions
- Quiz on Regular Expressions
- Quiz Solution
- Exercise on Regular Expressions
- Solution on Regular Expressions
- Array Creation using Numpy
- Mathematical Operations using Numpy
- Built-in Functions in Numpy
- Quiz on Introduction to Numpy
- Quiz Solution
- Exercise on Built-in Functions in Numpy
- Solution on Built-in Functions in Numpy
- Reading Datasets using Pandas
- Plotting Data in Pandas
- Indexing, Selecting, and Filtering Data using Pandas
- Merging and Concatenating DataFrames
- Lambda, Map, and Apply Functions
- Quiz on Introduction to Pandas
- Quiz Solution
- Exercise on Pandas Plotting
- Solution on Pandas Plotting
- Exercise on Indexing and Selecting
- Solution on Indexing and Selecting
- Exercise on Apply Functions
- Solution on Apply Functions
Data Exploration
- Why EDA and how it is useful
- Course curriculum walkthrough
- Data Profiling
- Analyzing Target Data
- Summarizing data
- Quiz on Introduction to EDA
- Quiz Solution
- Exploring the Dabl Library
- Exploring the Sweetviz Library
- Using Color Gradients for better analysis
- Best Practices for Data Exploration
- Quiz on Examining Data
- Quiz Solution
Data Visualization
- Univariate Analysis
- Bivariate Analysis
- Multivariate Analysis
- Quiz on Basics of Visualization
- Quiz Solution
- Scatter Plots
- Charts with Colorscale
- Bar, Line, and Area Charts
- Facet Grids
- Statistical Charts
- Polar Charts
- Subplots
- 3D Charts
- Waffle Charts
- Maps
- Quiz on Advanced Visualizations
- Quiz Solution
- Animation with Bubbleplot
- Animation with Facets
- Animation with Scatter Maps
- Animation with Choropleth Maps
- Quiz on Animated Visualizations
- Quiz Solution
- Introduction to Ipywidgets
- Interactive Univariate Analysis
- Interactive Bivariate Analysis
- Interactive Multivariate Analysis
- Quiz on Interactive Visualizations
- Quiz Solution
- Sunburst Charts
- Parallel Co-ordinate Charts
- Funnel Charts
- Gantt Charts
- Ternary Charts
- Tree Maps
- Network Charts
- Quiz on Miscellaneous Charts
- Quiz Solution
Query Analysis
- Aggregate functions used for Grouping
- Using Groupby for Grouping Operations
- Groupby with Idxmax and Idxmin functions
- Using Color scales for better visualization
- Visualizing the Groupby Operations
- Using Pivot Tables for Grouping Operations
- Difference between Groupby and Pivot tables
- Performing Cross Tabulation
- Visualizing Cross tabulated Data
- Interactive Grouping Operations
- Quiz on Grouping Operations
- Quiz Solution
- When to perform Filtering Operations
- Introduction to Simple Filtering Operations
- Advanced Filtering Operations
- Filtering and Grouping Operations
- Interactive Filtering Operations
- Quiz on Filtering Operations
- Quiz Solution
Linear Regression
- Introduction to Linear Regression
- Implementing Linear Regression using Sklearn
- Feature Selection using RFECV
- Data Transformation with Linear Regression
- Applying Cross Validation
- Analyzing the performance of Regression models
- R2 score and adjuted R2 score intuition
- MAE, RMSE, R2 and Adjusted R2 in code
- Applying real time prediction on our model
- Industry relevance of linear regression
- Quiz on Modelling with Linear Regression
- Quiz Solution
Structured Problem Solving
- Understanding a Business Problem
- Important Factors to Consider in a Business Problem
- The Process of Interviewing
- Do's and Dont's of Interviewing
- Introduction to 5W Framework
- Introduction to 5Why Framework
- Case Study on 5W and 5Why Framework
- Introduction to Spin Framework
- Case Study on Spin Framework
- Introduction to Business Model Canvas
- Introduction to Issue Tree Frameworks
- Case Study on Issue Tree Frameworks
- Introduction to 7P Framework
- Introduction to 3P Framework
- Introduction to 5C Framework
- Introduction to Specialized Business Frameworks
Mastering Communication Skills
- Why is Communication so Important?
- Tips for Better Communication
- Do's and Dont's for Communication
- How to Deal with Large no. of People
- How to Manage Stress and Anxiety
- How to develop Communication Skills
- How to Develop Negotiation Skills
- How to Handle Negative People
- How to say "No" at Workplace
- How to use Empathy in Communication.
Business Presentation Skills
- Why Presentation Skills are Important
- How to Use Google Slides
- Tips and Tricks to make an Effective Presentation.
- Adding Graphics to your Presentation
- Adding Animations to your Presentation
Github Ninja Skills
- Introduction to Github?
- Introduction to Version Control
- Introduction to Git
- How to Upload Projects using Github.
- Using Github Pages to make your Portfolio
- How to Clone, Fork and Search for Projects in Github
- Maintaining Github Repositories
- Mastering Github Issues
- Getting Insight about Github Repositories
Essential Business Grooming
- Benefits of Grooming
- How to Dress for Different Occasions
- Eating and Talking Habits
- How to be More Presentable
- How to Improve Interpersonal Skills
- How to be professional at work place
Outro Section
- Conclusion
- How to Get Your Certificate of Completion
Bonus Section
- Bonus Lecture
Articles
Popular Articles
prev
next
