Power BI Training

Watch demo Course

Power BI Training Course
This Power BI training course lets you master the Microsoft Power BI tool. We provide the best training classes to help you learn Extracting data, Data Transformations, Data Modelling, Data Visualization, Power BI Templates with various services and dashboards.

  • It will be an Online Live Instructor-Led Training Program
  • Complete emphasis will be given on the Hands-On Learning approach.
  • Virtual Machine access will be given to each participant for doing all the labs. That VM will be properly configured. It will have all the necessary software, sample source data files along with the Power BI Cloud accounts.

4.4/5

(1027 Ratings)

1349

  • Any Non-IT professional from domains such as Banking, Finance, Insurance, Marketing, Sales, Business Analysis, Engineering, Manufacturing, Logistics, Education, Medicine etc.       
  • Any IT professional who is working in technical areas such as Databases, Business Intelligence or Software Development related to report generation and data analytics.
  • Any student who aspires to start a career in the fields of Data Analytics, Data Science and Business Intelligence.

  • Basic understanding of MS Excel

  • Introducing Power BI
  1. Concept and Features of Data Visualization
  2. Evolution of Power BI
  3. Key Differences between Excel and Power BI
  4. Understanding the configurations of main Power BI Products such as Power BI Desktop and Power BI Services
  5. Walkthrough in Power BI Desktop
  • Understanding Data from Analytics perspectives
  1. Dimension columns
  2. Measure columns
  3. Hierarchical Columns
  4. Derived Columns
  • Extracting data from varied sources such as
  1. Text files
  2. Excel Files
  3. Folder as a Data Source
  4. Databases such as SQL Server, Oracle.                                                                                                                                                                                                                                                                                      
  • Data Transformations (M Query, Power Query Editor – Shaping Data)
  1. Formatting existing columns (trimming, extracting part of text, changing case, etc.)
  2. Filtering rows based on business conditions.
  3. Removing rows having Errors
  4. Removing duplicate rows
  5. Creating new columns using expressions
  6. Creating Index columns
  7. Merging Data
  8. Appending Data                                                                                                                                                                                                                                                                                             
  • Data Modelling: Relationships
  1. Concept of Cardinality
  2. Relating two tables
  3. Relating more than 2 tables
  4. Handling many to many relationships
  5. Cross Filter directions
  6. Active – Inactive relationships                                                                                                                                                                                                                                                                         
  • DAX
  1. Introduction to DAX
  2. Relational functions
  3. Conditional functions
  4. Aggregate functions
  5. Date & Time functions
  6. Time intelligence functions
  7. Lookup Functions
  8. Table functions
  9. Logical functions
  10. Statistical functions
  11. Text functions
  12. Filter Context
  13. Calculate function
  14. Analytical functions                                                                                                                                                                                                                                                                                                                            
  • Data Visualization in Power BI                                                                                                                                                                                                                                                                                                                          
  1. Understanding the power of charts in Power BI
  2. Pie Chart
  3. Clustered Column Chart
  4. Disabling interactivity within the visuals
  5. Line & Stacked Column Chart
  6. Funnel Chart
  7. Line Chart
  8. Map
  9. Waterfall Chart
  10. Scatter Chart
  11. Gauge chart
  12. Area Chart
  13. Slicer
  14. Card
  15. Multi-row Card
  16. KPI
  17. Matrix
  18. Disabling and enabling interactivity within different charts
  19. Conditional Formatting the Visuals
  20. Exploring Custom Visuals
  21. Drill through Reports
  22. Q & A feature
  23. Page and All Pages Filter                                                                                                                                                                                                                                                                                      
  • Parameters in Power BI
  1. Creating & using parameters for metadata of Data Source
  2. Creating & using parameters in Visuals
  • Enhancing the capability of column values
  1. Creating Hierarchies
  2. Creating Groups
  • Bookmarks
  1. Saving a state of a page through bookmark
  2. Using bookmarks to traverse through pages using elements such as buttons or Shapes.
  • Direct Query Mode of Data Source
  1. Import Vs Direct Query Mode (Pros and Cons of both)
  2. Getting data from RDBMS such as SQL Server using Direct Mode
  3. Mixed Mode of storage
  • Power BI Templates
  1. Advantage of creating a Template
  2. Using a template to create reports in Power BI Desktop
  • Power BI Service User Accounts
  1. Overview of Azure Cloud storage of Power BI
  2. Understanding of Power BI user accounts:-
  3. Trial Office 365 user
  4. Power BI Pro User
  5. Power BI Premium user     
  6. Power BI Service
  7. Introduction to Power BI Service
  8. Publishing report in Power BI Service
  9. Analyze in Excel feature                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
  • Dashboards
  1. Introduction to Dashboards
  2. Advantages of Dashboards
  3. Understanding Dashboards versus Reports
  4. Pinning selective visuals in a Dashboard
  5. Pinning a Live Page in a Dashboard
  6. Pin a tile to another Dashboard
  7. Creating a Copy of a Dashboard
  8. Creating Quick Insights on a Dashboard
  9. Use a Q&A in a Dashboard
  10. Privileges required for creating a Dashboard, i.e. who can create the Dashboard.
  11. Editing the Dashboards, its tiles layouts
  12. Creating Alerts in Dashboards
  • Row Level Security in Power BI
  1. Creating roles
  2. Assigning roles to users
  3. Securing the Dashboards
  • Workspace
  1. Advantages of user-defined workspace
  2. Providing user access to workspaces
  3. Practical implementation of Workspaces
  • Content Packs:
  1. Advantage of Content Packs
  2. Content Packs Versus Workspace
  3. Practical implementation of Content Packs
  • Other options of Publishing reports in Power BI
  1. Publish to Web
  2. Secure Embed
  • Overview of Power BI Gateways:
  1. Introduction to Gateways
  2. Basics of configuring a Gateway
  • Self-Serviced BI
  1. Introduction to Self-Serviced BI
  2. Creating a report in Power BI Service from specific sources
  3. Creating Report in Power BI Service from already published Datasets
  4. Creating Report in Power BI Desktop from already published Datasets
  5. Publishing Workbooks in Power BI Service

