

Microsoft Power BI Desktop (On-Premise Version)
Course Overview
Microsoft Power BI Desktop is a powerful on-premise data visualization and business intelligence tool developed by Microsoft. It allows users to connect to a wide range of data sources, transform and clean the data, and create interactive and visually appealing reports and dashboards. Power BI Desktop provides advanced analytics features, enabling users to perform complex calculations, create custom measures, and leverage machine learning capabilities. Its drag-and-drop interface makes it user-friendly, catering to both technical and non-technical users. Additionally, Power BI Desktop seamlessly integrates with other Microsoft products, such as Excel and Azure, enhancing its functionality and providing a comprehensive solution for data analysis and visualization.
Course Content
6 modules · 26 topics01Module 1: Overview2 topics
- Get Power BI Desktop
- Getting started with Power BI Desktop
02Module 2: Connect to Data4 topics
- Data Sources in Power BI Desktop
- Connect to web data
- Import Excel Workbooks
- Analysis Services Tabular Data
03Module 3: Shape and Combine Data6 topics
- Query overview
- Shape and combine data
- Data categorization
- Relationship view
- Create and manage relationships in Power BI Desktop
- Common query tasks
04Module 4: Data Fundamentals7 topics
- Data Type in Power BI Desktop
- Measures in Power BI Desktop
- Tutorial: Create your own measures
- Calculated columns
- Tutorial: Create calculated columns
- DAX Basics
- Calculated tables
05Module 5: Working with Reports4 topics
- Report View
- Sort by column
- Tips and tricks for creating reports
- Import and display KPIs (Preview)
06Module 6: Sharing your Work3 topics
- Publish from Power BI Desktop
- Dashboards in Power BI
- Share a dashboard from Power BI
Schedule Dates
4 upcoming batches| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 09 December 2026 | 1 Day | 8 hours & 4 hours | English / Arabic | |
| 09 March 2027 | 1 Day | 8 hours & 4 hours | English / Arabic | |
| 09 June 2027 | 1 Day | 8 hours & 4 hours | English / Arabic | |
| 09 September 2027 | 1 Day | 8 hours & 4 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
What are the prerequisites for this course?
Participants should have:
- Basic knowledge of data analysis and visualization concepts
- Familiarity with Excel or other data tools (helpful but not required)
What will I learn by the end of the course?
By the end of the course, participants will be able to:
- Transform raw data into meaningful insights using Power BI Desktop
- Make data-driven decisions to support their organization’s objectives
- Effectively communicate their findings through interactive reports and dashboards
What tools and technologies will be used during the course?
Participants will gain hands-on experience with:
- Power BI Desktop installation and data connection tools
- Data shaping and transformation techniques
- Data Analysis Expressions (DAX) for advanced data manipulation
- Report creation and visualization tools
- Dashboard creation and management tools
Is there a certification upon completion?
Yes, participants will receive a certificate of completion from CounselTrain, recognizing their expertise in using Microsoft Power BI Desktop for business intelligence.
How can I enroll in this course?
You can enroll in the course by visiting CounselTrain’s course page and following the enrollment instructions provided.
Are there any course materials provided?
Yes, course materials, including presentations, hands-on labs, and reference documents, will be provided to all participants.
Flexible Training Options to Meet Your Needs
Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.
Select the method that best suits your needs.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights
Related Courses
Other courses in the same category that might interest you.


T|IE: Threat Intelligence Essentials
View Course
I|SE: IoT Security Essentials
View Course
