Visual Data Analyst Tutorial from Scratch

Introduction to the tutorial resources for learning visual data analyst from scratch:

Learning data analysis is not a simple thing that can be achieved overnight, but a process of continuous learning and deepening of understanding. Only through actual cases at work can we truly find the door to the palace of data analysis.

In this process, many people took many detours. Now think about it, it was actually caused by improper learning methods.

Course Catalog

1 The concept of data analysis_ok (2).mp4

2 The role of data analysis_ok (2).mp4

4 Six Steps to Data Analysis 2_ok (2).mp4

5 Three major misunderstandings of data analysis_ok (2).mp4

6 The development and career requirements of data analysts_ok (2).mp4

7 Basic Qualities of a Data Analyst_ok (2).mp4

8 EXCEL basic operations: importing external data_ok (2).mp4

10 EXCEL basic operations: protect worksheet, advanced filter_ok (2).mp4

11 Data verification_ok (2).mp4

12 Combined calculation simulation operation_ok (2).mp4

13 Merge calculation and deduplication_ok (2).mp4

14 Multiple calculations of combined calculations_ok (2).mp4

16 countif, sumif, rank functions_ok (2).mp4

17 Logical function_ok (2).mp4

18 Leap Year Determination_ok (2).mp4

19 text function_ok (2).mp4

20 vlookup function_ok (2).mp4

22 indirect function_ok (2).mp4

23 index, match function_ok (2).mp4

24 Chart introduction_ok (2).mp4

25 Simple Pivot Table Creation_ok (2).mp4

26 Slicer, schedule addition_ok (2).mp4

28 Dynamic pivot table_ok (2).mp4

29 Related pivot table_ok (2).mp4

30 Excel Advanced Programming Solution to Complete the Optimal Solution for Pharmaceutical Raw Material Ratio_ok (2).mp4

31 Excel Advanced Planning Solver Completes the Solution of Six-Variable Linear Equations_ok (2).mp4

32 Excel Advanced Planning Solver Complete Data Envelopment Analysis Decision Input-Output Ratio_ok (2).mp4

34 Excel Advanced Planning Solution Complete the Best Number Combination Best Solution Solution_ok (2).mp4

35 Excel Advanced Planning Solution to Complete the Optimal Plan for Staff Number and Shift Scheduling_ok (2).mp4

36 Excel Advanced Planning and Solving Common Problems and Solutions_ok (2).mp4

37 Introduction_ok (2).mp4

38 demand_ok (2).mp4

39 Learn to use macros_ok (2).mp4

40 Using VBA to generate salary slip in one step_ok (2).mp4

41 VBA concepts and editor introduction_ok (2).mp4

42 Case introduction_ok (2).mp4

43 Write a Helloworld program with an interface_ok (2).mp4

44 Use of variables_ok (2).mp4

46 System function usage_ok (2).mp4

47 branch statement 1_ok (2).mp4

48 branch statement 2_ok (2).mp4

49 Actual User Login Verification_ok (2).mp4

50 Excel crawling web data to build a simple website server and create a simple table page_ok (2).mp4

52 VBA programming to capture web page source code_ok (2).mp4

53 VBA programming to get the webpage table and write it into the data table_ok (2).mp4

54 Installing MySQL_ok (2).mp4

55 Use CMD to log in to mysql_ok (2).mp4

56 Database data type_ok (2).mp4

58 navicat introduction_ok (2).mp4

59 navicat create database_ok (2).mp4

60 navicat fill data_ok (2).mp4

61 Homework Introduction_ok (2).mp4

62 New database_ok (2).mp4

64 insert_into_ok (2).mp4

65 delete_from_ok (2).mp4

66 Day0605_update_ok (2).mp4

67 select_ok (2).mp4

68 where_ok (2).mp4

69 orderby_ok (2).mp4

70 groupby_ok (2).mp4

71 After-class exercises_ok (2).mp4

72 Connection query_ok (2).mp4

73 subquery_ok (2).mp4

74 stored procedure_ok (2).mp4

75 After-class exercises_ok (2).mp4

76 Project Practice: Small Commodity Purchase and Sales Management System_Project Requirements_ok (2).mp4

