MSBI Tutor

Welcome to the October 2021 update. Leaves fall, Power BI calls; and we are excited to release additional functionality and performance improvements for DirectQuery, optimization for the SWITCH function,  new Bitwise DAX functions, and general availability of the Premium Gen2 platform for premium capacities. There is more to explore, please continue to read on.   Reporting Heat map layer – Azure Maps Visual DirectQuery for Power BI datasets and Azure Analysis Services More flexibility when selecting tables Performance improvements Tenant-level feature switch for Bing Maps Modeling SWITCH performance optimization Bitwise functions in DAX Data connectivity and preparation Amazon Redshift (Connector Update) Dataverse (Connector Update) Google Analytics (Connector Update) Azure Cosmos DB V2 (New Connector) Azure Databricks (Connector Update) Amazon Athena SIS-CC-SDMX (New Connector) SumTotal (Connector Update) Usercube (New Connector) Service Admin & governance Premiu

Course Outline Introduction Overview of Microsoft Power Platform Features Power Platform main components Integration with Office 365, Dynamics 365, and third-party apps Data sources and connectors Getting Started with Microsoft Power Platform Microsoft Dataverse basics (formally Common Data Service (CDS)) Tables and columns Relationships and environments Business rules Power Platform admin center Building Simple Applications with Power Apps Connecting with common data sources Different app types No code artificial intelligence (AI) Security, governance, and reporting features Power Apps Portals Creating Different Applications with Power Apps Building a canvas app Basic elements and functions Connecting to a data source Creating a model-driven app Building blocks (data, user interface, logic, visualization) Creating a form Security and access control Automating Processes with Power Automate Flow types Flow templates Recurring flows Button flow Approval requests Business process flow Gen

SELECT TBL . name AS ObjName       , STAT . row_count AS StatRowCount       , STAT . used_page_count * 8 AS UsedSizeKB       , STAT . reserved_page_count * 8 AS RevervedSizeKB FROM tempdb . sys . partitions AS PART      INNER JOIN tempdb . sys . dm_db_partition_stats AS STAT          ON PART . partition_id = STAT . partition_id             AND PART . partition_number = STAT . partition_number      INNER JOIN tempdb . sys . tables AS TBL          ON STAT . object_id = TBL . object_id ORDER BY TBL . name ;