Enhanced

Engagement

About the Course

Data Analysis with STATA and Power BI Workshop Series Join our Workshop Series, which is focused on data analysis using NSSO datasets with STATA and Power BI. It is designed for students, researchers, and professionals. This series provides hands-on training to analyze large-scale survey data and create impactful visualizations. Whether new to these tools or looking to advance your skills, these workshops will equip you with practical knowledge to handle, analyze, and visualize NSSO data effectively.
The sessions will begin with STATA, covering essential commands, data import techniques, and dataset management. You will learn to clean and prepare NSSO datasets, perform descriptive statistics, and conduct advanced regression and hypothesis testing analyses. The Power BI sessions will focus on creating dynamic dashboards and data visualizations to present insights effectively. You will explore tools for connecting, transforming, and modeling NSSO data for impactful reporting. Each session includes real-world examples and hands-on exercises to ensure the practical application of the skills. A final session will guide participants through a case study that combines STATA for analysis and Power BI for visualization and reporting.
Workshops will be conducted online, making it convenient for participants from any location. A certificate of participation will be awarded to those who complete the series.
This workshop series is ideal for individuals working with NSSO datasets or those seeking to integrate statistical analysis with advanced visualization techniques.
Register today and elevate your data analysis and visualization skills with STATA and Power BI.

  • 4.9 ⭐⭐⭐⭐⭐ (1068 Verified ratings)
  • 7751 learners

Course Overview

Format

This is a fully online course, providing flexibility for participants globally. Program Duration: Classes will be held from 1st Jan to 15th Feb, offering an immersive learning experience.

Eligibility

Open to undergraduate and postgraduate students, working professionals, and policymakers.

Certification

Upon successful completion, participants will receive a fellowship certificate.

About the Course

  • Understand the fundamentals and applications of STATA and Power BI for data analysis.
  • Gain hands-on experience in conducting and interpreting data analysis for public policy
  • Dive into essential research topics, including problem identification.
  • Learn to design, Analysic the resach data, Through SPSS.
  • Acquire skills in statics and advance data analysis, engagement, and scaling successful policies for broader impact.

Course Curriculum

Module 1
Extracting Data from NSSO & Introduction to STATA
  • Overview of NSSO datasets (types of data, sources, accessing data).
  • Extracting data from NSSO (tools and methods for downloading).
  • Introduction to STATA interface, basic commands, and data types.
  • Importing and managing NSSO data in STATA.
  •  
  • Downloading and extracting data from NSSO.
  • Importing NSSO datasets into STATA.
  • Data management in STATA: renaming, labeling variables, sorting, filtering.
  • Download a specific NSSO dataset and clean it for analysis.
Module 2
Descriptive Analysis & Graphical Representation Using STATA
  • Descriptive statistics (mean, median, standard deviation, frequency distribution).
  • Graphical representation in STATA (histograms, bar charts, scatter plots, pie charts).
  • Customizing graphs and exporting them for reports.
  •  
  • Using STATA commands for descriptive statistics (summarize, tabulate, describe).
  • Creating and customizing graphs (histogram, twoway, bar, scatter).
  • Exporting graphs for reports.
  •  
  • Perform descriptive analysis and graphical representation for a provided dataset using
    STATA.
  •  
Module 3
Normality Testing & Parametric vs Non-Parametric Tests in STATA
  • Introduction to normality testing (Shapiro-Wilk test, Q-Q plots, skewness, kurtosis).
  • Overview of parametric tests (t-test, ANOVA).
  • Overview of non-parametric tests (Mann-Whitney U test, Kruskal-Wallis test).
  •  
  • Normality testing in STATA (swilk, qnorm, skewness, kurtosis).
  • Conducting parametric tests (t-test, ANOVA using ttest, anova).
  • Performing non-parametric tests (ranksum, kwallis).
  • Test a dataset for normality and conduct both parametric and non-parametric tests on
    different variables.
Module 4
Regression Analysis Using STATA
  • Introduction to regression analysis (simple and multiple linear regression).
  • Interpreting regression outputs (coefficients, p-values, R-squared, confidence intervals).
  • Model diagnostics (checking assumptions, residuals).
  •  
  • Running simple and multiple linear regressions in STATA (regress).
  • Interpreting regression outputs and diagnostics.
  • Visualizing regression results using scatter plots with fitted lines (two-way).
  • Conduct a regression analysis using a provided dataset and interpret the results, checking
    for model fit and diagnostics.
  • Extract data from the NSSO, perform descriptive and graphical analysis, run normality tests,
    and apply both parametric/non-parametric tests. Finally, conduct a regression analysis,
    interpreting the results comprehensively.
