Power BI was Launched in 2014. It is a very power full tool that allows ETL, modeling, analysis, presentation and sharing. Using Powe BI does not require to learn a new language or scripting skills.
Everything you do in Power BI can be broken down into a few basic building blocks.
- Visualizations (Graphs, charts, maps etc)
- Data sets (collection/combination of data used to create visualizations)
- Reports (collection of visualizations that appear on one or more pages and then arranges)
- Dashboards (contains pages or set of visualizations on single page called canvas and can be shared)
- Tiles (single visualization found in a report or dashboard)
Underlying Technologies of Power BI
Following technologies are used underlying in Power BI for different operations
- Query/Table –> Power Query
- Model –> Power Pivot
- Presentation –> Power Map
- Sharing –> Dashboards
- Analysis –> Charts/Machine learning
Architecture of Power BI
Power BI has two architectural components
- Power BI desktop (Desktop application for creating reports and visuals)
- Power BI service (SaaS for sharing and collaborating the reports and dashboards)
Starting with Power BI
To start with power BI you would require office 360 account that can be created with your organization email. Then login to Power BI website to configure the service and download the desktop application as well. There is lot of work being done by Microsoft and community to add more and more features, visualizations and options in the tool. These additions may be included by regular updates provided.