About me

Youtube statistics project

The charts show some of the Youtube statistics from the last 7 days, with videos, channels and tags statistics in separate tabs.
The charts are automatically updated every 6 hours (data event more frequently).
You can check the statistics for different countries (so far for Poland and USA).
Only those videos/channels that appear in the top 30 videos in a given country are included.

This is a project that I have invented and made from the ground up.
Here is some technical information about the project:

• Data from YouTube is collected using a Python script that calls the YouTube API (data for top 30 videos and related channels).
• The Python script is hosted on Azure Functions and runs every hour.
• Youtube data is stored in Azure SQL.
• I'm using a GitHub repo for this project, which is automatically synchronised with Azure Functions (a change in the repo automatically triggers an update in the Azure Function).
• PowerBI Charts include a number of filters and data transformations in both PowerQuery and DAX, as well as aggregating data from each hour into a 7-day summary statistic.
• This page is hosted in Azure Blob and contains PowerBI charts published to the web.

Company sales project

Here you can check charts related to a fictitious sales company. The project is a result of the Udemy course "Microsoft Power BI Desktop for Business Intelligence (2023)", which I completed to learn some of the basics of Power BI.

There are four sections (tabs), each containing a different aspect of sales indicators and results.

• The first shows some general revenue and order data.
• The second is a map of the world showing the size of orders in certain countries.
• The next section shows some actual vs. target data and trends for a sample product.
• And the last summarises customer data.

Elements

i = 0;

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

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