Microsoft Power BI Desktop (Intermediate)
[2024] 21 Nov
1 Day
COURSE OBJECTIVE
Microsoft Power BI is a highly popular Business Intelligence tool that helps create analytical reporting systems to support decision-making and address business needs. This course is suitable for those who have basic knowledge of using Power BI and want to learn advanced techniques through practical exercises, enabling them to use the tool more effectively.
COURSE OUTLINE
- Importing data from multiple files in a folder into a single table
- Combining data from multiple sheets in Excel into one table
- Techniques for connecting and using data from OneDrive and Google Drive
- Using Power Query Editor
- Using and managing Applied Steps
- Refreshing data and troubleshooting refresh issues
- Using important data transformation commands, including:
- Techniques for creating common report calculations such as YTD, YOY, MOM without writing formulas
- Using themes to format reports
- Creating custom themes
- Customizing interactive formats for reports
- Techniques for sorting data
- Filtering report data with custom filters
- Creating hierarchies
- Techniques for creating drill-down reports
- Creating cross-page drill-downs
- Creating slicers for multi-level data filtering
- Customizing slicers to filter data across multiple pages
- Creating and applying bookmarks for data presentation
- Creating and applying conditional formatting
- Creating and using standard tooltips
- Creating and using graph-based tooltips
- Techniques for using Drill Through and Cross Report
- Using custom visualizations
- Using AI visualizations
- Automatically refreshing data with Power BI Gateway
WHO SHOULD ATTEND
- General users with basic knowledge of Microsoft Power BI
- Those who work in data management, data analysis, and report summarization
- Executives who need to view data for decision-making
- Business Analysts & Data Analysts