77 Project Practice: Small Commodity Purchase and Sales Management System_Technical Analysis_ok (2).mp4

78 Project Practice: Small Commodity Purchase and Sales Management System_Database Design_ok (2).mp4

79 Project Practice: Small Commodity Purchase and Sales Management System_Data Import into MySQL_ok (2).mp4

80 Project Practice: Small Commodity Purchase and Sales Management System_Employee Information Management_Employee Onboarding Operation_ok (2).mp4

81 Project Practice: Small Commodity Purchase and Sales Management System_Employee Information Management_Dismissal and Employee Salary Increase Operation_ok (2).mp4

82 Project Practice: Small Commodity Purchase and Sales Management System_Employee Information Management_Complex Nested Subquery Operation_ok (2).mp4

83 Project Practice: Small Commodity Purchase and Sales Management System_Employee Information Query_Realize Employee Information Statistics Analysis and Paging Query_ok (2).mp4

84 Project Practice: Small Commodity Purchase and Sales Management System_Employee Information Query_Practical Grouping, Aggregation, Filtering and Sorting_ok (2).mp4

85 Project Practice: Small Commodity Purchase and Sales Management System_Query Products with Higher Unit Price than Average_ok (2).mp4

86 Project Practice: Small Commodity Purchase and Sales Management System_Query which customers have no purchase records_ok (2).mp4

87 Project Practice: Small Commodity Purchase, Sales and Inventory Management System_Query the Product Information with the Largest Sales Quantity_ok (2).mp4

88 Project Practice: Small Commodity Purchase and Sales Management System_Query the Products with the Highest Sales_ok (2).mp4

89 Project Practice: Small Commodity Purchase and Sales Management System_Give salary increase to employees who sign the most orders_ok (2).mp4

90 Project Practice: Small Commodity Purchase and Sales Management System_Order Detailed Information Display (Complex Association Demonstration)_ok (2).mp4

91 Project Practice: Small Commodity Purchase, Sales and Inventory Management System_Query the top three customers with the largest purchase amount (multi-table association & nested subquery)_ok (2).mp4

92 Project Practice: Small Commodity Purchase and Sales Management System_Sorting Customers by Order Quantity_ok (2).mp4

93 Project Practice: Small Commodity Purchase, Sales and Inventory Management System_Counting and Sorting Product Types_ok (2).mp4

94 Project Practice: Small Commodity Purchase and Sales Management System_Project Summary_ok (2).mp4

95 Introduction to Power BI_ok (2).mp4

96 Power BI components_ok (2).mp4

97 Power BI's DWT_ok (2).mp4

98 Copyright and Fees of Power BI_ok (2).mp4

99 Power BI installation and demonstration_ok (2).mp4

100 Power BI Four Guardians_ok (2).mp4

101 Power Map Static Map_ok (2).mp4

102 Power Map Dynamic Map_ok (2).mp4

103 Power View function loading_ok (2).mp4

104 Power View highly interactive visual report usage_ok (2).mp4

105 Power Query data import_ok (2).mp4

107 Power Query data merge (vertical merge)_ok (2).mp4

108 Power Query M function_ok (2).mp4

109 Power Pivot data import_ok (2).mp4

110 Power Pivot hierarchy creation_ok (2).mp4

111 Power Pivot Create KPI_ok (2).mp4

112 Power Pivot DAX Function (I)_ok (2).mp4

113 Power Pivot DAX Function (II)_ok (2).mp4

114 Power Pivot multidimensional data model creation_ok (2).mp4

115 Case Analysis_Air Quality (Urban Information Preparation)_ok (2).mp4

116 Case Analysis_Air Quality (Import Air Quality Folder Data)_ok (2).mp4

117 Case Analysis_Air Quality (Processing Data)_ok (2).mp4

118 Case Analysis_Air Quality (Power View Interface)_ok (2).mp4

119 Case Analysis_Air Quality (Based on Power View Interface) Dashboard Production_ok (2).mp4

120 Case Study_Air Quality (Slicer Style Processing)_ok (2).mp4

121 Case Analysis_Air Quality (Control Binding)_ok (2).mp4

