Mike YU (BI&Analytics)

@UCj-aR1f7kzIXYIioh756p0Q - 946 subscribers

Welcome to my Channel ! By the channel I am sharing my practices experiences of using Microsoft Cloud Power Platform (Power BI, Power Automate and Power Apps) and Office Applications (excel, one drive, sharepoint and forms etc.), powered with data analytics programming languages (R Scripts and Python Script) and Latest LLM tools (chatGPT, Gemini, Copilot) for Business Intelligences, Analytics, Automations, Finance Quantitive Analytics Applications.... The contents shared in my channel are for informational and educational purposes only. Latst Highlighted Hints: 1). Power BI Memory and Performance Considerations (plase refer to my blog URL): mikeyubianalytics.blogspot.com/2023/01/power-bi-me…

Home Videos Live Playlists

Excel Tips & Tricks: Create a Customized Loan Amortization Function with LET, LAMBDA, and SCAN

Excel Tips & Tricks: Create a Customized Loan Amortization Function with LET, LAMBDA, and SCAN Mike YU (BI&Analytics)

127 views - 1 year ago

Excel Tips & Tricks: Dynamic Ranges with Comparing INDIRECT, INDEX, and OFFSET for Data Retrieval

Excel Tips & Tricks: Dynamic Ranges with Comparing INDIRECT, INDEX, and OFFSET for Data Retrieval Mike YU (BI&Analytics)

186 views - 1 year ago

Excel Tips and Tricks: Create a Dynamic Date Dimension Table with LET, VSTACK & HSTACK

Excel Tips and Tricks: Create a Dynamic Date Dimension Table with LET, VSTACK & HSTACK Mike YU (BI&Analytics)

135 views - 1 year ago

Generate Amortization Schedule Plan with ChatGPT-4: A Free and Easy Alternative to Excel

Generate Amortization Schedule Plan with ChatGPT-4: A Free and Easy Alternative to Excel Mike YU (BI&Analytics)

139 views - 1 year ago

Power Platform Automations: Auto Upload & Refresh Cloud PBI Reports Triggered by Email Attached ZIP

Power Platform Automations: Auto Upload & Refresh Cloud PBI Reports Triggered by Email Attached ZIP Mike YU (BI&Analytics)

214 views - 1 year ago

Power BI DAX tips: Dynamic Top Ranking with Reset Button Based on User Selections

Power BI DAX tips: Dynamic Top Ranking with Reset Button Based on User Selections Mike YU (BI&Analytics)

497 views - 1 year ago

Power BI DAX tips: Dynamic Security Solution RLS,OLS,RLS&CLS for Complex Organizational Hierarchies

Power BI DAX tips: Dynamic Security Solution RLS,OLS,RLS&CLS for Complex Organizational Hierarchies Mike YU (BI&Analytics)

933 views - 1 year ago

Power Platform Integrations: Embed Power Apps into Power BI with Power Automate & Excel & OneDrive

Power Platform Integrations: Embed Power Apps into Power BI with Power Automate & Excel & OneDrive Mike YU (BI&Analytics)

934 views - 1 year ago

Power BI Tips & Tricks: A workaround to Re - Arrange the Fields Order at Data Pane

Power BI Tips & Tricks: A workaround to Re - Arrange the Fields Order at Data Pane Mike YU (BI&Analytics)

259 views - 1 year ago

Power BI DAX Tips: Calculate OBV Indicator with DAX based on a mathematical formula transformation

Power BI DAX Tips: Calculate OBV Indicator with DAX based on a mathematical formula transformation Mike YU (BI&Analytics)

151 views - 1 year ago

Power BI DAX Tips: Generate Larger Sample Data Table with Unique Item Name list

Power BI DAX Tips: Generate Larger Sample Data Table with Unique Item Name list Mike YU (BI&Analytics)

225 views - 1 year ago

Power BI DAX tips: Customize Tooltip for a Candlestick Chart, #powerbideveloper

