Power Bi

Repositório com conteúdos de Power Bi:

• Blogs
• Certificação
• Artigos
• Power Query
• DAX
• Contato

Blogs

• Chris Webb - https://blog.crossjoin.co.uk/

• Aprenda Power Bi - https://aprendapowerbi.com.br/blog/

• BI conceito a pratica - http://www.bidoconceitoapratica.com.br/

• Power Bi Artes - http://www.powerbiarte.com.br/

• Radacad blog - https://radacad.com/blog

• Power Bi Tips and Tricks - https://powerbi.tips/

  Top

Certificação

• Site oficial - https://docs.microsoft.com/pt-br/learn/certifications/exams/70-778

• Conteúdo detalhado - https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE4tnJB

• Simulado Udemy - https://www.udemy.com/course/exam-70-778-microsoft-power-bi-practice-test-2019/learn/quiz/4615383/test?expanded=344147738#overview

• Simulado ExamTopics - https://www.examtopics.com/exams/microsoft/70-778/

• Dicas Leo Karpinski - https://aprendapowerbi.com.br/dicas-de-como-obter-a-certificacao-mcsa-bi-reporting-power-bi-excel/

• Dicas Dirceu Resende - https://www.dirceuresende.com/blog/certificacoes-microsoft-material-de-estudo-para-as-provas-de-mcsa-do-sql-server-2016/#5

• Dicas Dustin Ryan - https://sqldusty.com/2017/08/23/preparing-for-microsoft-certification-exam-70-778-analyzing-and-visualizing-data-with-microsoft-power-bi/

• Dicas Forum Comunidade - https://community.powerbi.com/t5/Desktop/Power-BI-Exam-70-778/td-p/392118

• Curso edX - https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+3T2019/course/#block-v1:Microsoft+DAT207x+3T2019+type@chapter+block@b593b1ac-07ec-8245-1328-bdc47535a3f6

• Power Bi Experts - https://powerbiexpert.wordpress.com/power-bi-da-100-certification/

  Top

Artigos

• Tipos de Join - Merge - https://app.powerbi.com/view?r=eyJrIjoiYmNhNzgzYjAtNjc2OS00YjQwLTgwNzItM2Q1MzcyMmJlYjMyIiwidCI6IjZjMGE1YjljLTA4OWEtNDk0ZS1iMDVlLTcxNjEwOTgyOTA0NyIsImMiOjF9

• Choose the right join type - https://radacad.com/choose-the-right-merge-join-type-in-power-bi

• DAX formulas Corbal - https://community.powerbi.com/t5/Data-Stories-Gallery/All-DAX-functions-and-corresponding-DAX-Fridays-tutorials/td-p/774426

• Integrando e explorando a linguagem Python no Power BI - https://medium.com/@fernando.gama/integrando-e-explorando-a-linguagem-python-no-power-bi-6bd8ba0e60ed

• Unicode - https://www.vertex42.com/ExcelTips/unicode-symbols.html

• Tipos de licença - https://dynamics.folio3.com/blog/difference-between-power-bi-pro-vs-free-vs-premium/

• Não uso Direct Query - https://aprendapowerbi.com.br/nao-use-directquery-otimize-o-modelo-use-agregacoes-e-modelos-compostos/

• "Em branco" no filtro - https://www.youtube.com/watch?v=YoPiQh6Vkr4

• Mapa Cloropletico - https://www.youtube.com/watch?v=JCKsjKcmKMg

• Atualização incremental - http://www.rafaelmendonca.com/2020/06/incremental-powerbi-csv-api-excel-odbc.html

• Níveis de privacidade Microsoft - https://docs.microsoft.com/pt-br/power-bi/admin/desktop-privacy-levels

• Data Privacy part 1 Chris Webb - https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performance-implications/

• Data Privacy part 2 Chris Webb - https://blog.crossjoin.co.uk/2017/05/31/data-privacy-settings-in-power-bipower-query-part-2-preventing-query-execution/

• Data Privacy part 3 Chris Webb - https://blog.crossjoin.co.uk/2017/06/26/data-privacy-settings-in-power-bipower-query-part-3-the-formula-firewall-error/

• Data Privacy part 4 Chris Webb - https://blog.crossjoin.co.uk/2017/07/04/data-privacy-settings-in-power-bipower-query-part-4-disabling-data-privacy-checks/

• Data Privacy part 5 Chris Webb - https://blog.crossjoin.co.uk/2017/07/10/data-privacy-settings-in-power-bipower-query-part-5-the-inheritance-of-data-privacy-settings-and-the-none-data-privacy-level/

• Bases de dados - https://medium.com/rladiesbh/19-lugares-para-encontrar-conjuntos-de-dados-gratuitos-para-projetos-de-ci%C3%AAncia-de-dados-4390943d860d

• RLS - https://medium.com/@rehaddad/power-bi-seguran%C3%A7a-em-n%C3%ADvel-de-linha-row-level-security-252f25c988b8

  Top

Power Query

• 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/

• Uso de parâmetro 1 - https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

• Uso de parâmetro 2 - https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters/

• Uso de parâmetro 3 - https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters/

• Uso de parâmetro 4 - https://www.biinsight.com/power-bi-desktop-query-parameters-part-3-list-output/

• Mesclar performatico - https://ibb.co/86rK1BR

  Top

DAX

• Funções: CALCULATETABLE, INTERSECT, EXCEPT, TREATAS, IN - https://powerbiexperience.com/pt/dax-como-usar-as-funcoes-calculatetable-intersect-except-treatas-in/

• Formatar medidas DAX - https://www.daxformatter.com/

• Guia DAX de medidas - https://dax.guide/

• Funções DAX Exemplo 1 - https://app.powerbi.com/view?r=eyJrIjoiOWUxYzM4YzEtZDE2YS00MWFjLWE4ZWMtNjJmYTZmZjc4MjY0IiwidCI6IjdkMjIwM2Y0LTRiMzQtNDc2OS05OWNlLWZkYzMyOWMyMGZiZSJ9

• Funções DAX Exemplo 2 - https://app.powerbi.com/view?r=eyJrIjoiMTU2NDczNDctODg3MC00YmMwLTkxOTUtZmUwOTc2ODU3MDhmIiwidCI6IjVjNWFmNjNlLTAzMWQtNGI2Mi05ZTFlLTVhZjZlYWQxNWU5ZSIsImMiOjR9

• Funções FILTER, ALL, RELATED, TOTALYTD e CALCULATE - https://uaismart.com/5-funcoes-dax-para-usar-no-power-bi/

• 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/

• Grafico de Pareto - https://www.youtube.com/watch?v=53HK7_r4JXY&feature=youtu.be

• Funções essenciais em DAX - https://www.youtube.com/watch?v=KGEkooDRSNQ&feature=youtu.be

• Acumulado sem dimensão temporal - https://www.youtube.com/watch?v=XmyY-tIiUbU

• Regressão linear - https://xxlbi.com/blog/simple-linear-regression-in-dax/

  Top

Contato

• LinkedIn: LinkedIn
• Portfolio: DataPowerBR