Virtual School – Page 21

Team and Product Performance Analysis using Power BI

Admin2 years ago2 months ago01 mins

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 products/categories. The excel file used for the data can be accessed at: https://docs.google.com/spreadsheets/d/1105HJYAt6hzP4tfY-t6W3Sf3ZDw6HRQ8/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true…

Lookup Functions, VLookup, HLookup, XLookup and Lookup

Admin2 years ago2 months ago01 mins

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

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

Admin2 years ago2 months ago01 mins

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 this tutorial can be downloaded from https://www.kaggle.com/datasets/laotse/credit-risk-dataset #AI #creditrisk #keyinfluencers #ai

Drill Down Report by Date, by Product, by Store Location

Admin2 years ago2 months ago01 mins

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 (location, category, product name). Sample data used in this report…

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

Admin2 years ago2 months ago01 mins

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/file/d/1FUqpX8SYGNPoeH79QANb4jpPJi91wEPA/view?usp=sharing #pythongui #pythonguitutorial #python #tkinter #tkintertutorial 1. Creating screen/textbox: https://youtu.be/h_3jhD4SQfs?t=90 2. Creating tags to justify text to…

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

Admin2 years ago2 months ago01 mins

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.) for this excercise. #powerbi #stockmarket #yahoofinance #googl

Expected Returns (Finance/Risk Management) using PyPortfolioOpt

Admin2 years ago2 months ago01 mins

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, Standard Deviation and Correlation using Statistics library. #expectedreturn #stockmarket #exponentialmovingaverage #capm #variance #standarddeviation #correlation #pypfopt

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

Admin2 years ago2 months ago01 mins

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, Store, Product and Sale Type. #powerbi #decompositiontree #ribbonchart

Sales and Profit Report by Date, Country, Product and Segment

Admin2 years ago2 months ago01 mins

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

Why you should not trust a stocks prediction model

Admin2 years ago2 months ago01 mins

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 stocks movements through Machine Learning using only historical data….