Projects

Change needs sense of urgency

  1. 職+專+學+正+系
  2. WSUS + java
  3. AD audit report and policies
  4. AD RFS
  5. Performance reporting
  6. 生改單 – 圖及版本看系統
  7. 料號變更跟蹤
  8. 訂單電子審核
  9. OA – 樣板單
  10. CACTI SNMP server
  11. SQL backup and restore
  12. Wechat programming
  13. tax expense profile
  14. Economist
  15. Scrap rates and quantity
  16. Stock level
  17. BI at sharepoint and Tablet / mobile
  18. 8S correction with scrap alerts
    1. Launch date: 10Oct2016
    2. Status: Not yet
  19. Quality level
  20. Offsite backup with docoumentations
  21. Windows perfmon automation / syslog / SNMP
  22. IT system applications in Manufacturing and various industies
    1. Logic / flow
    2. Requirements
    3. Critical success factors
  23. Wikis:
    1. Documents library with version control,
    2. co-authering with approval,
    3. knowledge searching
Projects

MSc resources

A. BSc 1st Class means nothing (too many out there…), the importance is what you learned and how do you sustain to break through!

B. MBA for business; Specialist in MSc but not of MSc IT…

  1.  UoG
    1. UoG Infonet: http://infonet.glos.ac.uk/
      1. Library online resources -> ScienceDirect
  2. Academic writing:
    1. MDX resources: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources
    2. Using-academic-language: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources/using-academic-language
    3. Academic vocabulary: http://www.nottingham.ac.uk/alzsh3/acvocab/
  3. Time management
  4. Research methods for Business Student – 5/e:
  5. Basic Business Statistics – 12e:
    1. Statistics e-resources: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources/maths-stats-and-numeracy/statistics
  6. Harvard referencing
    1. https://infonet.glos.ac.uk/departments/lis/Guides/Harvard%20Referencing.pdf
    2. http://ist.glos.ac.uk/referencing/harvard/
  7. Academic reference letter:
    1. http://www.strath.ac.uk/careers/uni_staff/writingacademicreferences/exampleofacademicreference/
  8. Further MSc study:
    1. MSc Big Data Technology, HKUST: https://www.sengpp.ust.hk/programs/bdt/en/application.html
    2. (NCC L7DSBIT) University of Gloucestershire (89th): http://www.glos.ac.uk/courses/postgraduate/cit/pages/computing-it-management-postgraduate-diploma-msc.aspx
    3. (NCC L7DSBIT) London Metropolitan University (120th): http://www.londonmet.ac.uk/courses/postgraduate/information-technology-distance-learning—msc/
    4. University of Edinburg (19th): MSc Data Science, Technology and Innovation (Medical Informatics).  http://www.ed.ac.uk/studying/postgraduate/degrees/index.php?r=site/view&id=906
    5. University of Leicester, MSc Computer Science, SoftEng, WebTech (32nd): https://le.ac.uk/courses/advanced-software-engineering-msc-dl
    6. University of Aberdeen, MSc PM, MSc IT & MBA Digital Marketing (42nd): https://www.abdn.ac.uk/study/postgraduate-taught/degree-programmes/52/digital-marketing-leadership/ 
    7. Royal Holloway Univeristy of London (37th): http://www.londoninternational.ac.uk/courses/postgraduate/royal-holloway/information-security-msc-postgraduate-diploma#overview
    8. Edinburgh Napier University (92nd): http://www.napier.ac.uk/courses/msc-advanced-security-and-digital-forensics-postgraduate-distance-learning-part-time
    9. Advanced Manufacturing system by Brunel University London (52nd): https://www.brunel.ac.uk/study/postgraduate/Advanced-Manufacturing-Systems-MSc
    10. DeMontfort University (54th): http://www.dmu.ac.uk/study/courses/postgraduate-courses/data-analytics-msc-degree/data-analytics-msc-degrees.aspx
    11. Northumbria University, Information Science – Data Analytics(59th): https://www.northumbria.ac.uk/study-at-northumbria/courses/information-science-msc-data-analytics-dl-dtdinv6/#year-two
    12. MSc PM, Liverpool John Moores University (74th): https://www.ljmu.ac.uk/study/courses/postgraduates/project-management
    13. University of Hertfordshire (79th): http://www.herts.ac.uk/courses/search?collection=herts-courses&f.Course%20Type|T=Postgraduate&query=!padrenullquery&f.Method+of+Study%7CS=Online+-+Part+Time
    14. MSc PM, Salford University (95th, 4 intakes/yr): http://www.salford.ac.uk/pgt-courses/project-management
    15. MSc PM, Birmingham City University (95th, but cheap): http://www.bcu.ac.uk/courses/int-project-management
    16. MSc IT, University of Derby (91st): https://www.derby.ac.uk/online/course/information-technology-msc/course-fees
  9. Further MBA study:
    1. UST: https://www.sengpp.ust.hk/programs/bdt/en/program_details.html
    2. Duram University (6th): https://www.dur.ac.uk/business/programmes/mba/online-mba/
    3. MBA with Data Analytics, Nottingham Trent University (63rd): http://online.ntu.ac.uk/online-courses/mba/data-analytics?cmgfrm=https%3A%2F%2Fwww.ntu.ac.uk%2Fstudy-and-courses%2Fcourses%2Fdistance-learning-online
    4. Middlesex University (78th):
    5. Leicester University (32nd): https://le.ac.uk/courses/the-leicester-mba-dl?uol_r=6641cede
    6. Heriot-Watt University (34th): https://www.hw.ac.uk/study/uk/postgraduate/master-business-administration.htm
    7. University of Derby (91st): http://www.derby.ac.uk/online/course/online-mba-global-master-business-administration-degree-course
    8. Most affordable:
      1. Agnlia Ruskin University (110th): https://distancelearning.anglia.ac.uk/courseDetail.php/MBA-Master-of-Business-Administration-16/
      2. Leeds Beckett University (103rd): https://courses.leedsbeckett.ac.uk/mba_executive_online/#Coremodules
    9. Strategic Planning / Strategic Sustainble Business
  10. Further HR study:
    1. Leicester University: https://le.ac.uk/courses/human-resource-management-and-training-msc-dl?uol_r=d65bd40d
  11. Further Acc Study (exempt basic knowledge application / future route?):
    1. HKICPA non-Acc routes: http://www.hkicpa.org.hk/en/become-a-hkicpa/how-to-apply/entry-routes/#route2 
    2. HKU SPACE (fast / low price): http://hkuspace.hku.hk/prog/postgrad-dip-in-prof-accounting
    3. PolyU (Most expensive / best): http://www.af.polyu.edu.hk/programmes/detail/7
    4. CUHK (High entry requirements with QR registers/ best): http://www.bschool.cuhk.edu.hk/index.php/programs/postgraduate-diploma-in-professional-accountancy/program-overview
    5. Lingnan (Deposit / Sat only, not available at 2017/18): http://www.ln.edu.hk/acct/macc/pgda.php
  12. Distance Learning materials:
    1. Leicester University: http://www2.le.ac.uk/departments/management/distancelearning/courses
    2. The University of Strathcylde:
      1. MSc Operational Research (Distance learning). https://www.strath.ac.uk/courses/postgraduatetaught/operationalresearchdistancelearning/
      2. Business Analysis & Consulting (Distance Learning). https://www.strath.ac.uk/courses/postgraduatetaught/businessanalysisconsultingdistancelearning/ 
    3. University of Hertfordshire:
      1. MSc Operations and Supply Chain Management (Online). http://www.herts.ac.uk/courses/operations-and-supply-chain-management-online
      2. MSc Manufacturing Management (Online). http://www.herts.ac.uk/courses/manufacturing-management-online
  13. Research Degrees (distance learning)
    1. LMU, Research Degree – MPhil / Phd. http://www.londonmet.ac.uk/courses/postgraduate/research-degree—mphil–phd/
  14. NCC references:
    1. NCC contact: http://www.nccedu.cn/onepage-10.html
    2. Middlesex sent official transcript to Education institute: http://www.onlinestore.mdx.ac.uk/browse/extra_info.asp?compid=1&modid=1&catid=23&prodvarid=84 
  15. Others
    1. Manufacturing: MSc Manufacturing Systems Engineering and Management (MSEM). http://www2.warwick.ac.uk/fac/sci/wmg/education/wmgmasters/courses/manufacturing_systems_engineering_and_management/
