Beijing
Shanghai
Guangzhou
South-West China
Hong Kong
Loading Events

Past Events

June 2019

POWER BI 商业大数据分析&可视化呈现 (中文授课) POWER BI Commercial Big Data Analysis & Visualization Presentation

In association with Dear Members and Friends of SwissCham, 课程简介 Brief Introduction Power Business Intelligence Desktop商业智能分析桌面版软件,以下简称Power BI Desktop。它是微软官方推出的可视化数据探索和交互式报告工具。核心理念就是让我们用户不需要强大的技术背景,只需要掌握Excel这样好用的工具就能快速上手商业大数据分析及可视化。它是构建在微软Azure公有云上的SaaS服务,无缝连接超过65+以上的数据库,超过85+钟以上的可视化报表。可以在PC端、移动端、手机端随时随地查看数据。Power BI在推出的短时间内就受到企业的青睐和广泛使用,覆盖零售、保险、制造、交通、教育等各行各业。未来,掌握Power BI的应用不仅仅会成为大学生求职或工作中的必备技能,也是能力的一种体现。 本课程主要培训数据分析与数据呈现的Power BI软件应用技能,培养满足企业岗位需要的数据分析与可视化技能,具备良好的数据处理、数据建模分析、数据可视化能力。 培训目标: 掌握Power Query多工作表、工作簿数据动态汇总。 掌握Power Pivot数据分析、数据建模的方法,常用DAX函数应用。 掌握Power BI Desktop呈现数据可视化的技术,享受无与伦比的图表视觉盛宴。 授课对象: 课程适用于有一定Excel数据分析操作基础,需要进一步提升掌握大数据分析与可视化的专业水平和使用效率的所有用户。 数据分析的各部门各级管理人员,企事业单位市场销售、行政办公人员、人力资源、财务会计、仓储物流等的相关岗位工作人员。 课程基础: 了解Microsoft Office Excel办公软件 有一定的Microsoft Office Excel办公软件使用经验 课程时间:1天,6小时授课(含答疑) 课程纲要 Course Outline 第一章:Power Query数据整理 1.   Power Query功能介绍及安装方式 2.   数据类型、查询刷新、应用步骤、上载存储类型介绍 3.   导入Excel数据 4.   规范化数据六大特点介绍 5.   数据的拆分合并提取 6.   多个工作表合并数据 7.   多个工作簿合并数据 8.   从文件夹汇总Excel数据M函数Excel. Workbook使用 第二章:PowerPivot数据建模与分析 1.   PowerPivot简介及与其他组件的关系 2.   理解事实表和维度表的概念 3.   DAX函数介绍 4.   计算客户不重复个数 5.   Related关系查找函数 6.   计算列和度量值的区别和使用方法…

Find out more »

深层挖掘EXCEL里的高级运用 (中文授课) Create Millions of Value by the Advanced Application of Excel

In association with Dear Members and Friends of SwissCham, 课程简介 Brief Introduction 培训现场,讲解与互动双管齐下,大量的案例练习,所有的知识点在课堂全部吸收 所有案例内容均从真实工作中提炼,培训后学员可以立即学以致用 所有EXCEL功能不再独立出现,均采用互相结合的方式学习,让案例更加深入工作 课后追踪,针对遗失的知识,一对一耐心辅导,实现真正的知识“落地” Training site, explaining and interacting with each other, a large number of case exercises, all the knowledge points can be absorbed in this training. All cases are extracted from real work, and the trainees can apply them immediately after training. All the EXCEL functions will no longer appear independently. The trainees will learn in a combined way, so that the case can be closer to work. There will be training tracking and patient one-for-one counseling about…

Find out more »

Fine Dining with Paul Pairet: How to combine creativity and discipline

June 12 @ 3:30 pm - 5:30 pm
Polux, Xintiandi North Block, No. 5, Lane 181 Taicang Lu, near Madang Lu, Huangpu District, Shanghai 上海市黄浦区太仓路181弄5号新天地北里, 近马当路
Shanghai,China
+ Google Map

Dear Members and Friends of SwissCham, When it comes to fine dining, there are not many Chefs in Shanghai who have the experience of Paul Pairet. Paul owns three restaurants in the city and his life project “Ultraviolet” has received three Michelin stars in 2017 and 2018. We invite you to this special event to hear how Paul developed his love for food and cooking, how he came up with “Ultraviolet” and what ideas he has for the years to come.…

Find out more »

Fireside Chat: Opportunities and Challenges in the Chinese Medtech landscape

June 4 @ 6:30 pm - 9:00 pm
swissnex China office (Shanghai), 22F, Building A, Far East International Plaza 319, Xianxia Road,
Shanghai,China
+ Google Map

