Links Úteis PowerBI

DAX

• Formatar medidas DAX - https://www.daxformatter.com/
• Guia DAX de medidas - https://dax.guide/
• Funções DAX Exemplo 1 Dashboard Powerbi 1
• Funções DAX Exemplo 2 Dashboard Powerbi 2
• Funções FILTER, ALL, RELATED, TOTALYTD e CALCULATE - https://uaismart.com/5-funcoes-dax-para-usar-no-power-bi/
• Contexto de Linha e Filtro - https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
• Tratamento de Erros - https://powerpivotpro.com/2019/09/a-brief-treatment-of-divide-rankx-and-n-a/
• ALLEXCEPT x ALL e VALUES - http://www.infointelligence.com.br/2017/11/13/usando-allexcept-versus-all-e-values/
• Quando usar SUMX ou CALCULATE - https://www.aprendapowerbi.com.br/post/medidas-dax-quando-usar-a-sumx-e-quando-usar-a-calculate
• Evite usar FILTER como argumento de filtro - https://docs.microsoft.com/pt-br/power-bi/guidance/dax-avoid-avoid-filter-as-filter-argument
• Calcular Acumulado 1 - https://www.youtube.com/watch?v=ENOL_LggsbQ
• Calcular Acumulado 2 - https://www.youtube.com/watch?v=XmyY-tIiUbU
• Calcular Acumulado com EARLIER - https://www.youtube.com/watch?v=lLOjRo1_v7o
• KPI em Tabelas - https://www.kasperonbi.com/showing-kpis-in-a-table-or-matrix-with-power-bi/
• Utilizando Hierarquias (Função PATH) - https://www.youtube.com/watch?v=QFKTr8tAQXE
• Somar Hierarquias - https://www.youtube.com/watch?v=IeAxmrwDHzw
• Colorir tabela por marca - https://www.sqlbi.com/articles/applying-color-banding-by-document-number-in-power-bi/
• Medida para converter bytes para KB, MB, GB - https://community.powerbi.com/t5/Desktop/Function-to-convert-bytes-into-KB-MB-GB-TB-PB-etc/td-p/468023
• Mostrar meses anteriores - https://www.linkedin.com/pulse/saiba-como-mostrar-mesmo-eixo-os-n-meses-anteriores-ao-pedro-eloy/
• Analisar dados no Excel - https://eriksvensen.wordpress.com/2020/07/27/powerbi-external-tool-to-connect-excel-to-the-current-pbix-file/
• Preencher para baixo DAX - https://www.youtube.com/watch?v=Vm_dSLCvBnA
• Tratar filtros em branco - https://www.youtube.com/watch?v=YoPiQh6Vkr4
• RankX sem repetições - http://www.rafaelmendonca.com/2018/10/power-bi-criando-ranking-sem-repeticoes.html
• Destacar Maior e Menor valor em DAX - https://www.youtube.com/watch?v=5yAylZKL0lE
• DAX Fusion (melhorar performance) - https://dax.tips/2019/08/05/dax-fusion/
• Aplicando o Formato de Horas - https://www.youtube.com/watch?v=7iINnoIkeIk
• Slicers para selecionar medidas - https://www.youtube.com/watch?v=gEeiqsm7BaY

Power Query M

