Data Analysis and Visualization Tools in Python with Numpy, Pandas, SQL, PowerBI

This course is suitable for individuals who are interested in learning the basics of data science and data analysis and visualization. It is particularly geared towards those who have some knowledge of programming in Python and are looking to gain hands-on experience with data analysis and visualization tools such as Numpy, Pandas, SQL, and PowerBI. The course is suitable for people with a beginner to intermediate level of experience in data science and computer programming.

The course is a basic introduction to Data analysis and Data visualization tools. The participants will learn about the building blocks of the basics of data science analysis and tools and techniques Python, Numpy, Pandas, SQL, and the basics of PowerBI.

• No prerequisite

Session 1: Understanding Python (3 hours)

• What is a python
• Installation of python
• Variables, data types, and operators in python
• Looping statement, looping constructors, function 
• Data structure
• List, Dictionaries, and standard libraries in python
• Understanding python through hands-on coding

Session 2: Understanding pandas (3 hours)

• What is pandas
• Reading files through pandas
• Understanding different panda’s functionality

Session 3: Numpy (3 hours)

• What is numpy
• Numpy datatype and attributes
• Understanding different functionality of numpy

Session 4: Matplotlib (3 hours)

• Different data visualization through matplotlib

Session 5: Power BI (3 hours)

• What is power BI
• Connecting to different data types through Power BI
• Power Query
• Power BI DAX
• Different dashboards through Power BI

Session 6: SQL (3 hours)

• What is SQL
• Basics of SQL
• SQL joins
• Connecting python and SQL