Module 4
Introduction to Quantitative Research & Basics of R
  • Overview of quantitative research (definition, data types, variables, etc.).
  • Importance of quantitative methods in research.
  • Introduction to R (installing R, RStudio, basic commands, R interface).
  • Data structures in R: vectors, matrices, data frames.
  • Installing R and RStudio.
  • Basic R operations: arithmetic, logical comparisons.
  • Creating vectors and data frames.
  • Explore R documentation and practice basic operations.
Module 5
Data Collection and Management in R
  • Descriptive statistics (mean, median, standard deviation, frequency distribution).
  • Graphical representation in STATA (histograms, bar charts, scatter plots, pie charts).
  • Customizing graphs and exporting them for reports.
  •  
  • Using STATA commands for descriptive statistics (summarize, tabulate, describe).
  • Creating and customizing graphs (histogram, twoway, bar, scatter).
  • Exporting graphs for reports.
  •  
  • Import and clean a provided dataset.
Module 6
Descriptive Statistics & Data Visualization
  • Descriptive statistics (mean, median, mode, variance, standard deviation).
    Frequency distribution, cross-tabulation.
  • Introduction to data visualization (bar plots, histograms, scatter plots).
  • Using ggplot2 for visualizations.

  • Calculating descriptive statistics using R functions.

    Visualizing data with ggplot2 (bar chart, scatter plot, histogram).

  • Create visualizations for a dataset and interpret the results.
Module 7
Inferential Statistics & Hypothesis Testing
  • Introduction to inferential statistics (sampling, confidence intervals).
  • Hypothesis testing (t-tests, chi-square tests, ANOVA).
  • Interpreting p-values and statistical significance.

  • Conducting t-tests, ANOVA, and chi-square tests in R.

    Interpreting results of hypothesis testing.

  • Conduct hypothesis tests on a provided dataset and write a brief analysis.
  • Analyze a dataset of choice, applying the concepts from all four classes. Include data cleaning, descriptive statistics, visualizations, and hypothesis testing. 
Module 8
Introduction to Quantitative Research & Data Preparation in Power Bl
  • Overview of quantitative research (definition, data types, variables).
  • Importance of quantitative methods in data analysis.
  • Introduction to Power BI interface (Power BI Desktop, basic navigation).
  • Importing data into Power BI (CSV, Excel, SQL databases).
  • Data modeling and preparation (filtering, renaming, managing columns, handling missing
    data).

    • Installing and setting up Power BI Desktop.

      Importing datasets (CSV/Excel) into Power BI.

      Basic data cleaning and preparation (splitting columns, removing duplicates, filtering)

  • Import and clean a provided dataset in Power BI, ensuring the data is ready for analysis.
Module 9
Descriptive Statistics, Visualization & Reporting in Power Bl
  • Descriptive statistics in Power BI (mean, median, mode, variance, standard deviation using
    DAX).
  • Data visualization using Power BI charts (bar, line, scatter, pie charts).
  • Creating and customizing interactive dashboards.
    Introduction to Power BI’s report features (slicers, filters, drill-through).
  • Using DAX (Data Analysis Expressions) for simple statistical functions and calculations.

  • Creating visualizations: bar charts, histograms, scatter plots.

    Building an interactive dashboard with multiple visual elements.

    Adding slicers and filters to enhance interactivity.

    Calculating and displaying descriptive statistics using DAX.

  • Build a basic interactive report on a provided dataset, including visualizations and descriptive
    statistics.
  • Create an end-to-end Power BI report that includes data import, cleaning, descriptive
    statistics, and visualizations. Use filters, slicers, and other interactive elements to build a
    complete dashboard.
  •  

International Institute of SDGS & Public Policy Research

Apply Now

This Course Included :

6 Modules

Homework after each class

Learn Relevant Data Analysis Technique

Certification

Do Relevant Projects in this workshop

One-on-One Mentoring Sessions

Our Speakers

