Data Analysis and Visualization Training with Power BI

4,3 (122 voting)
 Last update date 02/2024
 Türkçe

Excel VBA & Macro Training check out our education.

Data Analysis and Visualization Training with Power BI

Who can participate in the education 

People who want to properly process raw data and turn it into “information” and do reporting in order to make quick decisions in small or large companies. 

Learning Outcomes 

  • The participants will be able to connect to data for business mind (BI) 
  • The participants will be able to import data and make transforming and shaping 
  • The participants will be able to visualize the data  
  • The participants will be able to write report and programming at automatic refresh 
  • The participants will be able to create dashboards based to report at excel and Power bl desktop 
  • The participants will be able to share to create reports 
  • The participants will be able to use natural language query 
  • The participants will be able to create real time dashboard 

Education Dates: First is got preregistration then educations are dated and informed according to demand. 

The method of education: Online education of live (synchronous) 

Duration of education: 20 hours 

Number of participants: Minimum of 10 people  

Education Content 

Will be able to make that with Power Bl Desktop 

  • Import data 
  • Creating associations and new criterion and you can data replication with data formats 
  • Creating reports 
  • Hiding reports 
  • Loading and publish of reports 

Module 1: Import data 

  • Overview of Power BI Desktop 
  • Start of Power BI Desktop 
  • Connecting to data sources at Power BI Desktop   
  • Data transforming and cleaning with query editor 
  • More developed data sources and transforming  
  • Cleaning irregularly formatted data 

Module 2: Modelling 

  • Introduction modelling to data 
  • Associate between tables and associate types 
  • Setting data associate 
  • Creating column is calculated 
  • Optimization is data models 
  • Creating calculated measurements 
  • Discovering data based on time 
  • Making calculations in the data suitable for the graphic. 

Module 3: Visualization 

  • Introduction to visuals at Power Bl 
  • Create and privatization to sample Visualization 
  • Mixed chart 
  • Slicers 
  • Map of visualize 
  •  Matrix and tables 
  • Chart of scatter 
  • Chart of waterfall and funnel 
  • Odd numbers of carts and gauges 
  • Changing colors in charts and images 
  • Categorized data and data description on graphics. 
  • Shapes, text boxes, images 
  • Page setup 
  • Copying a report page 
  • Showing category without data 
  • Z order 
  • Visual hierarch and drill-down 
  • Filters 

Module 4: Data Analytic Expressions Language (DAX) 

  • Introduction to the DAX Language 
  • DAX Functions 
  • -Aggregate functions 
  • -Count functions 
  • -Logical functions 
  • -Date functions 
  • Calculate functions 
  • Process of date tables 
  • Time intelligence functions 
  • Calculate of ratio and percent 
  • Creating of calculated column and measures  
  • DAX tables functions 
  • Asociate of between tables in DAX 
  • Use of iterator functions 
  • Use of date tables 

Module 5: Introduction to Power Bl Cloud Service 

  • Creating and configuring a clipboard 
  • Sharing dashboards with your organization 
  • Editing details and adding items 
  • Gateway and configuration 

Module 6: Publishing and Sharing 

  • Introduction to Power BI Service 
  • Publishing Power BI Desktop reports 
  • Content Packages, Security and Introduction to Groups 
  • Printing and exporting dashboards and reports 
  • Quick Insights in Power BI 
  • Creating and Configuring a Dashboard 
  • Sharing Dashboards with Your Institution 

Module 7: Real Project Experience Work 

The Process of Education:

  • The training will be broadcast live simultaneously over the Internet.
  • In order to participate in the training, you must have internet access and a suitable internet package in your current environment.
  • In order for the educational system to be used,camera and microphone equipment have been introduced, a device that can connect to the Internet(smartphone, tablet and preferably computer) is needed.
  • Participants will log in to the system with their cameras and microphones turned on together with our instructor who provides the training during the specified lesson hours.
  • User names and passwords will be sent to the participants' e-mails before the training starts.
  • After the trainings are completed, the system will be kept open for participants for another 7 days. By the end of the seventh day at 23:00, the system will be completely shut down.
  • In order to help us during the training period, a whatsapp group will be created in the form of sending messages only to the administrator, and all kinds of support information will be shared by the administrator during the lesson period. Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.

Important Information:

  • Certificates are issued for participation of 80% and above of the total training period. for participation of 79% and below, no documents will be issued. 
  • After the completion of the training period, certificates will be issued after the controls belonging to our institution and will be sent to the addresses you entered at the time of registration with PTT Cargo. Your address and contact information must be up-to-date.
  • Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.
  • Application for education and paying the tuition fee online are made via the Internet. Installment payments cannot be paid on the participants' bank credit cards.

Comments

You are allow cookie by using us website. ENTER