Online and Face-to-Face Power BI Training
Embark on your journey to mastering Power BI with our comprehensive training program, led by the esteemed instructor, Ambarishan. Whether you prefer the flexibility of online learning or the interactive experience of face-to-face sessions, our program offers the best of both worlds. Over the course of 3 or 5 days, you'll dive deep into Power BI's features and functionalities, gaining practical skills and insights to excel in data analytics. With Ambarishan's expert guidance, you'll learn how to leverage Power BI effectively, empowering you to drive data-driven decisions and achieve your business objectives. Join us for an immersive learning experience and take your Power BI skills to new heights.
Why Should You Attend Our Training?
The course was developed by a globally recognized Power BI expert.
Gain online access to training video content for convenient revision and practice sessions at your own pace.
Join live online Q&A sessions with a Power BI expert every two weeks for a full year.
Who Should Attend Our Power BI Training?
Our Power BI training is ideal for anyone seeking to enhance their data analytics skills and unlock the full potential of Power BI. Whether you're a beginner looking to build a strong foundation in data visualization or an experienced professional aiming to refine your expertise, our training caters to individuals of all skill levels. Business analysts, data scientists, IT professionals, and decision-makers alike will benefit from our comprehensive curriculum designed to empower participants with the knowledge and tools needed to succeed in the dynamic world of data analytics.
- Business Analysts
- Data Analysts
- Data Scientists
- Business Intelligence Professionals
- IT Professionals
- Decision Makers
- Managers
- Project Managers
- Database Administrators
- Finance Professionals
- Students
- Marketing Analysts
- Sales Analysts
- Operations Managers
- Consultants
- Entrepreneurs
- Anyone interested in data analytics and visualization
Power BI training is applicable across diverse industries, including:
Master Power BI With the Right Guidance From Certified Experts
Ambarishan Purushothaman
Ambarishan offers personalized Power BI training programs, catering to diverse skill levels. With his expertise, he guides learners from basics to advanced techniques, providing practical insights and continuous support to unlock their full potential in data analytics.
Training Course Content
This comprehensive training course caters to beginners and self-taught individuals seeking to fill gaps in their Power BI knowledge. Explore the fundamentals of Power BI, including data importing, formula writing for insights extraction, and creation of innovative data visualizations. Gain invaluable skills to effectively share your data insights with relevant stakeholders. The course is structured into three modules for an in-depth learning experience (expand the sections below for details).
-
Module-1
Introduction to Power BI
Introduction
Overview of Power BI
Connecting to Software as Services
Power BI Community
Hands-on -
Module-2
Connecting to Data Source
Connecting to file system (Excel, CSV etc)
Connecting to data on Web
Connecting to On-Prem Databases (SQL, Oracle etc)
Connecting to Cloud DB (Azure, Snowflake etc)
Troubleshooting while connecting with data sources
Hands-on -
Module-3
Transforming Data using Power BI Desktop
Introduction to Power BI Desktop
Connecting to a Database
Basic Transformations
Managing Query Groups
M Queries
Splitting Columns
Changing Data Types
Working with Dates
Removing and Reordering Columns
Conditional Columns
Connecting to Files in a Folder
Merge Queries
Query Dependency View
Transforming Less Structured Data
Enter Data
Query Parameters
Hands-on -
Module-4
Data Modelling in Power BI Desktop
Managing Data Relationships
Creating Calculated Columns
Optimizing Models for Reporting
Creating Calculated Measures
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence
Manually Typing in a Data Table
Include / Exclude
Grouping / Binning
Hands-on -
Module-5
DAX: Data Analysis Expression
Aggregate Functions
Date & Time Functions
Filter Functions
Logical Functions
Relationship Functions
Text Functions
Time Intelligence Functions
Hands-on -
Module-6
Visualizing Data
Pie and Donut chart
Bar Chart with Line (Combo Chart)
Analytics Pane
Slicer
Focus Mode and See Data
Date Slicer
Map Visualizations
Table and Matrix
Table Styles
Scatter Chart
Waterfall
Gauge, Card, and KPI
Colouring Charts
Shapes, Textboxes, and Images
Gridlines and Snap to Grid
Working with Multiple Visualizations
Page Layout and Formatting
Visual Relationship
Duplicate Page
Categories with No Data
Default Summarization and Categorization
Positioning, Aligning, and Sorting Visuals
Custom Hierarchies
Hands-on -
Module-7
Working with Power BI Service
Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Configuring a Dashboard
Featured and Favorite Dashboard
Dashboard Settings
Natural Language Queries
Sharing a Dashboard
In-Focus Mode
Printing Dashboard and Exporting Data
Export to CSV and Excel
Data Gateway
Power BI Report Server
Hands-on -
Module-8
Apps, Security and Groups - Working with Others
Creating an App
Using an App
Editing an App
Row Level Security
Hands-on -
Module-9
In-Class Project
Tips and Tricks to build amazing reports
Building our In Class Project
