Excel and PowerBi for Data Visualization

Focused View

Information SystemSchool

2:46:06

141 View

1. Excel Introduction and Functions

1. Introduction.mp4

04:16

2. Excel Functions.mp4

02:43

3. Excel Functions.mp4

03:08

4. Excel Functions.mp4

05:26

2. PowerBi Introduction and DAX

1. Connecting to Data via PowerBi.mp4

04:53

2. PowerBi Functions.mp4

05:59

3. PowerBi Functions.mp4

03:33

4. PowerBi Functions.mp4

05:27

5. PowerBi Functions.mp4

02:08

6. PowerBi Functions.mp4

03:52

3. Formatting Data

1. Excel Formatting.mp4

02:09

2. Excel Formatting.mp4

02:40

3. Formatting in PowerBi.mp4

03:52

4. Charts

1. Excel Charts.mp4

11:13

2. Excel Charts.mp4

06:25

3. PowerBi Chart.mp4

02:48

5. Excel Lookup Functions

1. Lookup Functions.mp4

09:15

2. Lookup Functions.mp4

02:19

3. Lookup Functions.mp4

06:48

6. PowerBi Filtering

1. Filtering.mp4

02:31

2. Filtering.mp4

02:21

7. Excel Pivot Tables

1. Pivot Tables.mp4

07:30

2. Pivot Tables.mp4

18:18

3. Pivot Charts.mp4

05:25

4. Pivot Charts.mp4

07:01

8. Excel Conditional Functions

1. IF Function.mp4

10:01

2. Nesting Function.mp4

03:36

3. IF and Nesting.mp4

05:50

9. Advanced PowerBi

1. Report View.mp4

03:41

2. Matrxi Visual.mp4

02:43

3. Tree Maps.mp4

01:36

4. Trend Lines.mp4

02:41

5. Roles in PowerBi.mp4

02:01

6. Publishing.mp4

01:57

Description

Data Visualization with Microsoft Excel and PowerBi

What You'll Learn?

Excel and PowerBi for Data Visualization
Data analysis with Excel
Data visualization with PowerBi
Hands on experience with Excel and PowerBi

Who is this for?

Anyone interested in data visualization

More details

Description
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software. Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. We are covering Excel fundamentals, Quick Access Toolbar, Basic excel functions such as SUM, MIN & MAX, Average & AutoSum. Excel sheet modifications using Moving & Copying data, Inserting & deleting rows, Hiding, unhiding and re-naming. Formatting data, Font formatting, Creating styles, Conditional formatting, Creating Charts, Excel column chart, Adding and modifying data, Excel Pie chart. Pivot Table, Creating a Pivot table, Modifying pivot table, Grouping pivot table, Creating pivot charts, Filtering pivot charts, Excel conditional functions, IF function, Nesting function. Lookup functions VLookup, HLookup, INDEX & MATCH. For PowerBi we go through Power BI , Introduction to PowerBI desktop, Connecting to Data, Table relationships, Data model, Filter Flow, Data Analysis Expressions (DAX) â€“ Calculated Columns, Data Analysis Expressions (DAX) â€“ Measures, IF, AND, OR, CALCULATE , CALCULATE ALL, SUMX, Report View in PowerBI, Inserting Charts, Formatting, Filtering options, Matrix Visuals, Treemaps, Trend lines and forecast, Managing roles in Power BI
Publishing to PowerBI service.
Who this course is for:
Anyone interested in data visualization

User Reviews

Rating

average 0

Total votes0

Focused display

We provide training on various personal development forums covering mainly day to day aspects of life for the past 12 years. We mainly focus on personality development and behavioral training. Our training delivery includes customized one on one sessions, online and classroom sessions. We have trained hundreds of students, professionals and parents through our customized curriculum meeting their specific requirements over the past decade and more. We are expertise in using multiple platforms such as Power point presentations, videos, text for our learning program as well.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.