In association with Dear Members and Friends of SwissCham, Under the lead of swissnex, we continue our Fireside Chat series with Swiss individuals who have been in China for an extended period of time and therefore can tell us about their insightful China experience. This time, we have the pleasure to invite Dr. Urs Mattes who will tackle the topic of Medtech specialties through the presentation of a case study from the dental industry and a discussion with the audience. Medtech…

Find out more »

May 2019

Chinese Accounting Standards (CAS) and a Comparison with IAS Principles

May 28 @ 6:30 pm - 9:00 pm
Four seasons Hotel Shanghai (PUXI), 500 Weihai Rd, Jingan District, Shanghai
Shanghai,Shanghai200000China
+ Google Map

In association with Dear Members and Friends of SwissCham, China has its own unique accounting standards, the so-called Chinese Accounting Standards (CAS). How does it differ from the International Accounting Standards (IAS) and how can foreign companies work with both in China? To answer these and other questions, we have invited Marta Snaidero and Giada Piccinini of GWA Greatway Advisory. Both are experts in the accounting and tax fields and have advised foreign companies when it comes to CAS and IAS…

Find out more »

Swiss Drinks and Lucky Draw

May 27 @ 6:30 pm - 9:00 pm
Abbey Road, No. 3 Taojiang Road, cross Fenyang Road, Xuhui District, Shanghai 桃江路3号,靠近汾阳路
Shanghai,Shanghai200000China
+ Google Map

In association with                         Dear Members and Friends of SwissCham, We are launching our second Swiss Drinks in 2019 to get the Swiss community together and enjoy some drinks after work, to better connect with our friends and colleagues. Of course, the event is open to anyone interested in the Swiss community. Again, we will have a lucky draw this time with amazing prizes! We are looking forward to seeing you there! Best regards, Your SwissCham Team Date &…

Find out more »

Retail and Cross-Border E-commerce in China

May 16 @ 6:30 pm - 9:00 pm
Four Seasons Hotel Pudong Shanghai, 210 Century Avenue, Pudong, Shanghai 中国上海浦东世纪大道210号
Shanghai,China
+ Google Map

In association with                          SwissCham Shanghai is delighted to invite you to: 中国瑞士商会诚挚邀请您 Retail and Cross-Border E-commerce in China Thursday, May 16, 2019 2019年05月16日 星期四 Time: 18:30-21:00 @Four Seasons Hotel Pudong Dear Members and Friends of SwissCham, With an increasingly mature and consumer-oriented economy and a new competitive landscape, China has taken a leading role, especially in the rapidly expanding e-commerce sector. The fast-growing, digitized and high-income middle class in China has an increased appetite for foreign premium products such…

Find out more »

[Training] The Confidence of Cultural Alignment

May 9 @ 1:00 pm - 5:00 pm
FCA centre, Meeting Room: 23A+B, Level 23, Five Corporate Avenue, 150 Hubin Road, Shanghai 200021 上海市湖滨路150号企业天地五号楼23楼
shanghai,China
+ Google Map

In association with: SwissCham Shanghai is delighted to invite you to: 中国瑞士商会诚挚邀请您 Dear Members and Friends of SwissCham, China Speed! It’s what we need and what we are told to deliver but the reality is that culture slows us down a little sometimes. Speed can be only come from a team where there is a very high level of trust. We invite you to explore, share and debate the best ways of building trust with your Chinese clients, counterparts and team…

Find out more »

[培训] 工业4.0解决方案和实施方法 Industry 4.0 Solutions and Implementation Approach

May 9 @ 9:00 am - 5:00 pm
STAUFEN Shanghai Office, 22H Cross Region Plaza, 899 Ling Ling Road
Shanghai,Shanghai200030China
+ Google Map

In association with Dear Members and Friends of SwissCham, Industry 4.0 and Digitalization in general is doubtlessly connected with fancy technology: from automation technology over sensors and actuators to software solutions. The variety of so called “smart” solutions is enormous, but their benefits are not always as promised. On the other hand, there are rather simple and small solutions that are not that visible on the shop floor but make a significant impact on your operations. Decisions on what to…

Find out more »

April 2019

[Training] Individual Income Tax Planning & Risk of Expatriates Working in China

In association with SwissCham Shanghai is delighted to invite you to: 中国瑞士商会诚挚邀请您 Dear Members and Friends of SwissCham, There are significant changes in China IIT in 2019 which significantly affect HR of companies and foreigners working in China.  Tax bureaus and State Administration of Taxation have organised a lot of training programs, videos and mobile APP to ensure the IIT reform can smoothly move forward. Facing the big changes but the rules were only issued in December 2018, what are…

Find out more »
+ Export Events