Blog

Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing

Posted on December 9, 2018December 10, 2018 by Annie D

Download Zipped Folder with Text Files & Excel File: https://ift.tt/2L8w0is
Download Power BI Desktop FINISHED File: https://ift.tt/2C070XR
Download pdf Notes about Power Query: https://ift.tt/2L657Mh

This video is a comprehensive lesson in Power BI Desktop: Power Query to import data, DAX Formulas and Relationships to complete Data Model, Creating Dashboards, Publishing and Sharing Reports.

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Topics:
1. (00:15) Introduction of what we will do in this video.
2. (02:25) Overview of Excel Power Pivot & Power BI Desktop
3. (02:44) Approximate History of Power BI Desktop :
4. (03:15) Different Versions of Power BI (Different Power BI Products) Available from Microsoft
5. (04:56)Download Power BI Desktop (link to Avi’s video: https://www.youtube.com/watch?v=5Fv-I9xQkcc)
6. (05:43) List of Charts and Visualizations for your Dashboard (Review from prerequisite classes Busn 216 & 218)
7. (06:02) Overriding Steps for our Project
8. (06:27) Open a blank Power BI File
9. (07:04) Introduction to Power BI Window and User Interface
10. (08:32) Power Query to Import Multiple CSV Files and Clean and Transform Data
11. (13:38) Why we do NOT use Number or Date Fields from a Fact Table
12. (15:57) Import Dimension Tables from a Single Excel File
13. (18:09) Merge Snow Flake Dimension Tables into dProduct Table
14. (19:30) Do NOT import to Data Model (Uncheck Enable Load)
15. (20:22) Old Relationship View & New Relationships View with Properties & Better Selection Capability
16. (20:41) Steps to create Date Table using CALENDAR DAX Table Function & Calculated Columns. See many DAX Functions such as CALENDAR, FORMAT and others.
17. (16:10) Sort By Column to get Months to Sort correctly.
18. (27:47) Create Fiscal Periods for Data Table, including Helper Column for Sorting Fiscal Period correctly.
19. (33:12) Hide Columns from Report View
20. (34:00) Create DAX Measures and see why we do not use Implicit Measures.
21. (36:17) SUMX DAX Function
22. (38:15) Row Context (how formula calculates for each row in a table or Iterator Function)
23. (40:12) Filter Context (How Measures Calculate and how Tables are Filtered when Measures Calculate)
24. (41:50) Measure for Average Daily Revenue. Learn about Context Transition. See AVERAGEX Function to iterate at the Daily level.
25. (47:55) Conventions for DAX Formulas with a great tip from Marco Russo and Albetro Ferrari
26. (49:00) More About Filter Context and Context Transition
27. (49:26) Gross Profit Measures
28. (51:48) Refine Data Model in Power Query by Removing Columns in dProduct Table
29. (52:40) Learn about how to Create & Format Visualizations
30. (52:40) Create “Ave Daily GP” Dashboard.
31. (52:40) Create Matrix and add Conditional Formatting
32. (55:29) Create Column Chart and add Conditional Formatting
33. (56:00) Hierarchies
34. (56:52) Drill Down Icons in Power BI
35. (59:09) Create Line Chart
36. (01:00:00) Create Card
37. (01:01:00) Edit Interactions between visualizations
38. (01:02:50) Create “Fiscal Report” Dashboard
39. (01:05:32) Bookmark to save views of a Dashboard
40. (01:06:20) Create “Ave Last 12 Months” Dashboard
41. (01:06:37) DAX Measure for Average Transactional Revenue. See AVERAGEX Function to iterate at the transaction line item level.
42. (01:07:30) Visual of how we change the Filter Context to get dates for a full year backwards.
43. (01:08:25) CALCULATE & DATESINPERID & LASTDATE DAX Functions to calculate Measure for Rolling 12 Month Average for Transaction Level Data.
44. (01:12:08) Create “Question” Dashboard. Learn about Ask A Question feature.
45. (01:13:08) Publish Report to powerbi.com
46. (01:14:15) Edit at powerbi.com
47. (01:14:34) Publish to Web with Free Power BI Desktop version and allow public to review Report
48. (01:16:15)Publish and Share with Power BI Pro Account
49. (01:17:44) Source Data Changes and Refresh
50. (01:18:18) Summary

View on YouTube

Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

Posted on November 17, 2018December 2, 2018 by Annie D

Download Excel START File: https://ift.tt/2FrxeX5
Second Excel Start File: https://ift.tt/2Dtf4Sf
Download Zipped Folder with Text Files: https://ift.tt/2Frxfu7
Download Excel FINISHED File: https://ift.tt/2qSnYkx
Download pdf Notes about Power Query: https://ift.tt/2FrxwgD
Assigned Homework:
Download Excel File with Instructions for Homework: https://ift.tt/2qRom2T
Examples of Finished Homework: https://ift.tt/2Frxgyb

This video teaches everything you need to know about Power Pivot, Data Modeling and building DAX Formulas, including all the gotchas that most Introductory videos do not teach you!!!

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Topics:
(00:15) Introduction & Overview of Topics in Two Hour Video
1. (04:36) Standard PivotTable or Data Model PivotTable?
2. (05:51) Excel Power Pivot & Power BI Desktop?
3. (12:31) Power Query to Extract, Transform and Load Data to Data Model – Get data from Text Files, Relational Database and Excel File.
4. (25:47) Build Relationships
5. (27:43) Introduction to DAX Formulas: Measures & Calculated Columns
6. (29:15) DAX Calculated Column using the DAX Functions, RELATED and ROUND
7. (31:20) Row Context: How DAX Calculated Columns are Calculated: Row Context
8. (33:49) We do not want to use Calculated Column results in PivotTable using Implicit Measures
9. (34:05) DAX Measure to add results from Calculated Column, using DAX SUM Function.
10. (35:29) Number Formatting for DAX Measures
11. (36:35) Data Model PivotTable
12. (39:31) Explicit DAX Formulas rather than Implicit DAX Formulas
13. (41:50) Show Implicit Measures
14. (45:00) Filter Context (First Look) How DAX Measures are Calculated
15. (50:14) Drag Columns from Fact Table or Dimension Table?
16. (53:30) Hiding Columns and Tables from Client Tool
17. (55:52) Use Power Query to Refine Data Model
18. (57:54) SUMX Function (Iterator Function). DAX Measure for Revenue using the SUMX Function to simulate Calculated Columns in DAX Measures
19. (01:01:00) Compare and Contrast Calculated Columns & Measures
20. (01:04:26) Why We Need a Date Table. Why we do NOT use the Automatic Grouping Feature for a Data Model PivotTable
21. (01:06:46) Build an Automatic Date Table in Excel Power Pivot. And then build Relationship.
22. (01:11:00) Introduction to Time Intelligence DAX Functions. See TOTALYTD DAX Function
23. (01:13:47) Introduction to CALCULATE Function: Function that can “see” Data Model and can change the Filter Context. (01:18:00) Also see the ALL and DIVIDE DAX Functions. Create formula for “% of Grand Total”. Also learn about (01:21:30) Context Transition and the Hidden CALCULATE on all Measures.
24. (01:27:18) DAX Formula Benefits.
25. (01:28:00) Example of DAX Formula that is easier to author than if we tried to do it with a Standard Pivot Table or Array Formulas
26. (01:31:50) AVERAGEX Function (Iterator Function) to calculate Average Daily Revenue.
27. (01:34:00) Filter Context (Second Look) AVERAGEX Iterator Function
28. (01:36:16) Build Dashboard. Create multiple DAX Formulas. Create Multiple Data Model PivotTables and a Data Model Chart.
29. (01:38:38) Create Measures for Gross Profit and Gross Profit %
30. (01:41:27) Continue making more Data Model PivotTables.
31. (01:41:50) Make Data Model Pivot Chart.
32. (01:45:10) Conditional Formatting for Data Model PivotTable.
33. (01:46:22) DAX Text Formula for title of Dashboard
34. (01:47:50) CUBE Function to Convert Data Model PivotTable to Excel Spreadsheet Formulas.
35. (01:50:05) Adding New Data and Refreshing.
36. (01:50:40) Update Excel Power Pivot Automatic Date (Calendar) Table. Clue is the blank in the Dimension Table Filter.
37. (01:52:20) How to Double Check that a DAX Formula is yielding the correct answer?
38. (01:53:22) DAX Table Functions. See CALCULATETABLE DAX Function.
39. (01:55:07) DAX Studio to visualize DAX Table Functions, and to efficiently create DAX Formulas
40. (02:00:12) Existing Connections to import data from Data Model into an Excel Sheet
(02:03:15) Summary

View on YouTube

Expert Advise: AI Advisor Tools

Posted on April 26, 2024 by Annie D

Data Mentor offers an extensive range of AI tools covering diverse topics, from code simplification to data strategy, enabling users to learn and solve problems efficiently across various domains.

Details of what you will learn during this video:

– Overview of the AI tools available within Data Mentor
– Explanation of each tool’s functionality and purpose
– Examples demonstrating how to use different AI tools for tasks such as code simplification, data modeling, and project planning
– Insight into how these tools can enhance learning and problem-solving in various domains, including coding, data analysis, and project management

***** Learning with Enterprise DNA *****
FREE Courses – Continue reading “Expert Advise: AI Advisor Tools” →

DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.

Posted on April 26, 2024 by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video03Files.zip Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/03-DAMEMPT.pdf
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin. This video teaches you the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want/.

Topics:
1. (00:00) Introduction
2. (00:26) Free PivotTable Cheat Sheet in workbook file or pdf notes
3. (00:39) Toy sales Data Set
4. (01:21) Why use PivotTables?
5. (01:58) Basics of PivotTables
6. (02:35) PivotTable Cache
7. (04:02) Change Default PivotTable Layout
8. (04:40) PT Calculations: Summarize Values By, Continue reading “DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.” →

Visualize Ideas with AI Tools

Posted on April 25, 2024 by Annie D

An overview of various visualization and analysis tools for code and data, offering insights and explanations to optimize learning and problem-solving efficiency.

Details of what you will learn during this video:

– Advanced visualization and analysis tools for code and data
– Optimization techniques for learning and problem-solving efficiency
– Utilization of diverse tools for code explanation, simplification, and visualization

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial Continue reading “Visualize Ideas with AI Tools” →

DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!

Posted on April 25, 2024 by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/Video01-02Files.zip
Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/01-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video01-02Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about ALL the Microsoft Power Tools: Excel, Power Query, Power Pivot, Data Model, Power BI, Dataflow, Worksheet formulas, Dynamic Spilled Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) Introduction
2. (00:13) List of MS Power Tools taught in video
3. (00:44) Preview of 7 examples
4. (01:48) Why use Worksheet as a data analysis Continue reading “DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!” →

