Prasad Joshi

Results-driven IT Professional with over 3 years of experience specializing in Power BI. Demonstrated expertise in designing and implementing data-driven solutions that enhance business intelligence and facilitate strategic decision-making. Proficient in data visualization, reporting, and analysis, with a strong focus on creating impactful dashboards to drive performance. Committed to leveraging technical skills to support organizational growth and improve operational efficiency.

• Collect data from various sources such as databases, spreadsheets, and online resources.
• Ensure data accuracy and integrity by cleaning and preparing datasets for analysis
• Transform raw data into meaningful formats using Power BI tools and techniques.
• Create data models that establish relationships between different data sources.
• Develop interactive and visually appealing dashboards and reports using Power BI.
• Perform basic data analysis to identify trends, patterns, and insights
• Generate regular reports and summaries based on the data analysis.
• Design data models and data visualizations that effectively communicate key insights and trends in Sales and Service Data.
• Work closely with Area Sales and Service managers to gather requirements, understand business objectives, and deliver customized.
• Optimize data models and queries to improve report performance and reduce load times.

• Extracting data from various sources like databases, APIs, or Excel sheets.
• Cleaning and transforming the data to ensure it's accurate and ready for analysis (e.g., handling missing values, removing duplicates, etc.).
• Creating visualizations like charts, graphs, and tables in Power BI that represent key metrics, trends, and insights.
• Providing analysis on credit card usage, payment patterns, fraud detection, customer segmentation, etc.
• Creating and optimizing data models using Power BI's data modeling features (e.g., DAX formulas for calculated columns and measures).
• Ensuring the reports are user-friendly and intuitive.
• Regularly collaborating with business stakeholders to understand their reporting needs and adjusting reports accordingly.
• Automating data refresh schedules to ensure reports and dashboards are always up to date.
• Configuring Row-Level Security (RLS) in Power BI Service to ensure that users only see data they are authorized to view, especially when dealing with sensitive financial or credit card data.
• Ensuring the reports are updated on a regular schedule by setting up data refresh schedules.

• I was responsible to collect sales data from Excel Files for various stores, including transactions, sales volume, revenue Etc.
• Ensuring there are no repeated entries
• Identifying and correcting any mistakes in the data (e.g., invalid dates, sales amounts, or incorrect store names).
• Making sure all data columns are in consistent formats, such as dates, currency, or numerical values.
• Combining data from different sources or sheets using Power Query's merge feature, ensuring all relevant data is available for analysis.
• Creating pivot tables for in-depth analysis.
• Using conditional formatting in Excel, the manager can highlight key trends or outliers (e.g- highlighting the top-performing stores or showing low-performing stores in red).
• Comparing sales across all stores to identify top performers or stores that need improvement.
• Best-selling products or categories by store.

• Gender-Male
• Martial Status-Married
• Nationality-Indian
• Language-Fluent in English,Marathi,and Hindi.

As a dedicated and detail-oriented individual with a strong commitment to

teamwork, I am confident in my ability to excel in a dynamic and challenging work

environment. With a solid understanding of the requirements and a proven track

record of success, I am eager to bring my skills and expertise to a new role. I affirm that

the information provided in this resume is accurate and reflects my qualifications

and experience to the best of my knowledge.