What is the Power BI and what is it used for?

Business analytics Solution that lets you visualize your data and share insights across your organization or embed them in your application or website.

Visualization example

Connect to hundreds of data sources and bring your data life with live dashboards and reports.

Get Data — I

You can connect to your databases from Get data section and upload your tables and observe relationships between them. You can also import Excel, Text, XML, and CSV files.

Get Data — II

There are multiple Power BI products. I use both web and desktop product.

You can download here Power BI Desktop.

Power BI Desktop | Microsoft Power BI

Recommend Hardware for Power BI Desktop:

• Available RAM 1.5 GB + recommended(1 GB minimum)
• CPU: 1 GHz or faster x86, or x-64
• Display : 1440 x 900 or 1600 x 900
• Display setting for text: 100 % less
• Windows 7 / Server 2008 R2 or later
• .NET 4.5

Menu

Relationships

Data

Report-I

Report — II

You can create a report with visualizations and also you can modify and print a report.

You can download and use a custom visual from the gallery.

Marketplace

Power BI Web View

Create app workspace — I

Create app workspace — II

After creating Workspace, you will see a screen.

Workspace

You can create Dashboard, Report, Dataset, Streaming dataset and Dataflow.

Create

Get Data

You can get Samples, Partner Showcase, Service Content Packs and more ways to create your own content.

Samples

Service Content Packs

Files

Databases

Note: I tried and used trial version.

My Workspace

(Sales and Marketing Sample)

Click More Options

You can go to the report, open in focus mode, export to Excel and more options.

Datasets

You can create a report from Datasets.

Sample Report — I

You can export to PowerPoint, publish to web, embed and rename and delete your reports.

Sample Report — II

You can Pin a report tile to a dashboard, pin a live report page to a dashboard, pin a tile from another dashboard.

Pin

You can share your reports.

Share

You can generate QR Code.

QR Code

Personal Storage

I told about web and desktop product of Power BI. Briefly, I will mention its features.

-Power Query to extract and transform.

-Power pivot to model and analyze.

-Dashboards, reports, and datasets are at the heart of Power BI.

-Interactive reports and geo-map visualizations.

-Consistent reporting and analyses.

-Three separate national cloud data centers.

-Excel spreadsheets, Github mail chimp, Sharepoint and google analytics.

-Managers simply need to create an API KEY, Power BI will feel natural as it integrates easily with office 365 groups and Microsoft teams.

-Simple to use.

-Fast turnarounds and low costs.

-Constant innovation.

Who can Use it?

• IT Professionals
• Business analysts
• Users

You can learn more here..

Power BI | Interactive Data Visualization BI Tools

Hopefully, it benefits you..