Step-by-Step Instructions for Parsing a JSON Column in Power BI:
Tips: Example Scenario: If you have a JSON column like this: By following these steps, you’ll be able to effectively parse and use JSON data in Power BI for analysis and reporting.
Controller
DataMarts.ArrayVersion
The introduction of the array version of data marts is designed to enhance flexibility and consistency, particularly in managing regional data that may vary in field type and structure. This approach involves grouping related data fields into JSON-like arrays or structures within SQL. Here’s an explanation of its benefits and mechanics: Key Points of the … Read more
Project.Value
Purpose The Project Value fact table is designed to display summarised financial data related to project hours, costs, and revenues. It integrates with dimension tables, such as project_details and client_details, to provide a comprehensive view of the financial performance of each project. The primary purpose is to support project management, strategic decision-making, and financial analysis … Read more
Project.Dates
Purpose: The purpose of this DataMart view is to provide a comprehensive timeline overview of a project’s key dates, from its creation to completion. It consolidates important project milestones such as planned and actual start and finish dates, delivery estimates, and project modifications. This view is designed to help stakeholders monitor project timelines, identify delays, … Read more
Employee.Employment
Purpose: The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for HR … Read more
Customer.OrderlineValue
Purpose The Customer Order Line Value view provides a detailed financial overview of customer order lines, including key pricing and cost information, quantities, dates, and currency-based amounts. This view is specifically designed to facilitate reporting and analysis on the financial performance of individual order lines. It includes fields that capture gross and net amounts, tax-inclusive … Read more
Customer.OrderlineStatus
Purpose The Customer Order Line Status view provides detailed tracking of the operational state of each customer order line. It monitors statuses, user actions, and error messages for each line item within customer orders, offering insights into the progress and any potential issues in order line processing. This view is essential for maintaining transparency and … Read more
Customer.InvoiceValue
Purpose The Customer Invoice Value view provides detailed financial information on customer invoices, including gross, VAT, and net amounts across multiple currencies. This view is focused on delivering a comprehensive breakdown of financial values, allowing for detailed reporting and analysis of invoice data. Use Case Owner: Soon TanTypical Use Case: Designed for financial reporting and … Read more
Customer.InvoiceStatus
Purpose The Customer Invoice Status view provides insight into the operational state of customer invoices by tracking statuses and reporting errors. This view is intended for monitoring the life-cycle and status changes of invoices, including entry dates, user actions, and error messages. It supports operational reporting by offering visibility into any issues or errors that … Read more
Infrastructure.ChangeRequest
Purpose Designed to display the output from the SharePoint List Change Request The myHistory version of the request is designed to evaluate the effectiveness of the change management process. Use Case Owner: Simon WillmoreTypical Use Case: Change Management Dashboard presents key metrics such as the number of open and closed change requestsStyle: Fact Dashboards Utilising … Read more