Description

Microsoft Power BI is one of the most popular Data Visualization and Business Intelligence that connects data from different data sources and creates stunning & interactive BI reports and dashboards. It possesses a large market share among Fortune 500 companies.

In this 25-hour virtual Bootcamp course, Our Microsoft Certified Power BI Profession & Microsoft Certified Trainer, will start the discussion with the importance of data visualization and Power BI and will help you to reach the advanced level in Power BI. This knowledge enriching journey will complete the milestones of Power Query Editor, cleaning & data transformation, connecting data from multiple sources, Data Analysis Expressions (DAX) and Data Visualization. This course finally ends its journey with Power BI Service. This course also helps you to prepare for PL-300 Exam. PL-300 Exam helps you to get Microsoft Power BI Data Analyst Certification. This certification will support you to shift your career to Data Analyst position or enriches freshers to build their career as Data Analyst.

Course Objectives

Overview of Data Visualization & Power BI

Introduction to Power BI Desktop

Loading data from various data sources

Cleaning & transforming data with Power Query Editor

Merging & Appending data

Using DAX functions

Data Modelling

Creating & formatting visuals

Advanced charts

Slicers & Filters

Hierarchies

Introduction to Power BI Service

Power BI Report vs Dashboard

Data Gateways

Row Level Security 

Target Audience

This Bootcamp is for all industry professionals, faculty members and students who are passionate about Data Visualization and Data Analytics. Anyone who is eager to learn about Power BI as a newbie and would like to achieve the advanced level in it.

Basic Understanding

Basic MS Excel knowledge will help you but it is not compulsory.

Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

Microsoft Power BI Bootcamp

Session 1: Introduction to Data Visualization & Power BI

  1. Data Visualization
  2. History of Data Visualization
  3. Benefits of Data Visualization
  4. What is Power BI?
  5. Why are we learning Power BI?
  6. Components of Power BI
  7. Power BI Architecture
  8. Power BI pricing structure

Session 2: Power BI Desktop

  1. Introduction to Power BI Desktop
  2. Installation of Power BI Desktop
  3. Views in Power BI Desktop
  4. Overview of Power Query Editor

Session 3: Connect data from multiple sources

  1. Connect Excel & CSV files
  2. Connect Folder containing multiples Excel & CSV files
  3. Connect tables from Websites / SharePoint
  4. Understanding different data types
  5. Manually detecting data types
  6. Best practices in column naming conventions
  7. Creating Column Headers
  8. Modelling Data
  9. Managing Data Relationships

Session 4: Data Cleaning

  1. Removing duplicates, null values & errors
  2. Filtering blank rows & columns
  3. Filtering unwanted rows & columns
  4. Importance of Applied Steps section in Power Query Editor
  5. Replacing data from the tables
  6. Data profiling for data quality check
  7. Splitting columns

Session 5: Data Transformation

  1. Append Queries / Files
  2. Merge Queries / Files
  3. Merging columns
  4. Move columns & sorting of data
  5. Pivot & Unpivot of data
  6. Duplicate & Reference tables
  7. Closing & Applying changes in Power Query Editor
  8. Difference between Refresh Preview & Refresh All
  9. Issues in refreshing data

Session 6: Data Analysis Expressions (DAX)

  1. Overview of DAX
  2. Why DAX is important to learn?
  3. Data types in DAX
  4. Introduction to DAX functions
  5. Measures in DAX
  6. Calculated Columns in DAX
  7. Field Parameters (new feature)
  8. Date & Time functions
  9. Time Intelligence functions

Session 7: Data Visualization

  1. Introduction to visuals in Power BI
  2. Various charts in Power BI
  3. New Format Pane (new feature)
  4. Canvas Zoom (new feature)
  5. Chart formatting & customization
  6. Adjusting Page layout
  7. Creating Hierarchies
  8. Drill up & Drill down
  9. Page navigations
  10. Customizing Tooltips
  11. Slicers
  12. Sync slicers
  13. Bookmarks
  14. Filters
  15. Tables & Matrix
  16. Conditional formatting
  17. Advanced Charts
  18. Custom Visuals

Session 8: Power BI Service

  1. Overview of Power BI Service
  2. Importance of Power BI Service
  3. What is Workspace?
  4. Creating Workspace
  5. Power BI Report vs Dashboard
  6. Creating Power BI Dashboard
  7. Publish Power BI Report to Power BI Service
  8. Quick Insights
  9. Power BI Q&A
  10. Ask questions about our data using NQL
  11. Power BI Embedded
  12. Row Level Security (RLS)
  13. Paginated Report
  14. What is Data Gateway?
  15. Standard vs Personal Gateway
  16. Installation & configuration of Data Gateway
  17. Scheduled Refresh

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients