Data Analytics 360: Become Data Analyst in 40 Days

Master Python and Excel - 2 Widely Used Tools for A-Z Data Analysis with Complete Foundations and Hands-on Applications.

Created by: Shahriar's Intelligence Academy
Navigate the Future with Data Intelligence

What Will I Learn?

• You will master the fundamentals of data analytics, including facts and theories, statistical analysis, hypothesis testing, and machine learning.
• You will learn how to apply conditional formatting in Excel to visually highlight key trends, insights, and anomalies within your data.
• You will learn essential Excel formulas and functions such as SUM, AVERAGE, COUNT, IF statements and MORE, enabling you to manipulate data effectively.
• You will learn to utilize Excel's lookup functions (VLOOKUP, HLOOKUP, XLOOKUP) to efficiently search for and retrieve specific information within datasets.
• You will learn various graph and chart types in Excel for data visualization, including bar charts, pie charts, scatter plots, and more to communicate insights.
• You will learn advanced analysis using PivotTables and PivotCharts, enabling you to analyze, and visualize complex datasets with ease and interactivity.
• You will learn to use Excel's built-in data analysis tools for statistical analysis, i.e., descriptive statistics, t-tests, ANOVA, correlation, and regression.
• You will learn to design and create dynamic DASHBOARD in Excel, by a visually interactive format for effective decision-making and reporting.
• You will learn the important Python programming basics such as variables naming, data types, lists, dictionaries, dataframes, sets, loops, functions etc.
• You will master a range of methods and techniques for data cleaning, sorting, filtering, data manipulation, transformation, and data preprocessing in Python.
• You will learn to use Python for data visualizations, exploratory data analysis, statistical analysis, hypothesis testing methods and machine learning models.
• You will work on practical data analysis projects to apply learned skills. Enhance problem-solving abilities through hands-on data analysis exercises.

Requirements

• Access to computer and internet
• Basic computer literacy
• No coding experience required
• Dedication, patience and perseverance

Target audience

• Those who are highly interested in learning complete data analytics using Python.
• Individuals aiming to develop comprehensive knowledge in data cleaning, analysis, visualization, and dashboard creation in Excel.
• This course is NOT for those who are interested to learn data science or advanced machine learning application.