top of page

全能IT商业咨询师

​涵盖范围

Excel

Advanced Functions, Pivot Table, Pivot Charts, Dashboard, Macros, VBA, Data Import & Export, Power Query, Power Pivot, Analysis Tool Package, Financial Modelling, etc.

Python, PySpark, R, SAS, Scala

Data Import & Export, Data Manipulation, Visualization, Regression, Predictive Modelling, K-Means Clustering, etc.

SQL

CRUD Syntax, Stored Procedures, Functions, Data Import & Export, SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis Services), SSMLS (Machine Learning Services), etc.

Tableau, Power BI

Data Import, Pivot Table, Charting, Interactive Dashboard, Story Telling, Calculated Field, LOD Expressions, Action Filter, Power Query, Power Pivot, DAX, etc.

bottom of page