Data Visualization with Microsoft Excel and PowerBi
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
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.
Course Content
- Excel Introduction and Functions –> 4 lectures • 16min.
- PowerBi Introduction and DAX –> 6 lectures • 26min.
- Formatting Data –> 3 lectures • 9min.
- Charts –> 3 lectures • 20min.
- Excel Lookup Functions –> 3 lectures • 18min.
- PowerBi Filtering –> 2 lectures • 5min.
- Excel Pivot Tables –> 4 lectures • 38min.
- Excel Conditional Functions –> 3 lectures • 19min.
- Advanced PowerBi –> 6 lectures • 15min.
Requirements
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.