0(0 Ratings)

Data Analytics – Live Training

Categories Technical Course
Wishlist

What I will learn?

  • Gain an immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job
  • Gain Hands On Experience on tools like - ( Spreadsheets, SQL , Power BI / Tableau)
  • Learn key analytical skills ( Data cleaning, analysis & visualisation )
  • Work on Real life Case studies and Projects from companies like - Microsoft , Google , Netflix , Amazon and many more

Course Curriculum

Module 1 : MS – Excel

  • Lesson 1: Introduction to Excel, Shortcuts and Formatting
  • Lesson 2: Functions_Simple and Function_Date
  • Lesson 3: Functions_Text, Referencing and Logical Functions
  • Lesson 4: VLookup and HLookup
  • Lesson 5: SUMIF – COUNTIF and Pivot Tables
  • Lesson 6: Column Chart
  • Lesson 7: Clustered Chart, Bar Chart, Line Chart, Pie Chart, Area Chart and Combination Chart
  • Lesson 8: Scatter and Data Validation
  • Lesson 9: Google Sheets Advanced
  • Assignment 1 : Report Formatting ( UBER )

Module 2 : SQL

Module 3 : PowerBI

Student Ratings & Reviews

No Review Yet
No Review Yet
₹15,000.00 ₹20,000.00
  • Level
    Intermediate
  • Total Enrolled
    34
  • Duration
    60 hours
  • Last Updated
    September 2, 2022

Material Includes

  • Data Analytics Certifications - ( Google , KPMG )
  • Practise Assignment ( Excel , SQL , Power BI )
  • Customisable Templates and Dashboards
  • Resume Revamp and Linked in Profile Building
  • Placement Assistance & Company Referrals

Tags

Target Audience

  • College Students
  • Freshers ( Work Ex - 1,2 years )
  • Professionals ( Looking to switch to Data Analytics )