Mastering Data Analytics
source link: https://practice.geeksforgeeks.org/courses/dpa-self-paced?utm_campaign=course_card
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Mastering Data Analytics
Mastering Data Analytics
Mastering Data Analytics
Self-Paced Course5/5 ratings
Course Description
Course Overview
Keeping this in mind we bring to you a course that will help you grow from a beginner to an advanced level analyst equipping you with the tools and skills like Jupyter Notebook, Numpy, Pandas, Excel, SQL, Tableau, and more to become a smart and industry-ready Data Analyst expert.
Key Highlights:
- 10+ hours of Beginner Content
- 20+ hours of Advanced Content
- Work on Multiple Real Life Projects and implementation
- Industry Recognised Certificate
- Articles to supplement the learning experience
- Learn industrial tools including Pandas, Jupyter, Numpy, Excel, SQL, Tableau, and more
- Hands-on practice with Real-World Datasets
Enroll now and gear yourself up with the skill set required to advance your career in Data Analytics.
What you will learn
- Learn the basics of the Python Programming Language
- Understand how to work with files, JSON, Numpy, and the OS using Python
- Learn how to use Jupyter for data analysis and visualization
- Use Pandas to manipulate and analyze data
- Learn basic statistics and data preprocessing techniques for data analysis
- Build projects using data analysis techniques
- Understand the basics of Excel and SQL for data management and analysis
- Learn how to use Tableau for data visualization and reporting
Course Content
- Python
- Python Basics: Python Introduction, Variables in Python, input() in Pyhton, Arithmetic Operators in Python and more
- Loops in Python: Loops In Python, While Loops in Python, range() in Python, For Loop in Python and more
- Functions in Python: Functions in Python
- Strings in Python: Strings in Python, Escape Sequences and Raw Strings, String Operations, Pattern Searching in Python
- Data Structure: List Introduction, Tuples in Python, Set in Python, Dictionary in Python, Comprehensions in Python
- Data Toolkit
- Getting Started with Files: Reading Data from Test-File, Test Preprocessing, Writing Data On a test-file
- Inventory Management System with Files: Overview, Product Details, Updating Inventory, Add Functionalities, Generating Sales
- Inventory Management System with JSON: Overview, Generating Bill, Updating Inventory, Saving Record on JSON, Loading Record from JSON, Adding Functionalities and more
- Mastering Numpy Arrays: Getting Started with Numpy, Reshape and Random Number Generator, Arithmetic Operations on Array, Array Sorting, Merging and Slicing, Automating using Numpy
- Getting Started with OS: Introduction to OS, CLI and GUI, OS Commands on Mac- Directories and Files, OS commands on Windows
- Jupyter Notebook Setup: Jupyter Notebook Setup, Jupyter Notebook Walkthrough
- OS with Python: OS Library- Directories, List Directories, Bulk Directories Creation, Hirerical Bulk Directories Creation, Bulk Text-file reading and data combining
- Data Analysis with Python
- Getting Started with Pandas: Getting Started with Pandas, Dataset Walkthrough
- Statistics: Mean, median mode, Standard Deviation and Variance, Normal Distribution
- Data Preprocessing: Data Preprocessing - Removing Null Value Rows, Data Analysis - Numeric, Categorical, Automatic Categorical, Null Values Handling on GooglePlaystore Dataset
- Data Analysis: Data Analysis with Multiple Columns, Data Analysis using Conditions, GroupBy in Pandas
- Project Building: Data Visualization on Hear Disease Dataset, Black Friday Sales Data Analysis, GDP Analysis Assignment & Solution
- Excel
- Introduction to Excel: Interface of Excel, Entering Data, Changing the Structure of Worksheet, Data Styling
- Data Exntry in Excel: Entering Data, Tables in Excel, Insert and Create Objects in Excel, Managing Large Worksheets, Find, Replace, Autofill, Custom List
- Data Formatting & Validation: Data Validation In Excel, Conditional Formatting, Data Consolidation vs 3D Sum, Printing Options In Excel, What-If-Analysis
- Functions in Excel: Text Functions In Excel, Date Functions In Excel, Logical Functions In Excel, BODMAS Rule and Count Functions, Index Function Vs Match Function, Financial Functions In Excel, Statistical Functions in Excel, Maths and Trignometric Functions, VLOOKUP In Excel, HLOOKUP
- Hyperlinks & Illustration in Excel: How to add hyperlinks in excel, excel illustration, Excel Illustrations, Errors in Excel
- Pivot Table & Charts in Excel: Pivot Table, Charts in Excel, Sparklines Chart Vs Pivot Chart
- Shortcuts in Excel: Shortcut Keys, Shortcut Keys for Accessing the Tabs, F1 to F12 Shortcut Keys, Shift F1 to Shift F12 Shortcut keys, Ctrl F1 to Ctrl F12 Shortcut keys and more
- Visual Basic Analysis: Introduction to Macros and VBA, Code Your First Macro, Copy/Paste Sheet Content and WITH Block using Macro, Border and Alingment Using Macro, Change Font Color and Cell color using Macro, Change Orientation, Wrap Text and Merger/Unmerge Cells using Macro and more
Course Instructor
Sandeep Jain
Founder & CEO at GeeksforGeeks
Mr. Sandeep Jain graduated from Dr. Abdul Kalam Technical University with a B.Tech in Computer Science and Engineering. He completed his Master's degree from IIT-Roorkee and has worked as a full-time Software Developer at D.E. Shaw & Co. His passion for teaching led him to join JIIT Noida as an Assistant Professor.
He started GeeksforGeeks in 2009 as a blog, to compile resources on programming, algorithms, and interview preparation. He has curated and mentored the Data Structures and Algorithms - Self-Paced course on GeeksforGeeks, helping thousands of students land their dream jobs.
Associated Batches :
Data Analysis-PythonAshish Jangra
Associated Batches :
Data Analysis-PythonFrequently Asked Questions
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK