Advanced SQL and Power BI for Data Analyst and BI Developer

Files Included :

1 - Introduction of Analyst.mp4 (56.67 MB)
MP4
2 - SQL Server Installation.mp4 (63.83 MB)
MP4
3 - Power BI Installation.mp4 (30.39 MB)
MP4
4 - SQL Introduction and SQL Query writing.mp4 (39.11 MB)
MP4
5 - Power BI Introduction Import Data and Visualization.mp4 (203.24 MB)
MP4
39 - Extract Distinct Data.mp4 (27.04 MB)
MP4
40 - Aggregate Data with Group By.mp4 (108.82 MB)
MP4
41 - Apply Condition with Having Clause.mp4 (55 MB)
MP4
42 - Extract Data of Max Value.mp4 (28.24 MB)
MP4
43 - Extract Data of Min Value.mp4 (12.36 MB)
MP4
44 - Extract Data more than Average Value.mp4 (7.74 MB)
MP4
45 - Extract Product Name of 3rd Highest Sales.mp4 (46.82 MB)
MP4
46 - Extract Name of 3rd Smallest Salary.mp4 (18.89 MB)
MP4
47 - Introduction of Join.mp4 (7.93 MB)
MP4
48 - Inner Join.mp4 (55.52 MB)
MP4
49 - Left Join.mp4 (33.87 MB)
MP4
50 - Right Join.mp4 (32.65 MB)
MP4
51 - Full Join.mp4 (41.4 MB)
MP4
52 - Cross Join.mp4 (50.26 MB)
MP4
53 - Self Join.mp4 (113.61 MB)
MP4
54 - Union.mp4 (43.48 MB)
MP4
55 - Union ALL.mp4 (27.91 MB)
MP4
56 - Intersect.mp4 (19.73 MB)
MP4
57 - Except.mp4 (17.97 MB)
MP4
58 - Create a Conditional Field.mp4 (109.99 MB)
MP4
59 - RowNumber.mp4 (28.18 MB)
MP4
60 - Rank Function.mp4 (36.72 MB)
MP4
61 - DenseRank Function.mp4 (73.34 MB)
MP4
62 - Extract Product Name of 3rd Largest Sales.mp4 (46.82 MB)
MP4
63 - Extract Product Name of 3rd Smallest Sales.mp4 (34.81 MB)
MP4
64 - Extract Each Category Two Max Value Data.mp4 (60.95 MB)
MP4
65 - Extract Each Category Two Min Value Data.mp4 (36.45 MB)
MP4
66 - Introduction of Power BI.mp4 (25.98 MB)
MP4
67 - ETL Extract Transformation and Load.mp4 (66.48 MB)
MP4
68 - Dimension Table and Fact Table.mp4 (458.27 MB)
MP4
69 - Star Schema vs Snowflake Schema.mp4 (112.77 MB)
MP4
70 - Power Query Introduction.mp4 (89.7 MB)
MP4
71 - Data Extraction Using Import and Direct Query Mode.mp4 (85.59 MB)
MP4
72 - Manage Parameters.mp4 (186.36 MB)
MP4
73 - Dynamic Calendar Table Using Parameters.mp4 (147.75 MB)
MP4
74 - Join and Append.mp4 (204.34 MB)
MP4
75 - Index Number and Group by.mp4 (69.77 MB)
MP4
76 - Manage Delete Duplicate and Reference Option.mp4 (62.2 MB)
MP4
77 - Conditional Column.mp4 (56.32 MB)
MP4
78 - Custom Column.mp4 (46.66 MB)
MP4
79 - Choose Columns and Remove Columns.mp4 (72.52 MB)
MP4
80 - Visual Level Page Level Report Level and Drill Through Filters.mp4 (112.41 MB)
MP4
81 - Basic of Slicer.mp4 (18 MB)
MP4
82 - Sync Slicer.mp4 (157.52 MB)
MP4
83 - Edit Interactions.mp4 (33.44 MB)
MP4
6 - SQL Server Interface.mp4 (35.09 MB)
MP4
7 - Comment SQL Server Query.mp4 (10.81 MB)
MP4
8 - Server and Database.mp4 (37.43 MB)
MP4
9 - SQL Table Record Field.mp4 (90.77 MB)
MP4
84 - Basic of Tooltip.mp4 (23.35 MB)
MP4
85 - Report Tooltip.mp4 (89.82 MB)
MP4
86 - Selection Pane.mp4 (61.17 MB)
MP4
87 - Create a Report with Use of Bookmark.mp4 (95.11 MB)
MP4
88 - Reference Line for Minimum Average and Maximum Value.mp4 (136.02 MB)
MP4
89 - Conditional Formatting.mp4 (92.54 MB)
MP4
90 - One to One Relationship.mp4 (136.73 MB)
MP4
91 - Modeling in Power BI.mp4 (713.96 MB)
MP4
92 - DAX UNION INTERSECT EXCEPT.mp4 (116.76 MB)
MP4
93 - DAX ALL ALLSELECTED ALLEXCEPT.mp4 (105.81 MB)
MP4
94 - DAX CALCULATETABLE FILTER.mp4 (151.93 MB)
MP4
95 - DAX TOPN.mp4 (77 MB)
MP4
96 - Calculate Incentive with IF.mp4 (172.87 MB)
MP4
97 - Calculate Incentive with Switch.mp4 (63.35 MB)
MP4
100 - Sumx vs Calculate with Live Report Design.mp4 (83.61 MB)
MP4
101 - Countx vs Calculate with Live Report Design.mp4 (117.86 MB)
MP4
102 - Averagex vs Calculate with Live Report Design.mp4 (149.74 MB)
MP4
103 - Minx vs Calculate with Live Report Design.mp4 (49.15 MB)
MP4
104 - Maxx vs Calculate with Live Report Design.mp4 (51.47 MB)
MP4
105 - Rankx to Calculate Rank with Dynamic Report.mp4 (420.58 MB)
MP4
106 - DAX for Date Dimension Table.mp4 (92.76 MB)
MP4
107 - Design Report to Compare Current Day Vs Previous Day Sales.mp4 (174.86 MB)
MP4
108 - Design Report to Compare Current Week Vs Previous Week Sales.mp4 (318.54 MB)
MP4
109 - Design Report to Compare Current Month Vs Previous Month Sales.mp4 (91.37 MB)
MP4
110 - Design Report to Compare Current Quarter Vs Previous Quarter Sales.mp4 (100.1 MB)
MP4
111 - Design Report to Compare Current Year Vs Previous Year Sales.mp4 (82.8 MB)
MP4
112 - Design Report to Compare Current Week Vs Previous Week Sales.mp4 (318.52 MB)
MP4
113 - Current Year MTD Vs Last Year MTD.mp4 (318.01 MB)
MP4
114 - Current Year QTD Vs Last Year QTD.mp4 (156.99 MB)
MP4
115 - Current Year YTD Vs Last Year YTD.mp4 (91.49 MB)
MP4
116 - Design Report to Calculate TOPN and BottomN Sales.mp4 (220.29 MB)
MP4
98 - What is Measure Implicit and Explicit.mp4 (172.32 MB)
MP4
99 - Filter Dax to Create a Table.mp4 (92.52 MB)
MP4
117 - Card Vs Multi Row Card.mp4 (72.02 MB)
MP4
118 - Table Vs Matrix.mp4 (31.91 MB)
MP4
119 - Stacked Bar Vs Stacked Column Chart.mp4 (31.35 MB)
MP4
120 - Clustered Bar Vs Clustered Column Chart.mp4 (35.39 MB)
MP4
121 - 100 Stacked Bar Vs 100 Stacked Column Chart.mp4 (29.56 MB)
MP4
122 - Line Chart Vs Area Chart.mp4 (45.55 MB)
MP4
123 - KPI Visual.mp4 (38.07 MB)
MP4
124 - Pie Chart Vs Donut Chart.mp4 (14.71 MB)
MP4
125 - Map Vs Filled Map.mp4 (48.31 MB)
MP4
126 - Gauge Vs Funnel Chart.mp4 (39.31 MB)
MP4
127 - Restrict Report Access.mp4 (39.49 MB)
MP4
10 - Create Table.mp4 (21.1 MB)
MP4
11 - Create Table without Create Statement.mp4 (137.52 MB)
MP4
12 - Delete Table.mp4 (5.6 MB)
MP4
13 - Alter Table.mp4 (104.05 MB)
MP4
128 - Project Overview.mp4 (56.6 MB)
MP4
14 - Insert Data with Graphical User Interface.mp4 (66.46 MB)
MP4
15 - Insert Data into Table.mp4 (58.71 MB)
MP4
16 - Bulk Insert Data into Table.mp4 (135.79 MB)
MP4
17 - Import Data into Table.mp4 (30.3 MB)
MP4
18 - Export Data from Table.mp4 (36.56 MB)
MP4
19 - Define Delete Truncate and Drop.mp4 (38.55 MB)
MP4
20 - Delete Data on Condition.mp4 (43.4 MB)
MP4
21 - Delete Entire Data from Table.mp4 (10.53 MB)
MP4
22 - Drop Entire Table.mp4 (38.53 MB)
MP4
23 - Update Entire Field Data in Table.mp4 (43.86 MB)
MP4
24 - Update Data on Condition.mp4 (33.37 MB)
MP4
25 - View Data.mp4 (38.76 MB)
MP4
26 - View Distinct Data.mp4 (67.67 MB)
MP4
27 - View Filtered Data.mp4 (39.74 MB)
MP4
28 - View Filtered Data with AND Operator.mp4 (42.07 MB)
MP4
29 - View Filtered Data with OR Operator.mp4 (51.24 MB)
MP4
30 - View Filtered Data with IN Operator.mp4 (62.96 MB)
MP4
31 - View Filtered Data with BETWEEN Operator.mp4 (70.76 MB)
MP4
32 - View Filtered Data with LIKE Operator.mp4 (92.22 MB)
MP4
33 - SQL Top Clouse.mp4 (121.94 MB)
MP4
34 - View Top Data with Live Scenario.mp4 (26.48 MB)
MP4
35 - View Bottom Data with Live Scenario.mp4 (18.9 MB)
MP4
36 - Sort Data in Ascending or Descending Orders.mp4 (81.13 MB)
MP4
37 - Sort Data In Ascending Orders.mp4 (61.7 MB)
MP4
38 - Sort Data in Descending Orders.mp4 (41.55 MB)
MP4