Business Analytics Program

skillzrevo

Last Update November 29, 2024

0 already enrolled

About This Course

This program prepares participants with the necessary skills to work in the analytics industry by teaching them how to interpret and extract data from the business. The course covers the basics of Python, and statistics as well as data manipulation and analysis in addition to providing hands-on experience with industry-standard tools. Result: The learner will be able to do data interpretation, predictive modeling and translate insights for business strategy.

Curriculum

31 Lessons

Introduction to Business Analytics

Introduction to Business Analytics, Why Business Analytics & Importance of Business Analytics00:00

Python

Python – Case Study

Business Statistics

Business Statistics – Case Study

Advanced Excel & Data Analysis

Advanced Excel & Data Analysis – Case Study

SQL

SQL – Case Study

Tableau

Tableau – Case Study

Project Session

Your Instructors

skillzrevo

0/5

22 Courses

0 Reviews

151 Students

Business Analytics Program

About This Course

Curriculum

Introduction to Business Analytics

Introduction to Business Analytics, Why Business Analytics & Importance of Business Analytics00:00

Python

Introduction to Python, Why Python, Variables, Data Types, Type castings, Strings, Indexing00:00

Operators and Conditional Statements, Looping Statements and it’s Control Statement00:00

Lambda Functions, *args, **kwargs, Functions00:00

Data Structures – List, Tuple and List Comprehensions00:00

Data Structures – Set and Dictionaries00:00

Classes, Objects and Constructors, Inheritance00:00

Polymorphism, Abstraction and Encapsulation00:00

Connecting & Establishing connections to databases, Executing SQL Queries, ORM, Working with NoSQL Databases00:00

Introduction of Numpy, and Pandas00:00

Introduction of Seaborn and Matplotlib00:00

Assignments : Python and Data Structures Assignment

Python – Case Study

Business Statistics

Introduction to Statistics, Descriptive Statistics, Sample, Population, Major of Central Tendency, Standard Deviation00:00

Variance, Range, IQR, Outliers, Correlation, Covariance, Skewness, Kurtosis, Probability00:00

Probability, Probability distributions, Central Limit Theorem, Binomial and Poisson Distribution00:00

Normal Distribution, Type I & Type II Error00:00

T-test, Z-test, Hypothesis, Testing Interview Questions00:00

Business Statistics – Case Study

Advanced Excel & Data Analysis

Microsoft Excel Overview, Basic Navigation and Usage, Cell referencing, Formatting Excel, Advanced Formatting, Shortcuts and Basic Formulas00:00

Sorting, Filtering, Advanced Filtering, Charts, Types of Charts, Advanced Charting Techniques and Pivot Tables, Creating, Grouping and Summarizing Data00:00

Lookup Function, Vlookup, Using VLOOKUP with Multiple, Criteria Hlookup, Combining HLOOKUP with Other Functions, Match Function, Using MATCH for Dynamic Referencing00:00

Introduction to VBA & Macros, Understanding VBA basics, Debugging and error handling, Advanced VBA Techniques, Integrating VBA with Excel functions, Designing Effective Dashboards, Building a Dashboard00:00

Understanding the basics of data analysis, Data Import and Cleaning, Using Formulas and Functions, Data Visualization, Descriptive Statistics00:00

Advanced Data Analysis Techniques, DAX, Scenario and Sensitivity Analysis, Dashboards and Reports, Case Studies and Real-World Applications, Practical examples of data analysis in Excel00:00

Advanced Excel & Data Analysis – Case Study

SQL

Basic of Database,Types of Database,Data Types, SQL Operators, Expression, Create, Insert00:00

Drop, Truncate, Delete, Alter, Update, Select, Range, Operator, IN,Wildcard, Like, Clause00:00

Constraint, Aggregation Function, Group by, Order by, Having00:00

Joins, Case, Complex Queries, Doubt Clearing00:00

Quiz 1: Databases and SQL Fundamentals Quiz

Assignments : Fundamentals of Databases and SQL Commands

SQL – Case Study

Tableau

Introduction to Tableau, Why Tableau, Tableau Desktop, Tableau products00:00

Data import, Measures, Filters00:00

Data Transformation, Marks, Dual Axis00:00

Manage worksheets, Data visualization, Dashboard, Projects00:00

Tableau – Case Study

Project Session

Data Analytics, Reports & Dashboards00:00

Your Instructors

skillzrevo

Data Science & AI Batch Jan SkillzRevo

Data Science & Business Intelligence Program

Data Analytics & Generative AI Program

Follow US!

Company

Work with us

Discover

For Businesses

Our Popular Courses

Login

Ready to transform your career?

Ready to transform your career?