Enterprise Data Management <br> Professionals-1 (EDMP-1), Power BI <br> 100% Live Online

Enterprise Data Management
Professionals-1 (EDMP-1), Power BI
100% Live Online

Item# EDMP1-Power-BI-LiveOnline
$1,395.00, 3 people for $3,900.00, 4 people for $4,800.00, 5 people for $5,000.00
EDMP-1-/Power BI-1, 100% Live Online for Enterprise Data Management Professionals.

Class times: 10 AM to 7:15 PM, 100% Live Online, Eastern Time, using your computer. This is a three day class.

Course Objectives

1. Learn and practice self-service Power BI
2. Be able to analyze data from any source

Project Managers, Program Managers, IT Managers or Developers, Data Analysts, Business Managers, Business Analysts, Operation Managers, Engineers, Enterprise and Infrastructure Architects, CEOs, MBAs, Educators, CFOs, HR Managers, Quality and Risk Managers, Marketing & Advertising Managers, etc.

100% Live Online Power BI Training for Enterprise Data Management Professionals, Class I – 24 hours of training, and 3 days of training. This class is a price point for 100% Live Online training.

Class Times: 3 Days: 10 AM to 7:15 PM Eastern Time which is 7 AM to 4:15 PM Pacific Time or times that better suits your group.

Training Method: 100% Live Online Training

About the training: Trainees will be exposed to hands-on learning by using Power BI that includes using Power Query and Power Pivot. The trainees will learn Cloud technology, connecting to various data sources in order to analyze and create visual reports. They will learn how to implement self-service Business Intelligence (BI) and use Microsoft data platform to perform data analysis, how to share Power BI data, how to create a dashboard and how to use DAX. This competency certification is aligned to Microsoft Certification is aligned to Power BI and Power Pivot (Microsoft Excel). It is focused on Power BI Business Users. This class is for Business Users, not for IT Users.

Your Equipment Requirements: You will use your own lap top. In order to take this training, you will need to have 8 GB to 16 GB RAM on your laptop and download Power BI Desktop before coming to training. You will also be working with Power Pivot (Excel), also needed on your laptop. See Power BI requirements below.

Summary of What You Will Need for Training
(1) Your laptop
(2) Notebook and pen
(3) Install Power BI on your laptop before class (4) Install Power Pivot (Excel) installed on your laptop before class

There's no need for IT Experience in order to take the training: No prior IT or BI experience or training is required or needed; however, you need to have good excel skills that include all the following: Basic Excel Skills. Read the list at Basic Excel Skills' URL of what you MUST know before taking this class. The pre-requisite training in Excel is only $345.

This class aligned to Microsoft Certification 70-460 but it's not focused on the 70-460 exam. EDMP-1/Power BI-1 class is focused on Power BI for business users, those business users who work in business operations providing data analytics, insights and reports for decision making.

PDU # is EDMP-TR1-A This class offers PDUs for PMI Certifications. Ask us about the PDU breakdown.

EDMP-1/Power BI - 1
The Data Management Professional is someone who can fluidly use self-service Power BI. The first part of EDMP training takes an individual’s skills in “Business Analysis,” to a new height, where they can explain the industry trend known as SMAC – Social, Mobile, Analytics, and Cloud. You will be exposed to a holistic view of Enterprise Data, and a complete view of Big Data analytics using Power BI.

This intense three-day instructor-led class provides trainees the opportunities to practice using Power BI. Exposure to the power BI tool forms the foundation for self-service BI, where an individual can use any data, internal or external to the organization, to analyze and identify business insights. The trainee will also be exposed to data governance, data quality, and data models.

Benefits of Training

       • Using spreadsheets for your data analysis and creating a visual presentation of the analytics
       • Generate your own queries against variety of data sets without requiring IT as a middleman
       • Empowers you to use your Power BI self-service knowledge and skills
       • You can bring business value to your organization & clients by discovering customer sentiments
       • Pull big data to enable business insights using query & tables without any programming
       • Enables you to use big data solutions to drive prescriptive & predictive analytics

How to Purchase the Training: Call to confirm your group and we will activate the training dates for purchase, or join a training that's already happening.

Work Experience Requirements

Excel, and Power Pivot and a professional background.

