- Introduction to Business Analytics Foundation Course
- Introduction to MS Excel - 1: Basics of Spreadsheet Operations and Navigating MS Excel
- Introduction to MS Excel - 2: Excel Datatypes, and Sorting and Filtering Data
- Introduction to MS Excel - 3: Cell References, and Performing Basic Operations on MS Excel
- Excel Numerical Functions
- Logical Functions
- Reference Functions - 1
- Reference Functions - 2
- Date and Time Functions
- Pivot Tables
- Business Metrics and Problem Solving - E-commerce
- Visualization with Excel
- Building Basic Dashboards
- Building Dynamic Dashboards
- Building Business Models on Excel
- Data Modeling for Easy Data Management
Beginner
Online
3 Months
Free
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Business Analytics Foundations training is a free foundational online programme to learn the basic tools of business analytics. Offered by PWSkills, the online course can be pursued by anyone who wants to begin a career in business analytics. The Business Analytics Foundations online course will provide a glimpse into the key tools needed for data professionals, namely, SQL and MS Excel.
Business Analytics Foundations Certification by PWSkills is a 3-month long online programme. During the course, the learners will have access to the recorded videos as well as the practical exercises to deepen their hands-on skills. As the course is offered in Hinglish, learners in English or Hindi can pursue it.
Read more: Business Analytics Certification Courses
The highlights
- Free Programme
- Online Course
- 3 Months Duration
- Hinglish Medium
Program offerings
- Practice excercise
- Recorded videos
- Quizz
Course and certificate fees
Type of course
The course is free of cost and thus, the learners do not need to pay the Business Analytics Foundations certification fee.
Fee Structure
Name of the Course | Fee |
Business Analytics Foundations | Free |
certificate availability
What you will learn
The Business Analytics Foundations Certification Syllabus will enlighten on the following topics:
- Data analysis
- Excel proficiency
- Extraction
- Data cleaning
- Transformation
- Filtering
- Aggregation
- Efficient handling of large datasets
- Modelling
Who it is for
Business Analytics Foundations classes can be taken by anyone and does not prescribe any prerequisites. However, it is highly recommended for those who want to try a hand at the following professional careers:
- Business Analyst
- Operations Analyst
- Market Research Analyst
Admission details
The learners can join the Business Analytics Foundations certification course through these steps:
Step 1: Browse the URL
https://pwskills.com/course/business-analytics-foundations
Step 2: Click on “Enrol Now” and provide the needed information including your mobile number.
Step 3: Login and start taking the course.
The syllabus
Module 1: MS Excel
Module 2: SQL
- Intro to Database and SQL
- Installation of MySQL
- Creating Databases using DDL
- Writing Basic SQL Queries
- Operators in SQL
- Aggregate Functions in SQL
- Joins I
- Joins II
- Business Case Study - Solar Power Generation
- Case Expressions
- Advanced Querying - Subqueries
- Advanced Querying - Common Table Expressions
- Problem Solving - World Health Statistics
- Window Functions - I
- Window Functions - II
- String Functions
- Date and Time Functions
- Best Practices in Querying
How it helps
Business Analytics Foundations certification benefits include that the participants can acquire the skills and knowledge of tools required for business analytics such as SQL and Excel. Also, the insights and practical knowledge will help the learner to go for advanced courses and build a career.
Instructors
Mr Gopal Sharma
Chief Operating Officer
PW Skills
Mr Arpit Jain 1
Senior Data Consultant
Freelancer
Other Masters
FAQs
The online foundational programme is offered by PWSkills.
The online programme is 3 months long.
The online programme is offered in an online self-paced mode.
In this course, the learners can master MS Excel and SQL.
The instructors are Gopal Sharma, the COO of Pysicswalla and Arpit Jain, the senior data consultant at Ericsson.
Articles
Popular Articles
Latest Articles
Similar Courses
Business Analyst Fundamentals for Beginners
Skill Lync
Business Analytics
Udacity
Courses of your interest
Value Based Care Organizational Competencies
University of Houston, Houston via Coursera
Communication and Leadership during a Public Healt...
SUNY via Coursera
Data Management for Clinical Research
Vanderbilt via Coursera
Quality Improvement in Healthcare Organizations
Rutgers University, New Brunswick via Coursera
Introduction to International Business Management
University of Kent, Canterbury via Futurelearn
International Leadership Skills for the Workplace
Coventry University, Coventry via Futurelearn
Tourism and Hospitality Management
University of Palermo, Buenos Aires via Futurelearn
Team Building and Transformational Leadership How ...
Coventry University, Coventry via Futurelearn
Fundamentals of Agile Project Management
UCI Irvine via Futurelearn
Social Entrepreneurship in Educational Technology
Johns Hopkins via Futurelearn
More Courses by PW Skills
JavaScript Foundations
PW Skills
Technical Analysis Series
PW Skills
C Programming Foundations
PW Skills
C++ Foundation
PW Skills
Stock Market Fundamentals
PW Skills
Python Foundations
PW Skills