Business Data Analyst:Excel/VBA/Macros/PowerQuery/PowerPivot
Hands-on Data Analysis,Data Visualization,VBA Scripting,Macros Creation and debugging,etc
What you’ll learn
-
Creating a data models
-
Building relationships with connected data sources
-
Preparing queries
-
Enhancing queries
-
Cleansing data
-
Transforming data
-
Creating Pivot Tables and Pivot Charts
-
Creating Lookups
-
Using DAX to link data
-
Analyzing data with PivotTables and PivotCharts
-
Using Power Query with PowerPivot
-
Refreshing Data Source
-
Creating and editingMacros
-
Debugging Macros
-
VBA Scripting
Requirements
-
Basic knowledge of Excel is useful
Who this course is for:
- Beginner Business Analyst
- Beginner Data Analyst
- Beginner Data Scientist
