Mohammad Rashid

Excel & Power BI · Data and Business Intelligence Analyst

Profile photo of Mohammad Rashid

Services

High-impact deliverables tailored to your business.

Excel Automation

Automate workflows with advanced formulas, pivot tables, LOOKUPs, and reporting dashboards that save hours of manual work.

Power BI Dashboards

Design and deploy interactive dashboards with clean data models, DAX, and scheduled refresh for real-time insights.

Data Preparation

Clean, consolidate, and transform data using Power Query and SQL for analysis‑ready datasets that drive decisions.

About

Computer engineer and Freelancer with expertise in data analysis, advanced formula automation, visualization, and dashboard creation. Skilled in Excel and Power BI to enhance business efficiency. Over 6 years of freelance experience in the Data & Business Intelligence profession.

If you're looking for a skilled Excel and Power BI data and business intelligence analyst to turn your data into valuable insights or develop dynamic dashboards for your business needs, contact me. I'm here to help you unlock the true potential of your data!

Resume

Download my latest resume or view it online.

Mohammad Rashid — Data & BI Analyst

Excel, Power BI, DAX, Power Query, Data Modeling

Skills

Excel

  • Data manipulation and analysis
  • Advanced formulas and functions automation
  • Pivot tables
  • LOOKUPs (VLOOKUP, XLOOKUP, INDEX/MATCH)
  • Templates creation
  • Data visualization and dashboard creation
  • Data cleaning and transformation
  • Data transformation using Power Query
  • Data consolidation
  • Excel spreadsheet formatting
  • What-if analysis

Power BI

  • Dashboard design and development
  • Data transformation and manipulation
  • Power Query
  • Data modeling
  • DAX (Data Analysis Expressions)
  • Scenario and sensitivity analysis
  • Report automation and replication

SQL

  • Relational querying and data extraction
  • Joins, aggregations, and subqueries
  • Window functions for analytics
  • Data modeling for BI (star/snowflake)
  • Performance tuning basics (indexes, EXPLAIN)
  • ETL with SQL and views

Projects

Browse by domain and open project pages. Add or remove sections easily.

Finance dashboard preview

Financial Budget Dashboard Report

Microsoft Excel Power BI DAX Microsoft Powerpoint

Stock trading Excel automation preview

Stock Trading Excel Advanced Formula Automation

Microsoft Excel Advanced Formulas Dashboard reporting

Social Listening Dashboard

Social Listening Analysis Dashboard Report

Microsoft Excel Power BI DAX Dashboard Design

Imanco Marketing Solutions Dashboard preview

Imanco Marketing Solutions Dashboard for Founder

Microsoft Excel Power BI Power Query DAX Dashboard creation

ApexHouse PropFlow Dashboard preview

ApexHouse PropFlow Dashboard for CEO

Microsoft Excel Power BI Power Query DAX Dashboard creation

Construction dashboard preview

Construction Agency Dashboard Report

Power BI Power Query DAX Dashboard Replication

Rehabilitation Center Dashboard Report

Rehabilitation Center Dashboard Report For Executive

Power BI Google Sheets Automation Data Transformation DAX Dashboard Design Replication

Sales dashboard preview

Sales Performance Dashboard Report

Power BI Power Query DAX

Regional sales report preview

Regional Sales Report

Power BI DAX Hidden Page Navigation Microsoft Powerpoint

Sales Pipeline Dashboard preview

Sales Pipeline Dashboard

Microsoft Excel Power BI Power Query DAX Dashboard creation

Goods' Store Sales Dashboard preview

Goods' Store Sales Dashboard

Power BI Power Query DAX Hidden Filters Dashboard creation

Amazon & Shopify Multi-Channel Sales Report preview

Amazon & Shopify Multi-Channel Sales Report

Windsor.ai API Integration Power BI Power Query DAX Dashboard creation

E-commerce scenario analysis preview

E-commerce Scenario and Sensitivity Analysis

Power BI What-If Analysis Scenario Analysis Sensitivity Analysis DAX Microsoft Powerpoint

