Insight Mentor



Python Foundations for Data Analysis & Business Intelligence

What you'll learn

Requirements

Who this course is for


No prior programming experience is required. However, a basic understanding of programming concepts and familiarity with Microsoft Excel would be beneficial

Course content

  • Introduce the Python analytics ecosystem and key reasons why it’s the programming language of choice for many data analysts
  • Install Anaconda & create your first Jupyter Notebook, a user-friendly Python coding environment designed for data analysis and visualization
  • Learn how to name and store values in memory using variables, as well as how to overwrite, delete and track them.

  • Learn how to name and store values in memory using variables, as well as how to overwrite, delete and track them.

  • Learn how to work with numeric data, and use numeric functions to perform a range of arithmetic operations
  • Learn how to manipulate text via indexing and slicing, calculate string lengths, apply various string methods, and print f-strings to include variables

  • Learn how to use IF statements and Boolean operators to establish conditional logic and control the flow of your programs
  • Learn how to create, modify, and nest lists, tuples, and ranges, all of which allow you to store many values within a single variable
  • Understand the logic behind For and While loops and learn how to refine loop logic and handle common errors
  • Address the limitations of working with lists and explore common scenarios for using dictionaries and sets in their place

  • Learn how to create custom functions in Python to boost productivity, and how to import external functions stored in modules or packages

  • What is slicing and indexing and how its work on different data types of python.
  • Various operator used in python and their importance in python programming
  • How to handle error in python. How to handle error(s) using try-except-else-finally block.
  • Learn what is numeric python and how it is important in programming and data analysis
  • Learn about most useful module pandas. Data reading, Data manipulation, cleaning using pandas module.

how to create, move, rename, delete files and folders in your system. Various ways to handle file and folder structure using OS.

  • Learn how to work on projects using all the knowledge we gain until now.

Tools Covered

Python
Python
Jupyter
Jupyter
Numpy
Numpy
Pandas
Pandas
Matplotlib
Matplotlib
Excel
Excel
Scroll to Top