​

AI in Excel?

​

​

Do you know that your friendly spreadsheet software has many powerful and helpful AI features to make you more AWESOME?

​

Here are my top 5 AI features in Excel.

1. Flashfill for pattern recognition and data cleansing based on AI rules (Excel 2013 or above)
2. Create derived data with Column from Examples in Power Query (Excel 2016+)
3. Automated AI Analysis of your Data with "Analyze Data" feature (Excel 365)
4. Recommendations to help you decide right Pivots & Charts (Excel 2019+)
5. Forecasting based on patterns in your data (Excel 2016+)

​

​

​

AI in Power BI?

​

Power BI too has a handful for powerful and helpful AI features. Here are my top picks:

​

1. Q&A feature to ask questions about your data
2. AI analysis of your data (when published to the platform)
3. AI visuals to automatically analyze and present data - Decomposition tree, Key influencers
4. AI narrative based on your data and visuals - Smart narratives
5. Power Query AI features - Columns from example, Text processing (PRO needed)
6. Generate DAX based on your needs - new feature

​

If you want to know more about the #6 - generate DAX with AI, check out this video.

​

​

What is your favorite AI feature?

​

Reply back and let me know what is your fav. AI feature in Excel or Power BI.