Microsoft Power BI - Business Data Analysis and Visualization with Power BI

Become an expert in Microsoft Power BI

About The Course

This course will enable trainees to transition from any career background to become business data analysts in any organization in the world. They will be able to transform data into meaningful visuals, create dashboards, and forecast sales, design business models like weekly sales report, profit report and sales comparative charts, explore hidden insights and make meaningful business decisions. During this training, you would work on different industry standard projects.

How Participant will be Benefited

One of the main reasons why Microsoft Power BI stands as the most preferred data visualization tools is that there are several options in terms of connectivity, starting from Databases, Spreadsheets, and even Big Data. It is equipped with a Web Data connector and used to pull API directly from the web to connect data sources. It supports fact-based and logical decision making by analyzing historical data rather than assumptions. Hence, most of the firms are taking the help of BI tools to visualize the data. As companies are switching to these tools, demand for Power BI skilled professionals is automatically increasing.

Methodology

  • Face to face interactive class
  • Practical Case Studies 

Contact Us

  • +88 01733405068
  • support@icdb.info
  • Ka-7/ A (4th Floor), Jagannathpur Super Market, Bashundhara R/A Main Road

Who Can Attend?

This course is very useful for anyone who works with data. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.

Certification & Duration

  • Certificate: Yes 
  • Course Duration: 18 Hours

Course Content

Chapter 01 : Introduction of Power BI

  • Business Intelligence & Data Visualization
  • Why Choose Power BI?
  • What is Power BI?
  • Key Benefits Power BI
  • Components of Power BI
  • Architecture of Power BI
  • Building Blocks of Power BI
  • Visualizations
  • Datasets
  • Reports
  • Dashboards

Chapter 03 : Introduction to Power BI Desktop

  • Power BI Charts
  • Bar Charts & Column Charts
  • Line Charts & Area Charts
  • Combination Charts & Ribbon Charts
  • Pie Charts, Doughnut Charts & Tree Maps
  • Maps on Power BI
  • Funnel Charts
  • Gauge & Cards
  • Tables & Matrices
  • Map in Power BI
  • Card, Slicer & Filter

Chapter 05: Enhance Reports for data storytelling

  • How to choose right theme in Power BI
  • How to Align visual elements
  • Insert Button
  • Insert Text , Shape
  • Apply Page Navigation for dynamic presentation
  • Use Advanced chart in Power BI
  • Map visual for Power BI

Chapter 07: Data Modeling

  • Single-direction relationships
  • Bidirectional relationships
  • Fact tables, Dimension tables
  • Introduce Star Schema and Snowflake Schema

Chapter 02 : Using Power BI

  • Getting Started with Power BI
  • Install Power BI Desktop
  • Import Data
  • Create & Modify a Simple Visual
  • Save & Publish Report
  • Joining Data Sources
  • Update & Publish report

Chapter 04 : Clean and modify datasets by Power Query

  • Handle with null and unnecessary value
  • Introduce Join Query
  • Apply Splitting and Extract for hazy data
  • Creating Conditional Group
  • Find summary from a large dataset
  • Use basic Mathematical Operation
  • Apply Text Function

Chapter 06: Perform Advanced Analysis

  • Introduce Data Analysis Expression (DAX)
  • Using basic table functions
  • Apply Logical Function
  • Understanding CALCULATE and CALCULATETABLE
  • Time intelligence calculations
  • Understanding evaluation contexts
  • Understanding Logical contexts

Chapter 08 : The Power BI Sharing

  • Publish desktop to web
  • How to create an account in Power BI Service
  • Data Refresh
  • Managing the On-premises Data Gateway
  • Sharing dashboard
  • Build an effective dashboard
 
Contact us
+88 01733405068
E-mail: support@icdb.info
Institute of Career Development, Bangladesh – ICDB