
Having a knowledge on IT with in Business Intelligence tools like Power BI & SQL. Having good experience in Power query, Power pivot and Power view for creating the effective reports. Connected to different kind of data sources from Power BI like Azure SQL Data warehouse, Azure Analysis Services, SQL Server, Excel, etc. Worked on visual interactions using edit interactions to make few visual to effect data based on requirement. Worked on creating Data modelling using Star & Snow flake schema. Good experience in performance tuning of Power BI report & DAX optimization. Experience in creating dashboards in Power BI cloud service. Experience in scheduling dataset refresh. Experience in using like Bookmark, Drill through and Drill down in the report. Experience in implementing Row Level Security (RLS). Experience on enabling various types of filters for reports. Involved in importing/migrating data from Excel, SQL Database into Power BI Desktop.. Used DAX functions like logical, aggregate, conditional, time intelligence, date functions, etc. to implement business related calculations based on the requirements. Experience in creating SQL queries, stored procedures, views, etc. Good experience in tuning SQL queries. Experience in performance tuning of SQL queries & stored procedures.