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 MICROSOFT EXCEL

IMPORT FROM DATA SOURCES
  • Connect to and import from databases, files, and folders
  • Connect to Microsoft SQL Azure and Big Data
  • Import from Excel workbooks
  • Link to data from other sources
  • Privacy Levels
PERFORM DATA TRANSFORMATIONS
  • Design and implement basic and advanced transformations
  • Apply business rules
  • Change data format to support visualization
  • Filter data
  • Format data
CLEANSE DATA
  • Manage incomplete data
  • Handle data received as a report

MODEL DATA

CREATE AND OPTIMIZE DATA MODELS
  • Understanding the Excel data model
  • Get & Transform
  • Manually enter data
  • Manage data relationships
  • Optimize models for reporting
CREATE CALCULATED COLUMNS, MEASURES, AND TABLES
  • Create DAX formulas
  • Create DAX queries
  • Create Excel formulas
CREATE HIERARCHIES
  • Create data hierarchies
  • Create business hierarchies
  • Resolve hierarchy issues
CREATE PERFORMANCE KPI’S
  • Calculate the actual value

VISUALIZE DATA

CREATE AND MANAGE PIVOT TABLES
  • Format PivotTables
  • Format calculated measures
  • Filter data
  • Group and summarize data
CREATE AND MANAGE PIVOT CHARTS
  • Select a chart type
  • Format PivotCharts
  • Filter Data
INTERACT WITH POWER BI
  • Power BI overview
  • Import Excel data from Power BI
  • Manipulate Excel data in Power BI
Location & Dates
Call us at +971 4 430 8394