MSc resources

Tableau BI study log

  1. Objectives
    1. Establish formal procedures
    2. Establish advanced wiki for development
      1. OA + ERP db calculation
    3. Wide Access control by SharePoint
  2. Resources
    1. Tableau Data Visualisation Cookbook:
      1. DataSets: http://biostat.mc.vanderbilt.edu/wiki/pub/Main/DataSets/titanic.txt
    2. Tableau Getting start: https://onlinehelp.tableau.com/current/pro/online/mac/en-us/gettingstarted_overview.html
    3. Learning:
      1. Videos: http://www.tableau.com/learn/training
      2. Learning path to Tableau expert: https://www.analyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/tableau-learning-path/
      3. Tableau tutorials: https://www.tutorialspoint.com/tableau/index.htm
      4. Tableau: How Fast You Can Learn It?https://www.concentra.co.uk/blog/how-fast-can-you-learn-tableau
      5. Tableau user Doc by edu: http://casci.umd.edu/wp-content/uploads/2013/12/Tableau-Tutorial.pdf
    4. Scenario with 8 steps and library: http://onlinehelp.tableau.com/current/guides/get-started-tutorial/en-us/get-started-tutorial-home.html
    5. SQL by
      1. https://www.codecademy.com/learn/learn-sql
      2. http://www.w3schools.com/sql/
  3. Terms
    1. Tableau Server
    2. Tableau Desktop 8.2: http://www.tableau.com/support/esdalt
    3. Project
    4. Workbook
    5. KPI / metrics
    6. Views
    7. Dashboard
    8. Story
  4. BI literature review
  5. Study log
  6. Dashboard research
    1. Actions in Dashboard: https://public.tableau.com/en-us/s/blog/2015/06/rough-guide-dashboard-actions
    2. 7 Business Dashboards – http://www.cio.com/article/2369201/business-intelligence/151486-7-Business-Dashboards-That-Offer-Striking-Data-Visualizations.html#slide2
    3. 用数据说话,R语言有哪七种可视化应用?http://www.leiphone.com/news/201701/wiDDwAAEJ87zoji9.html
    4. Tableau and SharePoint Integration: https://www.youtube.com/watch?v=ElyH9iJd-4c
    5. PMC Report samples by Tableau: https://public.tableau.com/profile/unoviz#!/vizhome/PMCreport/ChannelDashboard
    6. Monitor production quality with a single manufacturing dashboard: https://www.tableau.com/stories/workbook/monitor-all-relevant-production-data-single-dashboard
    7. Add Reference Line: https://onlinehelp.tableau.com/current/pro/desktop/en-us/reflines_addlines.html
      1. Dynamic reference line: http://kb.tableau.com/articles/knowledgebase/creating-dynamic-reference-lines
    8. Creating Error Bars: http://kb.tableau.com/articles/howto/creating-error-bars
    9. Creating Bars in Bar chart in Tableau: https://www.youtube.com/watch?v=-qXfjweVuqQ 
