Enterprise Data Management<br> Professionals-1 (EDMP-1), Power BI, <br>Power Learning for Business Users

Enterprise Data Management
Professionals-1 (EDMP-1), Power BI,
Power Learning for Business Users

Item# EDMP-1-BI
Power BI Training for Enterprise Data Management Professionals, Class I – 28 hours of training, and 3 days of training. This class is a price point for Onsite training. Schedule your Group onsite at your location in VA, DC, WA, or MI.

Class Times: 3 Days: 8 AM to 5:15 PM or times that better suits your group.

Next available training even. Pre-register now: July 29 to 31. It this class goes forward it will be at the Washington, DC location below. Call Nereda Haque to pre-register at 360-584-8614. Tell your friends to make this class happen. We have 1 trainee pre-registered on 4-25-2019. We need 4 more. This is a powerful class, and you will learn so much that you will be able to apply immediately. If you have a PMP credential, you can earn 24 PDUs.

Training Locations & Methods: Training locations are for groups and other participating individuals who want to pre-register for a specific training event:
(1) 100% Live Online Training
(2) Troy, MI: SmartPath LLC, 100 W Big Beaver Rd, Suite 200, Troy, MI 48084 for a group of 3 or more or at a nearby hotel if your group exceeds 13 people. Parking is free behind the building or on the top of the parking garage only. The first floor of the parking garage is for monthly clients only. There is a small conference room for up to 5 trainees at this facility that is available if you schedule in advance.
(3) Bellevue-WA, Greater Seattle area: SmartPath LLC, 2018 156th Ave NW, Bellevue WA 98007 or a nearby location if your groups exceeds 13 people. Parking is free in designated places only.
(4) Washington, DC: Call to schedule your group of 6 to 7 at 1101 Connecticut Ave NW, Suite 410, DC or at another suitable location.

About the training: Students 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, and for the optional EDMP-1 certification Exam. This class is for Business Users, not for IT Users.

Your Equipment Requirements: - BYO Bring 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 Need for Training
(1) Your laptop
(2) Notebook and pen
(3) Bring your own laptop with Power BI installed
(4) Have Power Pivot (Excel) installed

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 of 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.

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.

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. This training assumes that you already know basic Excel.

PDU # is EDMP-TR1-A See PDU Details Below if you are updating your PMI® certifications.

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 four-day instructor-led class provides trainees the opportunities to practice using Power BI. Exposure to power BI toola 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

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 4 days training 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 create 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 resitting. There are no exams available for this training.