Pharmaceutical Business Dashboard preview

Pharmaceutical Business Dashboard

Microsoft Excel Power BI Power Query DAX Dashboard creation

Udemy E-learning Analysis Dashboard preview

Udemy E-learning Analysis Dashboard

Microsoft Excel Power BI Power Query DAX Dashboard creation

Ads performance dashboard preview

Detailed Ads Performance Dashboard Report

Microsoft Excel Pivot table Dashboard

Employees insights preview

Employees Insights Dashboard Report

Power BI Power Query DAX

Employee Resource Group (ERG) Analytics preview

Employee Resource Group (ERG) Analytics

Microsoft Excel Power BI Power Query DAX Dashboard Design Dashboard Replication Microsoft Powerpoint

Pricing Strategy & Market Perception Dashboard preview

Pricing Strategy & Market Perception Dashboard

Power BI Power Query DAX Dashboard creation

Restaurant report preview

Southern Prefecture Restaurant Report

Power BI Power Query Data Transformation DAX Drill Through What-If Analysis

E-commerce dashboard preview

Magento E-commerce Dashboard Report

Power BI Power Query DAX API Windsor.ai

Item Tracker Dashboard

Item Tracker Dashboard

Power BI Power Query DAX

Sports coach dashboard preview

Dashboard Report for Sports Coach

Power BI Power Query DAX Dashboard Design Dashboard Replication Microsoft Powerpoint

Testimonials

What clients say about working together.

“I worked with Mohammad Rashid on a dashboard project and had an exceptional experience. He is highly knowledgeable, helpful, and accommodating. Rashid adheres strictly to timelines and tackles challenges with skill and determination. His positive attitude and reasonable pricing make him stand out. The quality of his work is top-notch, and he always prioritizes client satisfaction. I highly recommend Rashid for any analytical or freelancing services.”
Photo of Varsha Singh
Varsha Singh
Program and Project Manager
“I have witnessed him effectively lead our intern team, fostering collaboration and creating a positive work environment that motivated everyone to perform at their best. Throughout the internship project, Mohammad played a pivotal role in conducting extensive research, analyzing data, and generating meaningful insights. His expertise in Power BI and Excel allowed us to visualize complex data sets and present them clearly and concisely. Moreover, Mohammad's exceptional communication skills and ability to articulate ideas effectively were evident during our team meetings and presentations.”
Photo of Vaibhav Nigam
Vaibhav Nigam
Deputy Manager, KP Group
“I recently had a session with Mr. Mohammed, and I was very impressed by his expertise and guidance. He taught me the tools, techniques, and best practices for creating dashboards and how to publish my work online. He was very patient, clear, and helpful—answering all my questions and giving valuable tips and feedback. I learned a lot and feel more confident in my data analysis skills. I highly recommend Mr. Mohammed to anyone who wants to learn data analysis.”
Photo of Aziza Gais
Aziza Gais
Engineering Administrator
“Rashid is a highly skilled and dedicated data analyst. He invested significant time in my project and delivered precisely what I needed. Highly recommended!”
Photo of Vaibhav Jhamb
Vaibhav Jhamb
Operations Analyst, Flipkart
“We worked on a project together where Mohammad guided me from scratch level. The way of explaining the topic was simple and understandable. Even if you have minor queries related to the project, he will definitely clear your doubts.”
Photo of Gazala Tarannum
Gazala Tarannum
SEO Executive

Resources

Curated Excel and Power BI resources I recommend.

Excel Formula Cheatsheet

Handy reference for advanced formulas and functions.

Open

Power BI DAX Patterns

Common DAX solutions for modeling and calculations.

Open

Power Query Cookbook

Reusable transformations for data preparation.

Open

Let's talk

Have a project in mind? I'd love to help.

📅 Booking Policy:

Meetings can be scheduled minimum 8 hours in advance.

Urgent Requests:

Need me on urgent basis? Feel free to connect on WhatsApp by clicking the WhatsApp icon above or by clicking on "Chat on WhatsApp" button below.

Important