
Explore the Power BI app family, including desktop for free report authoring, data transformation, and modeling; service for cloud editing and sharing; mobile for on-the-go access; and paginated report builder.
Get started with Power BI by signing up for a free 60-day trial using an organization account. Download Power BI desktop and share reports within your organization.
Load related datasets in Power BI, link customer and district tables via district code and district ID, and view or edit one-to-many relationships in model view.
Replicate the data categorizations from the customer dataset in the district table by defining a primary key and establishing the categorizations.
Explore how to apply conditional formatting to Power BI table visuals, configuring background colors, fonts, icons, and URLs with gradient and value-based rules for region and customer count.
Explore applying filters to Power BI visuals and pages, switching between filters on this visual and filters on the page, with basic and advanced options, top‑N prioritization, and filter clearing.
Learn to create and use a matrix in Power BI, compare it with a table, and explore multi-dimensional analysis with rows, columns, values, and drill-down through region to city.
Learn to format the matrix visualization in Power BI, customizing column and row headers, subtotals, and cell formatting, and master editing interactions to control how visuals filter each other.
Add and configure category and date slicers, explore single and multi-select, clear filters, and choose tile or dropdown layouts to control visuals and interactions in Power BI reports.
Create a chart parameters set (region, state name, city, purpose, gender), convert the slicer to a tile, and bind chart dimensions for interactive drill-down visuals.
Learn how to visualize status changes in Power BI with a funnel chart by mapping status to category and values, showing totals and percentages, and customizing colors by status.
Explore when to use pie charts, doughnut charts, and treemaps to show data proportions across categories. Learn to choose the visualization for many categories by comparing regions, states, and cities.
Create a Power BI loan disbursement dashboard with cards for totals and averages, slicers for date and purpose, top customers table, regional charts, a forecast line, and a pie chart.
Explore how to use the key influencers AI visualizations in Power BI to analyze loan amount by purpose, distinguishing when home loans increase and car loans decrease, with sample metrics.
Explore the Power BI service by accessing workspaces and viewing published reports and datasets. Edit reports, export to PowerPoint, analyze in Excel, and collaborate via Teams.
If you are a working professional, join me in this exciting course on Power BI. It will help you easily analyze and visualize complex data from various sources, and turn it into meaningful insights and reports with a short learning curve.
As of May 2023, I have delivered in-person training to over 2,500 working professionals in skills across office productivity, programming, databases, analytics, and cloud computing, enabling rapid implementation of new skill sets.
Course Curriculum
Data Models and Relationships
Visualizations - Tables, Matrix, Cards
Slicers - Date Hierarchy and Categories
Charts
Navigation and Drill Through
AI Visualizations
Publishing Reports and Dashboards
Mobile Layout
DAX Formulas
Data Transformation
What this course contains
11 Sections with Easy-to-follow instructional videos
4 Assignments
Software and Credentials Required
You will need Power BI Desktop to follow all instructions in this course
A work email address would be required to sign in to Power BI Desktop and Power BI Service.
Without a work email address, you will not be able to publish reports created in Power BI Desktop to the Power BI Service.
Intended Course Outcome
Career growth: Learning Power BI can lead to better job opportunities and career growth, particularly in data analytics, business intelligence, and other related fields.
Competitive advantage: Having Power BI skills can give you a competitive advantage in the job market, particularly in data analytics and business intelligence roles.
Better decision-making: Power BI enables you to analyze data from multiple sources and gain valuable insights, leading to better and more informed decisions.
Improved productivity: With Power BI, you can automate manual data processing and create interactive dashboards and reports quickly, improving productivity.
Data visualization skills: Power BI helps you to create visually appealing charts, graphs, and other visuals, enabling you to communicate data insights effectively.
Data accuracy and consistency: With Power BI, you can ensure that data is accurate and consistent across multiple sources, avoiding errors and discrepancies.