Uploaded March 2026 | Updated November 2026, 2 hours ago
If you install SQL Server on your computer, you can learn how to build queries, ETL, Power BI reports better. In this video, let me show you the easy process for setting up "FREE" SQL Server instance on your computer, set up SSMS and load sample data to practice querying, database skills and Power BI connections.
πImportant Links (to download software)
SQL Sever Express Software - microsoft.com/en-nz/sql-server/sql-server-downloads
SSMS Software: learn.microsoft.com/en-us/ssms/install/modify
Sample Data: github.com/chandoo-org/SQL/tree/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac
π Video topics:
0:00 - Why have SQL Server on your computer
0:20 - Download SQL Server 2022 Express
0:53 - SQL Server Installation Centre - Installation process
3:18 - Adding SSMS (SQL Server Management Studio)
4:35 - Launching SSMS and connecting to local instance of SQL Server
5:40 - Adding a "new" local database and importing sample data
8:16 - closing remarks
π Sample data:
Download sample CSV (flat file) data to load up in your SQL Server
Geo - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/geo.csv
People - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/people.csv
Products - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/products.csv
Shipment data - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/sales-data-2025.csv
π©βπ»π§βπ» Next Steps:
Learn SQL in one-hour youtu.be/l8DCPaHc5TQ
Learn SQL Basics in 10 mins youtu.be/yfWcZ6eot4g
Advanced SQL Concepts youtu.be/Ejxam_CBY9U
SQL Interview Questions youtu.be/Lb3vfuew7Gk
#sql
If you install SQL Server on your computer, you can learn how to build queries, ETL, Power BI reports better. In this video, let me show you the easy process for setting up "FREE" SQL Server instance on your computer, set up SSMS and load sample data to practice querying, database skills and Power BI connections.
πImportant Links (to download software)
SQL Sever Express Software - microsoft.com/en-nz/sql-server/sql-server-downloads
SSMS Software: learn.microsoft.com/en-us/ssms/install/modify
Sample Data: github.com/chandoo-org/SQL/tree/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac
π Video topics:
0:00 - Why have SQL Server on your computer
0:20 - Download SQL Server 2022 Express
0:53 - SQL Server Installation Centre - Installation process
3:18 - Adding SSMS (SQL Server Management Studio)
4:35 - Launching SSMS and connecting to local instance of SQL Server
5:40 - Adding a "new" local database and importing sample data
8:16 - closing remarks
π Sample data:
Download sample CSV (flat file) data to load up in your SQL Server
Geo - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/geo.csv
People - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/people.csv
Products - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/products.csv
Shipment data - github.com/chandoo-org/SQL/blob/92ff7e0f6f12b0d78365df746dcc42bf26c89675/sample%20data/ac/sales-data-2025.csv
π©βπ»π§βπ» Next Steps:
Learn SQL in one-hour youtu.be/l8DCPaHc5TQ
Learn SQL Basics in 10 mins youtu.be/yfWcZ6eot4g
Advanced SQL Concepts youtu.be/Ejxam_CBY9U
SQL Interview Questions youtu.be/Lb3vfuew7Gk
#sql



![Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]
Its hot π₯΅ its coldπ₯Ά, its just a dashboard that is bold
In this video, let me share 3 powerful and amazing ways to create heatmaps in Excel. We can use them to visualize matrix (pivot) style data for dashboards or MIS reports.
In the video:
0:00 - Introduction to Excel Heatmaps
0:24 - Heatmap 1 using Conditional Formatting
3:16 - Heatmap 2 using Images in Cell
9:34 - Heatmap 3 using bubble chart in Excel
15:29 - In conclusion
You will also learn how to use new PIVOTBY function in the video.
Sample file: https://chandoo.org/wp/wp-content/uploads/2026/08/heatmap-3-ways-demo.xlsx
Related videos:
Map chart in Excel - https://youtu.be/qNNn5uiZxOE
Variance chart in Excel - https://youtu.be/REpNnsdHxlY
Dynamic chart with Check boxes - https://youtu.be/L3WFN0bGv8I
How to add avg. line to Excel charts - https://youtu.be/S2RRGqR_MNw
#Excel #dashboards #dataanalytics Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]](https://i.ytimg.com/vi/Q3oqqYQz2gM/mqdefault.jpg)