Tableau BI study log

公眾責任險

  1. Objectives
    1. protect assets and staff
    2. protect third party
  2. Options
    1. 展览会责任保险方案
      1. 有承办展览会资格的机构;
      2. 参演人员、明星、嘉宾的人身伤亡或财产损失,保险人不负责;
      3. 50次, RMB25,000;
      4. 場地為500平方米以下, 人數為500人下;
      5. 不負責員工及展品/設備
      6. 及其他不負責事項;
    2. 經營場所公眾責任險
      1. 場所許可資質
      2. 活動安全風險評估
      3. 員工保險
  3. References
    1. 中國太平: http://www.cntaiping.com/product/30004.html
    2. 中國人壽: http://www.chinalife.com.cn/publish/zhuzhan/792/2011/20111202143058484504118/20111202143058484504118_.html
    3. 平安:”什麼是公眾責任險”: http://baoxian.pingan.com/baoxiananli/yiwaixiananli/1408587768751.shtml 
公眾責任險

OCP – MySQL 5.6 DBA

  1. Objectives
    1. exam at August
    2. wordpress application
    3. comparison with Oracle 11g, 12c, noSQL, MSSQL 2008,
  2. TOC
    1. Introduction to MySQL Database
    2. Concepts of MySQL Database
    3. MySQL Server Configuration Option
    4. Login Access to MySQL Server
    5. Granting Privileges on MySQL Server
    6. MySQL Metadata
    7. Log and Status Files
    8. MySQL Enterprise Audit Log
    9. Backup and Recovery
    10. High Availability: Replication
  3. Contents
    1. Introduction to MySQL Database
      1. MySQL editions: community / standard / enterprise (exam);
      2. two-tier processing model: a SQL/optimizer tier and a storage engine tier;
      3. MySQL Enterprise Edition provides the MySQL Thread Pool – sustain performance and scalability – by reduce overhead in managing client connections and statement execution;
      4. ACID: Atomicity, Consistency, Isolation and Durability;
        1. Atomicity requires each transaction be all / nothing;
        2. Durability the result of a transaction remains after it has been committed, even with power loss or system crashes;
    2. Concepts of MySQL Database
    3. MySQL Server Configuration Option
    4. Login Access to MySQL Server
    5. Granting Privileges on MySQL Server
    6. MySQL Metadata
    7. Log and Status Files
    8. MySQL Enterprise Audit Log
    9. Backup and Recovery
    10. High Availability: Replication
  4. References
