• Microsoft BI Architect
• SQL Server 2012&T-SQL&OLTP/OLAP
• SQLServer SSAS, SSRS, SSIS
• MicrosoftBI Tools (Excel, Power View, Power Query, Power Pivot)
• Tableau&BI
• Understanding Big Data
• SharePoint Business Intelligence
【项目交付】Agile/Scrum(4 weeks per sprint), Cloud-based Distributed Teams
• ETL Solution for CRM integration with Data Warehouse
• Sales, Marketing Business Intelligence with SSRS, Power Pivot etc.
• Data Mining and Analysis for Customer Consuming Trend, PotentialCapabilities
• Customer 360 degree view and insight
【课程时间】
每周日下午1:00–5:00
【项目时间】
每周二,四,六
【地点】
930 ProgressAve, Scarborough, ON M1G 3T5 (免费停车) 请预约老师面谈报名
预约热线:647- 861-6072
【目标职位】
• BI Developer
• BI Specialist
• Report Developer
• Data Analyst
• Data Developer
• Data Engineer
• BI Consultant
• ETL Specialist/Developer
• SQL Developer
Requirements:
· Hands-on Experience on Excel
· Knowledge of SQL, OLTP andOLAP
· Knowledge of SSIS, SSRS, SSASor Power BI/ Power Pivot/Power View
· Good Communication andCollaboration
Big Data Developers
Requirements:
· Deep knowledge of SQL
· Knowledge of Hadoop,MapReduce, Hive and Sqoop, Flume
· Competencies: Team-work,Collaboration and Communication
· Asset: Spark and MachineLearning
CRMDevelopers/Consultants
Requirements:
· Knowledge of Dynamics CRM andXRM
· Knowledge of SQL Database,ETL
· Competencies: Team-work,Collaboration and Communication
Our CRM-based Data Platform hasbeen designed to implement end-to-end data pipeline for big data ingestion,handling and integrating with EDW (enterprise data warehouse) for deeplyanalysis of business trend and corporate performance as well as optimization ofenterprise profit model along with accurate customer 360 degree view so as torealize data-driven business to maximize the profit margin for the corporation.
The Platform Portfolio as thefollowings:
· Cloud-based CRM and Big DataHandling Solutions
· CRM Integration Solution withData Warehouse
· Custom Business Intelligence(BI) Development
· Data Modeling, Data Mapping,Data Mining and OLAP
· ETL Strategy andImplementation
· Analytical Reporting andDashboard Generation
· Big Data handling and No-SQLData Warehouse
· Data Quality and SecurityManagement