|
Data analytics Syllabus Day wise
|
|
|
Power Bi Notes
|
|
|
|
BI Functions
|
|
|
|
Conditional Column & Index Column
|
|
|
|
CREATING A BASIC CALENDAR TABLE
|
|
|
|
DATA MODEL
|
|
|
|
DAX (Data Analysis Expressions)
|
|
|
|
DEFINING DATA CATEGORIES
|
|
|
|
GROUPING & AGGREGATING DATA
|
|
|
|
Measures
|
|
|
|
Merge and append
|
|
|
|
PIVOTING & UNPIVOTING
|
|
|
|
Power BI VS Power Excel
|
|
|
|
Query Editor and tools
|
|
|
|
Types Of Dataconnect
|
|
|
|
Why Power BI
|
|
|
|
Microsoft Power BI Interview Questions and Answers
|
|
|
|
Top Power BI Interview Questions and Answers
|
|
|
Power Bi Projects
|
|
|
|
Project 1: Employee Data
4:00
|
|
|
|
Employee Data
|
|
|
|
Project 2: Bank Analysis
4:00
|
|
|
|
P6-UK-Bank-Customers
|
|
|
|
Project 3: Email Markrting Analysis
5:00
|
|
|
|
Email Marketing Analysis
|
|
|
|
Project 4: Global Terrorism Analysis
6:00
|
|
|
|
globalterrorism
|
|
|
|
Porject 5:IPL Project
7:00
|
|
|
|
IPL
|
|
|
|
Project 6: Mavans Market Project
8:00
|
|
|
|
Maven Market
|
|
|
|
Project 7: Sales And Inventory Analysis
5:00
|
|
|
|
Fruit Sales Data - Inventory and Sales
|
|
|
|
Project 8: Unemployment Analysis
3:00
|
|
|
|
P6-Long-Term-Unemployment-Statistics
|
|
|
|
IBM Project
5:00
|
|
|
Day 01
|
|
|
|
Power BI Introduction
21:00
|
|
|
Day 02
|
|
|
|
Power bi installation and Data connection
17:00
|
|
|
|
3.5 kickstarter_projects
|
|
|
|
Kickstarter upload (1)
|
|
|
Day 03
|
|
|
|
Power Query Editing
23:00
|
|
|
|
Power Query Advanced Editing
14:00
|
|
|
Day 04
|
|
|
|
Creating Diagrams & Power Bi Tools intro
14:00
|
|
|
|
Creating Diagrams in Power bi
17:00
|
|
|
Day 05
|
|
|
|
Charts Customization
11:00
|
|
|
Day 06
|
|
|
|
Power Query Merging
11:00
|
|
|
|
Power Query Appending
5:00
|
|
|
|
supermarket_sales (Appending)
|
|
|
|
Merging Tables
|
|
|
Day 07
|
|
|
|
Filters in Power bi
15:00
|
|
|
Day 08
|
|
|
|
Used Cars Stock report
22:00
|
|
|
|
car_data
|
|
|
Day 09
|
|
|
|
Reliace Stock report
15:00
|
|
|
|
Reliance Industries 2012 to 2020
|
|
|
Day 10
|
|
|
|
Covid Dashboard Part 1
13:00
|
|
|
|
Covid 19 dashboard part 2
13:00
|
|
|
|
Covid 19 dashboard part 3
8:00
|
|
|
|
worldometer_coronavirus_summary_data
|
|
|
|
worldometer_coronavirus_daily_data
|
|
|
Day 11
|
|
|
|
Covid 19 Dashboard Part 4
10:00
|
|
|
|
Covid 19 Dashboard part 5
9:00
|
|
|
Day 12
|
|
|
|
WWI Dashboard Part 1
21:00
|
|
|
|
WWI Dashboard Part 2
12:00
|
|
|
|
DimCustomer
|
|
|
|
DimEmployee
|
|
|
|
DimStockItem
|
|
|
|
factsale1 (1)
|
|
|
|
date
|
|
|
|
DimCity
|
|
|
Day 13
|
|
|
|
WWI DAshboard Part 3
9:00
|
|
|
Day 14
|
|
|
|
Adv Dashboard Part 1
22:00
|
|
|
|
Adventures dashboard part 2
11:00
|
|
|
|
AdventureWorks_Calendar
|
|
|
|
AdventureWorks_Customers
|
|
|
|
AdventureWorks_Product_Categories
|
|
|
|
AdventureWorks_Product_Subcategories
|
|
|
|
AdventureWorks_Products
|
|
|
|
AdventureWorks_Returns
|
|
|
|
AdventureWorks_Sales_2015
|
|
|
|
AdventureWorks_Sales_2016
|
|
|
|
AdventureWorks_Sales_2017
|
|
|
|
AdventureWorks_Territories
|
|
|
|
AdventureWorks_Calendar
|
|
|
Day 15
|
|
|
|
Adv Dashboard part 3
11:00
|
|
|
|
Adv Dashboard Part 4
13:00
|
|
|
Day 16
|
|
|
|
Adv Dashboard Part 5
14:00
|
|
|
|
Adv Dashboard Part 6
9:00
|
|
|
Day 17
|
|
|
|
Adv Dashboard Part 7
12:00
|
|
|
|
Adv Dashboard Part 8
12:00
|
|
|
Day 18
|
|
|
|
Adv Dashboard Part 9
8:00
|
|
|
|
Adv Dashboard Part 10
11:00
|
|
|
Day 19
|
|
|
|
Ai Visuals
12:00
|
|
|
|
3.5 kickstarter_projects
|
|
|
Day 20
|
|
|
|
Bookmarks and Tips
13:00
|
|
|
|
Sample - Superstore
|
|
|
|
superstore_sales
|
|