Q&A session - My Power BI report is slow, what should I do?
This will be a live Q&A session - A private link to the recorded video with the same topic from SQLBI will be shared a few days before the event on the Persian Power BI LinkedIn page (https://bit.ly/32tGkif). After that, you can watch the video and start submitting your questions for this live Q&A session. To do so, prepare related questions and post them on the pigeonhole page set up for this event. Open https://pigeonhole.at/ and use PERSIAN as a password to submit your questions. More details about the video and Q&A session: https://www.sqlbi.com/blog/marco/2021/02/05/testing-sqlbi-live-qa/ 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞: English 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RLLearn M language (Power Query) from the UI
Power Query is a fabulous tool for cleansing and then loading data into Power BI and Excel. The UI is excellent and it lets you do almost everything you can imagine just by clicking on the menu options. Yet under the hood of Power Query is a very powerful functional language called “M”. There is now Intellisense that supports the M language in the UI, but you can also learn a lot about how the language works by using the UI to teach you. In this session Matt will introduce the basics of the M language and demonstrate concepts on how to learn more as you write you queries. 𝙈𝙚𝙚𝙩𝙞𝙣𝙜 𝙡𝙞𝙣𝙠(𝙈𝙎 𝙏𝙚𝙖𝙢𝙨): https://bit.ly/3PU7EsW 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: EnglishPower BI Development Best Practices
In this session, Soheil will show you some Power BI development and design best practices, covering topics such as Power Query, Data Modeling, DAX, Data Visualization, Star schema, Data Type, and Relationships,... 𝙈𝙚𝙚𝙩𝙞𝙣𝙜 𝙡𝙞𝙣𝙠(𝙈𝙎 𝙏𝙚𝙖𝙢𝙨): https://bit.ly/3CYM4A8 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiPower BI Development Best Practices - Part 2
Here is the video of the first part of this session, which was held on 20-Oct-22: https://youtu.be/ocDT_GFOvoE In this session, Soheil will show you some Power BI development and design best practices, covering topics such as Power Query, Data Modeling, DAX, Data Visualization, Star schema, Data Type, and Relationships,... 𝙈𝙚𝙚𝙩𝙞𝙣𝙜 𝙡𝙞𝙣𝙠(𝙈𝙎 𝙏𝙚𝙖𝙢𝙨): https://bit.ly/3CYM4A8 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiMy favorite hidden tricks in Power BI
In this session, Helen will show you her favorite Power BI tricks. Helen is a LinkedIn instructor for Microsoft Power BI, Excel, Python, R, AWS, for more details check out her LinkedIn profile: https://www.linkedin.com/in/helenrmwall/ Language: English 𝙈𝙚𝙚𝙩𝙞𝙣𝙜 𝙡𝙞𝙣𝙠(𝙈𝙎 𝙏𝙚𝙖𝙢𝙨): https://bit.ly/3CYM4A8 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RLPower BI Date Dimension: How to create it?
Are you using a dataset in Power BI that contains date fields which you need to use for analysis and creating reports? You need to use a Date Dimension in your model. A date dimension is an essential table in a data model that allows us to analyze performance more effectively across different time periods. It should be included in every dimensional model that contains a date or requires date intelligence as part of the analysis. In this session Shahab will introduce dim date and the necessity of using it and will explain how to create a dimension table in Power BI using different methods, including M Power Query, SQL script, DAX, Bravo Extension, and even the new tool ChatGPT. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiPower Query Tips and Tricks: What You May Not Know
Are you a Power Query user looking to level up your skills? Join us for this session where we'll dive into some of the lesser-known Power Query tips and tricks. We'll start with an introduction to Power Query and then cover some specific tips, including table projection, referencing middle steps in other queries, solving the problem of repeat function names, cheating in using functions, dealing with two or more headers, and converting Persian number characters to their normal equivalents. We'll also show you how to solve one of Excel BI's challenges using Power Query. Whether you're a beginner or an experienced user, you'll leave this session with a deeper understanding of Power Query's capabilities and how to use them to streamline your data cleaning and analysis workflows. Don't miss out on this opportunity to learn from our experts and take your Power Query skills to the next level. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiPower Query Tips and Tricks: What You May Not Know - Part 2
The second part of Mahmoud's Power Query Tips and Tricks series. Are you a Power Query user looking to level up your skills? Join us for this session where we'll dive into some of the lesser-known Power Query tips and tricks. We'll start with an introduction to Power Query and then cover some specific tips, including table projection, referencing middle steps in other queries, solving the problem of repeat function names, cheating in using functions, dealing with two or more headers, and converting Persian number characters to their normal equivalents. We'll also show you how to solve one of Excel BI's challenges using Power Query. Whether you're a beginner or an experienced user, you'll leave this session with a deeper understanding of Power Query's capabilities and how to use them to streamline your data cleaning and analysis workflows. Don't miss out on this opportunity to learn from our experts and take your Power Query skills to the next level. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiLevel-Up your Power Query game with Custom Functions
Functions are one of the fundamental building blocks of Power Query. In addition to the native ones, we can create our own so that we don't have to write everything repeatedly. Custom functions can be one of your best friends for making your work easier in Power Query. But you need to be able to create them and set the input parameters, including whether they are mandatory or optional. But once we create the function, it doesn't end there! To pass the function to someone or not forget what it does, it is good to know how to add documentation metadata that will be displayed in the preview of the function and used for quick understanding. Start building custom functions and advance your Power Query capabilities. About Speaker: A data lover, especially in the ecosystem of Microsoft tools. I primarily focus on Power BI, Azure Synapse, Azure SQL Microsoft Fabric. In general, I follow a very simple motto (is in Headline). He is a co-founder and a Lead Technical Consultant at DataBrothers.Power BI experts and consultants with a focus on data analysis, reporting, and training in Power BI. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: EnglishTips for Defining Custom Functions in Power Query
Despite the wide variety of functions available in Power Query, sometimes it is necessary to define new custom functions for specific needs, especially in complex data cleansing processes. Online training enables you to become familiar with how to create functions that precisely match your specific conditions and requirements. Defining these specialized functions helps you to clean and prepare your data in a much more accurate and flexible manner, facilitating the optimization of your workflows. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - Persian-Farsi
