Experience on MSBI (SSIS, SSRS and SSAS) and Microsoft Power BI
Experience in database design, data modelling, development, implementation, ELT and reporting in Power BI
Created reports in Power BI preview portal utilizing the SSAS Tabular using Power BI Gateway
Created Dynamic time-based calculations like MTD, QTD, YTD, Prior, %YoY etc.
Created Dynamic security in Tabular Model for two types of users based on requirement
Created Custom columns and Conditional Columns in the Power BI and transformed data using Power Query
Created various measures and columns in Power BI Modelling using Data Analysis Expression
Aggregated loaded/imported data based on Report requirement meaning data at source level have day level but report requirement is to show the data at month level
Created Partitions in Tabular Model based on Quarter
Having good experience on installing and configuring Data Gateway to get data from On-Premises databases
Have done Unit Testing and solved issues, which are getting from End customers