Power Bi Data Analyst

Shubham Singh

Data Analyst / Power BI Developer

Bhopal (M.P) 917-***-**** ************@*****.*** Linkedin GitHub Professional summary

Experienced Power BI and Data Analyst with 4 years in data analysis, visualization, and dashboard development. Skilled in creating financial dashboards, improving data quality, and delivering data-driven insights. Strong collaboration and continuous learning to stay current with BI trends.

Work experience

Albokoes EnviroSustain Pvt. Ltd November 2024 - Till Now Data Analyst / Power Bi Developer

Responsibilities:

● Designed and maintained interactive Power BI dashboards for sustainability and operational insights

● Collected, cleaned, and transformed large datasets using Power Query Editor

● Created custom KPIs, calculated measures, and drill-through reports for detailed analytics

● Connected data from Excel, SQL, cloud storage, and data warehouse sources

● Implemented scheduled refresh and incremental refresh for performance and up-to-date reporting

● Applied row-level security (RLS) for secure and role-based data access

● Deployed reports using Power BI Deployment Pipelines

● Optimized data models and report visuals following Power BI best practices

● Managed workspaces, shared apps, and assigned user roles (Admin, Contributor, Viewer) Vedam Design Technical Consultancy Pvt. Ltd.September 2022 - October 2024 Engineer - Power BI Analyst

Responsibilities:

● Built Power BI dashboards for marine and engineering projects

● Connected and cleaned Excel data using Power Query

● Optimized DAX formulas and data models

● Analyzed fuel consumption across 16 vessel operations (e.g., towing, supply)

● Created KPIs and visual reports for fuel efficiency tracking

● Published and shared reports with automated refresh and role-level security Microtechnologies India October 2021- August 2022

Data Analyst / Power Bi Developer

Responsibilities:

● Develop interactive and user-friendly Power BI dashboards and reports

● Connect to various data sources like Excel, SQL Server, SharePoint, and cloud platforms

● Perform ETL operations using Power Query and Power BI Dataflows

● Create data models and relationships for optimized performance

● Write DAX formulas for calculated columns, measures, and KPIs

● Implement row-level security (RLS) for data access control

● Automate data refresh schedules and monitor data pipeline health

● Collaborate with stakeholders to gather business requirement

● Publish reports to Power BI Service and manage workspace access

● Design and share Power BI apps with appropriate user roles (Admin, Contributor, Viewer)

● Ensure data accuracy, consistency, and follow visual best practices

● Integrate Power BI with other tools like Excel, Teams, and SharePoint Technical Skills

Analytical Skills:-

● Power BI Desktop: Data Import, Data modeling, report/dashboard creation, Power Query, Forecast in power BI, web Scraping in power bi, Dynamic Reports

● Power BI Service: Getway, Schedule Refresh, Incremental Refresh, RLS, OLS Security, Embedded report, Download, Sharing Report etc

● DAX: Data transformation, calculation, and optimization

● ETL: Data extraction, transformation, and loading processes

● Data Visualization: Interactive dashboards, KPI visualizations, drill-through reports, Forecasting, Paginated Report etc

● Microsoft Fabric:

● MS-SQL Server: Trigger, Store Procedure, Transaction, ACID Properties, Joins, Index, View, Window Function, CTE, Joins, Constraints, Operators etc.

● Advanced Excel: Vlookup, Hlookup, Xlookup, DGet, Range Lookup, Match, Index, Aggregate Functions, Power Pivot, Power Query, Conditional Formatting, Macros etc.

● Python: Jupyter Notebook, Pandas, Numpy, Matplotlib, Seaborn.

● AWS Cloud: EC-2 Instance, S3 Bucket, CloudFront, DynamoDB Education

Rajiv Gandhi Proudyogiki Vishwavidyalaya Bhopal, Madhya pradesh Bachelors of Engineering (BE) in Civil engineering 2017 Awadhesh Pratap Singh University Rewa, Madhya pradesh PG Diploma of Computer Application 2018

Projects

Data Visualization with Power BI

● E-Commerce Analysis

● GHG EmissionAnalysis

● ESG Analysis Report

● Real Estate Project

● Vessels Fuel Consumptions Analysis

● Vessels Productive and Non-Productive Analysis

● Chess matches Analysis

● Covid Pendnamic Analysis

● IPL Matches Analysis

● Food Delivery Analysis

Contact this candidate