This course has
- 8-week long Analytics masterclass covering all the industry-relevant skills(SQL, Python, Advanced Excel, Stats, Tableau, SAS)
- Mentorship for placements
- On-demand doubt clearing sessions
Introduction to queries and subqueries. Select, aggregate, joins, group by, order by, where statements, logical operations. Nested queries and SQL interview prep
RDBMS Movies Assignment, UBER Assignment SQL Quiz
Excel Charts and Plotting, Advanced Tips and Tricks, keyboard shortcuts. Pivot Tables, Advanced Excel Dashboards with slicers and filters. Power Query and Power Pivot.
Build a HR Dashboard Build an Interactive Sales Dashboard Build a Pivot Dashboard
User defined functions in VBA. VBA Message box, how to create VBA add-ins, VBA SSO object, Loops in VBA. If and else statements, VBA case statements
Build an SQL query editor in Excel
Sets, parameters, groups, custom visualizations, dashboards, dynamic calculations, dynamic calculations, table calculations. Data Storytelling and visual narratives
Build Sample Superstore Dashboard Build a Covid-19 Dashboard
Basics: Working with strings and numbers. Date types: tuples, dictionaries, lists. If statements, case statements. Loops: while loop, for loop. Exception Handling. File I/O. Object Oriented Programming
Build the game Bollywood Build the game Tic tac toe
Introduction. Real Life Example of a Python/Pandas Data Analysis project. Jupyter Notebooks Tutorial .Intro to NumPy. Intro to Pandas. Data Cleaning . Reading Data from other sources. Matplotlib and Seaborn
Titanic EDA with pandas Numpy Seaborn Matplotlib
SAS libraries. Infile options dealing with missing data. Formats & in-formats standard and non standard data. Dataset options. Import & export procedures. Proc print and proc sort. Combining the datasets. Proc SQL: introduction to SQL. Macros
SAS Quiz Burger Singh Growth Story
Modelling distributions. Exploring bivariate numerical data. Study design. Random Variables. Sampling Distributions. Confidence Intervals. Significance Tests. Two sample inference between groups. Chi-squared tests. Advanced Regression. ANOVA.
Statistics Assignment and Quiz
₹4999 ₹2449 only