Data Analyst – From Raw Data to Dashboard
2-Day Workshop
A fundamental understanding is crucial: 80% of the effort in data analysis is spent on data acquisition, structuring, data correction, and planning. But how can you efficiently utilize this time and resources?
Our seminar will show you how to optimize your data analysis with the Power Business Intelligence tools. Learn how to import and clean data from different sources and prepare it in a structured way. Find out how to visualize your data meaningfully, whether through georeports or relationship visualization.
Workshop Content
Introduction and Overview
- Overview of Power Business Intelligence Tools
- Installation & Download of Add-ins
PowerQuery
- Importing data from external sources
- Importing data from a folder in one step
- Importing data from different sources
- Creating relationships between tables
- Modeling data: Filtering, sorting, and grouping
- Unpivoting data
- Performing calculations in Power Query
Data Analysis with Pivot Tables
- Analyzing data in pivot tables
- Using predefined report layouts & formats
- Customizing pivot table settings
- Grouping pivot table data
- Using timelines & slicers
- Advanced analysis with pivot table functions
- Graphical data analysis with PivotCharts
PowerPivot
- PowerPivot interface & first steps
- Using DAX expressions
- Creating PowerPivot tables
- Resolving PowerPivot tables into CUBE functions
Other Analysis Functions in Excel
- 3D visualization of geographic data
- Creating georeports
- New analysis functions
Power BI Desktop
- Introduction to Power BI Desktop
- Retrieving & transforming data
- Creating relationships
- Creating reports with visuals
Who Should Attend This Workshop?
End users who want to clean, analyze, and visualize data.