Power BI Quiz 2

What file format are themes?

JSON

What are some frequently used data visualization tools?

PowerBi, Tableau, Spotfire, Splunk, GIS Platforms

What are the prefixes for the tables used in a star schema?

- Fact Tables include Fact_ in the name (Fact_Sales) - Dimension tables include Dim_ in the name (Dim_Products)

Where is DAX used?

- PowerBi desktop, Power Pivot in Excel, Microsoft SQL SSAS - Changes to the dashboard - To analyze data

Your organization purchased premium capacity - how many refreshes per day would you expect that you can setup?

48 a day

Using the MAD model, what type of metric is best for managers?

Analyze

How many rows does PowerBI assess by default to determine data type for a column?

First 200

How many metrics should ideally appear on a dashboard?

5-7 (but 7-14 is the original idea)

What license would you recommend for a client who is very focused on data security and prefers to keep most of their data on premise?

Power Bi Premium comes with the Power Bi Report server, which is an on-premises server that allows the deployment and distribution of interactive Power BI reports and traditional paginated reports completely within an organization's firewall. I would recommend the client to purchase the premium license.

Who can see "Datasets" within a PowerBI Workspace?

- Anyone with Build permission - Build permission is set in the Power BI service, after publishing. - If work is saved to a classic workspace only members who have access to the workspace where a report is published can access its dataset using a Power BI service live connection

Where is M used?

- Language to transform data Ex. pivot/unpivot - Used in Power Query and Query Editor

How did we describe "good questions" for interviewing our client?

- Questions that will determine the business problem you're there to solve; cannot be answered by data provided or questions about the data set provided - Open ended questions

Why use measures vs built in aggregation capabilities?

- Using measures is better for finding specific metrics you want - Is a different method of filtering - Won't have to use slicers as much

What is the authentication method when setting up credentials for SPO scheduled refresh?

0auth2

What level of access is required to setup Scheduled Refresh for a dataset?

Admin

What types of data can PowerBI read from SharePoint?

Connect to Lists as a data source for reporting (lists are like online excel files)

Which table in a star schema is "short and fat"? "Tall and skinny"?

Dimension tables are short and fat, Fact tables are tall and skinny

Should the DAX filter expression for Row Level Security equate to TRUE or FALSE for rows that you want hidden?

False for the rows you want hidden

How do you enable Usage Metrics?

Go to Workspaces and select any workspace then go to Dashboards tab and then click on Usage metrics icon from Actions. Once prompted, you can select view usage metrics button. Or, you can go to workspace and from Dashboard section, click on dashboard to open it then click on Usage metrics

What is used in the event that you have data on-premise that you want to use PowerBI web to visualize and refresh?

Have admin privileges and use the Refresh Now option (Not Sure)

Most efficient data type to join on?

INT if you can, Date if you must, Avoid the rest

Why might you need a date table if your data already has dates in it?

If you want a date mapping table that determines which buckets each day is part of

What does IaaS stand for?

Infrastructure as a Service

Can anyone who is able to read the report also refresh the dataset on demand?

Only admin can use the refresh now

Where are the roles setup for Row Level Security?

Power Bi Desktop → Modeling → Manage Roles Box

When connecting to SharePoint data from PowerBI, what was specific about the URL that we provided in the Get Data process?

SITE URL - not list URL

What is the mapping table called where we list the alternative names for a field that natural language query references?

Synonyms

Related to Office 365, what are the containers that each organization (typically) has only one of and contains all their O365 content (PowerBI, SharePoint, Exchange, Skype, etc)?

Tenant

You have a dataset with a zip code column - what might you want to consider about this numeric column when loading your data?

Turn it into text because the zip code may be summarized? (Don't know)

What do we call the container within PowerBI where we upload Reports and can enable sharing with others?

Workspace

Where are users assigned to specific roles for Row Level Security?

Workspace → Dataset → Security → Select Roles and Add Members

Can you subscribe others to PowerBI report and/or dashboards?

Yes but not if using Row level security (RLS)

Can you share a single report with someone?

Yes, through publishing to Power Bi Desktop

Where can you copy and paste M language into if you found an example online? Or must you re-create every step by hand?

You can copy past M language into the query editor

Using Natural Language Query, were we able to specify the visualization type we wanted? If so, how?

You can specify which visualization type you want by typing "as a 'visualization wanted'"

Which license is required to use the PowerBI Mobile App?

pro

What does "allexcept()" actually do?

removes any filter from a table apart from the columns that you are explicit about, using them as parameters

What does unpivot do?

removes any filter from a table apart from the columns that you are explicit about, using them as parameters

What were some resources we discussed to help pick the most appropriate type of visualization?

sqlbi, datavizcatalogue, perceptualedge