Business intelligence - project
gbadebo94
ResidencyPresentation.pptxBusiness Intelligence at Blackrock
By
Emmanuella Omeife, Oluwatobi Elugbadebo,
Muthu Krishnan Selvam & Rakesh Reddy
Agenda
Introduction
Blackrock Overview
Business Intelligence Overview
Blackrocks Database
Results
Next Steps
Summary
Blackrock Overview
Blackrock Overview
Organization Overview: Blackrock is a major Asian food chain established in 2001 with over 100+ restaurant locations in the United States
Current Challenge: Blackrock’s leadership team is interested in learning how they can harness their data to make better business decisions
Research Question:
How can Blackrock utilize Microsoft PowerBI to compare the popularity between Soba, Ramen & Pho ?
To help blackrock, we helped them to solve on their major challenges which is to compare popularity between soba , etc
Business Intelligence Overview
Definition: Process by which businesses analyze current and historical data using technological tools in enhancing strategic decision-making and staying ahead of the competition.
Purpose: Business intelligence tools have made it easier which process big data sets from many sources and deliver insights in visual representations that are easy to grasp and distribute.
Example of BI Tools: Power BI, Tableau, Datephine, Google Studio, Microstrategy, Zoho Analytics
Business Intelligence
Brand Positioning: Organizations can Identify trends that might enable them make effective decisions on their brand
Efficiency: Business Intelligence supports more effective decision making by relying on data-driven strategies and insights
Competitive Advantage: Business Intelligence supports knowledge sharing and organizational innovation, which can enable organizations develop a competitive advantage. (Eidizadeh et al., 2017)
Business Intelligence Benefits
For example, you can look at when your restaurant is busiest, change your staffing plan, and deal with the demand increase.
Blackrocks Database
Assessment: Blackrock’s current database contains over 100,000 customer and marketing data.
Next Steps: To show Blackrock how business intelligence tools can support them, we decided to solve an ongoing problem the team was having in comparing the popularity between Soba, Ramen, and Pho
Current Database Assessment
For example, you can look at when your restaurant is busiest, change your staffing plan, and deal with the demand increase.
Inputs: Google Trends search history on Pho, Ramen, and Soba
Tool: Microsoft's Power BI.
Benefits of Power BI: Rich features, superior accessibility, user friendly and embeddable attributes
Application
Results
Results and Findings
This graphic was extracted from our final Power BI report. It compares the number of times Pho, Ramen, and Soba were searched every year since 2016.
Here are some of the findings:
Ramen is consistently the most searched category amongst the three categories
Soba is the least searched category
Ramen and Pho are more popular in the united states than Soba
Results and Findings
This graphic was also extracted from our final Power BI report. It compares the number of times Pho, Ramen, and Soba were searched since 2016.
Its findings are consistent with our first graphic. It shows that;
Ramen is consistently the most searched category amongst the three categories
Soba is the least searched category.
Ramen and Pho are more popular in the united states than Soba.
Next Steps & Summary
Next Steps
Integrate Power BI to Blackrock’s database
Provide change management training to managers to encourage adoption of this tool
Summary
Blackrock’s leadership was interested in comparing the popularity between Pho, Soba, and Ramen
Power BI, a business intelligence tool, was used to determine the popularity of these meal categories
The findings revealed that Ramen was the most popular category, followed by Pho
By incorporating BI tools such as Power BI, Blackrock can easily understand trends and make more effective business decisions
Thank you
References
Eidizadeh, R., Salehzadeh, R., & Esfahani, A. C. (2017). Analysing the role of business intelligence, knowledge sharing and organisational innovation on gaining competitive advantage. Journal of Workplace Learning.
