I utilized 'Microsoft SQL Server Management Studio' to edit queries and analyzed 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data. For visualization, I leveraged 'Microsoft Power BI', and for deeper analysis, I employed MS Excel along with Power BI's query tool.

Data Wrangling, EDA using Pivot tables and Dashboard Visualization of Bike Purhasers to analyse the possible patterns and factors behind the Bike purchasing consumers. ETL,Storytelling,Web Scraping & Data Integration using Excel and Power Query

This is a personal data analysis project of mine, I used MS Excel and Power BI to do the whole data analysis processes. The dataset is inputted manually from text invoices into spreadsheets. I used Excel with some Power Query to sort the dataset from monthly sales data into a yearly sales data, and created a dashboard using Power BI.

AI-powered clinical trial matching system combining rule-based checks with LLM analysis. Processes XML patient data, queries clinicaltrials.gov API, and generates eligibility reports with detailed explanations. Features hybrid matching logic and automated Excel/JSON outputs.

Used Adv. Excel i.e Power Query, Power Pivot along with Adv DAX to perform data science jo analysis

SQL & Excel Data Analysis Project Includes SQL queries, CSV/Excel input and outputs, Power BI dashboard and Word report with linked results.

As part of a 75-day data analysis challenge, this work on Excel deals with data transformation using Power Query Editor

A complete Power BI Student Result Analysis Dashboard with toppers, KPIs, subject insights, mark ranges, and data modeling using Excel, Power Query & DAX.

Interactive Excel-based Adventure Works Sales Analysis Dashboard featuring Time Series Analysis, Product Insights, Customer Segmentation, Pricing Analysis, and Geographical Profitability. Built using Excel 365 with Power Query, Pivot Tables, and advanced visualizations. Perfect end-to-end data analytics portfolio project.

Data analysis projects involving Excel and SQL combine the power of spreadsheet software like Excel with the querying and manipulation capabilities of SQL to extract insights and make informed decisions from datasets.

LLM Based Data Analyst Assistant : AI-powered data analysis platform that transforms natural language into data insights. Query databases and Excel files using conversational AI in any language. Built with Llama3 LLM.

End-to-end Sales & Financial Analysis using Advanced Excel, including ETL with Power Query, data modeling, DAX measures, and dynamic Pivot Table reports for business decision-making.

Sales data analysis project using Excel. Data was cleaned with Power Query, modeled using Power Pivot, and visualized through an interactive dashboard. The project highlights trends, patterns, and key insights to support better decision-making.

Comprehensive analysis of UPI transactions across banking apps, uncovering monthly trends, market share insights, and seasonal patterns. Data efficiently processed using Excel Power Query and analyzed with PostgreSQL.

In this Data Analysis in Power BI! I explore the world of data analysis, data visualization and insights using the Microsoft Power BI. This project showcase my skills with DAX, Power query, custom sorting, data modelling in Excel, cardinality, time intelligence functions and how i transform raw data into visually appealing and interactive report

COVID-19 Data Analysis Dashboard uses Power BI to analyse Covid-19 data and provide valuable insights. The data is cleaned and transformed using Excel and Power Query Editor. Dashboard is created with KPIs, Visualizations, filter and slicers to analyse the trends and patterns associated with Covid-19 Data

Excel Ride Hailing Dashboard inspired by Indrive includes data cleaning, transformation, and KPI analysis using Power Query, Pivot Tables, and DAX. Dataset (1,000 rows, 18 columns) generated with AI, featuring visuals for revenue, rides, and performance insights. Tools: Excel + ChatGPT.

Performed end-to-end data analysis on Zomato restaurant data using Excel, MySQL, Power BI, and Tableau, including data cleaning, transformation, and date-based analysis. Built SQL queries to generate KPIs on restaurant growth, ratings, pricing, and online delivery trends. Developed interactive dashboards with filters, slicers.

An Excel dashboard created on learning, mission, and manager aspirations using survey data by standardizing datasets with power query, pivot tables for dynamic insights. Delivered comprehensive analysis of aspirations through interactive charts and tables.

This project builds essential skills for 2025 Data Analyst roles, covering Python, SQL, and Power BI. It includes hands-on practice with data analysis, querying, dashboarding, Excel, statistics, and real-world case studies to support job readiness and interviews.

Comprehensive technical guide to real-world data analytics in Microsoft Excel. Covers data import with Power Query, cleaning, advanced formulas (SUMIFS, FORECAST.ETS, etc.), PivotTables, DAX in Power Pivot, statistical analysis, interactive dashboards, VBA automation, and practical business case studies. Includes formulas, step-by-step examples

Performed comprehensive analysis on Netflix shows and movies dataset using multiple tools. Conducted exploratory data analysis (EDA) in Python, queried and managed data with MySQL, processed and analyzed data in Excel, and created interactive dashboards in Power BI to uncover trends in release patterns, genres, ratings, and cast/director insights.

Fnp_Sales_Analysis — An interactive sales dashboard and analysis of 1,000 orders (₹35,20,984 total revenue) that surfaces key insights by occasion, category, time (day/month), top products, and top cities. Built from CSV/Excel data and prepared with Power Query,

Analysis of revenue and profit trends across multiple categories, subcategories, and countries, conducted using Power BI, Excel, and Power Query. The project provides data-driven insights into high-margin products, underperforming items, and top customer segments, with dashboards created to inform strategic decisions and drive business growth.

The data science bootcamp data science training is rigorous and packed with challenges covering concepts, theories, and projects that include the following Course 1: Introduction to Data Science Course 2: Analyzing and Visualizing Data with Excel Course 3: Analyzing and Visualizing Data with Power BI Course 4: Analytics Storytelling for Impact Exploratory Data Analysis: 1st Data Science Project Course 5: Ethics and Law in Data and Analytics Course 6: Querying Data with Transact SQL Course 7: Introduction to Python for Data Science Data Querying and Cleaning: 2nd Data Science Project Course 08: Data Science Research Methods: Python Edition Data Science Research Methods: 3rd Data Science Project Course 09: Essential Math for Machine Learning: Python Edition Course 10: Principles of Machine Learning: Python Edition Machine Learning: 4th Data Science Project Course 11: Developing Big Data Solutions with Azure Machine Learning Course 12: Implementing Predictive Analytics with Spark in Azure HDInsight Course 13: Analyzing Big Data with Microsoft R Data Science BootCamp: Final Capstone Project Course 14: Introduction to R for Data Science Course 15: Essential Math for Machine Learning: R Edition Course 16: Data Science Research Methods: R Edition Course 17: Principles of Machine Learning: R Edition

No description available

No description available

Exploratory Data Analysis with Microsoft Excel Power Query.

Data analysis with excel, power pivot, power query, and pivot tables

Data professional survey analysis with Power BI, Power Query and Excel