Microsoft Power BI Desktop (On-Premise Version)

Overview Schedule Dates Course Content Faqs

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.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Schedule Dates

Microsoft Power BI Desktop (On-Premise Version)

09 December 2024

Microsoft Power BI Desktop (On-Premise Version)

09 March 2025

Microsoft Power BI Desktop (On-Premise Version)

09 June 2025

Microsoft Power BI Desktop (On-Premise Version)

09 September 2025

Course Content

Get Power BI Desktop
Getting started with Power BI Desktop

Data Sources in Power BI Desktop
Connect to web data
Import Excel Workbooks
Analysis Services Tabular Data

Query overview
Shape and combine data
Data categorization
Relationship view
Create and manage relationships in Power BI Desktop
Common query tasks

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

Report View
Sort by column
Tips and tricks for creating reports
Import and display KPIs (Preview)

Publish from Power BI Desktop
Dashboards in Power BI
Share a dashboard from Power BI

FAQs

Participants should have:

Basic knowledge of data analysis and visualization concepts
Familiarity with Excel or other data tools (helpful but not required)

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

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

Yes, participants will receive a certificate of completion from CounselTrain, recognizing their expertise in using Microsoft Power BI Desktop for business intelligence.

You can enroll in the course by visiting CounselTrain’s course page and following the enrollment instructions provided.

Yes, course materials, including presentations, hands-on labs, and reference documents, will be provided to all participants.