Week Class date Topic Videos Time requirements Time per week Notes Literature Week 1 9/20/2017 Intro to Business Analytics # 02 - Excel rules 12:37:24 AM 1:43:50 AM uvod Week 2 9/20/2017 Basic Excel functions # 03 - What If Analysis I 12:05:28 AM pujcka # 04 - What If Analysis II 12:04:46 AM # 05 - What If Analysis III 12:11:31 AM # 06 - What If Analysis IV 12:09:46 AM # 07 - Basic Data visualization 12:14:26 AM # 08 - VLOOKUP & LOOKUP/SUMPRODUCT 12:19:51 AM # 09 - INDEX & MATCH & IF 12:10:57 AM # 10 - Fix Excel Formula Errors 12:17:16 AM # 11 - Excel Tables (Excel dynamics) 12:09:49 AM Week 3 10/4/2017 Clean & Transform & Format Data # 12 - Basic Data Rules 12:15:48 AM 1:20:43 AM "# 13 - Sort, Filter, Pivot Tables" 12:21:38 AM "# 14 - Logical Formulas, Conditional Formatting" 12:13:29 AM "# 27 - Formulas, Flash fill, Text to Columns" 12:29:48 AM Week 4 10/11/2017 Descriptive Statistics # 15 - Frequency Distributions (1) 12:11:51 AM 2:23:11 AM Lecture notes DADM_MBA # 16 - Frequency Distributions (2) 12:07:29 AM # 17 - Frequency Array Function 12:23:01 AM # 18 - Data Analysis Add In for Frequency and Distribution 12:09:33 AM # 19 - Pivot Tables rules for Frequency 12:16:29 AM # 20 - Skew shape of Histogram 12:03:18 AM "# 21 - AVERAGE,MEDIAN MODE.MULT functions" 12:09:03 AM # 22 - Geometric Mean 12:11:32 AM "# 23 - Variability, Varinace, Standard Deviation" 12:18:20 AM # 24 - Empirical Rules & NORM.DIST & NORM.S.DIST 12:13:58 AM # 25 - Percentiles & Quartiles 12:13:16 AM # 26 - Box & Whisker Plot Chart 12:05:21 AM time line Week 5 10/18/2017 Power Query # 28 - Text file Import 12:21:53 AM 1:19:53 AM # 29 - CSV File Import 12:11:19 AM # 31 - Excel Files I 12:12:06 AM # 32 - Excel Files II 12:08:58 AM # 33 - Transform Bad Data 12:11:21 AM # 34 - Import & Merge Multiple Sources 12:05:01 AM # 35 - Data from Web Side 12:03:00 AM # 36 - Transform Data From Multiple Columns to Single Column 12:06:15 AM Week 6 10/25/2017 Case I EVA Challange Week 7 11/1/2017 Case I Week 8 11/8/2017 Case I Week 9 11/15/2017 Case II Week 10 11/22/2017 Case II Week 11 11/29/2017 Case II Week 12 12/6/2017 Week 13 12/13/2017 ??? Excel Solver - Optimalizations Models # 57 - # 63 ??? Montecarlo simulation # 64 - # 69 ??? Time Series & Forecasting # 53 - # 56 ??? Regresion # 44 - # 52 ##### Sheet/List 2 ##### Č. Učo Student Studium Ukonč Poznámka 1. 390904 "Aláč, Peter" ESF N-SI POIN [sem 2] (skupina V) zk 2. 448559 "Bednářová, Veronika" ESF N-FU FIN [sem 4] zk 3. 408519 "Dohnálek, Richard" ESF N-KME MSME [sem 2] zk 4. 379853 "Igaz, Dávid" "FI N-AP SSME [sem 5, roč 3]" zk 5. 423634 "Kaličiaková, Lea" ESF N-KME MSME [sem 2] zk 6. 394592 "Kaplanová, Klára" ESF N-KME MSME [sem 4] zk 7. 421089 "Karčmař, Petr" "ESF N-KME MSME [sem 1, roč 1] (skupina 17J)" zk 8. 405857 "Karlínová, Bára" "ESF N-KME MSME [sem 3, roč 2] (skupina 16J)" zk stáž 9. 420810 "Knapeková, Zuzana" "PřF B-MA FINPOJ [sem 6, roč 3]" zk 10. 408687 "Kočková, Veronika" "ESF N-KME MSME [sem 3, roč 2] (skupina 16J N)" zk 11. 405454 "Komínek, Lukáš" ESF N-KME MSME [sem 2] zk 12. 375636 "Kratochvílová, Lucie" ESF N-KME MSME [sem 4] zk 13. 405754 "Láncošová, Elena" ESF N-FU FIN [sem 4] zk 14. 405633 "Líbalová, Monika" ESF N-KME MSME [sem 4] zk 15. 444188 "Lisztwan, Denis" ESF B-FU FIN [sem 4] zk 16. 421492 "Lofaj, Jakub" "ESF N-HPS HOSP [sem 1, roč 1] (skupina 17J)" zk 17. 408436 "Macková, Magdaléna" ESF N-KME MSME [sem 4] zk 18. 421220 "Pecsérke, Filip" ESF B-EKM PEM [sem 7] (skupina VNV) zk 19. 391148 "Potěšil, Tomáš" ESF B-SI POIN [sem 2] zk 20. 63251 "Rademacher, Jiří" ESF B-HPS VES [sem 4] zk 21. 409004 "Roštárová, Lenka" ESF N-KME MSME [sem 4] zk 22. 421267 "Rybář, Jaroslav" ESF N-FU FIN [sem 2] zk stáž 23. 394088 "Šimková, Jana" ESF N-KME MSME [sem 4] zk 24. 433493 "Šudák, Ján" ESF B-EKM PEM [sem 4] zk 25. 362549 "Večeřa, Martin" ESF N-EKM PEM [sem 2] zk 26. 420852 "Zámorská, Eliška" ESF N-FU FIN [sem 2] zk