Lesson finished
Up next: Power Query Editor, Data Connectors and Basic Table Transformation
Unlock all 27 lessons of Effective Dashboards using Power BI for Construction ManagementFull course ₹40,000 · paid
Why Power BI: Installation, Desktop Views and Gartner Leadership
A free lesson from Skill-Lync's Effective Dashboards using Power BI for Construction Management course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Week 1 Session 2”
What will you learn in this free Effective Dashboards using Power BI for Construction Management lesson?
Explains what Power BI is, why it offers low cost and strong value, and how it connects to many data sources with ETL and DAX. Covers its Gartner leader position, two ways to install Power BI Desktop, and the Report, Data and Model views.
- Why organizations choose Power BI
- What ETL and DAX mean in Power BI
- Two ways to install Power BI Desktop
- Report View, Data View and Model View
What comes after lesson 2?
The next free lesson is lesson 3, “Power Query Editor, Data Connectors and Basic Table Transformation” (11 min). Later in Skill-Lync's Effective Dashboards using Power BI for Construction Management course (paid): lesson 4, Week 2 Session 1; lesson 5, Week 2 Session 2; lesson 6, Week 2 Session 3. The full course has 27 lessons (7 h 26 min of video); see the course overview or its price and syllabus.
Lesson transcript
Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.
Hi all. Welcome to Effective Dashboards using Power BI. Week 1. Introduction to Power BI. A small recap in our Week 1, Session 1. We have discussed Introduction to Business Intelligence. What are the various functionalities of Business Intelligence? What are the various products available within the Business Intelligence Platform? and we have done the comparison of those platform. In this week, we will talk about Power BI. Why Power BI? How do we install Power BI Desktop on our laptop or desktop? What is Power BI Query Editor? What are the various types of Power BI Data Connectors available? And we will have a small basic table transformation demo.
In this course, we will learn the basic introduction about Power BI and Power Query Editor, which is also called Transform Data. We also learn why Power BI is the leader of Business Intelligence Tool and the user interface of Power BI Desktop. Moving on, we will talk about Power BI. What is Power BI? Power BI is a product from Microsoft. It is a business intelligence product which includes both desktop and web-based application for data loading, data modeling, and visualizing the data. It is available at a cloud-based business analytics services gives a single view at your most critical business data.
So why Power BI? So why Power BI? So it's a rock-bottom cost and fantastic value. In our session 1, when we compared the various BI products, we have seen Microsoft Power BI comes with low cost compared to all other BI products. That is why it is rock-bottom cost and fantastic value to the organization. Along with that, we can connect to various data. Along with that, we can connect to various data, millions of rows and records. We can access data virtually from any way like database tables, flat files, cloud services, folders, etc.
and create automated data, etc. And create automated data shaping and loading procedures. Here, the ETL means E for extract, T for transformation, L for loading the data. Using Power BI, we can blend data from various sources with the help of relational models. We can analyze the overall performance across an entire data model by creating a table relationship. We can also define complex calculations using data analysis. In a short form, it is called DAX. With the powerful and portable DAX expressions, we can enhance our datasets and enable advanced analytics.
So what is data analysis expressions or DAX? This is nothing but formulas that we can write it in Power BI desktop. It also follows a similar syntax of Excel formulas. For example, if you select year 2022, you should get 2021 sales dynamically. That is the power of DAX. We can create such formulas in Power BI. Not only these formulas, you can also try to create many other formulas like difference between two dates. You can calculate the dates. You can calculate the dates. You can calculate the date of birth, age. You can calculate the financial summary like year to date, quarter to date, month to date, and we can do lot of cumulatives and many more data calculations using Power BI desktop. That is why DAX has become very powerful formulas in Power BI.
Moving on, we can also visualize data with interactive reports and dashboards. What is interactive report? For example, if you are looking data by year and sales, you want to drill down to the month level or a quarter level. So when you double click on a bar of a year, it will drill down to the month level and quarter level. You can also use one filter to another one, which is interactive. You have a bar chart. Click on a bar. You can filter your line chart. That is why it is called interactive reports and dashboards. We can build custom business intelligence tools with best-in-class visualization and dashboard features.
Not only with the standard visualizations available in Power BI, we can also download the custom visualizations from the marketplace and create the dashboard. Moving on, Power BI is the industry leader among all the BI platforms. Microsoft Power BI is intuitive, powerful, and absolutely free to get started. If you look at this chart, which is a quadrant chart or they call magic quadrant and this is the survey done by the Gartner. This organization every year looks into all the BI products and analytics products provided by various vendors and then they put in these groups.
You see the first group is the challenges, second group is the leaders, third group is the players, and the fourth group is the visionaries. And you see Microsoft is being the leaders for consecutively almost 10 plus years in the industry. That is why Power BI has become more powerful and many organization is trying to adapt Power BI. Moving on, how do we install Power BI desktop in your laptop or your desktop? So there are two methods. Method one, you can go to this website and click on try free and then you can download the Power BI desktop and install the desktop.
Or you can also go to Microsoft store. So you can search for Power BI desktop. This doesn't require any admin privileges. Okay. And you click, it will ask install button here. If it is already installed, you can click open. So I would recommend to install Power BI desktop using Microsoft store. The reason because Microsoft Power BI desktop gets updated on monthly basis or quarterly basis so that you don't need to reinstall the Power BI desktop all the time. It is like our mobile app. How you get the updates. Similarly, when you install Power BI desktop from the Microsoft store, you will get all the future updates automatically. You don't need to install or reinstall.
Moving on, once you install Power BI desktop, you can open using your Windows button. Looking at the workflow of the Power BI or you can call architecture of the Power BI. So in your desktop or laptop, you have Power BI desktop installed. So in Power BI desktop, you can get data from various sources. It can be in the cloud. It can be in a database like SQL, Oracle, MySQL, Amazon Redshift and many others. Or you can have your existing data sets which you can connect through your Power BI desktop. Once you are connecting data to the Power BI desktop, you create your own visualization and you will publish to the Microsoft platform or Microsoft services where the Power BI dashboards can be shared to the end users.
So we may need Power BI gateway when we are connecting to a SQL server within your organization. For example, you are part of skill link and you are connecting to a database which is in the skill link. Once you connect to a database and you create your analysis and you created your visualizations in your Power BI desktop and then you move that file or you publish that file to the Microsoft platform where it needs to know what is the database that has been connected. So that is why you need a gateway to make an entry of your server and the credentials so that Microsoft Power BI service can understand what is the data source.
In simple lame terms, if I have to Like if you are traveling from India to US, you need a immigration center where you will be asked like what is your credentials and why are you traveling to US. The immigration center is nothing but the gateway for you to access or to enter to access the reports. Same way, users, the end users, to access the dashboards which are connected to a database, you need a gateway. Moving on, what is the Power BI interface? After we install Power BI, if you open desktop or BI desktop, you will on your left hand side, you will see three views.
The first one is called Report View, Data View and then Model View or it is called Relationship Views. So what are these views? In Report View, you can build your visualizations, you can arrange them as you want, you can create number of pages, it is like a blank page. Data View, Data View, here you can see all the raw data in the form of columns and rows. In the Relationship View or the Model View, you can see the relationship between two data sets. For example, if you have an employee and department, you can join employee and department using the common column or common key column called department.
So you can see all those relationships in the Relationship View and today it is called as Model View and here is the pictorial references of the Power BI interface. Report View, Data View, Model View. You can see the same thing in your Power BI desktop. So you open your Power BI desktop, you see if you mouse over there, it will also show the tooltip saying this is the Report View, this is the Data View, this is the Model View. These are the three important views that is being used in the Power BI interface.
With this, we will end our Session 2 for the Week 1. Thank you.