I can do Data Analysis and have exprience with:
MySql - Experience in creating and optimizing control schemas and SQL queries: data management, filtering, grouping and aggregation. Creating tables, setting primary and secondary keys. I am able to design relational databases, ensuring data integrity and performance.
Power BI - I can create Interactive reports with visualizations. Integrate data from various platforms such as SQL Server, Excel. Use DAX for complex calculations and KPI creation. I can deploy and manage reports in “Power BI Service”, including automated data refresh. User right management on reports.
Python - I can perform Data Analysis and Transformation using Pandas and NumPy. Create interactive data visualizations with Matplotlib, Seaborn, and Plotly. Perform database operations using PyMySQL.
PowerQuery - I am able to effectively perform data cleaning, transformation and integration from various sources. Automate tables and queries and enable their dynamic updating. I can manage transformation scripts in Power BI and Excel environments.
Mquery - I know how to create and apply M functions for complex data transformations, Optimize queries