Power BI Software In Nepal - Dakshyalaya Training Center

Description

Discover the power of data analytics with Power BI. This course equips participants with the skills to analyze data, create interactive reports and dashboards, and derive actionable insights for informed decision-making. Learn to connect to various data sources, transform raw data into meaningful visualizations, and share insights across your organization. With Power BI, unlock the potential of your data and drive business success through informed, data-driven strategies and actions.

What You will Learn?

Introduction to Power BI Desktop: Setup, Getting Started, and Overview of Power BI Features
Data Management in Power BI Desktop: Sources, Importing, Types, Append, Transformations, Joins, Merging, and Data Refresh.
Power BI Data Integration: Connecting Multiple Sources, Text, JSON, XML, Web Data, Transformation Techniques, and M Query Basics.
Connecting to APIs
Advanced Data Transformation in Power BI: Pivot, Unpivot, and Other Advanced Data Manipulation Techniques.
Data Modeling Basics: Relationships - One-to-One, One-to-Many, Many-to-Many.
Database Connection: Access, Oracle, MySQL, SQL Server.
DAX Basics: Calculated Columns, Measures, Navigation, Conditional Functions.
Advanced DAX: Variables, Filter Context Manipulation Techniques.
Advanced DAX functions: CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED
Power BI Desktop Visualization Basics: Branding, Insertions, Reporting.
Power BI Chart Types and Visualization Tools.
Utilizing Power BI Service: Deployment, Sharing, Workspaces, Concepts.
Data Refreshing: Overview, Gateway, Scheduling, Dashboard Process.

Introduction to Power BI Desktop: Setup, Getting Started, and Overview of Power BI Features
- Setting up Power BI Desktop
- Getting Started with Power BI Desktop
- Overview of Power BI
Data Management in Power BI Desktop: Sources, Importing, Types, Append, Transformations, Joins, Merging, and Data Refresh.
- Data Sources in Power BI Desktop
- Importing Excel Workbooks
- Data Types in Power BI Desktop
- Appending Multiple Files
- Transforming Data (Combining Files)
- Joins (Left, Right, Inner, Outer)
- Transforming Data (Merging Queries)
- Refreshing Data
Power BI Data Integration: Connecting Multiple Sources, Text, JSON, XML, Web Data, Transformation Techniques, and M Query Basics.
- Data Connect from Multiple Sources
- Delimited Text Files
- JSON Files
- XML Files
- Connecting to Web Data
- Data Transformation
- Transforming Data (Appending Queries)
- Transforming Data (M Query Basics)
Connecting to APIs
- Connecting to APIs
Advanced Data Transformation in Power BI: Pivot, Unpivot, and Other Advanced Data Manipulation Techniques.
- Pivot Feature in Power BI
- Unpivot Feature in Power BI
- Advance Data Transformation
Data Modeling Basics: Relationships - One-to-One, One-to-Many, Many-to-Many.
- Introduction to Modeling Data
- Data Mapping (Relationship between Tables)
  - One-to-One
  - One-to-Many
  - Many-to-Many
Database Connection: Access, Oracle, MySQL, SQL Server.
- Introduction to Database Connection from Power BI Desktop
- Connecting Access Database
- Connecting Oracle Database (If Available)
- Connecting MySQL Database (If Available)
- Connecting SQL Server Database (If Available)
DAX Basics: Calculated Columns, Measures, Navigation, Conditional Functions.
- Basics of DAX
- Creating Calculated Columns
- Navigation Functions
- Conditional and Logical Functions
- Calculated Tables
- Creating Calculated Measures (Measure Basics)
- Creating Calculated Measures (Time Intelligence Functions)
Advanced DAX: Variables, Filter Context Manipulation Techniques.
- Advanced DAX
- Working with Variables
- Working with Filter Context (What is Filter Context?)
- Working with Filter Context (CALCULATE)
- Working with Filter Context (Overriding Filter Context)
- Working with Filter Context (FILTER)
- Working with Filter Context (FILTER and ALL)
- Working with Filter Context (ALLEXCEPT)
- Working with Filter Context (Totals)
Advanced DAX functions: CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED
- Advanced DAX Function (CONTAINS)
- Advanced DAX Function (FIND)
- Advanced DAX Function (SEARCH and SUBSTITUTE)
- Advanced DAX Function (ALLSELECTED)
Power BI Desktop Visualization Basics: Branding, Insertions, Reporting.
- Introduction to Visualization in Power BI Desktop
- Branding (Size, Header, Spacing, Footer)
- Inserting Images, Shapes, Text Box
- Creating Basic Reports with the Power BI Desktop
- Starting Data Visualization
Power BI Chart Types and Visualization Tools.
- Bar Chart
- Column Chart
- Line Chart
- Area Chart
- Ribbon Chart
- Pie Chart
- Combo Chart
- Bubble Chart
- Scatter Chart
- Donut Chart
- Gauge Chart
- Funnel Chart
- Waterfall Chart
- Single Number Chart
- Multi-Row Chart
- KPI Chart
- Table Chart
- Matrix Chart
- Tree Map
- Slicer
- Map
- Filled Map
Utilizing Power BI Service: Deployment, Sharing, Workspaces, Concepts.
- Using the Power BI Service (Deploying to the Power BI Service)
- Using the Power BI Service (Creating and Sharing Dashboards)
- Using the Power BI Service (Setting Up App Workspaces)
- Using the Power BI Service (Concept of Report, Dashboard, Power Bi App)
- Using the Power BI Service (Concept on Development Environment and Production Environment)
Data Refreshing: Overview, Gateway, Scheduling, Dashboard Process.
- Refreshing Data (Refreshing Data Overview)
- Refreshing Data (Installing Data Gateway)
- Refreshing Data (Scheduling Data Refresh)
- Understanding End-to-End Process for a Power BI Dashboard