Description
**We give participants access to a shared Power BI pro account so they can practice all the full aspects of Power BI. We also do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI that can drive business process and report automation and take you from just data analysis level to Business Intelligence (BI). We cover the following aspects: Get Data (bringing in your data for analysis)Data Sources in Power BI DesktopConnect to web data and web appsImport Excel WorkbooksConnect to enterprise DatabaseData Transformation, Power Query and DAXGet Data Model section of the report builder (Power BI Desktop)Creating RelationshipsCardinalityDirectionData section of the report builder (Power BI Desktop)Data TypeData FormatDAXNew ColumnNew MeasureNew TableMust know DAX formulasDAX formula reference guideRow level Security to control report access using roles (dept, function, branch, cost centre etc)Report section of the report builder (Power BI Desktop)Report creationNative VisualsCustom VisualsMenu Tools for professional looking reportsEdit InteractionsReport creation from scratchPower QueryTransforming and Combining Data before loading to ModelCommon Power Query tasksUnpivotPivotSplit ColumnAppend TablesMerge TablesRemove rowsUse first row as headerMerge ColumnsAdd ColumnsGroup ByExtractFillTransposeM Code reference resourceReport Publishing, Dashboards and Power BI ServiceUnderstanding the concept of WorkspacesPublishing report (from Power BI desktop to Power BI service for consumption)Controlling access to aspects of the report by role (region, department or level)Published Report optionsExporting to PowerPoint or PDFEmbedding in SharePointEmbedding in a websiteMaking it available via a web linkSharing with specific usersEditing the report - adding new visuals, changing visuals used and creating new report pagesAdding comments and tagging usersScheduling the report to send our daily or weekly to specific peopleCreating a DashboardCan be created from one or more reports to show management useful analysisCan incorporate data and visuals from other people's dashboards or reports shared with youSet Alerts to be instantly notified when a KPI is reached or an SLA is breachedAdd actionable commentsSchedule the dashboard to be sent out daily or weekly to specific peopleShare the dashboard with final usersBest practicesSetting automatic/scheduled refresh so new data is ingested automaticallyData Gateway configurationThe type of data sources that require data gatewayAI in Power BI and SettingsQ & A for autogenerating charts and tables in answer to questionsOrganization wide settingsAccount wide settingsWorkspace settingsDashboard settingsReport settingsDatasets settingsThis is the course to solidify your Power BI proficiency.
