تفاصيل الدورة
About the Course:
Power BI is a powerful tool that enables businesses to harness the full potential of Business Intelligence (BI). In today’s fast-paced environment, businesses generate massive amounts of customer transactions and data that are impossible to analyze manually in a short amount of time. As a result, organizations increasingly rely on technology for accurate data extraction, analysis, and presentation to guide strategic decisions.
Power BI meets this need by providing… + المزيد
تفاصيل الدورة
About the Course:
Power BI is a powerful tool that enables businesses to harness the full potential of Business Intelligence (BI). In today’s fast-paced environment, businesses generate massive amounts of customer transactions and data that are impossible to analyze manually in a short amount of time. As a result, organizations increasingly rely on technology for accurate data extraction, analysis, and presentation to guide strategic decisions.
Power BI meets this need by providing robust tools for the extraction, analysis, transformation, and visualization of data. It empowers businesses to make insightful decisions that drive future strategies and foster informed decision-making.
Duration: 2 Days (8 Hours Per Day)
Course Objective:
Data Extraction
Data Transformation
Data Loading
Data Modelling
Data Analysis Expressions
Data Analysis
Data Visualization
Data Driven Decisions.
Data Publishing
Learning Outcome:
To Know about various Methods of Extracting data.
Learn Various tools and Methods for data Cleaning and Data Transformation.
Understand How to create relationship with different sources of data
Learn how to create data Analysis Function for preparing Reports.
Learn to Analysis various ways of Data Analysis
Learn to prepare Dashboards and Different types of visuals for effective decision Making
SCOPE
Data Analyst
Business Analyst
Course Outline:
Module 1:
Concept of Data Analysis
Concept of Business Intelligence.
Introduction to Power Bi
Power Bi Architecture
Power Bi Components
Installing Power Bi Desktop.
Module 2:
Extract/Connect Data
Getting data from Flat Files
Getting Data from open Data Feeds
Getting Data from Folder
Difference between Transform and Load Data
Module 3:
Power query Editor
Data Transformation
Data Formatting and Extraction
Formatting by Add Column
Merge, Add & Remove Columns in Power Query
Sorting in Power query
Merge and Append query
Transform Table Tools
Text Column Tools
Number Column Tools
Module 4:
Power Query Editor Advanced Options
Building a complete Calendar Table
Conditional Custom & Invoke Custom
Flash fill in Power Query (Columns from example)
Understanding different view options
Connect to multiple files in a folder
Column Profiling in Power query Editor
Module 5:
Data Modelling in Power Bi
How to build relationship and relationship cardinality
Understanding filter flow & Cross Filter direction
Building entire model
Snowflake & Star schema
Add Related table
Module 6: DAX –
Data Analysis Expressions
Understanding DAX and its Types
Difference between calculated columns and measures
Logical DAX
Another example of conditional column
Understanding SWITCH function
Understanding Year and Today function
Playing with Text functions (Left and Search)
Most Common used DAX Measures
DAX Iterators
Date & Time DAX
Module 7:
Report Setup in Power Bi Desktop
Understanding Report view and creating a new report
Page display settings in a Power BI report
Setting color theme aligned to project/company color theme & Theme Gallery
Adding non-visualization object
Inserting Basic charts and understanding format tab
Creating Comparison visuals (Doughnut Chart)
Creating Bar chart for Top 5 Customers
Geographical Visualization
Understanding Matrix visual along with Conditional Formatting
Comparing Actual vs. Target using Gauge Chart
Slicing and Dicing in Reports
Module 8:
Advanced Visualization/Custom Visualization Options
Showing monthly trend with line chart
Setting up forecasted revenue in line chart
Presenting data in an Area chart with awesome tooltip feature
Building amazing KPI's
Drill through Report Page
Custom visual (third party visual)
Story telling through Bookmarks
Ask questions from PBI and get visuals (NLQ)
Module 9:
Publishing Report & Advanced Report Options
What if Parameter
Setting RLS (Row Level Security)
Tooltip Page
Different types of filters in report view
Change how visuals interact in a report
Publishing Reports
Importing Report to Power Point
Module 10:
Power Bi Project for Pro Training Analaysis.
تحديث بتاريخ 11 February, 2025 - أقل