Course Overview

Power Bi is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And create scale across the enterprise, with governance and security built-in.
Prepare for Microsoft Exam 70-778 and help demonstrate your real-world mastery of Power BI data analysis and visualization. This course is designed for professionals interested in developing their skills in Business Intelligence. It will develop your skills in data analysis and business reporting, and Business Intelligence. Exam 70-779 focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. The course focuses on the expertise measured by following objectives: Consume and transform data by using Power BI Desktop, Model and visualize data, Configure dashboards, reports, and apps in the Power BI Service

Course Methodology

This is a hands-on course with about 20% on design and structure and 80% uses Power BI as a commanding tool to perform routine and periodic tasks. Individuals will be required to complete exercises, case studies, and projects on a daily basis.

Course Objectives

Upon successful completion of this course:
  • Consume and transform data by using Microsoft Excel
  • Model data, from building and optimizing data models through creating performance KPIs
  • Visualize data
  • Creating and managing PivotTables and PivotCharts
  • Interacting with Power BI
  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

Target Audience

Data Analysts, Business Reporting Professionals, BI professionals, and other roles responsible for analyzing data with Excel. Business professionals, senior and junior business analysts, research professionals, marketing and sales, administrative staff, supervisors, general business professionals.
Professionals with strong understanding of how to use Microsoft Excel to perform data analysis. Delegates should be able to consume, transform, model, and visualize data in Excel. Also, delegates should also be able to configure and manipulate data in PowerPivot, PivotTables, and Pivot Charts

Target Competencies

  • Business analytics
  • Data connectivity
  • Data preparation and analysis
  • Report writing techniques
  • Publishing and sharing work
  • Designing dashboards

Course Outline

CONSUME & TRANSFORM DATA BY USING POWER BI DESKTOP

CONNECT TO DATA SOURCES
  • Connect to databases, files, and folders
  • Data connectivity modes
  • Importing data
  • DirectQuery
  • Implications of using DirectQuery
  • When to use DirectQuery
  • Live Connection
  • Connecting to: Microsoft SQL Server Access database Oracle database MySQL database PostgreSQL database Data using generic interfaces Text/CSV files JSON files XML files Folder SharePoint folder Web pages and files Azure Data Lake Store and Azure Blob
CONNECT TO SQL AZURE, BIG DATA, SQL SERVER ANALYSIS SERVICES (SSAS)
  • Connecting to: Azure SQL Database and Azure SQL Data Warehouse Azure HDInsight Spark SQL Server Analysis Services (SSAS) Power Bi Services
PERFORM TRANSFORMATIONS
  • Design and Implement basic and advanced transformations
  • Power Query overview
  • Using the Power Query Editor interface
  • Basic transformations
  • Advanced transformations
  • Appending queries merging queries
  • Creating new columns in tables
APPLY BUSINESS RULES
  • Change data format to support visualization

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
  • Measures
  • Use What-If parameters
MEASURES PERFORMANCE BY USING KPI’S, GUAGES, AND CARDS
  • Calculate: The actual, The target, 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 VISUALIZING
  • Select a visualizing type
  • Configure page layout and formatting
  • Configure interactions between visuals
  • 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
  • Enable and integrate R visuals
  • Format measures
  • Use bookmarks and themes for reports
MANAGE CUSTOM REPORTING SOLUTIONS
  • Configure and access Microsoft Power BI Embedded
  • Enable developers to create and edit reports through custom applications
  • Enable developers to embed reports in applications
  • Use the Power BI API to push data into a Power BI dataset
  • Enable developers to create custom visuals

CONFIGURE DSHBOARDS, 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
  • Customize the URL and titles
  • Enable natural language queries
CONFIGURE SECURITY FOR DASHBOARD, REPORTS, AND APPS
  • Create a security group by using the Admin Portal
  • Configure: Access to dashboards and app workspaces, The export and sharing setting of the tenant, Row-level security
CONFIGURE APPS AND APPS WORKSPACES
  • Create and configure an app workspace
  • Publish an app
Location & Dates
Call us at +971 4 430 8394