The development cycle for business intelligence can be summarized as data discovery, data modeling, data visualization and the distribution of reports/dashboards. Connectivity refers to the connnections to data sources; Data Elelments refers to the types of data needed to build the reports; Process refers to ETL to visualization; and Access refers to the 24/7, HIPAA compliant, cloud-based access. This is built within Microsoft Power BI, coded in Data Analysis Expressions (DAX) with Tenancy on the Microsoft Azure cloud platform.


CONNECTIVITY

Databases
□ SQL, SQL Server Analysis Services
□ Oracle, Access, MySQL, PostgreSQL
□  IBM DB2,SAP HANA,ODBC, etc.
File Types
□ Excel, Text/CSV, XML, JSON
Folder Connectors
□ SharePoint, Azure Blob and Data Lake


ELEMENTS

Organization
□ Divisions, Business Units, Locations
Demographics
□ Plan, Tier, ID, Age, Gender, Pay, Zip
Claims Data
□ Allowed, Discounts, OOP Liability, Paid
□  NDC, DRG, CPT, Network, Formulary
□ Incurred, Paid, Funded Dates


PROCESS

Extract, Transfer & Load
□ Import Data, Set Privacy & Credentials
Transform
□ Cleanse, Format, Filter, Apply Rules
Model
□ Queries, Formulas, Tables, KPI's
Visualize
□ Reports and Dashboards


ACCESS

Cloud
□ Licensed Azure Tenant Space
□ Row-Level Security, Role Restrictions
24/7
□ Laptop, Desktop, iPad, Mobile Devices
HIPAA
□ Azure/Microsoft Covered under BAA
Microsoft ISO/IEC 27001 Certification


REPORTS

DASHBOARDS

About    Contact
Health Quant LLC is a Delaware corporation. All proprietary analytical engines are powered by DAX and Microsoft Power BI.
 © 2020 Health Quant LLC.  All rights reserved.
 
Navigation