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.

Socio-economic dashboard depicting Employment and Job Creation. Unemployment Rate (Province, Year, Qtr, Rate [percentage])Unemployment Rate by population group (Province, Year, Population Group, Rate [percentage])Unemployment Rate by gender (Province, Year, gender, Rate [percentage])Youth Unemployment Rate (Province, Year, Age cohorts, Rate [percentage])% Employment in formal and informal sectors (Province, Year, Sectors incl Agriculture, Sectors excl Agriculture, Private Households (domestic work), Rate [percentage])Labour particpation Rate (Province, Year, labour particpation Rate [percentage])Publication Date13 March 2022LineageData is sourced from Stats SA Quarterly Labour Force Surveys. Data is transformed into a BI format and quality assured. Data is consumed by a dashboard created in Power BI. Six reports exist for this dashboard:Unemployment RateUnemployment Rate by population groupUnemployment Rate by genderYouth Unemployment Rate % Employment in formal and informal sectorsLabour particpation RateData SourceData from Stats SA; Labour force surveys and Quarterly Labour Force Surveys 2017 – 2021Dynamic dashboard reflecting the Outcome Indicator Release - Outcome Indicator: Unemployment rateUnemployment rate by population in WCUnemployment rate by gender in WCYouth unemployment ratePercentage of employed people working in the informal sector, including domestic work in WCLabour participation rate

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

Section and Beat Outline for Power BI maps

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.

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.

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

This data layer is a draft of selected species ranges from ECOS. The layer has to be made public to test for integration into a Power BI dashboard. Please do not use for any other purposes. Most current geospatial data including area of influence, current and historical ranges, data are available through the Threatened and Endangered Species System (TESS) here. https://ecos.fws.gov/tess/speciesModule/home.doOther information may be found on the FWS Endangered Species web page here https://www.fws.gov/program/endangered-species

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)

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.

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

The River Authority Water Quality Viewer is a tabbed web mapping application. The following tabs are defined below:The first tab - Water Quality – is an embedded interactive Power BI dashboard. It displays monitoring efforts for the Texas Commission on Environmental Quality’s (TCEQ) Clean Rivers Program and summarizes how the water quality in the San Antonio River Basin compares to the Texas Surface Water Quality Standards (TSWQS) using the latest TCEQ Integrated Report assessment. Through the Texas Clean Rivers Program, The River Authority and its partners collect surface water, stormwater and sediment chemistry, physical, and biological data within the San Antonio River Basin. The second tab – Primary Contact Recreation Use –summarizes assessment outcomes for the San Antonio River Watershed as identified in the Texas Commission on Environmental Quality (TCEQ) 2018, 2016, 2014, and 2012 Integrated Report (IR). It displays the Primary Contact Recreation Use Designations by color.The third tab – Aquatic Life Use – summarizes assessment outcomes for the San Antonio River Watershed as identified in the Texas Commission on Environmental Quality (TCEQ) 2018, 2016, 2014, and 2012 Integrated Report (IR). This Web Map displays the Aquatic Life Use Designations. It is the dependent of the SARA Water Quality Viewer and uses the Aquatic Life Use Web Map.The fourth tab – General Use – summarizes assessment outcomes for the San Antonio River Watershed as identified in the Texas Commission on Environmental Quality (TCEQ) 2016, 2014, and 2012 Integrated Report (IR). It displays the General Use Designations. It is the dependent of the SARA Water Quality Viewer and uses the General Use Web Map.The fifth tab – Fish Consumption Use – summarizes assessment outcomes for the San Antonio River Watershed as identified in the Texas Commission on Environmental Quality (TCEQ) 2016, 2014, and 2012 Integrated Report (IR). This Web Map displays the Fish Consumption Use Designations. It is the dependent of the Fish Consumption Use Tab and the SARA Water Quality Viewer.Please do not delete or modify The River Authority GISESD

Section and Beat Outline for Power BI maps

Data is sourced from SAPS and other sources is transformed into a BI format and quality assured. Data is consumed by a dashboard created in Power BI. These dashboard depict the Western Cape Government (WCG) outcome indicators related to Safety and Security.Four reports exist for this dashboard:1. Safety and Security (2016/17-2020/21); filter by year, quarter, province - Safety and Security Crime by Group (2016/17-2020/21); filter by year, quarter, province - 2. Number of Road Accidents Road Accidents in the Western Cape3. Murder Rate per 100k population4. Crime rates per 100k populationPublication Date05 October 2022Data from SAPSDynamic dashboard reflecting the Outcome Indicator Release - Outcome Indicator: Total number of murders reported in a given yearMurder rate per 100 000 population in a given yearTotal number of contact crimes incidents reported in a given yearRate of contact crimes reported per 100 000 population in a given yearTotal number of property related crimes and aggravated robbery reported in a given yearTotal number of sexual offence crimes reported in a given yearTotal number of drug-related crimes reported in a given year in the Western CapeDrug-related crime rate per 100 000 population in the Western CapeTotal number of community reported crime in a given year in the Western CapeRate of 17 categories of community-reported crime per 100 000 population in the Western CapeNumber of road accident deaths in a given year in the Western CapeNumber of road crash fatalities per 100 000 populationData SourceCrime Statistics 2020/21; Crime Information Management – SAPSDTPW Annual Report 2016/17-2020/21 – Department of Transport and Public WorksMid-year Population Estimates 2016-2021, Stats SA

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.