oterocarlos Profile Banner
Carlos Otero Profile
Carlos Otero

@oterocarlos

Followers
928
Following
791
Media
77
Statuses
837

#Excel Team @Microsoft. Creating experiences that help people make sense of data. Previous stints in corporate strategy and finance

Seattle
Joined September 2009
Don't wanna be here? Send us removal request.
@oterocarlos
Carlos Otero
2 years
RT @gvanrossum: Yeah, so I helped the Excel team with this. Excited that it's out!
Tweet card summary image
techcommunity.microsoft.com
Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.
0
3K
0
@oterocarlos
Carlos Otero
2 years
RT @john_lam: Python in Excel is now a thing! Python is now a peer of the Excel formula language and you can mix both languages seamlessly….
0
397
0
@grok
Grok
5 days
Join millions who have switched to Grok.
242
262
2K
@oterocarlos
Carlos Otero
2 years
It's been awesome partnering with @anacondainc on this project. I am excited to provide access to Anaconda Distribution for Python directly within #Excel.
1
0
6
@oterocarlos
Carlos Otero
2 years
RT @tomwarren: Microsoft is bringing Python to Excel. The two worlds of Excel and Python are colliding thanks to Microsoft’s new integratio….
Tweet card summary image
theverge.com
Python code will run on Microsoft’s Cloud.
0
283
0
@oterocarlos
Carlos Otero
2 years
We built a thing! #Python in #Excel - now in preview, brings the best of Python analytics straight to the Excel grid. I cannot wait to see what our community builds leveraging pandas, matplotlib, scikit-learn, and more!.See:
Tweet media one
5
37
135
@oterocarlos
Carlos Otero
3 years
My team is #hiring! Help shape the future of #Excel and impact 100s of millions of people around the world. We are looking for a creative product leader with an entrepreneurial spirit to help us build and grow data analysis user experiences at scale. You…
0
0
2
@oterocarlos
Carlos Otero
4 years
Love this!.
@reckless
nilay patel
4 years
Today on Decoder: Kat Norton, the Microsoft Excel influencer making up to six figures *a day* selling Excel tips and tricks. This one. goes places. I loved it.
Tweet media one
0
0
2
@oterocarlos
Carlos Otero
4 years
More #Excel + #PowerBI news! We are broadening availability of recent integration features to support customers with Premium Capacity + PBI Free. This means more people will now be able to analyze PBI data in Excel, w/o having to leave Excel! See details:.
Tweet card summary image
techcommunity.microsoft.com
Connected PivotTables and Organization data types coming soon for users with Power BI free licenses
2
23
66
@oterocarlos
Carlos Otero
4 years
Note that these updates will sit at this stage for a bit while we react to any feedback and complete the equivalent work in Excel for the web (being tested internally right now). This is a particularly complex area in the code base, so testing and feedback are appreciated!.
0
0
4
@oterocarlos
Carlos Otero
4 years
Of course, having explicitly defined DAX measures in the underlying dataset is still a best practice for more complex calculations. The challenge here is that most folks interacting with the PivotTables might not have access or know how to create the measures in the first place.
1
0
3
@oterocarlos
Carlos Otero
4 years
This means that PivotTables connected to #PowerBI datasets will now support drag-and-drop aggregation of fields (e.g. sum, average, distinct count, etc.). This helps you to quickly get answers within Excel without needing pre-defined measures in the underlying Power BI datasets.
1
0
7
@oterocarlos
Carlos Otero
4 years
Quick update on the #Excel + #PowerBI integration front. The Windows specific updates mentioned in this post (e.g. drag and drop aggregations) are now available to the Current Channel Preview (aka Insiders Slow). Please test these out and send us feedback!.
techcommunity.microsoft.com
Power BI connected PivotTables in Excel for the web now available  
2
7
14
@oterocarlos
Carlos Otero
4 years
Love this! Excited to see what else you cook up at the intersection of Cube Functions, #Excel Lambdas, and Dynamic Arrays!.
@cwebb_bi
Christopher Webb
4 years
#Excel cube functions, dynamic arrays and lambdas, Part 1: getting all the items from a set #PowerBI #PowerPivot #SSAS
0
0
2
@oterocarlos
Carlos Otero
4 years
RT @jjmcdaid: We just announced a new wave of lambda functions. If you like dynamic arrays, you are going to love BYROW and BYCOL -- they a….
Tweet card summary image
techcommunity.microsoft.com
Excel has new LAMBDA functions
0
13
0
@oterocarlos
Carlos Otero
4 years
Modern #Excel templates powered by Data Types for the win! You can find more of those here:
0
5
11
@oterocarlos
Carlos Otero
4 years
Awesome overview @wynhopkins! Excited to see what folks build with these new capabilities. I hear you on the access friction - still some more to go to polish the experience.
1
2
13
@oterocarlos
Carlos Otero
4 years
Quick update on the #PowerBI + #Excel front! The ability to interact and refresh PBI PivotTables in Excel for the web should now be available to 100% of eligible users. Thank you for the patience and feedback as we addressed issues with the initial release.
@oterocarlos
Carlos Otero
4 years
I am happy to share we have started the rollout of #PowerBI connected PivotTables in #Excel for the web. This means that interacting with and refreshing PivotTables connected to Power BI Datasets in a browser will now be supported. #MSBizAppsSummit
2
11
28
@oterocarlos
Carlos Otero
4 years
I need to work some more with my #PowerBI friends on messaging and wordsmithing. This should technically say something more along the lines of "PivotTable refresh in #Excel for the web." Any PivotTable purist would know that it is just one word. :).
@cristian_angyal
Cristian Angyal
4 years
#Excel Online Refresh of Pivot Tables is coming in #PowerBI: just announced at #MSBizAppsSummit
Tweet media one
1
0
4