Context

In this practical assignment, students will apply their business intelligence knowledge and practical skills to develop business intelligence solutions.

This practical assignment setting will be on the simulated phishing campaigns dashboard. As an analyst, your main task is to apply the MS Power BI tool and develop business intelligence solutions (i.e., simulated phishing campaign dashboards). You may use either real-world or artificial datasets.

Specific Requirements

1. Your task is to develop the relevant BI dashboards using the MS Power BI tool. Please present the BI dashboard first, then followed by an explanation of each chart of the dashboard. At least 3 different dashboards are expected.

2. Justify why these BI solutions could provide insights and why those attributes are laid out in the fashion you proposed (feel free to include all other relevant justifications). Note: To ensure that you discuss task (2) properly, you must include visual samples of the reports you produce (i.e., the screenshots of the BI charts/dashboards must be presented and explained in the written report; use ‘Snipping tool’), and also include any assumptions that you may have made.

3. The BI report should include: 1) objectives and advantages of your BI solution, 2) BI dashboards screenshots and commentary, 3) overall findings and recommendations based on your analysis, etc.

4. Feel free to make reasonable assumptions or refine the data as needed. You may create your own artificial datasets. Real-world dataset is not mandatory. Note: Do refer to the assignment marking rubric & report outline example. See examples of simulated phishing campaigns dashboard: https://support.phishingtackle.com/hc/en-gb/articles/360029323431-The-Phishing-Tackle-Dashboard

5.

Some useful links:

• https://www.openml.org/search?type=data&sort=runs&id=4534&status=active

• https://community.mimecast.com/s/article/awareness-training-phishing-campaign-analytics

• https://github.com/randomaccess3/Awesome-BEC

• https://www.kaggle.com/datasets/shashwatwork/phishing-dataset-for-machine-learning

• https://www.kaggle.com/datasets/shashwatwork/web-page-phishing-detection-dataset

• https://data.world/datasets/hack

• https://www.cybsafe.com/solutions/phishing-usb-attack-simulations/

• https://phished.io/

• https://www.phishingbox.com/

• https://www.phriendlyphishing.com/