YIU Virtual Learning Environment

Welcome Message from Mentor 👨🏼‍🏫

Data Analyst VS Business Analyst : What's the difference?

What is Power BI?

Course Outlines Video

0.1 - Face to face introduction session with Mentor (by zoom or google meet)

0.2 - Install Microsoft Access Database Engine and Power BI

1.1 - Introduction to Power BI Desktop Data Transformations

1.2 Lab Overview

1.3 Exercise one - Import Data from Access Database

1.4 Exercise Two - Import Data from CSV Files

1.5 Exercise Three - Import Data from an Excel File

Unit 1 - Assignment Session

2.1- LAB OVERVIEW

2.2 Exercise 1- Manage Table Relationships

2.3 Exercise 2 - Last Year Comparison

2.4 Exercise 3 - Year to Date

2.5 Exercise 4 - Market Share

2.6 Exercise 5 - Optimize the Data Model

Unit 2 - Assignment Session

3.1 Lab Overview

3.2 Exercise 1 - Cross-Tabular Report

3.3 Exercise 2 - Part to Whole Report

3.4 Exercise 3 - Relationship Report

3.5 Exercise 4 - Trend Report

3.6 Exercise 5 - Rank Report

Unit 3 - Assignment Session

4.1 Lab Overview

4.2 SIGNING UP FOR POWER BI SERVICE

4.3 Exercise 1( Upload PBI Report and Pin Visualizations )

4.4 Exercise 2- Share Dashboard and Update Report

4.5 Exercise 3 - Schedule Data Refresh

5.1 Lab Overview and What you'll need

5.2 Exercise 1-Import Excel File with an Excel Table

5.3 Exercise 2 - Upload an Excel File with a Data Model

6.1 Lab Overview

6.2 Exercise 1 - Direct Connectivity From Power BI Desktop

6.3 Exercise 2- Direct Connectivity From Power BI Service ( lecture Video )

6.4 Direct Connectivity to SSAS

6.5 Using SSAS Connector

7.1 Lab Overview

7.2 Exercise 1 - Use Custom Visuals

Completion Test ( Total Score - 43 , For Certificate , your scores have to be greater than or equal 35)