Power BI DAX tips: Customize Tooltip for a Candlestick Chart, #powerbideveloper Mike YU (BI&Analytics)

246 views - 1 year ago

Power BI DAX Tips: DAX Measures for CandleStick Chart via Line & Stacked Column Visual #powerbi

Power BI DAX Tips: DAX Measures for CandleStick Chart via Line & Stacked Column Visual #powerbi Mike YU (BI&Analytics)

575 views - 1 year ago

Power BI DAX Tips: Create Stock Price RSI Chart with Power BI Line & Stacked Column Visual

Power BI DAX Tips: Create Stock Price RSI Chart with Power BI Line & Stacked Column Visual Mike YU (BI&Analytics)

357 views - 1 year ago

Power BI with R: How to Get Power BI ready for R script

Power BI with R: How to Get Power BI ready for R script Mike YU (BI&Analytics)

445 views - 1 year ago

Power BI Transform Data with R: Calculated Columns for 4 types of Relative Strength Index (RSI)

Power BI Transform Data with R: Calculated Columns for 4 types of Relative Strength Index (RSI) Mike YU (BI&Analytics)

213 views - 1 year ago

Power BI DAX & DAX Studio:Calculate Initial Values of SMA with DAX for Bollinger Bands,#dataanalysis

Power BI DAX & DAX Studio:Calculate Initial Values of SMA with DAX for Bollinger Bands,#dataanalysis Mike YU (BI&Analytics)

196 views - 2 years ago

Power BI DAX: DAX MINX & TOPN find Dynamic Rolling 20 Data Points for Bollinger Band Calculations

Power BI DAX: DAX MINX & TOPN find Dynamic Rolling 20 Data Points for Bollinger Band Calculations Mike YU (BI&Analytics)

372 views - 2 years ago

Power BI Security: Dynamic Combined RLS & CLS for Solid & Dot Line Organizational Hierarchies

Power BI Security: Dynamic Combined RLS & CLS for Solid & Dot Line Organizational Hierarchies Mike YU (BI&Analytics)

323 views - 2 years ago

Power BI Power Query & R: Calculate MACD Indicators with Assumed Initial Values,#powerbideveloper

Power BI Power Query & R: Calculate MACD Indicators with Assumed Initial Values,#powerbideveloper Mike YU (BI&Analytics)

302 views - 2 years ago

Power BI & R & AI ChatBot: MACD Chart for Stock Price Analysis & Ask Gemini about,#powerbideveloper

Power BI & R & AI ChatBot: MACD Chart for Stock Price Analysis & Ask Gemini about,#powerbideveloper Mike YU (BI&Analytics)

376 views - 2 years ago

Power BI & R: Get Daily Stock Prices Automatically with Windows Task Scheduler,#powerbideveloper

Power BI & R: Get Daily Stock Prices Automatically with Windows Task Scheduler,#powerbideveloper Mike YU (BI&Analytics)

310 views - 2 years ago

Power BI with R: R Script Connector Unzips & Combines the Zipped csv/xlsx/xlsb/xls files

Power BI with R: R Script Connector Unzips & Combines the Zipped csv/xlsx/xlsb/xls files Mike YU (BI&Analytics)

220 views - 2 years ago

Power BI DAX: Generate Random Sample Data with DAX Functions (GENERATESERIES/CONVERT/UNCHAR/SWITCH)

Power BI DAX: Generate Random Sample Data with DAX Functions (GENERATESERIES/CONVERT/UNCHAR/SWITCH) Mike YU (BI&Analytics)

993 views - 2 years ago

Power BI Advanced Visual & R: Simulate 3D Quadratic Surface in R Script Visual,#powerbideveloper

Power BI Advanced Visual & R: Simulate 3D Quadratic Surface in R Script Visual,#powerbideveloper Mike YU (BI&Analytics)

359 views - 2 years ago

Power BI Advanced Visualizations: 3D Scatterplot with Interactive Rotation View by R Script Visual

Power BI Advanced Visualizations: 3D Scatterplot with Interactive Rotation View by R Script Visual Mike YU (BI&Analytics)

