Section and Beat Outline for Power BI maps

This project focuses on developing a machine learning-driven system to classify hospital claims and treatment outcomes, offering a second opinion on healthcare costs and decision-making for insurance claims and treatment efficacy.Key Features and Tools:Machine Learning Algorithms: Leveraging Python (pandas, numpy, scikit-learn) for predictive modeling to assess claim validity and treatment outcomes.APIs Integration: Used Google Maps API to retrieve and map the locations of private hospitals in Malaysia.GIS Mapping Dashboard: Created a GIS-enabled dashboard in Microsoft Power BI to visualize private hospital distribution across Malaysia, aiding healthcare planning and analysis.Advanced Analytics Tools: Integrated Microsoft Excel, Python, and Google Collab for data processing and automation workflows.

This Power BI dashboard shows the COVID-19 vaccination rate by key demographics including age groups, race and ethnicity, and sex for Tempe zip codes.Data Source: Maricopa County GIS Open Data weekly count of COVID-19 vaccinations. The data were reformatted from the source data to accommodate dashboard configuration. The Maricopa County Department of Public Health (MCDPH) releases the COVID-19 vaccination data for each zip code and city in Maricopa County at ~12:00 PM weekly on Wednesdays via the Maricopa County GIS Open Data website (https://data-maricopa.opendata.arcgis.com/). More information about the data is available on the Maricopa County COVID-19 Vaccine Data page (https://www.maricopa.gov/5671/Public-Vaccine-Data#dashboard). The dashboard’s values are refreshed at 3:00 PM weekly on Wednesdays. The most recent date included on the dashboard is available by hovering over the last point on the right-hand side of each chart. Please note that the times when the Maricopa County Department of Public Health (MCDPH) releases weekly data for COVID-19 vaccines may vary. If data are not released by the time of the scheduled dashboard refresh, the values may appear on the dashboard with the next data release, which may be one or more days after the last scheduled release.Dates: Updated data shows publishing dates which represents values from the previous calendar week (Sunday through Saturday). For more details on data reporting, please see the Maricopa County COVID-19 data reporting notes at https://www.maricopa.gov/5460/Coronavirus-Disease-2019.

Web map created by Research and Stats for PowerBi DashboardMap of Current Sales and Use Tax Rates

The San Bernardino County CAASPP & ELPAC Report provides an overview of the county's performance. This interactive tool has seven reports that can be viewed by district, student group and grade level. In order to protect student confidentiality, no scores are reported (or included in the research files) for any group of 10 or fewer students.

Source: California Department of Education, CAASPP Research Files, https://caaspp-elpac.ets.org/caaspp/

Link to the City of O'Fallon's Power BI Budget Report. This is not a live report - data is generally at least one business day behind actual.

This dataset is of 2017 properties. It is used for the City's Power BI training.

Section and Beat Outline for Power BI maps

Section and Beat Outline for Power BI maps

Data is sourced from various health resources. Data is transformed into a BI format and quality assured. Data is consumed by a dashboard created in Power BI. Four reports exist for this dashboard:1. HIV Prevalence and TB Success RateHIV prevalence amongst women attending antenatal clinics in the Western Cape (2012-2015) by district and yearHIV prevalence amongst women attending antenatal clinics in the province (2012-2015) by province and yearTB Programme Success Rate (2013/14-2018/19) by TB Measure2. Births and Maternal MortalitiesNeonatal in facility (0-28 days) mortality rate (2015/16-2018/19); by years and neonatal death rate in facility and mortality rate by 1,000 live births Facility maternal mortality rate (2002, 2005, 2008, 2011, 2014); by triennia (3 years) deaths by 1,000 live births in WC (incl count of maternal deaths, count of live births, and infant maternal mortality ration)(Child (under 5) and Infant (under 1) mortality rate (2011, 2012, 2013); filter years, Infant/Child age band; Years, District, Births and Deaths by age bandDelivery rate in facility to women under 20 years (2013/14-2018/19); filter by financial year (FY); delivery rate by FY, delivery rate, numerator (births to women <20), denominator (total births)3. Deaths and Life ExpectancyLeading underlying causes of death in the Western Cape (2012-2016) by years and cause of deathYears of life lost (YLL) by cause of death in the WC (2012-2016) by years and YLL cause of deathAverage Life Expectency (LE) at birth (2006, 2011, 2016) by year, province, and gender4. Travel time to facilitiesTravel time taken to health facility by households with expenditure less than R1200-SA (2013-2018); by year, province, and travel time to health facilityTravel time taken to health facility by households with expenditure less than R1200-WC (2013-2018); by year, province, population group, and travel time to health facilityPublication Date2 September 2021LineageData from various sources transformed to a BI format and used to develop dynamic Power BI dashboards reflecting Outcome Indicators: HIV prevalence amongst women attending antenatal clinics in the provinceAll DS-TB (drug-susceptible tuberculosis) client treatment success rateNeonatal in facility (0-28 days) mortality rateFacility maternal mortality rateDelivery rate in facility to women under 20 yearsLife Expectancy (LE)Leading underlying causes of death in the Western CapeTravel time taken to health facility by households with expenditure less than R1200 (SA and WC)Data Source2019 National Antenatal Sentinel HIV Survey, National Department of Health 2021;Annual report 2014/15-2020/21, DOH;District Health Information Systems;Mid-year population estimates, Stats SA; Life Expectancy Stats SA calculations;Mortality and Causes of Death in South Africa 2018, June 2021, Stats SA

The Data Insight Newsletter is produced by the Product Management team to provide insights and updates to work undertaken by the service.This edition contains information about:Power BI Cycling DashboardArea Strategy Scheme MappingData Engineering Updates

Power BI Dataflow: rs_lginform_metricsLG Inform is the local area benchmarking tool from the Local Government Association LG Inform Plus makes available a large number of metrics about a wide range of areas from different data sources in one place accessible through an API.This dataflow contains the metric values for metric types within the WMCA Types of interest view of LG Inform Plus Metric Types, covering areas of interest at a regional comparison level (regions and local authorities in England) and at MSOA, LSOA and Ward level within the West Midlands metropolitan area.It contains the associated dimensional tables for metric types, datasets, collections and sources that have been queried at source from LG Inform Plus API web services at https://home.esd.org.uk/.The Dataflow is manually refreshed upon new data metrics available. Last refresh 04/10/2023

This point layer represents the water quality stations located throughout the San Antonio River Basin. The San Antonio River Authority's environmental science departments monitors and collects surface water samples at these locations. Samples are processed immediately at our in-house Texas Commission on Environmental Quality (TCEQ) accredited Lab. This layer was created to share externally through the SA River Authority Open Data Portal. It is also made visible through our Water Quality Viewer, Power BI embedded dashboard. This data is subject to change. Last updated on 3/22/2021.Here are the fields available in this layer: station_idsubwatershed_namesara_short_descounty_namesegement_idlatitudelongitudewaterbody_namewatershed_namestation_type

This hosted feature layer has been developed in-house by the VDOT CO TED Highway Safety section for crash analysis purpose based on updates from the Power BI Crash Tool. The Crash Data Dictionary can be found here. The main source of the data is owned and maintained by DMV. In providing this web map, we assume no responsibility for the accuracy and completeness of the data. In the process of recording and compiling the data, some deletions and/or omissions of data may occur and VDOT is not responsible for any such occurrences.

The main source of the data is owned and maintained by DMV. In providing this tool, VDOT assumes no responsibility for the accuracy and completeness of the data. In the process of recording and compiling the data, some deletions and/or omissions of data may occur and VDOT is not responsible for any such occurrences. The most recent data contained in this report is preliminary and subject to change. Please be advised that, under Title 23 United State Code – Section 409, this crash information cannot be used in discovery or as evidence in a Federal or State court proceeding or considered for other purposes in any action for damages against VDOT or the State of Virginia arising from any occurrence at the location identified.

All users shall comply with and be subject to all applicable laws and regulations, whether federal or state, in connection with any of the receipt and use of DMV data including, but not limited to, (1) the Federal Drivers Privacy Protection Act (18 U.S.C. § 2721 et seq.), (2) the Government Data Collection and Dissemination Practices Act (Va. Code § 2.2-3800 et seq.), (3) the Virginia Computer Crimes Act (Va. Code § 18.2-152.1 et seq.), (4) the provisions of Va. Code §§ 46.2-208 and 58.1-3, and (5) any successor rules, regulations, or guidelines adopted by DMV with regard to disclosure or dissemination of any information obtained from DMV records or files.

The Dashboard contains the following information:Population by province (9 SA provinces), age and genderWC Population by gender, age cohorts, and district and metroNational population as a tree chart (and map)Decomposition tree by gender and age cohortData from 2002-2021 - using Census data, Community Survey 2016, and mid-year population esitmatesDynamic dashboard reflecting the Outcome Indicator Release - Outcome Indicator: The Western Cape population by age group and genderThe Western Cape District population by age group and genderThe South African population per provincePublication Date1 September 2022Lineage:Data is sourced from Statistics South Africa. Data is transformed into a BI format and quality assured. Data is consumed by a dashboard created in Power BI. Four reports exist for this dashboard:Population by age and genderWestern Cape PopulationNational PopulationDecomposition TreeData SourceMid-year population estimates - Stats SA (2002-2021)

A data dashboard in the form of a document link to Microsoft Power BI Dashboard of the same name, prepared and maintained by the Department of Economic Prosperity and Housing. Data is updated quarterly.NOTE: This product and the information shown is provided "AS IS" and exists for informational purposes only. The City of Vancouver (COV) makes no warranties regarding the accuracy of such data. This product and information is not prepared, nor is suitable, for legal, engineering, or surveying purposes. Any sale, reproduction or distribution of this information, or products derived therefrom, in any format is expressly prohibited. Data are provided by multiple sources and subject to change without notice.

Data is sourced from Stats SA, CoCT, Dept Water Affairs, . Data is transformed into a BI format and quality assured. Data is consumed by a dashboard created in Power BI. The following reports exist for this dashboard:1. Electricity and WasteElectricity distributed in SA; Filter by year, province, month and region; by GWhElectricity distributed in WC; Filter by year, and month; by GWhTotal Waste minimised; Filter by year and facility; total waste minimised by month in Tons2. Zones, Dams, and ConservationBlue Drop Status; Filter by province and year; Blue Drop scoreGreen Drop Status; Filter by province and year; Green Drop scorePercentage dams filled to capacity; Hectares of biodiversity under conservation;Publication Date16 November 2021LineageData from Electricity generated and available for distribution, Stats SA, Waste diverted in City of Cape Town from CoCT open data portal, Dept of Water Affairs dam levels and blue- and green drop reports, and State of Biodiversity ReportDynamic dashboard reflecting the Outcome Indicator Release - Outcome Indicator: Electricity distributed in South Africa (2002-2020)Electricity distributed in the Western Cape (2002-2020)Total waste diverted from landfill sites in a given year in the City of Cape Town (2015-2019)Blue Drop Status (2009-2014) - Average Blue Drop status of the drinking water quality management businesses in the Western Cape.Green Drop Status (2009-2014) - Average Green Drop status of the waste water management in the Western Cape.Percentage dams filled to capacity (2012-2019) - The monthly dam level is calculated from the estimated dam levels on the 1st of each month or the earliest available estimates for the monthHectares of biodiversitry under conservation (2007, 2012, 2017) - by biodiversity stewardship programmePublication Date2 September 2021Data SourceData from Electricity generated and available for distribution 2021, Stats SAWaste diverted in City of Cape Town - CoCT open data portalDepartment of Water Affairs: Dam Levels (2012-2019); Blue Drop Reports (2009-2014 ); Green Drop Report (2009, 2011, 2014);State of Biodiversity Report 2017