OCP – MySQL 5.6 DBA

Mobile apps and DB

  1. Objectives
    1. Mobile programming
    2. DB
    3. UI/UX
    4. security and testing
    5. privacy and compliance
  2. Contents
  3. References
    1. 5 popular DB for mobile: https://www.developereconomics.com/five-popular-databases-for-mobile
    2. NoSQL: http://www.techrepublic.com/article/nosql-is-ideal-database-for-mobile-apps-says-couchbases-chief-mobile-architect/
    3. DB powered app bulilders: https://zapier.com/learn/forms-surveys/simple-database-app-builders/
    4. Mobile databases: http://www.cse.yorku.ca/~jarek/courses/6421/F12/presentations/Mobile-Databases_%20Presentation.pdf
    5. Oracle mobile application framework: http://www.oracle.com/technetwork/developer-tools/maf/documentation/oraclemaf-datasheet-2220993.pdf
Mobile apps and DB

MSc IT – LMU

  1. Objectives
    1. MSc degree between 2017-2018
  2. Contents
    1. CC7173 – Mobile Application Design and Development
    2. CC7174 – Database Systems with Professional Certification
    3. FC7P05 – MSc Project
  3. Other modules from LMU
    1. **CC7181 – Data Modelling and OLAP Techniques for Data Analyticshttps://intranet.londonmet.ac.uk/module-catalogue/record.cfm?mc=CC7181
    2. CC7164 – Data Mining for Business Intelligence. https://intranet.londonmet.ac.uk/module-catalogue/record.cfm?mc=CC7164
  4. References
    1. FC7004 – Research and Development Skills. https://intranet.londonmet.ac.uk/module-catalogue/record.cfm?msid=C75E0FA2-4256-46D6-8C659F6B2CB147A1
    2. CC7173 – Mobile Application Design and Development. https://intranet.londonmet.ac.uk/module-catalogue/record.cfm?msid=B332F4C8-9813-4C8E-8DF71C22E0A77375
    3. CC7174 – Database Systems with Professional Certification. https://intranet.londonmet.ac.uk/module-catalogue/record.cfm?msid=F41F42C4-24AB-4F94-89CCCDA136325337
    4. FC7P05 – MSc Project. https://intranet.londonmet.ac.uk/module-catalogue/record.cfm?msid=AD3212F5-7A6D-4D3A-B53646BE7A5BD693
    5.  PDP:
      1. https://www.bangor.ac.uk/doctoral-school/PersonalDevelopmentPlan.php.en
      2. https://www.bangor.ac.uk/humanresources/staffdevelopment/pdr/pdp-guide.php.en
    6. LMU, Research Degree – MPhil / Phd. http://www.londonmet.ac.uk/courses/postgraduate/research-degree—mphil–phd/
MSc IT – LMU