Data Analytics
Student Material
INDEX - Course Lecture ut-Line
Chapter: 1 Introduction to Data Analytics. Page No. 3- 17
Course Introduction
Data Analytics Overview
Dealing with Different Types of Data
Data Visualization for Decision making
Data Science, Data Analytics, and MachineLearning
Data Science Methodology
Data Analytics in Different Sectors
Analytics Frameworkand Latest trends
Chapter: 2 Data Ingestion Page No. 18- 56
Power Bl Data Ingestion and Modelling
Reading from MySQL
Reading from HDF5
Reading from The Web
Reading from APIs
ETC
Reading from Other Sources
Summary and close
Chapter: 3 Data Cleansing Page No. 57- 100
we look at finding data and reading differentfile types.
Getting and Cleaning Data! The primary goal is to introduce you to the
most common data storage systems and the appropriate tools to
extract data from web or from databases like MySQL.
Introduction to Data Wrangling and Shaping
Advanced Shaping
Beyond Initial Shaping
Advanced DAX
Publishing and Testing Your Dataset
Summarizing Data
Creating New Variables
1|Page
Brought to you by:
CENTUM
RuFOUNDATION
1/412
Data Analytics
Student Material
Chapter: 4 Data Modelling Page No. 101- 141
What is Data Modelling?
Data Modelling sometimesneeds Data Analysis
Star Schema
Snowflake Schema
Create a Relationship
One to many, many to many relationships
Chapter: 5 Data Visualization Page No. 142 - 204
Overview of Power BI
Advantages of using Power BI
Chart Selection
Getting Started
Transforming Data
Report Creation
Differenttypes of visualization charts
Area Charts
Line Charts
Bar Charts
Column Charts
Combo Charts
Chapter: 6 Data Regression Page No. 205 - 244
Types of Regression Models
Simple Linear Regression Model
Simple Linear Regression Equation
Equation for the best straight line
Graph of the best straight line
Interpreting the Results
Measures of Variation
Course Assignment Page No. 245 264
-
Assignment on Power Bl report creation with Solution
2| Page
Brought to you by:
CENTUV
LRaFOUNDATION
2/412
Data Analytics
Student Material
CHAPTER 7:INTRODUCTION Page No: 265-274
CHAPTER 8:DATABASE Page No: 275-305
CHAPTER 9 : DATA ENGINEERING SERVICES Page No: 306-329
CHAPTER 10 :S3 or STORAGE SERVICES Page No: 330-343
CHAPTER 11 : DMS (Ingestion) Page No: 344-363
CHAPTER 12 : REDSHIFT or CLOUD BASE DATA VWAREHOUSE Page No: 364-390
CHAPTER 13 :GLUE or DATA PIPELINING Page No: 391-396
CHAPTER 14 : EMR PROCESSING Page No: 397-404
CHAPTER 15:SCHEDULING & MONITORING Page No: 405-412
Table of Content of Al with Power Bl
Subject Module Topics Subtopics Hours
Detect language
Extract key phrases
Enable Text Score sentiment
Analytics and Vision Tag images 3
on Premium Invoke Text Analytics or Vision functionsin
Use Text capacities Power Query
Analytics and Publish a report with Text Analytics or Vision
Vision functions
Use Al Insights
Select a capacity
in Power Bl
Monitor with the Capacity Metrics app
Desktop Manage impact on a
Compare Power Query and Power Query
Premium capacity
Online
Considerationsand limitations of Text Analytics
Enable Al features
Detect Language
Cognitive Services in
Al in Power BI Extract Key Phrases 3
Power BI
Score Sentiment
Tagimages
TOTAL DURATION
1/1
