Introduction to Data Analytics

• Overview of Data Analytics, importance, and applications in various industries
• Understanding different types of data (structured, unstructured), data sources, and data formats

Introduction To Python

• Overview of Python, its importance, and applications
• Basics of Python programming for Data Science (variables, data types, control structures)

Data Manipulation and Visualization(Python)

• Introduction to Pandas for data manipulation
• Data visualization using Matplotlib and Seaborn

Data Cleaning and Preprocessing(Python)

• Handling missing data and outliers
• Feature scaling, encoding categorical variables, and data normalization

Advanced Excel for Data ANALYSIS

• Excel Fundamentals for Data Analysis
• Introduction to Microsoft Excel, navigation, basic functions (SUM, AVERAGE, etc.)
• Data entry and formatting, sorting and filtering data, basic formulas and functions
• Data Manipulation and Analysis in Excel
• Advanced functions (VLOOKUP, IF, INDEX/MATCH), data validation, and conditional formatting
• PivotTables and Pivot Charts for data summarization and visualization, data analysis with What-If analysis tools
• Statistical Analysis in Excel
• Descriptive statistics (mean, median, mode), frequency distributions, and histograms
• Correlation analysis, regression analysis, and hypothesis testing using Excel

Data Visualization with Tableau

• Introduction to Tableau
• Overview of Tableau, its interface, and different products (Tableau Desktop, Tableau Server)
• Connecting to data sources, importing data into Tableau, and understanding Tableau data types
• Creating Visualizations in Tableau
• Building basic charts (bar charts, line charts, pie charts) and maps in Tableau
• Advanced visualization techniques (dual-axis charts, treemaps, heat maps) and dashboard creation

Advanced Data Analysis with Power BI

• Introduction to Power BI
• Overview of Power BI, its components (Power BI Desktop, Power BI Service), and data sources
• Data preparation and transformation in Power BI using Power Query Editor
• Building Reports and Dashboards in Power BI
• Creating visualizations (bar charts, line charts, matrices) and formatting in Power BI
• Interactive dashboards, slicers, and drill-down capabilities in Power BI

Advanced Techniques in Tableau and Power BI

• Advanced Calculations in Tableau
• Calculated fields, table calculations, and LOD expressions in Tableau
• Using parameters and advanced mapping techniques in Tableau
• Advanced Data Modeling in Power BI
• Introduction to DAX (Data Analysis Expressions) for creating calculated columns and measures
• Advanced data modeling techniques, relationships, and hierarchies in Power BI

Capstone Project and Integration

• Capstone Project
• Students work on a real-world data analytics project using Excel, Tableau, or Power BI
• Presentation of capstone projects, peer review, and feedback sessions
• Integration and Best Practices
• Integrating Excel, Tableau, and Power BI for comprehensive data analysis workflows
• Best practices in data analytics, data visualization, and storytelling with data

Bonus

• Learn How to use ChatGPT in Data Analytics
• Interview preparation & Personality development