Data Analytics Complete course ( English)

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

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

Created byYusuf Didighar

Last updated 7/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

12 sections • 364 lectures • 53h 13m 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
Learn to split and join text in Excel with the new text split, text join, text after, and text before functions; control delimiters, ignore empty, and case sensitivity.
030. UNIQUE Function6:08
031.SORT & SORTBY Functions9:18
Master Excel's sort and sort by functions to sort data by columns, use multiple criteria with curly braces, and return array results with ascending or descending orders.
032.FILTER Functions8:09
033.SEQUENCE & RANDARRAY Functions2:27
034. VSTACK & HSTACK Functions6:31
Learn how to consolidate data from multiple sheets using vstack to stack arrays vertically and hstack to stack data horizontally, including handling non-continuous ranges, table inputs, and dynamic updates.
035. CHOOSECOLS & CHOOSEROWS Functions3:13
036.TOROW & TOCOL Functions1:45
Learn how to transform a two-row by three-column data set into a single column or a single row, using optional ignore blanks and ignore errors settings.
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
Learn to use workdays and workdays.intl in Excel to add or subtract working days, excluding weekends and holidays, with customizable weekends and holiday ranges for accurate planning.
043.DATEDIF Function6:16
Explore the Datediff function in Excel to compute exact differences between two dates in years, months, and days, using Y, M, and D parameters and concatenation.
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
Test
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
Test
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
Learn to delete rows with delete from table and a where clause, or empty the table with truncate, using a backup table, and understand how drop removes the table entirely.
25.StringFunctions-Part113:02
Explore essential SQL string functions, including upper and lower case transforms, left, right, and substring extractions, plus length and trim helpers, in a multi-part SQL lecture.
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
Learn the basics of window functions with row_number, using over, order by, and partition by to assign unique, partitioned row numbers in a sample employees table.
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
Learn how to set up a data gateway in Power BI, enable on-prem data refreshes, configure gateway connections, and manage manual and scheduled refreshes for cloud reports.

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
Explore recursion in Python by showing how a function calls itself to print numbers 1 to n, use a base case, and understand stack unwinding.

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
Explore the data quality framework 1.0 in Azure, outlining end-to-end checks across raw, bronze, and silver data with Data Factory, Databricks, and metadata governance.
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
Explore mirroring Azure SQL data in Fabric to replicate near real-time tables, build a semantic model, and create Power BI reports using Direct Lake on OneLake.
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: