Power BI Training Course Master Microsoft Power BI and transform raw data into actionable insights. This hands-on course covers data analysis, visualization, and interactive dashboards, from basics to advanced topics like DAX, Power Query, and data modeling. Gain the skills to create professional reports and make data-driven decisions with confidence.
“Power BI is suitable for all Audience and can be easily learn”
Key Highlights:
- Hands-on, practical learning with real-world datasets.
- Comprehensive coverage of Power BI features, including Power Query and DAX.
- Develop skills to design interactive dashboards and reports.
- Ideal for professionals in business analysis, data science, or reporting roles.
- No prior experience required, suitable for beginners and intermediate learners.
At STA, we provide multiple assignments to everyone to increase the Hands-on experience
Training Content
Module 1: Power BI Desktop
• Overview of Power BIDesktop
• Data sources and connections in Power BI ( Various different DS connections)
• Connecting to multiple Sources
• Setup and work with Data Model
• Setting up Relationships
• Hide tables / columns in the model
• Working with Filters tab
• Connecting to Power BI Datasets
• Joining / Merge multiple queries
• Data Visualizations (For details please refer data visualization section below)
• Working with Bookmarks, Selection Pane and Sync Slicers
• Create Calculated measures /column
• Setting up Page views and Mobile layout
• Implementing Row Level Security
Module 2: Data Visualizations
• Table & Matrix Usage
• Card and Multicard
• Working with Slicers
• Working with various Chart types (Clustered column chart, line, area etc.,) in Power BI
• Map Visualizations (Bing Map,Map Box)
• Color Palettes in Charts
• Loading Shapes, text boxes, and images
• Custom visuals
• Power BI Q&A
Module 3: Data Analysis Expressions (DAX)
• Table & Matrix Usage
• Card and Multicard
• Working with Slicers
• Working with various Chart types (Clustered column chart, line, area etc.,) in Power BI
• Map Visualizations (Bing Map,Map Box)
• Color Palettes in Charts
• Loading Shapes, text boxes, and images
• Custom visuals
• Power BI Q&A
• DAX tables andFiltering
• DAX queries (Calculate,Filter, Lookup, SUM, SUMX, etc.,)
Module 4: Power Query Editor
• Introduction to Power QueryEditor
• Playing with different transformations for Data Cleanse like below
o Create new / Update existing data.
o Adding Conditional column, Duplicate Column
o Merge / Append Queries
o Pivot / Unpivot
• Adding New columns / New Columns from Examples
• Invoking Custom Functions
Module 5: Power BI Service
• Introduction to Power BIService
• Dashboard vs.Reports
• Creating Dashboards
• Tiles & Notifications
• Working with Workspaces
• Quick Insights
• Working with different options in Power BI Service
• Setting up Data Gateway
• Scheduled datarefresh
