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.
Excel for Data Analysis
-
1How is Excel important to businesses
-
2Understanding the excel interface
-
3Basic Formatting in Excel
-
4Insertion and Deletion in Excel
-
5Data Types in Excel
-
6Q and A
-
7Thanks for your Support
-
8Quiz on Excel Basics
-
9Quiz Solution
-
10Applying the sort function
-
11Applying the filter function
-
12Applying the advanced filter function
-
13Quiz on Sort and Filter
-
14Quiz Solution
-
15Using the UPPER, LOWER and PROPER functions
-
16Using the LEFT, RIGHT and SEARCH functions
-
17Using the TRIM, CONCAT and LEN functions
-
18Quiz on Text functions
-
19Quiz Solution
-
20Using the MIN, MAX AVERAGE functions
-
21Finding the Standard deviations
-
22Find the percentiles of data
-
23Finding the Outliers present in data
-
24Finding the Missing values in data
-
25Quiz on Statistical functions
-
26Quiz Solution
-
27Using the IF function
-
28Using the IF ERROR function
-
29Applying the COUNTIF function
-
30Applying the SUNIF function
-
31Applying the AVERAGEIF function
-
32Quiz on Logical functions
-
33Quiz Solution
-
34Using Colorbars for formatting
-
35Using Colorscales for formatting
-
36Quiz on Conditional Formatting
-
37Quiz Solution
SQL Introduction
-
38Applying VLOOKUP function
-
39Applying HLOOKUP function
-
40Quiz on Lookup Functions
-
41Quiz Solution
-
42Why to use Index and Match?
-
43Applying Index and Match
-
44Quiz on Index and Match
-
45Quiz Solution
-
46Making Pivot Tables
-
47Making Pivot Charts
-
48Quiz on Pivot Tables
-
49Quiz Solution
-
50Basics of Data Visualizations
-
51Making Charts in Excel
-
52Making Dashboards
-
53Adding Slicers in Dashboards
-
54Formatting dashboards
-
55Quiz on Dashboards
-
56Quiz Solution
-
57Goal Seek Analysis
-
58Data Tables
-
59Scenario Management
-
60Quiz on What If Analysis
-
61Quiz Solution
-
62Understanding Regression
-
63Performing Linear Regression
-
64Quiz on Regression
-
65Quiz Solution
SQL Deep Dive
-
66Introduction to SQL
-
67Build your first SQL query
-
68Basic SQL queries Part - 1
-
69Basic SQL queries Part - 2
-
70Brain Buster Exercise
-
71Brain Buster Solution
-
72Quiz on Introduction to SQL
-
73Quiz Solution
-
74Installation
-
75Interface walkthrough
-
76Creating Required Databases
-
77Quiz on Installation and set up
-
78Quiz Solution
-
79Type of SQL Commands
-
80The SELECT Command
-
81Numerical Functions
-
82String Functions
-
83Exercises on String Functions
-
84The Having Clause
-
85Filtering using the Like Operator
-
86Quiz on DQL
-
87Quiz Solution