AutomationPros.Club
Table of Contents
👥 Who are we?
We are awesome, Awesome Analytics. 😉
Awesome Analytics is the team that develops automation & dashboards used by MNCs across sectors like FMCG, Pharma, Banks, Metals and mining, Oil and gas, E-commerce, and Consulting Firms covering domains like Finance, Sales, Marketing, Inventory, Manufacturing, Supply Chain, Audit, Management team, etc.
🧔🏻 Who am I?
Hi, I am Mehul Thakkar, founder of Awesome Analytics.
I'm a Chartered Accountant by profession and a Certified Ethical Hacker by certification, but at heart, I'm a programmer driven by passion for data and problem-solving.
In my brief career of a decade plus, Awesome Analytics has had the privilege of working on financial and digital forensic audits with government agencies like SEBI, EoW, ED, CBI, and Cyber Crime.
Five years ago, we left the government sector and entered the private sector. We now provide data analytics, automation, RPA, and digital transformation consulting to many listed MNCs.
❓ Why are we doing this?
A still from our PowerBi session in Dubai packed with 100+ fantastic people and Me, along with two assistant trainers.
Getting back to the Complaint
They are frustrated with online courses. They find the same basic datasets everywhere and lack real project experience. After the courses end, they're left alone to figure out how to design solutions and create reports, with little to no help for their questions.
😢 Do you have the same complaint?
In today's data-driven world, mastering the art of analysis and automation is no longer optional. But navigating the learning curve on your own can feel overwhelming. Here’s what a great course would have:
-
Live sessions
[because you would have questions that need answers] -
Real-world Project datasets and automation solution designs.
[enough of the same dataset used by every company out there] -
A trainer who does real-world, large-scale projects.
[instead of the ones who only know what clicking on a button does] -
Monthly Update Videos
[because tech never stops evolving] -
Project assignments based on real projects with mock client/stakeholder interaction
[because you may know the software, but you need a structure to interact with stakeholders and get the requirements right!] -
Handholding in the complex and sometimes tiring world of data, automation and technology
[especially when you are hitting roadblocks] -
A community of people on the same journey
[because you grow faster together, duh! ]
👬👭 Community
We wanted a community like that but have yet to find one. Then we realised we needed to look harder and missed the most obvious place 🤦🏻♂️ - Our OWN Whatsapp Community!!!
We have an active community of 2300+ people who are connected with us for ONE SIMPLE REASON
We solve their Excel and Power BI queries with our project and practical experience. All of this for free!
The first group was created eight years ago on 28th April 2015.
So, here’s what we realised:
- We have the project experience [100+ projects every year!]
- We have trained 12000+ people in person over last 10 years.
- We already have the community.
- We already provide counselling to many who are looking to enter this field.
All we needed to do was bring these elements together to make your life Awesome!
😎 Introducing the Automation Pros Club
Your safe space to get trained, work on real-life projects, and get all the support from a team of experts and, most importantly, the community!
▶️ What technologies will we focus on?
For starters PowerBi. We will eventually add more!
▶️ Let’s talk about the Schedule
With,
- a decade of experience in 100+ projects annually
- 12,000+ members trained
- a 2000+ member community,
we are now combining it all to create a very deep learning experience for you.
Here’s what to expect:
Active Training
- Two hours of live training – seeing/learning!
- One hour of practical – doing!
Session Dates and Time – all sessions on Sunday
- 07th Jan, 24 – 9 am to 12
- 14th Jan, 24 – 9 am to 12
- 21st Jan, 24 – 9 am to 12
- 28th Jan, 24 – 9 am to 12
- Every week, you will be given one assignment.
- You have to spare just 120 minutes to execute the assignment.
- You will have 6 days to do that, that’s is just 20 minutes per day
- The Awesome Analytics builds many client projects every year
- We will discuss those case studies with you in our learning sessions and also as a part of The Leverage
Active Implementation
What is the best way to be a power bi consultant? Well, act like one! Presenting The Consultant Capstone project
- The Capstone Project is about using everything you learned in month one from training and assignments and executing a real-world PowerBi project brief.
- The Awesome Analytics team would give you a real project they have worked on.
We will be the client, you will be the consultant.
- This will require a total of 16 hours in the entire month to build [probably more if you go deeper]
- This is only for people who want to go deep, so if you opt-in, you execute the project.
- Note: If you do not opt-in, you still get to see the results and presentations of those who participated.
Active Learning
Setting The Leverage Routine
Information Technology never stops evolving. So, what’s your leverage to stay updated? Our fortnightly updates
- Depending on the kind of information we want to show/share, we will create summarized written and/or video updates.
- The updates will be about Excel, PowerBi, Python, Ai, things we learned from our projects, and things affecting the data analytics and automation industry!
- A session that is aimed at addressing your queries and discussing tech.
- Working on a project? Have queries? Ask Away!
- Duration – 1 hour+, depending on how many people join in and have questions.
DAX Weekly – Recorded [Add-on package]
- One no-nonsense video on DAX every week.
- That’s 13 videos on just DAX!
- Many learners feel overwhelmed by the complexity of DAX functions in PowerBi.
- We will make it easy for you.
Following Monthly Routine – The Leverage
- Depending on the kind of information we want to show/share, we will create summarized written and/or video updates.
- The updates will be about Excel, PowerBi, Python, Ai, things we learned from our projects, and things affecting the data analytics and automation industry!
- A session that is aimed at addressing your queries and discussing tech.
- Working on a project? Have queries? Ask Away!
- Duration – 1 hour+, depending on how many people join in and have questions.
⏩⏩⏩ Python Course!
🚩 Python Course [Add-on]
Four sessions of 3 hours each on Sunday
- Two hours of live training – seeing/learning!
- One hour of practical – doing!
Session Dates and Time – all sessions on Sunday
- 07th July, 24 – 9 am to 12
- 14th July, 24 – 9 am to 12
- 21st July, 24 – 9 am to 12
- 28th July, 24 – 9 am to 12
- Every week, you will be given one assignment.
- You have to spare just 120 minutes to execute the assignment.
- You will have 6 days to do that, that’s is just 20 minutes per day
Chart Weekly – Recorded [Add-on package]
- One no-nonsense video on Data Visualization every week.
- That’s 9 videos on just Visualization!
- When it comes to Dashboarding, people get stuck.
- The management/client only gives this feedback, “can we do something better on the charts?”
- But what does that mean? How do you make it better? What do you need to add or remove?
- We will make dashboarding easy for you!
Following Monthly Routine – The Leverage
- Depending on the kind of information we want to show/share, we will create summarized written and/or video updates.
- The updates will be about Excel, PowerBi, Python, Ai, things we learned from our projects, and things affecting the data analytics and automation industry!
- A session that is aimed at addressing your queries and discussing tech.
- Working on a project? Have queries? Ask Away!
- Duration – 1 hour+, depending on how many people join in and have questions.
Congratulations! By this time, you already have the skill and momentum. All you have to do is continue the monthly routine with us and continue learning.
Following Monthly Routine
- Depending on the kind of information we want to show/share, we will create summarized written and/or video updates.
- The updates will be about Excel, PowerBi, Python, Ai, things we learned from our projects, and things affecting the data analytics and automation industry!
- A session that is aimed at addressing your queries and discussing tech.
- Working on a project? Have queries? Ask Away!
- Duration – 1 hour+, depending on how many people join in and have questions.
- If you buy the Full Pro package, any additional course we create for this membership up to Dec 2024 will be available to you as a part of this annual membership.
📝 Topics Covered
| Power Query | Power Pivot | PowerBi Visuals |
|---|---|---|
| Topic | Topic | Topic |
| Import Data | Calculated Columns | Various PowerBi chart types |
| Take From Folder or From File | DAX Measures | |
| Load To table VS Connection | Calculate () | |
| Promote header | Multiple Tables | |
| Replace Headers | Disconnected Tables | |
| Replace values | Time Intelligence | |
| IF Function | Calculate & Filter | |
| Queries Without Column | ||
| Reorder Column | ||
| Change type | ||
| Creating date key column | ||
| Add prefix | ||
| Blank query | ||
| Date table | ||
| Copy pasting queries | ||
| Creating a Function |
- Introduction to Python + Modules + libraries
- Introduction to Python
- Syntax and Data Types
- Data Manipulation and OpenPyXL
- Managing Excel, CSV
- Transforming data
- Automate Excel with Python
- Leveraging Excel features with Python !!
- Projects Showcase and Practical Application
- Going through multiple real projects and their workflows
- Practical project execution
🖊️ FAQs
Yes, verifiable certificates for the courses you have completed + the projects you have built with us.
No. Live sessions are only in Jan [PowerBi] and July [Python]. Also, monthly live query-solving sessions. So you don’t need to block your entire year’s weekends for us. However, the learning is a yearly thing. Our goal is to teach you something new each week!
Nope. PowerBi Desktop and Python are completely free
Nope, absolutely none.
Yes. We understand that sometimes life happens, and you miss sessions. Recordings will be available as long as you are a member.
The recordings for month 1 PowerBi live sessions will be available till month 3.
The recordings for month 7 Python live session will be available till month 9.
Yes, once you make the payment, email us at admin@awesomeanalytics.in with your GST details and the email id used while making the payment.
We have used all the tools like Discord, Telegram, Whatsapp, Slack, Circle. Nothing beats whatsapp as long as the group discipline is maintained.
So, Chat will be on WhatsApp and resources will be shared via Google Drive and Notion and our LMS
🎓 Investment
- For the ✅ practical training, ✅ year-long community access, ✅ AMAs + Monthly catchups+ Weekly and Fortnightly updates, ✅ And a year full of learnings we have a good package of options for you!
- Note these are discounted prices and are subject to change without notice. We do not want to create fake countdown timers to force you to buy now. Do not delay your learning and success if you need what we have to offer. 😇
📄 Links to Enroll now
🎓 Terms & Conditions
- All the materials built for the course, during, and using the course material are Awesome Analytics's intellectual property.
- Any attempt to download the videos or distribute any content without the express permission of Awesome Analytics will be seen as copyright infringement, leading to legal action and immediate termination of course and community access without any refund.
- Your admission is subject to confirmation and screening by Awesome Analytics. If your profile does not pass the screening process for being part of the community we are building, then Awesome Analytics reserves the right to cancel your admission. In such a case, you will receive a full refund of the fees paid.
- The admission/seat is neither transferable nor refundable. Refund is provided only if your admission gets rejected under screening.