Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Batch 89 - Master's In Data Science And Analytics
27 August
27 August Recording (159:30)
2nd September
2nd September Recording (159:10)
3rd September
3rd September Recording (157:28)
3rd September file
9th September
9th September Recording (157:24)
10 September
10 September Recording (152:07)
10th September File
16th September
16th September Recording (155:26)
17th September
17th September Recording (157:02)
17th September File
23rd September
23rd September Recording (156:55)
23rd September File
24th September
24th September Recording (159:34)
30th September
30th September Recording (158:34)
30th September File
1st October
1st October Recording (148:31)
1st October File
7 October
7 October recording (157:29)
7th October File
8th October
8th October Recording (152:45)
8th October File
14th October
14th October Recording (160:11)
14th October File
15th October
15th October Recording - Part 1 (66:26)
15th October - Part 2 (81:02)
21 October
21 October Recording (155:36)
21 October Files
22nd October
22nd October Recording (153:03)
22nd October File
28th October
28th October Recording (151:49)
Numpy and Pandas File
29th October
29th October Recording (152:56)
29th October File
4th November
4th November Recording (134:19)
4th November File
5th November
5th November Recording (113:55)
5th November File
5th November mpg file
18th November
18th November Recording _ Part 1 (5:51)
18th November Recording - Part 2 (130:08)
18th November File
Assignments and Solutions
21st November
Assignments and Solutions
25th November
25th November Recording (128:43)
26th November
26th November Recording (132:03)
25th and 26th November File
Assignments
2nd December
2nd December files
2nd December Recording (131:38)
3rd December
3rd December Recording (129:40)
Assignments
16th December
16th December Recording (140:36)
16th December Files
17th December
17th December Recording (136:30)
23rd December
23rd December Recording (140:59)
17th December and 23rd December Files
24th December
24th December Recording (161:30)
24th December File
Capstone project 1
30th december
30th December Recording (149:50)
31st December
31st December Recording (139:58)
30th & 31st December Assignments
6th January
6th January Recording (123:17)
6th January files
7th January
7th January Recording (11:49)
12th January
12th January Recording (97:37)
12th January File
13th January
13th January Recording (132:54)
13th January Files
14th January
14th January Recording (131:03)
14th January Files
ML test file
Assignments
20th January
20th January Recording (128:39)
21st January
21st January Recording (124:47)
20th and 21st January Files
Assignment
3rd February
3rd February Recording (163:36)
3rd February File
4th February
4th February Recording part-1 (13:22)
4th February Recording part-2 (121:35)
4th February Files
Assignments
10th February
10th February Recording (131:19)
11th February
11th February Recording (68:36)
Career Building Session 1 - 17th February
Career Building Session (86:09)
Career Building Session PPT
Career Building Session 2 - 18th February
Career Building Session (88:23)
Resumes building and Sample Interview Questions
Sample Resume
Sample Resume
Sample Interview Questions
Handy tips for Aspiring data scientist to make a resume
Company wise data science questions
What should a candidate ask in a interview
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 (7:01)
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 (7:14)
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
Placement Process
Placement Process Session (52:00)
How to Configure SSMS and SQL Server DB Power BI
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock