Se você gostar deste repositório não esqueça de dar um like (clicando na estrela) ⭐!
Linkedin: https://www.linkedin.com/in/wanderleihuttel/
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/
- 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/
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/
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
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/