You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Creating Power BI dashboards for "Classic Models" to track KPIs using data from MySQL. Scenarios include inventory breakdowns, finance and sales insights, and regional performance analysis. Visualizations feature funnels, column charts, pie charts, and maps. Power BI Desktop is used for its diverse visuals.
Classic Models In R project showcases data analysis using R. It covers establishing a MySQL connection, using R Studio for various analyses including bar charts, pie charts, diverging bar charts, histograms, ordered bar charts, treemaps, and world maps. The scenarios demonstrate R's graphical capabilities with Classic Models dataset.
Using Python in Jupyter Notebook to recreate queries for imaginary stakeholders. Demonstrates connecting to MySQL, exporting tables to Excel, merging data, cleaning datasets, and counting orders. Visualizations include bar plots, revenue plots, pie charts, scatter charts, and map manipulation with geopandas. Dataset from MySQL.
Updating my portfolio with MySQL examples. This project uses MySQL Workbench to analyze the Classic Models database, a fictional company selling miniature vehicles globally from 2003 to 2005. Some scenarios include counting rows, identifying top customers, ranking sales reps and offices, sales, stock, and tracking orders and revenue.