Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python
4.0 /5- Offered byUDEMY
Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python at UDEMY Overview
Duration | 22 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 12 downloadable resources & 7 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python at UDEMY Course details
- For Anyone curious to master Data Analysis in a short span of time
- For Business Analysts/ Managers who want to expand on the current set of skills
- A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
- Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
- Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
- Make great presentations using Bar charts, Scatter Plots, Histograms etc.
- Knowledge of all the essential SQL commands
- Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
- Become competent in using sorting and filtering commands in SQL
- Learn how to solve real life problem using the Linear Regression technique
- This course will teach you data-driven decision-making, data visualization, data analytics in SQL, and the use of predictive analytics like linear regression in business settings
- Understand how to interpret the result of the Linear Regression model and translate them into actionable insight
- Learn how to solve real-life business problems using the Linear Regression technique
- The practical classes where we create the model for each of these strategies are something that differentiates this course from any other course available online
Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python at UDEMY Curriculum
Introduction
Introduction
Excel Basics
Milestone!
Basics
Worksheet Basics
Data Formats
Data Handling Basics - Cut, Copy and Paste
Saving and Printing - Basics
Essential Formulas
Basic Formula Operations
Mathematical Functions Part-1
Mathematical Functions Part-2
Difference between RANK, RANK.AVG and RANK.EQ
Textual Functions Part -1
Textual Functions Part -2
Logical Functions
Date-Time Functions
Lookup Functions (V Lookup, Hlookup, Index-Match)
New XLOOKUP- only for excel2021 and office 365
XLookup as a replacement of Vlookup
Handling #NA and Approximates match in Xlookup
Wildcard matching in XLookup
Search modes in XLookup
Data Tools
Data Tools Part - 1
Data Tools Part - 2
Formatting data and tables
Excel charts
Importance of data visualization
Elements of charts
The Easy way of creating charts
Bar and column charts
Formatting Charts Part 1
Formatting Charts Part 2
Line Charts
Area Charts
Pie and Doughnut Charts
Scatter plot or XY chart
Waterfall Charts
Sparklines
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsData AnalysisData Analyst Skillpath: Zero to Hero in Excel, SQL & Python