Curriculum:
- Introduction to Visualization
- Why Business Intelligence
- Introduction to Power BI
- Power BI Architecture
- Components of Power BI
- Power BI Flow
- Introduction of Power BI Desktop
- Power BI Licensing (Free vs Pro vs Premium)
- Power BI Desktop Installation
- Power BI Desktop User Interface and Views
- Types of Data Sources in Power BI
- Data Loading Modes and Advantages
- First Row Header
- Duplicate Columns
- Split Columns
- Remove Duplicate/Columns
- Replace Value
- Change Data Type
- Group BY
- Pivot and Unpivot
- Formatting data
- Add Custom Columns
- Invoke Function
- Append Queries
- Join Merge Queries
- Combine Files (Folder)
- Parameters
- Other Query Features
- Components of Data Modeling
- Introduction to Data Models
- Data Model Engine
- Types of Data Model (Flat, Star & Snowflake)
- Granularity of Data & multiple fact tables
- Data Modeling Relationships
- One to One
- One to Many
- Many to Many
- Roll Playing Tables
- Sorting/Renaming/Hiding Tables
- Hierarchy Creation
- Formatting & Data Category
- Grouping / Binning
- Drill Through Reports
- What IF Parameter
- Designer Options
- Power BI Visualization Types
- Custom Visualization
- Best Practices
- Choosing Colors
- Types of Charts and Usage
- Slicers / Filters
- Creating Complete Visualization Report (Practical)
- Continue Creating Complete Visualization Report (Practical)
- Story Telling with the created Report
- Bookmarks / Selection Pane
- Spotlight
- Drill Through
- Additional Features
- Publishing / Deploying Reports
- Apps Workspace & Roles
- Creating Dashboard
- Q&A
- Quick Insights
- Dashboard Options
- Subscription
- Alerts
- Export Options (Embed, Web, Power Point…etc.)
- Excel Integration
- Row Level Security
- Data Refresh Concept
- Gateway and Installation
- Power BI Mobile Service
- Power BI Admins Roles
- Audit Logs
- Introduction DAX
- DAX Data Types
- Calculated Columns
- Calculated Tables
- Calculated Measures
- Calculated Columns vs Measures
- Aggregated Functions (SUM, MIN, MAX, AVG, COUNT)
- Relate Functions (RELATED & RELATED TABLE)
- Iterative Functions (SUMX, AVGX, COUNTX)
- Variables (VAR)
- Logical functions (AND, OR, IF, SWITCH)
- Table Functions (VALUES, FILTER, CALCUILATETABLE)
- FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, UNION, ROW, ADDCOLUMNS, SUMMARIZE
- Handling Blanks (ISBLANK, NOTISBLANK)
- Rank Functions (RANKX)
- CALCULATE (ALL, ALLEXCEPT, ALLSELECTED)
- Understand Row & Table level Filter Context
- Date Functions (DATEADD, DATEDIFF, TODAY Required Date Formats)
- Calendar Functions (CALENDAR, CALENDAT AUTO)
- Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
- SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)
- Project 1
- Project 2
Fee:
Online Virtual Class Room
Enroll in any above batch and attend live class at scheduled time
9000Upcoming Batches:
FAQ:
1. Who can learn this course?
Anyone who is interested and having prior computer knowledge can learn Power BI.
2. What are the prerequisites for this course?
No prerequisite as such, if you have computer knowledge you can learn Power BI.
3. What are career opportunities from this course?
You can apply for jobs like Power BI Developer, BI Developer, BI Architecture after covering this course.
4. How long this course will take?
This course will take 25 hours practical live class. After that you can practice as much as you can.
5. Will you provide soft copy material?
Yes, we will share the Power Point soft copy material and we will provide recording of our live classes
6. I am working on Microsoft Excel can I learn Power BI to enhance my skills?
Yes, you can learn, and it will be added advantage to enhance your career as a Developer.
7. I don’t have any technical education; can I apply for this course?
Yes, this is more on GUI interface and easy to lean. No technical background is required.
8. Will you start this course from scratch?
Yes. We will start this course from scratch.
9. Do you provide a license for Power BI Service?
Yes, we do provide 2 months trail Pro License to practice and explore all the Power BI Service
10. Do you provide projects to work on?
Yes, after completion of course you will to work on 2 or 3 projects to work. It will hand on experience to clear the interviews confidently.
Recommended Courses:
Recommended courses
Core Python
Data Science with Python
Big Data Hadoop Certification
Data Analyst
Reviews:
Jun-03-2024
