Master in Microsoft Power BI Desktop and Service [Video]
- FREE Subscription Read for free
- $17.99 Video Buy
- $12.99 Video + Subscription Buy
-
What do you get with a Packt Subscription?
- Instant access to this title and 7,500+ eBooks & Videos
- Constantly updated with 100+ new titles each month
- Breadth and depth in over 1,000+ technologies
-
Free ChapterBusiness Intelligence Concepts and Introduction
-
Connecting Power BI with Different Data Sources
-
Power Query for Data Transformation
-
Power BI Data Modeling – Relationship View and PowerPivot
-
Data Analysis Expression (DAX)
- Introduction to Data Analysis Expression (DAX)
- Creating Calculated Columns, Creating Measures
- DAX Date and Time Functions
- DAX Text Functions
- DAX Logical Functions
- DAX Related Function
- DAX Implicit Versus Explicit Measures
- DAX Statistical Functions
- DAX Filter Functions
- DAX X-factor Functions
- DAX Time Intelligence Functions
- DAX Rank Functions
- New Table and Quick Measure
-
Reports and Visualization Types in Power BI
- Introduction to Reports and Visualization Types in Power BI
- Page Settings
- Getting started with color formatting and axis properties
- Customize Visualization and X-axis and Y-axis properties
- Filters in Power BI
- Slicers in Power BI
- Table and Matrix
- Conditional Formatting on Visuals
- Card and Multi-Row Card
- Treemap
- Combo Chart
- Line chart, Area chart, and Stacked area chart
- Gauge chart
- KPI
- Drill through
- Map and Filled map
- Pie chart and Doughnut charts
- Ribbon charts
- Waterfall Chart
- Funnel chart
- Import Data model to Power BI desktop
- Phone layout
- Bookmark
-
Power BI Publishing - Reports
- Comparing Power BI Desktop and Power BI Service
- Sign in to Power BI
- Power BI Service walkthrough
- Publishing a report from Power BI Desktop to Power BI Service
- Create a Dashboard in Power BI Service
- Power BI Service Workspace UI
- Edit a Report in Power BI Service
- Power BI Report - Reading View
- Power BI Report - Usage Metrics
- Analyze in Excel
- Power BI Report - Quick Insights
- Dashboard Walkthrough
- Adding Tile in Dashboard
- Q and A
- Dataset Settings
- Get More Visuals
- Row-Level Security with Power BI
Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive dashboards and visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves without having to depend on anyone else, as Power BI’s artificial intelligence is there to help you out. Power BI provides cloud-based BI services, known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers data modeling capabilities along with data preparation, data discovery, and interactive dashboards.
In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services. You’ll start with learning how to connect Power BI to different data sources. Then you’ll be able to transform your data using Power Query and create data models.
After this, you’ll also level up your data analysis skills using DAX and create calculated columns and measures. With the help of reports and visualization in Power BI, you’ll be able to present your data in an efficient and interactive way. And lastly, you’ll learn how to publish your reports and dashboards to the Power BI online service.
By the end of this course, you’ll be able to excel at your career as a business intelligence and data analyst professional.
The resource files are updated on GitHub at https://github.com/PacktPublishing/Master-in-Microsoft-Power-BI-Desktop-and-Service
- Publication date:
- May 2021
- Publisher
- Packt
- Duration
- 7 hours 15 minutes
- ISBN
- 9781801819961