Notes on Power BI Lecture

Introduction

What is Power BI?

• Developed by Microsoft
• Data visualization platform for business intelligence (BI)
• Designed for business professionals with various data knowledge levels
• Capable of reporting and visualizing data in multiple styles: graphs, maps, charts, scatter plots, etc.

Main Features of Power BI

1. Visualization Tool: Suitable for company, school, and college data
2. Comprehensive Dashboard: Integrates data from various sources
3. Extensive Functions and Charts: Over 1200 functions and 280 charts available
4. Data Connectivity: Connects to 100+ data sources such as CSV, SharePoint, Outlook, and websites
5. Recognized by Gartner: Trusted BI tool with significant recognition

Components of Power BI

1. Power Query

   • Data connectivity tool to discover, connect, combine, and refine data sources
   • Can be downloaded as an Excel add-in or used in Power BI Desktop

2. Power Pivot

   • Data modeling technique for creating models, relationships, and calculations using Data Analysis Expression (DAX)

3. Power View

   • Tool for creating interactive charts, graphs, maps, and other visuals
   • Can filter data for each visualization element or the entire report

4. Power BI Services

   • Platform to collaborate on reports and dashboards with colleagues, offering shared workspaces

5. Power BI Desktop

   • Integrated development environment for building advanced queries, models, and reports

6. Power Map

   • Visualize geospatial data in 3D based on geographical location using Bing Maps

7. Power Q&A

   • Natural language processing tool to ask questions and get visualized answers, e.g.,