Professionals are faced with the challenge of presenting data analysis on a platform where management can easily access, quickly interpret and intelligently use for decision making. Many different platforms are available but certainly Microsoft’s Power BI is one of the most useful and increasingly popular tools. In this course, we will go over several functionalities used in Power BI – Desktop version to create dashboards and present data visually. A powerful tool normally used alongside Power BI is Power Query which is mainly used to get data from external sources, transform it, prepare it for analysis and automate all this process. Typically data is loaded into Power BI using Power Query which will be covered in this course as well.
Accounting and Finance
Power BI: Data Visualization and Dashboards
Professionals are faced with the challenge of presenting data analysis on a platform where management can easily access, quickly interpret and intelligently use for decision making. Many different platforms are available but certainly Microsoft’s Power BI is one of the most useful and increasingly popular tools. In this course, we will go over several functionalities used in Power BI – Desktop version to create dashboards and present data visually. A powerful tool normally used alongside Power BI is Power Query which is mainly used to get data from external sources, transform it, prepare it for analysis and automate all this process. Typically data is loaded into Power BI using Power Query which will be covered in this course as well.
Upcoming dates
Classroom
| Start date | End date | Location | Fee | Registration |
|---|---|---|---|---|
| Rome - Italy |
€2,125 + VAT
|
→ | ||
| Kuala Lumpur - Malaysia |
€1,400 + VAT
|
→ | ||
| Dubai - UAE |
€1,400 + VAT
|
→ | ||
| Cape Town - South Africa |
€1,420 + VAT
|
→ | ||
| Frankfurt - Germany |
€1,625 + VAT
|
→ | ||
| Barcelona - Spain |
€1,925 + VAT
|
→ | ||
| Frankfurt - Germany |
€1,625 + VAT
|
→ | ||
| Rome - Italy |
€2,125 + VAT
|
→ |
- Understand features and capabilities of Power BI
- Edit and transform data imported from various sources and file types using Power Query
- Develop dynamic data visuals and dashboards using Power BI Desktop version
- Automate data reporting and dashboarding using Power BI
This program is intended for professionals involved in Accounting and Finance.
- Business professionals, business analysts, data analysts, research analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision making.
Live online course where participants will be able to interact with instructor (video and audio), view slides, collaborate with others, comment on discussions, complete assessments, activities and case studies.
Day1
Get and transform – Power Query
- Get data from Excel
- Get data from TXT or CSV files
- Get data from web
- Get data from folder
Day2
Transformation
- Pivoting and unpivoting
- Filtering
- Sorting
- Adding/removing columns
- Adding conditional columns
Day3
Data visualization – Power BI
- Power BI report view
- Visuals
- Fields
- Basic charts
- Formatting options
- Filtering
- Matrix visuals
- Slicers and timelines
- Cards
- Q&A
- Maps
- Tooltip
- Drill through
- Bookmarks
Day4
Working with Data Models and DAX measures
- Explicit and Implicit measures
- Creating relationships between tables
- CALCULATE and RELATED functions
- Iterative functions e.g. SUMX, COUNTX, AVERAGEX
SPARK Training Certificate of Completion is awarded to participants who attend and complete the full training course.
Explore this topic
Related Training Courses
Accounting and Finance
Accounts Payable: Accounting and Management Best Practices
Accounting and Finance
Advanced Excel: Functions, Power Query and Power Pivots
Accounting and Finance
Advanced Financial Analysis
Accounting and Finance
