What Is Power BI?
Power BI is a business intelligence and data analytics platform used to connect data from different sources, prepare and transform that data, create data models and build interactive reports and dashboards.
How Power BI Is Used for Data Analytics
A typical Power BI workflow starts by connecting to a data source. The data can then be cleaned and transformed, organized into a useful model and represented through appropriate visualizations.
Power BI Data Sources
Power BI can work with sources such as Excel files, CSV files, SQL databases and web-based data sources.
Power Query
Power Query is used for preparing data. Common activities include cleaning values, changing data types, removing duplicates, replacing values and transforming columns.
Data Modeling
Data modeling involves organizing tables and defining relationships between related data. A good model helps reports use information from multiple tables correctly.
Power BI Visualizations
Power BI provides visual tools such as bar charts, line charts, tables, cards and other report visuals. The appropriate visual depends on the analytical question.
Interactive Power BI Reports
Power BI reports can include filters, slicers, drill-downs and other interactions that allow users to explore data instead of viewing a static report.
Power BI for Data Analytics Course
This interactive Power BI course focuses on the practical workflow of connecting, cleaning, modeling, visualizing and communicating data. DAX is intentionally not included in this course and will be taught separately.