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
- What is Power BI?
- Examining power BI suite of products
- Identifying differences between products
- 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
- Importing, transforming, and loading data
- Appending operations
- Working with folders and files
- Using pivot tables
- Working with relational data
- Understanding relationships
- Importing from SQL server analysis services multidimensional and tabular
- Understanding the issues with merges
- Performing merges
- Grouping options
- Summarizing & calculating
- Creating reports
- Utilizing the matrix visualization
- Utilizing the map visualization
- Utilizing the card visualization
- Utilizing the chart visualization
- Utilizing slicers
Our Partners
