Browse

Power BI: How to install Power BI Desktop and create your first Chart (Tutorial)

In this video tutorial we will show you how to install Microsoft Power BI Desktop for free and how to create your first chart using web data. https://virtual-school.org/tutorial?v=qDCLsvvoAPk...

Power BI: Dimensional Model Report using Adventure Works sample data. (Tutorial)

Today we will show you how to: - Import data from MS Excel - Create dimensional model - Create relational data model - Create hierarchies - Create charts, diagrams, slices, matrix and maps - Create measures using Data Analysis Expressions (DAX) We will use...

Power BI: Sales and Profit Report by Date, Country, Product and Segment (Tutorial)

In this power bi video, we will create a Power BI report using Financial Sample (https://go.microsoft.com/fwlink/?LinkID=521962) Excel Workbook by Microsoft. We show you how to create a Sales Report by Product and Segment and a Profit report by Date and Co...

Power BI: Decomposition Tree and Ribbon Chart, Sales by Year, Region, Store, Product and Sale Type

Today we will to create decomposition trees and ribbon charts using DTS Sales data (https://docs.google.com/spreadsheets/d/1FbeFtMlB-CcrOnfWW39SdcIWXyLJm5qy/edit?usp=sharing&ouid=111966831820301688680&rtpof=true&sd=true). We will show Sales by Year, Region...

Power BI: Visualizing Stock Positions and Historical Movements, Yahoo Finance, Google (Googl) Stock

In this video tutorial, we will show you how to import stock market data from websites such as Yahoo Finance, transform that data for in Power Query Editor and Create Power BI reports from that data. We are gonna use Googl Symbol (Alphabate/Google Inc.) fo...

Power BI: Drill Down Report by Date, by Product, by Store Location (Tutorial)

In this video we will create a report with drill down mode turned on. We will show you how to drill down charts to further details. We will drill down charts by date (years, quarters, months, days), by store location (country, state, city), by product (loc...

Power BI: Artificial Intelligence (AI) (Key Influencers), Analyzing & Predicting Credit Risk

In this video we will show you how to use Key Influencers (Powe BI Artificial Intelligence). We will use credit risk data from web, and try to explain the loan default, by borrowers age, income, intent, home ownership, loan amount, etc. Dataset used in thi...

Power BI: Team and Product Performance Analysis using Power BI (Tutorial)

In this video, we will show you how to analyze the performance of teams, their members, product categories and products through Power BI dashboard. We will create monthly sales and profit charts and use slicers to filter the data by teams/members and produ...

Power BI: Dashboards with Tooltip Pages (Tutorial)

Today we will show you how to create reports with tool tip pages. We will create a sales report by country and products where products and countries will have tooltip pages which will appear when you will hover over their relevant fields. Link to the xlsx...

Power BI: Bank Failure in USA (2000-2020) Dashboard

Today we will create a dashboard from data collected from FDIC Bank Failure dataset: https://catalog.data.gov/dataset/fdic-failed-bank-list. We will show you how to use various charts including map charts and multi row cards. #bankruptcy #financialcrisis ...

Power BI: Using Smart Narratives to add Automatic, Responsive and Dynamic Descriptions

In this video we will show you how to add automatic, responsive and dynamic descriptions to your Power BI visualizations using Smart Narratives. We will use Electric Vehicles Registered with Washington Department of Licensing (https://catalog.data.gov/data...

Power BI: Using DAX (Data Analysis Expressions) to Evaluate Performance

Today we will use Data Analysis Expressions (DAX) to create columns and tables in the Power BI and use those tables to display visualizations. Excel file: https://docs.google.com/spreadsheets/d/1cSmnIs9vW6cyJ5Z-vf1IjV-Gb7vk7feD/edit?usp=share_link&ouid=1...

Power BI: Drill-through Reports, analyzing regional sales data in drill through report (Tutorial)

Today we will create a drill through report in Power b i. With drill through in Power B I reports, you can create a destination target page in your report, that focuses on a specific entity, such as a supplier, customer, or manufacturer. When your report r...

Power BI: Crimes in Los Angeles on Power BI Dashboard (Tutorial)

Today we will create a dashboard, showing crimes in Los Angeles, from 2020 onward. We will show you how to display crimes by type of crime, age, area, gender, descent, status, premises, weapon and location. We will use donut charts and map charts to displa...

Power BI: Multi Page Power BI Dashboard using Northwind Traders Database (Tutorial)

Today, we will use Northwind Traders data, to create multiple dashboards in Power BI. Northwind Traders is a fictitious organization that manages orders, products, customers, suppliers, and many other aspects of a small business. This sample appeared with ...

Power BI: Using Sankey Diagrams to show US Rivers data

In this video we will create a dashboard, using Sankey diagram. Sankey diagrams are a type of flow diagram, in which the width of the arrows is proportional, to the flow rate of the depicted extensive property. We will use a third party custom visual. The ...

Power BI: Analyzing Bank Loans Aging/Classification/Movement (Tutorial)

Banks analyze there loans in several ways to minimize credit risk, one of them is loans cycle / loans classification / loans movement analysis. In these analysis, they try to make sense of data using aging buckets, and how loans move from one bucket to ano...

Power BI: Connecting to the World Bank Data using API (WBGAPI)

The World Bank Group has a lot of economic and social data on their servers, which is available for free. You can download and use the data too, but today we will show you how to connect power bi directly to their data, through API, and create dashboards ...

Power BI: Grouping Data in Power BI (Tutorial)

In Power BI, grouping data allows you to combine multiple data elements into a single unit. This can be useful for summarizing and analyzing data in a more meaningful way. For example, you can group similar items, and display their data combined. In today'...

Power BI: Forecasting Data with Power BI - Forecasting the Global Temperatures (Tutorial)

The video is demonstrating how to use the forecasting feature in Power BI, a business intelligence and data visualization tool. The tutorial is using global temperature data to create a forecast. The speaker starts by importing historical temperature data ...

Power BI: Analyzing human resource data and forecasting future hiring requirements

This video is about analyzing human resource data using Microsoft Power BI. It covers how to import data from a Google spreadsheet, perform data modeling and cleaning, and create various visualizations such as slicers, gauge charts, map charts, bar charts,...

Power BI: Creating a Dimensional Report based on Star Schema, in Power BI (Tutorial)

This video demonstrates how to create a Power BI dimensional report from a star schema database created in Microsoft Access. A star schema is a type of relational database schema that consists of a central fact table surrounded by dimension tables, linked ...

Power BI: Market Basket Analysis Simplified: A Step-by-Step Guide

The video explains how to perform market basket analysis in Power BI, using sales data of over half a million items. Market basket analysis is a data mining technique used by retailers to understand customer purchasing patterns and increase sales. The proc...

Power BI: Exploring Default Visuals in Power BI, A Comprehensive Guide

The video is about exploring the default visuals in Power BI, which is a business intelligence tool used for data visualization and analysis. The video explains how to import data into Power BI and create various types of charts, including stacked charts, ...

MS Excel/Power BI: Unpivoting and Properly Pivoting Data in MS Excel and Power BI

In this video, the speaker explains how to unpivot data in Microsoft Excel and Power BI. The data used in the video is world population data downloaded from the World Bank, which is already pivoted, but not in the form of an Excel pivot table. The speaker ...

Power BI: Mastering Marketing Campaign Insights with Power BI - A Step-by-Step Guide

This video is a tutorial on how to analyze marketing campaign insight data using Power BI. The narrator explains that marketing campaign insight refers to the knowledge gained through analyzing data related to a marketing campaign, and how this knowledge c...

Power BI: Analyzing Warehouse and Retail Sales Data with Power BI

In this informative and practical YouTube video, viewers are guided through the process of using Power BI to analyze warehouse and retail sales data that is available online. The video begins by providing a link to the data and instructs viewers to downloa...

Power BI: Manage and Monitor Projects in Power BI Using Dashboards and Gantt Charts

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 d...

Power BI: Analyzing Murder Motives in India

The video tutorial discusses how to analyze murder motives in India using data that is available online. The tutorial provides a link to download the data and instructs viewers to load the data into Power BI using the "get data" feature. Once the data is l...

Power BI:Â Correlation Analysis of Sales and Marketing Data to Identify Most Effective Method

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 elec...

Power BI: Create a YouTube Channel Statistics Dashboard Using YouTube Feeds (No API Key Required)

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 an...

Power BI: How to Use Bookmarks for Easy Navigation in Power BI (Tutorial)

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 intr...

Power BI:Â Displaying Realtime information in Power BI Dashboard using SQL Server

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 displa...

Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

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...

Power BI: Using Conditional Formatting in Power BI including Web URLs and Sparklines

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 c...

Power BI: Displaying Live System Performance using Power BI, SQL and Python

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...

Power BI: Creating a Project Cashflows Dashboard to help Management Make Informed Decision

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. Th...

Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI

The video is a tutorial on how to simulate real-time performance monitoring of a call center using Python, Microsoft SQL Server, and Power BI. The video starts by explaining that the simulation will generate random calls from customers and store the call c...

Power BI: Creating Pareto Charts in MS Excel and Power BI to analyze reasons by percentages

The video is a tutorial on how to use Pareto Charts in MS Excel and Power BI to analyze a hypothetical problem. The problem that is being analyzed is the reasons why people are late to their office. The video explains that a Pareto chart is a combination o...

Power BI: Setting up Power BI Report Server, Uploading Reports, LAN & Internet Access, & Embedding

The video explains the process of installing and running a Power BI Report Server from a virtual machine. The video recommends running the Report Server from a virtual machine for better security. The video then explains the process of downloading and inst...

Power BI: Creating Data Source and Data Set in Power BI Report Server Using Microsoft Report Builder

This video tutorial explains how to create a simple dataset in Power BI Report Server. The tutorial covers the steps required to create a new folder, to place the dataset. The next step is to download and install Microsoft Report Builder. The tutorial show...

Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server

This video is a tutorial on how to create a KPI (Key Performance Indicator) using SQL Server Database. The video starts with an introduction to KPI and its importance in evaluating progress towards measurable goals. Then the video demonstrates the steps to...

Power BI: Creating Paginated Reports in Power BI Report Server, using SQL Server Database

This video tutorial is about creating paginated reports using SQL Server database in Power BI. Paginated reports are designed to be printed or shared, and are formatted to fit well on a page. They display all the data in a table, even if the table spans mu...

Power BI: Creating your first Python Visual in Power BI Desktop

This video tutorial explains how to install Python and connect it to Power BI Desktop to create Python visuals. It starts by demonstrating how to download and install Python using a customized installation method in the C drive. After installation, you may...

Power BI: Analyzing Seasonality in Data, and Predicting Future Data using Seasonality

The video is a tutorial for creating a dashboard that explains seasonality and predicts future sales for a business based on their monthly sales data from 2010 to 2022. The video starts by introducing the data and showing charts of individual years that de...

Power BI: Realtime Plant Simulation using SQL Server and Power BI Dashboard

This is a tutorial video on how to create a simulation for real-time data connectivity and visualization using Power BI and SQL Server. The video is presented by a trainer who takes the viewer through the process step-by-step. The video starts by explaini...

Power BI: Visualizing Basic Statistics in Power BI, Using Python Script

In this video, the presenter demonstrates how to calculate basic statistics using Python script in Power BI and create a dashboard from those statistics using Power BI visuals. The video starts with importing the Pandas library and reading data from an Exc...

Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source

This video is a tutorial on how to use SQL query inside a Python script to extract data from a CSV file or any other data source, instead of using Power Query in Power BI Desktop. The video is divided into several sections. The first section explains that...

Power BI: Loading Data into Power BI through Data Entry, without Using an External Data Source

The video is a tutorial on how to create a dashboard using the Enter Data feature in Power BI Desktop. The narrator explains that they will not be importing data from an external source, but instead, they will enter the data directly into Power BI Desktop ...

Power BI: Displaying Audit Findings, Observations, Results, Redressals, Actions and Audit Progress

The video tutorial is a step-by-step guide on how to create a dashboard on audit findings using Microsoft Power BI Desktop. The data used in the tutorial is an Excel file containing audit data of a food chain in 2022, which includes audit periods, start an...

Tableau: Tutorial for Beginners, Installing Tableau & Creating Your First Sheet, Dashboard & Story.

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 ...

Python: Easiest way to download, install/setup and use python (WinPython Tutorial)

Today we will show you how to download, install and use WinPython which is the most easy and portable version of python to install and setup on any PC. Download: https://winpython.github.io/ https://virtual-school.org/tutorial?v=9-WdyGyaNsg...

Python: How to use World Bank API (WBGAPI) and Pandas to import data, and draw charts (Tutorial)

In this video tutorial we will teach you how to use World Bank API (WBGAPI) to import data and statistics into python and create charts using Pandas library. https://virtual-school.org/tutorial?v=ri_RLKU7EAQ...

Python: Data Scraping from web using Selenium, WebDriver and XPath (Tutorial)

In this video tutorial we will show you how to install Selenium, WebDriver-Manager and how to use them to get/scrape information from websites using html elements' XPaths. Used for data scraping. #datascraping #selenium #webdriver #python https://virtua...

Python: How to work with SQL server database and queries in Python using pyodbc (Tutorial)

In this video tutorial we will show you how to: - Connect Python with SQL Server - Create tables using pyodbc - Using SQL commands in python - Displaying SQL table data in charts using matplotlib.pyplot #python #sql #pyodbc #pyplot #matplotlib #pyodbc.con...

Python: How to work with pandas, create, manage and visualize dataframes (Tutorial)

In this video tutorial we will show you how to: - Work with Pandas library - Create data frames (DataFrame) - Combine data frames - Pivot data frames - Unpivot data frames (melt) - Visualize data frames (plot) https://virtual-school.org/tutorial?v=mUzXG_...

Python: How to create and train a neural network machine learning model using sklearn/scikit-learn

Today we will show you how to create and train a neural network machine learning model using sklearn/sci-kit learn. We will use MLP Regressor (Multi-layer Perceptron Regressor) as model, RELU (rectified linear unit) for activation, LBFGS (Limited-memory BF...

Python: How to perform loops (for/while/nested) in python (Tutorial)

Today we will show you how to perform loops in python. In python, loops can be performed through for loops, or while loops. Loops can also per performed within other loops. These are called nested loops. Loops can be performed on lists, arrays, ranges, etc...

Python: Support Vector Machine for Classification (Tutorial)

In this tutorial, we will show you how to: - Read a csv file using Pandas library - Create and train a Support Vector Machine (SVM) - Use Principal component analysis (PCA) to compress dataframe - Predict #Iris dataset using Support Vector Classification...

Python: Web Scraping using Pandas, How to import HTML table from Wikipedia (Tutorial)

In this video, we will show you how to: - Import html table into python dataframe using Pandas - Select appropriate columns from datagrame - Draw a pie chart using matplotlib.pyplot #webscraping #html #padas #python #matplotlib #pyplot #piechart https:/...

Python: Machine Learning, Classification using Nearest Centroid Classifier (Tutorial)

In this tutorial, we will show you how to: - Read a csv file using Pandas library - Create and train a Nearest Centroid Classifier sklearn.neighbors - Use Principal component analysis (PCA) to compress dataframe - Predict #Iris dataset using Nearest Centr...

Python: How to classify data using K Nearest Neighbors, Neighborhood Components Analysis and Pipline

In this video we will show you how to: - Extract data from CSV into a python dataframe using Pandas - Use Neighborhood Components Analysis (NCA) - Use K Neighbors Classifier (K Nearest Neighbors) - Use sklearn.pipeline for classification and prediction We ...

Python: How to save, reload and reuse a machine learning model in Python (Tutorial)

In this tutorial we will show you how to: - Read a csv file using pandas - Split training and testing data using sklearn - Create, train and test a neural network model (MLPRegressor) - Save, Load and Re-use a model using joblib - Plot error and prediction...

Python: Why you should not trust a stocks prediction model.

In this video we will demonstrate how a model predicting stock exchange data can be all wrong even though it predicts same patterns or scores over 90%. The reason I made this video is because I have seen similar videos online telling people how to predict ...

Python: Expected Returns (Finance/Risk Management) using PyPortfolioOpt

Today we will calculate expected returns from historical data. We will calculate Mean historical return, Exponential Moving Average (EMA) historical return, and historical return using Capital Asset Pricing Model (CAPM). We will also calculate Variance, St...

Python: Creating a GUI based application (calculator) in Python using tkinter (Tutorial)

In this video we will demonstrate python GUI application development using the tkinter library. We will create a basic calculator with buttons and display. Since the code is larger than usual, we have shared it via google drive: https://drive.google.com/fi...

Python: Predicting absenteeism at work, using simplest model (Tutorial)

Today we will attempt to predict absenteeism at work, machine learning dataset. Dataset can be downloaded from https://archive.ics.uci.edu/ml/datasets/Absenteeism+at+work #python #machinelearning #absenteeismfromwork #randomforest https://virtual-school...

Python: Unleashing the Power of Statistics in Python: A Hands-On Guide

The video explains how to calculate basic statistics in Python. It covers the steps involved in importing libraries for statistical calculations, generating a list of random numbers, plotting the data on charts, calculating mean, median, mode, standard dev...

Power BI: Displaying Live System Performance using Power BI, SQL and Python

Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI

Power BI: Creating your first Python Visual in Power BI Desktop

Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source

Power BI: Displaying SQL Database Usage Information retrieved through Python Script from SQL Server.

In this YouTube video, we will learn how to create a dashboard that displays the space usage of a SQL Server database using Python. This exercise was done based on a request by one of our users in the comment section. We hope we were able to give you some ...

Python: Performing basic Statistical Analysis in Google Colab using Excel file in Google Drive

In this Python tutorial, we will explore how to access an Excel file stored in Google Drive using Google Colab and perform basic statistical analysis on the data. To begin, we will open the Excel file in Google Sheets and then import it into Python for an...

Python: Mastering Data Visualization with PyPlot Library in 12 Minutes

In this tutorial, we will learn how to create charts in Python using the PyPlot library. We will be using Google Colab for Python programming. To begin, open Google Drive and create a new notebook by clicking on the "New" button. From the options, select ...

Python: Creating Polynomial Regression Line, using sklearn Library in Google Colab

Welcome to another Python tutorial where we will learn how to create a polynomial regression line using the scikit-learn library. Polynomial regression is a type of linear regression that enables us to model non-linear relationships between variables. In ...

Python: Uploading Files Directly From Your PC into Google Colab, and Creating Charts.

Python Notebook: https://colab.research.google.com/drive/1cyrpCWUU5KmixQf6lBjTjdzQgXDA078e?usp=sharing CSV file: https://drive.google.com/file/d/1wKHLmXVQG_0nV7gImV-KfcgfW7QoepkB/view?usp=sharing By Me A Coffe: https://www.buymeacoffee.com/ViSIT In this t...

Python: Mastering NumPy Library, by Performing Sales Analysis

Welcome to our YouTube channel! In today's tutorial, we're delving into the world of Python programming with a focus on the indispensable NumPy library. NumPy stands out as one of the most widely used Python libraries, serving as a fundamental package for ...

MS Excel: Pivot Tables, Pivot Charts Filters and Slicers (Tutorial)

In this video tutorial we will show you how to create pivot tables and pivot charts. How to use slicers, filters, computed/calculated fields and items, designs etc. https://virtual-school.org/tutorial?v=wRaNDrBxXOw...

Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)

In this video, we will show you how to use lookup functions, and what is the difference between various lookup functions provided by MS Excel. #vlookup #vlookupformula #vlookupinexcel #vlookupfunction #xlookup #hlookup https://virtual-school.org/tutorial...

Excel: Using the Fill Features

In this video, we will show you how to use the fill features in MS Excel. These features allow you to quickly fill a range of cells with a series of data or a repeated value. This can be especially useful, when you need to enter a large number of similar v...

MS Excel: Pivot... Pivot... Pivot...

When an advanced user sees a beginner creating manual tables which are messy and useless....

Excel: Mapping, Grouping and Summarizing data in MS Excel (Tutorial)

The video is showing how to use the mapping technique in Microsoft Excel to summarize data. The data being used is a large set of sales from January 1st, 2018 to December 31st, 2018, of various grocery items. The goal is to create a table that shows the to...

MS Excel: Conditional Formatting Explained

Conditional formatting in Microsoft Excel is a useful tool for highlighting and visualizing data based on specified conditions. There are several predefined rules, such as "Greater Than", "Less Than", "Between", "Equal To", "Text That Contains", "A Date Oc...

MS Excel: Creating a Bell Curve in Microsoft Excel: A Step-by-Step Tutorial

In this video, the steps to create a bell curve using Microsoft Excel are demonstrated. A column named "Data" is created. 500 random values are generated between 100 and 200 using the "RANDBETWEEN" formula and entered into the "Data" column. The mean and ...

MS Excel: Predicting Sales with Linear and Non-Linear Demand Curve Models (Tutorial)

In this video, the presenter is discussing how to predict sales or demand through linear and non-linear prediction models based on the demand curve. The demand curve is a graphical representation of the relationship between the price of a good or service a...

MS Excel: Using the Break-Even Decision Model to Determine the Optimal Production Method

The video explains how to design a break-even decision model in Microsoft Excel to determine whether it is more cost-effective to manufacture a product or outsource it. The model is created by comparing the total costs associated with both manufacturing an...

MS Excel/Power BI: Unpivoting and Properly Pivoting Data in MS Excel and Power BI

MS Excel: What lies beneath an Excel file?

MS Excel files are containers (like compressed folders) that contain several XML files with data that you see in MS Excel spread sheets. You can view the raw XML files by opening Excel files as zip or rar files in any compression utility. https://virtual-...

MS Excel: How to add serial numbers to identical items without sorting the data.

Today we will show you how to add serial numbers to identical items without sorting the data, using the countifs function. https://virtual-school.org/tutorial?v=-xWiipaOLy4...

MS Excel: Creating 3D Maps and Tours in Microsoft Excel with Picture Backgrounds

This video is a tutorial on how to create a 3D map using Microsoft Excel. The presenter begins by stating that the information will be presented using Microsoft Excel 3D maps, and a picture background map will be used to display sensor data. The video pro...

MS Excel: Creating an Animated GPS Route on a 3D Map Using MS Excel

The video is a tutorial that guides the viewer through the process of creating an animated GPS route on a 3D map using Microsoft Excel. The presenter explains that to design this visualization, three columns are required: GPS coordinates in latitude and lo...

MS Excel: Using What If Analysis to Forecast Profits Based on Sales Values in Excel (File in Link)

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 cr...

MS Excel: Using Excel Slicers to Filter Data Quickly and Easily

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 demo...

Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

MS Excel: How to Create Relational Data Models, and use them in Pivot Tables and Charts

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 betwe...

Power BI: Creating Pareto Charts in MS Excel and Power BI to analyze reasons by percentages

MS Excel: Create a Smart, Dynamic, Personal Accounts Manager using Pivot Tables and Charts

Link to the file: https://docs.google.com/spreadsheets/d/1zSxV65zkUpGfgHquEeQqM6icKqZTsy8z/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true This video is a tutorial that explains how to create a smart, dynamic personal accounts manager using...

MS Excel:Â How to Use Calculated Fields and Items in Pivot Tables - A Tutorial for Excel Users

In this video, we will explore the important features of pivot tables, called calculated fields and calculated items. These features add calculated rows and columns, from existing rows and columns, in the pivot table. We will create a pivot table from a sm...

MS Excel: Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method

In this tutorial, we'll show you how to write a large, complex, nested conditional formula in Microsoft Excel, but in a simple and understandable manner. We'll guide you through the process of adding multiple conditions using a straightforward technique th...

MS Excel:Â Calculating, Comparing, and Visualizing Simple Returns and Log Returns

Hey there, welcome to my MS Excel tutorial! In today's video, we're diving into the world of investment simulations using Microsoft Excel. I'll walk you through the process of comparing simple returns with log returns, helping you gain a better understandi...

MS Excel:Â Using Formulas like a Boss, By Using Actual Names instead of Cell References

Are you tired of using meaningless cell references in your formulas? Do you want to use proper names in your formulas, which are more meaningful, self-explanatory, and understandable? Do you want to make your formulas look more professional and unique? The...

MS Excel:Â Data Modeling and Reporting in MS Excel using Power Pivot and Pivot Tables

Official Website: https://virtual-school.org/ Forums: https://virtual-school.org/forums/ SQL Server for Practice (Adventure Works Database): https://virtual-school.org/post?t=118 SQL Server for Practice (Star Corps Database): https://virtual-school.org/po...

MS Excel: Mastering Excel Dashboards and Visualization using a Restaurant Sales Dataset.

MS Excel: Best Way to Create Dashboard using a Grid - Stocks Performance Analysis and Visualization.

MS Access: How to Create Relational Databases, Forms, Reports & Queries & Import Data from Excel.

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 ...

R: Creating Your First Pie Chart in R, A Step-by-Step Guide

This video tutorial is about creating a pie chart using the R programming language. R is a free software environment for statistical computing and graphics and is widely used for data analysis, visualization, statistical modeling, and reporting. To create...

JavaScript: How to get the System Information of Client PC (Tutorial)

Today, we will show you how to get the client's system information, using Java Script. We will use Navigator class to extract system information such as product, version, language, platform, app name etc. #javascript #html #navigator https://virtual-scho...

JavaScript: How to use onLoad event trigger in HTML and JavaScript (Tutorial)

In this video, the speaker is explaining how to use the "on load" event in JavaScript. The "on load" event is triggered when an HTML element, such as the body tag, an iFrame, an image, a link, or a style, is loaded with content from an external source. To...

JavaScript: How to use onClick event trigger in HTML and JavaScript (Tutorial)

OnCick event captures user's click on a button. We will demonstrate how to use the onClick event to trigger a buttonClicked function, using HTML and JavaScript. https://virtual-school.org/tutorial?v=jUpUuSZrO9E #onclick #javascript #html...

JavaScript: Performing Mathematical Operations in HTML using JavaScript (Tutorial)

In this video, we will show you how to perform mathematical operations in HTML, using JavaScript. There are many ways you can perform mathematical operations in JS. Using plus, minus, multiply and divide signs/operators is the most basic one. Then you can ...

JavaScript: Using the if-else Condition in JavaScript (Tutorial)

In Java Script, the if else statement is used to perform different actions based on different conditions. In this video, we will show you the structure of if-else condition statement, and its practical usage within a web page, using a drop down. https://v...

Power BI: Automating Data Loading from Online Analyzer flat files to SQL Database & BI Dashboard

This tutorial addresses the challenge of automatically loading data from an online production plant analyzer, generating flat files every five seconds, into an SQL database. The preferred method is direct storage in the SQL database, but the tutorial explo...

HTML: Complete Course for Beginners â€“ Learn HTML in 30 Minutes

JavaScript: How to get the System Information of Client PC (Tutorial)

JavaScript: How to use onLoad event trigger in HTML and JavaScript (Tutorial)

JavaScript: How to use onClick event trigger in HTML and JavaScript (Tutorial)

JavaScript: Performing Mathematical Operations in HTML using JavaScript (Tutorial)

JavaScript: Using the if-else Condition in JavaScript (Tutorial)

Power BI: Automating Data Loading from Online Analyzer flat files to SQL Database & BI Dashboard

SQL: How to create databases and tables. Use select, insert, delete, update commands etc. (Tutorial)

In this video tutorial, we will show you how to connect SQL Server Management Studio to an SQL Server, then we will create a database file, and a table (using wizard and query), then we will show you how to insert delete update and select data. How to filt...

Power BI:Â Displaying Realtime information in Power BI Dashboard using SQL Server

Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

Power BI: Displaying Live System Performance using Power BI, SQL and Python

Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI

Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server

Power BI: Creating Data Source and Data Set in Power BI Report Server Using Microsoft Report Builder

Power BI: Creating Paginated Reports in Power BI Report Server, using SQL Server Database

Power BI: Realtime Plant Simulation using SQL Server and Power BI Dashboard

Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source

Power BI: Displaying SQL Database Usage Information retrieved through Python Script from SQL Server.

Power BI: Realtime Simulation of Coin Flip Probability using SQL and Power BI

Welcome to another power b i direct query simulation. In this video, we will be flipping a coin for one million times and observing the number of heads and tails. While the probability of heads or tails in a coin flip is 50%, we will investigate if the act...

Power BI: Crafting Dynamic Animated Charts using Power BI and SQL Queries

Welcome to our tutorial where we'll guide you through the process of creating an animated bar chart using Power BI and SQL queries. In this narrative journey, we'll harness the power of SQL Server database to display world population data on an engaging ba...

Power BI: Displaying Realtime Boiler Plant Information in Power BI Dashboard using SQL Server

Welcome back to another real-time simulation video. Today, we will create a real-time simulation of a boiler plant using SQL Server to store boiler information per second and display it in a Power BI dashboard. To begin, let's start with SQL. In SQL Serve...

Power BI: Automating Data Loading from Online Analyzer flat files to SQL Database & BI Dashboard

SQL: SQL Server Reporting Services, Installing, Configuring, and Creating Reports, for Beginners

SQL: Creating Realtime Live Reports in SQL Server Reporting Services

Power BI: Real-time Data Refreshing using Auto Refresh, Power Automate and Browser Extension

Looker Studio: Setting up Public mySQL Server on your PC, and connecting it to Looker Reports

Power BI:The Clock - Episode 2 | Displaying a Clock in Power BI with Current Time using SQL & XAMPP

Looker Studio: Creating a Sales Performance Dashboard with Looker Studio and Google Sheets

This video demonstrates how to use Looker Studio to analyze the performance of a sales team. It starts by connecting a Google Sheet as a source data for the Looker Studio dashboard. Then, the presenter creates a blank report and inserts a title, a date con...

Looker Studio: Understanding the Essential Concepts and Techniques

Welcome to our tutorial on understanding the essential concepts of Looker Studio. In this tutorial, we will cover the basic concepts and techniques that are required to use Looker Studio effectively. We will begin by exploring how to connect to datasets, ...

Looker Studio: Creating Dynamic MySQL Reports for Data Visualization

Welcome to another Looker Studio tutorial. In this video, we will guide you through the process of connecting to a MySQL server using a data source and creating a report with that data. To begin, visit the Star Bakery data set page, where you can find all...

Looker Studio: Setting up Public mySQL Server on your PC, and connecting it to Looker Reports

Animate: Classic Tween in Adobe Animate, parachuting from c130 (Animation Tutorial)

In this video we will show you how to create classic tweens in Adobe Animate. Create a flying plane animation. Create a dropping parachuter animation. Create a 3d effect in the animation. Export the animation to GIF file and run independently. #adobe #ad...

Unity3d: How to create terrain, add trees & water, rotate camera, & create day night (Tutorial)

Today we will show you you how to create terrain, add trees and water, rotate camera, and create day night cycle. We will create an island with some texture and trees. Then we will add basic water. Then we will create day nigh affect and rotate camera arou...

Creating and Setting up a Virtual Machine with Windows 11

The video explains how to set up a virtual machine and install Windows 11 on it. A virtual machine is a software-based computer that provides an isolated environment for running an operating system or application. The reasons for using a virtual machine in...

Home

MS Excel

Power BI

Tableau

Looker Studio

R Language

Python

HTML/JS/CSS

MS Access

SQL

Unity 3D

Adobe Animate

Other Tutorials

Datasets

Power BI: How to install Power BI Desktop and create your first Chart (Tutorial)

Power BI: Dimensional Model Report using Adventure Works sample data. (Tutorial)

Power BI: Sales and Profit Report by Date, Country, Product and Segment (Tutorial)

Power BI: Decomposition Tree and Ribbon Chart, Sales by Year, Region, Store, Product and Sale Type

Power BI: Visualizing Stock Positions and Historical Movements, Yahoo Finance, Google (Googl) Stock

Power BI: Drill Down Report by Date, by Product, by Store Location (Tutorial)

Power BI: Artificial Intelligence (AI) (Key Influencers), Analyzing & Predicting Credit Risk

Power BI: Team and Product Performance Analysis using Power BI (Tutorial)

Power BI: Dashboards with Tooltip Pages (Tutorial)

Power BI: Bank Failure in USA (2000-2020) Dashboard

Power BI: Using Smart Narratives to add Automatic, Responsive and Dynamic Descriptions

Power BI: Using DAX (Data Analysis Expressions) to Evaluate Performance

Power BI: Drill-through Reports, analyzing regional sales data in drill through report (Tutorial)

Power BI: Crimes in Los Angeles on Power BI Dashboard (Tutorial)

Power BI: Multi Page Power BI Dashboard using Northwind Traders Database (Tutorial)

Power BI: Using Sankey Diagrams to show US Rivers data

Power BI: Analyzing Bank Loans Aging/Classification/Movement (Tutorial)

Power BI: Connecting to the World Bank Data using API (WBGAPI)

Power BI: Grouping Data in Power BI (Tutorial)

Power BI: Forecasting Data with Power BI - Forecasting the Global Temperatures (Tutorial)

Power BI: Analyzing human resource data and forecasting future hiring requirements

Power BI: Creating a Dimensional Report based on Star Schema, in Power BI (Tutorial)

Power BI: Market Basket Analysis Simplified: A Step-by-Step Guide

Power BI: Exploring Default Visuals in Power BI, A Comprehensive Guide

MS Excel/Power BI: Unpivoting and Properly Pivoting Data in MS Excel and Power BI

Power BI: Mastering Marketing Campaign Insights with Power BI - A Step-by-Step Guide

Power BI: Analyzing Warehouse and Retail Sales Data with Power BI

Power BI: Manage and Monitor Projects in Power BI Using Dashboards and Gantt Charts

Power BI: Analyzing Murder Motives in India

Power BI:Â Correlation Analysis of Sales and Marketing Data to Identify Most Effective Method

Power BI: Create a YouTube Channel Statistics Dashboard Using YouTube Feeds (No API Key Required)

Power BI: How to Use Bookmarks for Easy Navigation in Power BI (Tutorial)

Power BI:Â Displaying Realtime information in Power BI Dashboard using SQL Server

Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

Power BI: Using Conditional Formatting in Power BI including Web URLs and Sparklines

Power BI: Displaying Live System Performance using Power BI, SQL and Python

Power BI: Creating a Project Cashflows Dashboard to help Management Make Informed Decision

Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI

Power BI: Creating Pareto Charts in MS Excel and Power BI to analyze reasons by percentages

Power BI: Setting up Power BI Report Server, Uploading Reports, LAN & Internet Access, & Embedding

Power BI: Creating Data Source and Data Set in Power BI Report Server Using Microsoft Report Builder

Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server

Power BI: Creating Paginated Reports in Power BI Report Server, using SQL Server Database

Power BI: Creating your first Python Visual in Power BI Desktop

Power BI: Analyzing Seasonality in Data, and Predicting Future Data using Seasonality

Power BI: Realtime Plant Simulation using SQL Server and Power BI Dashboard

Power BI: Visualizing Basic Statistics in Power BI, Using Python Script

Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source

Power BI: Loading Data into Power BI through Data Entry, without Using an External Data Source

Power BI: Displaying Audit Findings, Observations, Results, Redressals, Actions and Audit Progress

Tableau: Tutorial for Beginners, Installing Tableau & Creating Your First Sheet, Dashboard & Story.

Python: Easiest way to download, install/setup and use python (WinPython Tutorial)

Python: How to use World Bank API (WBGAPI) and Pandas to import data, and draw charts (Tutorial)

Python: Data Scraping from web using Selenium, WebDriver and XPath (Tutorial)

Python: How to work with SQL server database and queries in Python using pyodbc (Tutorial)

Python: How to work with pandas, create, manage and visualize dataframes (Tutorial)

Python: How to create and train a neural network machine learning model using sklearn/scikit-learn

Python: How to perform loops (for/while/nested) in python (Tutorial)

Python: Support Vector Machine for Classification (Tutorial)

Python: Web Scraping using Pandas, How to import HTML table from Wikipedia (Tutorial)

Python: Machine Learning, Classification using Nearest Centroid Classifier (Tutorial)

Python: How to classify data using K Nearest Neighbors, Neighborhood Components Analysis and Pipline

Python: How to save, reload and reuse a machine learning model in Python (Tutorial)

Python: Why you should not trust a stocks prediction model.

Python: Expected Returns (Finance/Risk Management) using PyPortfolioOpt

Python: Creating a GUI based application (calculator) in Python using tkinter (Tutorial)