Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Batch 77 - Master's In Data Science (VP)
First Section
First Lesson (131:57)
PPT
25 March
25 March (188:50)
26th March
26th March (207:02)
26th March File
1st April
1st April (191:28)
1st April and 2nd April Material
2nd April
2nd April (183:08)
Tableau Zip
2nd April File
8th April
8th April (202:13)
8th April file
9th April
9th April (187:09)
9th April file
15th April
15th April (213:03)
15th April File
16th April
16th April (180:54)
16th April File
23rd April
23rd April (181:49)
23rd April File
29th April
29th April (183:23)
29th April file
30th April
30th April (180:36)
30th April File
6thMay
6th May (191:01)
6th May File
7th May
7th May (197:45)
7th May File
13th May
13th May (198:53)
13th May File
14th May
14th May (195:00)
14th May File
20th May
20th May (161:35)
20th May File
21st May
21st May (201:28)
21st May File
27th May
27th May (177:39)
27th May File
28th May
28th May (154:05)
28th May File
11th June
11th June (190:20)
11th June File
17 June
17 June Recording (100:17)
18th June
18th June (195:18)
18th June File
24th June
24th June recording (179:41)
24th June File
25th June
25th June (157:39)
25th June File
1st July
1st July Recording (176:51)
2nd July
2nd July Recording (200:12)
1st and 2nd July Files
8th July
8th July Recording (223:11)
9th July
9th July Recording (207:19)
9th July File
15th July
15th July Recording (225:26)
15th July File
16th July
16th July Recording (188:49)
22nd July
22nd July Recording (211:47)
23rd July
23rd July Recording (208:26)
22nd and 23rd July Files
29th July
29th July Recording (192:05)
30th July
30th July Recording (184:13)
29th and 30th July Files
5th August
5th August 1st Session Recording (170:07)
5th August 2nd Session Recording (195:22)
5th August Files
6th August
6th August Recording (179:12)
6th August Files
12 August
12 August Recording (206:24)
12 August Files.zip
13 August
13 August Recording (202:37)
13th August Files
26th August
26th August Recording (196:10)
26th August File
27th August
27th August Recording (175:21)
27th August file
2nd September
2nd September Recording (203:12)
2nd September File
3rd September
3rd September Recording (197:30)
3rd September File
Getting Started
What is PowerBi ? (9:20)
PowerBi Desktop Installation (5:12)
PowerBi Walkthrough (6:19)
Introduction to Database (26:50)
Introduction to Database objects (48:28)
Installing SQL Server (8:44)
Installing Sample Database (7:19)
Introduction to Relational Database - Codds Rules (52:14)
Learning ER Diagram (42:17)
Create Tables and Insert using SQL Server (26:24)
Reading content from the Database (51:14)
Introduction to OLAP Database (14:55)
Schema Modelling - Star vs Snowflake (29:55)
Connecting to Data
How to Configure SSMS and SQL Server DB Power BI (48:15)
Connecting to CSV (7:19)
Practice with CSV file (7:52)
Connecting to Excel File with Data (9:22)
Connecting to Hidden Sheet in Excel (3:36)
Connecting with Excel sheet with blank columns (4:00)
Read password protected excel file (3:04)
Read formula from Excel (6:39)
Practice with Excel Data (12:12)
Connecting to Folder of Data (6:22)
Practice with Folder Data (10:57)
Getting Data from Web (4:36)
Web Data Practice (21:03)
Overview of Connecting to SQL Server (6:23)
Connecting to SQL Server and Understanding the data (12:12)
Creating and Importing SQL Views using Import (12:23)
Reading using SQL Query (6:38)
Connecting to ESPN CricInfo (4:26)
Connecting to MYSQL DB (5:34)
Connecting to SQLITE DB (5:17)
Connecting to Wikipedia (3:26)
Include or Exclude part of Visualization (2:20)
Creating Visuals
Line Chart (6:22)
Stacked Bar Chart (4:49)
100 pc Stacked Bar Chart (4:54)
Pie Chart (5:24)
Donut Chart (3:56)
Area Chart (6:04)
Stacked Area Chart (4:23)
Line and Stack Chart (5:48)
Line and Clustered Chart (2:45)
Waterfall Model (7:11)
Key Influencer Chart (6:56)
Funnel Chart (6:28)
Gauge Chart (4:50)
Ribbon Chart (7:24)
Card KPI (4:07)
Sankey Chart (6:30)
Scatter Chart (7:34)
Indicator KPI (6:01)
Bow Tie Chart (7:38)
Tree Map (5:17)
Advance Infographic (7:23)
How to change Aggregation or Calculation type (6:29)
How to create matrix or pivot chart (4:10)
Table Chart (5:12)
Animated Bar Race Chart (7:13)
Bullet Chart (6:38)
Tree Based Custom Visualization (5:45)
World Cloud Visualization (5:10)
Tornado Chart (6:24)
Visual For Natural Language Processing (5:34)
Show or Hide Visualization on Dash board (3:12)
Data Wrangling
Relative Date Filter Tutorial for selecting Previous and Period Range (3:27)
Create a new custom PowerBi table (3:11)
Create a summarized table from existing table (3:31)
Mini Project Connect clean and Model Data (15:50)
Create a new measure PowerBi to keep all measures at one place (4:03)
PowerBi Advance Date Filtering Tutorial with Example (6:21)
Create a new table in PowerBi from existing table based on filter conditions (3:55)
Drill through Filter Tutorial with example to connect pages (7:43)
Create and Use PowerBi Hierarchy (3:56)
Numeric Field Formatting and Conditional Formatting (5:13)
Totals and Sub Totals in Matrix or Pivot Table (4:22)
Visual vs Page vs Page All Filters (3:42)
Changing or Formatting Slicer (6:30)
How to create PowerBi Text Slicer (7:26)
How to create Date Slicer (7:45)
DAX FORMULAE
Dax Introduction (5:19)
Discussion on DAX funtions (14:02)
DAX Example (4:16)
DAX Calculated Column (14:17)
Find Values for Every Last Day of the Year (4:23)
DAX Function DATESINPERIOD (4:08)
DAX Function ClosingBalanceQuarter to find the value at the last day of Quarter (3:03)
DAX Function ClosingBalanceYear to capture on the last day of the year (3:07)
DAX Function DatesMTD and Calculation for running month to date cumulative values (3:37)
DAX Function DatesQTD and calculating for running quarter to date cumulative values (3:27)
DAX Time Intellingence Date Add Function Calculation to get Historical and Future Values (9:37)
DAX Function DatesYTD and Calculation for running year to date cumulative values (3:35)
DAX Time Intelligence Date Function to calculate values between two dates (4:04)
Time Intelligence Dax Function to find the value on last day of the month (3:53)
End to end Visualization
Visualization 1 - Big Picture (54:38)
Working with Call Center Data (49:23)
Sales Insights Performance Dashboard (27:46)
Data Quality Analysis (34:56)
Customer Ageing Analysis (26:30)
Customer Ageing
V4 KPI List
Career Building Session and Placement Assistance
Career Building Session and Placement Assistance
Career Building Sessions
Career Building Session - 9th September (117:36)
Career Building Session - 10th September (86:14)
Resumes building and Sample Interview Questions
Sample Resumee
Sample Resumee
Sample Interview Question
Handy Tips for Aspiring Data Scientist to make a resume
Company wise Data Science Question
What should a candidate ask in an interview
DAX Function ClosingBalanceQuarter to find the value at the last day of Quarter
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock