Data Analysis Mastery: Combo Excel & Power BI 101 Mastery

Categories: Excel, Power BI

About Course

Why choose one when you can master both? This combo brings together our signature Excel 101 and Power BI 101 series into one powerful learning path. By mastering the world’s most used spreadsheet tool alongside the industry-leading visualization software, you bridge the gap between simple data entry and high-level business intelligence.

Course Content

The Excel 101 Mastery Series
 Ribbon, QAT & Interface  Worksheet Management  Shortcuts  Data Entry Shortcuts  Autofill & Flash Fill  Formulas & Functions  Data Cleaning  Range, Table & Freeze Pane  Paste Options  Sort & Filter  Charts  Conditional Formatting  Data Validation  Absolute Reference  Relative Reference  Vlookup  Xlookup  IF Function  [IF(S)/SUMIF(S)/COUNTIF(S)/IF(AND)/IF(OR)]  Index Match  Pivot Table  Dashboard  Lock Cells  Protect Sheet  Macros  Power Query

The Power BI 101 Mastery Series
1. INTRODUCTION  Overview of the Course  What is Power BI  How to Install Power BI Desktop  Explore Power BI Desktop & Save File 2. GET & TRANSFORM DATA  Import File from Folder & Transform Data in Power Query  Changing Query Source  Additional Lookup Table by Referencing Queries  Merge Queries  Prevent Queries from Loading In 3. DATA MODELLING  Create Relationships Between Table  Creating Data Table  Create Additional Date Columns  Sorting Month & Weekday Arrangement  Validate Table  Hiding Fields from Report View 4. DAX MEASURES  Calculate Total Revenue  Calculate Total Rows of a Table  Calculate Function  Calculate Total Revenue Last Year  Year-on-Year Comparison 5. REPORT VISUALISATIONS  Summary Cards  Column Charts  Map Visual  Slicer  KPI Card  Line Graphs  Matrix  Top N 6. REPORT DESIGN  Adding Textbox & Shapes  Power BI Themes  Conditional Formatting 7. EDITING INTERACTIONS AND FILTERS  Interactions between Visuals  Filter Pane  Drill Through 8. POWER BI SERVICE  Publish Report to Power BI Service  Ways to Share Power BI Report