Domain: Telecom Function: Executive Management
AtliQo is one of the leading telecom providers in India and launched it’s 5G plans in May 2022 along with other telecom providers.
However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022. Atliqo’s business director requested their analytics team to provide a comparison report of KPIs between pre and post-periods of the 5G launch. The management is keen to compare the performance between these periods and get insights which would enable them to make informed decisions to recover their active user rate and other key metrics. They also wonder if they can optimize their internet plans to get more active users. Peter Pandey, a junior data analyst is assigned to this task.
Imagine yourself as Peter Pandey and perform the following task
Other resources Provided:
Domain: Hospitality Function: Revenue
Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.
Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.
You are a data analyst who has been provided with sample data and a mock-up dashboard to work on the following task. You can download all relevant documents from the download section.
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/tier1 cities in the next 2 years.
AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers on a daily basis so that they can respond swiftly to these issues.
The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘on-time delivery (OT) %’, ‘In-full delivery (IF) %’ and OnTime in full (OTIF) % of the customer orders on a daily basis against the target service level set for each customer.
Peter Pandey is the data analyst in the supply chain team who joined Atliq Mart recently. He has been briefed about the the task in the stakeholder business review meeting. Now Imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task
Other resources Provided:
A real-time data analytics project to add to your resume.
An opportunity to learn data analytics using business use cases and datasets.
The top 3 submissions will get an attractive prize.
Every qualified submission gets an appreciation certificate.
30% scholarship on our premium courses for all qualified submissions.
Reach out to the Codebasics team at theDiscord Channel
Excellent presentation by you Sir.I am privileged to learned this course by you to learn real time project which make me got to know more about actual exploration of data analysis. THANK YOU
Thanks a lot CodebasIcs team for your valuable Time & Effort.., Guys how are searching for an Power BI Course can take this without hesitation, Im sure it will help you a lot on not only in this BI tool also we can gain Real time experience. Give It a shot Worth compared to other Courses in market.
This course is the full package! it teaches and exemplifies the job of a data analyst in a working environment. The lessons are easy to understand and follow, and the assignments are tasking and challenging.
It was a fantastic experience doing this course. Learned so much more about Data Analytics than in any other course available on the internet.
This course was very detailed and clear. Thanks a lot for all your efforts in making such a wonderful course.
This course is my first step towards carrier transition from mechanical engineering to Data Analytics .Here i Learn a lot new tool and technologies how they can work ,it is a best course and best platform to get a feel of how a fresher real data analyst initialize his work in a organization,Thank you Dhavel Sir, Thanks Codebasics.....!!!
Absolutely the best Project available on Internet, what make this project special is, you learn everything in detail about data analytics. All i can say is Thankyou
It's a premium course taught by the experts in the Data Industry ! Have taken so many different courses from various platform for BI tools, this course is absolutely opposite and to the next level ! Thank you Dhaval Patel sir and codebasics team for launching such a amazing course !
Best learning platform compared to other ones. A perfect skill stack to boost your knowledge as well as the career. Thank You Code Basics Team
No data analytics course is as good as this course , I personally feel that This course has so much potential to change a person and build so much confidence in him that he can face any challenge in the industry very easily and I am enjoying this part of learning
WOW, This was a Wonderful course for beginners who start their carrier in data analytics , as well as for the experienced person from different domain. I am telling this because, I am from a different domain. It was blended with Technical stuffs & Project Management skills. Thank you Dhaval Patel sir & Hemanand Vadivel sir for making this fruitful course.
Great Course! The course is very insightful and professional. The chapter were clear and informative. Thank You so much...nice experience...
Excellent. Best most efficient way to go from beginner to advanced. I would love to see another course that does a deeper dive into doing the same thing, but with more M, all the external tools (tabulator editor 3, dax, data dictionary automation, etc), dna enterprise master date table with offset, I have every reason to believe this group could pull it off. Take BI user from advanced to expert.
The course have make me to have a direction in the new career that I choose, that I can do it with determination, although this is my first time of going through the course of which I plan to go through it like twice, to enable me create different Reports on my own. There so many tools to learn actually which will come with a lot of practices, I can not wait to become a master in this field. Thank
Great learning experience with real time project example, its take lot of time to me for completing the course since its not about only using tool, instead I learn to use this tool for generating useful insight from data with respective business problem.
A perfect course for data analysis in which you get real world case scenarios to study and get hands-on, to get job ready in data analytics world. Thank you Dhaval Patel for a wonderful experience!!
I am from commerce background, still this course helps me in learning power bi well thnks sir 🙏🙏 for making such an amazing platform for learning power bi in a simple way.
This course really helped me to get rid of the naivety I had in my mind about how exactly a data analytics project would look like in a real business setting, and it really helped in my learning process. Also, Dhaval sir's teaching style is very unique and I think that helped me a lot in reducing the time I took to understand each concepts.
I loved this course. I learned a lot from this course and enjoyed the way you taught us every lesson. Wish you all the best and thanks for starting such an amazing course. I will also be with Codebasics in my learning of new technology.
Exceptionally designed course which has power to turn any non tech fellow to kick start in the world of DATA. Course takes you through the almost all aspects and all stages of data analysis process performed by the seasoned data professionals in the real time scenario.
By far one of the best course related to Data Analysis I have come across. Rather than just learning what the tool does and the functions in it, you gain an overall perspective on approaching and utilizing Power BI from a project point of view. It is a brilliant course! I recommend this course to anyone in the field of analytics or ones who are looking to start afresh or switch their career.
Thank you Sir for such a wonderful course, very nicely explained, and seriously it is like working on real project, got some real project exposure. Please make course on other technologies also in Future.
Absolutely awesome. The way that this course teaches and the value of the information that it gives is something that you don't find anywhere else. In love with Peter Pandey
As promised, this course is 5X of YT playlist. It took me around 3 weeks to complete this course with my full-time job, as always I loved the course and learnt a lot. Mainly the mimicking of real time project scenarios with meeting sessions is so real and can give true exposure to working in corporate. The course is abundant on tips and knowledge of data analytics. I strongly recommend it.
This is my first online course. The project-based learning method is really easy to understand. This course covers end to end business processes and helped me to gain good knowledge of business domain and some soft skills. Thanks to Dhaval and Hemanand for this awesome course. I am confident that, after finishing the course I can work on my own to solve more complex problems.
I completed this course a few days ago and trust me it is one of the best courses because it teaches you about Power BI through a project (practically) rather than focusing only on theory. Now I have joined several Power BI groups on LinkedIn & Telegram and I was even able to answer the queries & it felt really amazing to contribute back to the community. I'll definitely recommend this course :)
As a beginner Power BI learner with over 100 practice hours previously, after completing the course I must say this course definitely gets you job ready skills.
Was a great kickstart to my goal of data analytics in Power BI. Totally worth the money
Amazing work, great description and loved the way things are explained in such a simple and effective manner. Looking forward for more such technical courses to learn.
It's a wonderful course that helped me learn Power BI by creating a project. It is one of the best courses I have attended so far. This course starts up with a problem statement and drives you through real project-like scenarios and also provides you with a few soft skills that will help you grow in your career. Overall it was an amazing experience. Thanks a lot, Dhaval and Hemanand sir.
Thank you very much for this course @codebasics & @Hem! You did a great job creating this course! Congrats!
After 10 years of working in a different field when I wanted to make a career transformation, I stumbled upon "Code Basics" YouTube channel and from there to this course. I am still grateful for the day I did. I am 85% through the course and pretty much confident I can transition into a Data Analyst's role easily. Wish I could Thank you Personally
The course is really insightful as the course structure is designed in such a manner that a beginner in this Data Analytics domain gets to work in a guided real industry relevant project . The project has really ignited my interest to learn and practice from similar projects in order to gain meaningful insights by doing similar in depth Analysis in Power BI.
Completed 40% of the Course. To be Frank, this course makes me feel like I am working in the Real Time working conditions. The uniqueness about the course is how to build the soft skills which is very crucial while learning the technical skills. Never felt bored or heavy and each tutorial feels like watching a favorite movie...My Big Thanks for Dhaval and Hemanand Sir for this amazing concept.
I would definitely recommend this course to anyone who is looking forward to starting a career in Data Analytics. It covers all the required topics from the basics to state of the art. The teaching style of Dhaval Patel is amazing. Kudos to Hemanand Vadivel
The quality of the course is outstanding in every aspect and your way of teaching (No words to describe it, you are the best at what you do). No second thought about it. The video quality, that too in 4k is just a Visual Wonder for me. You and 'Hemanand Vadivel' Sir have created awesome content.
Almost 40% through my course, and I must say the course is very detailed and pragmatic! I like it how you motivate at the beginning of each new section in the chapter. It's like you're reading my mind + absolutely love how I can update my review like a reflection journal.
I just completed 50% of the course, I am feeling like I am working as a data analyst in a startup company. it is very practical actually. I 100% recommend this course. it helps me a lot. thanks, code basic team for designing such nice content at an affordable price.
I bought Both courses and they are more than 7 stars!!! Your courses are very great!! I really appreciate it.
Thank you so much for the valuable content. The way of your teaching was very impressive and it makes me understand the concept very easily. And also I have watched your powerbi, python, data structure youtube playlist, those are the best videos I have ever seen. It all helps me to get prepared for the interview.
Watched your YouTube videos got inspired to switch to data analytics and after completing this course can proudly say that now i know data analysis and PowerBi in detail... Dhaval sir ty😊
This is one of the best courses that are available on the internet. The project-based learning that takes you through the problem statement and possible solutions which makes it amazing. It is worth every penny and hats off to the team for making it more affordable.
The course has helped build confidence in my data analytics career. I have managed to learn not only the technical aspects but also the soft skills plus Dhaval Patel has got a lot of humor which makes the course more interesting and engaging.
I highly recommend this course. Sir Dhaval and he's team did a great job in preparing this course. The way industry terminology are presented in a comic pattern helps even a newbie to understand financial analytics in business, domain knowledge and effective communication to stakeholders through engaging story telling via visualization.
This course come with full package of knowledge which is very necessary for every data analyst to learn. In this course every basic detail and wide concept are provided in such a way that anyone can learn easily even a nontechnical background.
This course was really interactive. I had learnt Excel and MySQL individually at some point but couldn't fathom the connections among this data analytics tool. But this course connected the dots for me and the role plays made it a realistic one. I am confident to continue my pursuit for Sales operations or Supply chain analyst role.