Omdena Academy Courses

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

December 29, 2023


Omdena Course Featured Image

For whom is this course?

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.


What will you learn?

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.


Prerequisites

  • No prerequisite

Syllabus

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

Instructors




Course Info

Certificateyes
Duration18 hours
Start DateMarch 19, 2023
Last Registration DateMarch 12, 2023
No of Students50-80
Skill Levelbeginner,intermediate

View more Courses

media card
View all courses from Omdena Academy Go Back