Zhao Dan

Zhao Dan Email and Phone Number

Data Analyst @ 尚德机构
Zhao Dan's Location
Guangzhou, Guangdong, China, China
About Zhao Dan

VBA is my major coding language,Mysql and Python is the next. I can do ETL alone, I use Selenium to fetch web content, and use Pandas to clean my data, but mostly I use VBA. I use Power BI to modeling, cause I understand some M language basic and I can use PowerPivot to build model.When I was in school, I studied Logistics. When graduated, I find myself fond of IT things. I like coding and want to coding through my whole life

Zhao Dan's Current Company Details
尚德机构

尚德机构

View
Data Analyst
Zhao Dan Work Experience Details
  • 尚德机构
    Bi
    尚德机构 Aug 2018 - Present
    中国 广东 广州
    1 工作中使用Python,MySql,PowerQuery,PowerPivot,VBA等工具2 已自动化数据存储的ETL,大部分表格数据处理,还有数据展示3 目前主要对接临时需求和自动化维护,并提供分析建议
  • Lotus Love Corporation Limited
    Data Analyst
    Lotus Love Corporation Limited Mar 2016 - Jul 2018
    Guangzhou, Guangdong, China
    1 I'm in charge of Data Department. One workmate works with me and report to me2 I gather excel workbooks from our consultants and process data in them. On special analysis point, I'll discuss it with consultants. After changing data to charts, I'll give them to the consultant3 I'll report department work to general manager4 I use excel functions like IF,SUM and so on to process data and pivot table to reorganize my data. All data will be displayed in chart in powerpoint finally5 I study on automatic data-to-chart changing by using VBA and I work it out. Before, a report wasted 4 hours to complete and now I use only half an hour
  • Vatti Corporation Limited
    Management Tranee
    Vatti Corporation Limited Jul 2014 - Jan 2016
    Zhongshan,Xiaolan Town,Industrial Avenue South,Huayuan Road No.1
    1 I have worked on assembly line for 3 months. And I worked for Plan and Logistics Purchase Center for 3 months and 1 month in QC. Finally my main job was KPI and Data Operate management, and I was the secretary of our vice director meanwhile, and I was office clerks of many departments2 I was a member of logistics project leading by the vice president of manufacturing center. I designed the logistics route and made signage3 I learned AutoCAD and CorelDraw to help my work4 I was trained to develop a course and learned from MCT about excel skills. Then I developed a excel course facing to my workmates and it was accepted by training department of HR center

Zhao Dan Skills

Microsoft Office Microsoft Excel Microsoft Word 数据分析 Cad Coreldraw Sql Vba Python Autocad Erp

Zhao Dan Education Details

  • Zhongnan University Of Economics And Law
    Zhongnan University Of Economics And Law
    Logistics

Frequently Asked Questions about Zhao Dan

What company does Zhao Dan work for?

Zhao Dan works for 尚德机构

What is Zhao Dan's role at the current company?

Zhao Dan's current role is Data Analyst.

What schools did Zhao Dan attend?

Zhao Dan attended Zhongnan University Of Economics And Law.

What skills is Zhao Dan known for?

Zhao Dan has skills like Microsoft Office, Microsoft Excel, Microsoft Word, 数据分析, Cad, Coreldraw, Sql, Vba, Python, Autocad, Erp.

Not the Zhao Dan you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.