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
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…
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…
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
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
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
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.
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….
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 predictions on scatter chart using pyplot #machinelearning #python…
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 Adventure Works sample data available at GitHub for this tutorial https://github.com/microsoft/powerbi-desktop-samples/blob/main/AdventureWorks%20Sales%20Sample/AdventureWorks%20Sales.xlsx…
