Data Analytics complete course (Hindi)

Name: Data Analytics complete course (Hindi)
Rating: 4.5 (184 reviews)

Learn multiple tools in data analytics stack through this course, all in one bundle!

Bestseller

Highest Rated

Created byYusuf Didighar

Last updated 7/2026

Hindi

What you'll learn

Understand and learn different tool in data analytics.
Be ready to appear for interviews and crack them easily
Become independent to maximum level in handling tasks
Understand the depth of analytics

Course content

12 sections • 366 lectures • 52h 11m total length

001. Introduction To Excel5:56
002. Text Vs Numbers14:00
003.CellReferencing-Relative5:38
004.CellReferencing-Absolute5:13
005.CellReferencing - RowFixed5:20
006.CellReferencing-ColumnFixed3:25
007.LEFT Function3:44
008.RIGHT Function1:54
009.MID Function2:44
010.LEN Function1:48
011.TRIM Function2:59
012.FIND & SEARCH Functions5:55
013.REPLACE Function4:21
014.SUBSTITUTE Function3:28
015.Scenario - Extract Names13:29
016.CustomLists4:34
017.SUM Function5:21
018.COUNT Functions4:03
019.AVERAGE Function1:57
020.MIN & SMALL Functions1:45
021.MAX & LARGE Functions1:13
022.SortData8:24
023.FilterData5:41
024.VLOOKUP Function11:28
025.HLOOKUP Function3:00
026.INDEX & MATCH Functions14:09
027.XLOOKUP Function5:58
028. Table11:01
29.TextFunction13:43
030. UNIQUE Function6:19
031.SORT & SORTBY Functions10:57
032.FILTER function7:14
034.SEQUENCE & RANDARRAY Functions3:35
034.VSTACK & HSTACK Functions5:32
035.CHOOSECOLS & CHOOSEROWS Functions3:19
036.TOCOL & TOROW Functions1:50
037.IF, AND & OR Functions16:10
38.SUMIF, SUMIFS..Functions10:53
39. IntroductiontoDate11:33
40.EDATE & EOMONTH Functions4:12
041.NETWORKDAYS & NETWORKDAYS.INTL Functions5:40
042. WORKDAY & WORKDAY.INTL Functions3:24
043.DATEDIF Function5:43
044.WEEKNUM & WEEKDAY Functions2:49
045.IFS Functions2:57
046.PivotTables17:41

