Excel and PowerBi for Data Visualization
Data Visualization with Microsoft Excel and PowerBi
What you’ll learn
Excel and PowerBi for Data Visualization
- Excel and PowerBi for Data Visualization
- Data analysis with Excel
- Data visualization with PowerBi
- Hands-on experience with Excel and PowerBi
Requirements
- No prior experience is required, we start from the basics
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 developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform.
We cover
- Excel fundamentals
- Quick Access Toolbar
- Basic excel functions such as
- SUM,
- MIN
- MAX
- Average
- AutoSum.
Excel sheet modifications
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 charts, Adding and modifying data, Excel Pie charts. 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.
Power BI
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
I am publishing to PowerBI service.
Who this course is for:
- Anyone interested in data visualization
