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 EngineeringSr. 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 isBachelors 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
Ashar k
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.
Kajal Auti
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.
Zubair khan
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.
David George
Perfect place to learn data science,data analytics course for the non-tech background students...
30-Day Money-Back Guarantee
This course includes
- 2.5 hours on-demand video
- 34 articles
- 12 downloadable resources
- 51 coding exercises
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
