Data Analytics Complete course ( English)

Name: Data Analytics Complete course ( English)
Rating: 4.5 (95 reviews)

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

Created byYusuf Didighar

Last updated 5/2026

English

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
End-to-end project covering entire lifecycle

Course content

11 sections • 361 lectures • 52h 23m total length

1. Introduction To Excel5:27
2. Text Vs Number12:17
003.CellReferencing - Relative4:44
004.CellReferencing - Absolute5:08
005.CellReferencing-RowFixed7:42
006.CellReferencing-ColumnFixed2:49
007.LEFT Function4:43
008.RIGHT Function1:14
009.MID Function2:59
010.LEN Function1:43
011.TRIM Function3:00
012.FIND & SEARCH Function5:11
013.REPLACE Function4:08
014.SUBSTITUTE Function3:05
015. Scenario - Extract Names13:27
016.CustomLists3:11
017.SUM Function4:04
018.COUNT Functions3:38
019.AVERAGE Function2:13
020.MIN & SMALL Functions1:48
021.MAX & LARGE Functions1:22
022.SortData6:33
023.FilterData4:22
024.VLOOKUP Function10:12
025.HLOOKUP Function2:13
026.INDEX & MATCH Functions14:07
027.XLOOKUP Function6:06
028.Table9:29
029.TextFunctions11:44
030. UNIQUE Function6:08
031.SORT & SORTBY Functions9:18
032.FILTER Functions8:09
033.SEQUENCE & RANDARRAY Functions2:27
034. VSTACK & HSTACK Functions6:31
035. CHOOSECOLS & CHOOSEROWS Functions3:13
036.TOROW & TOCOL Functions1:45
037.IF, AND & OR Function18:24
038.SUMIF,SUMIFS..Functions12:59
039.IntroductionToDate9:14
040.EDATE & EOMONTH Functions3:09
041.NETWORKDAYS & NETWORKDAYS.INTL Functions5:20
042.WORKDAY & WORKDAY.INTL Functions2:27
043.DATEDIF Function6:16
044.WEEKNUM & WEEKDAY Functions2:51
045.IFS Function2:44
046.PivotTables18:05

1. Introduction to SQL4:34
History of SQL0:25
2. SQL Server 2025 Installation7:37
3. Create And Drop Database14:25
SQL Server Hierarchy0:35
4. System Databases2:05
5. Create and Drop Tables12:33
6. Insert Data In Table17:11
7. Select4:30
8. InstallAdventureWorksSampleDB1:47
9.GetUniqueValues9:13
10. SortData11:51
11. Comments5:09
12. SortData21:28
13. FilterWithWildCharacters10:06
14. Aggregate Function13:36
15. GroupingRows7:30
16.Select..Into6:33
17. CreateTableWithPrimaryKey14:28
18. CreateTableWithNOTNULLConstraint4:44
19. Create Table With Unique Constraint7:17
20. Create Table With Check Constraint7:51
21. Create Table With Default Constraint3:45
22. Create Table With AutoIncrement6:04
23. UpdateRowsInTable10:33
24. Delete Rows From Table7:35
25.StringFunctions-Part113:02
26. String Functions - Part 26:16
27. Scenario-CombineNames11:12
28. Scenario - Extract First And Last Names11:10
29.DateTimeFunctions-Part17:35
30. DateTimeFunctions-Part213:07
31.DateTimeFunctions-Part35:11
32-DataTypes-Part1-Integers8:22
33-DataTypes-Part2-ApproximateNumeric7:14
34-DataTypes-Part3-DateTime1:52
35-DataTypes-Part4-Strings13:38
36-DataTypes-Part5-Uniqueidentifier4:33
37. DataTypes-Part6-bit2:55
38.DataType Conversion5:48
39.Joins-Part1 – Introduction to joins16:52
40.Joins-Part2 – Using Joins8:33
41.Joins-Part3 – Join 3 tables6:14
42. Joins-Part4 – Using Expressions4:38
043.Joins-Part5 – Outer Joins4:46
44.Scenario-Joins-Part6 – Self Join4:46
45.FactAndDimensions15:51
46.IIF Function9:40
47. CASE9:40
48.IIF & CASE multiple conditions8:00
49. CustomSorting6:30
50.UNION & UNION ALL7:17
51. INTERSECT4:22
52. EXCEPT2:32
53. Foreign Key constraint13:40
54.Subquery-PART15:34
55. Subquery-PART2-Using IN & NOT IN5:27
56.Subquery-PART3-Update5:47
57.-PART4-Subquery-PART4-Derived Table4:35
58.Subquery-PART5-EXISTS, NOT EXISTS, Correlated Subquery4:35
59-Scenario-Get Percent Contribution of each year6:37
60.HAVING clause4:42
61. TOP Clause4:46
62. Scenario-Get TOP BOTTOM products4:43
63.Window Functions – PART1 – ROWNUMBER()11:07
64.Window Functions – PART2 – RANK & DENSE_RANK7:43
65.Window Functions – PART3 – LAG & LEAD5:53
66.Window Functions – PART4 – FIRST_VALUE & LAST_VALUE5:05
67.SQL Classification2:02
68-ALTER TABLE -PART 1 – Columns6:05
69-ALTER TABLE -PART 2 – Constraints7:25
70.OFFSET4:22
71. COALESCE5:46
72.MERGE13:48
73. SCHEMA12:04
74. GROUP BY WITH ROLLUP10:28
75. GROUP BY WITH CUBE3:04
76. PIVOT5:19
77. UNPIVOT4:35
78. VIEWS11:02
79.CommonTableExpression-Part1-Introduction8:55
80-CommonTableExpression-Part2-MultiPart6:28
81.CommonTableExpression-PART3-Recursion10:02
82. Variables8:32
83.IF…ELSE7:33
84.WHILE LOOP10:52
85. TempTables7:36
86. StoredProcedures13:56
87.Converting a table to JSON9:42
88. CreatingNestedJSONOutput5:42
89.OUTPUT Clause10:57
90. SlowlyChangingDimensions19:11
091. Indexes - Part 1 - ClusteredIndex19:05
092. Indexes - Part 2 - NonClusteredIndex21:56
093. Indexes - Part 3 - Theory21:57
094. Indexes - Part 4 - IndexSeek11:25

