get app
    Download Careers360 App

    Business Analysis Masterclass (5 courses in 1)

    BY
    Udemy

    Brochure Enquire
    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

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Cyber Security Courses Programming Courses Data Science Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close
    Download Careers360 App
    All this at the convenience of your phone

    • Regular Exam Updates

    • Best College Recommendations

    • College & Rank predictors

    • Detailed Books and Sample Papers

    • Question and Answers

    google play
    students
    400M+ Students
    Colleges
    36K+ Colleges
    Exams
    500+ Exams
    eBooks
    3K+ eBooks
    Certification
    16K+ Certifications
    mobile