Latest Posts - Workaround Guru

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8750249084606465&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-8750249084606465 -->

</head><body>*/</style>

Tecnologia

Dica: Expressões lambda no PowerQuery

Na nossa dica rápida de hoje, vamos falar um pouco mais sobre funções lambda e como elas podem ser úteis no PowerQuery . Funções lambda são ...

Workawriter 5 mai., 2023

Power BI

Combinando arquivos

No workaround de hoje, você aprenderá um método diferente para combinar arquivos utilizando o Power Query . Contexto: Imagine que você tem u...

Workawriter 3 mai., 2023

Power BI

"Exportando" visuais do Power BI

No nosso workaround de hoje, você aprenderá como exportar visuais de um dashboard apenas manipulando o arquivo " .pbix ". Context...

Workawriter 1 mai., 2023

Tecnologia

Dica: Gere seus próprios dados fictícios com a biblioteca Python Faker

Na dica rápida de hoje, falaremos sobre a biblioteca Faker , disponível no Python . E no que essa biblioteca pode ser útil? Gerar dados fict...

Workawriter 28 abr., 2023

SQL

Eliminar caracteres não numéricos de strings

No nosso primeiro workaround sobre SQL, apresentarei uma técnica para retirar todos os caracteres não numéricos de uma string . Contexto Ima...

