AKASH R

Administrating and Monitoring Power BI Cloud such as Work spaces, Users, Security, Premium Capacities. Worked with all the products in Power BI Such as Power BI Desktop, Power BI Pro, Power BI Report Server, Power BI Premium, Power BI Service, Power BI Mobile and Power BI Embedded. Created and developed Dynamic and Static Row-Level-Security in Power BI Desktop according to the roles assigned to the users. Installed and Configured Power BI gateway(Personal/Enterprise) to schedule daily jobs to refresh reports/dashboards in Power BI Service. Used Power Query 'M' language for Data Cleansing Activities in Power BI Desktop Editor. Wrote DAX Language to write and analyze analytical data. Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL Designed SSIS ETL Packages for Data Transformation Activities Such as Slowly Changing Dimensions, Conditional Split, Multicast, Derived Column, Lookup, SQL Task Developed Geo locator Dashboard with ArcGis Visual in Power BI showcasing the geo coordinates of the site .

Developed different types of reports such as Descriptive, Predictive, Prescriptive for end-users. Assisted in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections Created mapping tables to find out the missing attributes for the ETL Packages Developed Azure Machine learning models to predict the future analytical results. Designed Power BI Custom Visuals and Integrated in Power bi desktop using D3 Java Script, Type Script and Power BI modules. Developed Measures, Calculated Columns, Conditional Columns, Custom Columns in Power BI. Automated Power Query refresh using power shell script and windows task scheduler. Developed T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. Created and Designed dashboards and reports for business executives, stakeholders and project managers to showcase the progress. Created, Managed, Scheduled Pipelines in Azure Data Factory. Worked with both the version in Azure Data Factory such as V1 & V2 Development level experience in Microsoft Azure providing data movement and scheduling functionality to cloud-based technologies such as Azure Blob Storage and Azure SQL Database. Wrote U-SQL Scripts to transform RAW Data in to meaningful data stores and data lakes Created Copy activities and linked service for both source and destination Databases.

Hands-on working on projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI. Developed Custom Visualization in Power Bi such as Fuel tank, Liquid fill Gauge, Charts. Worked on Data Cleansing Part in Power BI desktop using concepts such as, Merge Columns, Merge Queries with necessary joins, Pivot, Unpivot and Transpose columns and rows in query editor Created the KPI to show the difference between actual, budget and forecast data using visuals such as DUAL KPI, KPI and Power KPI