Power BI
In-Person/Online
2 Days
English/Arabic
Learning Objectives
Identify what is power BI. Open power BI desktop. Explore how to work with CSV, TXT, and excel worksheets. Apply connecting to databases. Use merging, grouping, summarizing, and calculating data.
In-Person/Online2 Days
English/Arabic
Learning Objectives
Identify what is power BI. Open power BI desktop. Explore how to work with CSV, TXT, and excel worksheets. Apply connecting to databases. Use merging, grouping, summarizing, and calculating data.
Modules
Module 1: Power BI
What is Power BI?
Examining power BI suite of products
Identifying differences between products
Module 2: Power BI Desktop
- Installing power BI desktop
- Exploring the power BI desktop interface
- Utilizing file types; PBIX vs PBIT
- Examining data sources
- Discussing data refresh
- Understanding data types
Module 3: Working With CSV, TXT and Excel Worksheets
- Importing, transforming, and loading data
- Appending operations
- Working with folders and files
- Using pivot tables
Module 4: Connecting to Databases
- Working with relational data
- Understanding relationships
- Importing from SQL server analysis services multidimensional and tabular
Module 5: Merging, Grouping, Summarizing, and Calculating Data
- Understanding the issues with merges
- Performing merges
- Grouping options
- Summarizing & calculating
Module 6: Reporting
- Creating reports
- Utilizing the matrix visualization
- Utilizing the map visualization
- Utilizing the card visualization
- Utilizing the chart visualization
- Utilizing slicers
Our Partners
