Learn How to Use Microsoft Power BI Desktop (On-premise Version) - Get Started Today!

Download Course Contents

Microsoft Power BI Desktop (On-premise version) Course Overview


Microsoft Power BI Desktop is a powerful and flexible data analysis, visualization and reporting tool. The On-premise version of the software allows users to access, prepare and analyze data stored on premise and publish their insights in an interactive dashboard.
This course provides a comprehensive overview of all the features and functions of Microsoft Power BI Desktop, designed to help users become familiar with the software in a hands-on manner. It walks through the data preparation and manipulation process, covers the types of visualizations available, provides guidance on creating interactive visualizations and introducing dashboards, as well as sharing and publishing of the work.
The course includes practical activities and exercises that allow the participants to develop their own Power BI Desktop solution and build their own interactive dashboards.
The course also provides an introduction to advanced analysis features such as Power Query, Measures and DAX, which are all crucial skills for an effective Power BI user. These topics are covered in detail, so that the participant can take control of their own data analytics.
By the end of the course, participants will:
• Understand core Power BI concepts such as Relationships, Filters and Analyzing Data
• Know how to prepare and load data from different sources
• Create interactive visuals and dashboards
• Achieve mastery in building Power BI measures and DAX expressions
• Gain full control over the application settings and customizing the visualizations
• Develop the skills to share and publish Power BI content.
Microsoft Power BI Desktop (On-premise version)
home-icon

The 1-on-1 Advantage

Get 1on-1 session with our expert trainers at a date & time of your convenience.
home-icon

Flexible Dates

Start your session at a date of your choice-weekend & evening slots included, and reschedule if necessary.
home-icon

4-Hour Sessions

Training never been so convenient- attend training sessions 4-hour long for easy learning.
home-icon

Destination Training

Attend trainings at some of the most loved cities such as Dubai, London, Delhi(India), Goa, Singapore, New York and Sydney.

You will learn:

Module 1: Overview
  • 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
Live Online Training (Duration : 8 Hours)
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

800 + If you accept merging of other students. Per Participant & excluding VAT/GST
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
700 Per Participant & excluding VAT/GST
Online
05 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Online
03 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Course Prerequisites

• Familiarity with basic database concepts such as database tables, columns, and rows
• Familiarity with database query tools (such as SQL)
• Basic knowledge of Microsoft Excel, including pivot tables and basic data analysis
• Knowledge of data sources and database concepts, such as SQL database and query syntax.
• Experience working with computer-based data such as Microsoft Excel, CSV files or database tables

Target Audience


The target audience for Microsoft Power BI Desktop (on-premise version) training is comprised of individuals and organizations with an interest in harnessing the power of data analytics
This includes data analysts, data engineers, business intelligence specialists, project managers, IT professionals, and data architects
Those in IT departments, finance departments, marketing departments, operations teams, and other departments that seek to transform data into meaningful insights can also benefit from this training
This training will also appeal to those sending and managing large databases, as well as prepping and merging datasets
Through this training, users will learn how to create interactive visuals and reports, analyze data, and share insights with others
In short, this course is an ideal learning experience for those interested in taking advantage of the most up-to-date analytics technology

Learning Objectives of Microsoft Power BI Desktop (On-premise version)


Microsoft Power BI Desktop (On-premise version) training enables users to gain an in-depth understanding of the features and functions of the analytical software program. This training will teach learners how to use Power BI Desktop to create complex visualizations, analyze data, and share insights with stakeholders. Objectives of this training include:
1. Understanding Power BI Desktop’s core concepts
2. Developing data models and visualizations
3. Automating Power BI reporting
4. Integrating with other data sources
5. Analyzing data with DAX
6. Publishing and sharing insights with stakeholders
7. Troubleshooting and optimizing performance

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?
on Trust Pilot
Student Name Feedback
Jave Javier
United States
A1. Raj has been really helpful in explaining further the training topics ensuring that the attendees understand the concepts. He may want to check in with the participants about the effectiveness of the topics being delivered.

FAQ's

You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, we do offer corporate training More details
You can pay through debit/credit card or bank wire transfer.
Yes, course requiring practical include hands-on labs.
1-on-1 Public - Select your start date. Other students can be merged.
1-on-1 Private - Select your start date. You will be the only student in the class.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes.You can access courseware for most vendors.
You can request a refund if you do not wish to enroll in the course.
Yes you can request your customer experience manager for the same.
We use the best standards in Internet security. Any data retained is not shared with third parties.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, we do.
Yes you can.
Yes, we do. For details go to flexi
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however,it takes 48 hours for the money to be moved.
Yes, if we have an office in your city.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
After you submit your payment, you will land on the payment confirmation screen.It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
Yes, fee excludes local taxes.
Yes, we do.
Yes, Koenig Solutions is a Microsoft Gold Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1 on 1 Public you can select your own schedule, other students can be merged. Choose 1-on-1 if published schedule doesn't meet your requirement. If you want a private session, opt for 1-on-1 Private.

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)