Scheduled maintenance: Thursday, January 26 from 6PM to 7PM PST
Upgrade to remove ads
Only $35.99/year

Quiz 1

Terms in this set (80)

According to the MAD framework - what is best for analysts and managers?
Contributing metrics - dimensional data
Where should the logo go on your dashboard?
Upper left corner
How many visualizations should ideally go on a single dashboard? How did we pick this number?
7-14, Human memory statistics
Which of the following was NOT a dashboard pitfall?
Utilizing an insufficient number of colors
How many data visualizations are available in powerBI
31, plus marketplace options
Considering interactions, what are some ways we can accommodate their impact?
Choose appropriate labels, disable interactions where appropriate, use measures.
What type of file is a powerBI theme?
.json
Which of the following is NOT a typical reason to apply a theme to your powerBI file?
Simplify understanding
What are the typical reasons to apply a theme to your powerBI file?
Ensure good dashboard appearance, minimize nuance between design/builders, brand consistency.
What type of files are NOT powerBI theme
.csv, .xls, .pbix
What are examples of dashboard pitfalls?
Introducing meaningless variety, exceeding the boundaries of a single screen, displaying excessive detail or precision
Which is not a type of measure we discussed?
Calculated
What does DAX stand for?
Data analysis expressions
What does M stand for?
Power Query M formula language
What is Dax
Analytical engine in PowerBI
What is M?
Data transformation engine
Which is best to summarize data from across multiple rows in a dataset?
Measure
Which is best to summarize data from across multiple columns in a dataset?
Column
When working on our airline data - we discussed ways to change how our data "looks" which technique did we discuss?
Adjusting axis start and end values
Which data model is frequently used in PowerBI
Star Schema
What is characteristic of a fact table?
Tall and skinny
What is the best data type for joins?
Int
How many ways did we discuss to create relationships in the lecture?
2
What is data visualization?
Charts, graphs, matrix/pivot
Why do we visualize data?
To highlight trends, identify outliers, summarize data
IaaS
Infrastructure as a Service
PaaS
Platform as a Service
SaaS
Software as a Service
Microsoft Certification Structure
MCSA --> MCSE --> MCSD
MCSA
Microsoft certified solutions associate.BI Reporting. Demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert
MCSE
Microsoft Certified Solutions Expert. Data Management and Analytics - This certification is for those intending to build a career in data management and analytics. MCSE certification addresses a wide spectrum of fundamental technical concepts, assesses and validates your core technical knowledge, and enhances your technical credibility..
MCSD
Microsoft certified solutions developer
How is PowerBI Delivered?
Free (consumer), Pro (business grade), Premium (dedicated capacity)
What is Office 365, (O365)
SaaS solution for homes and businesses. Includes: OneDrive, SharePoint, Skype, Teams, Dynamics 365 and more
Tenants and instances are:
impermeable buckets (mostly)
How many types of data can be consumed in PowerBI
70
Common types of data consumed in PowerBI are:
Excel, Text, CSV, XML, JSON, OData, Sharepoint, SQL, Oracle, Access, Salesforce, Mailchimp
What data belongs on your dashboard?
MAD Framework - The Data warehouse institute
MAD
Monitor, analyze, detail
How do levels between MAD go together?
At monitor level top 4-10 summary level KPIS, at analyze level supporting 10 KPIS per monitor KPI , At details level supporting 10 metrics per analyze KPI
Measure types:
Direct, composite, derived, correlated
Direct
Measure type that repeats every level (sum by row, by dept, by company)
Composite
Combination of lower level measures but not in directly mirrored way across (multiplication or division of measures)
Derived
Similar to direct but can't be done perfectly so has band-aid anomaly (i.e difference in calculating sales between departments) - opportunity to fix business process around calculation.
Correlated
Low level metrics influence high level metrics but cannot roll up
KPI
summary of 1 or more measures
Traceability
All KPI's are measures but not all measures are KPI's
How many kinds of interactions are there?
2, Filter and highlight
What is DAX used in?
Microsoft SQL Server analysis services (SSAS), power pivot in excel and powerBI Desktop
What is M used in?
Power Query and Query Editor
When should we use DAX?
When you want changes to the dashboard (such as interactions) to influence the outcomes. Similar to excel but much more powerful
When should we use M?
When you want to rearrange or transform your data. It is your ETL tool.
What is a table?
A collection of rows and columns that represent a dataset. Can be generated using M or DAX.
What is a column?
Stores a computed value, directly influences refresh time and impacts every row. (Vertical) EX: Lookup value similar to vlookup.
What is a measure?
Rows we add to the "bottom" of a dataset, to summarize data. These don't exist for individual rows in our dataset but are an aggregate of information across all of our rows. Does not store any value until they are placed on the canvas. EX: Calculate, sum.
Normalized data / snowflake model
- Strict rules
- Not friendly for end users
- Many joins
- Joins are "expensive" in powerBI
- Best for dimensional analysis
Star Schema
- Less strict
- Easier to follow and often results in less joins
- Frequently used in PowerBI models as we often have an idea the planned visualizations
Fact tables
- Frequently include Fact_ in the same (Fact_Sales)
- Generally "tall and skinny" tables
- Get updated every time something happens as part of business as usual (i.e sales transaction)
- Connected with an int surrogate key
Dimensions tables
- Frequently include Dim_ in the name (Dim_products)
- Generally short and fat tables
- Have the granular details about a product/service/employee
- Connected with an int surrogate key
Are all joins created equally?
No
Joins
Join on INT if you can
Join on Date if you must
avoid the rest
What is time intelligence
PowerBI natively knows some things about time such as sort order, spacing between days in a visualization, and comparing against other time periods. Ex: date hierarchies, appropriately distributed events across time, same period last year.
Frequently used tools
PowerBI, Spotfire, Tableau, Splunk, GIS platforms
Tool in the cloud
Becoming the most common approach
Tenant
Big container, usually one per company
Individual apps (SharePoint Online, Teams, PowerBI)
Can exist more than once within a tenant and are typically referred to as instances though some apps use special names -- I.E PowerBI Workspaces
Features included in PowerBI Desktop
Ribbon, Visualization pane, Fields pane, Filter pane, View icon (report, View icon (data) View icon (relationships), Canvas, Pages.
(MAD) Monitor's target audience, goal, and data type
-Executive
-Actionable metrics
-Graphing and visual data
(MAD) Analyze's target audience, goal, and data type
- Analyst
- Contributing metrics
- Dimensional data
(MAD) Detail's target audience, goal, and data type
- Worker
- Detail metrics
- Transnational data
What can a theme control?
Just about everything - most commonly data colors
How do i make a theme?
It is a JSON file
When working on visualizations during the 2nd lecture assignment, what had the greatest influence on getting the "right" picture in our graphs?
Setting data types
O365 is what kind of offering?
SaaS
Which of the following is not a PowerBI License
Premium
Which of the following is NOT a data visualization tool?
Node.JS
**Which of the following is a challenge specifically associated with on-premise BI tool architecture?
Difficult to keep up to date
What is the "entry" level Microsoft certification related to PowerBI
MCSA
**How many exams are required to become "MCSE: Data Management and Analytics"
2
**Which of the following is the correct list and order of cloud services (least to most cloud based)?
IaaS, PaaS, SaaS
Students also viewed