What is Microsoft Power BI
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence
... [Show More] capabilities with an interface simple enough for end users to create their own reports and dashboards
Power BI hardware recommendations
CPU 1 GHz +, 32 or 64 bit
Resolution 1440 x 900 or higher
Display text 100% or less
3 versions of Power BI
Power BI, free
Power BI Pro
Power BI Premium
Software requirements
.NET 4.5 or later
Windows 7 or later
Fully updated web browser
3 steps using Power BI
Get data, model data, create data visualizations and reports
What do you need to connect to a database on premise for getting data
power bi gateway
Apps for the power program are available from where?
Appsource
How can a user create a refreshable data source?
Putting the file in the cloud. Pushing data into cloud storage (OneDrive for business, OneDrive personal, SharePoint library/list) will make the data refreshable
You've loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.
Delete the reports and dashboards
The common flow of activity
1. Bring data into Power BI Desktop, and create a report.
2. Publish to the Power BI service, where you can create new visualizations or build dashboards.
3. Share dashboards with others, especially people who are on the go.
4. View and interact with shared dashboards and reports in Power BI Mobile apps.
Basic building blocks of Power BI
1. Visualizations
2. Datasets
3. Reports
4. Dashboards
5. Tiles
Visualization
a visual representation of data, like a chart, a color-coded map, or other interesting things you can create to represent your data visually
Dataset
the complete set of raw data, for all observational units and variables, in a survey or experiment
Data connectors
Whether the data you want is in Excel or a Microsoft SQL Server database, in Azure or Oracle, or in a service like Facebook, Salesforce, or MailChimp, ____ has built-in data connectors that let you easily connect to that data, filter it if necessary, and bring it into your dataset.
Dashboard
A collection of visuals from a single page that you can share with others. When you're ready to share a single page from a report, or a collection of visualizations, you create a _____.
Apps
An easy, quick, popular way to create visuals.
A collection of preset, ready-made visuals and reports that are shared with an entire organization [Show Less]