hello!

Who am I

My name is Fahad, I excavate insightful information from data. I am based in Riyadh, KSA. I specialize in data cleaning, modeling, visualization, BI, advance SQL and have solid knowledge of programming languages and structure.

I have a bachelors degree in Information systems. I’ve developed websites and a mobile fintech application. After graduation, I coordinated projects, worked on in-house application solution and implementing business intelligence to inform future decision making. Along with some interesting personal projects you can browse here.

I work out, play video games and grow plants. These activities taught me to be focused, sharp and persistent. Discipline and patience gave a better understanding that I can support people I work with to reach high mountain.

Though I need my time to charge my social battery, I spend time reading books or trying very hard not to be a bad cook 👨🏽‍🍳.

Work Experiance

National Data Managment office

I completed my internship in the summer of 2021 working for almost 3 months we worked with government agencies in activating data offices to comply with NDMO interms & regulations.

STC Solutions

I trained here for 6 month, learning about team dynamics, managing people and working on modern solution technologies. I was introduced to multitude of client projects from technology infrastructure, few Cybersecurity project, business analysis and application integration. My first exposure to data analytics, we needed a solution for import data in bulk by short amount of time and using less computing resources.

Ministry of Media

First I worked on digital transformation for all departments involved, I played a major role with coordinating important meeting, trainings and documenting. part of it was Implementing BI dashboard for general managers and the minister of media. I was responsible for making sure that goals are meet. I also volunteered to work writing media kit for international journalists covering 1444H hajj for the virtual Press Office.

Projects

Spotify tracks Dashboard

Most Streamed Spotify Songs 2023 dataset published by Nidula Elgiriyewithana on Kaggle.
I wanted to answer the following questions about the dataset:

1. Leaverage ChatGPT to enrich dataset and use external tools
2. What is the highest streamed track?
3. What are the average streams per year vs top song?
4. What are characteristics in popular songs?
5. When Tracks were released?

First, I wanted to ChatGPT to enrich the data. I gave it the dataset then asked for column with URLs of the song or album. It had some problems connecting the internet and therefore cannot do what I asked by its self, so I asked GPT to give me steps for using Spotify developer API and python script needed. Running the python script output a new CSV file with the URL column added. Navigating to it shows the cover. I proceeded to create background canvas for PBI.

After a close inspection of the dataset, it did not have a date column, but there is information about the year, month and day. To implement time intelligence in this dashboard, I used a calculated column to combine this information using the “date” function then used Bravo, an external tool to create a calendar table. Now I was able to create a line chart using dates from the date table to visualize count of tracks released by day.

Next, I quickly created 3 slicers at the ribbon, by Date range, Arist and track, helps you find more insight about the dataset then bar charts with number of steams for each track artist, this easily shows you the highest streamed tracks and popular artists filtered by most streams. I included more information about total streams, number tracks and number of participating artists utilizing cards KPIs. Right below it added more cards to show you what track achieved the highest number of streams, its name, release date and the artist’s name. The noticeable point is that even though Ed Sheeran’s “shape of you” ranked second most streamed, Bad Bunny ranked second most popular artist, a 26 total tracks with 15.4bn streams vs Ed Sheeran’s 13 total tracks with 14.6bn streams.

get in touch

Hobbies

I am Still writing this section.
DM me! I'll' show you my ✨boss & astheticly pleasing✨ setup or maybe we can exchange funny memes

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';