After attending this training, the participants will be able to do the following:

  • Extract data from varied sources and convert the extracted data into relevant business data by creating reports having comparative analysis of different aspects of business process
  • Convert the Analysis and Summaries into nice and powerful Visualizations.
  • Create Dashboards which will depict the key areas from the multiple reports.
  • Share the reports and dashboards amongst colleagues, subordinates, seniors, top management, end users and to clients.
  • Share the reports with conditional access of data to users.
  • Create reports and dashboards in cloud which can be considered as "Self-Serviced BI".
  • Most importantly the training will help in improving or enhancing the busines decisions or strategies based on the Power BI Reports & Dashboard, as the hidden facts, ups & downs, trends will become easily viewable!!
  • Checkout power bi interview questions and answers 

 

  • Any Non-IT professional from domains such as Banking, Finance, Insurance, Marketing, Sales, Business Analysis, Engineering, Manufacturing, Logistics, Education, Medicine etc.       
  • Any IT professional who is working in technical areas such as Databases, Business Intelligence or Software Development related to report generation and data analytics.
  • Any student who aspires to start a career in the fields of Data Analytics, Data Science and Business Intelligence.
  • Basic understanding of MS Excel
  • Introducing Power BI
  1. Concept and Features of Data Visualization
  2. Evolution of Power BI
  3. Key Differences between Excel and Power BI
  4. Understanding the configurations of main Power BI Products such as Power BI Desktop and Power BI Services
  5. Walkthrough in Power BI Desktop
  • Understanding Data from Analytics perspectives
  1. Dimension columns
  2. Measure columns
  3. Hierarchical Columns
  4. Derived Columns
  • Extracting data from varied sources such as
  1. Text files
  2. Excel Files
  3. Folder as a Data Source
  4. Databases such as SQL Server, Oracle.                                                                                                                                                                                                                                                                                      
  • Data Transformations (M Query, Power Query Editor – Shaping Data)
  1. Formatting existing columns (trimming, extracting part of text, changing case, etc.)
  2. Filtering rows based on business conditions.
  3. Removing rows having Errors
  4. Removing duplicate rows
  5. Creating new columns using expressions
  6. Creating Index columns
  7. Merging Data
  8. Appending Data                                                                                                                                                                                                                                                                                             
  • Data Modelling: Relationships
  1. Concept of Cardinality
  2. Relating two tables
  3. Relating more than 2 tables
  4. Handling many to many relationships
  5. Cross Filter directions
  6. Active – Inactive relationships                                                                                                                                                                                                                                                                         
  • DAX
  1. Introduction to DAX
  2. Relational functions
  3. Conditional functions
  4. Aggregate functions
  5. Date & Time functions
  6. Time intelligence functions
  7. Lookup Functions
  8. Table functions
  9. Logical functions
  10. Statistical functions
  11. Text functions
  12. Filter Context
  13. Calculate function
  14. Analytical functions                                                                                                                                                                                                                                                                                                                            
  • Data Visualization in Power BI                                                                                                                                                                                                                                                                                                                          
  1. Understanding the power of charts in Power BI
  2. Pie Chart
  3. Clustered Column Chart
  4. Disabling interactivity within the visuals
  5. Line & Stacked Column Chart
  6. Funnel Chart
  7. Line Chart
  8. Map
  9. Waterfall Chart
  10. Scatter Chart
  11. Gauge chart
  12. Area Chart
  13. Slicer
  14. Card
  15. Multi-row Card
  16. KPI
  17. Matrix
  18. Disabling and enabling interactivity within different charts
  19. Conditional Formatting the Visuals
  20. Exploring Custom Visuals
  21. Drill through Reports
  22. Q & A feature
  23. Page and All Pages Filter                                                                                                                                                                                                                                                                                      
  • Parameters in Power BI
  1. Creating & using parameters for metadata of Data Source
  2. Creating & using parameters in Visuals
  • Enhancing the capability of column values
  1. Creating Hierarchies
  2. Creating Groups
  • Bookmarks
  1. Saving a state of a page through bookmark
  2. Using bookmarks to traverse through pages using elements such as buttons or Shapes.
  • Direct Query Mode of Data Source
  1. Import Vs Direct Query Mode (Pros and Cons of both)
  2. Getting data from RDBMS such as SQL Server using Direct Mode
  3. Mixed Mode of storage
  • Power BI Templates
  1. Advantage of creating a Template
  2. Using a template to create reports in Power BI Desktop
  • Power BI Service User Accounts
  1. Overview of Azure Cloud storage of Power BI
  2. Understanding of Power BI user accounts:-
  3. Trial Office 365 user
  4. Power BI Pro User
  5. Power BI Premium user     
  6. Power BI Service
  7. Introduction to Power BI Service
  8. Publishing report in Power BI Service
  9. Analyze in Excel feature                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
  • Dashboards
  1. Introduction to Dashboards
  2. Advantages of Dashboards
  3. Understanding Dashboards versus Reports
  4. Pinning selective visuals in a Dashboard
  5. Pinning a Live Page in a Dashboard
  6. Pin a tile to another Dashboard
  7. Creating a Copy of a Dashboard
  8. Creating Quick Insights on a Dashboard
  9. Use a Q&A in a Dashboard
  10. Privileges required for creating a Dashboard, i.e. who can create the Dashboard.
  11. Editing the Dashboards, its tiles layouts
  12. Creating Alerts in Dashboards
  • Row Level Security in Power BI
  1. Creating roles
  2. Assigning roles to users
  3. Securing the Dashboards
  • Workspace
  1. Advantages of user-defined workspace
  2. Providing user access to workspaces
  3. Practical implementation of Workspaces
  • Content Packs:
  1. Advantage of Content Packs
  2. Content Packs Versus Workspace
  3. Practical implementation of Content Packs
  • Other options of Publishing reports in Power BI
  1. Publish to Web
  2. Secure Embed
  • Overview of Power BI Gateways:
  1. Introduction to Gateways
  2. Basics of configuring a Gateway
  • Self-Serviced BI
  1. Introduction to Self-Serviced BI
  2. Creating a report in Power BI Service from specific sources
  3. Creating Report in Power BI Service from already published Datasets
  4. Creating Report in Power BI Desktop from already published Datasets
  5. Publishing Workbooks in Power BI Service

