COURSE OUTLINE
Data Analytics
Course Description
This course offers a comprehensive introduction to data analytics, ideal for individuals eager to explore the tools,
techniques, and methodologies essential for analyzing large datasets and deriving meaningful insights. Throughout the
course, students will gain hands-on experience with industry-standard tools and best practices, preparing them to apply
data analytics in real-world contexts. By the end of the course, participants will possess the skills and knowledge
necessary to make data-driven decisions across various industries. Whether you're a beginner aiming to launch a career in
data analytics or a professional seeking to refine your expertise, this course provides a strong foundation in this rapidly
growing field.
Prerequisite
● Beginner to intermediate-level learners with an interest in data analysis.
● Professionals looking to enhance their skills in data analysis and reporting using Power BI.
Learning Outcome:
● Data Connectivity: Understand how to connect to various data sources and import data into Power BI for
analysis.
● Data Modeling: Learn to create robust data models, organize and transform data effectively.
● DAX Proficiency: Gain proficiency in using Data Analysis Expressions (DAX) for creating calculated columns,
measures, and more.
● Visualization Skills: Develop the ability to create insightful and impactful visualizations using Power BI’s tools.
● Collaboration: Master collaboration features in Power BI to share reports and dashboards with stakeholders.
● Project Execution: Apply learnt skills to complete data analytics projects from start to finish.
● SQL and Databases: Strengthen SQL knowledge for efficient data extraction and querying in databases.
● Python: Gain a foundational understanding of how to integrate Python for advanced data analytics within Power
BI.
● Real-Life Project: Work on a real-life project to demonstrate and solidify the skills acquired during the course.
Course Module Outline
Visualization:
Class 1
Duration: 2 hours
Topic: Introduction to Power BI
Details:
● Overview of Power BI ecosystem.
● Key components: Power BI Desktop, Service, Mobile App.
● Installing and setting up Power BI Desktop.
● First look: Importing simple data.
Class 2
Duration: 2 hours
Topic: Data Loading and Transformation
Details:
● Introduction to Power Query Editor.
● Importing data from multiple sources (Excel, CSV, SQL).
● Data cleaning and shaping basics.
● Hands-on: Cleaning messy datasets.
Class 3
Duration: 2 hours
Topic: Data Modeling Basics
Details:
● Understanding data modeling and relationships.
● Creating relationships between tables.
● Using the Auto-detect feature.
● Hands-on: Building a basic data model.
Class 4
Duration: 2 hours
Topic: Introduction to DAX (Part 1)
Details:
● Overview of DAX (Data Analysis Expressions).
● Basic DAX calculations: SUM, AVERAGE, COUNT.
● Hands-on: Simple measures and calculated columns.
Class 5
Duration: 2 hours
Topic: Introduction to DAX (Part 2)
Details:
● Intermediate DAX: IF, SWITCH, FILTER, CALCULATE.
● Time intelligence functions.
● Hands-on: Creating dynamic measures.
Class 6
Duration: 2 hours
Topic: Data Visualization Basics
Details:
● Exploring visualization types: bar, line, pie charts, and tables.
● Formatting visuals and interactivity.
● Hands-on: Designing a basic dashboard.
Class 7
Duration: 2 hours
Topic: Advanced Visualizations
Details:
● Custom visuals from AppSource.
● Conditional formatting and drill-through.
● Hierarchies and slicers.
● Hands-on: Interactive dashboards.
Class 8
Duration: 2 hours
Topic: Power BI Service
Details:
● Publishing to Power BI Service.
● Sharing dashboards and reports.
● Understanding workspaces and apps.
● Hands-on: Publish and collaborate.
Class 9
Duration: 2 hours
Topic: Data Refresh and Gateways
Details:
● Scheduled refresh and on-demand refresh.
● Configuring gateways for on-premises data.
● Hands-on: Automating data refresh.
Class 10
Duration: 2 hours
Topic: Row-Level Security (RLS)
Details:
● Setting up RLS roles in Power BI Desktop.
● Testing RLS in Power BI Service.
● Hands-on: Implementing RLS for a dataset.
Class 11
Duration: 2 hours
Topic: Project Workshop (Part 1)
Details:
● Real-world project: Define a problem statement.
● Dataset preparation and data modeling.
● Begin creating visualizations.
Class 12
Duration: 2 hours
Topic: Project Workshop (Part 2)
Details:
● Finalizing the dashboard.
● Publishing and sharing the project.
● Feedback and Q&A.
Data Analysis
Class 1
Duration: 2 Hours
Module: Introduction to Data Analysis (2 Hours)
Topic: Fundamentals of Data Analysis
Details:
● What is Data Analysis? Types and Importance.
● Overview of Data Analysis Workflow.
● Introduction to SQL and Python in Data Analysis.
● Course Outline and Learning Objectives.
Class 2
Duration: 2 Hours
Module: SQL for Data Analysis (10 Hours)
Topic: SQL Basics
Details:
● Understanding Databases and Introduction to SQL.
● Setup environment for Database and SQL.
● Basic SQL Syntax: SELECT, FROM.
● WHERE Clause for Filtering Data.
Class 3
Duration: 2 Hours
Module: SQL for Data Analysis (10 Hours)
Topic: SQL Data Aggregation
Details:
● Aggregation Functions: COUNT, SUM, AVG.
● GROUP BY and HAVING Clauses for Data Grouping.
Class 4
Duration: 2 Hours
Module: SQL for Data Analysis (10 Hours)
Topic: SQL Joins
Details:
● Understanding Joins: INNER JOIN.
● Advanced Joins: LEFT JOIN, RIGHT JOIN.
Class 5
Duration: 2 Hours
Module: SQL for Data Analysis (10 Hours)
Topic: Advanced SQL Queries
Details:
● Subqueries: Basic Concepts and Usage.
● Introduction to Common Table Expressions (CTEs).
Class 6
Duration: 2 Hours
Module: SQL for Data Analysis (10 Hours)
Topic: SQL Practice and Assessment
Details:
● Practical Exercises: Real-world SQL Challenges.
● Quiz 1: Assessment of SQL Skills.
Class 7
Duration: 2 Hours
Module: Python for Data Analysis (10 Hours)
Topic: Introduction to Python
Details:
● Setting Up Python Environment.
● Basic Syntax and Operations.
● Control Flow: Conditionals and Loops.
Class 8
Duration: 2 Hours
Module: Python for Data Analysis (10 Hours)
Topic: Python Data Structures
Details:
● Lists, Tuples, and Dictionaries.
● Defining and Using Functions.
Class 9
Duration: 2 Hours
Module: Python for Data Analysis (10 Hours)
Topic: Data Handling with Pandas
Details:
● Introduction to Pandas and DataFrames.
● Data Selection, Filtering, and Sorting.
Class 10
Duration: 2 Hours
Module: Python for Data Analysis (10 Hours)
Topic: Data Cleaning Techniques
Details:
● Handling Missing Data.
● Removing Duplicates and Data Standardization.
Class 11
Duration: 2 Hours
Module: Python for Data Analysis (10 Hours)
Topic: Python Practice and Assessment
Details:
● Real-world Data Manipulation Exercises.
● Quiz 2: Assessment of Python Skills.
Class 12
Duration: 2 Hours
Module: Integrating SQL and Python (4 Hours)
Topic: SQL in Python
Details:
● Using SQLAlchemy for Databases Connection.
● Executing SQL Queries in Python with Pandas.
Class 13
Duration: 2 Hours
Module: Integrating SQL and Python (4 Hours)
Topic: Advanced Integration Techniques
Details:
● Building Complex Data Pipelines.
● Case Studies and Practical Applications.
Class 14
Duration: 2 Hours
Module: Final Projects and Beyond Analytics Concepts (4 Hours)
Topic: Project Development
Details:
● Share real-world problems and set objectives.
● Big Data, ETL, ELT, DataLake, Deltalake, Spark, Kafka, etc.
Class 15
Duration: 2 Hours
Module: Final Projects and Beyond Analytics Concepts (4 Hours)
Topic: Project Completion and Presentation
Details:
● Project Presentations and Peer Feedback.
Class 16
Duration: 2 Hours
Module: Conclusion (2 Hours)
Topic: Wrap-up and Future Directions
Details:
● Brief Review of Key Concepts.
● Career Opportunities and Further Learning.
