Data Shaping for Maximum Efficiency
Hello! I am new to Power BI and am in the process of developing dashboards around healthcare information. I need guidance on best practices for importing data via SQL, particularly maximizing efficiency around data shaping. After reading on article on star schema methodology it sounds like I should break up my data and not just import one or two large tables. Let’s say for simplicity sake I have two tables, one with member information and one with claim information as follows: Member table: Policy ID Member ID Gender Date Resident State Family Type Agent Type Product Type Premium 12345 1 Male 1/1/2022 Texas Husband and Wife Broker Dental Plan $10.00 12345 2 Female 1/1/2022 Texas Husband and Wife Broker Dental Plan $10.00 12345 1 Male 2/1/2022 Texas Husband and Wife Broker Dental Plan $10.00 12345 2 Female 2/1/2022 Texas Husband and Wife Broker Dental Plan $10.00 12345 1 Male 3/1/2022 Florida Husband and Wife Broker Dental Plan $10.00 12345 2 Female 3/1/2022 Florida Husband and Wife Broker Dental Plan $10.00 12345 1 Male 4/1/2022 Florida Husband, Wife and Child Broker Dental Plan $10.00 12345 2 Female 4/1/2022 Florida Husband, Wife and Child Broker Dental Plan $10.00 12345 3 Child 4/1/2022 Florida Husband, Wife and Child Broker Dental Plan $5.00 Claims table: Policy ID Member ID Claim Date Claim ID Claim Line Claim Type Procedure Code Claim Cost 12345 1 02/17/2022 17854 1 Preventive D1045 $17.52 12345 1 02/17/2022 17854 2 Basic D9305 $29.31 12345 1 02/17/2022 17854 3 Major D1700 $85.68 Let’s say that every row in the member table is unique for a given Policy ID, Member ID, and Date. Should each attribute in the member table be split into its own table with their corresponding Policy ID, Member ID and Date? And then I would join the tables in Power BI on these three values? Similarly for the Claims Tables the Policy ID, Member ID, Claim ID and Claim Line are the unique identifiers. Should I have a separate table for Claim Type, Procedure Code, Claim Cost, etc.?
Power BI doesn't show value
Hello Everyone, I'm trying to create an interactive dashboard with Security/Medical Risk location, it's working fine until I try to add a "Risk Gauge". The risks are from Low (1) until Extreme (5) As per the example on the left. Until now the Dash is working OK, the shows what it needs to show and things like that. But The gauge is not showing correctly is should show 4, and not 2, The only options that I have are below: I want to show the raw value of each contry when I click it, like it should have shown "4" for High Risk Tried everything and can't find a solution....
