Download Excel & pdf Files: https:\/\/ift.tt\/2tiUtJK
\nThis video introduces the topics that will be covered in this Highline College BI 348 Class:
\nName of Class:
\nBI 348 \u2013 Microsoft Power Tools for Data Analysis:
\n\u2022 Power Query
\n\u2022 Power Pivot
\n\u2022 DAX
\n\u2022 Power BI Desktop
\n\u2022 Excel
\nFor Creating:
\n\u2022 Data Models, Reports, Dashboards and Analytics
\nTaught by Mike excelisfun Girvin, Excel MVP 2013-2018
\n\u2022 A class about connecting to multiple source of data, transforming the data into a refreshable & dynamic data model, and building reports and dashboards to provide insightful and actionable information.<\/p>\n

Prerequisites for this class:
\n\u2022 Busn 216: Excel Basics, https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
\n\u2022 Busn 218: Advanced Excel, https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
\n\u2022 Busn 210: Business Statistics, https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj<\/p>\n

What Version of Power BI Desktop:
\n\u2022 Free Tool we will download (update each month)<\/p>\n

Over View of Topics for the class:
\n1. Data Analysis \/ Business Intelligence terms and concepts that we will learn in this class:
\n\u2022 Proper Data Set
\n\u2022 Fact Table
\n\u2022 Dimension Tables
\n\u2022 Relationships
\n\u2022 Star Schema
\n\u2022 ETL
\n\u2022 Measures
\n\u2022 Dashboards
\n\u2022 SQL
\n\u2022 Data Warehousing
\n\u2003
\n2. Learn how to use Excel Power Query:
\n\u2022 Import Data from multiple sources
\n\u2022 Clean and Transform Data
\n\u2022 Create Data Components for Star Schema Data Models
\n\u2022 Load Data To Excel, the Data Model and Connection Only
\n\u2022 Replace Complicated Excel Solutions with Power Query Solution
\n\u2022 Use the Power query User Interface to create Power Query Solutions
\n\u2022 Learn about the Case Sensitive, Function-based M Code Language that is behind the scenes in Power Query
\n3. Learn how to use Excel Power Pivot:
\n\u2022 Excel Power Pivot provides:
\ni. Data Model where we can have multiple tables, formulas and relationships (Star Schema)
\nii. Columnar Database to hold “Big Data” and process quickly over that “Big Data”
\niii. New Formula Language called DAX:
\n1. Many More Calculations than in Standard PivotTable
\n2. Build One Formula that can work in many reports
\n3. Add Number Formatting to Formulas
\n\u2022 Excel Power Pivot to:
\ni. Replace VLOOKUP Formulas and Single Flat PivotTable Data Source with Multiple Tables, Relationships in the Data Model to create more efficient Reports & Dashboards
\nii. Use Power Pivot Columnar Database to hold millions of rows of data
\niii. DAX formulas have more Power than Standard PivotTable Calculations
\n4. Learn about Building Star Schema Data Models:
\na. Why they are important in Power Pivot and Power BI Desktop
\nb. How to build them using:
\ni. Power Query
\nii. Power Pivot
\niii. DAX
\niv. Power BI Desktop
\n5. Learn how to author DAX Formulas for Excel\u2019s Power Pivot & Power BI Desktop:
\na. Calculated Column Formulas for Data Model
\nb. Measure Formulas for PivotTables
\nc. DAX Functions like SUMX, CALCULATE, RELATED, and Much More\u2026
\nd. Lean why we must create Explicit rather than Implicit formulas
\ne. Learn how Row Context works in formulas
\nf. Learn how Filter Context works in formulas
\ng. Learn about Scalar & Table Functions
\nh. Use DAX Studio to visualize and analyze DAX Formulas
\n6. Learn how to use Power BI Desktop:
\na. Power Query to import, clean, transform and create Star Schema Data Models
\nb. Create Relationships
\nc. Create DAX Formulas
\nd. Build Interactive Visualizations
\ne. Build Dashboards
\n\u2003
\n7. Learn how to use Excel:
\n\u2022 Spreadsheet Formulas & Functions
\n\u2022 Standard PivotTables
\n\u2022 Power Query
\n\u2022 Power Pivot
\n\u2022 Build Data Model PivotTables and the resultant Reports, Dashboards and Analytics
\n8. Building Refreshable, Insightful Dashboards
\na. Build Excel Dashboards
\nb. Build Power BI Dashboards
\n9. Case Studies to practice using Power Pivot & Power BI Desktop for Reporting, Building Dashboards and Building Business Analytics Solutions<\/p>\n