1. Find Average2:49
2.Joins Challenge6:50
3. IdentifyAndDeleteDuplicateRows9:59
4. CustomMerging13:25
5. MissingData-FindMissingDepartments8:58
6. SecondLargestSalary6:07
7. Find2ndLargestSalaryInEachDepartment2:45
8. RowNumbering2:53
9. FindAlternateRows4:53
10. Palindrome2:38
11. FindDuplicateEmails4:16
12. UpdateCorrectGender2:00
13. TransformStudentsInfo11:29
14. DefectClassification5:19
15. DailyRunningTotal5:26
16. MTD Total5:02
17. QTDTotal6:25
18. YTDTotal5:49
19. PreviousYearTotalAndYOYgrowth10:03
20. 3 Month Moving Total6:07

1. Introduction2:33
2. InstallingPOWERBIDesktop4:43
3. BuildingBlocks3:18
4. ImportDataFromExcel8:08
5. AddDateColumnsUsingPowerQuery10:37
6. AddDateColumnsUsingCalculatedColumns5:25
7. IntroductionToMeasures2:56
8. IntroductionToMeasures6:13
9. IntroductionToDAX3:04
10.CALCULATE Function15:49
11. UnderstandingRelationship8:35
12.IF Function10:44
13.SWITCH function4:07
14. RELATED & LOOKUPVALUE Functions6:22
15.PowerQuery-AppendAndCombineFiles16:38
16.PowerQuery-SourceProperties5:19
17.PowerQuery-EnterData3:35
18.PowerQuery-ManageRowsAndColumns5:29
19.PowerQuery-SplitColumn5:41
20-PowerQuery-DuplicateReferenceGroupBy4:26
21.PowerQuery-DataTypes3:43
22.PowerQuery-Headers&Replace3:01
23.PowerQuery-MergeQuery10:59
24.PowerQuery-Transpose&ReverseRows3:47
25.PowerQuery-Fill1:30
26.PowerQuery-Pivot&Unpivot4:04
27.PowerQuery-Format2:36
28.PowerQuery-Extract4:29
29.PowerQuery-Round&Info3:28
30.PowerQuery-AddColumnFromExamples3:05
31.PowerQuery-AddIndex&ConditionalColumn3:32
32.StringFunctions-UPPER,LOWER,LEFT,RIGHT,MID13:47
33.BLANK Function6:09
34.RELATEDTABLE_Function7:30
35.COUNTX_Function9:39
36.SUMX_Function8:31
37.ALL_Function11:18
38.ALLSELECTED_Function8:28
39.ALLEXCEPT_Function4:37
40.GENERATESERIES_Function2:35
41. UNICHARandUNICODE_Functions2:39
42.DISTINCTandVALUES_Functions7:09
43.RowContextAndFilterContext4:09
44.FILTER_Function8:30
45.CALENDAR_Function5:11
46.CALENDARAUTO_Function3:32
47.DATEADD_Function7:13
48.CalculatePreviousYearSales12:10
49.SAMEPERIODLASTYEAR_Function3:57
50.PARALLELPERIOD_Function8:25
51.DATESYTD,DATESQTD,DATESMTD_Functions10:25
52.TOTALYTD,TOTALQTD,TOTALMTD_Functions4:42
53.FIRSTDATEandLASTDATE_Functions3:30
54.DATESINPERIOD_Function10:21
55.DATESBETWEEN_Function6:38
56.SyncSlicers7:00
57.DrillThrough8:49
58.Hierarchy,DrillDown,DrillUp6:17
59.ConnectionModes11:48
60.IntroductionToPowerBIService9:02
61.PowerBiService-CreatingWorkspace3:28
62.PowerbiService-ManagingWorkspaceAccessAndRoles9:14
63. RowLevelSecurity6:51
64. DynamicRowLevelSecurity13:34
65.DynamicRowLevelSecurity-ManagerAccess14:34
66. CreateDashboardInPowerBiService9:25
67. 1,2,3 YearsPerformance11:49
68. Bookmarks15:19
69. ButtonNavigation6:36
70. SwapVisuals5:27
71.12MonthsTrailingPerformance17:19
72. 12MonthsTrailingPerformanceBasisSelection8:04
73. DynamicMonthsTrailingPerformance6:47
74.SUMMARIZE Function7:01
76.TOPN Function12:28
77.KEEPFILTERS Function6:41
78.REMOVEFILTERS Function6:05
79.DynamicTopBottom7:54
80.USERELATIONSHIP Function7:56
81.TREATAS Function6:48
82.FNB,LNB,FNBV,LNBV Functions14:16
83.POWER BI License Types13:02
084.Creating & Managing an App12:07
085.Setting Up DataGateway & Managing Refreshes30:53

