Complete Data Analyst Learning Data Analyst Learning Hub LEARNING RESOURCE LIBRARY Data Analyst Learning Hub Choose a learning path, open a folder, and access your resources. Structured courses Projects & practice Career preparation Expand all Collapse all ExcelSQLPython Power BIR SoftwareTableauProjects InterviewsCareer β¦Start HereCourse roadmap, setup and learning guidance1 folderβ π00. Start HereGet oriented before you begin+ Welcome and Course Overview Complete Learning Roadmap Recommended Learning Sequence Software Installation Guide Student Progress Tracker Frequently Asked Questions β¦ExcelSpreadsheet skills, formulas, shortcuts and practice3 foldersβ π01. Excel β Basics to AdvancedComplete course materials+ Course VideosNotes and PDFsSample WorkbooksAssignmentsSolutions π02. Excel Practice FilesHands-on exercises and answers+ Beginner ExercisesIntermediate ExercisesAdvanced ExercisesAnswer Files π03. Excel Shortcuts and TipsQuick reference and productivity+ Keyboard ShortcutsFormulas and FunctionsProductivity TipsQuick Reference βSQLDatabase querying, practice and portfolio projects3 foldersβ π04. SQL β Basics to AdvancedLearn SQL step by step+ Introduction and SetupSELECT and FilteringSorting and AggregationJoins and SubqueriesCTEs and Window FunctionsAdvanced SQLNotes and Solutions π05. SQL Practice QuestionsPractice by difficulty+ Beginner QuestionsIntermediate QuestionsAdvanced QuestionsInterview QuestionsSolutions π06. SQL ProjectsBuild query-driven projects+ Project BriefsDatabase FilesSQL ScriptsResults and Reports PyPython and Data CleaningPython, Pandas, NumPy and data preparation4 foldersβ π07. Python for Data AnalysisPython fundamentals for analytics+ Python SetupPython FundamentalsData Types and CollectionsConditions and LoopsFunctionsFile HandlingNotes and Examples π08. Python Practice ProblemsCoding exercises with solutions+ BeginnerIntermediateAdvancedSolutions π09. Pandas and NumPyArrays, DataFrames and transformations+ NumPyPandas Series and DataFramesData Selection and FilteringGrouping and AggregationMerging and ReshapingExercises and Solutions π10. Data Cleaning with PythonPrepare analysis-ready datasets+ Missing ValuesDuplicatesData Types and FormattingOutliers and InconsistenciesCleaning ProjectsBefore-and-After Datasets β₯Power BIData models, DAX measures and dashboards4 foldersβ π11. Power BI β Complete CourseFrom importing data to publishing reports+ Installation and InterfaceData ImportPower QueryData ModelingDAXVisuals and ReportsPublishing and SharingCourse Files π12. Power BI ProjectsPortfolio projects from beginner to advanced+ Beginner ProjectsIntermediate ProjectsAdvanced ProjectsProject FilesSolutions π13. Power BI DashboardsExamples by business function+ Sales DashboardFinance DashboardHR DashboardMarketing DashboardOperations DashboardDashboard Templates π14. DAX and Power QueryMeasures and transformations+ DAX FundamentalsMeasures and Calculated ColumnsTime IntelligenceM LanguageTransformationsPractice ExercisesQuick Reference RR SoftwareR programming, data analysis, statistics and visualization5 foldersβ πR FundamentalsStart programming with R+ Installing R and RStudioR Syntax and Data TypesVectors, Matrices and ListsData Frames and FactorsConditions, Loops and FunctionsNotes and Practice Files πData Cleaning with RImport, clean and transform datasets+ Importing CSV and Excel FilesMissing Values and Duplicatesdplyr Fundamentalstidyr and Data ReshapingData Cleaning Exercises πStatistical Analysis in RApply statistics to real datasets+ Descriptive StatisticsProbability and DistributionsHypothesis TestingCorrelation and RegressionStatistical Analysis Exercises πData Visualization with RCharts and visual storytelling with ggplot2+ Base R Chartsggplot2 FundamentalsCustomizing ChartsMulti-Chart ReportsVisualization Practice Files πR Projects and PracticeBuild a portfolio using R+ Beginner R ExercisesExploratory Data Analysis ProjectBusiness Analytics Case StudyDatasets and R ScriptsProject Solutions β€Tableau and VisualizationCharts, dashboards and visual storytelling4 foldersβ π15. Tableau β Complete CourseConnect data and publish dashboards+ Setup and InterfaceConnecting DataCharts and CalculationsFilters and ParametersDashboards and StoriesPublishingCourse Files π16. Tableau ProjectsGuided portfolio projects+ BeginnerIntermediateAdvancedProject BriefsSolutions π17. Tableau DashboardsDashboard examples by domain+ SalesFinanceHRMarketingPortfolio Examples π18. Data Visualization FundamentalsChart choice, design and accessibility+ Chart SelectionVisual Design PrinciplesColor and AccessibilityDashboard LayoutData Storytelling Examples βStatistics and Business AnalyticsAnalytical thinking and business problem-solving5 foldersβ π19. Statistics for Data AnalysisCore statistical concepts+ Descriptive StatisticsDistributionsSamplingCorrelation and RegressionPractical Exercises π20. Probability and Hypothesis TestingProbability, intervals and statistical tests+ Probability BasicsCommon DistributionsConfidence IntervalsHypothesis TestsP-values and ErrorsPractice and Solutions π21. EDA β Exploratory Data AnalysisDiscover patterns and insights+ EDA WorkflowUnivariate AnalysisBivariate and Multivariate AnalysisVisualizationEDA ProjectsReports π22. Data Modeling ConceptsRelational data and analytical schemas+ Relational DatabasesPrimary and Foreign KeysER DiagramsStar and Snowflake SchemasFact and Dimension TablesModeling Exercises π23. Business AnalyticsTranslate business questions into insights+ Business Questions and KPIsSales AnalyticsCustomer AnalyticsMarketing AnalyticsFinancial AnalyticsBusiness Cases βProjects and Case StudiesReal-world datasets, guided projects and portfolio work6 foldersβ π24. Real-World ProjectsProject briefs, data and reports+ Project BriefsDatasetsWorking FilesFinal ReportsDashboard Screenshots π25. End-to-End Project GuidesFollow the full analytics workflow+ Problem DefinitionData CollectionData CleaningAnalysisVisualizationRecommendationsFinal Deliverables π26. Industry-Based Case StudiesPractice across different industries+ Retail and E-commerceBanking and FinanceHealthcareEducationManufacturingTechnology π27. SQL + Python Integrated ProjectsCombine querying and Python analysis+ Database and SetupSQL QueriesPython NotebooksIntegrated WorkflowFinal Reports π28. Portfolio ProjectsOrganize projects for your portfolio+ Project BriefsWorking FilesREADME and DocumentationFinal DeliverablesPortfolio Screenshots π29. Data Analysis in Real ScenariosInvestigate practical business questions+ Business ProblemsData and AssumptionsAnalysis FilesFindingsRecommendations βInterview PreparationTechnical questions, HR preparation and mock interviews5 foldersβ π30. Interview PreparationPlan and practice your interviews+ Interview RoadmapTechnical ScreeningCase InterviewsMock InterviewsPreparation Checklist π33. HR Interview QuestionsPractice structured answers+ Introduction QuestionsStrengths and WeaknessesBehavioral QuestionsSample Answers π34. Technical Interview QuestionsQuestion banks across analytics skills+ ExcelSQLPythonBI ToolsStatisticsCase Questions π35. SQL Interview QuestionsFrom basic queries to window functions+ Basic QueriesJoins and AggregationsSubqueries and CTEsWindow FunctionsSolutions π36. Python Interview QuestionsPython fundamentals and data libraries+ Python FundamentalsLists and DictionariesPandas and NumPyCoding ChallengesSolutions βCareer and Learning ResourcesRoadmaps, cheatsheets, tools and job-search support6 foldersβ π31. Resume TemplatesCreate a clear, ATS-friendly resume+ Fresher ResumeExperienced ResumeATS-Friendly TemplatesSample ResumesResume Checklist π32. LinkedIn OptimizationImprove your professional profile+ Profile ChecklistHeadline and About SectionSkills and ProjectsNetworking TemplatesProfile Examples π37. Data Analyst RoadmapBuild a structured learning plan+ Beginner Learning PathSkill Checklist30-Day Study Plan60-Day Study Plan90-Day Study Plan π38. Cheatsheets and Quick NotesFast references for your tools+ ExcelSQLPythonPandas and NumPyPower BI and DAXTableauStatistics π39. Important Resources and ToolsSoftware, documentation and dataset sources+ Software and InstallationDocumentationLearning WebsitesDataset SourcesProductivity Tools π40. Career Guidance and Job Search TipsApplications, networking and career planning+ Job Search StrategyJob PortalsApplication TrackerNetworkingSalary and Role ResearchCareer Advice βDatasets, Practice and CapstonesDatasets, exercises, mini projects and final assessments7 foldersβ π41. Datasets β Real and PracticeOrganized datasets by tool+ Excel and CSVSQL DatabasesPython DatasetsPower BI and TableauDataset Sources and Licences π42. Practice ExercisesCross-tool exercises and answer keys+ ExcelSQLPythonStatisticsPower BI and TableauAnswer Keys π43. Mini Projects β Topic WiseShort projects to build confidence+ Excel ProjectsSQL ProjectsPython ProjectsDashboard ProjectsSolutions π44. Capstone ProjectsShow end-to-end analytics ability+ Capstone BriefsRaw DatasetsWorking FilesFinal DeliverablesEvaluation Rubrics π45. Domain-Specific ProjectsProjects across business domains+ FinanceHR AnalyticsSalesMarketingSupply Chain and OperationsCustomer Analytics π46. Data Storytelling and ReportingCommunicate insights clearly+ Report WritingKPI ReportingExecutive SummariesPresentationsSample Reports π47. Presentation TemplatesReusable presentation layouts+ Project PresentationBusiness ReviewDashboard WalkthroughCapstone Presentation β Bonus and Premium ResourcesAdditional learning, updates, templates and downloadable guides4 foldersβ π48. Additional Learning ResourcesExtra tutorials and advanced topics+ Books and Reading NotesTutorialsAdvanced TopicsRecommended Courses π49. Updates and New ContentNew lessons and revised resources+ New LessonsUpdated FilesChange LogAnnouncements π50. Bonus ResourcesExtra practice, templates and checklists+ Extra PracticeSample PortfoliosAdditional TemplatesUseful ChecklistsBonus Projects πPremium ResourcesGuides, templates and interview materials+ Data Analyst Roadmap PDFExcel Cheatsheet PDFPython Quick Reference PDFPower BI DAX Guide PDFTableau Shortcuts Guide PDFProject TemplatesInterview Question BankResume TemplatesPortfolio GuideBonus Cheat Sheets
π00. Start HereGet oriented before you begin+ Welcome and Course Overview Complete Learning Roadmap Recommended Learning Sequence Software Installation Guide Student Progress Tracker Frequently Asked Questions
π01. Excel β Basics to AdvancedComplete course materials+ Course VideosNotes and PDFsSample WorkbooksAssignmentsSolutions
π02. Excel Practice FilesHands-on exercises and answers+ Beginner ExercisesIntermediate ExercisesAdvanced ExercisesAnswer Files
π03. Excel Shortcuts and TipsQuick reference and productivity+ Keyboard ShortcutsFormulas and FunctionsProductivity TipsQuick Reference
π04. SQL β Basics to AdvancedLearn SQL step by step+ Introduction and SetupSELECT and FilteringSorting and AggregationJoins and SubqueriesCTEs and Window FunctionsAdvanced SQLNotes and Solutions
π05. SQL Practice QuestionsPractice by difficulty+ Beginner QuestionsIntermediate QuestionsAdvanced QuestionsInterview QuestionsSolutions
π06. SQL ProjectsBuild query-driven projects+ Project BriefsDatabase FilesSQL ScriptsResults and Reports
π07. Python for Data AnalysisPython fundamentals for analytics+ Python SetupPython FundamentalsData Types and CollectionsConditions and LoopsFunctionsFile HandlingNotes and Examples
π08. Python Practice ProblemsCoding exercises with solutions+ BeginnerIntermediateAdvancedSolutions
π09. Pandas and NumPyArrays, DataFrames and transformations+ NumPyPandas Series and DataFramesData Selection and FilteringGrouping and AggregationMerging and ReshapingExercises and Solutions
π10. Data Cleaning with PythonPrepare analysis-ready datasets+ Missing ValuesDuplicatesData Types and FormattingOutliers and InconsistenciesCleaning ProjectsBefore-and-After Datasets
π11. Power BI β Complete CourseFrom importing data to publishing reports+ Installation and InterfaceData ImportPower QueryData ModelingDAXVisuals and ReportsPublishing and SharingCourse Files
π12. Power BI ProjectsPortfolio projects from beginner to advanced+ Beginner ProjectsIntermediate ProjectsAdvanced ProjectsProject FilesSolutions
π13. Power BI DashboardsExamples by business function+ Sales DashboardFinance DashboardHR DashboardMarketing DashboardOperations DashboardDashboard Templates
π14. DAX and Power QueryMeasures and transformations+ DAX FundamentalsMeasures and Calculated ColumnsTime IntelligenceM LanguageTransformationsPractice ExercisesQuick Reference
πR FundamentalsStart programming with R+ Installing R and RStudioR Syntax and Data TypesVectors, Matrices and ListsData Frames and FactorsConditions, Loops and FunctionsNotes and Practice Files
πData Cleaning with RImport, clean and transform datasets+ Importing CSV and Excel FilesMissing Values and Duplicatesdplyr Fundamentalstidyr and Data ReshapingData Cleaning Exercises
πStatistical Analysis in RApply statistics to real datasets+ Descriptive StatisticsProbability and DistributionsHypothesis TestingCorrelation and RegressionStatistical Analysis Exercises
πData Visualization with RCharts and visual storytelling with ggplot2+ Base R Chartsggplot2 FundamentalsCustomizing ChartsMulti-Chart ReportsVisualization Practice Files
πR Projects and PracticeBuild a portfolio using R+ Beginner R ExercisesExploratory Data Analysis ProjectBusiness Analytics Case StudyDatasets and R ScriptsProject Solutions
π15. Tableau β Complete CourseConnect data and publish dashboards+ Setup and InterfaceConnecting DataCharts and CalculationsFilters and ParametersDashboards and StoriesPublishingCourse Files
π16. Tableau ProjectsGuided portfolio projects+ BeginnerIntermediateAdvancedProject BriefsSolutions
π18. Data Visualization FundamentalsChart choice, design and accessibility+ Chart SelectionVisual Design PrinciplesColor and AccessibilityDashboard LayoutData Storytelling Examples
π19. Statistics for Data AnalysisCore statistical concepts+ Descriptive StatisticsDistributionsSamplingCorrelation and RegressionPractical Exercises
π20. Probability and Hypothesis TestingProbability, intervals and statistical tests+ Probability BasicsCommon DistributionsConfidence IntervalsHypothesis TestsP-values and ErrorsPractice and Solutions
π21. EDA β Exploratory Data AnalysisDiscover patterns and insights+ EDA WorkflowUnivariate AnalysisBivariate and Multivariate AnalysisVisualizationEDA ProjectsReports
π22. Data Modeling ConceptsRelational data and analytical schemas+ Relational DatabasesPrimary and Foreign KeysER DiagramsStar and Snowflake SchemasFact and Dimension TablesModeling Exercises
π23. Business AnalyticsTranslate business questions into insights+ Business Questions and KPIsSales AnalyticsCustomer AnalyticsMarketing AnalyticsFinancial AnalyticsBusiness Cases
π24. Real-World ProjectsProject briefs, data and reports+ Project BriefsDatasetsWorking FilesFinal ReportsDashboard Screenshots
π25. End-to-End Project GuidesFollow the full analytics workflow+ Problem DefinitionData CollectionData CleaningAnalysisVisualizationRecommendationsFinal Deliverables
π26. Industry-Based Case StudiesPractice across different industries+ Retail and E-commerceBanking and FinanceHealthcareEducationManufacturingTechnology
π27. SQL + Python Integrated ProjectsCombine querying and Python analysis+ Database and SetupSQL QueriesPython NotebooksIntegrated WorkflowFinal Reports
π28. Portfolio ProjectsOrganize projects for your portfolio+ Project BriefsWorking FilesREADME and DocumentationFinal DeliverablesPortfolio Screenshots
π29. Data Analysis in Real ScenariosInvestigate practical business questions+ Business ProblemsData and AssumptionsAnalysis FilesFindingsRecommendations
π30. Interview PreparationPlan and practice your interviews+ Interview RoadmapTechnical ScreeningCase InterviewsMock InterviewsPreparation Checklist
π33. HR Interview QuestionsPractice structured answers+ Introduction QuestionsStrengths and WeaknessesBehavioral QuestionsSample Answers
π34. Technical Interview QuestionsQuestion banks across analytics skills+ ExcelSQLPythonBI ToolsStatisticsCase Questions
π35. SQL Interview QuestionsFrom basic queries to window functions+ Basic QueriesJoins and AggregationsSubqueries and CTEsWindow FunctionsSolutions
π36. Python Interview QuestionsPython fundamentals and data libraries+ Python FundamentalsLists and DictionariesPandas and NumPyCoding ChallengesSolutions
π31. Resume TemplatesCreate a clear, ATS-friendly resume+ Fresher ResumeExperienced ResumeATS-Friendly TemplatesSample ResumesResume Checklist
π32. LinkedIn OptimizationImprove your professional profile+ Profile ChecklistHeadline and About SectionSkills and ProjectsNetworking TemplatesProfile Examples
π37. Data Analyst RoadmapBuild a structured learning plan+ Beginner Learning PathSkill Checklist30-Day Study Plan60-Day Study Plan90-Day Study Plan
π38. Cheatsheets and Quick NotesFast references for your tools+ ExcelSQLPythonPandas and NumPyPower BI and DAXTableauStatistics
π39. Important Resources and ToolsSoftware, documentation and dataset sources+ Software and InstallationDocumentationLearning WebsitesDataset SourcesProductivity Tools
π40. Career Guidance and Job Search TipsApplications, networking and career planning+ Job Search StrategyJob PortalsApplication TrackerNetworkingSalary and Role ResearchCareer Advice
π41. Datasets β Real and PracticeOrganized datasets by tool+ Excel and CSVSQL DatabasesPython DatasetsPower BI and TableauDataset Sources and Licences
π42. Practice ExercisesCross-tool exercises and answer keys+ ExcelSQLPythonStatisticsPower BI and TableauAnswer Keys
π43. Mini Projects β Topic WiseShort projects to build confidence+ Excel ProjectsSQL ProjectsPython ProjectsDashboard ProjectsSolutions
π44. Capstone ProjectsShow end-to-end analytics ability+ Capstone BriefsRaw DatasetsWorking FilesFinal DeliverablesEvaluation Rubrics
π45. Domain-Specific ProjectsProjects across business domains+ FinanceHR AnalyticsSalesMarketingSupply Chain and OperationsCustomer Analytics
π46. Data Storytelling and ReportingCommunicate insights clearly+ Report WritingKPI ReportingExecutive SummariesPresentationsSample Reports
π47. Presentation TemplatesReusable presentation layouts+ Project PresentationBusiness ReviewDashboard WalkthroughCapstone Presentation
π48. Additional Learning ResourcesExtra tutorials and advanced topics+ Books and Reading NotesTutorialsAdvanced TopicsRecommended Courses
π49. Updates and New ContentNew lessons and revised resources+ New LessonsUpdated FilesChange LogAnnouncements
π50. Bonus ResourcesExtra practice, templates and checklists+ Extra PracticeSample PortfoliosAdditional TemplatesUseful ChecklistsBonus Projects
πPremium ResourcesGuides, templates and interview materials+ Data Analyst Roadmap PDFExcel Cheatsheet PDFPython Quick Reference PDFPower BI DAX Guide PDFTableau Shortcuts Guide PDFProject TemplatesInterview Question BankResume TemplatesPortfolio GuideBonus Cheat Sheets