in the business world we live in today companies use tools to look at numbers and make decisions just having a lot of data from transactions is not enough to really understand what is going on unless we can make sense of it and show it in a way that is easy to see this project is about creating a system for business intelligence using the adventure works dataset which is from a company that makes bicycles and is available in a simple format called csv we took the data put it into microsoft power bi then we cleaned it up made it look nice with power query we used some ways to organize the data like star schema relationships and cardinality management we figured out some numbers like revenue and profit we also looked at return rate how different customers are we used something called data analysis expressions or dax for short to calculate these numbers we made a dashboard that people can use to look at the data this dashboard shows what is happening each month it also shows where sales are coming from and how well products are doing it shows what customers are doing we used microsoft power bi to make this dashboard this study shows how business intelligence tools can turn raw organizational data into valuable insights that improve managerial decision-making keywordsbusiness intelligence power bi data modeling dax kpi sales analysis dashboard.
Business Intelligence, Power BI, Data Modeling, DAX, KPI, Sales Analysis, Dashboard
International Journal of Trend in Scientific Research and Development - IJTSRD having
online ISSN 2456-6470. IJTSRD is a leading Open Access, Peer-Reviewed International
Journal which provides rapid publication of your research articles and aims to promote
the theory and practice along with knowledge sharing between researchers, developers,
engineers, students, and practitioners working in and around the world in many areas
like Sciences, Technology, Innovation, Engineering, Agriculture, Management and
many more and it is recommended by all Universities, review articles and short communications
in all subjects. IJTSRD running an International Journal who are proving quality
publication of peer reviewed and refereed international journals from diverse fields
that emphasizes new research, development and their applications. IJTSRD provides
an online access to exchange your research work, technical notes & surveying results
among professionals throughout the world in e-journals. IJTSRD is a fastest growing
and dynamic professional organization. The aim of this organization is to provide
access not only to world class research resources, but through its professionals
aim to bring in a significant transformation in the real of open access journals
and online publishing.