1. IntroductionAndInstallation7:32
2. print9:55
3. Variables10:24
4. Concatenate3:45
5. Interpolation14:30
6.If..else12:05
7.Input4:44
8.IF..ELIF..ELSE5:50
9.For..Loop10:10
10.While..Loop6:01
11.Break&Continue7:13
12.Lists-Part1-Introduction&Indexing15:40
13.Lists-Part2-Len,Existences&Loop3:51
14.Lists-Part3-Add&RemoveItems10:52
15.Lists-Part4-Count,Copy,Reverse&Sort6:38
16.Lists-Part5-UpdatingLists4:03
17.Set9:03
18. Tuple3:09
19.Dictionary9:52
20. Comments4:33
21.StringOperations-Part18:46
22.StringOperations-Part210:17
23.StringOperations-Part37:52
24.ListComprehensions16:50
25. dir3:02
26.DateTime-Part1-datetimeModule11:28
27.DateTime-Part2-timedeltaANDtimestamp5:51
28.DateTime-Part3-monthdeltaModule6:54
29.DateTime-Part4-relativedeltaModule9:39
30.DateTime-Part5-Formatting6:47
31.ExceptionHandling9:58
32. None2:33
33. Random4:23
34.Functions-Part1-Introduction11:23
35.Functions-Part2-ScopeOfVariable5:39
36.Functions-Part3-Arguments14:15
37.Functions-Part4-DocStrings3:44
38.Lambda4:25
39. Map9:29
40.Reduce4:48
41. Recursion17:35

001. Data Quality12:02
002.Understanding Requirement8:23
003. PurchaseDataModel1:11
004. SalesModel2:13
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 - Part238:44
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

001.IntroductiontoFabric6:15
002.SignUpForFabricUsingPersonalEmail8:23
003.CreatingAWorkspace5:10
004.CreatingALakehouse4:16
005.LoadDataIntoLakehouse5:09
006.LoadDataFromFolder5:05
007.SqlAnalyticsEndPoint7:10
008.VisualQuery4:32
009.DefaultSemanticModel2:29
010.OneLakeExplorer4:47
011.CreatingShortcut8:02
012.UpdatingConnection2:19
013.CreatingATableUsingShortcut3:34
014.CreatingAWarehouse3:49
015.CreatingATableInWarehouse4:47
016.CopyInto2:39
017.LoadDataIntoWarehouseUsingDataPipeline13:40
018.DataSharingBetweenLakehouseAndWarehouse10:41
019.TableCloning5:40
020.IntroductionToDataflow23:52
021.IntroductionToNotebook9:51
022.SparkOptions11:23
023.Comments&SharingInNotebook4:53
024.CodeSnippets1:39
025. CopyJob-AzureSqlDb To Lakehouse Full Load15:37
026. CopyJob-AzureSqlDb To Warehouse Full Load6:32
028. Copy Job - Change Data Capture (CDC) with SCD215:06
029. Mirror Azure SQL db in Fabric12:57
030. Workspace Level Permissions10:45

Requirements

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

Description

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

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 ( English)

What you'll learn

Explore related topics

Course content

Excel46 lectures • 4hr 38min

SQL96 lectures • 13hr 25min

SQL Scenarios20 lectures • 2hr 3min

DataWarehousing7 lectures • 54min

POWER BI84 lectures • 10hr 46min

Datrabricks Introduction3 lectures • 19min

Python Programming41 lectures • 5hr 35min

Data Quality Project30 lectures • 10hr 45min

Azure4 lectures • 17min

Fabric29 lectures • 3hr 41min

Requirements

Description

Who this course is for: