Complete Data Analyst Bootcamp From Basics To Advanced
-
Introduction To The Course
-
Getting Started With Python
-
Complete Python With Important LibrariesGetting Started With VS Code With Environments0sPython Basics-Syntax And Semantics0sVariables In Python0sBasic Data Types In Python0sOperators In Python0sCoding Excercise And AssignmentsConditional Statements(if,elif,else)0sLoops In Python0sCoding Excercise And AssignmentsList And List Comprehrension In Python0sList Practise Code And assignmentsTuples In Python0sTuple Assignment And Practise CodeSets In Python0sSets Assignment and Practise CodeDictionaries In Python0sDictionaries Assignments and PRactise QuestionsREal World Usecases Of List0sGetting Started With Functions0sMore Coding Examples With Functions0sLambda functions0sMap functions In Python0sFilter Function In Python0sFunction Assignments With SolutionImport Modules And Packages In Python0sStandard Library Overview0sFile Operation In Python0sWorking With File Paths0sException Handling With Try Except else finally blocks0s
-
Data Analysis With Python
-
Getting Started With Statistics
-
Descriptive Statistics
-
Probability Distribution Function And Types OF DistributionPdf, PMF, CDF0sTypes OF Probability Distribution0sBernoulli Distribution0sBinomial Distribution0sPoisson Distribution0sNormal or Gaussian Distribution0sStandard Normal Distribution0sUniform Distribution0sLog Normal Distribution0s10-Power Law Distribution0s11-Pareto Distribution0sCentral Limit Theorem0sEstimates0s
-
Inferential Stats And Hypothesis TestingHypothesis Testing And Mechanism0sP value And Hypothesis Testing0sZ test Hypothesis Testing0sStudent t Distribution0sT stats With T Test and Hypothesis Testing0sZ test vs T test0sType1 And Type 2 Error0sBaye’s Theorem0sConfidence Interval And Margin Of Error0sWhat is Chi Square Test0sChi Square Goodness Of Fitness0sWhat is Anova0sAssumptions Of Anova0sTypes Of Annova0sPartioning OF Annova0s
-
Feature Engineering With Python
-
Exploratory Data Analysis
-
SQL Course Introduction & Overview
-
Microsoft SQL Server basicsSQL Select Statement0sSQL Select Distinct0sSQL Temporary Tables0sSQL Where Clause0sSQL Order By Clause0sSQL AND & OR Operator0sSQL NOT, BETWEEN & IN Operators0sSQL Insert Into0sSQL Null Operator0sSQL Update Statement0sDelete, Drop & Truncate0sSQL Comments & TOP N0sSQL MAX & Group BY0sSQL MIN Function & Group BY0sSUM, AVG, COUNT & Group BY0sGroup BY Concept0sGroup BY Example SQL Server0sSQL Having Clause0sSQL Where & Having Clause Difference0sInner Join Concept0sInner Join Example0sLeft Join Concept0sLeft Join Example0sRight Join Concept0sRight Join Example0sLeft & Right Anti Join0sLeft & Right Anti Join Example0sFull Outer Join0sSelf Join0sUnion & Union All0sSQL Like Operator0sSQL Case in Select statement & Order BY Clause0sNested CASE statement0sSQL Data Types0sSQL Create Table0sInserting Records into All Columns of the Table0sInserting Records into Certain Columns in a Table0sCopying Data From One Table to Another0sSub Queries0sNot Null Constraint0sUnique Constraint0sCheck Constraint0sDefault Constraint0sPrimary & Foreign Key Concept0sPrimary Key Constraint0sForeign Key Constraint0sSQL Order of Execution0s
-
SQL Basics Questions
-
SQL Functions
-
Advanced SQL
-
SQL Important Interview Questions
-
Power BI Course Introduction
-
Introduction to Power BI
-
Data VisualizationCreating a Bar Chart0sCreating a Column Chart0sCreating a Pie & a Donut Chart0sCreating a Clustered Column & Bar Chart0sCreating a Line & Area Chart0sCreating a Ribbon Chart0sCreating a line & stacked column chart0sCreating a Line & Clustered Column Chart0sCreating a Scatter Plot0sCreating a Bubble Map Visual0sCreating a Table & Matrix Visual0sFormatting Table & Matrix Visual0sCreating a Funnel Chart0sGauge chart & KPI Visual0sAI Visuals in Power BI0s
-
Power Query EditorDetecting Data Types in Power BI Desktop0sData Profiling0sColumn Distribution Example0sAppending Queries0sMerge Inner Join0sLeft Outer Join0sRight Outer Join0sLeft & Right Anti Join0sFull Outer Join0sGroup By in Power Query Editor0sPivot, Unpivot & Transpose0sAdd/Transform Columns0s
-
DAX
-
Power BI Project 1, Sales Data AnalysisBusiness Requirements0sLoading Data to PBI Desktop0sData Profiling & Data Transformations Part 10sData Transformations Part 20sPrimary & Foreign Key0sCardinality0sStar Schema0sData Model Overview0sDifferent Types of Filters in Filters Pane0sTop Bottom 5 Products By Sales, Quantity and Profit0sSales Trends Over Time0sOther Requirements0sRequirement 4 DAX0sRequirement 4 Edit Interactions0sOther Remaining Requirements0sChanging Filter Behaviour for Dimension Table Slicers0s
-
Power BI Project 2, Insurance Data AnalysisDownloading & Installing MSSQL Server0sImporting Data to MSSQL Server0sLoading Data to Power BI Desktop0sTable View & Data Profiling0sAdding Slicers & Text0sAdding New Card Visuals0sAdding a Multi Row Card & a Ribbon Chart0sAdding a Bar & a Line Chart0sAdding a Donut Chart & Matrix Visual0sPublishing the Report to Power BI Service0sScheduling Refresh0sDrill Through Filter0sTesting Scheduled Refresh & Publishing the updated report0sCreating & Testing Roles in PBI Desktop0sTesting & Implementing RLS in Power BI Service0sPower BI Reports & Dashboards0sSentiment Analysis Power Query0sSentiment Analysis Adding Visuals to the Report0s
-
Power BI Project 3, UPI Transactions Data AnalysisLoading Data into Power BI Desktop0sData Profiling0sSize & Position of slicers0sFormatting the Slicers0sAdding a Page & Age Group Column0sAdding a Line Chart0sAdding a Matrix Visual0sSyncing Slicers & Applying Conditional Formatting0sAdding Bookmarks for Transactions0sAdding Bookmarks for Remaining Balance0sPublishing the Report to Power BI Service0s
-
Miscellaneous Section Power BI
-
Getting Started with Microsoft ExcelHome Tab Font Group0sHome Tab Alignment Group0sHome Tab Number Group Part 10sHome Tab Number Group Part 20sHome Tab Styles Group Conditional Formatting 10sHome Tab Styles Group Conditional Formatting 20sDraw Tab & Cell Styles0sExcel Functions Video 10sExcel Functions Video 20sExcel Functions Video 30sExcel Functions Video 40sExcel Functions Video 50sExcel Functions Video 60sExcel Functions Video 70sExcel Functions Video 80sExcel Functions Video 9 VLookUp Function0sExcel Functions Video 10 XLookUp Function0s
-
Excel Dashboard 1
-
Excel Dashboard 2
-
Power Query Editor (MS Excel)Data Profiling (Column Distribution)0sData Profiling (Column Profile & Column Quality)0sCombining Queries0sInner Join Concept0sInner Join Example0sLeft Join Concept0sLeft Join Example0sRight Join Concept0sRight Join Example0sFull Outer Join Concept0sFull Outer Join Example0sLeft & Right Anti Join Concept0sRight & Left Anti Join Example0sNulls in SQL Server & Power Query Editor0sAppending two tables0sAppending three tables0sPower Query Editor Exercise 10sPower Query Editor Exercise 20sPower Query Editor Exercise 30sPower Query Editor Exercise 40sPower Query Editor Exercise 50s
-
Excel Activity (Importing Data From SQL Server)
-
TableauWork of a Data Analyst (Story Telling)0sDownloading & Installing Tableau Public0sLoading Data into Tableau Public0sCreating Column & Bar Chart0sSaving Your Work to Tableau Public0sHorizontal & Vertical Axis0sStacked & 100% Stacked Column Chart0sStacked & 100 % Stacked Bar Chart0sCreating an Area Chart0sCreating a Line Chart0sCreating a Scatter Plot0sCreating Pie Chart & Tree Map0sCreating a Donut Chart0sCreating a Lollipop Chart0sFilters Shelf in Tableau 10sFilters Shelf in Tableau 20sSymbol & Filled Map0sFunnel & Packed Bubble Chart0sSets in Tableau0sParameters in Tableau0sSets & Parameters0s
-
Tableau Dashboard 1
-
Tableau Dashboard 2
-
Tableau Prep BuilderDownloading & Installing Tableau Prep Builder0sUnderstanding the Dataset0sConnecting to Text File & Microsoft Excel0sRemoving Additional Columns0sCleaning Orders Central Table0sCleaning Orders East Table0sCleaning Orders West Table0sAssigning Data Roles to Geographical Fields0sCombining Different Tables0sCleaning Returns Table0sJoining Tables0sCleaning Combined Table0s
-
SQL + Tableau Project (Student Depression Data Analysis)Importing Data to SQL Server0sModifying Gender Column0sAdding the Age Group Column0sColumn Distribution remaining columns0sAdding Index Column & Updating depression column0sDownloading & Installing Tableau Desktop0sBringing Data from SQL Server to Tableau Desktop0sAcademic Pressure & Student Count0sFinancial Stress & Student Count0sStudy Satisfaction & Student Count0sSleep Duration & Student Count0sStudy Hours & Student Count0sCreating the Student Count Analysis Dashboard0sPublishing the report to Tableau Cloud0s
-
SnowflakeCreating Snowflake Free Trial Account0sCreating a SQL Worksheet0sSnowflake Architecture0sSetting up a Warehouse in Snowflake0sSigning up for an AWS Account0sCreating S3 Bucket0sUploading Data to Amazon S3 Bucket0sCreating Roles using IAM0sCreating Integration Object0sLoading Data0sCreating Free Azure Account0sCreating Storage Account in Azure0sCreating Containers in Azure & Loading Data in Containers0sCreating Integration Object to Connect to Azure0sCreating the stage area & loading data in table in snowflake0s
-
Connecting Snowflake to Power BI & Tableau
-
AWS + Snowflake + Power BI ProjectCreating Amazon S3 Bucket & Loading Data into it0sCreating the Role0sCreating the Integration Object & Updating the Trust Policy0sLoading Data into Snowflake0sUnderstanding the Data0sData Transformation using Snowflake SQL0sAdding Rainfall Groups Column0sImporting Data into Power BI from Snowflake0sAdding Rainfall Analysis page in the Power BI report0sAdding Other Pages to the Power BI report0sPublishing the report to Power BI Service0s
-
AWS + Snowflake + Tableau ProjectCreating & Loading Data to S3 Bucket0sCreating the Role0sCreating the Integration Object & updating the trust policy0sLoading Data into Snowflake0sData Understanding0sData Transformation using Snowflake SQL0sConnecting Snowflake to Tableau0sCreating Charts for Monthly Usage Consumption0sCreating Charts for Cost Savings0sCreating the Dashboard0sPublishing the workbook to Tableau Cloud0s
Are you ready to embark on a rewarding career as a Data Analyst? Whether you’re a beginner or an experienced professional looking to enhance your skills, this Complete Data Analyst Bootcamp is your one-stop solution. This course is meticulously designed to equip you with all the essential tools and techniques needed to excel in the field of data analysis.
What You Will Learn:
-
Python Programming for Data Analysis
Dive into Python, the most popular programming language in data science. You’ll learn the basics, including data types, control structures, and how to manipulate data with powerful libraries like Pandas and NumPy. By the end of this module, you’ll be able to perform complex data manipulations and basic analyses with ease. -
Statistics for Data Science
Understanding the language of data requires a solid foundation in statistics. This course will take you through the key concepts such as descriptive statistics, probability, hypothesis testing, and inferential statistics. You’ll gain the confidence to make data-driven decisions and interpret statistical results accurately. -
Feature Engineering and Data Preprocessing
Data preparation is critical for successful analysis. This module covers all aspects of feature engineering, from handling missing data and encoding categorical variables to feature scaling and selection. Learn how to transform raw data into meaningful features that improve model performance and analysis outcomes. -
Exploratory Data Analysis (EDA)
Before diving into data modeling, it’s crucial to understand your data. EDA is the process of analyzing data sets to summarize their main characteristics, often with visual methods. You’ll learn how to identify trends, patterns, and outliers using visualization tools like Matplotlib and Seaborn. This step is essential for uncovering insights and ensuring data quality. -
SQL for Data Analysts
SQL (Structured Query Language) is the backbone of database management and a must-have skill for any data analyst. This course will guide you from the basics of SQL to advanced querying techniques. You’ll learn how to retrieve, manipulate, and aggregate data efficiently using SQL Server, enabling you to work with large datasets and perform sophisticated data analysis. -
Power BI for Data Visualization and Reporting
Data visualization is key to communicating your findings effectively. In this module, you’ll master Power BI, a leading business intelligence tool. You’ll learn how to create compelling dashboards, perform data transformations, and use DAX (Data Analysis Expressions) for complex calculations. The course also includes real-world reporting projects, allowing you to apply your skills and create professional-grade reports. -
Real-World Capstone Projects
Put your knowledge to the test with hands-on capstone projects. You’ll work on real-world datasets to perform end-to-end data analysis, from data cleaning and EDA to creating insightful visualizations and reports in Power BI. These projects are designed to simulate actual industry challenges, giving you practical experience that you can showcase in your portfolio.
Who Should Enroll:
-
Aspiring data analysts looking to build a comprehensive skill set from scratch.
-
Professionals seeking to switch careers into data analysis.
-
Data enthusiasts who want to gain hands-on experience with Python, SQL, and Power BI.
-
Students and recent graduates aiming to enhance their job prospects in the data science industry.
Why This Course?
-
Comprehensive Curriculum: Covers everything from Python programming and statistics to SQL and Power BI, making you job-ready.
-
Hands-On Learning: Work on real-world projects that mirror the challenges you’ll face in the industry.
-
Industry-Relevant Tools: Learn the most in-demand tools and technologies, including Python, SQL Server, and Power BI.
-
Career Support: Gain access to valuable resources and guidance to help you kickstart or advance your career as a data analyst.
Conclusion:
By the end of this course, you’ll have a strong foundation in data analysis and the confidence to tackle real-world data problems. You’ll be ready to step into a data analyst role with a robust portfolio of projects to showcase your skills.
Enroll now and start your journey to becoming a proficient Data Analyst!
What's included
- 83 hours on-demand video
- 8 articles
- 371 downloadable resources
- Access on mobile and TV
- Certificate of completion