Full Power BI Course (Offline) のアプリ分析 2月20日

Note: - this is not a Microsoft Corporation application. This is just to Learn Power BI. Application content : Power – Introduction & Setup • What is Business Intelligence • What is Power BI and Why Power BI in Data Analysis • Power BI Components • Practical Applications • Downloading Power BI & Adjusting Settings • Types of Data Connectors in Power BI Desktop • Differences Between Microsoft Power BI and SSRS • Power BI Free vs Power BI Pro vs Power BI Premium Power BI – Query Editor • Edit PowerBI App • Query Editor in Power BI for Data Transformation • Working with Numbers in Power BI • Working with Date & Time Tools • Creating a Rolling Calendar in Power BI • Conditional Columns in Power BI • Grouping & Aggregating Records • Merge and Append Queries in Power BI • Manage data source settings and permissions • Data refresh in Power BI • Power BI Data Types • Explain Power BI Hierarchy, and How to Use it • Power BI – Excel Integration Power BI DashBoard and Power BI Visualisation • Power BI – Dashboard • Power BI – Dashboard Actions • Adding Objects to the Power BI Report Canvas and Exploring the “Report” View • Creating Table Relationships & Data Models in Power BI • Inserting Basic Charts & Visuals in Power BI • Conditional Formatting • How to add Reports to Dashboards • Power BI Report Formatting Options • Power BI Report Filtering Options • Exploring Data with Matrix Visuals • Filtering with Date Slicers • Adding Trend Lines & Forecasts • Editing Power BI Report Interactions • Adding Drillthrough Filters • Inserting Text Cards • How to Format a Card? • Format Multi-Row Card • Visualizing Geospatial Data with Maps • How to Format Map • Visualizing Data with Treemaps • Format Tree Map • Managing & Viewing Roles in Power BI Desktop • Creating a Simple Table • Power BI – Format Table Chart • Create a Stacked Column Chart • Power BI – Format Stacked Column Chart • Create a 100% Stacked Column Chart • Format 100% Stacked Bar Chart • Create a Stacked Bar Chart • Power BI – Format Stacked Bar Chart • How to Create a Stacked Area Chart • Power BI – Format Area Chart • Create a Radial Gauge Chart • Create Key Performance Indicators (KPIs) Chart • Power BI – Format KPIs Chart • Format Clustered Bar Chart • Power BI – Format Clustered Bar Chart • How to Create a Waterfall Chart? • Format Waterfall Chart • Create a Filled Map • Format Filled Map • Create a Scatter Chart. • Format Scatter Chart • Showing Trends with Line Charts • Power BI – Format Line Chart • How to Create a Shape Map? • Format Donut Chart • Format Pie Chart • Format Ribbon Chart • Create an R Script Visual • Line and Stacked Column chart • Format Line and Clustered Column Chart DAX Introduction • Data Analysis Expressions (DAX) • Intro to DAX Calculated Columns • Creating measures using DAX • Adding Columns & DAX Measures in Power BI Desktop • Filter Context in Power BI • Common DAX Function Categories • Basic Date & Time Functions • DAX Window Function • Conditional & Logical Functions • DAX Information Functions • DAX Text Functions • Index function in Power BI • DAX Trigonometric Functions • DAX COUPDAY Financial Function • DAX Depreciation Functions • Power BI – Distinct() function • Basic Math in Power BI • Power BI – DAX Trigonometric Functions • COUNT Functions • Power BI – DAX Date Functions • DAX Aggregate Functions in Power BI • Power BI – DAX TEXT Functions • Power BI – DAX Depreciation Functions • Power BI- DAX Bitwise Functions Creating Table Relationships & Data Models in Power BI • What is a “Data Model”? • Principles of Database Normalization • Understanding Data Tables vs. Lookup Tables • Understanding Table Relationships vs. Merged Tables • Creating Table Relationships in Power BI Desktop • Managing & Editing Table Relationships | Power BI • Managing Active vs. Inactive Relationships | Power BI • Connecting Multiple Data Tables in Power BI • Understanding Filters in Power BI • Hiding tables, columns, and fields from Power Pivot and more