Power BI
In this course, we will guide you through the comprehensive landscape of Power BI, starting from the basics and gradually progressing to advanced techniques. Whether you’re a beginner seeking to grasp the fundamentals or an experienced user aiming to refine your skills, this course is tailored to meet your learning needs.
Our journey begins with an exploration of Power BI’s intuitive interface, where you’ll learn to connect to various data sources, transform and clean your data, and create visually compelling reports and dashboards. We’ll dive into the world of data modeling, helping you understand how to design robust data models that lay the foundation for meaningful analysis.
As we advance, we’ll delve into DAX (Data Analysis Expressions), a powerful formula language used in Power BI, enabling you to create sophisticated calculations and metrics. You’ll discover how to leverage Power BI’s capabilities to derive insights, make data-driven decisions, and present your findings in a compelling and accessible manner.
Throughout the course, hands-on exercises and real-world scenarios will reinforce your learning, ensuring that you gain practical skills that can be immediately applied in professional settings. Whether you’re a business analyst, data professional, or decision-maker, the Power BI Syllabus Course aims to equip you with the knowledge and proficiency to navigate the world of business intelligence confidently.
Get ready to transform your data into actionable intelligence, visualize trends, and uncover hidden insights. Join us on this journey, and let’s unlock the full potential of Power BI together.
Power BI Syllabus
- Module 1: Introduction to Power BI (Duration-5hrs)
Get Started with Power BI
Overview: Power BI concepts
Sign up for Power BI
Overview: Power BI data sources
Connect to a SaaS solution
Upload a local CSV file
Connect to Excel data that can be refreshed
Connect to a sample
Create a Report with Visualizations
Explore the Power BI portal
Module 2: Viz and Tiles (Duration-5hrs)
Overview: Visualizations
Using visualizations
Create a new report
Create and arrange visualizations
Format a visualization
Create chart visualizations
Use text, map, and gauge visualizations and save a report
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
Download and use a custom visual from the gallery
Module 3: Reports and Dashboards (Duration-10hrs)
Modify and Print a Report
Rename and delete report pages
Add a filter to a page or report
Set visualization interactions
Print a report page
Send a report to PowerPoint
Create a Dashboard
Create and manage dashboards
Pin a report tile to a dashboard
Pin a live report page to a dashboard
Pin a tile from another dashboard
Pin an Excel element to a dashboard
Manage pinned elements in Excel
Add a tile to a dashboard
Build a dashboard with Quick Insights
Set a Featured (default) dashboard
Ask Questions about Your Data
Ask a question with Power BI Q&A
Tweak your dataset for Q&A
Enable Cortana for Power BI
Module 4: Publishing Workbooks and Workspace (Duration-5hrs)
Share Data with Colleagues and Others
Publish a report to the web
Manage published reports
Share a dashboard
Create an app workspace and add users
Use an app workspace
Publish an app
Create a QR code to share a tile
Embed a report in SharePoint Online
Module 5: Other Power BI Components and Table Relationship (Duration-5hrs)
Use Power BI Mobile Apps
Get Power BI for mobile
View reports and dashboards in the iPad app
Use workspaces in the mobile app
Sharing from Power BI Mobile
Use Power BI Desktop
Install and launch Power BI Desktop
Get data
Reduce data
Transform data
Relate tables
Get Power BI Desktop data with the Power BI service
Export a report from Power BI service to Desktop
Module 6: DAX functions (Duration-5hrs)
New Dax functions
Date and time functions
Time intelligence functions
Filter functions
Information functions
Logical functions
Math & trig functions
Parent and child functions
Text functions