Pratik Mistry

WORK HISTORY

EDUCATION

ABOUT PRATIK MISTRY

Having around 7 plus years of work experience in Business intelligence, Data Analytics using Tableau Desktop, Tableau Server, and Power BI• End-to-End experience in designing and deploying data visualizations using Tableau and Power BI• Proficient in design and development of various analytical and interactive dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization, and others making use of actions, local and global filters according to the end user requirement.• Understand and synthesize complex data into executive summaries and maintain operational metrics, key performance indicators used in making business decisions.• Working on the development of Dashboard reports for the Key Performance Indicators for the top management.• Hands on experience in working with Tableau Desktop and Power BI - Building quick views, Sorting, Grouping, Hierarchy, Table Calculations, Functions, Advanced Filtering, Sets, Parameters, SQL Joins, Data Blending, Data Extracts, Incremental Refresh, Packaged workbooks.• Worked with On-Premises Gateway to refresh & schedule the data sources/creating a live connection with SQL Server, Flat Files (Excel and CSV) to Power BI Cloud.• Experienced in providing the Row Level Security for reports/dashboards by assigning the roles using DAX Expressions in Power BI Desktop and SSAS.• Experience in creating Power BI Embedded reports and dashboards for users.• Extensively made use of extracts from various data sources to ensure optimal performance and deployed automated refresh of extracts on Tableau server on pre-determined schedules.• Expertise on Tableau Desktop to analyze and obtain insights from large data sets• Designed and deployed reports with drill up, drop down menu option, Parameterized Linked reports, and parameters used in multiple tableau objects like sets, calculated fields, filters, reference lines, etc. • Manually developed various analytical advanced visualizations like Pareto charts, waterfall charts, etc. to achieve client requirements. • Good experience in writing DAX in MS Power BI Desktop.• Good experience on Power Query. • Involved in trouble shooting, performance tuning of reports and resolving issues within tableau server and reports.