• Formatar código M - http://powerqueryformatter.com/
• Combinar funções M - https://powerpivotpro.com/2018/06/powerquery-magic-combine-m-functions-and-formulas-in-custom-columns/
• Tabelas em M - https://ssbi-blog.de/blog/technical-topics-english/tables-in-power-query-how-when-and-why/
• Fibonacci - https://radacad.com/fibonacci-sequence-understanding-the-power-query-recursive-function
• Salva imagem base64 - https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/
• Renomear todas colunas para maiúsculo - https://www.youtube.com/watch?v=jlogBrcYZwc
• Remover linhas duplicadas ignore case - https://seddryck.wordpress.com/2018/03/31/table-distinct-and-case-pitfalls-with-power-query-m-language/
• Verificar se coluna é número - https://www.fourmoo.com/2019/10/09/power-query-add-column-to-see-if-it-is-a-number-data-type/
• Dimensão de tempo - https://www.fourmoo.com/2019/08/28/creating-a-time-dimension-using-the-power-query-editor-in-power-bi-desktop/
• Arquivos CSV - https://blog.crossjoin.co.uk/2018/03/09/an-in-depth-look-at-the-csv-document-m-function/
• Trim cabeçalhos - https://www.youtube.com/watch?v=QQtS1hECgwI
• Renomear cabeçalhos - https://bengribaudo.com/blog/2018/05/18/4447/automating-column-name-renames
• Verificar substring é número - https://stackoverflow.com/questions/37960196/is-there-an-isnumber-or-istext-equivalent-for-power-query
• Acumular valores em uma Lista (List Accumulate)- https://www.youtube.com/watch?v=0l_mxQVTVsU
• API Paginação - https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
• Trabalhar com horas1 - https://insightsquest.com/2019/08/25/time-dimension-via-power-query/
• Trabalhar com horas2 - https://www.youtube.com/watch?v=8DFih8ccMV0
• Efetuando Loops - https://www.youtube.com/watch?v=T1q3BF5_YJ8
• Linhas p/ Colunas1 - https://www.youtube.com/watch?v=5OF12HMxVuk
• Linhas p/ Colunas2 - https://www.youtube.com/watch?v=oNGHsmHA7s0
• List.Accumulate para substituir caracteres - https://chandoo.org/wp/multiple-find-replace-list-accumulate/
• Loop em Power Query - https://exceed.hr/blog/list-generate-and-looping-in-powerquery/
• Arquivo texto sem delimitador - https://powerpivotpro.com/2016/03/power-query-fixed-width-magic/
• Adicionar Zeros à Esquerda - http://datacornering.com/how-to-add-leading-zeros-in-r-power-query-dax-or-excel/
• dCalendario Fiscal - https://www.youtube.com/watch?v=2XUZOtEFbSc
• Transformações dinâmicas e em massa usando Listas - https://www.thebiccountant.com/2017/01/09/dynamic-bulk-type-transformation-in-power-query-power-bi-and-m/
• Conexão API Omie - https://www.youtube.com/watch?v=g6l0Rg0ez68
• Conexão API Omie Paginado - https://www.youtube.com/watch?v=HgxYfJlwjQ4
• Listas - https://gorilla.bi/power-query/complete-guide-to-lists/
• Juntar texto de várias linhas - https://www.youtube.com/watch?v=dB8W4GCf9AY
• Substituir Valores - https://gorilla.bi/power-query/replace-values/

Modelagem

• Esquema estrela - https://docs.microsoft.com/pt-br/power-bi/guidance/star-schema
• Base de dados de exemplos - https://docs.microsoft.com/pt-br/power-bi/create-reports/sample-datasets
• Dados abertos - https://medium.com/rladiesbh/19-lugares-para-encontrar-conjuntos-de-dados-gratuitos-para-projetos-de-ci%C3%AAncia-de-dados-4390943d860d

Temas, Fundos e Personalização

• Gerar Temas Json - https://themes.powerbi.tips/
• Galeria de temas - https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery
• Temas - https://alluringbi.com/gallery/
• Modelos de Dashboards - http://www.powerbiarte.com.br/
• Emojis - https://getemoji.com/
• Emojis - In Windows 10 [Windows Key + .] ou (Windows Key + ç)
• Layouts - https://powerbi.tips/tools/layouts/

Imagens

• https://wallpaperaccess.com/business-intelligence
• https://www.pexels.com/pt-br/
• https://pixabay.com/pt/
• https://morguefile.com/
• https://br.freepik.com/
• https://graphicburger.com/
• https://flagicons.lipis.dev/

Criar Paleta de Cores

• https://color.adobe.com/pt/create/image
• https://palettegenerator.com/
• https://coolors.co/
• https://colourco.de/
• https://flatuicolors.com/
• https://www.colors.lol/
• https://mycolor.space/

Baixar Ícones

• https://icons8.com.br/
• https://www.flaticon.com/br/
• https://icon-icons.com/pt/
• https://logomakr.com/
• https://graphicburger.com/
• https://www.freeicons.io/
• https://www.iconfinder.com/
• https://icon-icons.com/
• https://www.iconspedia.com/
• https://www.iconshock.com/
• https://findicons.com/
• https://thenounproject.com/
• https://remixicon.com/
• https://www.drawkit.io/free-icons
• https://undraw.co/illustrations
• https://blush.design/pt/collections
• https://github.com/microsoft/PowerBI-Icons
• https://iconmonstr.com/
• https://icomoon.io/app/#/select
• https://fontawesome.com/
• https://dryicons.com/free-icons

Outros

• Extensão Chrome rotacionar abas - https://www.bidoconceitoapratica.com.br/2019/01/09/rotacao-de-abas/
• Melhorar exibição em TV - https://www.youtube.com/watch?v=stHD0FVsdJk
• Configurar Syntax Highlight Notepad++ (PowerQuery) - http://sascha-kasper.com/m-aka-power-query-and-notepad/
• Configurar Syntax Highlight Notepad++ (DAX) - http://sascha-kasper.com/dax-syntax-highlighting-for-notepad/