Workawriter 26 abr., 2023

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/851759228-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AAPvtVn2L3qmD5CfK3QzMjL88D4m:1789944087705';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d8714950731461918873','//www.workaroundguru.com/search?updated-max\x3d2023-05-07T02:27:00-07:00\x26max-results\x3d5','8714950731461918873');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '8714950731461918873', 'title': 'Workaround Guru', 'url': 'https://www.workaroundguru.com/search?updated-max\x3d2023-05-07T02:27:00-07:00\x26max-results\x3d5', 'canonicalUrl': 'https://www.workaroundguru.com/search?updated-max\x3d2023-05-07T02:27:00-07:00\x26max-results\x3d5', 'homepageUrl': 'https://www.workaroundguru.com/', 'searchUrl': 'https://www.workaroundguru.com/search', 'canonicalHomepageUrl': 'https://www.workaroundguru.com/', 'blogspotFaviconUrl': 'https://www.workaroundguru.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-BSYPXJB1ZX', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'pt-BR', 'localeUnderscoreDelimited': 'pt_br', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Workaround Guru - Atom\x22 href\x3d\x22https://www.workaroundguru.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Workaround Guru - RSS\x22 href\x3d\x22https://www.workaroundguru.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Workaround Guru - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/8714950731461918873/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-8750249084606465', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'isGoogleEverywhereLinkTooltipEnabled': true, 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/7ce469edaf870342', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Gerar link', 'key': 'link', 'shareMessage': 'Gerar link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Compartilhar no Facebook', 'target': 'facebook'}, {'name': 'Postar no blog!', 'key': 'blogThis', 'shareMessage': 'Postar no blog!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Compartilhar no X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Compartilhar no Pinterest', 'target': 'pinterest'}, {'name': 'E-mail', 'key': 'email', 'shareMessage': 'E-mail', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27pt_BR\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Leia mais', 'pageType': 'index', 'pageName': '', 'pageTitle': 'Workaround Guru'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Editar', 'linkCopiedToClipboard': 'Link copiado para a \xe1rea de transfer\xeancia.', 'ok': 'Ok', 'postLink': 'Link da postagem'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Personalizar', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Workaround Guru', 'description': 'Sua dose homeop\xe1tica de data analytics', 'url': 'https://www.workaroundguru.com/search?updated-max\x3d2023-05-07T02:27:00-07:00\x26max-results\x3d5', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': false, 'search': {}}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'Workaround Guru (Cabe\xe7alho)', 'type': 'Header', 'sectionId': 'upload-image', 'id': 'Header1'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': '#Caixa de c\xf3digo', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML3'}, {'title': '#Analytics', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML2'}, {'title': '#Cookies', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML1'}, {'title': 'Em destaque', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost1', 'postId': '2016856870926771369'}, {'title': 'Postagens no blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '6050942223208571682', 'title': 'Dica: Express\xf5es lambda no PowerQuery', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOmlzTkiZGirebezZK-N3pr4U7o630Et6HDTIu1t5myWxxK1prwiwJTC8TmuxbOK37VKj3_6bmkayFVT5HmlCFVkBurUy9TujTXD8RqBGOaz9cvPmTbARI4Jn4S4vvReHAJKU6TuW0cdrhPcbMvUD-Z4VRqc8uJaml-oLJ9wZCLYg0ylDUnjq9t1L6g/s320/dica%20rapida.png', 'showInlineAds': false}, {'id': '6046449599254425051', 'title': 'Combinando arquivos', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMmQBuH0iLdpSzij_rBY49Q8ZTADGNSB5wmWb3xj9FCLKiK9MqvdSbOf_Fh7OSfm9ywbh6CzudvxM5albI_X0e5yLRlJjV3c2azQZsDmAynlFnJbfD275URv2NbI-tLn8cccDwhQqeXvd7jmew3jby3PrB_Ty0zEeQPjdGYZfdSBdlnOUJptxpxwGPnQ/s320/Arquivos.png', 'showInlineAds': false}, {'id': '8206304204812923647', 'title': '\x22Exportando\x22 visuais do Power BI', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyhEKyYHpUO-mAgkj-ylsG-d_FvIHkfKPM_42Xqxohyb3ktsKtH_zuClJ4rDgaBwvu4Hz2jVQ_zQXzfT0Sx2457qabfDXdnEGgMOiRhorXv8BQpFH2Q-SQZtt--ZGp6_VmAvTOxNMTmw9cFJ8i6PdwATUe4IlFjvr7jUHnZCi_S1NhIOd2lGhXbi0MJA/s320/visuais.png', 'showInlineAds': false}, {'id': '7860349193001168673', 'title': 'Dica: Gere seus pr\xf3prios dados fict\xedcios com a biblioteca Python Faker', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwm36eB0R-dKoITNPu86D7BKoBw80g-5DustLQtJs4slRblZL1OKjdbkEOBnQ4Vk1JWAzKGvA55MKxKX-84KBTzcW5TSa9F56HcuJP_XyJvf2tUoigjS4v8qa08kCVGDaYS2eI_RucMHyShSHW5cdrJwZrpB60wUhKOUlDNZuZKwFwnhc1UGaLImFvKA/s320/faker.png', 'showInlineAds': false}, {'id': '9118377648196311647', 'title': 'Eliminar caracteres n\xe3o num\xe9ricos de strings', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeW62XXtD1kjIG7HB0CsGEfte9bctqvI1JB14KTxGJFa6mn7oVtNf34f4xE4Qq3ljXGGkd-6YMiLoNGkpKwAkwpXRwDPfLq114-_UmJtF_AdaCqPH4Z9EZe9VdKsTKFUVirHu8XlZouMcz9ZHCV9TMbuvOGT6EcWwks9icojc_yVT5B6DrKzsvFZ52og/s320/caractere_nao_numerico.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': 'Tags'}]}, {'title': 'Populares', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Suporte a Python no Excel', 'id': 2016856870926771369}, {'title': 'Dica: Express\xf5es lambda no PowerQuery', 'id': 6050942223208571682}, {'title': 'Ada Lovelace', 'id': 3518788171148747916}, {'title': 'Dica: Imagens em Base64 no Power BI', 'id': 4045901579405581755}, {'title': 'Skills b\xe1sicas de um Engenheiro de Dados', 'id': 1891349538989887731}]}, {'title': 'Categorias', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label11'}, {'title': 'Arquivo do blog', 'type': 'BlogArchive', 'sectionId': 'sidebar-static', 'id': 'BlogArchive10'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML19'}, {'title': 'Workaround Guru', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Saiba mais', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Redes', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'upload-image', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'before-blog', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'before-blog', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'before-blog', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'before-blog', document.getElementById('FeaturedPost1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3903585616-lbx__pt_br.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label11', 'sidebar-static', document.getElementById('Label11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive10', 'sidebar-static', document.getElementById('BlogArchive10'), {'languageDirection': 'ltr', 'loadingMessage': 'Carregando\x26hellip;'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML19', 'sidebar-static', document.getElementById('HTML19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>