What you'll learn?

  • Advanced Excel and Dashboarding
  • Power BI
  • SQL
  • Python for Data Analytics Course
  • Advanced Python
  • 24 X 7 Support
  • Life Time Access
  • Resume Building Session
  • Real World Projects
  • Hands on Practice, Assignements and Project

Requirements

  • Hold a any degree from an any institution or have 0-2 years of work experience
  • No coding experience required.
  • Must have PC/Laptop for practice
  • Good Internet Connection

Why Data Analytics with Edgrow

  • Designed for Students & Working Professionals.
  • 1 : 1 Mentoring from Industry Expert
  • Lifetime Access to our Data Science Resources
  • 100% Job Assistance
  • Real time projects
  • Mock Interviews
  • Help in Resume Builidng
  • Central government recognised NSDC Certification / Internship letter

Course content

Total: 40+ lectures
  • Cell Formatting in Excel
  • Working With the Essential Formulas/Functions
  • Export and Print Options
  • Cleaning up Messy Data
  • Formatting Content
  • Working with Graphs
  • Data Analysis
  • Making Dashboard in Excel
  • Working with Power Query
  • Prepare to Deploy
  • Introduction to Data Analytics
  • Business Intelligence (BI) Concepts
  • Power BI Architecture
  • Power BI introduction and Its components
  • Power BI over Excel
  • Power BI Desktop - An Introduction
  • Connecting Power BI with Different Data sources
  • Data Transformation through Power Query
  • Data Modelling in Power BI
  • Understanding Data Analysis Expressions (DAX)
  • Basic DAX functions - (Calculated Columns)
  • Relational Functions
  • Understanding Contexts in Power BI
  • Understanding Measures
  • Most Common DAX - CALCULATE _ FILTER
  • Filtering Data using DAX
  • Date _ Time DAX
  • Report setup in Power BI Desktop
  • Building Report
  • Advanced Visualizations
  • Advanced Report options
  • Publish the Report to Cloud
  • Reports and Dashboard
  • Introduction to Python
  • Variable and Data Types
  • Python Operators and Conditional Statements
  • Loops in Python
  • Functions in Python
  • File Operation in Python
  • Numpy
  • Pandas
  • Visualization
  • Getting started with SQL
  • Introduction to Databases
  • Primary Key vs Unique Key
  • Foreign Key Constraint
  • Update, Delete, Alter, DDL vs DML, Truncate vs Delete
  • Distinct, Order By, Limit, Like Keyword
  • Order of execution in SQL
  • Advance Datatypes
  • Aggregate Functions and Group By Statements
  • Logical Operators
  • Nested Queries
  • Joins and Union in SQL
  • Clauses (Where, Having, Order by)
  • Window Function (Row Number, Rank, Dense Rank, Lead, Lag)

About the instructor

Mr. Sufiyan M
Holds B.Tech in Mechanical Engineering

Sr. Data Analyst and Trainer with strong Analytical skills and 4+ years of experience. Specialist in Training Data Analytics for Non-IT background Students

Mr. Sufiyan is

Bachelors Degree Holder In Mechanical Department

Certified Data Scientist

Certified Data Analyst from Simplilearn, Coursera,etc

Experienced Trainer for NON-IT Students for the last 2 years.

Best Learner Badge holder at Tableau and IBM

Corporate Trainer and one of the Top Rated Trainers at Edgrow Training Center.

Student feedback

Reviews

User image
Ashar k
2 months ago

Over-all learning experience was good. I thoroughly enjoyed the online training classes and found it really satisfying after completing the DATA ANALYTICS course in EDGROW. Each and every trainer which were assigned to us was very professional and supportive. And most importantly they were interactive. All doubts were cleared in precise manner. I really had a good experience. Special thanks to Sufiyan sir and Dr. Md Daoud sir for developing skills and providing in Data Analytics. So thank you Edgrow for great learning experience.

User image
Kajal Auti
4 months ago

Hello am non.IT student ..and am learning data science in Edgrow..Edgrow is best to lnprove basic to advanced level skills...and industrial knowledge...also .Mr.daoud sir is very experienced person in this field..and he is also good lecturer and gaidence for students....am happy to have the part of Edgrow.. .. thanks..Edgrow for give me a best platform to prove self identity.... ..and also thanks to all team of Edgrow to support and valuable guidance for me .. ...thank you.

User image
Zubair khan
a year ago

Perfect platform to learn data science. Our mentor Dr. Md Daoud Sir who himself is a data scientist, puts so much efforts in teaching us. Teaching is practical oriented and focuses more on teaching industry needs. Staff is very humble and interactive. Overall a great experience in learning data science.

User image
David George
2 month ago

Perfect place to learn data science,data analytics course for the non-tech background students...

//