After attending this training, the participants will be able to do the following:

  • Extract data from varied sources and convert the extracted data into relevant business data by creating reports having comparative analysis of different aspects of business process
  • Convert the Analysis and Summaries into nice and powerful Visualizations.
  • Create Dashboards which will depict the key areas from the multiple reports.
  • Share the reports and dashboards amongst colleagues, subordinates, seniors, top management, end users and to clients.
  • Share the reports with conditional access of data to users.
  • Create reports and dashboards in cloud which can be considered as "Self-Serviced BI".
  • Most importantly the training will help in improving or enhancing the busines decisions or strategies based on the Power BI Reports & Dashboard, as the hidden facts, ups & downs, trends will become easily viewable!!
  • Checkout power bi interview questions and answers 

 

Request More Information

Reviews

reviewer.png

Ram manohar Prasad

Business Intelligence Analyst

Through this course, I understood complete Data Visualisation with Analytics, Data Modelling, and lot more. Course material is excellent and trainer with professional knowledge with vast industry experience. Thanks, Vinsys!


reviewer.png

Shilpa Agrawal

BI Consultant

Overall The quality of the material, faculty and the way the courses are designed conducted, and managed are outstanding. Vinsys follows a very disciplined way to conduct this training with timely reminders and post-training followup.


Find this Course at other locations:

+91-20-67444700

Australia | China | Kenya | India | Malaysia | Oman | Singapore | Tanzania | UAE | USA |

enquiry@vinsys.com