This course has
- covering all the industry-relevant skills(SQL, Python, Advanced Excel, Stats, Tableau, SAS)
- for placements
- On-demand 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
Aman is the co-founder of Prepleaf. Project Management is his blood and veins as he has 4 years of work-ex being a team lead in EXL services as a Data Analyst and other VC funded start-ups. He also loves analytics, is passionate about entrepreneurship and of course, poker.
Kunj is an analytics consultant to AmEx at EXL services. He is an alumni of Aalto University Finland & IIT, Kanpur, and has worked with multiple start-ups in the past. He is passionate about Data Visualization, playing Basketball and Innovation.