top of page
Search

Powe bi and Tableau

  • Writer: Amudha priya
    Amudha priya
  • Nov 19, 2024
  • 2 min read

Updated: Dec 11, 2024

Power Bi

  • Get to know the different tools of the power bi universe and learn how to use them

  • Understand the power Bi Desktop and its components

  • Learn how to use query editor to connect Power bi to various source types ,how to work on the Data model and understand the difference between those two steps

  • How to work in the different views of the data model

  • how to create calculated columns,measures and DAX functions

  • how to build relationships between differnet tables

  • how to create a report with different interactive visualization types

  • Learn how to use Power bi Services(=Power BI Pro) to create dashboards and to share and publish your results.

  • how to access your results from multiple devices using power bi mobile

  • how to create custom visuals using type script and the power bi developer tools .




👉 Build an Interactive Dashboard with Excel!



👉 VLOOKUP vs HLOOKUP vs XLOOKUP! https://lnkd.in/greQCjfY


👉 INDEX & MATCH! 



👉 2-WAY LOOKUPS (XLOOKUP vs INDEX & MATCH)!



👉 EXTRACT TEXT FROM CELLS with LEFT, MID & RIGHT EXCEL Formulas!



👉 How to use the TRIM formula in EXCEL for DATA CLEANING!



👉 How to use TEXT TO COLUMNS in EXCEL for DATA CLEANING!



👉 CHANGE TEXT CASE in EXCEL using UPPER, LOWER & PROPER formulas!



👉 How to use FIND function with IFERROR, REPLACE, LEFT, RIGHT, MID, LEN, ISNUMBER! https://lnkd.in/g_-w8JWY


👉 COUNTIF 



👉 COUNTIFS 



👉 EXCEL with ChatGPT



👉 FORMULATEXT 



👉 GOAL SEEK 



👉 IFERROR




👉 PivotTable



👉 ROUND 



👉 SLICERS basics



👉 SUMIF 



👉 SUMIFS 



👉 Create a 9-BOX GRID for TALENT MAPPING with PIVOT TABLE!



👉 Create a 9-BOX GRID for TALENT MAPPING with EXCEL'S SCATTER CHART!



👉 Generate VLOOKUP formulas with ChatGPT! 



👉 Excel SHORTCUT Keys 🗝️ 



🔥 Descriptive & Predictive Analytics with Excel & Word❗ 


 👉 How to create a WORD CLOUD with Word!



👉 How to run SENTIMENT ANALYSIS with EXCEL! https://lnkd.in/gYkqNPYX


👉 DESCRIPTIVE STATISTICS with EXCEL!



👉 How to find the CORRELATION MATRIX for Share Prices with EXCEL! https://lnkd.in/d7vF6eVC


👉 How to Forecast Seasonality in EXCEL


 

👉 Multiple Regression in Excel - Predict Results with Numerical & Non-Numerical Data with 2 Values



👉 Multiple Regression in Excel - Predict Results with Numerical & Non-Numerical (Categorical) Data with 3 Values!



📣 For more Excel & Predictive Analytics Tips, SUBSCRIBE to "The HR Diary" YouTube channel 


 
 
 

Recent Posts

See All

Comments


bottom of page