Sai

Projects:

Project 1: MIS Reporting - Sun Pharma:

Tools                   : Power BI

Database              : MS SQL Server

Ø Gathering business requirements from various users of different Departments.

Ø Building, publishing customized interactive reports and dashboards, report scheduling using Power BI server. 

Ø Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI. 

Ø Executed and tested required queries and reports before publishing. 

Ø Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

Ø Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Ø Created New Calculated Column and Measure using DAX Quick Expression.

Ø Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Power BI.

Ø Provided support for Power BI developed objects and understand tool administration.

Ø Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure. 

Ø Worked in Power BI environment to create dashboards like weekly, monthly, daily reports using Power BI desktop & publish them to server.

Project 2: Kellogg’s in Retail industry:

Tools                    : Power BI

Database              : MS SQL Server

Ø Gathering business requirements from various users of different Departments.

Ø Building, publishing customized interactive reports and dashboards, report scheduling using Power BI server. 

Ø Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Power BI. 

Ø Joins to update the database and retrieve data for data analysis and validation.

Ø Mastered the ability to design and deploy good visualizations with Drill Down and Drop-down menu option and Parameterized using Power BI.

Ø Created various views in Power BI like Text tables, bar charts, stacked bar, Heat Maps, Geographic maps, Line chart, Pie charts etc.