Excel and PowerBi for Data Visualization

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, and Basic excel functions such as SUM, MIN & MAX, and 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 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. 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.