122 Case Analysis_Air Quality (Combined Graph Implementation)_ok (2).mp4

123 Case Analysis_Air Quality (Completion Value Linkage)_ok (2).mp4

124 Case Analysis_Air Quality (Bubble Map Production)_ok (2).mp4

125 Power BI Desktop_concept_ok (2).mp4

126 Power BI Desktop_How it works_ok (2).mp4

127 Power BI Desktop_install and run_ok (2).mp4

128 Power BI Desktop_three views_ok (2).mp4

129 Power BI Desktop_Query Editor_ok (2).mp4

130 Power BI Desktop_Connect and adjust data_ok (2).mp4

131 Power BI Desktop_Merge data_ok (2).mp4

132 Power BI Desktop_create chart_ok (2).mp4

133 The concept of financial DuPont analyzer_ok (2).mp4

134 Financial DuPont Analyzer Production (1)_ok (2).mp4

135 Financial DuPont Analyzer Production (2)_ok (2).mp4

136 Financial DuPont Analyzer Production (3)_ok (2).mp4

137 Financial DuPont Analyzer Production (4)_ok (2).mp4

138 Financial DuPont Analysis Maker (5)_ok (2).mp4

139 Sales Funnel Relationship_ok (2).mp4

140 Building a multidimensional data model_ok (2).mp4

141 Insight into Risk_ok (2).mp4

143 Sales Management Analyzer Design Ideas_Story Development_ok (2).mp4

144 Sales Management Analyzer Design Ideas_Story Climax_ok (2).mp4

145 Sales Management Analyzer Design Ideas_The End of the Story_ok (2).mp4

146 P0WER QUERY data processing (1)_ok (2).mp4

147 P0WER QUERY data processing (2)_ok (2).mp4

148 P0WER QUERY data processing (3)_ok (2).mp4

149 P0WER PIVOT data processing (1)_ok (2).mp4

150 P0WER PIVOT data processing (2)_ok (2).mp4

151 P0WER PIVOT data processing (3)_ok (2).mp4

152 14_homework_ok (2).mp4

153 Course Catalog_ok (2).mp4

154 Course Objectives_ok (2).mp4

155 Tableau Overview_What is Data Visualization?_ok (2).mp4

156 How to tell a story with charts? (1)_ok (2).mp4

157 Tableau Family Products_ok (2).mp4

158 Tableau Development History_ok (2).mp4

159 Tableau Product Advantages_ok (2).mp4

160 Tableau Desktop installation configuration_ok (2).mp4

161 Tableau's navigation and menu_ok (2).mp4

162 Tableau Design Process Best Practices_ok (2).mp4

163 Tableau data types and files_ok (2).mp4

164 Tableau Data Source Preliminary Exploration_ok (2).mp4

165 Data source in-depth_basic operation_ok (2).mp4

166 Data connection mode (real-time vs extraction)_ok (2).mp4

167 Multi-table data connection_ok (2).mp4

168 Heterogeneous data mixing_ok (2).mp4

169 Extract data_ok (2).mp4

170 Worksheet_General Operation_ok (2).mp4

171 Worksheet_Edit metadata (change data type)_ok (2).mp4

173 edit metadata(alias)_ok (2).mp4

174 Field Operation (Merge Field)_ok (2).mp4

175 Field Operation (Hierarchical Field)_ok (2).mp4

176 Field Operation (Field Grouping)_ok (2).mp4

177 Field Operation (Field Split)_ok (2).mp4

178 Field Operation (Introduction to Calculated Fields)_ok (2).mp4

179 How much do the members of the demonstration set contribute to the total amount?_ok (2).mp4

180 Demonstrate how many members of a set exist in another set (above)?_ok (2).mp4

181 Demonstrate how many members of a set exist in another set (Part 2)?_ok (2).mp4

182 Summary_ok (2).mp4

183 operator_ok (2).mp4

184 digital function_ok (2).mp4

185 string function_ok (2).mp4

186 Date function_ok (2).mp4

187 Aggregate function_ok (2).mp4

188 Type conversion function_ok (2).mp4

189 Logical Function (Part 1)_ok (2).mp4

190 Logical Function (Part 2)_ok (2).mp4

