Enterprise Data Management
Professionals-1 (EDMP-1), Power BI
100% Live Online
EDMP-1-/Power BI-1, 100% Live Online for Enterprise Data Management Professionals. 7-26-24: This page is currently being updated to reflect the new exam contents.
To purchase all 5 days, click here
Class times: 10 AM to 6:00 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
Audience
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 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 (5) You should have 16 GM of RAM on your computer.
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
What You Will Receive
• Class material in digital format and 21 hours of training
You should have 16 GM of RAM on your computer.
To purchase all 5 days, click here
Class times: 10 AM to 6:00 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
Audience
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 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 (5) You should have 16 GM of RAM on your computer.
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
What You Will Receive
• Class material in digital format and 21 hours of training
You should have 16 GM of RAM on your computer.
