Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Batch 92 - DS - Morning - (SS)
5 November
5 November Recording (164:23)
5 November Files
18 November
18 November Recording (62:37)
18th Novemeber File
19th November
19th November Recording (158:23)
19th November File
25th November
25th November recording (164:25)
25th November File
25th November File
26th November
26th November Recording (157:38)
26th November File
2nd December
2nd December recording (152:47)
2nd December File
3rd December
3rd December recording (153:49)
3rd December Files
9th December
9th December Recording (151:11)
9th December File
10th December
10th December Recording (164:16)
10th December File
17th December
17th December Recording (147:00)
17th December File
23rd December
23rd December Recording (151:26)
23rd December File
24th December
24th December Recording (153:46)
24th December File
30th December
30th December Recording (151:27)
30th December File
31st December
31st December Recording (163:39)
31st December File
6th January
6th January Recording (151:52)
6th January Files
7th January
7th January Recording (155:46)
7th January File
20th January
20th January Recording (154:25)
20th January File
21st January
21st January Recording (159:14)
21st January File
27th January
27th January Recording (151:55)
27th January File
28th January
28th January Recording (161:44)
28th January File
3rd February
3rd February Recording (154:41)
3rd February File
4th February
4th February Recording (172:45)
4th February File
10th February
10th February Recording (151:31)
10th February File
11th February
11th February Recording (150:42)
11th February File
17th February
17th February Recording (149:09)
17th February Files
18th February
18th February Recording (145:05)
18th February File
2nd March
2nd March Recording (150:23)
2nd March File
3rd March
3rd March Recording (162:24)
3rd March File
9th March
9th march Recording (82:28)
9th March File
10th March
10th March Recording (146:37)
10th March File
16th March
16th March Recording (142:26)
16th March File
17th March
17th March Recording (151:30)
17th March File
23rd March
23rd March Recording (189:32)
23rd March File
30th March
30th March Recording (153:54)
30th March File
31st March
31st March Recording (142:30)
31st March File
6th April
6th April Recording (160:31)
6th April File
13th April
13th April Recording (157:03)
13th April File
14th April
14th April Recording (160:59)
14th April File
20th April
20th April Recording (156:55)
20th April File
21st April
21st April Recording (165:20)
21st April file
27th April
27th April Recording (150:33)
27th April File
28th April
28th April Recording (165:32)
28th April File
Career Building Session
Career Building Session part-1 (105:04)
Career Building Session Part-2 (100:14)
Career building session material
further process for placement assistance
further process for placement assistance (39:06)
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 (17:28)
Installing Sample Database (14:38)
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 (102:28)
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 (7:12)
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 (12:44)
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 (24:24)
Creating and Importing SQL Views using Import (12:23)
Reading using SQL Query (6:38)
Connecting to ESPN CricInfo (8:52)
Connecting to MYSQL DB (5:34)
Connecting to SQLITE DB (5:17)
Connecting to Wikipedia (3:26)
Include or Exclude part of Visualization (4:40)
Creating Visuals
Line Chart (12:44)
Stacked Bar Chart (4:49)
100 pc Stacked Bar Chart (4:54)
Pie Chart (10:48)
Donut Chart (3:56)
Area Chart (12:08)
Stacked Area Chart (4:23)
Line and Stack Chart (11:36)
Line and Clustered Chart (2:45)
Waterfall Model (7:11)
Key Influencer Chart (6:56)
Funnel Chart (12:56)
Gauge Chart (9:40)
Ribbon Chart (7:24)
Card KPI (4:07)
Sankey Chart (13:00)
Scatter Chart (7:34)
Indicator KPI (12:02)
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 (8:20)
Table Chart (5:12)
Animated Bar Race Chart (14:26)
Bullet Chart (13:16)
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 (6:22)
Create a summarized table from existing table (7:02)
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 (13:00)
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 (8:16)
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 (98:46)
Sales Insights Performance Dashboard (27:46)
Data Quality Analysis (34:56)
Customer Ageing Analysis (26:30)
Customer Ageing
V4 KPI List
Projects/Assignments
File
Overview of Connecting to SQL Server
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock