Data Analytics (Excel, Tableau, Power BI, and SQL)

Duration: 3 Months

Download Brochure
Apply Now
Login

What will you learn?

Excel
SQL
Statistics
Power BI
Tableau
Application Fee

Rs.500 + GST

Expected Course Commencement Date

17-Nov-2024

Last Date to Apply

15-Nov-2024

Course Fee

Rs. 30,000 + GST

Class Timings

Physical Classroom Session

Saturday & Sunday (Alternative Weekends): 9 am to 5.30 pm (Physical Classroom Session at LIBA)

Course Plan

44 Hours of Classroom session (Including Hands on training)

Admission Process

  • Fill out the application form

  • Our expert team will review your application

  • Admission letter will be sent to your email ID

  • Pay the Course Fee

Benefits of doing the programme

Industry Experts Session

1:1 Career Coaching Sessions

Structured Programme

44 Hours of Classroom Session

Hands on
Learning

Practical Case Studies – Datasets

Programme Overview

  • Designed for working professionals, Freshers

  • Programming tools & Languages

  • 44 hours Classroom Sessions)

  • Individuals looking to transition into the world of Data Analytics and Data Science

  • Developing core skills in Excel, Power BI, and SQL—fundamental tools for any Data Analyst

Job Opportunites

Data Analyst
Data Scientist
Business Analyst
Product Analyst
Data Engineer

Who is this Programme for?

Business Managers and Executives

HR & Recruiters

Sales & Marketing Professionals

Banking & Finance, Telecom, Healthcare Professionals

Management Students

Finance Executives

Teachers & Professors

Operations & Admin

Logistics & Supply Chain

Eligibility

Bachelor’s Degree with minimum 50% or equivalent passing marks.

No coding experience required

Faculty

Mr. Karthik Veer

Syllabus

  • Course Introduction and Overview
  • Introduction to Excel Interface
  • Excel basics and understanding the layout
  • Data Entry, Importing Data, and Table Creation
  • Excel Functions and Formulas (SUM, AVERAGE, COUNT, IF)
  • Hands-on Activity: Basic sales data calculation and formatting
  • Text Functions (RIGHT, LEFT, MID, UPPER, LOWER)
  • Introduction to Data Cleaning in Excel
  • Removing duplicates, handling missing data, splitting & merging data.
  • Conditional Formatting for data visualization
  • Hands-on Activity: Clean a messy dataset, apply transformations
  • Introduction to Pivot Tables and Pivot Charts
  • Data Exploration and Summary Statistics
  • Creating Interactive Dashboards in Excel
  • Hands-on Activity: Create a dashboard using Pivot Tables
  • Introduction to Power Query for Data Transformation.
  • Combining and Merging Data Sources
  • Data Forecasting Techniques
  • Hands-on Activity: Apply Power Query to clean data and create visual forecasts
  • Overview of Power BI Ecosystem and Interface
  • Connecting to Data Sources
  • Creating and Managing Data Models (Relationships, Star Schema)
  • Hands-on Activity: Create a basic Power BI report with connected data sources
  • Advanced Data Transformation using Power Query.
  • Visualization Basics: Bar, Line, and Pie Charts.
  • Introduction to Slicers and Filters for Interactivity.
  • Hands-on Activity: Build visualizations using cleaned data.
  • Introduction to DAX (Data Analysis Expressions)
  • Calculated Columns, Measures, DAX Functions.
  • Advanced Visualization: Maps, Tree Maps, and Combo Charts.
  • Hands-on Activity: Create an interactive report using DAX functions.
  • Introduction to Databases and SQL.
  • SQL Commands: SELECT, FROM, WHERE.
  • Aggregation Functions: COUNT, SUM, AVERAGE, MIN, MAX.
  • Hands-on Activity: Query a dataset to extract useful insights.
  • SQL Joins (INNER, LEFT, RIGHT, FULL).
  • Grouping and Filtering Data (GROUP BY, HAVING).
  • Subqueries and Nested Queries.
  • Hands-on Activity: Perform multi-table joins and advanced queries.
  • Data Definition Language (DDL): CREATE, ALTER, DROP.
  • Data Manipulation Language (DML): INSERT, UPDATE, DELETE.
  • Views, Stored Procedures, and Triggers.
  • Hands-on Activity: Create and manage a SQL database for a project.

Certificate