191 Creating formulas in Tableau_ok (2).mp4

192 Tableau numerical calculation_ok (2).mp4

193 Tableau string calculation_ok (2).mp4

194 Tableau date calculation_ok (2).mp4

195 Table Calculation Difference Calculation_ok (2).mp4

197 Table Calculation Percentage Calculation_ok (2).mp4

198 Table calculation of total percentage calculation_ok (2).mp4

199 Table calculation of total ranking calculation_ok (2).mp4

200 Table Calculation Percentile Calculation_ok (2).mp4

201 Table Calculation Summary Calculation_ok (2).mp4

202 Table Calculation Summary Calculation (Subordinate Calculation)_ok (2).mp4

203 Table Calculation Mobile Calculation_ok (2).mp4

204 Fast table calculation_ok (2).mp4

205 temporary calculation_ok (2).mp4

206 Summary_ok (2).mp4

207 Introduction to this course_ok (2).mp4

208 Manual sorting_ok (2).mp4

209 Calculate sort_ok (2).mp4

210 How to create and edit filters_ok (2).mp4

211 Example Demonstration Dimension Type Filter_ok (2).mp4

212 Example Demonstration of Measure Type Filter_ok (2).mp4

213 Example Demonstration Date Type Filter_ok (2).mp4

214 Example Demonstration of Context Type Filter_ok (2).mp4

215 Example Demonstration Conditional Filter_ok (2).mp4

216 Example Demonstration Top Filter_ok (2).mp4

217 Example Demonstration Wildcard Filter_ok (2).mp4

218 Summary_ok (2).mp4

219 How to create and modify parameters?_ok (2).mp4

220 Examples showing how to use calculated fields in conjunction with parameters_ok (2).mp4

221 Example demonstrating how to use calculated fields in conjunction with filters_ok (2).mp4

222 Comprehensive example of the use of parameters in the view (Part 1)_ok (2).mp4

223 Comprehensive example of the use of parameters in the view (Part 2)_ok (2).mp4

224 Example of getting started with bar chart_ok (2).mp4

225 Example of getting started with line chart_ok (2).mp4

227 Example of getting started with scatter plot_ok (2).mp4

228 Example Getting Started Text Table_ok (2).mp4

229 Example Getting Started Heat Map_ok (2).mp4

230 Example Getting Started Histogram_ok (2).mp4

231 Example of getting started with Gantt chart_ok (2).mp4

232 Example of getting started with box-whisker plot_ok (2).mp4

233 Example of filling bubble chart_ok (2).mp4

234 Review_ok (2).mp4

235 Set geographic role_ok (2).mp4

236 How to customize geographic roles_ok (2).mp4

237 Building a simple map view_ok (2).mp4

238 Build a simple pie chart view_ok (2).mp4

239 Example Creating a map showing quantitative values_ok (2).mp4

240 Traffic volume spider map of Paris subway stations (above)_ok (2).mp4

241 Traffic volume spider map of Paris metro stations (below)_ok (2).mp4

242 Bike sharing data in Seattle, Washington_ok (2).mp4

243 reference line_ok (2).mp4

245 distribution interval_ok (2).mp4

246 Dashboard Detailed Explanation (Part 1) _ok (2).mp4

247 Dashboard Detailed Explanation (Part 2) _ok (2).mp4

248 story details_ok (2).mp4

249 Best Practices for Dashboards_ok (2).mp4

250 Best Practices on How to Tell a Great Story_ok (2).mp4

251 Project Background and Requirements Analysis_ok (2).mp4

252 Education website indicator evaluation_production【average score】view_ok (2).mp4

253 Create [Exam Results] View_ok (2).mp4

254 Create [School Education Level Assessment] Dashboard_ok (2).mp4

255 Create [Comparison of various dimensions] view_ok (2).mp4

257 Create [Urban Education Level Assessment] Dashboard_ok (2).mp4

258 Production [Education Website Index Evaluation] Story_ok (2).mp4

259 Project Background and Requirements Analysis_ok (2).mp4

260 Detailed design and business terminology description_ok (2).mp4

261 Create [View by Page] View_ok (2).mp4

