Data Science: Getting Started with Power BI
What is Power BI?
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
Power BI also gives you cloud-based BI services, known as “Power BI Services”, along with a desktop based interface, called “Power BI Desktop”. It offers data warehouse capabilities, including data preparation, data discovery and interactive dashboards. In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform which enables the user to analyze data easily, perform various ETL operations and deliver reports with Power BI.
Power BI gateways let you connect with SQL Server databases, Analytical Services, and many other data sources to your dashboard in Power BI and reporting portals, embed Power BI reports and dashboards to give you a unified experience.
In Power BI you can create visualizations such as
- Waterfall chart
- Stacked bar chart
- Scatter chart
- Clustered bar chart
- Treemap chart
Get started with PowerBI
Load your excel sheet
Click on individual field to open the required field for exploration.
Now, lets manage the relationships between the fields. Open the manage relationship tab from task bar which will show output like below:
Once, the relations are maintained, lets generate the model. Open the model generate option in pages tab and it will generate a model.
