/powerbi-dataprofessional

I chose a dataset collected by Alextheanalyst to analysis and visualization. The query was done in 'MySQL workbench' and in PowerBI. Visualization part was done b Power BI. For analysis I use MySQL, Excel and Power BI query tool.

Data Professional Survey Breakdown

Overview

The Data Professional Survey Breakdown project focuses on analyzing and visualizing a dataset collected by #Alextheanalyst. The dataset was scrutinized using MySQL Workbench for initial querying and further analysis was done through MySQL, Excel, and Power BI query tools. The visualization aspect was exclusively handled in Power BI to represent key insights.

Dataset Information

  • Source: Dataset collected by Alextheanalyst
  • Tools Used: MySQL Workbench, Excel, Power BI

Project Components

1. Querying and Analysis

  • MySQL Workbench: Initial querying and dataset overview were conducted using MySQL Workbench.
  • MySQL: Detailed dataset analysis using various SQL queries for insights into the data.
  • Excel: Supplementary data analysis and manipulation were performed in Excel for specific requirements.

2. Data Visualization

The visualization segment was completely handled in Power BI, creating a comprehensive dashboard representing the analyzed data.

  • Relationship Diagram Model
Screenshot 2023-11-01 112903
  • Dashboard Overview
Screenshot 2023-11-01 112947

Components of the Repository

  • MySQL Queries: SQL queries used for dataset analysis in MySQL.
  • Excel Files: Supplementary files used for specific data analysis and manipulation in Excel.
  • Power BI Dashboard: Contains the Power BI dashboard for visualizing the data.

Note: I couldn't able to share the direct link due to subscription issues, will try to do that soon.