
Explore data analysis with Power BI to aggregate, analyze, visualize, and share data. Build an interactive multi-page dashboard from diverse data sources using Power Query, visuals, and charts.
Download and install Power BI Desktop from the official Power BI website, select the second download option, and install the software, noting that publishing requires Power BI Pro.
Download the Power BI supporting files attached in this section, and access all the files used in this course.
Learn to build an interactive, multipage CMO dashboard in Power BI that tracks brand health, marketing spend, and engagement metrics.
Connect Power BI to data sources by importing an Excel workbook, transform data in the Power Query Editor to fix errors, then apply changes and load the data.
Explore the Power BI interface, create a measures table and a calendar table with year, month, month number, and sorting, and build multi-page dashboards with visuals, backgrounds, and color themes.
Learn to build relationships in model view, manage active and inactive links, and create Dax measures for dashboards, including total sales, units sold, and unique customers.
Create DAX measures with variables to compute percentage changes and handle blanks, then build, format, and display unit sold, sales, and customers visuals updated by slicer selections.
Explore using DAX measures and parameters in Power BI to create dynamic visuals, switching monthly sales, units sold, and customers in one chart with a slicer.
Learn to build an interactive Power BI dashboard by adding slicers, formatting visuals, and creating DAX measures to display counts and percentages across funnel stages.
Create and format multiple Power BI visuals using DAX measures to display sales by payment type, traffic type, source, age group, and gender with dynamic slicer updates.
Create and format multiple Power BI visuals on the second page using DAX measures and slicers, showing monthly traffic and marketing budget vs spend.
Learn to build a multi-page Power BI dashboard by creating DAX measures and adding diverse visuals, including cards, line charts, and clustered charts, with slicers and monthly trends.
Create an interactive multipage HR analytics dashboard in Power BI with three pages: KPI headcount insights, employee expense breakdowns, and detailed workforce dynamics, all updating via linked slicers.
Learn to build a Power BI dashboard by connecting to data sources, transforming data in Power Query Editor, creating a calendar table, and defining relationships across tables.
Create dax measures to compute headcount, exits, new hires, and total employee expense in Power BI, and build visuals illustrating current year versus last year data.
Learn to create dax measures and build Power BI visuals, including cards, donut charts, and clustered column charts, with slicers to analyze headcount, hires, exits, and age groups.
Create measures in DAX and build diverse visuals in Power BI to analyze employee expense by hire type, gender, country, and department, using cards, charts, and a slicer-driven dashboard.
Create measures in DAX and build visuals in Power BI, including donut and stacked bar charts, slicers, and a KPI grouping to analyze exit, separation, gender, department, and country.
Create an interactive supplier quality analysis dashboard in Power BI, featuring a three-page, multi-visual dashboard with KPIs, year-over-year comparisons, and dynamic slicer updates to reveal defects, downtime, and supplier performance.
Import data from an Excel workbook into Power BI, clean it with Power Query Editor, and create a calendar table with relationships and DAX measures for totals and year comparisons.
Create an interactive Power BI dashboard by building cards, column charts, and a matrix, applying DAX measures like total quantity and last year, with defects and supplier quality analysis.
Build an interactive power bi dashboard page with visuals for defects, quantity, and downtime by category; monthly defects; defects by materials and defects type; and year/category slicers.
Add a downtime analysis page with interactive visuals showing downtime minutes by defects type, category, supplier location, materials type, and defects outcome, using area charts and synced slicers.
Apply your new Power BI skills at work to build impressive and dynamic data models, reports and dashboards that help you stand out to top management.
Learn Microsoft Power Bi Data Analysis & Data Visualization - Learn Business Intelligence
This course will provide you the skillset you need to create Dynamic Reports and Interactive Dashboards to analyze and interpret meaningful insights from your any data using a Business Intelligence tool like Microsoft Power BI. We have created content with relevance to real world scenarios
From this course, you will learn how to analyze data based on relevance using Power BI.
Power BI is a business analytics and business intelligence service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. Power BI is part of the Microsoft Power Platform.
Power BI is a collection of software services, apps, and connectors that work together to turn your data from different sources into visually immersive and insightful reports.
Using Power BI Desktop, you can create rich, interactive reports with visual analytics at your fingertips for free. It can connect to more than 65 on-premises and cloud data sources to turn information into interactive visuals. Data scientists and developers work with Power BI Desktop to produce reports and make them available to the Power BI service.
In Power BI Desktop, users can:
Connect to raw data from different sources
Extract, Profile, Clean, Transform and model the data. Build a Relational Data Model using Power Query and DAX
Build and optimize data models and DAX measures
Create charts and graphs using different visualization techniques
Design and create reports and interactive dashboards to get meaningful insights
Analyze hidden trends and patterns
Create and manage datasets
Share reports with others using the Power BI service within or outside the organization
In this course,
You will learn data analysis and data visualization using Power Query, M Language, Dax and Visualizations in Power BI. You will learn about Power BI Desktop and its components. Learn how to use the Power Query Editor to connect Power BI to various data sources, learn how to work on the Data Models to get meaningful insights.
Topics you will Learn
Power Bi DAX
Power Query
Power Bi Charts and Graphs
Build a multi page Supplier Quality Analysis Dashboard in Power Bi
You will learn Power BI in a Step by Step Process
Learn how to use Power BI Desktop and Power BI Query Editor
Learn how to create relationships between related data sources in Power BI
Learn to create Power BI Data Models using the Power Query, M Language and DAX Formula language to create powerful calculations
Learn Power BI DAX and how to use it to build custom Measures
Learn to create Power BI reports with various types of aggregations and filters
Learn to create Powerful Interactive reports and dashboards with drill throughs and relative date filters in Microsoft Power BI
Create a wide range of Power BI Charts, Graphs and Visualizations using drag and drop methods from Data Visualization Tools
Learn how to use themes and custom visualizations in enhance your reports
By the time you complete this course, you'll be a highly proficient Power BI user.
So what are you waiting for?
Let's get started.