The video is a tutorial on how to create a dashboard to present financial data related to two options for starting a new project – buying machinery or renting it. The data, containing inflows and outflows for both options, is available in an Excel file. The video shows how to create a dashboard using Microsoft…
The video explains a step-by-step guide on how to display system performance information in real-time using Python, Microsoft SQL Server, and Power BI Desktop. The narrator explains that this exercise will help learners understand Python, SQL, and Power BI Desktop and how to connect the three major data science applications. The video begins by explaining…
This video tutorial is about Conditional Formatting in Power BI. The video starts by defining conditional formatting and its significance in data analysis. Conditional formatting is a feature in Power BI that allows users to format data based on specific conditions. It is used to highlight key insights in data and make it easier for…
The video is a tutorial on how to create a relational data model using Microsoft Excel. The tutorial begins with an introduction to the concept of a data model and proceeds to show how to convert Excel sheets into tables before defining relationships between the tables to create a data model. The speaker emphasizes the…
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…