{"product_id":"467808_acca-learning-china","title":"Power Query, Power Pivot, Power BI pack","description":"\u003ch2\u003eAbout this pack\u003c\/h2\u003eThis group of courses will provide you with the tools you need to generate rich and interactive dashboards, that look like they have spent weeks in development, in only a fraction of the time. Power Pivot, Power Query and Power BI are tools that enable database-like computational power on our desktops, firstly within the familiar environment of Excel, and then secondly within Power BI, automating and elevating the process of reporting and generating dashboards. Leverage Power Query and Power Pivot in Excel, and then see how they interact with Power BI to analyse and report key information.\u003cbr\u003e\n\u003cbr\u003e\nBy completing this course, you will be able to: \u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003eload, link and update data in Power Pivot\u003c\/li\u003e\n\u003cli\u003ewrite formulae in Power Pivot’s Data Analysis Expressions (DAX) language\u003c\/li\u003e\n\u003cli\u003eunderstand the Power BI ecosystem (including Desktop, Service, Mobile) and it's place in Microsoft Fabric and in the broader Microsoft data platform\u003c\/li\u003e\n\u003cli\u003eextract, transform and load data using Power Query from a range of sources\u003c\/li\u003e\n\u003cli\u003eformat and transform ’dirty’ data into a usable form to enable analysis\u003c\/li\u003e\n\u003cli\u003epublish, secure, and share reports using Power BI Service, including apps, permissions, refresh schedules, and collaboration features.\u003c\/li\u003e\n\u003c\/ul\u003e \u003ch2\u003eCourses included in this pack\u003c\/h2\u003e\u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003ePower Query\u003c\/li\u003e\n\u003cli\u003ePower Pivot\u003c\/li\u003e\n\u003cli\u003ePower BI 2026.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003ch4\u003eKey information\u003c\/h4\u003e\u003cul class=\"htmlEditor-ul\"\u003e\n\u003cli\u003eThis pack contains a collection of videos for you to follow, and exercises for you to complete within Excel.\u003c\/li\u003e\n\u003cli\u003eThis pack requires you to have a basic understanding of Microsoft Excel.\u003c\/li\u003e\n\u003cli\u003eThis pack requires you to download Power BI Desktop and register for the Power BI Service.\u003c\/li\u003e\n\u003cli\u003eThis pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).\u003c\/li\u003e\n\u003cli\u003eThe recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.\u003c\/li\u003e\n\u003cli\u003eCPD certificate is available upon successful completion of all courses within the pack.\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003cimg alt=\"ACCA SumProduct joint logo\" src=\"${PICTURE_CONTEXT_PATH}ckeditor_uploads\/ACCA_SumProduct_sml_470588.jpg\" style=\"margin: 5.0px;\"\u003e\u003c\/p\u003e","brand":"acca-learning-china","offers":[{"title":"Standard price \/ 0","offer_id":48285072720123,"sku":"100184","price":375.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":48285072818427,"sku":"100184","price":375.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":48285072785659,"sku":"100184","price":375.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":48285072752891,"sku":"100184","price":375.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/sum_power_query_pivot_bi_467851.jpg?v=1780723081","url":"https:\/\/acca-learning.myshopify.com\/products\/467808_acca-learning-china","provider":"acca-learning","version":"1.0","type":"link"}