- Getting started with BigQuery
- Querying a simple table on BigQuery
- SELECT statements
- WHERE conditions
- Multiple conditions
- IF and CASE WHEN
- Functions
- Group Functions
คอร์สนี้จะสอนการเขียนภาษา SQL ในระดับเริ่มต้นเพื่อนำไปใช้งานในด้าน Data Analytics โดยผู้เรียนจะฝึกการเรียนภาษา SQL ด้วย Google BigQuery ซึ่งเป็น Cloud Service สามารถเรียนเขียน SQL ได้เลย โดยไม่ต้อง install program บนเครื่อง สามารถฝึกเขียน SQL ผ่าน Web Browser ได้
Learn how to master MS Excel (Beginners & Advanced) methods quickly and easily for yourself or business.
The fundamentals of creating a brand positioning and how it translates into brand communication
A step by step learning of JavaScript language from basics to advanced concepts
Learn HTML and CSS from scratch and build a project for your web developer portfolio
We’ll cover functional programming, debugging techniques, and object-oriented programming.
I have extensive experiences in Data Analytics and Business Intelligence in both working and teaching. I have been working as a consultant with leading companies in Thailand for more than 20 projects, for instance; Data Mining and CRM in Retail, Anti-Money Laundering in Banking, Strategic Information System in Transportation, and Executive Information System in Healthcare. During years of being a consultant, I participated in every phase of BI development life cycle; from design to deployment. I have extensive hands-on experiences in using leading BI software packages including SAS Business Intelligence Suite, IBM Cognos & TM1, Oracle Business Intelligence and Hyperion, SAP Business Objects, Microsoft, and Tableau. I am proficient in using BI tools such as ETL, Data Quality, OLAP Cube and Reporting, Scorecard, Dashboard, Data Mining, Forecasting, and Budgeting and Planning.
In addition, I taught in several classes in top universities in Thailand for more than 10 years including Business Intelligence, Data Warehouse, Data Mining, Customer Relationship Management (CRM), Business Reporting, System Analysis and Development, E-Commerce, for instance.