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

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

Item# EDMP-1-BI
Check with us about possible training dates
Power BI Training for Enterprise Data Management Professionals, Class I – 28 hours of training, 100% Live Online, fully instructor-led training. Or schedule your Group onsite at your location in VA, DC, WA, or MI.

Class Times: 3 Days: 8 AM to 6:20 PM or your preference.

(1) 100% Live Online Training
(2) Troy, MI: SmartPath LLC, 100 W Big Beaver Rd, Suite 200, Troy, MI 48084. 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.
(3) Bellevue-WA, Greater Seattle area: SmartPath LLC, 2018 156th Ave NW, Bellevue WA 98007. Parking is free in designated places.
(4) Washington, DC: Call to schedule your group of 5 or more people

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 In order to take this training, you will need to have 8 GB to 16 GB RAM on your laptop, and download Power BI 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.

You don't need an IT background in order to use Big Data and other data to extract Business Intelligence. The future has become NOW. This is the new paradigm. This certification is aligned to Microsoft Certification 70-460 but it's not focused on 70-460 exam as this exam covers coding skills. This 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 See PDU Details Below if you are updating your PMI® certifications.

Power BI - 1
It 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 training:
Classes are guaranteed to run at the time of purchase or registration so register or purchase early if you wish to save the class dates. You may pay with debit cards, credit cards or PayPal. If the class is showing, it is still available for you to join, although it may be necessary to register at least 3 - 6 weeks before the first day of class to get a seat. Onsite seats at SmartPath LLC in Bellevue WA are limited to 9 people, and in Washington DC, the class is limited to 8. Live Video Conference attendees should purchase their class 4 business days before training so they receive the class handout o time.

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 materials

What is not included in the price of your training? Free resitting. There are no exams available for this training.
Scroll to top