Comparte si te a gustado:

Power Query M Language with Specialize in Web Scraping

Publicado en 12 Feb 2021

Udemy UK


Lo que aprenderás


  • Introduction to Power query M language

  • Rename & sorting using M code

  • Secrets of List functions in Power query M language

  • M query for group by aggregation

  • Top N records for each category dynamically

  • How to do error handling

  • Web scraping using lists

  • Dynamic table creation using M language

  • Nested Let & Variables scope

  • M language Record functions

  • Power query M language Index function secrets

  • Input & dynamic parameters

  • Web scraping projects using M functions

  • Requisitos


  • There is no such prerequisites but knowledge of Power query would be helpful

  • Descripción


    What is M formula language


    One of the most critical and challenging tasks in any data analytics project is data transformation & data cleaning. We need to prepare the data to make it suitable for analysis to retrieve useful insights.


    In the world of power bi, we have a Power query like an ETL for the data warehouse. Whenever we perform any operation on the data, the power query generates M code, a formula language. M formula language contains a rich set of different functions for data transformation & cleaning.


    Why learn M formula language


    In power bi, we have a graphical user interface that we use to perform different operations on the data. Still, unfortunately, this interface is minimal. We cannot perform all the data related operations on it by using a graphical user interface.


    Almost every month, Microsoft releases new versions of Power BI, which have new graphical tools in the power bi ribbon. However, we still have to depend on the unique features of the power query graphical user interface.


    We can overcome this dependency by learning the Power Query M language. M language is much more powerful than the Power query because the entire underlying auto-generated code will be in our hands.


    In this course, You will learn all the building blocks of Power query M language to master it on your own.


    This course will give you a clear path about the M language on how to implement any available function for data transformation.


    New upcoming features & functions will be added in this course from time to time.


    About me


    My name is Muhammad Asif, and I will be your instructor in this course. I have more than ten years of experience in data & analytics with one of the world's leading organizations. I am a Microsoft certified solution expert in data analytics & management.


    I have developed several data models, dashboards & reports for a different line of services. You can learn from my experience, and I will share each and everything. I aim to spread the knowledge by simplifying hard concepts.


    I wish you all the best for your journey in Power BI & M formula language.


    ¿Para quién es este curso?


  • Excel users

  • Data Analysts

  • Business Intelligence constultants

  • Data Engineers

  • Data Scientists

  • Debes tener en cuenta que los cupones duran maximo 4 dias o hasta agotar 1000 inscripciones,pero puede vencer en cualquier momento. Obten el curso con cupon haciendo clic en el siguiente boton:

    (Cupón válido para las primeras 1000 inscripciones): DISCUDMY
    Udemy UK
    Tags:
    • #Power Query

    Articulos Relacionados

    content

    Power BI: Empieza desde cero

    Vuélvete un experto del Business Intelligence y extrae valor de los datos.

    Ir al Curso
    content

    Microsoft SQL Server: Análisis de datos con Tableau

    Mejora tus habilidades analíticas comerciales con SQL y visualización de datos

    Ir al Curso
    content

    Power BI: 8 Proyectos reales para volverte un master

    Vuélvete un experto del Business Intelligence y extrae valor de los datos.

    Ir al Curso
    Suscríbete a nuestro boletín
    Reciba los últimos Cupones y promociones (Solicitar Cupón)