.
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.
The parts of Power BI
Power BI consists of several elements that all work together, starting with these three basics: A Windows desktop application called Power BI Desktop. An online SaaS (Software as a Service) service called the Power BI service. Power BI mobile apps for Windows, iOS, and Android devices.
Get Power BI Desktop
With Power BI Desktop, you can build advanced queries, models, and reports that visualize data. You can also build data models, create reports, and share your work by publishing to the Power BI service. Power BI Desktop is a free download.
To get Power BI Desktop, you can use one of the two approaches.
- Install as an app from the Microsoft Store.
- Download directly, as an executable you download and install on your computer.
Workbook B:
Get started with Power BI Desktop
This tour shows you how Power BI Desktop works, what it can do, and how to build robust data models and amazing reports to amplify your business intelligence.
Workbook C:
GETTING STARTED WITH POWER BIConnect to data in Power BI
CONCEPT
TUTORIAL
Refresh data
CONCEPT
Incremental refresh for datasets
What are commonly used data sources?
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
What is an example of a public data set that is commonly used in data analysis?
https://rpubs.com/chiragrpatel/titanic
What is the data source format available for this public data set?
How do we connect Power BI to these data sources?
1) Manual Entry
2) Web
4) CSV
5) JSON
6) XML
7) SQL
Transform and shape data
OVERVIEW https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview
TUTORIAL https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
CONCEPT https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-common-query-tasks
HOW-TO GUIDE https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics
0 Comments