{"id":2199565,"date":"2026-04-20T04:30:04","date_gmt":"2026-04-20T02:30:04","guid":{"rendered":"https:\/\/academy.asseco.pl\/training\/default-layout-itil-4-foundation\/"},"modified":"2026-04-20T04:30:04","modified_gmt":"2026-04-20T02:30:04","slug":"prepare-and-visualize-data-with-microsoft-power-bi","status":"publish","type":"training","link":"https:\/\/academy.asseco.pl\/en\/training\/prepare-and-visualize-data-with-microsoft-power-bi\/","title":{"rendered":"Prepare and visualize data with Microsoft Power BI"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
Asseco Academy<\/a><\/span><\/span><\/div>\n <\/div>\n<\/div> <\/div>\n
\n

Training DP-605T00<\/p>\n

Prepare and visualize data with Microsoft Power BI<\/h2>
\n \n<\/div> <\/div>\n
\n
\n Rozwi\u0105zania IT<\/a>\n Microsoft<\/a>\n Dane, Analityka, AI i ML<\/a>\n In\u017cynieria danych<\/a>\n <\/div>\n <\/div>\n <\/div>\n
\n

Accreditation<\/p>\n

<\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n
\n
\n
\n
\n

Training<\/p>\n\n

Price of training from <\/strong> PLN\u00a01,080  net<\/sup><\/strong><\/p>\n\n

Lowest price in the last 30 days: PLN\u00a01,080  net<\/sup><\/strong><\/p>\n \n

Language: <\/strong>polski<\/p>\n

*the price depends, among others on the form of training and the date<\/p>\n

\n
Sign up<\/div>\n
Download PDF<\/div>\n <\/div>\n <\/div>\n
\n\n

Additional products<\/p>\n

No additional books or exams are specified for this training.<\/p>\n \n \n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n\n

\n
\n
\n
\n
    \n
  • Training description<\/li>\n
  • Scope<\/li>\n <\/ul>\n <\/div>\n
    \n
    \n
    \n
    \n

    Training description<\/h2> <\/div>\n

    <\/p>\n

    \n

    Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.<\/p>\n<\/div>\n

    Prerequisites<\/strong><\/p>\n

    Completion of the Get started with Microsoft data analytics is recommended.<\/p>\n<\/div>\n\n <\/div>\n

    \n
    \n

    Scope<\/h2> <\/div>\n

    <\/p>\n

    \n

    Get data in Power BI<\/p>\n

      \n
    • Get data from files<\/li>\n
    • Get data from relational data sources<\/li>\n
    • Create dynamic reports with parameters<\/li>\n
    • Get data from a NoSQL database<\/li>\n
    • Get data from online services<\/li>\n
    • Select a storage mode<\/li>\n
    • Get data from Azure Analysis Services<\/li>\n
    • Fix performance issues<\/li>\n
    • Resolve data import errors<\/li>\n
    • Exercise – Prepare data in Power BI Desktop<\/li>\n<\/ul>\n

      Clean, transform, and load data in Power BI<\/p>\n

        \n
      • Shape the initial data<\/li>\n
      • Simplify the data structure<\/li>\n
      • Evaluate and change column data types<\/li>\n
      • Combine multiple tables into a single table<\/li>\n
      • Profile data in Power BI<\/li>\n
      • Use Advanced Editor to modify M code<\/li>\n
      • Exercise – Load data in Power BI Desktop<\/li>\n<\/ul>\n

        Design a semantic model in Power BI<\/p>\n

          \n
        • Work with tables<\/li>\n
        • Create a date table<\/li>\n
        • Work with dimensions<\/li>\n
        • Define data granularity<\/li>\n
        • Work with relationships and cardinality<\/li>\n
        • Resolve modeling challenges<\/li>\n
        • Exercise – Model data in Power BI Desktop<\/li>\n<\/ul>\n

          Add measures to Power BI Desktop models<\/p>\n

            \n
          • Create simple measures<\/li>\n
          • Create compound measures<\/li>\n
          • Create quick measures<\/li>\n
          • Compare calculated columns with measures<\/li>\n
          • Exercise – Create DAX Calculations in Power BI Desktop<\/li>\n<\/ul>\n

            Add calculated tables and columns to Power BI Desktop models<\/p>\n

              \n
            • Create calculated columns<\/li>\n
            • Learn about row context<\/li>\n
            • Choose a technique to add a column<\/li>\n<\/ul>\n

              Design Power BI reports<\/p>\n

                \n
              • Design the analytical report layout<\/li>\n
              • Design visually appealing reports<\/li>\n
              • Report objects<\/li>\n
              • Select report visuals<\/li>\n
              • Select report visuals to suit the report layout<\/li>\n
              • Format and configure visualizations<\/li>\n
              • Work with key performance indicators<\/li>\n
              • Exercise – Design a report in Power BI desktop<\/li>\n<\/ul>\n

                Configure Power BI report filters<\/p>\n

                  \n
                • Introduction to designing reports for filtering<\/li>\n
                • Apply filters to the report structure<\/li>\n
                • Apply filters with slicers<\/li>\n
                • Design reports with advanced filtering techniques<\/li>\n
                • Consumption-time filtering<\/li>\n
                • Select report filter techniques<\/li>\n
                • Case study – Configure report filters based on feedback<\/li>\n<\/ul>\n

                  Create and manage workspaces in Power BI<\/p>\n

                    \n
                  • Distribute a report or dashboard<\/li>\n
                  • Monitor usage and performance<\/li>\n
                  • Recommend a development life cycle strategy<\/li>\n
                  • Troubleshoot data by viewing its lineage<\/li>\n
                  • Configure data protection<\/li>\n<\/ul>\n

                    Manage semantic models in Power BI<\/p>\n

                      \n
                    • Use a Power BI gateway to connect to on-premises data sources<\/li>\n
                    • Configure a semantic model scheduled refresh<\/li>\n
                    • Configure incremental refresh settings<\/li>\n
                    • Manage and promote semantic models<\/li>\n
                    • Troubleshoot service connectivity<\/li>\n
                    • Boost performance with query caching (Premium)<\/li>\n<\/ul>\n<\/div>\n\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n\n\n
                      \n
                      <\/div>\n<\/div>\n
                      \n
                      \n
                      \n

                      Training schedule<\/h2> <\/div>\n
                      \n
                      \n
                      \n
                      \n \n

                      Remote<\/p>\n

                      … if you value the opportunity to learn with a trainer and other participants, from anywhere without having to commute.<\/p>\n <\/div>\n <\/div>\n

                      \n
                      \n \n

                      Stationary<\/p>\n

                      … if you want to learn while sitting in the same room with the trainer and other participants.<\/p>\n <\/div>\n <\/div>\n

                      \n
                      \n \n

                      Online<\/p>\n

                      … if you want to learn from materials available via the interenet anywhere at any time<\/p>\n <\/div>\n <\/div>\n <\/div>\n

                      \n
                      \n
                      <\/div>\n<\/div>
                      \n
                      \n
                      \n
                      \n

                      Filters:<\/p>\n <\/div>\n

                      \n