| 課程大綱 Syllabus |
學生學習目標
Learning Objectives |
單元學習活動
Learning Activities |
學習成效評量
Evaluation |
備註
Notes |
序
No. | 單元主題
Unit topic |
內容綱要
Content summary |
| 1 | Dashboard Basics & Table Visuals & Using Power BI Desktop to Create a Data Model |
# The Power BI Desktop Window
# View Types, Creating Visuals
# Types of Data, Defining Aggregation
# Working with Tables
# Changing Column Order
# Table Granularity
# Formatting Tables, Field Formatting
$ Data Modeling in the Power BI Desktop Environment
$ Designing a Power BI Desktop Data Model
$ Inhibiting Relationship Autodetection |
#how to
• Switch between dashboards, data tables, and the data model
• Create and modify visuals
• Add and remove data from visuals
• Find fields in a data model
• Activate the Formatting pane where you enhance your visuals
$Establishing relationships between the tables so that Power BI Desktop understands how the data in one table is linked to the data contained in another table |
上機實習
講授
|
期中考
其他評量-Term Prj
|
|
| 2 | Matrix Visuals & Extending the Data Model |
#Creating a Row Matrix, Column Matrix
#Viewing Records
#Displaying Multiple Values As Rows
#Formatting a Matrix
#Column Subtotals
#Sorting Data in Matrices
$Managing Power BI Desktop Data
$Formatting Power BI Desktop Data
$Preparing Data for Dashboards
$Key Columns
$Nullable Fields
$Sorting Data in Power BI Desktop Tables |
#Through the process of creating further text-based visualizations in Power BI Desktop and learn how to create and enhance matrices.
$Learn how to extend the core data model by
• (Re)naming tables and fields
• Specifying data types
• Categorizing data
• Formatting data in the data model
• Adding “sort by”fields that ensure the correct sort order in dashboard elements
• Defining key fields |
上機實習
講授
|
其他評量-Term Prj
|
|
| 3 | Card Visual Types & The Semantic Layer |
#Formatting Cards
#Formatting Multirow Cards
#Sorting Multirow Cards
#Switching Between Visual Types
$Data Model Topologies
$Field and Table Names
$Hiding Tables, Fields
$Display Folders and Subfolders for Measures
$Items in Multiple Folders
$Tables to Contain Measures
$Hierarchies
$Binning and Grouping
$Naming Conventions in the Semantic Model
$Custom Formats
$Data Model Aesthetics |
#Learn how to use
• Cards
• Multirow cards
$Learn how to make the data model
• Easier to use
• More intuitive and immediately comprehensible
• Better able to deliver results faster |
上機實習
講授
|
其他評量-Term Prj
|
|
| 4 | Charts in Power BI Desktop & Calculated Columns |
#Pie charts, Bar charts, Column charts, Line charts, Area charts, Funnel charts, Donut charts
$Types of Calculations
$Calculated Columns
$Concatenating Column Contents
$Renaming Calculated Columns
$Using Table Names in Calculated Columns
$Handling Mistakes
$Simple Calculations
$Cascading Column Calculations |
#Learn how to use
• Pie charts, Bar charts, Column charts, Line charts, Area charts, Funnel charts, Donut charts
$Learn how to augment the existing tables that you have imported by adding new columns containing calculations.
#Can apply the output from these calculated columns to the dashboards that you create using Power Bi Desktop. |
上機實習
講授
|
其他評量-Term Prj
|
|
| 5 | Advanced Chart Types & Formatting Charts & Calculating Across Tables |
#Multiple Chart Formatting
#Specific Chart Formatting
#Trellis Chart Formatting
$Calculating Across Tables
$Cross Filter Direction
$Modifying Cross Filter Direction
$Using Functions in New Columns
$Summarizing for Each Row in a Table |
#Learn how to use
• Scatter charts, Bubble charts, Waterfall charts, Ribbon charts, Dual-axis charts
$Learn how to build on the data model that includes the calculated columns. |
上機實習
講授
|
期中考
其他評量-Term Prj
彈性教學
|
|
| 6 | Other Types of Visuals & DAX Logical Functions |
#Tree maps, Gauges, KPIs, R visuals, Python visuals, Decomposition tree visuals, Key influencers visuals, Paginated reports
$Simple Logic-the IF( ) Function
$Making Good Use of the Formula Bar
$Keyboard Shortcuts in the Formula Bar
$DAX Logical and Information Functions
$Testing for Blank or Empty Values
$Testing for Error Values |
#Learn how to revitalize your dashboards with
• Tree maps, Gauges, KPIs, R visuals, Python visuals, Decomposition tree visuals, Key influencers visuals, Paginated reports
$Learn a few of the core DAX logic functions along with some ideas as to ways they can be used. |
上機實習
講授
|
其他評量-Term Prj
|
|
| 7 | Drill down and Drill up & Date and Time Calculations in Columns |
#Expanding and Drilling Down and Up
#Matrix Drill down
#Including and Excluding Matrix Elements
#Drilling into and Expanding Chart Data Hierarchies
#Including and Excluding Data Points in Charts
$Date Calculations
$Date Elements
$Assembling Usable Dates
$Adding or Subtracting
$Date and Time Formatting |
#For drill down to function correctly:
• The visual must be capable of being drilled into.
• The necessary levels of data must be created.
$Learn how date and time calculations can be applied to calculated columns. |
上機實習
講授
|
期中考
其他評量-Term Prj
彈性教學
|
|
| 8 | Mid. Exam. |
Mid. Exam. |
Mid. Exam. |
|
期中考
|
|
| 9 | Maps in Power BI Desktop & Introduction to Measures |
#Creating Maps in Power BI Desktop
#Using Geographical Data
#Drilling Down in Maps
#Adjusting the Map Display in Power BI Desktop
#Filled Maps, Shape Maps
#Formatting Maps
#ArcGIS Maps
$Basic Aggregations in Measures
$Default Measures
$Measures Are Column-Based Calculations
$Ways to Create Measures
$Modifying Measures
$Field References
$Measure Recalculation |
# Learn how to use four types of map visuals:
• Maps
• Filled maps
• Shape maps
• ArcGIS maps
# Learn how to carete measures and use them |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 10 | Filtering Data & Filtering Measures |
#Filters
#Removing Filters
#Filtering Different Data Types
#Advanced Text Filters
#Specific Visualization-Level Filters
#Page-Level Filters
#Filter Field Reuse
#Using the Filter Hierarchy
$Filtering Data in Measures
$Simple Filters, Boolean (True/False) Filters
$Filtering Dates
$AND/OR Filters in Measures
$NULL (Blank or Empty Cell) Handling
$The Extent of Filtering in CALCULATE( )
$Limits on CALCULATE( ) Filters |
#Power BI Desktop provides two main approaches to assist you in focusing on the key elements of your data:
• Filters
• Slicers
$Learn how to apply explicit filters to measures. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 11 | Slicers and Cross-Filtering & CALCULATE() Modifiers |
#Slicers
#Hierarchical Slicers
#Date Slicers
#Formatting Slicers
#Using Charts As Slicers
#Charts As Complex Slicers
#Specifying Visual Interactions
#What-If Slicers
$Calculating Percentages of Totals
$REMOVEFILTERS( ) Constraints
$Extending the Scope of REMOVEFILTERS( )
$Explicit Measure Filters and Modifiers Cannot Be Overridden
$KEEPFILTERS( ) |
#Put less breathlessly, you can interact with your filtered data in Power BI Desktop reports to subset or isolate metrics.
$Learn how to implicit filters interact with a calculation. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 12 | Enhancing Dashboards & The Filter() Function |
#Formatting Ribbons, Pages
#Aligning and Distributing Visuals
#Adding Text Boxes to Annotate a Report
#Adding Text Boxes to Annotate a Report
#Modifying the Page Background Color
$Filter
$Displaying the Output from a FILTER( )
$Filtering on Measures
$Filter Criteria Inside the FILTER( ) Function
$FILTER( ) Caveats |
#Learn how to
• Align and distribute objects on the report canvas.
• Apply a report background.
• Add basic shapes to enhance your visuals.
• Superpose objects and define how they are placed one on top of
another.
• Prepare reports ready for display on mobile devices.
$Learn how to use FILTER() in a vast array of ways inside a range of other DAX functions. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 13 | Multipage Dashboards & Iterators |
#Multipage Dashboards
#Applying Slicers Across Multiple Pages
#Drill-through
#Drill-through Across Power BI Files
#Page Navigator
#Pop-up Tooltips
$DAX Iterator Functions to Replace Calculated Columns
$Iterator Parameters
$Aggregator and Iterator Functions
$Iterator Functions or Calculated Columns?
$Filtering the Table Input for an Iterator |
# Learn how to
• Add, remove, and rename dashboard pages
• Control how slicers act across dashboard pages
• Drill-through from one dashboard page to another
• Add page navigation buttons
• Create pop-up tooltips
• Create dashboard templates
$Learn how to use the FILTER() function to reduce the scope of calculations. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 14 | Bookmarks and Buttons & Creating and Applying a Date Dimension |
#Bookmarks
#Applying Bookmarks to Selected Visuals
#Bookmark Page Settings
#Grouping Bookmarks
#Slideshows Using Bookmarks
#Buttons
#Formatting Buttons
#Bookmark Navigator
$Why Use a Date Dimension?
$Creating the Date Table
$Extending the Date Dimension
$Elements of Year, Quarter, Month, Week, Day, Date
$Adding Sort by Columns to the Date Table |
#Learn how to shape the dashboard interface to guide the user by controlling the visibility and appearance of visuals on the dashboard page.
#Use Power BI Desktop itself to create a date table. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 15 | DAX Variables & Table Functions |
$Variable Output
$Basic Variable Use, Assignment
$Variables and Intellisense
$Multiple Variables in a Measure
$Variable Reuse Inside a Measure
$Variables in Calculated Columns
$Commenting DAX
$Table Variables in Table Functions
$The SUMMARIZECOLUMNS Function
$Adding Columns to the Output from Table Functions
$Filtering Table Function Output
$Removing Columns
$SELECTCOLUMNS
$INTERSECT, UNION, EXCEPT
$CROSSJOIN( )
$Table Functions |
$Learn how to add variables to DAX.
$Learn how to make heavy use of variables. |
上機實習
講授
|
期末考
其他評量-Term Prj
|
|
| 16 | Final Exam. |
Final Exam. |
Final Exam. |
|
期末考
|
|