Pratik Jadhav

BI Developer skilled at technical leadership, communication and presentations. Experienced in the full project life cycle from importing data in power bi desktop to visualization. Having more than 5 years of experience in Business intelligence, good hands-on SQL Also and on Sql Server Analysis Service.

· Understanding sampling data to analyse.

· Development of Reports / Dashboards using Power BI.

· Used DAX provided in power BI.

· Worked on Power Query for data modification.

· Use different function in Power Query like Merge, Append, Concate.

· Development of Data Model and publishing to Power BI Service.

· Row Level security implemented as per required roles.

· Performed complex query calculations to meet user’s requirements.

· Created different filters like visual level filters and page level filters per reporting.

· Expertise in various visualizations like Pie chart, Bar graph, Line Charts, Area Charts, water fall charts and Card Visualizations

· Designed different types of reports like drill down, drill through, And Sync Slicer.

· Created various Customized and interactive Reports and Dashboards in Power BI.

· Gave access to workspace or app to end user.

· Created mobile view for the reports.

· Worked on AAS using Tabular Editor.

· Created relationship, measures and import views in SSAS.

· Created Monthly, Yearly Partitions in cube.

· Assign RLS in cube level.

· In SQL created views, Synonyms and schema for the database.

· Validation of report level data to SQL level data.

Power BI Data Analyst (PL-300)

• Mandarin Hotel Group is a large hotel chain in various nations which provides different services like Rooms, Catering, Spa and Golf etc. They have huge data of different customers across the world which needs to be managed securely. DominanceTech handles several databases, controls all data 24
• 7 and helps to make easy to create reports and dashboards that contain powerful insights into how to elevate operations and customer service to new heights. DominanceTech provides business intelligence solutions to the hospitality industry. In that time, we have empowered many of valued customers by transforming their relationship with their data, so that they can streamline operations and better serve their guests.