Excel slows down at a few lakh rows, and every monthly report means repeating the same clean-up steps by hand. Python handles a 10-lakh-row file in seconds, and once you write the steps as code, next month's report runs again with one click.
This course is built for data work, not software development. You learn enough Python to load files, fix messy columns, merge tables, summarise numbers and draw charts, then use it on sales, customer and finance data. Pick the 30-hour course for Python and Pandas, or the 45-hour package if you also want statistics, interactive dashboards, report automation and a first look at machine learning.
Data analyst job posts in India usually ask for three things: Excel, SQL and Python. Python is the one that lets you automate. Interviewers often give a CSV file and ask you to clean it, find the top products and plot a trend. That is exactly what this course trains.
You don't need any coding background. Basic Excel helps because many ideas carry over: filters become df[df["city"] == "Delhi"] and Pivot Tables become pivot_table.
Want Excel, Power BI and SQL with Python? See the Data Analytics with AI programme. Want machine learning, deep learning and GenAI? See Data Science with AI. You can also pair this course with Advanced Excel, Power BI or SQL Server.
Installing Anaconda, Jupyter Notebook and VS Code. Variables, data types and operators. Writing and running your first scripts.
Practice: A small calculator and a GST amount calculator.
if/else, for and while loops, writing functions, default arguments, and simple error handling with try/except.
Practice: A data validation script that flags wrong phone numbers and emails.
Lists, tuples, sets and dictionaries. Reading and writing text, CSV and Excel files. Basics of objects and classes, only as much as data work needs.
Practice: A file processing utility that merges several CSV files into one.
Arrays, indexing, broadcasting, and fast calculations on large numeric data.
Practice: Calculate monthly growth for 1,000 products in one line instead of 1,000 formulas.
DataFrames and Series, loading data, selecting rows and columns, filtering, sorting, new columns, groupby and aggregation, pivot tables, merge and join, and concat.
Practice: Sales data analysis by region, product and month.
Missing values, duplicates, wrong data types, text clean-up, date parsing, outliers, and basic feature creation such as month, quarter and age group.
Practice: Clean a messy customer file and prepare it for analysis.
Matplotlib and Seaborn: bar, line, histogram, box plot, scatter plot, correlation heatmap. Telling a story with charts. Basic Git and GitHub to save and share your notebooks.
Project: A full exploratory data analysis (EDA) report on retail sales data, uploaded to your GitHub.
Mean, median, spread and distributions. Correlation vs causation. Hypothesis testing, p-values and confidence intervals, explained with examples. A/B test basics.
Practice: An A/B test on two marketing campaigns: did the new one really work?
Plotly for interactive charts and Streamlit for a simple web dashboard you can share.
Project: An interactive sales dashboard in Streamlit.
Reading from SQL Server with pandas.read_sql, writing formatted Excel reports with openpyxl, scheduling a script to run on its own, and sending the output by email.
Practice: A script that builds the monthly MIS Excel report from raw data automatically.
A simple prediction model (linear regression) and customer grouping (K-means) with scikit-learn, and how to judge if a model is any good. Using ChatGPT or Copilot to write and explain Python code, and how to check AI-written code before trusting it.
Project: Customer segmentation on purchase data, written up for a manager.
Pay a small amount now to hold your seat. Pay the rest when you join.
Takes about a minute
EMI and No Cost EMI are offered by Bajaj Finance and Payment Gateway Partners. They depend on Bajaj Finance approval, admin approvals, documents and terms.
Data Analyst
Python Data Analyst
MIS Analyst
Business Analyst
Reporting Analyst
Junior Data Scientist
Research Analyst
Operations Analyst
Extra 10% off on the spot admission.
Get 50% off on MDA Program
View Details
Learn AI with real projects - Get 40% off on AI Courses
View Details
Become a Tax & Accounting Pro - Extra 10% off on CEA Program
View Details
Start Building for the Web - Extra 10% off on Full Stack Program
View DetailsNo. Python is one of the easiest languages to read, and this course only teaches what you need for data. Most students load and filter their first data file in the second week.
Package 1 is 30 hours and covers Python basics, NumPy, Pandas, data cleaning, charts and one EDA project. Package 2 is 45 hours and adds statistics, Streamlit dashboards, automating Excel and SQL reports, an introduction to machine learning and using AI tools to write code, with 3 projects in total. Choose Package 2 if you want to automate reports or move towards data science.
No. A general Python course teaches software development, such as building apps and websites. This course focuses on data: reading files, cleaning them, analysing them and making charts. If you want Python for development, take our Python Programming course.
It helps but is not required. Many students do Advanced Excel first, then SQL, then Python. If you are short on time, Python alone is fine: we cover the data ideas from the start.
Yes. Classes run in the classroom in Delhi, Gurgaon and Ghaziabad, and live online, with weekday, evening and weekend batches. Call +91 98188 45002 (Ghaziabad: +91 92203 99033) or WhatsApp +91 99903 49899 for the next batch date.
Yes. Python is one of the tools in Data Analytics with AI, depending on the path you pick. This course teaches only the Python part, in 30 to 45 hours: Python basics, NumPy, Pandas, data cleaning and charts. Pick it if you already know Excel and want to handle bigger data files with code. For Excel, Power BI, SQL and Python together, choose Data Analytics with AI.
2,800+ student ratings on Google, Justdial & UrbanPro.
Real words from learners who trained with F1 Macro Technologies.
I joined this data analyst coaching and it was really helpful. The teacher explained every concept in a simple and clear way. The classes covered Excel, SQL, Power BI, and Python with real examples. Doubt sessions were great, and I got personal help whenever needed. Best for beginners who want to start a career in data analysis
Sahil Panwar
Data AnalyticsF1 Macro is Referred By My Friend After That I Join the Classes for Data Analysis Course My Excel Class is Complete Good To Understand, Power BI Class is Running, Excellent To Understand the Classes Of Power BI from Rohit Sir, Advance Excel, SQL, VBA and Python By Krishna Sir All Doubt are Clear at Same time. Thanks
Ankur Pandey
Data AnalyticsHello I'm Vivek Yadav...I have enrolled master of data analytics thanks for giving me the opportunity to be a part of F1 macro. I have learned a lot from here which I am gonna cherish all my life .. thank you so much teachers for your kind support.
Vivek Yadav
Data Analytics - MDAThe institute has amazing and supportive faculty members. They provide with multiple assignments along with study material as well as resolve any queries related to the assignment. I highly recommend F1 Macro Technologies for anyone looking to build a strong foundation in data analysis.
Divya R Nair
Data AnalyticsI have just completed my Data Analyst Training from F1 Macro Technology, Delhi. I enjoyed my training over there. The course was designed by experts and not only theory but hands on experience was good in class. Each and every concept was taught from the basics. They covered all the aspects which will help you in Future.
Tarun Gupta
Data Analyst Training | Placed in MNCI have done MCCA course from F1 Macro and I am lucky because I got a good and supportive teaching staff here. Now I got a job in India's biggest IT company Telus International - all thanks to the entire team of F1 Macro Technologies.
Ali Jawad Zaidi
MCCA + Data Skills | Placed at Telus InternationalHi, I am Amit from Bangalore. I have attended Data Analytics basic tools like Excel, SQL, Python, Power BI from F1 Macro Technologies and I can proudly say one should go for their courses as the faculties and the study materials are really good.
Amit Prakash
Data Analytics (Excel, SQL, Python, Power BI)My name is Mukesh Goyal from Jaipur. It's a wonderful platform for good learning. I really learnt from F1 Macro Technologies courses - SQL Server, Advance Excel, Power BI, VBA, Python. Overall good experience. Thanks to all staff and management for this opportunity to learn and earn.
Mukesh Goyal
Data Analytics + ML | Career Switcher from JaipurMy name is Ankur Sharma, and I live in Gandhi Nagar, Delhi. I enrolled in the Data Analyst course at F1 Macro technologies Institute Laxmi Nagar, and my experience has been very positive. The institute provides highly knowledgeable and supportive teachers who explain concepts clearly and help students understand even complex topics with ease. They are always available to solve doubts and provide guidance whenever needed. One of the best things about the institute is the digital notes and study materials, which make learning more convenient and effective. The course content is well-structured and industry-oriented, helping students build practical skills in Data Analytics. I would highly recommend F1 Macro Institute to anyone looking to learn Data Analyst and improve their technical skills in a supportive learning environment.
Ankur Sharma
Data AnalyticsI am Avinash Singh, currently pursuing the Data Analytics course at F1 Macro Technologies. The training is well-structured, and the instructors explain concepts clearly. The hands-on projects and practical approach have helped me improve my skills in Excel, SQL, Power BI, and Data Analytics. I highly recommend this institute to anyone looking to build a career in data analytics.
Avinash Singh
Data AnalyticsGuides and career stories from our trainers and students.
Accounting
Financial Accounting: A Beginner-to-Job-Ready Guide
Learn the basics of accounting: the main rules, Profit and Loss, Balance Sheet, Cash Flow, the accounting cycl...
Read article
Web Design
Web Design: The First Impression of Every Business
Your website is often the first thing a customer sees. See what web designers build, the skills they need and...
Read article
Data Analytics
Data Analyst: The Rising Power of Data
Businesses now plan sales, stock and hiring from data. See what a data analyst does each day, the tools they u...
Read article
Check your eligibility and apply online.
12th pass
For 12th Passed in Current & Previous Year
Apply Now
Commerce & arts
For College Students in B.Com / BBA/ B.A/ M.Com/ MBA/ M.A
Apply Now
IT & computers
For College Students in BCA/ BSC (IT), B.Tech, MCA, MSC (IT), M. Tech
Apply Now
Special support
For Students with Disabilities & Economically Weaker Section (EWS)
Apply Now
We do not own these logos. Company names and logos belong to their owners. We show them only to mark where our students got jobs. F1 Macro Technologies is not a partner of these companies and is not endorsed by them.
Learners from our placement records, now working in the roles they trained for.
Placed
Placed
Placed
Placed
Placement assistance helps you prepare and apply; it is not a job guarantee.
See how F1 Macro Technologies is bridging the gap between education and employment. Explore where our students are working today.
to understand your profile and plan the next career move!
Call us+91 98188 45002
We use cookies to understand how people use our site and to improve our ads. You can accept all, reject the optional ones, or choose. Privacy Policy