1. SQL Overview6:48
History Of SQL0:25
2. SQL Server Installation8:17
3. Create And Drop Database12:45
SQL Server Hierarchy0:35
4. System Databases2:39
5.Create and Drop Tables11:34
6. Insert Data In Table13:17
7. Select4:39
8. InstallAdventureWorksSampleDB2:53
9.GetUniqueValues8:44
10. SortData11:22
11. Comments6:37
12. Filter Data17:43
13. FilterWithWildCharacters9:11
14. Aggregate Function11:21
15. GroupingRows6:02
16. Select..Into7:05
17. CreateTableWithPrimaryKey12:22
18. CreateTableWithNOTNULLConstraint6:04
19. Create Table With Unique Constraint6:52
20. Create Table With Check Constraint7:16
21. Create Table With Default Constraint3:20
22. Create Table With AutoIncrement4:38
23. UpdateRowsInTable7:31
24. Delete Rows From Table6:59
25.StringFunctions-Part111:22
26. String Functions - Part 26:55
27.Scenario-CombineNames11:38
28. Scenario - Extract First And Last Names12:10
29.DateTimeFunctions-Part16:49
30.DateTimeFunctions-Part29:53
31.DateTimeFunctions-Part35:59
32-DataTypes-Part1-Integers7:52
33-DataTypes-Part2-ApproximateNumeric5:50
34-DataTypes-Part3-DateTime1:40
35-DataTypes-Part4-Strings11:48
36-DataTypes-Part5-Uniqueidentifier4:27
37. DataTypes-Part6-bit3:10
38.DataType Conversion5:34
39.Joins-Part1 – Introduction to joins14:18
40.Joins-Part2 – Using Joins9:03
41.Joins-Part3 – Join 3 tables5:40
42. Joins-Part4 – Using Expressions4:58
043.Joins-Part5 – Outer Joins4:47
44.Scenario-Joins-Part6 – Self Join9:11
45.FactAndDimensions14:47
46.IIF Function10:56
47. CASE6:30
48.IIF & CASE multiple conditions6:28
49. CustomSorting5:23
50.UNION & UNION ALL7:33
51. INTERSECT4:22
52. EXCEPT3:04
53. Foreign Key constraint12:35
54.Subquery-PART14:47
55. Subquery-PART2-Using IN & NOT IN4:58
56.Subquery-PART3-Update5:48
57.-PART4-Subquery-PART4-Derived Table3:30
58.Subquery-PART5-EXISTS, NOT EXISTS, Correlated Subquery5:10
59-Scenario-Get Percent Contribution of each year6:26
60.HAVING clause4:04
61. TOP Clause5:14
62. Scenario-Get TOP BOTTOM products6:05
63.Window Functions – PART1 – ROWNUMBER()10:35
64.Window Functions – PART2 – RANK & DENSE_RANK9:08
65.Window Functions – PART3 – LAG & LEAD6:34
66.Window Functions – PART4 – FIRST_VALUE & LAST_VALUE4:37
67.SQL Classification2:11
68-ALTER TABLE -PART 1 – Columns6:07
69-ALTER TABLE -PART 2 – Constraints6:37
70. OFFSET4:35
71. COALESCE5:06
72. MERGE12:21
73. SCHEMA9:45
74.GROUP BY WITH ROLLUP9:30
75. GROUP BY WITH CUBE3:30
76. PIVOT4:03
77. UNPIVOT4:56
78. VIEWS10:26
79.CommonTableExpression-Part1-Introduction8:51
80-CommonTableExpression-Part2-MultiPart5:01
81.CommonTableExpression-PART3-Recursion9:41
82. Variables8:54
83.IF…ELSE6:21
84.WHILE LOOP10:02
85. TempTables7:33
86. StoredProcedures13:50
87.Converting a table to JSON9:19
88. CreatingNestedJSONOutput5:14
89.OUTPUT Clause11:43
90. SlowlyChangingDimensions22:48
091. Indexes - Part 1 - ClusteredIndex16:26
092. Indexes - Part 2 - NonClusteredIndex15:35
093. Indexes - Part 3 - Theory25:48
094. Indexes - Part 4 - IndexSeek11:29

1. Find Average2:48
2.Joins Challenge7:25
3. IdentifyAndDeleteDuplicateRows9:03
4. CustomMerging11:42
5. MissingData-FindMissingDepartments9:22
6. SecondLargestSalary7:15
7. Find2ndLargestSalaryInEachDepartment3:11
8. RowNumbering3:10
9. FindAlternateRows4:03
10. Palindrome2:57
11. FindDuplicateEmails3:52
12. UpdateCorrectGender2:20
13. TransformStudentsInfo10:38
14. DefectClassification5:45
15. DailyRunningTotal5:56
16. MTD Total5:10
17. QTDTotal6:38
18. YTDTotal5:06
19. PreviousYearTotalAndYOYgrowth8:06
20. 3 Month Moving Total4:47

