EXCEL · SQL · POWER BI · PYTHON · TABLEAU
Data Analytics course.
Turn data into useful reports and dashboards with Excel, SQL, Power BI, Python and Tableau.
Course overview
Explore the data analysis process across six modules: Data Analytics, Excel and Advanced Excel, SQL, Power BI, Python and Tableau. Practice data cleaning, modelling, visualization and reporting, then combine the tools in retail sales and COVID-19 capstone projects.
Detailed syllabus
DATA ANALYTICS
- Introduction to Data Analytics
- Types of Data Analytics
- Benefits and Overview of Data analytics
- Data Analysis Process
- Data Types
- Sampling Funnel
- Graphical Techniques
- Data Visualization
- Data Modelling
- Sampling Variation
- Data Analytics using Tableau
- Confidence interval
- Data Analysis using Python libraries
EXCEL & ADVANCED EXCEL
- Entering and Editing Text
- Excel Functions
- Graphical Techniques
- Important Functions and Formulae in Excel
- Excel List
- Pivot Tables
- Power Pivot
- List Functions
- Data Validation
- Conditional and Lookup Functions
- Charts
- Pie Charts
- Conditional Formatting
- Formatting, Removing and Cleaning data with Text Functions
- Using IF Functions
- Text Based Functions
- Concatenate Functions
- Using Slicers
- Data Visualization in Excel
- Project – Analysis
- Table Style
- Grouping Items
- Table Styles
- Viewing Names in a Workbook
- Copying formulas with Names
- Finding a workday after specified days
- Create Table
- Table Name
- Resize Table
- Converting the Dates
- Obtaining the Today’s Dates
- Obtaining Date from Day, Month and Year
- Number of workdays between two given dates
- Calculating Years, Months and Days between two dates
- Extracting the Day of the Week
SQL
- Introduction to Database
- Introduction to RDBMS
- Types of Database
- SQL Database
- Commands
- Table
- SQL Select
- Clause
- Functions
- Working with SQL: Joins, Tables and Variables
- Order By
- Set Operators
- Keys
- Sub Queries
- Database Normalization and Entity Relationship Model
- Constraints
- Indexes and Views
- Stored Procedures
- SQL Optimization and Performance
- Triggers
- Exception Handling
- Regular Expression Support
- SQL vs NoSQL
- About NoSQL
POWER BI
- Introduction to Power BI
- Power BI Installation
- User Interfaces
- Power BI Dashboard
- Transforming Data using Power BI Desktop
- Visualizations
- Types of data sources
- Power BI Artificial Intelligence Visual
- Power BI Query Editor
- Modelling with Power BI
- Power Query Editor
- Customize the data
- Sample Dashboard with Animation Visual
- Data Cardinality and Data Modelling
- Power BI Query Editor Filter Data
- Custom Visual
- Dax Expressions
- Power BI Service
- Organization Packs and Security
- Power BI Python Integration
- Power BI SQL Integration
- Sample Dashboard with Animation Visual
PYTHON
- Introduction to Python
- Python Data Types
- Python Basics
- Python Operators
- Python Loops
- String
- Lists
- Tuples
- Sets
- Dictionary
- Functions
- Built-in-Functions
- Lambda Functions
- File Handling
- Modules
- Exception Handling
- Date and Regular Expression
- Module
- Thread and Date Time in python
- Arrays
- Python OOPs
- Python MySQL
TABLEAU
- Introduction to Tableau
- Basic Reports in Tableau
- Advanced Tableau Reports
- Charts
- Formatting
- Filters
- Calculations
- Tableau Dashboard
- Data Combining Techniques
- Custom Charts
- Server
- Analytics and Dashboard
- Hierarchies
- Dashboard Actions
- Tableau Public
- Groups and Bins
- Sets and Parameters
Projects
- AI-enhanced retail sales analysis: Analyze and forecast retail sales using Python, SQL and Power BI.
- Comprehensive COVID-19 data analysis: Analyze and visualize COVID-19 data with AI-enhanced reporting using Python, SQL and Power BI.