pwskills-logo
search-icon

Business Analytics Foundations

Get started on your journey into a business analytics of data science career with the most important and basic tools any data professional should know - SQL and Excel.
language-icon
Language: hinglish
clock-icon
Duration: 3 months

What you'll learn

  • Excel
  • SQL
  • Performing Operations on Large Datasets

Requirements

  • Requirements
  • System With Minimum I3 Processor Or Better
  • At Least 4 Gb Of Ram
  • 3 Months Of Dedication

Course Curriculum

MS Excel
  • 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
  • Visualisation with Excel
  • Building Basic Dashboards
  • Building Dynamic Dashboards
  • Building Business Models on Excel
  • Data Modeling for Easy Data Management
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
Gopal Sharma

Chief Operating Officer at PW - IIT BHU Graduate - Leading PWs Business Analytics team

instructor
Arpit Jain

Senior Data Scientist - Ex-Ericsson, Michelin - 6+ Years Of Teaching Experience - Postgraduate In Computer Science From IIT Madras

instructor
FREE
Class Details
start-date
Start Date:
21st November'22
class-timings
Class Timings:
Scheduled
Course Features
  • In Depth Coverage by Industry Veterans
  • Free Class Notes
  • Free Assignments and MCQs

Get in touch

Have a query about our courses? Get in touch with us and we will guide you through a new world of redefined learning.
Phone