Mohammed Ashfaq K

Power BI Developer

Concentrix India Pvt Ltd

07.2022 - Current

Having around 3 years of professional IT experience.
Having around 3 years of experience with business intelligence tools like Power BI (Power BI Desktop and Power BI Service).
Experience in connecting with multiple data source like SQL Server and Excel from Power BI to build complex dataset.
Extensively worked on performing the ETL activities in Power Query.
Good experience in cleaning the unwanted data in power query.
Extensively used transformations like Merge Queries, Append Queries, Pivoting the column, Un-Pivoting columns
Adding custom columns, Splitting the columns, Merging the columns.
Extensive experience in doing Data Modelling in Power Pivot model.
Extensively worked on enhancing the data model by Creating New Columns, New Measure and New calculated tables using DAX functions.
Hands-on experience with visual level, page level, report level, and drill-through filter for filtering the data in a report.
Good experience in creating hierarchies and drill-down reports.
Good experience in sorting the data in visualizations, grouping, and binning the data in Power BI.
Experience in publishing the report to the Power BI service and setting up the necessary connection.
Implemented row-level security (RLS) as part of security in Power BI.
Experience in VB.NET, Microsoft SQL Server, and Crystal Reports.
Good experience with Microsoft SQL Server, including stored procedures, functions, indexes, views, triggers, joins, DML, and DDL SQL statements.
Coordinated deployments of new software, feature updates and fixes.