Business Analysis Masterclass (5 courses in 1)

BY
Udemy

Mode

Online

Fees

₹ 449 799

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

  • 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

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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books