• Tutorials
  • DSA
  • Data Science
  • Web Tech
  • Courses
    Get 90% Refund!
gfg_dialler_icon
08069289001

Mastering Data Analytics - Python, SQL, Excel, Tableau

Self-Paced Course
backgroundoverlay
interested count19k+ interested Geeks

Course Description

The surging demand for data in business and IT makes it the new oil. Elevate your skills with our Mastering Data Analytics course. Learn Python, SQL, Excel, and Tableau for data analysis, visualization, and reporting through hands-on projects

levelBeginner to Advancecourse duration8 Weeks
Comprehensive LearningIndustry ReadinessCapstone Projects
warning

Three 90 Challenge is Back and It's Bigger & Better than Ever!!
Complete 90% Course within 90 Days & Get 90% Refund!

Course Overview

  • 30+ hours of Content tailored and delivered by Industry Experts
  • Uncover patterns and insights crucial for informed decisions.
  • Work on Multiple Real Life Projects and implementation
  • 10 Contests for self assessment
  • Learn industrial tools and libraries including Pandas, Jupyter, Numpy
  • Learn Python, Excel, SQL, Tableau, and much more
  • Get Industry-Recognised Certificate
  • Hands-on practice with Real-World Datasets
  • Gain direct experience in the day-to-day life of a Data or Business Analyst
  • Learn everything from analysis to visualization
Read more

Three 90 Challenge

We were listening, and we heard you loud and clear. The Three 90 challenge is back and this is your chance to get 90% of your fee back in just 90 days!

90 Days

Course Content

01Python
  • 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
02Data 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
03Data 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
04Excel
  • Exploring Data: Overview & Basics of Spreadsheet Navigation, Working on Rows and Columns, Looking for exact matches, Trimming function and its usage, Sorting the data, Nesting functions, Data types in Excel, and Type conversion in Excel.
  • Preparing Data: Text Functions in Excel: CONCATENATE, UPPER, LOWER, and PROPER, Text Extraction in Excel: LEFT, RIGHT, and SUBSTITUTE Functions, DATE Function: Effective Techniques for Date Handling, DATEDIF Function, Relative & Absolute Cell References,  In-depth VLOOKUP, Sumif Function in Excel
  • Analysing Data: COUNT, COUNTA, and COUNTBLANK Functions, Countif Function, Excel's Core Calculation Functions, Excel Logic Functions: IF, AND, and OR, UNIQUE and SORT Functions.
  • Project: Sales Data Analysis Using Covered Functions and Pivot Tables
Read more
Unable to loadUnable to load

Pricing

Frequently Asked Questions

01

Will I get 90% of my course fee back?

02

How can I register for the course?

03

Is there any number to contact for query?

04

Can I make the payment through PayPal?

05

How long will the course content be available for?

06

When can I make the payment for the course?