Turn data into actionable insights
Inform decision making
Compelling narrative and accessible information
4 of 24
Dashboard
A single-page collection of visuals built from a report
5 of 24
Reports
A collection of visuals built from a dataset. Can span several pages
6 of 24
What is the common flow of activity in Power BI?
Bring data into Power BI Desktop
Create a report
Share it to the Power BI service
View and interact with reports and dashboards in the service and Power BI mobile
7 of 24
What is a collection of ready-made visuals, pre-arranged in dashboards and reports?
An app
You can get apps that connect to many online services from the AppSource
8 of 24
What allows you to shape your data?
Power Query
9 of 24
Examples of Shaping Data
Promote First Row as Header
Rename columns
Remove top rows
Remove columns/ remove other columns
Pivot/Unpivot Columns
10 of 24
Can you edit Query names in Power Query?
Yes
11 of 24
Can you replace one value in a cell in Power Query?
In Power Query, you can't select one cell and change one value, like you might have done in Excel.
12 of 24
What can you do with null values in your data?
You can change them to 0 so that averages can calculate correctly.
13 of 24
In what instances is removing duplicates useful?
You can copy a query table, and then remove duplicates to create a unique set of values e.g. for a look up table.
14 of 24
Why is it useful to use spaces instead of underscores for naming conventions?
Easier for Natural Language queries in Power BI
15 of 24
Does Power BI capture the whole data source when looking at column profile, distribution or quality?
No. The default is 1000 rows but you can reset to capture entire table.
16 of 24
What is the impact of incorrect data types
Unable to create hierarchies e.g. dates
Creating proper relationships in tables
Unable to create calculations
17 of 24
Where can you change column data type?
Home - Transform (PowerQuery)
Select Icon next to the column header
18 of 24
How can you combine multiple tables?
Append or Merge
19 of 24
What happens when you append tables?
Rows are added as long as the data contains the same column structure (Concatenate)
You can append multiple tables (more than 2)
20 of 24
What happens when you merge tables?
Columns are added, and there must be a column that is the KEY. Similar to Join.
21 of 24
Can you append queries as new?
Yes. You can either append or append queries as new (creates new table)
22 of 24
Explain the following Joins?
Left
Full
Inner
Left- Displays all rows from the first table and only the matching rows from the second.
Full - Displays all rows from both tables.
Inner - Displays the matched rows between the two tables.
Traditional thobes are typically made from lightweight fabrics such as cotton or linen, ideal for the region's hot climate. However, modern variations may alhaq thobes feature luxurious materials such as silk or satin, offering a more refined and contemporary look.
Comments
Report