Pratik Jagdale

Overall 4 years of experience in IT sector, worked as a Software Developer and Data Analyst as well on Microsoft Power BI tool. Experience in creation of dashboards and reports in Power BI and share this with management. Extracted the data from different data sources developed reports by using Power BI Desktop.

• Data Analysis and Visualization: Develop interactive reports and dashboards using Power BI to visualize data. Analyze data requirements and translate them into visualizations that provide insights. Ensure data accuracy, completeness, and consistency in reports.
• Data Modeling: Design and implement data models using Power BI's modeling capabilities. Optimize data models for performance and efficiency. Integrate data from multiple sources into a cohesive data model.
• Data Transformation and Cleansing: Perform data cleansing, transformation, and manipulation using Power Query Editor. Ensure data quality and consistency by implementing data cleaning routines. Handle data from various sources and formats.
• Data Integration and ETL Processes: Build and maintain data pipelines for extracting, transforming, and loading data into Power BI. Integrate Power BI with other data sources and systems within the organization. Implement ETL (Extract, Transform, Load) processes to ensure data accuracy and consistency.
• Creating Calculated Columns and Measures: Use DAX to create calculated columns that derive values based on expressions or conditions from existing data columns. Develop measures to perform aggregations, calculations, and comparisons on numerical data. Implement complex calculations such as running totals, moving averages, and year-over-year comparisons using DAX functions.
• Data Analysis and Aggregation: Aggregate and summarize data using DAX functions like SUM, AVERAGE, MIN, MAX, COUNT, etc. Calculate key performance indicators (KPIs) and metrics to measure business performance. Analyze trends, patterns, and outliers in data using DAX functions for statistical analysis and forecasting.
• Time Intelligence: Implement time-based calculations and analysis using DAX functions such as DATEADD, TOTALYTD, SAMEPERIODLASTYEAR, etc.
  Create time-based measures for year-to-date, quarter-to-date, and period-over-period comparisons. Develop dynamic date filters and slicers to enable users to analyze data based on different time periods.
• Data Modeling and Relationships: Define relationships between tables and optimize data models using DAX functions like RELATED, RELATEDTABLE, FILTER, etc.
  Implement calculated tables using DAX expressions to generate dynamic sets of data based on specified criteria. Perform complex data modeling tasks such as many-to-many relationships and role-playing dimensions using DAX.
• Optimization and Performance Tuning: Optimize DAX expressions for performance by reducing complexity, avoiding unnecessary calculations, and leveraging query folding. Monitor and analyze query performance using DAX Studio or Performance Analyzer to identify bottlenecks and optimize DAX calculations.