1. Introduction2:36
2. InstallingPOWERBIDesktop4:37
3. BuildingBlocks4:16
4. ImportDataFromExcel8:25
5. AddDateColumnsUsingPowerQuery9:50
6. AddDateColumnsUsingCalculatedColumns5:16
7. IntroductionToMeasures3:38
8. CreatingMeasures6:11
9. IntroductionToDAX3:07
10.CALCULATE Function15:29
11. UnderstandingRelationship7:41
12.IF Function10:23
13.SWITCH function3:43
14.RELATED & LOOKUPVALUE Functions5:51
15.PowerQuery-AppendAndCombineFiles15:16
16.PowerQuery-SourceProperties4:11
17.PowerQuery-EnterData3:29
18.PowerQuery-ManageRowsAndColumns5:15
19.PowerQuery-SplitColumn5:14
20-PowerQuery-DuplicateReferenceGroupBy5:07
21.PowerQuery-DataTypes3:42
22.PowerQuery-Headers&Replace3:34
23.PowerQuery-MergeQuery9:32
24.PowerQuery-Transpose&ReverseRows3:29
25.PowerQuery-Fill1:49
26.PowerQuery-Pivot&Unpivot3:19
27.PowerQuery-Format2:42
28.PowerQuery-Extract4:13
29.PowerQuery-Round&Info3:04
30.PowerQuery-AddColumnFromExamples2:29
31.PowerQuery-AddIndex&ConditionalColumn3:23
32.StringFunctions-UPPER,LOWER,LEFT,RIGHT,MID14:08
33.BLANK Function6:07
34.RELATEDTABLE_Function5:40
35.COUNTX_Function7:50
36.SUMX_Function7:08
37.ALL_Function8:39
38.ALLSELECTED_Function6:07
39.ALLEXCEPT_Function4:04
40.GENERATESERIES_Function2:25
41.UNICHARandUNICODE_Functions2:16
42.DISTINCTandVALUES_Functions7:19
43.RowContextAndFilterContext4:23
44.FILTER_Function7:07
45. CALENDAR_Function5:10
46.CALENDARAUTO_Function2:53
47.DATEADD_Function7:13
48.CalculatePreviousYearSales9:16
49.SAMEPERIODLASTYEAR_Function3:36
50.PARALLELPERIOD_Function8:52
51.DATESYTD,DATESQTD,DATESMTD_Functions10:12
52.TOTALYTD,TOTALQTD,TOTALMTD_Functions4:39
53.FIRSTDATEandLASTDATE_Functions2:42
54.DATESINPERIOD_Function9:02
55.DATESBETWEEN_Function5:09
56.SyncSlicers5:03
57.DrillThrough6:18
58.Hierarchy,DrillDown,DrillUp5:32
59.ConnectionModes11:46
60.IntroductionToPowerBIService7:36
61.PowerBiService-CreatingWorkspace3:18
62.PowerbiService-ManagingWorkspaceAccessAndRoles7:01
63. RowLevelSecurity7:19
64. DynamicRowLevelSecurity12:40
65.DynamicRowLevelSecurity-ManagerAccess11:26
66. CreateDashboardInPowerBiService8:46
67. 1,2,3 YearsPerformance11:22
68. Bookmarks15:00
69. ButtonNavigation6:33
70. SwapVisuals5:32
71.12MonthsTrailingPerformance16:20
72. 12MonthsTrailingPerformanceBasisSelection7:30
73. DynamicMonthsTrailingPerformance5:56
74.SUMMARIZE Function7:23
76.TOPN Function10:12
77.KEEPFILTERS Function6:54
78.REMOVEFILTERS Function4:54
79.DynamicTopBottom11:25
80.USERELATIONSHIP Function8:58
81.TREATAS Function5:58
82. FNB,LNB,FNBV,LNBV Functions14:00
83.POWER BI License Types12:47
084.Creating & Managing an App12:34
085.Setting Up DataGateway & Managing Refreshes36:39

1. IntroductionAndInstallation8:05
2. print10:54
3. Variables8:26
4. Concatenate3:37
5. Interpolation14:56
6.If..else11:26
7.Input5:19
8.IF..ELIF..ELSE5:08
9.For..Loop12:00
10.While..Loop6:34
11.Break&Continue6:51
12.Lists-Part1-Introduction&Indexing15:24
13. Lists-Part2-Len,Existences&Loop4:04
14.Lists-Part3-Add&RemoveItems9:36
15.Lists-Part4-Count,Copy,Reverse&Sort6:29
16.Lists-Part5-UpdatingLists4:21
17.Set7:36
18. Tuple3:00
19.Dictionary7:03
20. Comments5:25
21.StringOperations-Part19:02
22.StringOperations-Part29:03
23.StringOperations-Part37:19
24.ListComprehensions13:57
25. dir3:01
26.DateTime-Part1-datetimeModule10:34
27.DateTime-Part2-timedeltaANDtimestamp5:49
28.DateTime-Part3-monthdeltaModule6:13
29.DateTime-Part4-relativedeltaModule8:22
30.DateTime-Part5-Formatting6:32
31.ExceptionHandling10:06
32. None2:35
33. Random3:36
34.Functions-Part1-Introduction10:56
35.Functions-Part2-ScopeOfVariable5:16
36.Functions-Part3-Arguments11:52
37.Functions-Part4-DocStrings4:21
38.Lambda4:23
39. Map8:29
40.Reduce4:53
41. Recursion16:06

