Project Details

Situation - Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

Task - 1) Answer Ad- hoc requests. 2) Build a dynamic dashboard.

Action - 1) First loaded the data in MySQL workbench and ran SQL queries to answer Ad-hoc requests. 2) Then established a connection between MySQL workbench and PowerBI for building the dashboard. 3) Finally built the presentation using Canva and conveyed the insights to the stakeholders.

Result - The best XI from past 3 years :- Faf duPlessis, Jos Buttler, Surya Kumar Yadav, Shimron Hetmyer, Andre Russel, Rinku Singh, Klaasen, Rashid Khan, Shami, Bumrah, Chahal.

Project video

Project Details

Situation - AtliQ Hardwares is one of the leading computer hardware manufacturers and is also well established in other countries. The management team requires Excel reports to review their customer performance and measure their market performance against the target for the years 2019, 2020, and 2021.

Task - 1) Provide an excel report for individual customer performances for the 3 years. 2) Provide an excel report for measuring the company's performance against the targets across various countries.

Action - 1) First, I loaded the dataset in the Excel. 2) Then performed data cleaning using Power Query. 3) Established the relationships between various tables using data modelling. 4) Created the required DAX measures. 5) Finally, used power pivot to generate the reports.

Project video

Project Details

Situation - Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

Task - There are 10 ad hoc requests for which the business needs insights. It requires to run SQL queries to answer these requests.

Action - 1) I loaded the dataset in MySQL workbench. 2) Then ran SQL queries to answer the Ad-hon questions. 3) Then created a presentation using Canva to convey the insights to the stakeholders.

Project video

Project Details

Situation - AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.

Tasks - 1) Answer Ad-hoc queries. 2) Build a dynamic dashboard.

Action - 1) Firstly, loaded the dataset to MySQL workbench and PowerBI. 2) Then ran SQL queries to answer the Ad-hoc queries. 3) Then, built the dynamic dashboard on PowerBI. 4) Finally, created the presentation to convey the insights to the stakeholders.

Project video

Project Details

Situation - Shield Insurance is one of our potential clients but they want to be assured that we are capable enough to handle their massive dastasets. So, they want us to first work on a this pilot project and then they will give us the main project.

Task - 1) Create a dashboard to according to the client mockup.

Action - 1) First, I understood the client's requirements. 2) Then I Created the feature list. 3) Then created a mockup of the final dashboard using Powerpoint. 4) Seeked feedback from the client over the mockup. 5) Then, I created the final dashboard. 6) Finally presented the dashboard to the client.

Project video

Project Details

⏩ Situation -

AtliQ Motors is an automotive giant from the USA specializing in electric vehicles (EV). In the last 5 years, their market share rose to 25% in electric and hybrid vehicles segment in North America. As a part of their expansion plans, they wanted to launch their bestselling models in India where their market share is less than 2%. Bruce Haryali, the chief of AtliQ Motors India wanted to do a detailed market study of existing EV/Hybrid market in India before proceeding further.

⏩ Task -

📌 Answer primary insights

📌 Answer secondary insights

📌 Build a dynamic dashboard analysing the Indian EV landscape.

⏩ 𝗔𝗰𝘁𝗶𝗼𝗻 -

📌 Firstly, I created a dynamic dashboard analysing the EV landscape.

📌 Secondly, I answered the ad-hoc requests using PowerBI.

📌 Finally, I answered some secondary questions based upon my own research.

Project video