Dr. Dhaval Maheta (R, Stata and Power Bi)

Professor Veer Narmad South Gujrat University, Surat. B.E.(PRODUCTION), M.B.A. (FINANCE), N.E.T (Management), PH.D. (Management), Post Graduate Diploma in Research Methodology

Dr. Dhaval Maheta is a Professor at the Department of Business and Industrial Management, Veer Narmad South Gujarat University, Surat, with over 22 years of experience in post-graduate teaching and industry (ICICI Bank, HDFC Ltd.). His specializations include Quantitative Methods, Financial Management, Production Management, Research Methodology, and Financial Derivatives. He has presented and published 40 research papers at national and international conferences and authored several books, including Minitab Software, Statistical Analysis using R Software, Machine Learning Using R-Rattle, and Data Analysis using R. Dr. Maheta also runs a YouTube channel, "Dhaval Maheta," offering free tutorials for researchers and data scientists. He has trained over 15,000 faculty, professionals, and bureaucrats in research software and conducted over 200 training programs in Data Science, Machine Learning, and AI. He is a certified trainer for KNIME and Atlas.ti and has received awards for his KNIME tutorials.

Success Stories

International Institute of SDG and Public Policy Research. "I had the privilege of working as a researcher and Data Scientist at the International Institute of SDG and Public Policy (IISPPR). Presenting 'our paper, A Study on Analyzing Protests and Finding Policy Gaps in the Global South, at Woxsen University was a proud moment. The invaluable guidance and support I received helped sharpen my skills in data analysis and research. Currently, as a Data Scientist at IISPPR, I continue to apply these learnings to real-world problems. I am thrilled to have received admissions from the University of Wisconsin-Madison and Boston University, confident that my experience at IISPPR has given me the knowledge, abilities, and self-assurance to thrive in the field of research."

Arshad Bagde Data scientist

I am Manan Singh, a third-year student at O.P. Jindal Global University pursuing B.A.(Hons.) Liberal Arts and Humanities with a major in History. Interning at IISPPR was an amazing experience. The foundational sessions on how to write a research paper, question formation and Literature review writing were really beneficial and have come in handy to date. I would like to thank IISPPR for the opportunity they gave me.

Manan Singh Liberal Arts and Humanities

My experience with IISPPR has been incredibly enriching. My internship at IISPPR was both insightful and rewarding, particularly regarding international relations. The hands-on projects provided me with a deep understanding of global policy challenges and the intricacies of diplomatic relations. The guidance and mentorship I received were exceptional, equipping me with practical skills and a broader perspective on international governance. It was an invaluable learning opportunity that greatly enhanced my academic and professional journey."

Rangoli

I'm immensely grateful for the enriching experience of working as an intern at the International Institute of SDG's and Public Policy Research. Despite my initial apprehension due to my limited experience in the field of public policy research. I was elated to join a team that shared my interests and provided invaluable guidance. The humility, cooperation, and healthy learning environment of everyone involved surprised my expectations. This internship has transformed me, instilling confidence, a new craving for knowledge, and a deep appreciation for the support and opportunities I received. Thanking you Divya Divyanishu Vivekananda Institute of Professional Studies New Delhi BA (JMC) 4th semester

Divya Divyanishu

Frequently Asked Questions

Answer: The application deadline for the Workshop is 14th Feb 2025. We recommend submitting your application at least a few days in advance to avoid any last-minute issues.

Answer: The Workshop runs for 6 Classes.

Answer: The Workshop timeline:

Starts at- 7:00 PM

Ends at- 9:00 PM

The classes will be had on every sat and sun.

Answer: Yes, the fellowship is open to international candidates; however, candidates are responsible for securing any necessary permits required for field research.

The amount of fellowship is ₹1000.

Answer: Fellows are expected to actively engage in their research projects and participate in all scheduled activities.

Answer: There are no strict eligibility criteria; anyone can apply for the fellowship program.

Answer: No, you don’t need any specific research proposal you can directly join

Answer: Yes, fellows will receive mentorship from experienced researchers and academics throughout the program. This includes guidance on research design, data collection, and analysis.

Answer: Fellows can present their research through community workshops or presentations, depending on the project.

To apply, visit iisppr.org.in. Send your CV to admission@iisppr.in or contact us at +91 8755502998

Apply Now