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





