Posts filed under Power BI

(Livestream Replay) Design Thought Process for Power BI Reporting - with Miguel Myers

ABSTRACT 📝

Visualizing large amounts of data can be overwhelming and frustrating regardless of one’s skill level, so imagine how frustrated and exhausted the viewing audience can become when trying to interpret complex visuals. In the absence of strategic thinking, Reports can become so overloaded that designs are easily rejected by wearisome and disappointed customers. It's imperative that designers embrace and implement Strategic Thinking to extrapolate critical factors to be presented in the creation of a successful report. By embracing a strategic methodology, we’re able to find solutions to problems, and even alternative solutions that may have gone unnoticed initially. This session will provide a more structured approach and help you to realize your own strategic thought processes that are comfortable for you through the way I personally take.

GUEST BIO 👤

Miguel Myers is a Senior Program Manager on the legendary Power BI Customer Advisory Team at Microsoft. Miguel is highly regarded and accomplished Business Intelligence Professional, Graphic Designer, and Data Scientist with a demonstrated history of success in the business analytics industry, skilled in Business Intelligence, Data Science, Marketing, and Graphic Design. His role at Microsoft is to evangelize the use and best practices of Report Design and Data Visualizations in Power BI.

RELATED CONTENT 🔗

Miguel’s LinkedIn

Calculating the Top Name & Value Using [DAX] in Power BI

Video by: Reid Havens

Learn how to leverage a long standing DAX pattern to calculate the top performing name/category and it's corresponding value using DAX measures in Power BI. Plus also see how to optimize the code using DAX Studio.

RELATED CONTENT 🔗

DAX Function (TOPN)
DAX Function (FIRSTNONBLANK)
Optimizing DAX Video Course

Creating a Composite Model Against a Power BI Dataset

Video by: Reid Havens

Learn how to create a composite model against a Power BI dataset, also known as (DirectQuery for Power BI datasets and Azure Analysis Services) or DQFPBIDAAS for short. 😅

Composite Models against a Power BI Dataset allows you to import tables from other data sources and combine it with your Power BI dataset.

RELATED CONTENT 🔗

Splitting a Report & Model
DirectQuery for Power BI datasets and Azure Analysis Services

Integrating Time Intelligence Filters with Drillthrough in Power BI

Video by: Reid Havens

Learn how to combine a Time Intelligence table with a matrix visual to propagate date filters through a Drillthrough action in Power BI.

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods