The video is a tutorial by Virtual School on creating a sales simulation of a bakery business in SQL Server and displaying its real-time sales information in Power BI Desktop using the Direct Query connection. The video begins by introducing the topic and outlining the steps involved in the tutorial. The steps include creating a…
This video is a tutorial on how to display real-time data on a Power BI dashboard using a free version of Power BI desktop and Microsoft SQL Server Express. The video starts by introducing the topic and then explaining that there are various ways to display real-time data on a Power BI dashboard. The video…
This video is a tutorial on how to use Excel’s slicer tool to filter data quickly and easily. The video starts with an introduction to the purpose of slicers, which is to filter data to find specific information quickly. The presenter then goes on to demonstrate how to use slicers on a table of sample…
The video is an introduction for beginners to Tableau software. It shows how to install Tableau for free and create a dashboard using a parking statistics dataset. The video begins by giving the link to the dataset in the description below. To start using Tableau, one must go to the tableau.com website and look for…
This video provides a tutorial on how to use bookmarks in Power BI for navigation between different dashboards and visuals. The video begins by introducing the topic of bookmarks and how they can be used for navigation in Power BI. The presenter then introduces the five dashboards that will be used as examples throughout the…
The video is a tutorial on creating a simple relational database in Microsoft Access. The video starts by introducing the objective of the exercise, which is to convert product, sales person, order type, and orders data in Microsoft Excel into a Microsoft Access relational database. The video then proceeds to explain how to create a…
The video explains how to use different what-if analysis tools in Excel to forecast profits based on historical data and sales values. The tools used in this video include Scenario Manager, Goal Seek, Data Table, and Forecast Sheet. The video starts by creating a new column and using the average formula to calculate the average…
The video is a tutorial on how to create a dashboard to display YouTube channel statistics using YouTube feeds without requiring API keys or permissions. The video demonstrates how to access the YouTube feeds of the Microsoft Power BI channel by copying and pasting the link from the page source into the navigation bar. The…
The video discusses how to use Power BI to analyze sales and marketing data using correlation analysis. The purpose is to identify the most effective marketing method to enhance sales. The video begins by explaining that the company is currently using electronic media, print media, and social media for marketing. To get started, the data…
The video is a tutorial on how to manage and monitor projects in Power BI, a data visualization and business intelligence tool. The instructor explains that they will create a Gantt chart to monitor the progress of various projects and their tasks, and a dashboard to monitor the progress and status of tasks by projects,…
