Scribd
Upload
2 views2 pages

Business & Data Analytics Using PBI

The document outlines a comprehensive training program on Power BI, covering topics such as data modeling, DAX expressions, and various visualization techniques over a series of sessions. It also includes a list of practical projects for application, ranging from finance analysis to tourism data analysis. Each session is structured to last 2 hours, focusing on essential skills for effective data analysis and reporting.

Uploaded by

sahashuvranil742
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views2 pages

Business & Data Analytics Using PBI

The document outlines a comprehensive training program on Power BI, covering topics such as data modeling, DAX expressions, and various visualization techniques over a series of sessions. It also includes a list of practical projects for application, ranging from finance analysis to tourism data analysis. Each session is structured to last 2 hours, focusing on essential skills for effective data analysis and reporting.

Uploaded by

sahashuvranil742
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Day Content Topics Duration

Introduction to Power BI – Need, Importance


Power BI – Advantages and Scalable Options
1 History – Power View, Power Query, Power Pivot 2 Hrs
Power BI Data Source Library and DW Files
Cloud Collaboration and Usage Scope
Business Analyst Tools, MS Cloud Tools
Power BI Installation and Cloud Account

Connect, Load, and Transform data


2 Concept and terminologies on Star-Schema 2 Hrs
Working with Shapes and Text Box
Introduction to Data Modelling
What is a data model? Basics of tables and relationships.
3 Primary and foreign keys: Establishing relationships. 2 Hrs
Creating relationships between tables.
Understanding star and snowflake schema.
Importing multiple datasets and building relationships.

4 Introduction to DAX
Describe DAX Expression 2 Hrs
Purpose of DAX

5 Create and execute Powerful DAX Calculation


DAX Entities: Calculated Columns and Measures 2 Hrs
Dax formulas
6 Power BI Design: Canvas, Visualizations, and Fields
Data Fields and Filters with Visualizations 2 Hrs
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing.
7 Testing Sets
CHART Report Types and Properties 2 Hrs
STACKED BAR CHART, STACKED COLUMN CHART
CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
8 100% STACKED BAR CHART, 100% STACKED COLUMN CHART
LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS 2 Hrs
LINE AND STACKED ROW CHARTS
LINE AND STACKED COLUMN CHARTS
9 WATERFALL CHART, SCATTER CHART, PIE CHART
Field Properties: Axis, Legend, Value, Tooltip 2 Hrs
Field Properties: Colour Saturation, Filters Types
Formats: Legend, Axis, Data Labels, Plot Area
Data Labels: Visibility, Colour, and Display Units
10 Describe Advanced BI Techniques 2 Hrs
Enlist the Power BI services offered to users
11 Report Creation 2 Hrs
12 Dashboard Creation 2 Hrs
Project List:

1. Airline Passenger Traffic Analysis


2. COMPANY FINANCE ANALYSIS
3. CONSUMER BEHAVIOUR ANALYSIS
4. E-COMMERCE SALES ANALYSIS
5. EMPLOYEE PERFORMANCE ANALYSIS
6. FINANCE STATEMENT ANALYSIS
7. HEALTHCARE PERFORMANCE ANALYSIS
8. Household Budget Management
9. INVENTORY MANAGEMENT ANALYSIS
10. Inventory Tracking & Management
11. MARKETING CAMPAIGN PERFORMANCE
12. ONLINE SHOPPING DATA ANALYSIS
13. PERSONAL BUDGET TRACKER
14. PROFITABILITY ANALYSIS
15. RETAIL SALES DATA ANALYSIS
16. SALES PERFORMANCE ANALYSIS
17. SPORTS PERFORMANCE ANALYSIS
18. STOCK MANAGEMENT ANALYSIS
19. STOCK MARKET ANALYSIS
20. SUPPLY CHAIN EFFICIENCY
21. TOURISM DATA ANALYSIS
22. TRAFFIC ACCIDENT ANALYSIS
23. TRAVEL DATA ANALYSIS
24. Warehouse Optimization

You might also like