Leave your phone number, and our counselor will call you back and answer all your questions about the course!
What is inside 8 months course
Python Python is a universal programming language. It has simple and versatile syntax, which allows you to learn it in a relatively short time. Instagram, Dropbox, Uber, Spotify and other apps made with Python. Our course will help you to master this language for back-end development
Google Sheets Spreadsheet software like Excel or Google Sheets are widely used tools for analyzing data. Google Sheets allows users to edit, organize, and analyze different types of information as well as allows collaborations, and multiple users can edit and format files in real-time.
SQL SQL is the standard language for dealing with Relational Databases. Data analyst can use SQL to access, read, manipulate, and analyze the data stored in a database and generate useful insights to drive an informed decision-making process.
Power BI Power BI is an interactive data visualization software product developed by Microsoft. Power BI allows users to see and share data and insights throughout their organization.
Python Python is a universal programming language. It has simple and versatile syntax, which allows you to learn it in a relatively short time. Instagram, Dropbox, Uber, Spotify and other apps made with Python. Our course will help you to master this language for back-end development
job applications
3
Live sessions /week
assignments
1500+
300+
career sessions
10
Don't miss your chance to become an in-demand Data specialist and restart your career in 2022!
93%
of our students get employed
Achieve success with our human-powered approach
Become a part of vibrant community with:
Regular calls
Group project work
Live sessions
Get personalised help from mentors
Book a 1-1 video call
Tag your mentor and receive fast feedback via chat or
Take practice sessions with a Career coach
Get referred to our Hiring partners
Prepare for Screening and technical interviews Live sessions
Optimise your CV and Linkedin
We will take you by the hand and lead to guaranteed result
Amitava Chowdhury
Before the course, I worked as a program manager and felt my job did not bring me professional growth and happiness. During the Data Analytics course, I got the necessary hard and soft skills to enter the dynamic Data industry. Thanks to the individual approach of the Career Service, I received 3 offers within 2 months and accepted an offer with a 40% hike. Finally, I enjoy my job and feel that I bring impact to the business!
Applied for 1000+ vacancies with Career centre
Honed job interview skills during 10+ mock interview sessions
Polished CV and Linkedin with Career coach
Learned Google Sheets, SQL, Power BI and Python on project-based assignments
How Amitava switched to his dream career with us
After: Data Analyst with 40% salary hike
Before: Program Manager
Real projects that you will build with your peers
Here are some examples:
Large raw data of million records were fetched from the YouTube channel and dumped on SQL DB to do meaningful analysis about trending videos in YouTube. Data normalization was done as the dataset had multiple entities(tables) and huge records. Various advanced SQL techniques like SQL Joins, subqueries, Windows functions, Pivot table, Groupby, etc were used to do advanced analysis.
Domain: Video analytics (YouTube)
In-depth analysis and visualization of various loan-related data of the customer forecast their defaulter status based on their credit history, education, dependants, etc. Additionally, the GDP of the country and unemployment rate were also used to find out the statistical correlation. The use of statistics and Power BI visuals helped to find meaningful insights from the data.
Domain: Banking (BFSI)
Extracted payroll data from various sources for the company, transformed using Power BI functions like DAX, Aggregation, etc using Power query. Designed interactive dashboards to view correct metrics (PPC - Per Payslip Costs) for various platforms for the leadership team to identify and improve the process and automate the payroll manual reports reducing defects and increasing efficiencies. Additionally performing Text analytics on customer surveys and analyzing pre-defect scenarios and highlighting them for respective countries’ regional managers.
Domain: HR Analytics
In this supply chain project, the supplied volume and invoice level details of all vendors(tier 1 and tier 2) for each part procured, weight and quantity, MSME type, and other categorical information were analyzed with an insightful dashboard for a Procurement Department make better supply chain strategic decisions in Power BI. The purpose of the analysis is to identify the Procurement trends, Supplier limitations, Product based supplier consolidation, and minimize cost impact to the company.
Domain: Supply Chain
The global health of countries’ data of the past 15 years for 193 countries was analyzed in Python using Pandas and visualized using matplotlib and seaborn. This dataset was primarily analyzed for humans to strive and survive under extreme conditions or pandemics like Covid. On the other hand, it helps the health insurance companies to prepare.
Domain: Healthcare
Syllabus
Tools
Google Sheets
Duration: 1 month
Group Project. Create reports for a retail store brand Group Project. Product analytics on video platform
You will learn:
Automate your work with spreadsheets using formulae
Analyse data with pivot tables
Creating dashboards via Google Sheets
Tools
SQL
MySQL
Metabase
Duration: 2 month
Group Project. Analysing investment bank portfolio Group Project. YouTube video trends analytics
You will learn:
Query database using SQL
Analysing data from several tables with JOIN
Working with string and text data
Using sub queries
Advanced SQL: window functions, database normalisation and others
CV review
Technical assessment
Technical interview
Duration: 1 week
Tools
Exploratory data analysis (EDA)
A/B testing
Duration: 1 months
Group project. Analysing credit scores for retail banking clients
You will learn:
Descriptive statistics: mean, median, mode, standard deviation
Analysis of variance (ANOVA)
Hypothesis testing
Tools
Power BI
Duration: 1 month
Group project. Visualising cost structure of a corporation Group project. Increasing profit by optimising supply-chain
You will learn:
Working with data sources in Power BI
Working with Query Editor
Visualisations in Power BI
Working with DAX
CV review
Technical assessment
Technical interview
Duration: 1 week
Tools
Python
Numpy
Pandas
Jupyter notebook
Matplotlib
Duration: 3 months
Group project. Analysing macroeconomic data on health to assess insurance risks Group project. Reducing cost of fleet maintenance
You will learn:
Basics of Python programming
Loading and analysing data with Pandas dataframes
Super fast data analytics with Numpy arrays
Creation charts and graphs with matplotlib
Technical assessment
Technical interview
Duration: 2 weeks
Prepare and polish your CV
Organise portfolio on GitHub
Prepare for technical and HR interview with career coach
Duration: 1 month
Apply to 300+ job application via our job application service
Get referred to our hiring partners
Participate in technical assessments
Participate in interviews
Work with career coach to analyse your results and traction
Learn on assignments handpicked by industry leaders
Our tutors are real business practitioners who hand-picked and created assignments and projects for you that you will encounter in real work.