028 3824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

Pro Power BI Desktop

In this course, you will learn how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft’s free self-service business intelligence tool.

Pro Power BI Desktop will help you to push your BI delivery to the next level. You’ll learn to create great-looking visualizations and let your audience have fun by interacting with the elegant and visually arresting output that you can now deliver. You can choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You’ll be able to deliver those results on the PC, on tablets, on smartphones, as well as share results via the cloud. Finally, this course helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. Power BI Desktop will let your analyses speak for themselves.

  • Simple techniques to make data into insight.
  • Polished interactive dashboards to deliver attention-grabbing information.
  • Visually arresting output on multiple devices grab the reader’s attention.

Any users who are comfortable in Microsoft Office. Everyone from CEOs and Business Intelligence developers through to power users and IT managers can attend this course to outshine the competition by producing 21st Century business intelligence visualizations and reporting on a variety of devices from a variety of data sources. All of this is possible through leveraging your existing skill set with the same, common Microsoft tools you already use in your daily work.

At Course Completion

  • Produce designer output to astound your bosses and peers.
  • Share business intelligence in the cloud
  • Deliver visually stunning charts, maps, and tables.
  • Make them interactive tool
  • Find new insights as you chop and tweak your data as never before.
  • Adapt delivery to mobile devices such as phones and tablets.
  1. Introduction to Power BI Desktop
    • The Microsoft Self-service Business Intelligence Solution
    • Installing Power BI Desktop
    • A First Power BI Desktop Daschboard
    • The Data Load Process
    • The Power Desktop Windows
    • Interactivity in Dashboards
    • Creating and Modifying Reports
    • Importing Excel and Power View Items
  2. Discovering and Loading Data with Power BI Desktop
    • Data Sources
    • Loading Data
    • Relational Databases: SQL Server
    • Microsoft SQL Server Analysis
    • Other Data Sources
    • Reusing Recent Data Sources
    • Refreshing Data
    • Connection Security
  3. Transforming Datasets
    • Power BI Desktop Queries
    • Query or Load
    • The Power BI Desktop Query Editor
    • Dataset Shaping
    • Filtering Data
  4. Data Cleansing
    • Viewing a Full Record
    • Power BI Desktop Query Editor Context Menus
    • Grouping Records
  5. Data Mashup
    • The Power BI Desktop View Ribbon
    • Extending Data
    • Duplicating Columns
    • Splitting Columns
    • Merging Columns
    • Custom Columns
    • Index Colums
    • Merging Data
    • Appending Data
    • Changing the Data Structure
    • Managing the Transformation Process
    • Managing Queries
    • Pending Changes
    • Copying Data from Power BI Desktop
  6. Creating a Data Model
    • Data Modeling in the Power BI Desktop Environment
    • Data Model or Query?
    • The Power BI Desktop Data View Ribbons
    • Managing Power BI Desktop Data
    • Preparing Ddata for Dashboards
    • Sorting Data in Power BI Desktop Tables
    • Adding Hierachies
    • Designing a Power BI Desktop Data Model
  7. Extending the Data Model with Calculated Columns
    • Types of Calculations
    • New Columns
    • Concatenating Column Contents
    • Tweaking Text
    • Simple Calculations
    • Calculating Across Tables
    • Cascading Column Calculations
    • Using Functions in New Columns
    • Simple Logic: the IF () Function
    • Making Good Use of the Formula Bar
  8. Adding Measures to the Data Model
    • A First Measure: Number of Cars Sold
    • Basic Aggregations in Measures
    • Using Multiple Measures
    • Cross-Table Measures
    • More Advanced Aggregations
    • Filter Context
    • Filtering Data in Measures
    • Simple Filters
    • More Comples Filters
    • Calculating Percentages of Totals
    • Filtering on Measures
    • Dsplaying Rank
    • A Few Comments and Notes on Using Measures
    • Calculation Options
  9. Analyzing Data Over Time
    • Simple Date Calculations
    • Adding Time Intelligence to a Data Model
    • Creating and Applying a Date Table
    • Applying Time Intelligence
    • Comparisons with Previous Time Periods in Time
    • Rolling Aggregations over a Period of Time
  10. Text-Based Visualizations
    • Power BI Desktop Dashboards
    • Tables
    • Types of Data
    • Enhancing Tables
    • Table Granularity
    • Creating a Matrix
    • Cards
    • Multirow Cards
    • Switching Between Table Types
  11. Charts in Power BI Desktop
    • A First Chart
    • Basic Chart Types
    • Essential Chart Adjustments
    • Donut Charts
    • Funnel Charts
    • Multiple Data Values in Charts
    • 100% Stacked Column and Bar Charts
    • Scatter Charts
    • Bubble Charts
    • Waterfall Charts
    • Dual-Axis Charts
    • Data Details
    • Drill Down
    • Enhancing Charts
    • Bubble Chart Play Axis
  12. Other Types of Visuals
    • Maps
    • Using Geographical Data
    • Adjusting the Map Display in Power BI Desktop
    • Filled Maps
    • Tree Maps
    • Gauges
    • Additional Visuals
    • Loading Custom Visuals
    • A Rapid Overview of a Selection of Custom Visuals
  13. Filtering Data
    • Filters
    • Visual-Level Filters
    • Filtering Different Data Types
    • Advanced Text Filters
    • Specific Visualization-Level Filters
    • Multiple Filters
    • Page-Level Filters
    • Report-Level Filters
    • Removing Filters
    • Using the Filter Hierarchy
    • Filtering Tips
  14. Using Slicers
    • Slicers
    • Formatting Slicers
    • Using Charts As Slicers
    • Charts As Filters
    • Specifying Visual Interactions
    • Choosing the Correct Approach to Interactive Data Selection
  15. Enhancing Dashboards
    • Choosing the Correct Approach to Interactive Data Selection
    • Modifying the Page Background Color
    • Images
    • Adding Shapes
    • Organizing Visuals on the Page
    • Exporting Data from a Visualisation
  16. PowerBI.com
    • Publishing Reports to PowerBI.com
    • Using Power BI Desktop Files in PowerBI.com
    • Interacting with a Report on PowerBI.com
    • Creating PowerBI.com Dashboards
    • Sharing Dashboards
    • Creating New Reports in PowerBI.com
    • The Power BI App on Tablet Devices
    • PowerBI.com Gateways
Các khóa học liên quan
KH 2
KH 3
KH 5