262 Make【View by Media】static view_ok (2).mp4

263 Create [User Visits] View_ok (2).mp4

264 Create [User Access Behavior Analysis] Dashboard_ok (2).mp4

265 Project Background and Requirements Analysis_ok (2).mp4

266 original data and material preparation_ok (2).mp4

267 Create [Planogram] View_ok (2).mp4

268 Create [Store Sales Trends] View_ok (2).mp4

269 ​​Create [Product Category] View_ok (2).mp4

270 Create [Shelf Analysis Report] Dashboard_ok (2).mp4

271 Course introduction_ok (2).mp4

272 What is a programming language and the history of Python_ok (2).mp4

273 Python introduction, installation and IDLE tool_python features_ok (2).mp4

274 python development environment configuration-1_ok (2).mp4

275 python development environment configuration-2_ok (2).mp4

276 This chapter homework_ok (2).mp4

277 number and float and none and bool data types_ok (2).mp4

278 string type_ok (2).mp4

279 variable_ok (2).mp4

280 Basic Program Composition and Input and Output_ok (2).mp4

281 Common methods for converting between basic data types_ok (2).mp4

282 Python data structure-list_ok (2).mp4

283 collection_ok (2).mp4

284 tuple_ok (2).mp4

285 dictionary_ok (2).mp4

288 Python conditional statements: multiple conditional if statements_ok (2).mp4

289 Python conditional statements: complex conditions and nested if statements_ok (2).mp4

290 Python loop statement import_ok (2).mp4

291 Python loop statement while loop_ok (2).mp4

292 Python loop statement for loop_ok (2).mp4

293 Python loop statement nested loop_ok (2).mp4

294 Python loop statement loop control statement_ok (2).mp4

295 Python crawler crawler basics_ok (2).mp4

296 Python crawler: Introduction to crawler principles_ok (2).mp4

297 Python crawler crawler introduction request object introduction_ok (2).mp4

298 Python crawler, crawler introduction, small case study, crawling simple web pages_ok (2).mp4

299 Why should we learn R language, the introduction of R language and the overview of R language_ok (2).mp4

300 R Installation, basic use (HelloWorld program and initial understanding of functions and objects)_ok (2).mp4

301 R help command usage and R script execution instructions_ok (2).mp4

302 A glimpse into R language functions: case analysis and drawing and input and output in R (saving graphics as pictures and files)_ok (2).mp4

303 R language integrated development tool RStutio installation and use and R language package installation and loading instructions_ok (2).mp4

304 Example: Installing the ggplot2 package and using it to draw scatter plots and histograms_ok (2).mp4

305 Detailed explanation of Object and Vector in R_ok (2).mp4

306 Detailed explanation of atomic vectors and vector properties in R_ok (2).mp4

307 What is a function in R and how to define and use it_ok (2).mp4

308 Project Practice 1: Dice Rolling (I) Function and Object Definition Use_ok (2).mp4

309 Project Practice 1: Dice Roll (II) Function Definition, Optimization and Qplot Drawing_ok (2).mp4

310 R data structure matrix creation (combined with examples)_ok (2).mp4

311 R data structure matrix element acquisition and array creation_ok (2).mp4

312 R data structure: data frame creation and use (with case)_ok (2).mp4

313 R data structure list and common string function usage_ok (2).mp4

314 R workspace and importing CSV and XML data in RStudio_ok (2).mp4

315 R Load CSV format data and perform business analysis (with case studies)_ok (2).mp4

316 R Reading data from EXCEL and MySQL database tables (with case studies)_ok (2).mp4

317 R0208-Project: Poker game - generating poker cards, defining dealing and shuffling functions_ok (2).mp4

318 Project: Poker Game - Detailed Explanation of Global Environment and Function Runtime Environment in R Language_ok (2).mp4

319 Project: Poker game - Rewrite the card dealing and shuffling functions in R environment_ok (2).mp4

320 Project: Rewriting the code and testing the poker game using closures_ok (2).mp4

321 Project: Poker game - modifying the value of an object according to different game rules_ok (2).mp4

324 Project: Slot machine calculation and test run (involving FOR loop)_ok (2).mp4