Course Code: bespokedatavisualization
Duration: 35 hours
Overview:

The aim of this advanced training is to create in house certified core group that can lead trainings and advice on the following areas:

  • Visualize data, author reports, and schedule automated refresh of the reports
  • Create and share dashboards based on reports in Power BI desktop and Excel
  • Use natural language queries
  • Create real-time dashboards
Course Outline:

  • Consuming and Transforming Data By Using Power BI

  • Connect to data sources

  • Connect to databases, files, folders; import from Excel; connect to SQL Azure, BigData, SQL Server Analysis Services (SSAS)

  • Perform transformations

  • Design and implement basic and advanced transformations; apply business rules; change the data format to support visualization

  • Cleanse data

  • Manage incomplete data; meet data quality requirements

  • Modeling and Visualizing Data

  • Create and optimize data models

  • Manage relationships; optimize models for reporting; manually type in data; use power Query

  • Create calculated columns, calculated tables, and measures

  • Create DAX formulas for calculated columns, calculated tables, and measures; useWhat If parameters

  • Measure performance by using KPIs, gauges, and cards

  • Calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values

  • Create hierarchies

  • Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy

  • Create and format interactive visualizations

  • Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Usebookmarks and themes for reports

  • Manage custom reporting solutions

  • Configure and access Microsoft Power BI Embedded; enable developers to createand edit reports through custom applications; enable developers to embed reportsin applications; use the Power BI API to push data into a Power BI dataset; enabledevelopers to create custom visuals

  • Create interactive maps

  • Use the different map visuals available in PowerBI to create interactive maps.

  • Create JSON file based on the available geodata to produce interactive custom maps.

  • Configure Dashboards, Reports and Apps in the Power BI Service

  • Access on-premises data

  • Connect to a data source by using a data gateway; publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop

  • Configure a dashboard

  • Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries

  • Publish and embed reports

  • Publish to the web; publish to Microsoft SharePoint; publish reports to a Power BIReport Server

  • Configure security for dashboards, reports and apps

  • Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant;configure Row-Level Security

  • Configure apps and apps workspaces

  • Create and configure an app workspace; publish an app; update a published app;package dashboards and reports as apps