Class Outline

EDMP-1/ Power BI for Business Users
BI – Business Intelligence is taking over the “analytical side” of an Organization or an Enterprise. Microsoft Power BI is an integrated tool that enables any business user to collect, query, organize, analyze, and create Visual Dashboards of business Data. This class is a 3-day training class, and it is totally hands-on and requires that attendees bring their own laptops with Power BI installed.

Power BI Introduction
1. Why Power BI and not other BI tools elements?
3. Flow of work in Power BI
4. Building blocks of Power BI, and how they relate
5. Power BI service with cloud services
6. Logging in to Power BI Desktop
7. Connecting to data sources in Power BI
8. Cleaning and transforming data with the Query editor
9. Getting data in shape for use with Power BI
10. Using advanced data sources and transformation
11. Connecting and combining two data sources
12. Cleaning irregularly formatted data Data Modeling
1. How to handle messy data in Power BI
2. Connecting many different data sources
3. How to manage data relationships in Power BI
4. Creating calculated columns, and creating unique keys
5. Optimizing Data Models for Visuals Creating and viewing visuals with optimized models
6. Define custom calculations to evaluate time-based functions
7. Building calculated tables based on DAX formulas and expressions
8. Exploring time-based data and discovering hierarchical drill-down tools for date fields

Data Visualization
1. Creating and customizing simple Visualizations
2. Customizing three common types of visuals
3. How to use combination charts
4. Creating and formatting slicers
5. How to use Map Visualizations
6. How to use tables and matrixes
7. How to use Scatter Charts
8. How to use Waterfall and Funnel Charts
9. How to use Gauges and Single Number Cards and drive
fast dashboard insights with gauges and numbers 10. How to modify colors in charts and visuals
11. Styling reports with Shapes, Text Boxes, and Images
12. Styling reports with page layout and formatting
13. Creating complex interactions between Visualizations
14. Duplicating a report page
15. Showing categories with no data
16. Customizing visuals with Summarization and Category Options
17. Arranging Z-order of Report Elements
18. Visual hierarchies and drill-down behavior
19. R Visuals in Power BI

Data Dashboard
1. Exploring data and collaborate with the Power BI service
2. Using quick insights in the Power BI service
3. Creating and configuring a Dashboard
4. Customizing dashboards in Power BI
5. Data usage with Natural Language and creating Q&A
6. Creating custom Q&A to suggest Q&A dashboard prompts
7. Sharing Dashboards with an organization
8. Displaying Visuals and Tiles Full-Screen
9. Edit Tile Details
10. Changing the title, link behavior, and adding widgets
11. Using Full Screen mode to manage dashboard space more effectively
12. Installing and Configuring a Personal Gateway

Excel and Power BI
1. Using a Personal Gateway to automatically update on-premises data
2. How Power BI and Excel work together
3. Importing an Excel table into Power BI
4. Uploading an Excel workbook to Power BI
5. Importing Excel files with data models and Power View sheets
6. Connecting OneDrive for Business to Power BI

Sharing BI Data
1. Publishing Reports from Power BI Desktop to the Power BI Service
2. Printing and exporting Power BI dashboards
3. Manually Republishing and Refreshing Data
4. Manually updating dataset and report
5. Introducing Power BI Mobile
6. Creating a group in Power BI
7. Creating a new group, set privacy levels, and invite members
8. Creating a content pack in Power BI
9. Publishing a content pack with a bundle of pre-designed dashboards, reports, and datasets
10. Connecting to a content pack from a group in Power BI
11. Reusing dashboards, reports, and datasets across an organization
12. Editing a content pack in Power BI
13. How to push content packs changes to others in an organization
14. Integrating OneDrive for Business with Power BI
15. Collaborating with OneDrive for Business and Power BI files

Using DAX
1. What is DAX
2. DAX Calculation types
3. Creating calculated columns and measures in Power BI using DAX formulas
4. Available DAX Functions
5. Using variables in DAX expressions
6. Table Relationships and DAX
7. Creating expressions across multiple tables with relational functions
8. DAX Tables and Filtering
9. Filtering and evaluating tables using advanced table functions

What You Will Receive
• Class material

What is not included in the price of your training? Free re-sitting. There are no exams available for this training.