611 views - 2 years ago

Power BI Advanced Visualizations: Circular BarPlot with R Script Visual

Power BI Advanced Visualizations: Circular BarPlot with R Script Visual Mike YU (BI&Analytics)

688 views - 2 years ago

Excel Dynamic Arrays Tips: Cumulative Sums by SUBTOTAL with OFFSET & SEQUENCE

Excel Dynamic Arrays Tips: Cumulative Sums by SUBTOTAL with OFFSET & SEQUENCE Mike YU (BI&Analytics)

693 views - 2 years ago

Excel Dynamic Arrays: Spill Dynamic Arrays for Calendar Years and Months (Date List)

Excel Dynamic Arrays: Spill Dynamic Arrays for Calendar Years and Months (Date List) Mike YU (BI&Analytics)

466 views - 2 years ago

Excel VBA: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report.

Excel VBA: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report. Mike YU (BI&Analytics)

673 views - 2 years ago

Excel VBA: A Macro to Generate Yearly Loan Schedule Report with Aggregated Monthly Re-Payments

Excel VBA: A Macro to Generate Yearly Loan Schedule Report with Aggregated Monthly Re-Payments Mike YU (BI&Analytics)

835 views - 2 years ago

Excel Tips & Tricks: A Loan Calculator with PMT, IPMT, PPMT & VBA Macro for Loan Report

Excel Tips & Tricks: A Loan Calculator with PMT, IPMT, PPMT & VBA Macro for Loan Report Mike YU (BI&Analytics)

599 views - 2 years ago

Power Apps Tips: How to set the Default Values for the DatePicker Control and TimePicker Control

Power Apps Tips: How to set the Default Values for the DatePicker Control and TimePicker Control Mike YU (BI&Analytics)

17.5K views - 2 years ago

Power BI AI Visualizations: Predict Future Values for Time Series Data with Line Chart forecasting

Power BI AI Visualizations: Predict Future Values for Time Series Data with Line Chart forecasting Mike YU (BI&Analytics)

3.3K views - 2 years ago

Power BI AI Visualizations: Decomposition Tree AI Splits with Absolute Mode and Relative Mode

Power BI AI Visualizations: Decomposition Tree AI Splits with Absolute Mode and Relative Mode Mike YU (BI&Analytics)

928 views - 2 years ago

Power BI Visualizations: Build Reset Button with Power BI Bookmarks in a Multi-Slicers Report Page

Power BI Visualizations: Build Reset Button with Power BI Bookmarks in a Multi-Slicers Report Page Mike YU (BI&Analytics)

883 views - 3 years ago

Power BI DAX: Rank Top N Accounts with calculated measure for visual filter based on user selections

Power BI DAX: Rank Top N Accounts with calculated measure for visual filter based on user selections Mike YU (BI&Analytics)

3.1K views - 3 years ago

Power BI DAX: Dynamic Ranking Calculations Based on User Selections and Filters

Power BI DAX: Dynamic Ranking Calculations Based on User Selections and Filters Mike YU (BI&Analytics)

7.4K views - 3 years ago

Power BI Modelling Tips: Organize Your Measures with Power BI Measure Group

Power BI Modelling Tips: Organize Your Measures with Power BI Measure Group Mike YU (BI&Analytics)

191 views - 3 years ago

Power BI DAX: Add Status Labels and Colours to Visual’s Value and Title with calculated Measures

Power BI DAX: Add Status Labels and Colours to Visual’s Value and Title with calculated Measures Mike YU (BI&Analytics)

398 views - 3 years ago

Power BI DAX: Add String Status Labels to Records with Calculated Column

Power BI DAX: Add String Status Labels to Records with Calculated Column Mike YU (BI&Analytics)

370 views - 3 years ago

Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions

Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions Mike YU (BI&Analytics)

525 views - 3 years ago

Power BI DAX: Retrieve Extremums (Max/Min) Across Multiple Columns

