1. Introduction to Data Analytics
Overview of Data Analytics
Opportunities and Careers paths in Data Analytics
Roles and responsibilities of a Data Analyst
Data Analytics Case Studies
2. Data Visualization
Fundamentals of Data Visualization
Introduction to Power BI
Data Visualization using Power BI
3. Advanced-Data Visualization
Slicers and Filters in Power BI
Interactive Visualisations in Power BI
Creating Paginated Reports
Creating Dashboards in Power BI
4. Data Cleaning & Transformation using Excel / Power Query
Data Cleaning Techniques
Data Transformation Techniques
Introduction to Power Query
Data Types and Filters in Power Query
Inbuilt Column and Row Transformations
Creating a Query in Power Query
Combining Two Data Sets
5. Data Modelling & DAX
Introduction and Techniques to Data Modelling
Creating Measures in DAX
DAX Functions
6. Publishing Your Dashboards
Introduction to Power BI Service
Collaboration using Power BI
Creating Dashboards using Power BI Cloud/Service
Publishing Your Dashboard
7. Data Analysis using Python Libraries
Introduction to NumPy and Pandas
Indexing and Slicing NumPy arrays
Indexing and Filtering Pandas data frames and series
Modifying Pandas data frames and Series
8. Data Analytics using Tableau
Fundamentals of Tableau
Essential Design Principles for Visualization with Tableau
Creating Dashboards and Interactive Reports in Tableau