CFI – India’s Leading Finance and Analytics Training Institute
CFI’s Program on “Data Visualization using Power BI” prepares you to become a Certified Power BI Professional. The program equips candidates with the skills and insights to thrive in today’s data-driven business landscape. Power-BI program is designed to empower professionals and aspiring analysts with the knowledge and expertise required to extract actionable insights, drive informed decision-making, and propel organizational success.
Whether you are an aspiring Data Analyst eager to enter the field or a seasoned professional looking to upskill, this course is your gateway to mastering the symbiotic relationship between business strategy and data analytics.
Course CurriculumPower BI - Program Curriculum
Working with Name Range: –
- What does naming a cell range mean?
- Rules for naming cells and ranges
- Naming cell range(s) in a worksheet
- Navigating through workbooks using named ranges
- Creating named ranges automatically based on cell values
Numeric/Statistial Functions/ Lookup Function:-
- SUM, SUMIF, SUMIFS
- AVERAGE, AVERAGEIF, AVERAGEIFS
- COUNT, COUNTIF, COUNTA, COUNTBLANK
- MAX, MIN, Vlookup, HLookup
Understanding References
- Understanding References
- Relative References
- Absolute References
- Mixed References
- Utilizing names for writing formulae.
Filtering / Sorting
- Filtering and Sorting
- Concept and Implementation
Logical Functions
- If Function
- AND, OR Function
- Nested Functions
Conditional Formatting
- Create Conditional Formatting
- Rule 1 to 6
Creating Dropdown List
- Simple Dropdown List
- Conditional Dropdown List
Date & Time Functions
- TODAY, NOW
- DAY, MONTH, YEAR
- WEEKDAY
Working with PivotTables Charts
- Creating Pivot Table
- Exploring Table Design Tab
- Slicers
- Creating Chart
- Formatting Chart
- Using AI and ChatGPT in MS Excel -New
Module 1: Understanding Analytics & Business Intelligence (BI) Concept
- Data & Analytics
- Introduction to Business Intelligence
- Importance of Business Intelligence
- Overview of Self-Service BI
Module 2: Microsoft Power BI Introduction
- Power BI introduction and Overview
- Power BI Desktop – Installation
- Explain Power BI Desktop
- Power BI Screen Elements and Toolbars
Module 3: Connecting Power BI with Different Data Source
- Connect to CSV files in Power BI
- Connect to Excel in Power BI
- Connect to PDF in Power BI
- Connect to Web Page in Power BI
Module 4: Data Cleaning with Power Query
- Power Query Introduction
- Query Editor interface
- Column Transformations
- Combining Data: Append Query
- Combining Data: Merge Query
- Number, Date and Time Calculations
- Text Transformation
- Sorting & Filters Data
- Splitting & Merging Data
- Transforms Data
- Pivot and Unpivot Data
- Adding Columns
- M Built-in Function
Module 5: Data Modelling in Power BI
- What is a PowerPivot?
- What Is a Data Model?
- What is a Relationship?
- Introduction to DAX
- Detecting and Creating Relationships of Tables
- Understanding the Star Schema
- Creating Calculated Columns
- Creating Tables
- Creating Measure
- Row Context vs Set Context
- Working with DAX Functions
- Getting Data from Related Tables
Module 6: Creating Report & Visualization Type in Power BI
- Create a New Power BI Report
- Report Editor in Power BI
- Add, Rename, Delete & Duplicate Page to Power BI Report
- Save Report in Power BI
- Change how visuals interact in a report
- Open a Power BI in Reading View
- Page Display Setting in Power BI report
- Type of Visualization in Power BI Report (Bar, Column, Line, Area, Ribbon, Pie, Scatter, Tree Map, Waterfall, Combo, Funnel, KPI, Radial Gauge, Doughnut Chart)
- Data Categories, Geo-Data and Maps
- Creating and Working with Tables and Matrix Views
- Customizing Visuals by Field, Format & Analytic
- Filtering Visual, Page, All Pages
- Using Interactive Slicers – Dropdowns and Searches
- Number, Date, Text Slicers
- Applying Conditional Formats to Visualizations
- Drill Visualizations to see underlying Data
- Date Hierarchies
- Show Values as and Quick Measures
- Custom Visualization in Power BI
- Selection Pane
- Lock Objects
- Adding Graphics
- Bookmarks
- Spotlight
- Report Themes
- Using Security by Creating Role-Based Views
- Insight – Explain Increase/Decrease
- Export Power BI Data to CSV
Module 7: Creating a Power BI Dashboard
- Dashboard vs Reports
- Creating a Power BI Dashboard
- Dashboard Tiles in Power BI
- Pin a Tiles to Power BI Dashboard from a report
- Power BI publisher in Excel
- Data alert in Power BI Service
- Add Image, Text box, Video or web code to your dashboard
- Tips for designing a great Power BI Dashboard
- Create Phone View of a Dashboard
- Power BI Q&A
- Quick Insights with Power BI
Module 8: Refreshing Data
- Configure schedule refresh data
- Refresh a dataset created from Power BI Desktop (Local)
- Refresh a dataset created from Power BI Desktop (Cloud)
- Disable privacy setting
Why CFI Education
CLASSROOM TRAINING
Starts with personalized classroom training (16+ Hrs) with doubt clearing
CASE STUDY APPROACH
Real life cases for most effective and skill based learning.
PASSIONATE EDUCATORS
Highly experienced instructors who bring real business problems to the classroom.
INDIVIDUAL ATTENTION
Focus on building technical expertise and ensure the learning of all candidates.
CAPSTONE PROJECTS
A month long project work post classroom sessions to gain confidence in their domain area.
24*7 SUPPORT
Support for helping and enhancing student learning experience.
Top Hiring Companies for this Program
Latest Blog
Data Analytics Certification: How a Excel VBA Program Can Land Your Dream Job?
Data Analytics Jobs: 9 Career Options You Can Explore
5 Data Aggregations You Can’t Live Without
