ClickCease
Intermediate Power BI

Power BI trainings in Singapore is designed for all Professionals, who are focused on learning about nuances of Power BI and Data Visualization in today’s world.

The participants of this Power BI Trainings in Singapore will learn about working on large data sets and complex calculation parallelly with our expert trainer and work through understanding data statistically and application of meaning techniques on data mining and slicing and dicing of data. Through this workshop participants will be able to use dynamic formulas and use of interactive graphical techniques like charts and present raw data into meaningful and insightful reports using Power BI.

Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Hands on exercises and practical examples will be given to participants to master these functionalities and apply them in a meaningful way.

1.   Introduction to Power BI

  • Your Data on the go
  • Installing Power BI
  • Understanding Power BI Interface
  • Architecture of Power BI

 

2.  Working and Navigation on Power BI

  • Add, Delete, Rename, Duplicate pages
  • Add delete, rename and split Columns and Rows
  • Basic and Advanced Filtering in Power BI
  • Page Level vs Report Level Filters
  • Using Slicers
  • Sorting Data

Hands on Exercises to work with the trainer

3.  Learning about connection with different data sources

  •  Importing data through multiple excel Files,
  • Importing data through text files,
  • What and how to use Direct Query, Imported Query
  • Online source
  • Load data from Multiple Data Sources

 

4.  Data Modelling

  • How to create relationships in data sources
  • Combining Multiple Tables
  • Use calculated table to create connection between two tables
  • Formatting Dates Hierarchies and Joins

 

5.  Understanding DAX Language

  •  Explaining most commonly used formulas and functions
  1. Aggregate functions
  2. Counting functions
  3. Text functions
  4. Date functions
  5. Information functions
  •  Creating Calculated Columns
  •  Calculated Tables
  •  Calculated Columns

 

6.  Creating Power BI Charts:

  •  Introduction to Charts
  1. Area Chart,
  2. Bar Chart,
  3. Column Chart,
  4. Doughnut Chart,
  5. Line Chart,
  6. Pie Chart,
  •  Modifying Charts properties like
  1. changing source data,
  2. legend,
  3. colors,
  4. Borders.
  5. Titles,
  6. font, etc
  •  Inserting Objects and Graphics

 

7.  Creating Power BI Reports

  • Introduction to Power BI Reports
  • Adding different elements in Reports
  • Formatting Reports
  • Drill up and Drill down Reports
  • Navigation across different sheet tables after creating report summaries

 

8. Sharing Power BI dashboards

  •  Report Sharing in Power BI Dashboard

 

9.  Printing Power BI Reports

  •  Printing Power BI Reports
  • Publishing Report internally
  • Publishing reports to the web

At the end of the workshop the participants will be able to increase productivity and enhance efficiency in their day to day work.

Participants will be able to analyze their data in a meaningful way to draw further insights and decision making. The aim of the workshop is to help them make dynamic and interactive reports with multiple functionalities using Power BI.

This will help the participants to create meaningful and insightful reports for seniors to enable them to generate better insights

The training is ideal for all who deal with large volume of data & excel in their day to day work for creating reporting solutions, data mining and need excel tools and technologies for further enhancing their efficiency and productivity.

This workshop is apt for those people who want to understand the analytical perspective to data and now want to step ahead and create an edge in their industry with use of most popular Data Visualization and Business Intelligence tools and technologies

You can discuss your unique requirements at +65 84831463 or simply fill the required details on Enquiry Now Page and send us at divya@outsourcingwise.com

Enquire Now