Microsoft Power BI Desktop (Basic)
[2024] 5 Sep
1 Day
COURSE OBJECTIVE
Microsoft Power BI is a tool that helps in managing, analyzing, summarizing, and creating interactive reports or dashboards from large amounts of data from various data sources. These reports and dashboards can be viewed in real-time from any device, whether it is a PC, mobile, or tablet. Additionally, they can be shared with others to aid in business decision-making. This course is designed to teach all aspects of using Power BI through practical exercises, from the basics to publishing reports to the cloud.
COURSE OUTLINE
Introduction to Microsoft Power BI
- Getting to know Power BI
- Familiarizing with various Power BI products
- Power BI from Ms. Excel files
- Power BI Desktop
- Power BI Service
- Power BI Gateway
- Power BI Mobile App
- How to download and install the free Power BI Desktop program
- Overview of using Power BI Desktop
Importing and Connecting to Various Data Sources
- Importing data from files such as Microsoft Excel, Text File/CSV
- Importing data from databases such as Ms. Access, SQL Server
- Importing data from files in a folder
- Importing data from the web
- Creating your own data by creating new tables
- Refreshing data
- Basic data transformation to make it ready for use
Data Model Management
- Formatting data
- Creating and managing relationships
- Performing calculations with DAX (Data Analytic Expressions)
- Creating calculated columns
- Creating calculated measures
- Using Time Intelligence
Creating Interactive Reports
- Creating and using visualizations such as Card, Table, Matrix, Map, and various Charts
- Formatting numbers, fonts, sizes, colors, legends, headers, etc.
- Filtering data using Tile, Slicer, Basic Filter
- Sorting data
- Drill Down
- Configuring report display settings for mobile phone viewing
Publishing Reports to the Cloud for Mobile Viewing
- Introduction to using Power BI services on the Cloud (Power BI Service)
- Registering for Power BI Service
- Uploading data from Power BI Desktop to the Cloud
- Customizing reports in Power BI Service
- Creating and managing dashboards
- Exporting to PowerPoint files
- Publishing reports to the web
- Installing and using the Power BI Mobile App
- Viewing dashboards or reports on mobile devices
WHO SHOULD ATTEND
- Individuals who want to start learning about Business Intelligence
- General users who have some basic knowledge of Excel or PivotTable
- Those who work in data management, data analysis, and report summarization
- Executives who need to view data for decision-making
- Business Analysts & Data Analysts