Uploaded March 2023 | Updated November 2026, 1 day ago
Do you want to learn Tableau?
In this video, learn all the basics you need to start using Tableau straightaway. We are going to understand how to load some data, analyse it, create some charts and prepare a dashboard with Tableau.
โฌ DOWNLOAD TABLEAU PUBLIC SOFTWARE:
=====================================
Get the FREE Tableau public software from here - tableau.com/products/public/download
๐Sample Data to Pratice:
======================
The sample data I've used in the video is here ๐ chandoo.org/wp/wp-content/uploads/2023/03/sample-data-10mins.xlsx
โฑ In this video
=============
0:00 - Introduction and how to download Tableau
1:08 - Loading data into Tableau
2:07 - Creating your first visual / chart / sheet in Tableau
5:00 - Making a Top 10 salesperson chart
6:51 - How to make a dashboard with Tableau
9:32 - How to use one visual as a "filter" for other visuals in tableau?
10:29 - Adding business summary section to the dashboard (calculated fields)
13:31 - Formatting the charts & text in Tableau
14:29 - Saving and publishing your work
๐ป Business Intelligence Analysis - Other Tutorials:
==========================================
INTRODUCTIONS:
Introduction to Power BI - youtu.be/9tF1IrfLflg
Introduction to Excel - youtu.be/F7aPazuS8QY
Introduction to SQL - youtu.be/yfWcZ6eot4g
DEEP DIVES:
Power BI - youtu.be/uwe8C7K8fXY
Excel - youtu.be/v2oNWja7M2E
DAX - youtu.be/PQ5lALdFHCU
SQL - youtu.be/l8DCPaHc5TQ
Python - youtu.be/uoC48wrJ-yM
FULL COURSES:
Power BI - chandoo.org/wp/power-bi-course
Excel - chandoo.org/wp/excel-school-program
~
#tableau #dataanalytics
Do you want to learn Tableau?
In this video, learn all the basics you need to start using Tableau straightaway. We are going to understand how to load some data, analyse it, create some charts and prepare a dashboard with Tableau.
โฌ DOWNLOAD TABLEAU PUBLIC SOFTWARE:
=====================================
Get the FREE Tableau public software from here - tableau.com/products/public/download
๐Sample Data to Pratice:
======================
The sample data I've used in the video is here ๐ chandoo.org/wp/wp-content/uploads/2023/03/sample-data-10mins.xlsx
โฑ In this video
=============
0:00 - Introduction and how to download Tableau
1:08 - Loading data into Tableau
2:07 - Creating your first visual / chart / sheet in Tableau
5:00 - Making a Top 10 salesperson chart
6:51 - How to make a dashboard with Tableau
9:32 - How to use one visual as a "filter" for other visuals in tableau?
10:29 - Adding business summary section to the dashboard (calculated fields)
13:31 - Formatting the charts & text in Tableau
14:29 - Saving and publishing your work
๐ป Business Intelligence Analysis - Other Tutorials:
==========================================
INTRODUCTIONS:
Introduction to Power BI - youtu.be/9tF1IrfLflg
Introduction to Excel - youtu.be/F7aPazuS8QY
Introduction to SQL - youtu.be/yfWcZ6eot4g
DEEP DIVES:
Power BI - youtu.be/uwe8C7K8fXY
Excel - youtu.be/v2oNWja7M2E
DAX - youtu.be/PQ5lALdFHCU
SQL - youtu.be/l8DCPaHc5TQ
Python - youtu.be/uoC48wrJ-yM
FULL COURSES:
Power BI - chandoo.org/wp/power-bi-course
Excel - chandoo.org/wp/excel-school-program
~
#tableau #dataanalytics









![How to make the perfect CALENDAR TABLES ๐
in Power BI
CALENDAR Tables are a must if you want to analyze business data in Power BI. In this video, let me show you how I create my calendar tables out of thin air ๐ช
In the video โฑ
0:00 - Why you need a calendar table in Power BI?
0:26 - Using Blank Query to make calendar table
2:00 - Adding useful date columns (year, month, weekday etc.)
2:28 - Is weekend column
3:00 - Adding start of the month calculated column
3:17 - Year month column with Custom Power Query formula
4:08 - Type of the month (this month, previous month, next month, etc.)
7:10 - Loading the calendar table to Power BI
๐ Sample file & code
Get the full M code (Power Query steps) and more from here -
https://chandoo.org/wp/power-query-calendar-table-best-method/
๐บ WATCH NEXT
Using Power BI to make a dashboard
https://youtu.be/mXD0Peot4hY
How to use Power BI (10 min intro)
https://youtu.be/9tF1IrfLflg
Beginner to PRO Power BI Class
https://youtu.be/uwe8C7K8fXY
Learn Power Query in 15 minutes
https://youtu.be/UAFExySaSPY
How to create DAX measures
https://youtu.be/PQ5lALdFHCU
Star Schema in Power BI
https://youtu.be/1CgG0t59WcM
๐ฅFULL Power BI Course
https://chandoo.org/wp/power-bi-course/
๐ฉโ๐ป Power Query Script for Calendar Table
Here is the M language script. Paste this in advanced editor in Power Query ๐
~~~
let
Source = List.Dates(#date(2023,1,1),365, #duration(1,0,0,0)),
#Converted to Table = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#Renamed Columns = Table.RenameColumns(#Converted to Table,{{Column1, Date}}),
#Changed Type = Table.TransformColumnTypes(#Renamed Columns,{{Date, type date}}),
#Inserted Year = Table.AddColumn(#Changed Type, Year, each Date.Year([Date]), Int64.Type),
#Inserted Month = Table.AddColumn(#Inserted Year, Month, each Date.Month([Date]), Int64.Type),
#Inserted Month Name = Table.AddColumn(#Inserted Month, Month Name, each Date.MonthName([Date]), type text),
#Inserted Day of Week = Table.AddColumn(#Inserted Month Name, Day of Week, each Date.DayOfWeek([Date]), Int64.Type),
#Inserted Day Name = Table.AddColumn(#Inserted Day of Week, Day Name, each Date.DayOfWeekName([Date]), type text),
#Added Conditional Column = Table.AddColumn(#Inserted Day Name, Is Weekend?, each if [Day of Week] = 6 then Yes else if [Day of Week] = 0 then Yes else No),
#Inserted Start of Month = Table.AddColumn(#Added Conditional Column, Start of Month, each Date.StartOfMonth([Date]), type date),
#Added Custom = Table.AddColumn(#Inserted Start of Month, Year Month, each [Year] * 100 + [Month]),
#Added Custom1 = Table.AddColumn(#Added Custom, Current Month, each let cm = Date.StartOfMonth(DateTime.LocalNow())
in Date.Year(cm) * 100 + Date.Month(cm)),
#Inserted Subtraction = Table.AddColumn(#Added Custom1, Subtraction, each [Year Month] - [Current Month], type number),
#Added Conditional Column1 = Table.AddColumn(#Inserted Subtraction, Month Type, each if [Subtraction] = 0 then This Month else if [Subtraction] = 1 then Next Month else if [Subtraction] = -1 then Previous Month else Other Month),
#Removed Columns = Table.RemoveColumns(#Added Conditional Column1,{Current Month, Subtraction})
in
#Removed Columns
~~~
#powerquery #powerbi
~
Why did the Power BI developer never go past first date?
Because he lacked date intelligence ๐ How to make the perfect CALENDAR TABLES ๐
in Power BI](https://i.ytimg.com/vi/wN1ok8JDzrI/mqdefault.jpg)