Power BI DAX: Retrieve Extremums (Max/Min) Across Multiple Columns Mike YU (BI&Analytics)

649 views - 3 years ago

Power BI DAX: A Joint Measure to concatenate different measures with ampersand (&) Operator

Power BI DAX: A Joint Measure to concatenate different measures with ampersand (&) Operator Mike YU (BI&Analytics)

2.4K views - 3 years ago

Power BI DAX & Visualizations: Dynamic Ranges of Tachometer Gauge with What if Parameter

Power BI DAX & Visualizations: Dynamic Ranges of Tachometer Gauge with What if Parameter Mike YU (BI&Analytics)

1.7K views - 3 years ago

Power BI DAX: Benchmark Measures and Calculated Field Values for Visual Conditional Format

Power BI DAX: Benchmark Measures and Calculated Field Values for Visual Conditional Format Mike YU (BI&Analytics)

1.1K views - 3 years ago

Power BI Power Query Tips: Range Lookup with Power Query M Table Function TABLE.SELECTROWS

Power BI Power Query Tips: Range Lookup with Power Query M Table Function TABLE.SELECTROWS Mike YU (BI&Analytics)

3.4K views - 3 years ago

Power BI Power Query: Range to List for Dimension Table with Functions SPLITTER and LIST.NUMBERS

Power BI Power Query: Range to List for Dimension Table with Functions SPLITTER and LIST.NUMBERS Mike YU (BI&Analytics)

1K views - 3 years ago

Power BI Power Query Tips: Age Calculations with Power Query DATE and DATETIME Functions

Power BI Power Query Tips: Age Calculations with Power Query DATE and DATETIME Functions Mike YU (BI&Analytics)

530 views - 3 years ago

Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT

Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT Mike YU (BI&Analytics)

4.8K views - 3 years ago

Power BI Visual Tips: Sort Table Visual by Multiple Columns

Power BI Visual Tips: Sort Table Visual by Multiple Columns Mike YU (BI&Analytics)

4.2K views - 3 years ago

Power BI Modelling (Preview Features): Edit Relationship in properties pane

Power BI Modelling (Preview Features): Edit Relationship in properties pane Mike YU (BI&Analytics)

1.3K views - 3 years ago

Power BI & PowerPoint Integrations: Embed Live Power BI report page in PowerPoint

Power BI & PowerPoint Integrations: Embed Live Power BI report page in PowerPoint Mike YU (BI&Analytics)

391 views - 3 years ago

Power BI DAX: Data Values Ranking within Subgroup with RANKX

Power BI DAX: Data Values Ranking within Subgroup with RANKX Mike YU (BI&Analytics)

2.7K views - 3 years ago

Power BI DAX: Dynamic Title with SELECTEDVALUE and ISFILTERED

Power BI DAX: Dynamic Title with SELECTEDVALUE and ISFILTERED Mike YU (BI&Analytics)

2.1K views - 3 years ago

Power BI DAX: Funnel Drop off Rate and Abandonment Rate for Sales Analysis

Power BI DAX: Funnel Drop off Rate and Abandonment Rate for Sales Analysis Mike YU (BI&Analytics)

1.2K views - 3 years ago

Power BI DAX: Percentage Calculations with DAX Functions and Operator

Power BI DAX: Percentage Calculations with DAX Functions and Operator Mike YU (BI&Analytics)

1.5K views - 3 years ago

Power BI DAX: UNPIVOT Columns with DAX Expression

Power BI DAX: UNPIVOT Columns with DAX Expression Mike YU (BI&Analytics)

8.2K views - 3 years ago

Power BI DAX: Running Monthly Cost Per Day vs Running Monthly Budget Per Day

Power BI DAX: Running Monthly Cost Per Day vs Running Monthly Budget Per Day Mike YU (BI&Analytics)

1.6K views - 3 years ago

Power BI Visualization: Syncilizinng Slicers with Visual-Level Filter

Power BI Visualization: Syncilizinng Slicers with Visual-Level Filter Mike YU (BI&Analytics)

809 views - 4 years ago