AI Tools Debugging: Quick Fixes

Posted on April 24, 2024 by Annie D

AI tools aiding users in identifying and fixing coding issues, improving code quality and streamlining the debugging process.

Details of what you will learn during this video:

– Overview of five AI debugger tools
– Description of each debugger tool’s functionality
– Explanation of how debugger tools can improve code quality and streamline the debugging process

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Empower Your Content: Creator AI Tools

Posted on April 23, 2024 by Annie D

Overview of diverse tools in the Enterprise DNA suite, offering functionalities from code generation to unit testing, aimed at enhancing data analysis and coding processes.

Details of what you will learn during this video:

– Overview of 32 Enterprise DNA suite tools
– Introduction to tools like code generator, database query writer, and language translator
– Explanation of each tool’s purpose and functionality
– Demonstration of how these tools aid data analysis and coding tasks

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – <a href="https://app.enterprisedna.co/pricing" Continue reading “Empower Your Content: Creator AI Tools” →

Demystifying Data Mentor Pricing

Posted on April 22, 2024 by Annie D

Data Mentor offers various pricing tiers, providing flexibility for users to choose based on their query needs and budget.

Details of what you will learn during this video:

– Explore the pricing tiers available for Data Mentor
– Understand the benefits and features included in each tier
– Learn about the generous free tier and its limitations
– Consider customized plans for teams or enterprise clients
– Gain insights into current promotional offers and sales opportunities

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – <a href="https://app.enterprisedna.co/pricing" Continue reading “Demystifying Data Mentor Pricing” →

