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)
MS Excel: Pivot... Pivot... Pivot...
Description
When an advanced user sees a beginner creating manual tables which are messy and useless.
Tags
excel, funny, ross galler, pivot, friends
Watch on Youtube
https://www.youtube.com/watch?v=Qkop8KCLTtQ
© 2023 - Virtual School of Information Technology