Home
Home
Recent Tutorials
All Tutorials
All Topics
Youtube
Facebook
Forums
Spreadsheets
MS Excel
MS Excel: Pivot Tables, Pivot Charts Filters and Slicers (Tutorial)
Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)
Excel: Using the Fill Features
MS Excel: Pivot... Pivot... Pivot...
Excel: Mapping, Grouping and Summarizing data in MS Excel (Tutorial)
MS Excel: Conditional Formatting Explained
MS Excel: Creating a Bell Curve in Microsoft Excel: A Step-by-Step Tutorial
MS Excel: Predicting Sales with Linear and Non-Linear Demand Curve Models (Tutorial)
MS Excel: Using the Break-Even Decision Model to Determine the Optimal Production Method
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: How to add serial numbers to identical items without sorting the data.
MS Excel: Creating 3D Maps and Tours in Microsoft Excel with Picture Backgrounds
MS Excel: Creating an Animated GPS Route on a 3D Map Using MS Excel
MS Excel: Using What If Analysis to Forecast Profits Based on Sales Values in Excel (File in Link)
MS Excel: Using Excel Slicers to Filter Data Quickly and Easily
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
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
MS Excel:Â How to Use Calculated Fields and Items in Pivot Tables - A Tutorial for Excel Users
MS Excel: Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method
MS Excel:Â Calculating, Comparing, and Visualizing Simple Returns and Log Returns
MS Excel:Â Using Formulas like a Boss, By Using Actual Names instead of Cell References
MS Excel:Â Data Modeling and Reporting in MS Excel using Power Pivot and Pivot Tables
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.
Visualizations
Power BI
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
Tableau: Tutorial for Beginners, Installing Tableau & Creating Your First Sheet, Dashboard & Story.
Looker Studio
Looker Studio: Creating a Sales Performance Dashboard with Looker Studio and Google Sheets
Looker Studio: Understanding the Essential Concepts and Techniques
Looker Studio: Creating Dynamic MySQL Reports for Data Visualization
Looker Studio: Setting up Public mySQL Server on your PC, and connecting it to Looker Reports
R Language
R: Creating Your First Pie Chart in R, A Step-by-Step Guide
AI/ML
Python
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)
Python: Predicting absenteeism at work, using simplest model (Tutorial)
Python: Unleashing the Power of Statistics in Python: A Hands-On Guide
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.
Python: Performing basic Statistical Analysis in Google Colab using Excel file in Google Drive
Python: Mastering Data Visualization with PyPlot Library in 12 Minutes
Python: Creating Polynomial Regression Line, using sklearn Library in Google Colab
Python: Uploading Files Directly From Your PC into Google Colab, and Creating Charts.
Python: Mastering NumPy Library, by Performing Sales Analysis
HTML/JS/CSS
HTML/JS/CSS
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
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
Database
MS Access
MS Access: How to Create Relational Databases, Forms, Reports & Queries & Import Data from Excel.
SQL
SQL: How to create databases and tables. Use select, insert, delete, update commands etc. (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: 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
Power BI: Crafting Dynamic Animated Charts using Power BI and SQL Queries
Power BI: Displaying Realtime Boiler Plant Information in Power BI Dashboard using SQL Server
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
Graphics
Unity 3D
Unity3d: How to create terrain, add trees & water, rotate camera, & create day night (Tutorial)
Adobe Animate
Animate: Classic Tween in Adobe Animate, parachuting from c130 (Animation Tutorial)
Others
Other Tutorials
Creating and Setting up a Virtual Machine with Windows 11
Datasets
Adventure Works (SQL Server)
Star Corp (SQL Server)
Other SQL Datasets (SQL Server)
Star Bakery (mySQL Server)
Power BI Desktop
Introduction to Power BI Desktop
Get Data
Introduction to the Get Data feature
Get Data from Files
Power Query
Data Source Settings
Data Analysis Expression (DAX)
Getting string/text before a specific character in a new column and dealing with error in find and search
Practice Datasets
Adventure Works (SQL Server)
Star Corp (SQL Server)
Star Bakery (MySQL Server)
MS Excel
Excel Ribbon
Introduction to MS Excel Ribbon
Skip Navigation Links.
© 2023 - Virtual School of Information Technology