Business Analysis Masterclass (5 courses in 1)

- Description
- Curriculum
- FAQ
- Reviews
Welcome to the best online course on Business Analysis in Data Science Masterclass.
Omar Hanif
⭐⭐⭐⭐⭐
“Truly an amazing course.
I am yet to find a better course that covers so many topics in Business Intelligence with such great detail.
Everything is so elaborately explained that it leaves no confusions. Highly recommended!”
—
Business Intelligence and Data Analysis is a disciplined approach for introducing and managing change to organizations, whether they are for-profit businesses, governments, or non-profits.
Business analysis is used to identify and articulate the need for change in how organizations work, and to facilitate that change.
This course is a complete package for everyone wanting to pursue a career in business analysis.
This course gives you complete knowledge from basics to advanced level on Excel, Python, Tableau and SQL.
You will learn to create interactive dashboards using Excel as well as Tableau.
Along with these, this course will cover other business analytics concepts such as
- Big Query
- Data Exploration
- Data Visualization
- Query Analysis
- Linear Regression
- Structured Problem Solving
All these topics are covered in detail.
Along with theory, you will get to practice them using some real-world datasets.
There will be lots of exercises and quizzes.
And Not only this,
This course gives you the opportunity to master communication skills,
Enhance your presentation skills, GitHub skills, and also provide essential business grooming.
This course is a complete package for business analysis concepts.
This is a great test for people who are learning the Python language and data science and are looking for new challenges.
Instructor Support – Quick Instructor Support for any queries.
I’m looking forward to see you in the course!
You won’t regret it after taking this course.
This course is worth taking.
Enroll now and become a skilled business analyst.
-
1How is Excel important to businessesVideo lesson
-
2Understanding the excel interfaceVideo lesson
-
3Basic Formatting in ExcelVideo lesson
-
4Insertion and Deletion in ExcelVideo lesson
-
5Data Types in ExcelVideo lesson
-
6Q and AVideo lesson
-
7Thanks for your SupportVideo lesson
-
8Quiz on Excel BasicsQuiz
-
9Quiz SolutionVideo lesson
-
10Applying the sort functionVideo lesson
-
11Applying the filter functionVideo lesson
-
12Applying the advanced filter functionVideo lesson
-
13Quiz on Sort and FilterQuiz
-
14Quiz SolutionVideo lesson
-
15Using the UPPER, LOWER and PROPER functionsVideo lesson
-
16Using the LEFT, RIGHT and SEARCH functionsVideo lesson
-
17Using the TRIM, CONCAT and LEN functionsVideo lesson
-
18Quiz on Text functionsQuiz
-
19Quiz SolutionVideo lesson
-
20Using the MIN, MAX AVERAGE functionsVideo lesson
-
21Finding the Standard deviationsVideo lesson
-
22Find the percentiles of dataVideo lesson
-
23Finding the Outliers present in dataVideo lesson
-
24Finding the Missing values in dataVideo lesson
-
25Quiz on Statistical functionsQuiz
-
26Quiz SolutionVideo lesson
-
27Using the IF functionVideo lesson
-
28Using the IF ERROR functionVideo lesson
-
29Applying the COUNTIF functionVideo lesson
-
30Applying the SUNIF functionVideo lesson
-
31Applying the AVERAGEIF functionVideo lesson
-
32Quiz on Logical functionsQuiz
-
33Quiz SolutionVideo lesson
-
34Using Colorbars for formattingVideo lesson
-
35Using Colorscales for formattingVideo lesson
-
36Quiz on Conditional FormattingQuiz
-
37Quiz SolutionVideo lesson
-
38Applying VLOOKUP functionVideo lesson
-
39Applying HLOOKUP functionVideo lesson
-
40Quiz on Lookup FunctionsQuiz
-
41Quiz SolutionVideo lesson
-
42Why to use Index and Match?Video lesson
-
43Applying Index and MatchVideo lesson
-
44Quiz on Index and MatchQuiz
-
45Quiz SolutionVideo lesson
-
46Making Pivot TablesVideo lesson
-
47Making Pivot ChartsVideo lesson
-
48Quiz on Pivot TablesQuiz
-
49Quiz SolutionVideo lesson
-
50Basics of Data VisualizationsVideo lesson
-
51Making Charts in ExcelVideo lesson
-
52Making DashboardsVideo lesson
-
53Adding Slicers in DashboardsVideo lesson
-
54Formatting dashboardsVideo lesson
-
55Quiz on DashboardsQuiz
-
56Quiz SolutionVideo lesson
-
57Goal Seek AnalysisVideo lesson
-
58Data TablesVideo lesson
-
59Scenario ManagementVideo lesson
-
60Quiz on What If AnalysisQuiz
-
61Quiz SolutionVideo lesson
-
62Understanding RegressionVideo lesson
-
63Performing Linear RegressionVideo lesson
-
64Quiz on RegressionQuiz
-
65Quiz SolutionVideo lesson
-
66Introduction to SQLVideo lesson
-
67Build your first SQL queryVideo lesson
-
68Basic SQL queries Part - 1Video lesson
-
69Basic SQL queries Part - 2Video lesson
-
70Brain Buster ExerciseVideo lesson
-
71Brain Buster SolutionVideo lesson
-
72Quiz on Introduction to SQLQuiz
-
73Quiz SolutionVideo lesson
-
74InstallationVideo lesson
-
75Interface walkthroughVideo lesson
-
76Creating Required DatabasesVideo lesson
-
77Quiz on Installation and set upQuiz
-
78Quiz SolutionVideo lesson
-
79Type of SQL CommandsVideo lesson
-
80The SELECT CommandVideo lesson
-
81Numerical FunctionsVideo lesson
-
82String FunctionsVideo lesson
-
83Exercises on String FunctionsVideo lesson
-
84The Having ClauseVideo lesson
-
85Filtering using the Like OperatorVideo lesson
-
86Quiz on DQLQuiz
-
87Quiz SolutionVideo lesson

External Links May Contain Affiliate Links read more