Book Free Demo
Data & Analytics

Data Analyst (Python, SQL & Power BI)

Live online training with real-time projects, then resume marketing, mock interviews and placement support with US employers.

60 Days (8 Weeks)Live online, US time zonesNext batch Dec 1Certificate
Python logoPythonPandas logoPandasMySQL logoMySQLMatplotlib logoMatplotlib
  • Live instructor-led classes
  • Real-time project work
  • Resume writing & marketing
  • Mock interviews & placement

Course overview

Data analysts turn raw data into answers that businesses act on. This 60-day intensive program teaches the three skills US employers ask for most: Python, SQL and Power BI.

Month one covers Python for data analysis with Pandas, visualization and exploratory analysis. Month two covers SQL, from basic queries to window functions, and Power BI dashboards you can publish and share.

A 60-day intensive program: Python for data analysis in month one, then SQL and Power BI in month two, with projects on real-world datasets.

01Week 1Introduction to Python3 topics
  • Days 1-2: Python setup with Anaconda and Jupyter Notebooks
  • Days 3-4: Variables, data types, conditionals and loops
  • Days 5-7: Functions, modules and libraries (NumPy, Pandas)
02Week 2Data handling with Pandas3 topics
  • Days 8-9: Series and DataFrames
  • Days 10-12: Data cleaning, missing values and duplicates
  • Days 13-14: Filtering, sorting and grouping data
03Week 3Exploratory data analysis (EDA)4 topics
  • Days 15-16: Visualization with Matplotlib and Seaborn
  • Days 17-18: Descriptive statistics: mean, median, mode, standard deviation
  • Days 19-20: Outliers, correlation and covariance
  • Day 21: Case study: EDA on a sample dataset
04Week 4Advanced data analysis4 topics
  • Days 22-23: Time series data: resampling, shifting, rolling
  • Days 24-25: Text data: string operations and cleaning
  • Days 26-27: Merging and joining data with Pandas
  • Day 28: Final Python project on a real-world dataset
05Week 5SQL basics and queries4 topics
  • Days 29-31: Relational databases and setup (MySQL/PostgreSQL)
  • Days 32-34: SELECT, WHERE, LIMIT and ORDER BY
  • Days 35-37: INNER, LEFT, RIGHT and FULL OUTER joins
  • Days 38-39: GROUP BY, HAVING, COUNT, SUM and AVG
06Week 6Advanced SQL3 topics
  • Days 40-41: Subqueries and nested queries
  • Days 42-43: Window functions: ROW_NUMBER, RANK, DENSE_RANK
  • Days 44-45: CTEs, views and indexing
07Week 7Introduction to Power BI3 topics
  • Days 46-48: Power BI Desktop, Service and Gateway
  • Days 49-51: Importing data from Excel, SQL databases and CSV
  • Days 52-53: Cleaning and transforming data with Power Query
08Week 8Visualization and dashboards3 topics
  • Days 54-56: Charts, maps, tables and KPIs
  • Days 57-58: Interactive dashboards with filters, slicers and drill-throughs
  • Days 59-60: Publishing and sharing reports in Power BI Service

Who should take this course?

Graduates, career changers and professionals from finance, operations or business backgrounds who want to work with data. No prior programming experience is required.

Roles you can apply for

Data AnalystBusiness Intelligence AnalystReporting AnalystJunior Data Scientist

Get course details & fees

Your details stay private. No spam.

Talk to us

Mon–Fri, 9 AM–6 PM CST

+1 (512) 666-7460Email us
How it works

From registration to your first offer

Training is only half the job. One team guides you through every stage until you're hired.

Register & get counselledPick the right course for your background with a free advisor call.
Step 1 of 5
Related

You may also like

FAQ

Data Analyst course FAQ

Who can join the Data Analyst course?+

Graduates, career changers and professionals from finance, operations or business backgrounds who want to work with data. No prior programming experience is required.

How long is the Data Analyst course?+

The live training runs 60 days (8 weeks), followed by resume preparation, resume marketing and interview preparation.

Is placement support included?+

Yes. After training we prepare your resume, market your profile to hiring employers and prepare you with mock interviews before client interviews.

Do I get a certificate?+

Yes. You receive an Ace IT Careers certificate that employers can verify online.

Start your Data Analyst career

Book a free demo class and get the full syllabus, batch dates and fees.