Organize Your Data Mentor Account

Posted on April 21, 2024 by Annie D

Access and manage your Data Mentor account for organizing queries, threads, and favorites, with upcoming features like Agents for automated query creation and collaborative learning.

Details of what you will learn during this video:

– Accessing and managing your Data Mentor account
– Organizing queries, threads, and favorites
– Utilizing features like Agents for automated query creation
– Collaborative learning through sharing threads and queries within teams

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Exploring Queries and Threads with Data Mentor

Posted on April 20, 2024 by Annie D

Explore the concept of threads within Data Mentor, demonstrating how they enhance learning by layering queries to delve deeper into specific topics, ultimately building a comprehensive knowledge base for users.

Details of what you will learn during this video:

– Understanding the concept of threads within Data Mentor.
– Learning how threads elevate the learning experience by layering queries.
– Utilizing follow-up prompts and recommendations to expand thread discussions.
– Demonstrating the process of pausing and resuming threads, as well as accessing and sharing thread documents.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA Continue reading “Exploring Queries and Threads with Data Mentor” →

🔴 Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (April 20, 2024) (Member Chat 2nd Half)

Posted on April 19, 2024 by Annie D

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

📢 Become a member: <a Continue reading “🔴 Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (April 20, 2024) (Member Chat 2nd Half)” →

Wait?!? I can’t conditionally format a Line Chart in Power BI?

Posted on April 19, 2024 by Annie D

You have a requirement that your line chart needs to be conditionally formatted. But wait! There’s no option to do that within Power BI? Go to another tool? NOPE! Adam has you covered!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools Continue reading “Wait?!? I can’t conditionally format a Line Chart in Power BI?” →

Data Mentor Mastery: Tips & Tricks

Posted on April 19, 2024 by Annie D

Learn to use Data Mentor efficiently by creating queries, employing AI tools like formula generators and tools advisors, and organizing resources via folders and threads to boost learning and productivity.

Details of what you will learn during this video:

– Creating queries within Data Mentor to obtain on-demand assistance.
– Utilizing different AI tools including formula generators and tools advisors.
– Organizing and managing resources through folders and threads.
– Learning to customize queries for specific tasks and topics.
– Exploring follow-up prompts and additional functionalities for deeper learning and productivity enhancement within the platform.

***** Learning with Enterprise DNA *****
FREE Courses – rel=”nofollow”>https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Share this:

This video teaches everything you need to know about Power Pivot, Data Modeling and building DAX Formulas, including all the gotchas that most Introductory videos do not teach you!!!

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: