We live in the times of ever-expanding data due to this analytics is a necessity.
Why Power BI
It makes machine learning accessible to end-users. There is no need-to-know complex coding if you are not a technical person. It is a cloud-based service so you can create a report on the go. It is very affordable compared with other tools in the market.
What is Power BI
It is a self-service Business Intelligence tool. It has great capabilities. It lets you Aggregate, Analyze, Visualize and Share the data as reports.
Elements of Power BI
Power BI desktop
It is a free application that can be installed on a local computer that lets you connect to, transform, and visualize data.
After transforming or editing your data in power query, you will be able to create effective reports and visualization.
Relationships can be created between different tables with primary key and foreign key.
When you load up the data in Power BI you will be seeing a blank screen.
This is where you create dashboards.
This gives you a preview of how data looks now.
It lets you customize in such a way that you can meet your business needs more effectively.
DAX is in-built function which is the formula language that is used by Power BI. You can perform various actions on the data in tables with the help of DAX.