suvendhu patel
Data analyst ( Python, Power Bi, Excel, MySQL)
I am a skilled PowerBI and analysis professional with 3 years of experience in working with healthcare, marketing, and internal company data. My expertise lies in DAX, data modeling, and data cleanup, which allows me to transform raw data into actionable insights.
Key Skills:
* PowerBI: Creating interactive dashboards and reports using DAX, data modeling, and visualization techniques.
* DAX: Writing complex formulas and measures to perform calculations and aggregations on data.
* Data Modeling: Designing and implementing data models that optimize query performance and data integrity.
* Data Cleanup: Identifying and correcting data quality issues to ensure data accuracy and reliability.
Work Samples:
Please find attached samples of my Excel analysis and PowerBI visualizations that demonstrate my skills in:
* Analyzing patient demographics and trends in a healthcare dataset
* Creating a marketing campaign performance dashboard
* Developing a sales analysis report for internal stakeholders
Project Approach:
When analyzing an Excel file and creating visualizations on PowerBI, I follow a structured approach:
* Understand the requirements: Clearly define the project objectives and the questions that need to be answered.
* Import and clean the data: Import the Excel data into PowerBI and perform necessary data cleaning tasks, such as handling missing values, inconsistencies, and formatting issues.
* Create the data model: Design a data model that reflects the relationships between entities and optimizes query performance.
* Write DAX measures: Develop DAX measures to calculate key performance indicators (KPIs) and other relevant metrics.
* Create visualizations: Build interactive visualizations, such as charts, graphs, and tables, to present the insights in a clear and engaging manner.
* Iterate and refine: Continuously refine the analysis and visualizations based on feedback and evolving requirements.
DAX, Data Modeling, and Data Cleanup Expertise:
I have a s