An end-to-end data analytics project built in Power BI that simulates a SOC environment by analyzing cybersecurity attack logs and transforming them into interactive visual dashboards.
- Power BI
- Microsoft Excel / CSV datasets
- Python (data preprocessing – Pandas)
- DAX (Data Analysis Expressions)
- Interactive cybersecurity dashboards
- Attack trend analysis by time, country, and technique
- Risk classification (Low / Medium / High)
- SOC-style threat monitoring view
- Data-driven security insights
- Collected raw cybersecurity log data
- Cleaned and processed data using Python (Pandas)
- Created risk classification rules
- Structured data into relational format
- Imported data into Power BI
- Built dashboards using visuals + DAX measures
- Tested insights for accuracy and usability
- Data cleaning and preprocessing for real-world datasets
- Building data models (fact & dimension tables)
- Creating interactive dashboards in Power BI
- Understanding cybersecurity attack patterns
- Turning raw logs into meaningful insights
- Download the repository
- Open Power BI Desktop
- Load the dataset (
clean_attacks.csvor original dataset) - Open the
.pbixfile - Refresh data if needed
- Explore dashboards interactively
- Ctrl + Click → Multi-select visuals
- Ctrl + C / V → Copy & paste visuals
- Ctrl + Z → Undo
- Ctrl + Shift + M → New measure
- F11 → Full screen mode
- Add real-time threat intelligence feeds
- Integrate machine learning for anomaly detection
- Automate data pipeline (ETL process)
- Deploy dashboard to Power BI Service
- Add alert system for high-risk attacks
To simulate a real-world Security Operations Center (SOC) dashboard that helps analysts quickly detect, monitor, and understand cyber threats.