Your cart is empty
Add prompt packs to continue
This exclusive collection of prompts represents the definitive frontier for professionals seeking to transform raw data into strategic assets. Meticulously designed by data engineering experts, each instruction optimizes the workflow in Power BI, from advanced cleansing with M language to architecting complex DAX measures, ensuring accurate and visually impactful reports. By integrating the latest advances in artificial intelligence, such as Copilot and predictive analytics, this resource allows you to automate repetitive tasks and discover deep insights that remain hidden in plain sight. Elevate your dashboards to a higher corporate level, implementing robust data governance along with a user experience that accelerates critical decision making in real time.
100 resources included
Acts as a Data Architect expert in Power BI and tabular modeling. Your goal is to design an optimized data architecture for [Project Name] that manages large-scale, multi-level product hierarchies. The structure must allow fluid navigation from the high consumption level to the stock keeping unit (SKU) level, ensuring that the model is scalable for [Volume of Records] rows and that the structure supports [Number of Hierarchical Levels] defined by the business. I need you to define the best technical strategy to transform a source table with hierarchical dependency relationship (based on product ID and parent ID) into an optimized dimension table. This is crucial to minimize the impact on query performance and take advantage of the compression capabilities of the VertiPaq engine in Power BI Desktop. Please detail the creation of calculated columns using navigation functions to uniquely identify each level of the hierarchy, allowing analysts to use efficient data slicers. In the context of irregular hierarchies or 'Ragged Hierarchies', propose an advanced technical solution to visually manage empty levels when a product does not reach the maximum depth of the organizational structure. It uses logical functions to ensure that aggregation metrics at higher nodes are consistent and that navigation in matrix-type visuals is professional, avoiding unnecessary repetition of names at lower levels that do not exist for [Market Segment]. Finally, document the data audit process to detect potential inconsistencies in the product chain of command. It includes logic examples to calculate the percentage share of each SKU with respect to its immediate superior node, ensuring that the proposed architecture facilitates the dynamic maintenance and integration of new product catalogs under the [Data Quality Regulations] standard without requiring deep structural changes to the data model.
Acts as a senior Business Intelligence Solutions Architect with specialization in Power BI and Data Storytelling. Your goal is to design a highly customized Waterfall Chart visualization that transcends the tool's standard native capabilities. This chart should break down complex variations between [Start Metric] and [End Metric], analyzing driving factors such as [Variance Factor A], [Variance Factor B], and [Special Business Adjustments]. The design should focus strictly on executive clarity, allowing stakeholders to instantly identify the positive and negative drivers that impact financial or commercial performance in the period [Temporal Range]. To achieve this level of detail, I need you to develop the DAX measures necessary to handle 'Bridge Categories'. You must implement robust logic that calculates the incremental or decremental value for each variance category, ensuring that the final cumulative total exactly matches the closing value of the reported period. Provides DAX code for a master measure called [Main Measure Name] that uses variables (VARs) to define the calculation context, handling specific filters from the [Fact Table], and ensuring that data labels show both the absolute value and the percentage impact relative to the initial starting point. Regarding aesthetics and color psychology, it applies high-impact information design principles. Defines a semantic color palette where increments are displayed in [Increment Color], decrements in [Decrement Color], and start/end totals pillars use an institutional neutral tone such as [Totals Color]. It instructs in detail on how to set up advanced conditional formatting for bars and how to use custom connecting lines to guide the user's view through the narrative flow of the waterfall. Additionally, it integrates advanced techniques to group categories with insignificant variations under a dynamic 'Other' label using a parameter table or ranking logic in DAX. Finally, optimize the interactivity and analytical capacity of the report. Explains the technical process for setting up custom Tooltips (tooltip pages) that reveal granular details of [Detailed Dimension] when hovering over any variance bar. Design a visual storytelling strategy that includes dynamic annotations based on the context of the filters selected in the [Data Segmenter]. The final result must be a visual component that not only presents cold figures, but also explains in a coherent and aesthetic way the 'why' behind the fluctuations in the [Department or Business Unit] area.
Acts as a Senior User Experience (UX) Designer specialized in Business Intelligence and data visualization in Power BI. Your mission is to design the "Interactive Wireframe Structure" for a critical dashboard intended for [End User Profile]. The design should prioritize user adoption and minimize cognitive load, ensuring that key information is digestible in less than 5 seconds following Gestalt principles and Stephen Few's visual hierarchy. Defines a detailed information architecture that includes the arrangement of elements in a grid of [Number of Columns] columns. You must specify the exact location of the global navigation bar, hideable slicer panel, and main display area. It uses an 'Information Pyramid' approach where the top level contains the strategic KPIs, the middle level the comparative trends and the bottom level the granular detail or support tables for the root cause analysis. Describes the interactive behavior of the wireframe in detail. It explains how the navigation buttons between pages should work, the bookmarks to change graph views without cluttering the canvas, and the logic of the custom tooltips that will guide the user in the interpretation of the data. It includes guidelines on the use of negative space to separate thematic sections and how cross-filtering should influence the visual narrative of the report to avoid confusion for the end user. Establish visual design guidelines for specific components: font sizes for titles and labels, color palette consistent with [Brand Manual] but accessible to people with color blindness, and the use of micro-interactions that give immediate feedback to the user when interacting with a filter or graph. Ensure that the design considers adaptability for different screen resolutions, always maintaining the integrity of the margins and the alignment of visual objects according to the importance of the data presented. Finally, generate a usability checklist that the Power BI development team must follow to validate that the wireframe has been implemented correctly. This list should include user flow testing, verification of visual click response times, and consistency of field names across all report visuals, ensuring that the data narrative in [Project Name] is fluid and professional.