Why Learn Power BI?
Extracting business intelligence rapidly and accurately
It helps in transforming your enterprise data into rich visuals, thus extracting business intelligence for enhanced decision making.
Balanced simplicity and performance
The in-memory analysis technology and DAX scripting language are both exquisite examples of a balance between simplicity and performance. power bi courses in vizag
Rich personalized dashboards
The crowning feature of Power BI is the information dashboards, which can be customized to meet the exact need of any enterprise.
Publish reports securely
The tool helps you to setup automatic data refresh and publish reports allowing all the users to avail the latest information.
No specialized technical support required
Power BI provides agile inquiry and analysis without the need for specialized technical support. It supports a powerful natural language interface. power bi courses in vizag
Interactive Visualizations
Create interactive reports and dashboards with self-service business intelligence capabilities for end users.
Cloud-Based BI Services
Utilize Power BI Services for cloud-based business intelligence along with Power BI Desktop for comprehensive data analysis.
Data Discovery & Preparation
Power BI offers data modelling capabilities including data preparation, data discovery and interactive dashboards for comprehensive analysis. power bi courses in vizag
Curriculum
Introduction to Data Warehousing Concepts
- What is Business Intelligence?
- What are the advantages and applications?
- Phases in BI and tools used in BI
- Data modeling – Different types of data models
- Facts and dimensions and its different types
Introduction to Power BI
- Downloading and installing Power BI
- Power BI Architecture
Data transformations using Power Query Editor
- Text transformations
- Date transformations
- Number transformations
- Grouping, transposing, and unpivoting data
- Adding columns in the power query
- Merge queries
- Data Profiling
Introduction to Power View – Visualization basics
- Familiarize the environment
- An overview of power apps, power automate, dataverse, etc.
- Creating basic charts – columns, bar, pie, map, etc.
- Formatting visuals and report pages
- Data refresh using the power query editor
The Sales dataset
- Understanding the fact and dimension tables
- Loading tables to Power BI Desktop
- Simplifying the data model using append queries
- Creating the date dimension
Hierarchy
- Drill up and drill down
- Creating a hierarchy in the Location data table
Introduction to DAX functions
- Sum, Sumx, and Related Functions
- Creating a measure table
Using Calculate function
- Sameperiodlastyear
- Dateadd
Conditional Formatting
- Applying background color, Font color, databars, icons etc
- Applying conditional formatting to other visuals (bar chart)
Grouping, Edit Interaction, Tooltips and Drill through reports
- Grouping data using the “New Group” option
- Using “Edit Interaction” to control the visuals
- Creating tooltips
- Creating drill-through reports
Using ALLSELECTED, ALL, and IF functions
- Calculating cumulative sales
- Ranking using Rankx function
- What-if Parameters
Filtering reports and adding Custom visuals from AppSource
- Filter Pane – Types and Levels of filters
- Creating a Power BI service account and signing in to the Power BI desktop
- Connecting to Appsource and getting extra visuals
Navigating through the reports
- Creating Bookmarks and using buttons to access bookmarks
- Hiding visuals using the selection pane
- Other buttons
Calculated Columns and Tables
- Calculated Columns
- Calculated columns using logical operators
- Calculated Tables
- Variables
Connecting to database
- Using the import mode
- Using the direct query mode
- Automatic page refreshes in direct query mode
AI in Power BI
- QnA visual
- Key influencers
- Decomposition tree
- Smart narratives
- Performance Analyzers
- Text Analytics
- Image recognition using Power BI – Vision
Analytics Pane
- Adding dynamic reference lines
- Forecasting
Securing Power BI reports
- RLS
- OLS
Publishing and sharing reports using Power BI Service
- Introduction to Power BI Service
- Publishing reports
- Creating dashboard
- Sharing – Share and Subscribe options
- Data refresh using Data Gateways
Previous Post