Healthcare analytics brief summary.

Connection

In the home tab click get data
Click more
Select data
Select postgresql database
Click the connect button
specify the server and database
select ok
Select the tables and click ok

Cleaning

In Power Query(transform data):
o Rename columns to readable names.

Double click the title to rename it in title case then click enter.

o Set correct data types: dates to Date, amounts to Decimal Number, IDs to Text.

Select the column
In the home tab go to Data Type and specify the data type

o Trim/clean text, replace blanks with nulls where appropriate.

Select the column whose values you want replaced
In the home tab select replace values and specify the value to be replaced with what it should be replaced with
Click ok

o Create (if needed) a Year, Month, and Year-Month text column for easy visuals.

Underthe add column tab
Select custom column
Specify the column name in the 'new column name' namebox.
In the custom column formula;

Year = YEAR([AppointmentDate])
Month = MONTH([AppointmentDate])
MonthName = FORMAT([AppointmentDate], "MMMM")
YearMonth = [Year] & "-" & FORMAT([Month], "00")

o Close & Apply.

Modeling Choices

Create a date table by merging the appointments enrinched table and doctor monthly metrics table
Create a relationship between the date table and appointments enriched table How to create a relationship between the tables

Go to the model view
Click the three dots on the top-right of the data table
Click manage relationships
Click new relationship
Under the from table, select date, select date column
Under the to table, select appointments enriched, select Appointment Date column
Cardinality: Many to many
Cross filter direction :Single
Click save the button