Course Introduction
Watch this video to checkout the details and the benefits you get from this training.
Start your career in Microsoft Power BI
This course teaches the fundamentals of Microsoft Power BI for creating interactive reports and dashboards. You will learn how to connect to data, clean and transform it using Power Query, build simple data models, create DAX measures, and design meaningful visualizations. The course also covers report publishing and sharing, helping beginners turn raw data into clear business insights.
By completing this course, you will be able to learn:
- Understand the basics of Microsoft Power BI and its key components
- Connect, clean, and prepare data using Power Query
- Build simple data models and create relationships between tables
- Create basic DAX measures and calculated columns for analysis
- Design interactive reports using charts, tables, KPIs, slicers, and filters
- Build a one-page dashboard to present business insights clearly
-
Publish and share Power BI reports using the Power BI Service
Course Curriculum
- Session Video - Introduction to Microsoft Power BI (87:02)
- Session Video - Power BI Desktop (101:49)
- Session Video - Power BI Query Editor - Merge Query (110:13)
- Session Video - Transform Data Set (105:37)
- Session Video - Excel Visuals (95:09)
- Session Video - Different Kinds of Charts (100:57)
- Session Video - Build Visuals with Data in Power BI (100:01)
- Session Video - Add Data to Your Report - Online Food Delivery (100:23)
- Session Video - Create a Dashboard (116:09)
- Session Video - Concept of Data Modelling (99:55)
- Session Video - DAX Functions (91:53)
- Session Video - Data Cleaning - Data Set (59:44)
- Session Video - Data Set (106:56)
- Session Video - DAX & Other Features (120:52)
- Session Video - DAX Functional (87:51)
- Session Video - Power BI Services (112:42)
- Session Video - Functionalities of Power BI (109:01)
- Session Video - DataSets (135:07)
- Session Video - Dataverse (132:14)
- Assessment - 1. Power BI Foundations & Setup
- Assessment - 2. Data Loading, Cleaning & Transformation (Power Query)
- Assessment - 3. Data Modeling & Core DAX
- Assessment - 4. Visualizations & Report Design
- Assessment - 5. Publishing, Sharing & Power BI Service
- Assessment - 6. Security, Performance & Best Practices + Capstone
- Assignment - 1. Power BI Foundations & Setup
- Assignment - 2. Data Loading, Cleaning & Transformation (Power Query)
- Assignment - 3. Data Modeling & Core DAX
- Assignment - 4. Visualizations & Report Design
- Assignment - 5. Publishing, Sharing & Power BI Service
- Assignment - 6. Security, Performance & Best Practices + Capstone
- Lab Activity - 1. Get started with Power BI Desktop
- Lab Activity - 2. Sample File Overview
- Lab Activity - 3. Use Power Query to transform data
- Lab Activity - 4. Overview of query evaluation and query folding in Power Query
- Lab Activity - 5. Error handling
- Lab Activity - 6. Time intelligence functions
- Lab Activity - 7. Write DAX Formulas For Semantic Models
- Lab Activity - 8. Create DAX calculations in semantic models
- Lab Activity - 9. Use DAX time intelligence functions in Semantic models
- Lab Activity - 10. Create Visual calculations in Power BI Desktop
- Lab Activity - 11. Visualizations overview in Power BI
- Lab Activity - 12. Create report bookmarks in Power BI to share insights and build stories
- Lab Activity - 13. Power BI service basics
- Lab Activity - 14. Publish semantic models and reports from Power BI Desktop
- Lab Activity - 15. Row-level security (RLS) with Power BI
- Assessment - Advanced Analytics in Power BI using R and Python
- Assessment - Data Analysis Expressions (DAX)
- Assessment - Data Visualization
- Assessment - Direct Connectivity
- Assessment - Introduction to Power BI Q_A and Data Insights
- Assessment - Introduction to Power BI
- Assessment - Power BI Desktop
- Assessment - Power BI Report Servers
- Lab Activity - Connect to Data Sources in Power BI Desktop
- Lab Activity - Create a Calculated Column that uses an IF Function
- Lab Activity - Create Calculated Columns in Power BI Desktop
- Lab Activity - Create your own measures in Power BI Desktop
- Lab Activity - Creating a Measure using Power BI DAX
- Lab Activity - Creating R visuals in Power BI
- Lab Activity - Creating visual using Python
- Lab Activity - Dashboard vs. Reports
- Lab Activity - Download Power BI Desktop directly
- Lab Activity - Exploring live connections to data with Power BI
- Lab Activity - Get data from Comma Separated Value (.CSV) files
- Lab Activity - Get data from Power BI Desktop Files
- Lab Activity - Import Power View and Power Pivot to Power BI
- Lab Activity - Install as an App from the Microsoft Store
- Lab Activity - Paginated Reports
- Lab Activity - Power BI Publisher for Excel
- Lab Activity - Programming Power BI datasets with the Tabular Object Model (TOM)
- Lab Activity - Row-level Security
- Lab Activity - Use your measure in another Measure
- Lab Activity - Use your measure in the Report
- Lab Activity - Use your measure with a Slicer
- Lab Activity - Use your New Column in a Report
- Capstone Project - 1. Financial Reporting & Variance Analysis (P&L Dashboard)
- Capstone Project - 2. Healthcare Patient & Operations Dashboard
- Capstone Project - 3. HR Workforce Analytics & Attrition Dashboard
- Capstone Project - 4. Retail Sales Performance & Profitability Dashboard
- Capstone Project - 5. Supply Chain & Logistics Performance Dashboard
Meet Your Instructor
Experience and Expertise: Over 10 years of experience in SAP Finance, business intelligence, SAP Enable Now, and financial reporting, with expertise in Microsoft Power BI, data visualization, and business analytics.
Global Training Experience: Delivered corporate training on SAP Finance, SAP Enable Now, and Microsoft Power BI, helping professionals build interactive dashboards, reports, and data-driven business insights.
Corporate Clientele: Worked with global enterprise clients across finance and SAP implementations, supporting reporting, user enablement, business analytics, and digital transformation initiatives.
Certifications: SAP Certified Application Associate - Financial Accounting with SAP ERP 6.0 EhP7; SAP Certified Application Professional - Financials in SAP S/4HANA for SAP ERP Finance Experts; MBA - Finance & Marketing.
Diverse Technical Skills: Proficient in Microsoft Power BI, SAP FICO, SAP Enable Now, Excel, PowerPoint, Microsoft Visio, data visualization, dashboard development, financial reporting, and business analytics.
Training Methodology: Uses a practical, hands-on approach with real-world reporting scenarios, interactive dashboards, and business use cases to help learners confidently build Power BI reports and visualize data effectively.
Project Leadership: Led SAP Finance, reporting, and user enablement initiatives, developing dashboards, training content, and business intelligence solutions that improved reporting accuracy, user adoption, and operational efficiency.
Got Questions?
Frequently Asked Questions
When does the course start and finish?
The course is entirely self-paced. You decide when you start and when you finish.
How long do I have access to the course?
That depends on the type of Subscription you bought - Monthly or Yearly. After enrolling, you have unlimited access to this course and materials across any devices you own.
What do I get after I signup?
After you signup and make the payment, you will have full access to the course which includes,
1. Session Videos (these videos are from actual live sessions from the past)
2. Assignments
3. Assessments
4. Lab documents
5. Other pdfs (configuration documents, eBooks, pdfs, interview and certification FAQs)
How do I get access to practice on the Server?
Reach out to your Support team and send an email to support@zarantech.com and they will send you the details and the monthly cost for the Server (if available)
Are the videos or materials downloadable?
No, they are not. But you have unlimited access to view them from any device and on this platform depending on your Subscription type. Everything on this platform is the intellectual property of ZaranTech
How soon after I enroll and make payment would get access to the course?
Immediately
What if I have doubts, whom do I ask?
These are pre-recorded videos from the actual Live Training program. Most of the doubts were cleared in the session videos itself. But if you still have any questions, please raise a ticket, and our support team will help you https://zarantech.freshdesk.com/support/tickets/new
What if I have an issue accessing the course?
You can Raise a ticket by clicking the link below and selecting the appropriate ticket - https://zarantech.freshdesk.com/support/tickets/new
How will I get my course completion certificate?
Once you have successfully completed the training and the Final Quiz/Assessment, you can avail of your
Certificate of Completion from ZaranTech which you can then showcase on LinkedIn and other Social Media portals
Do you provide Instructor-led Live training for Individuals?
Yes, we do. Email us at info@zarantech.com and we will send you all the details
How we deliver Live training (video) - https://bit.ly/How-we-deliver-training
Do you provide Corporate/group training?
Yes, we do. We have trained more than 200 Data Science customers with over 4000 participants in the USA, Canada, Europe, Asia, and South America. We offer corporate training for all SAP modules.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 7 days and we will give you a full refund.
What is your Refund Policy and Terms of Use?
To know more about canceling the enrollment, refund, and rescheduling policy, visit:
Refund and Rescheduling Policy – https://www.zarantech.com/Refund-policy/
Terms of Service – https://www.zarantech.com/terms-of-use/
What other Resources do you provide?
YouTube (Free Videos) - https://www.youtube.com/@zarantechdotcom
LinkedIn (Free materials) - https://www.linkedin.com/showcase/sap-learner-community/
