Course Description

This course provides a practical introduction to Apache Airflow, an open-source platform used to programmatically author, schedule, and monitor data workflows. Students will learn how to build, manage, and optimize data pipelines using Directed Acyclic Graphs (DAGs), integrate Airflow with cloud services and databases, and apply best practices for automation and monitoring in modern data engineering.

Why should I join?

Airflow helps you manage:

Cloud workflows

ETL/ELT processes

Data movement between systems

Machine learning pipelines

Please contact us if you have any questions relating to any of the vika technologies features.

Course Content

Oracle Introduction
4 Topics
What is Power BI?
Power BI ecosystem: Desktop, Service, Mobile, Gateway
Power BI vs Excel vs Tableau
Installing Power BI Desktop
Unix Commands
4 Topics
Power BI interface & layout
Connecting to data sources
Data import vs direct query
Basic data loading and previews
OS information
5 Topics
Power Query Editor interface
Data cleaning techniques:
Transforming columns: split, merge, extract
Pivoting and unpivoting data
Appending and merging queries
Copy and move commands using cp, mv command
5 Topics
Introduction to relationships
Star vs snowflake schema
Creating and managing relationships between tables
Creating calculated columns and measures
Using DAX (Data Analysis Expressions):
Compression and un-compression
7 Topics
Creating visuals: Bar, Line, Pie, Card, Map, Table, Matrix
Custom visuals
Slicers and filters (visual, page, report level)
Drillthrough and drill-down reports
Conditional formatting
Tooltips and bookmarks
Sorting, grouping, and hierarchies
Changing file permission
5 Topics
Publishing reports to Power BI Service
Report Publishing reports to Power BI Service
scheduling and refresh
Workspaces and apps
Data Gateway setup for on-prem data
Scheduling the job
5 Topics
Row-Level Security (RLS)
Q&A visual and natural language queries
Exporting reports to PDF/PPT
Embedding Power BI reports
Introduction to Paginated Reports
Editor command
4 Topics
Sales dashboard
Marketing performance report
Financial reporting dashboard
HR analytics dashboard
Includes
8 Lessons
39 Topics