Power BI Master Class
Course Overview
In this course, we’ll dive into the art of data transformation and visualization, learning how to leverage Power BI to its full potential. We will focus on enabling you to build dynamic, interactive reports and dashboards that bring your data to life. Through hands-on training, you’ll master techniques for data modeling, creating custom visuals, and performing advanced analytics. This course is designed to help you turn complex datasets into clear, actionable insights, enhancing your decision-making capabilities and streamlining your data presentation.
Rating :
4.7
Reviews :15
Students :283
Available In :EnglishHindi
Updated On :January, 2024
Trainer :Sagar Thorat
Fee :
Find A Batch₹ 13,000
Key Features
- Zero to Hero
- Learn with fun
- Hands-on learning
- Real-world projects
- Easy to follow lessons
- Comprehensive Curriculum
- Certificate of Excellence
- Live online sessions
Who should join?
- Anyone and Everyone: Anyone and Everyone working in non-technical backgrounds seeking to transition into technical roles by acquiring Power BI skills to bridge the gap between their current positions and new technical opportunities
- Power Excel Users: Those who are already working with Excel, Power BI offers advanced capabilities to enhance data analysis and visualization, making it easier to handle and present complex datasets
- Aspirants: Anyone who wants to become Data Engineer, Data Analyst, Power BI Developer, Financial Analyst, Data Scientist, Manager, HR Professional, Consultant, and more
- Experienced Professionals: Working Professionals including Data Engineers, Data Analysts, Financial Analysts, Data Scientists, Managers, HR Professionals, Consultants, MIS Executives, and more
- Students and Graduates: Students and recent graduates can build a strong foundation in data visualization and business intelligence, making them more competitive in the job market
Pre-requisites
- Curious to Learn
- Willingness to Practice
Course content
IMPORTANT: Currently we are re-desiging all our courses and latest syllabus will be available as soon as it is ready.
- 1.Getting Started With Power BI Desktop
- Downloading & Installing Power BI Desktop
- 2.Importing and Transforming Data with Power BI Desktop
- Introduction to Power BI Desktop
- Importing Data From Excel
- Importing Data From Text File
- Importing Data From Access Database
- 3.Modeling with Power BI
- Introduction to Modeling
- Creating Calculated Columns
- Creating Measures & Quick Measures
- 4.Power BI Desktop Visualisations
- Creating Visualisations
- Color Formatting
- Setting Sort Order
- Slicers, Timeline Slicers & Sync Slicers
- Visual, Page and Report Level Filters
- Drill Down/Up
- Hierarchies
- Tables, Matrices & Conditional Formatting
- Map Visualizations
- Custom Visuals
- Drillthrough
- Applying Custom Themes
- Selection Pane, Bookmarks & Buttons
- 5.Publishing and Sharing
- Introduction
- Publish report to Workspace (Power BI Pro)
- Workspaces and Apps (Power BI Pro)
- Row Level Security (Power BI Pro)
- Export Data from a Visualization
- Publishing for Mobile Apps
- Export to PowerPoint
- 6.Refreshing Datasets
- Refreshing Datasets
- Scheduling Data Refresh
- 7.Working With DAX
- Calculate
- Count, Counta, Countblank, Countrows, Distinctcount
- Countif, Sumif, Averageif, Countifs, Sumifs, Averageifs,
- Sum, Average, Max, Min
- Countx, Countax, Sumx, Averagex, Maxx, Minx
- Filter
- Group By
- All, All Except
- Selected Value, Values
- Distint
- Union
- Generage Series
- Calendar
- If, And, Or, Not, Not In, Switch
- SelectColumns
- Error Handling In Dax
- Date, Year, Month, Day, Format, Weekday, Weeknum
- Networkdays, Networdays with holidays
- Rank.EQ, Rankx
- Edate, Eomonth
- Datevalue, Timevalue
- Hasonefilter
- Related, Lookupvalue
- Blank, Isblank, Isempty
- Summarize
- Concatenate, Concatenatex
- Lower, Proper, Upper
- Mid, Left, Right, Find, Len, Substitue, Replace, Pathitem
- 8.Working With Relationships
- Creating Relationship
- Modify / Deleting Relationship
- Creating Relationship On Multiple Columns
- 9.Power BI and Excel Together
- Pin Excel Elements to Power BI