课程详情

The course provides a comprehensive overview of Microsoft Power BI and how to use it for data analysis, creating interactive reports, and visualizations that support business decision-making. The lessons cover learning how to create various charts such as Column Charts, Line Charts, and Pie Charts, in addition to using filters and cards to display data in a customized way. The course also delves into advanced performance analysis tools like KPI and Decomposition Tree, explaining how to tailor Power BI to suit different user roles, such as data analysts and developers.You will learn: Lesson 1: Introduction to Microsoft Power BI- What is Power BI: Power BI is a business analytics service that delivers insights to enable fast, informed decisions. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.- Power BI Framework: The Microsoft Power BI framework consists of three major components: Power BI Desktop, Power BI Service (cloud-based), and Power BI Mobile (for phones and tablets). Together, they provide a comprehensive set of tools for data analysis, visualization, and reporting.- The Parts of Power BI: Power BI is made up of various parts like Power BI Desktop, Power BI Service, Power BI Mobile, and Power BI Gateway (for on-premises data sources).- HowMicrosoft Power BI matches your role: Microsoft Power BI is versatile, offering tools for business users, report creators, developers, and administrators. Depending on your role, you may use it for reporting, monitoring, analysis, or administration.Lesson 2: Roles in Power BI- Power BI for business users: Business users can consume reports and dashboards shared with them and use Power BI Service to interact with the data.- Power BI Desktop for report creators: Report creators use Power BI Desktop to design, develop, and publish reports and dashboards.- Power BI Report Builder for enterprise report creators: Report Builder is used for creating paginated reports-detailed reports that can span multiple pages.- Power BI for administrators: Administrators manage Power BI deployment, monitor system health, and govern data access.- Power BI for developers: Developers use APIs to integrate Power BI capabilities into custom applications, automate workflows, or extend its functionality.Lesson 3: Install Power BI- System Requirements: Basic requirements include Windows 10/11, 2GB memory (8GB recommended), and a.NET Framework.- Install Microsoft Power BI Desktop: Step-by-step process to download and install Power BI Desktop from the Microsoft website.- Sign in to Microsoft Power BI Desktop: How to sign in with your work or school account.- Launching Microsoft Power BI Desktop: How to launch and configure Power BI Desktop for first-time use.- Exploring the Microsoft Power BI Desktop Interface: Introduction to the Power BI interface, including report, data, and model views.Lesson 4: Column Charts in Power BI Desktop- Stacked Bar Chart: Displays data in horizontal bars where each bar segment represents a part of the whole.- Stacked Column Chart: Similar to a stacked bar chart but uses vertical columns.- Clustered Column Chart: Groups related data side-by-side in vertical columns.- 100% Stacked Bar Chart: A bar chart where each bar represents 100% of the data, split into parts.- 100% Stacked Column Chart: A column chart where each column represents 100% of the data, segmented.Lesson 5: Line and Area Charts in Power BI Desktop- Line Chart: Displays trends over time using a line.- Area Chart: Similar to a line chart but with the area under the line filled in to emphasize volume.- Stacked Area Chart: Shows multiple data series stacked on top of each other in an area format.- 100% Stacked Area Chart: Represents the area of each data series as 100% of the total value.- Line & Stacked Column Chart: Combines line and stacked column charts in one view.- Line & Clustered Column Chart: Combines a line chart with a clustered column chart.Lesson 6: Pie, Donut, Scatter, Funnel, Waterfall & Ribbon Charts- Pie Chart: Displays parts of a whole as slices of a pie.- Donut Chart: A variant of a pie chart with a hole in the middle.- Scatter Chart: Plots data points based on two variables, showing the relationship between them.- Funnel Chart: Visualizes stages in a process, with each stage shown as a proportion of the whole.- Waterfall Chart: Shows a running total as values are added or subtracted.- Ribbon Chart: Visualizes rankings of categories over time, with ribbons indicating rank changes.Lesson 7: TreeMap, Map, and Filled Map- TreeMap Chart: Displays hierarchical data using nested rectangles.- Map Chart: Plots data points on a geographic map.- Filled Map Chart: Similar to a map chart but with regions filled based on data values.Lesson 8: Cards and Filters- Card (Number, Text, Date): Displays single values like sums, averages, or other key numbers.- Multi-row Card: Displays multiple rows of summarized data.- Filters (Visual, Page, All Pages): Filters data at different levels-specific visuals, entire pages, or across all pages in a report.Lesson 9: Card (new)- Card (new): Likely focuses on a new feature or update to the card visual in Microsoft Power BI.Lesson 10: Slicers in Power BI- Number Slicer: Filters data based on a range of numerical values.- Text Slicer: Filters data based on text values.- Date Slicer: Filters data based on date ranges.- Format: Options for formatting slicers for a more user-friendly interface.Lesson 11: Slicers (new)- Traditional Slicer: The basic slicer used to filter data.- Slicer (new): Introduces updated slicer functionalities or new types of slicers.Lesson 12: Performance Charts in Power BI- Gauge Chart: Visualizes performance against a target, using a dial format.- KPI Chart: Displays Key Performance Indicators (KPIs) to track progress toward goals.- Key Influencers: A machine learning visual in Power BI that identifies the key drivers behind specific outcomes.Lesson 13: Table and Matrix- Creating a Simple Table: Introduction to creating a basic table in Power BI.- Formatting in Table: How to apply basic and advanced formatting to tables.- Conditional Formatting in Table: Adds dynamic formatting based on data conditions.- Changing Aggregation in Table: How to change the aggregation (sum, average, etc.) of values.- Creating a Matrix in Power BI: A pivot-table-like visual that organizes data into a grid.- Automatic Hierarchy in Matrix: Automatically organizes data hierarchically within the matrix.- Subtotal and Grand Total: How to display subtotal and grand total rows/columns.- Number Formatting (Table and Matrix): Formatting numbers in tables and matrices for better readability.- Decomposition Tree: Visualizes data breakdown across various dimensions and levels.Lesson 14: Advanced Charts in Microsoft Power BI- Animated Bar Chart Race: Displays bar charts in a dynamic race format over time.- Drill Down Donut Chart: Allows users to drill down into different layers of data in a donut chart.- Drill Down Column Chart: A column chart with drill-down capabilities.- Word Cloud: Visualizes the frequency of words in a dataset.- Sankey Chart: Displays flows between categories using weighted lines.- Infographic: A highly visual chart that combines graphics and data.- Play Axis: Adds an animated axis to visuals that changes over time.- Scoller: Likely refers to a scrolling chart or visual component.- Sunburst Chart: Displays hierarchical data in a radial layout with segments representing categories.

课程标签

0人关注该课程

主题相关的课程