• COVID Data Exploration and Visualization

  • Built an analytical visual dashboard using Covid Infection/Death and Covid Vaccination data based on the guided project by Alex the Analyst (https://www.youtube.com/@AlexTheAnalyst).
    Utilized SQL queries for data exploration, applied JOIN clause for combining datasets and VIEW statement for virtual tables to use in Tableau.
    • Insights created:
      • Comparison of infection, death, and vaccination rates globally and in Hungary (my home country)
      • Effect of vaccinations on infection and death rates globally and in Hungary
      • Top 10 countries with highest infection and death rates
      • Total number of infected and deceased people since the beginning of the epidemic to 4/30/2021 and the death rate of COVID-19.
  • Technologies used: Excel, SQL, Tableau

  

• Data Analysis using Excel Data

  • Built a data analysis report using Sales data for a company. Applied statistical methods, calculations using formulas and Pivot Tables, slicers, and conditional formatting.
  • Technologies Used: Microsoft Excel

  

• Visualization using Power BI with Excel Data

  • Created a data analysis visual dashboard using Sales data of a company. Applied data import from Excel into Power BI and data transformation in Power BI to display right currency values. Used various charts to create visual dashboard of the Sales data.
  • Technologies Used: Microsoft Excel, Microsoft Power BI

  

• Visualization Using CSV Import Data with Power BI

  • Built an analytical visual dashboard using Employee and Department data of a company. This project uses two CSV flat data documents with an established relationship between them for descriptive analysis and deriving insights with Power BI.
  • Technologies Used: CSV files, Microsoft Power BI

  

• Visualization Using SQL Direct Query Data with Power BI

  • Built a visual dashboard using Employee and Department data of a company. Initially, imported two CSV flat documents into an SQL Database and then created an SQL Direct Query command using an SQL Join clause. Finally, used the created Direct Query to connect the data to Power BI and developed the required visuals.
  • Technologies Used: Microsoft SQL Server, Microsoft Power BI

  

• Visualization Using SQL Import Data with Power BI

  • Built an analytical visual dashboard using Employee and Department data of a company. Initially, imported two CSV flat documents into an SQL Database and then used Power BI's SQL Server Database Import function to connect to the data to develop the required visuals.
  • Technologies Used: Microsoft SQL Server, Microsoft Power BI

  

TBD

• Visualization of SQL Data with Power BI using Python Program
  • Build a data analysis visual dashboard using Sales data of a company. Analysis to be developed using Power BI and SQL Data and Using Python Program.
  • Technologies Used: Microsoft SQL Server, Microsoft Power BI, Python