001. Data Quality12:02
002.UnderstandingRequirements8:23
003.PurchaseDataModel5:21
004.SalesModel1:11
005.HRModel2:13
006.ResourceSetUp7:23
007.GettingStartedWithAzureDevops19:49
008.UnderstandingDataSource8:57
009.GetDatabricksReady37:01
010.DevelopingPurchaseNotebooks-Part135:39
011.DevelopingPurchaseNotebooks-Part226:29
012.TaskPlanning11:35
013.DevelopingPurchaseBronzeNotebooks36:05
014-FirstDemo10:15
015-DevelopingPuchaseSilverNb-Part11:02:17
016.DevelopingOtherNotebooks11:46
017.CreatingOtherAndSilverNotebooks-Part28:17
018.DevelopingSalesRawBronzeNotebook2:29
019.DevelopingSilverSalesNotebook-Part120:22
020.DevelopingSalesSilverNotebook-Part221:48
021.DevelopingHrModelNotebooks8:16
022.DevelopingWorkflows38:44
023.PowerBIDevelopmentKickOff6:29
024.-DevelopingPowerBiPurchaseReports-Part146:49
Use the attached Purchase.xlsx file to import datasets readily into POWER BI
025.BugFixing42:15
026.DevelopingPurchaseReport-Part21:02:39
IntroductionToDataQuality10:51
ProjectFlow7:24
SettingUpDataQualityInfra20:34
DevelopingRuleExecutionProcess38:07
AutomatingBugTicketing33:17

001.IntroductiontoFabric8:38
002.SignupForFabricUsingPersonalEmailAccount8:05
003.CreatingAWorkspace6:06
004.CreatingALakehouse4:15
005.LoadDataIntoLakehouse4:53
006.LoadDataFromFolder5:34
007.SqlAnalyticsEndPoint6:44
008.VisualQuery4:57
009.DefaultSemanticModel2:33
010.OneLakeExplorer4:39
011.CreateShortcut7:15
012.UpdatingConnection2:12
013.CreatingATableUsingShortcut3:51
014.CreatingAWarehouse2:37
015.CreatingATableInWarehouse4:08
016.CopyInto3:13
017.LoadDataIntoWarehouseUsingDataPipeline11:36
018.DataSharingBetweenLakehouseAndWarehouse9:15
019.TableCloning6:33
020.IntroductionToDataflow22:03
021.IntroductionToNotebook8:54
022.SparkOptions11:30
023.Comments&SharingInNotebook6:11
024.CodeSnippets2:33
025. CopyJob-AzureSqlDb To Lakehouse Full Load11:36
026. CopyJob-AzureSqlDb To Warehouse Full Load4:22
027. Copy Job - Incremental Load8:45
028. Copy Job - Change Data Capture (CDC) with SCD214:05
029. Mirror Azure SQL DB in Fabric13:08
030. Workspace Level Permissions9:21

Requirements

There are no prerequistes for this course, learn everything from scratch.

Description

Note: This is a Hindi course, same course is available in English.

This course makes it easy to learn data analytics stack now in hindi in an easy way!
This course covers multiple tools and technologies needed to become a data analyst.
The best part is there are no pre-requisites!
Anyone can enroll and learn through this course.
Our videos are simple to understand, to the point, short and yet covering everything you need.
The content we are offering in this course is immense and requires full dedication, self -discipline and daily learning to ensure a completion and to make you independent skilled professional.
We have trained 1000's of students and shaped their career and you could be the next one, join us by enrolling in the course and benefit immensely through our course offering.
You will get best of both quality and quantity!
There are no prerequisites.
All you need to do is follow the sequence in this course designed for you.

In this course you will learn below tools and technologies from scratch:

SQL : Learn structured query language in Microsoft SQL Server.
Data warehousing : Learn fundamental concepts of data warehousing.
POWER BI : Learn POWER BI in depth including concepts, reporting, DAX and Power bi service.
Databricks: Learn databricks overview, the leading data platform.
Python programming: Learn programming in python with simple way.

Who this course is for:

This course for one who is looking to transition into data analytics as well as for existing data analyst professionals.

Data Analytics complete course (Hindi)

What you'll learn

Explore related topics

Course content

Excel46 lectures • 4hr 52min

1. SQL96 lectures • 12hr 46min

2. SQL Scenarios20 lectures • 1hr 59min

3. Data warehousing7 lectures • 54min

4.POWER BI84 lectures • 10hr 10min

5. Datarbricks Introduction3 lectures • 19min

6. Python Programming41 lectures • 5hr 19min

7. Data Quality Project31 lectures • 11hr 5min

8.Azure4 lectures • 19min

9. Fabric30 lectures • 3hr 40min

Requirements

Description

Who this course is for: