Visualize This!
This type of Tableau chart is ideal for showing how individual parts contribute to a whole, often used for financial or categorical breakdowns.
What is a pie chart?
This Excel function helps you quickly combine first and last names into a single cell -- no manual typing required.
What is CONCAT (or Concatenate)?
This SQL command retrieves data from a database--it's the bread and butter of every query.
What is a Select statement?
When developing a report or dashboard for an operational review, the first step is identifying this--the group or leader whose decisions the insights are meant to inform.
Who is your stakeholder?
When presenting to leadership, this communication technique states that you should start with a clear, concise summary of your key takeaways before diving into the details.
What is Answer First Communication?
This Periscope supported business lane is based in Team Music City. They emphasize support for Acutes and Hospitals, SNFs, and Hospice care, often working directly with Field ROPs.
Who is Skippers?
What purpose does the Jack O Lantern serve?
What is to scare away evil spirits?
This Tableau feature allows you to create reusable fields with formulas, helping to standardize KPIs across dashboards.
What is a calculated field?
When you need to summarize large datasets--for example, total claims by region-- this Excel feature is your go-to.
What is a Pivot Table?
This identifier is created by the user and serves as a nickname for a table, column, or field.
What is an alias?
An operations leader emails you asking for a "quick turnaround" data pull that doesn't align with your current priorities. The best first step is to do this before saying yes or no.
What is clarify the request's purpose and urgency (or ask how it supports business goals)?
What is another name for the Answer First Method?
What is the Pyramid Principle?
If you were looking for documentation concerning your treatments with DaVita, this Periscope supported team would take your request, verify compliance, and provide it. They also spend significant time verifying the accuracy of documentation so that it may be properly billed.
Who is HIPsters?
The tradition of carving pumpkins originally started with this root vegetable before immigrants in America swapped it out.
What is a turnip?
When your data updates weekly but you don't want to rebuild your workbook/dashboard, you can take this action to ensure your visuals automatically update
What is publish to the Tableau Server?
You're troubleshooting why your VLOOKUP isn't working. You realize it's because your lookup value isn't in the first column of your table array. This newer function solves that problem.
What is XLOOKUP?
You're analyzing patient claims and want to match facility data to revenue records based on FACILITY_ID. This SQL operation makes it possible.
What is JOIN (or INNER JOIN)?
This common challenge in stakeholder management can often happen when the business problem and parameters are not clearly defined.
What is scope creep?
According to the Pyramid Principle, how many supporting points should you have to support your main argument?
What is 3 to 4?
This Periscope supported team is based out of Team Evergreen and is responsible for managing provider webs, scanning documents into electronic imaging system, and posting payments to the appropriate claims.
Who is Team Vault?
This actress plays Eleven in the hit spooky Netflix series Stranger Things?
Who is Millie Bobby Brown?
You're building a dashboard and want to see how a 2%, 5%, or 10% change in reimbursement rates would affect yield. This Tableau feature lets users adjust those values directly and see results update live.
What are parameters?
To automate repetitive tasks like formatting, data cleaning, or creating dashboards, you can use this Excel feature to record your actions and play them back later.
What are Macros (or VBA Macros)?
To calculate total revenue by region while excluding any NULL values, you might use these two SQL clauses in your query.
What are Where and Group By?
Midway through a project, you realize your timeline will slip due to a data dependency. The best way to maintain credibility with leadership is to do this early.
What is proactively communicate risks or delays (expectation management)?
When sending out Recap notes following a meeting, what is the most important thing to include?
What are Next Steps (Action Items)?
This periscope supported team has a mission of building and strengthening strategic relationships with government payors and agencies
Who is GPA?
Where is the oldest Halloween Festival held?
What is Derry, North Ireland?
When optimizing performance in Tableau, this best practice reduces load time by preventing data refreshes while visualizations are being built
What is pausing data updates/refreshes?
You're spending hours cleaning messy revenue data before analysis. This feature, available under the Data tab, can automate the process by transforming and loading data efficiently.
What is Power Query?
You're comparing current-month claims against the prior month's totals, but you don't want to create a separate table. Embedding one query inside another query inside another query allows you to accomplish this.
What is a Subquery (or nested query)?
This consistent habit done by both the analyst and stakeholder allows for alignment on the business problem, tracks historical actions taken, and provides visibility to all teammates involved.
What is documentation?
This type of analytics involves recommending specific actions to achieve a desired goal or optimal course of action.
What is Prescriptive (Diagnostic) analytics?
This team’s scope includes facilitation, coordination, and research of Setup Nautilus enhancements and defects, Nautilus metadata implementation and maintenance, ePREMIS maintenance, and Chargemaster management.
Who is Lighthouse (Release Management)?
The Michael Myers Mask is built on another face from the world of Pop Culture. Whose face is it?
What is Captain Kirk/William Shatner?