Home > Courses > WSQ-MS Analyzing Data Using Power Query and Power Pivot

WSQ-MS Analyzing Data Using Power Query and Power Pivot

Name: WSQ-MS Analyzing Data Using Power Query and Power Pivot
Price: 500.00 SGD
Rating: 4.2 (18 reviews)

Training Provider: TRAINOCATE (S) PTE. LTD.

Course Reference: TGS-2023039439

S$500

Original: S$1,000

Save S$500

About This Course

LO1: Perform database queries and appropriate data analysis for
business insights
LO2: Use data mining and assist with data transformation to identify
data patterns
LO3: Summarize business insights from data studies
LO4: Produce performance dashboards and insight reports by applying statistical techniques.

What You'll Learn

Leveraging the full potential of Power Query, this course focuses on areas such as importing data from various sources, cleaning, shaping, and transforming data, and automating data refresh tasks. For Power Pivot, the training covers data modelling, the creation and management of relationships between tables, and developing DAX formulas for calculated columns and measures. These training modules provide hands-on experience, incorporating real-life business scenarios to better illustrate the use of these tools.

Entry Requirements

- Basic understanding of core MS Excel concepts, such as how to create basic data visualizations, perform data cleaning, combine datasets and transform layouts.
- Workplace Literacy and Numeracy Level 5 (WPLN: Speaking, Writing, Listening, Reading, and Numeracy at ESS level 5 or equivalent to Upper Secondary Level of English and Mathematics).
- Trainocate will assess the learner's suitability if they are unable to meet the minimum entry requirements.