Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Excel Zipped Folder with all files (including pdf notes): https://excelisfun.net/files/MECS04DownloadFiles.zip Free YouTube Excel & Data Analysis class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3 Download Power BI Desktop: https://www.microsoft.com/en-us/download/details.aspx?id=58494 In this video learn about. Topics: 1. (00:00) Introduction 2. (00:26) Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard. 3. (02:46) What is a Columnar Database? 4. (04:18) Idea behind DAX Revenue Formula (Measure) 5. (05:56) Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop 6. (10:41) Build DAX Date Table 7. (15:37) Row Context in DAX Calculated Columns and DAX Iterator Functions 8. (20:50) Hide Fields in Report View 9. (22:15) Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions 10. (29:24) One-Step DAX Revenue Measure using SUMX DAX function 11. (31:28) Compare One-Step and Two-Step Measures. Which is better? 12. (34:33) Create four Remaining Measures in Report View 13. (37:24) What is Gross Profit? Two Measures for Gross Profit. 14. (42:00) Create Two Power BI Reports, including Map Report 15. (44:30) Map Visual 16. (46:00) Conclusion 17. (46:25) Closing and Video Links Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese. Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish. #excel #excelisfun #groupby #dataanalysis #Sort #filter #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #sql #sqldatabase #sqldata #powerbi #powerbidax #powerbi_training #powerbidesktop #powerbidashboard #bigdata