Virtual School

Azure Data Studio – Complete Guide for Beginners including SQL, Python, Sanddance and Dashboards

Admin11 months ago2 months ago01 mins

The video provides an introduction to Azure Data Studio and its functionalities. It covers connecting to SQL servers and databases, writing SQL queries and notebooks, installing and running Python code, exporting data to various formats, creating and customizing charts and dashboards, and using the Sand Dance visualization extension. #AzureData #AzureCloud #MicrosoftAzure #CloudComputing #SQLServer #Database #SQLQueries…

Creating a Stunning HR Performance Dashboard using Images and Slicers and Visuals

Admin11 months ago2 months ago01 mins

This video tutorial creates a beautiful HR performance dashboard in Power BI. The dashboard will include KPIs (Key Performance Indicators) such as female on board, engagement rate, and headcount. It will also use visuals like gauges, bar charts, slicers, and a map to represent the data. You will learn how to add images and format…

Project Payback, and Cost and Benefit Analysis using DAX and Power BI Dashboards

Admin11 months ago2 months ago01 mins

This video is a tutorial on how to perform cost-benefit and payback analysis of a project using Power BI. It walks you through creating a table with initial cost, yearly cost, yearly benefit, and interest rate. Then it demonstrates how to calculate present value, cumulative present value, and net present value. Finally, it shows how…

Complete Realtime Dashboard Demo using SQL Server Database from start to end

Admin11 months ago2 months ago02 mins

This is a video tutorial about creating a real-time SQL Server dashboard in Power BI. Here’s a summary of the video: – We’ll build a demo project from scratch by creating a SQL Server database and table. – We’ll insert data repeatedly into the table. – We’ll create a dashboard in Power BI to display…

Power BI: DAX Query View for Beginners – Supercharge Your Dashboards with DAX Query View

Admin12 months ago2 months ago02 mins

The video is about creating a dashboard and exploring Dax query view in Power BI. The speaker first introduces the Dax query view, which is a new feature in Power BI desktop. Then he demonstrates how to load data into Power BI and create a dashboard with various charts. After that, he explains how to…

Build Your Own Excel Toolbars: Excel Automation with Add-in created in Visual Studio using VSTO

Admin12 months ago2 months ago01 mins

This video provides a step-by-step guide on creating a custom Excel add-in using Visual Basic for Applications (VB.NET) and Microsoft Visual Studio. It starts with setting up the project in Visual Studio, then walks you through designing the add-in ribbon with buttons and options for formatting. Next, you’ll learn how to code the functionality behind…

Manage and Track Projects in Power BI Using S Curve

Admin12 months ago2 months ago01 mins

This video tutorial demonstrates how to create a project management dashboard using Power BI. The dashboard uses S-curve charts to visualize project progress. The video starts by explaining what S-curves are and their usefulness in project management. Then, it guides viewers through loading project data into Power BI and creating the dashboard with various charts…

Using Images in Pivot Tables, a new added Feature by Microsoft

Admin12 months ago2 months ago01 mins

This video tutorial is about creating pivot tables with images in Microsoft Excel, a newly introduced feature. It walks you through the process step-by-step, starting with creating a new sheet for photos and adding images of salespeople next to their names. Then it explains how to use VLOOKUP function to bring those photos into the…

Complete Guide to the New Chart Pane in Excel Online

Admin12 months ago2 months ago02 mins

This video tutorial will guide you through using the new chart pane in Microsoft Excel Online to format and style your charts. What you’ll learn:Accessing the chart paneFormatting chart elements (title, legend, axis, gridlines)Data label optionsAdding error barsUsing trendlinesData table settings Video Outline:We’ll use sample data to create a chart.Pivot tables won’t work with the…

Creating Dashboards for Mobile Devices

Admin12 months ago2 months ago01 mins

This video tutorial is about creating a mobile-friendly dashboard in Power BI. It starts by guiding you through how to import data from a website and design visuals in the desktop layout view. Then it explains how to switch to the mobile layout view and arrange the visuals appropriately for mobile devices. Finally, it demonstrates…