- Видео 70
- Просмотров 180 111
HOGOLYTICS
Австралия
Добавлен 12 окт 2022
Welcome to HOGOLYTICS, your ultimate destination for all things Power BI! Whether you're a seasoned data analyst or just starting your journey into the world of business intelligence, our channel is your go-to resource for informative, engaging, and practical content about Power BI.
🔍 What You'll Find Here:
🎥 Tutorials: Dive deep into our step-by-step tutorials that cover everything from Power BI basics to advanced techniques. Whether you're learning to create your first report or want to master DAX formulas, we've got you covered.
📈 Tips and Tricks: Unlock the secrets of efficient data visualization, report design, and data modeling with our insightful tips and tricks. Enhance your Power BI skills and make your reports stand out.
🤝 Connect With Us:
Follow us on social media and join the conversation. We love hearing from our viewers and are here to assist you in your Power BI endeavours.
💼 Subscribe today and let's embark on a data-driven journey together!
🔍 What You'll Find Here:
🎥 Tutorials: Dive deep into our step-by-step tutorials that cover everything from Power BI basics to advanced techniques. Whether you're learning to create your first report or want to master DAX formulas, we've got you covered.
📈 Tips and Tricks: Unlock the secrets of efficient data visualization, report design, and data modeling with our insightful tips and tricks. Enhance your Power BI skills and make your reports stand out.
🤝 Connect With Us:
Follow us on social media and join the conversation. We love hearing from our viewers and are here to assist you in your Power BI endeavours.
💼 Subscribe today and let's embark on a data-driven journey together!
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 2
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 2
Do you have an interview about Power BI and worry about DAX questions? This video helps you to cover the most common questions.
Act like a pro!
I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports
You can find more business intelligence tutorials blow:
Please read articles on: www.hogolytics.com
Follow me on LinkedIn: www.LinkedIn.com/in/sh-hogo
Follow me on Instagram: dr.shahab.hoghooghi
#dataanalytics #powerbi #dimdate...
Do you have an interview about Power BI and worry about DAX questions? This video helps you to cover the most common questions.
Act like a pro!
I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports
You can find more business intelligence tutorials blow:
Please read articles on: www.hogolytics.com
Follow me on LinkedIn: www.LinkedIn.com/in/sh-hogo
Follow me on Instagram: dr.shahab.hoghooghi
#dataanalytics #powerbi #dimdate...
Просмотров: 165
Видео
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 1
Просмотров 1803 месяца назад
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 1 Do you have an interview about Power BI and worry about DAX questions? This video helps you to cover the most common questions. Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, ...
Dashboard Design Best Practices - Dos and Don'ts!
Просмотров 1593 месяца назад
Dashboard Design Best Practices - Dos and Don'ts! This presentation provides you the fundamental knowledge about dashboard design. Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power BI serv...
Top 5 DAX Functions that you have to know!!
Просмотров 3086 месяцев назад
Top 5 DAX Functions that you have to know!! Do you like to learn Power BI? These 5 functions are essentials for all Power BI developers. Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power B...
How to Look up a value in Excel? use VLOOKUP & HLOOKUP
Просмотров 817 месяцев назад
How to Look up a value in Excel? use VLOOKUP & HLOOKUP Unlock the power of Excel with our comprehensive tutorial on VLOOKUP and HLOOKUP functions! Learn how to efficiently search for and retrieve data within your spreadsheets, whether you're working with vertical or horizontal data structures. Master these essential Excel tools to save time and streamline your data analysis workflows. Watch our...
How to use Inactive relationship in measures? USERELATIONSHIP is the function you need!
Просмотров 2197 месяцев назад
How to use Inactive relationship in measures? USERELATIONSHIP is the function you need! Have you ever tried to use different calculations based on two different relationships between two tables? You need to know how to make a disabled relationship active! Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial ...
Excel Referencing: Absolute, Relative or Mixed?
Просмотров 827 месяцев назад
Excel Referencing: Absolute, Relative or Mixed? Understand the importance of referencing cells accurately in Excel formulas. If your formulas aren't functioning properly when copied to other cells, chances are there's an error in your cell referencing. Different cell references require varying degrees of fixing-some need to be fully fixed while others partially. This distinction is known as abs...
How to Calculate Year To Date & Financial Year To Date?
Просмотров 3417 месяцев назад
How to Calculate Year To Date & Financial Year To Date? Calculating YTD and FYTD are one of the fundamentals that all analysts need to apply in their report. Watch this video to learn how you can easily use it. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different traini...
Everything about New Button Slicer - Part 2
Просмотров 1067 месяцев назад
Everything about New Button Slicer - Part 1 How to use New Button Slicer like web designs. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business in...
Everything about New Button Slicer - Part 1
Просмотров 1,1 тыс.8 месяцев назад
Everything about New Button Slicer - Part 1 How to use New Button Slicer like web designs. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business in...
How to Replace BLANK values in Power BI?
Просмотров 2,3 тыс.11 месяцев назад
How to Replace BLANK values in Power BI? You can easily replace blankd values with any other values like zero "0" or Unknown. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic re...
How to Organize measures and Columns in Power BI? Create Folders and Subfolders!
Просмотров 882Год назад
How to Organize measures and Columns in Power BI? Create Folders and Subfolders. You can easily create folders and subfolders within your dataset and organize all your measures and columns. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI deskto...
How to Create a Column From Examples without M Power Query?
Просмотров 160Год назад
How to Create a Column From Examples without M Power Query? You can easily use a few examples to handle it. Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Po...
How to use ChatGPT to create a Dim Date (Calendar) Table using DAX in Power BI?
Просмотров 171Год назад
How to use ChatGPT to create a Dim Date (Calendar) Table using DAX in Power BI? ChatGPT is an AI tool that supports you to create DAX tables without any effort. In this video you will learn how resolve the probable issues. Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! In this channel you will learn Power BI Tutorial for Beginners t...
How to create Dim Date (Calendar) Table using DAX in Power BI?
Просмотров 2,4 тыс.Год назад
How to create Dim Date (Calendar) Table using DAX in Power BI? Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! In this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business i...
How to Get Monthly Data From SharePoint Folder into Power BI?
Просмотров 899Год назад
How to Get Monthly Data From SharePoint Folder into Power BI?
AUTOMATE your Monthly Data in Power BI - Get Data From Folder
Просмотров 1,7 тыс.Год назад
AUTOMATE your Monthly Data in Power BI - Get Data From Folder
How to refresh Power BI Dataset Incrementally? Incremental Refresh helps you to improve performance!
Просмотров 941Год назад
How to refresh Power BI Dataset Incrementally? Incremental Refresh helps you to improve performance!
How to Use Valid Date Range Slicer and Remove Extra Date in Power BI?
Просмотров 1,5 тыс.Год назад
How to Use Valid Date Range Slicer and Remove Extra Date in Power BI?
How to Send Dynamic Email to users in Power BI table?
Просмотров 3,6 тыс.Год назад
How to Send Dynamic Email to users in Power BI table?
Your Flows Fail? Change Power Automate Settings in Power BI?
Просмотров 733Год назад
Your Flows Fail? Change Power Automate Settings in Power BI?
How to Send Power BI table data as CSV file to Email? Use Power Automate!
Просмотров 26 тыс.Год назад
How to Send Power BI table data as CSV file to Email? Use Power Automate!
پادکست دیتامن - قسمت سوم - آشنایی با SQL
Просмотров 107Год назад
پادکست دیتامن - قسمت سوم - آشنایی با SQL
How to Change Power BI Theme Color in Less than 10 Seconds!
Просмотров 2,6 тыс.Год назад
How to Change Power BI Theme Color in Less than 10 Seconds!
How to solve Query folding Issue for Data coming from AWS Athena through ODBC connection?
Просмотров 679Год назад
How to solve Query folding Issue for Data coming from AWS Athena through ODBC connection?
پادکست دیتامن - قسمت دوم - مهمان برنامه: وحید دوستی مجد
Просмотров 214Год назад
پادکست دیتامن - قسمت دوم - مهمان برنامه: وحید دوستی مجد
Okay - you made this so much simpler than anyone else I've looked at! Amazing job - thank you so much. Favourited and subscribed :D
Is there a way to avoid pressing reload this page?
Thanks for making such video. It helped me a lot. This is one of the most effective use-case of Power Automate.
We have multiple ways to refresh a report. My question is , which refresh is fast
a power bi dashboard with 2 table visuals, now i would like to sent the 2 tables as excel sheets in single excel csv file through outbox using power automate. is it possible?
You need to add another steps the same as the first table for the next ones, before the last step sending to email.
.JSON extension theme not working when apply theme in power bi can you provide steps
Great video. I have an error on send to email (v2) Input parameter email message/to is required to be of type string/email
You need add one more day in Duration: Duration.Days(End_of_Year - Start_Date) + 1, or you are one day less in the end, missing 12/31. Am I right?
Great!
Hi Do you have an example extracting in excel?
You are awsome.. I have been trying since a while but it didn't worked...and by your videos I have created these buttons thank you
Works very fine here, thank you bro!
Hello, thank you for uploading the video, it was extremely helpful. could you please send me a link for the additional columns in the dim date table?
Great video - works perfectly for me but finding the PA won't run for others?
Thanks for the tutorial, but is it possible to send a visualized table to email without the button so it's automatically sent to specific emails?
Thanks Shahab, Please upload more videos about interview sessions for Power bi and Data Analyst, especially the metrics which are used to evaluate the candidates.
Thanks Sahar, sure. Will upload more.
Gracias
Gracias :)
Thanks alot
what if the data is from a sharepoint list? the button on the report is not refreshing after i update the sharepoint.
Thank you!
Hello sir, thanks for the video. I noted that the box that contained the last refresh time didn’t change. Do you know how to fix that?
درود بر شما با تشکراکسلی دارم شامل حروف سال به فارسی مثلا 1390 که بخشی از آنها با فونت انگلیسی هستند و بخشی با فونت فارسی. بخشی که فونت انگلیسی است به راحتی در Power Query خوانده می شود اما آن بخشی که فونت فارسی دارد Error می دهد. راهکار چیست؟ با تشکرReza Amini
Hi Reza, thanks for your comment. Unfortunately I haven’t used Farsi font in Power BI. I used Power BI in English version. Don’t have any idea about your issue.
Very nice and useful.
Thanks for your comment
this seems sketchy 😂
Thanks
Thanks you for your sharing! however my data table over 1000 row, It's send email within 1000 row. could you please help to share for that in case data table >1000 row :)
How can we get original theme back?
I thought the keywords RangeStart and RangeEnd were used for incremental refresh.
Same issue I am getting when I am getting the data from API through ODBC can it be done through it?
let Source = Odbc.DataSource("dsn=TestDWH_Appointment", [HierarchicalNavigation=true]), DATA_Schema = Source{[Name="DATA",Kind="Schema"]}[Data], result_View = DATA_Schema{[Name="result",Kind="View"]}[Data], #"Filtered Rows" = Table.SelectRows(result_View, each [appointmentDate] >= RangeStart and [appointmentDate] <= RangeEnd) in #"Filtered Rows" Sir this is my code i can see native query till Navigation but when i filter it do not show
Can you export a matrix table data as csv?
I'm getting error as below when triggering manully and when go back to the report the run option is not enabled. can some suggest on this. please ' The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.
I was getting the same error. Make sure you hit save and apply once you have fixed your error. Then go back to the report and run the Data Flow.
This is EXACTLY what I've been trying to do for days. You sir, are a GENIUS!
@@pmo4325 Thanks and happy it was helpful for you
What if you don't want a button? How would you handle a monthly set day of month refresh since Power BI doesn't allow this? I want to just use refresh dataset from power automate, and then schedule it on 7th day of the month
Thank You Sir!
Thank you so much for this video. I was able to achieve what I was looking for.
The flow is working and I am getting the output as expected, the only issue is I am getting multiple emails after triggering the flow.
Did you resolved? Because I have the same issue, actually I need to send to different emails depends of the filter and the mail duplicates depending of the result 😔😔
@@TheRealKarinaRusher rather using Outlook to get the output, I connected the flow to the sharepoint to get the file saved to a folder which is helping me at the moment.
@@n4ishuu i already fixed if you are interested
Thanks
Brilliant, thanks!
It's a video which is really underrated! May you be blessed!
For some reasons, it didn’t work for me, I was only able to see “Microsoft Power Automate” nothing else
Thank You for the video. Does it work when Power BI on my computer is closed? How can I make it work out of access to my computer but refresh it online?
What if I have more than 3 datasets? Can we get items from share point list and loop through?
Nice video. Thank you for your explanation!
Very well explained Shahab!
I have already gone through all the shamanic rites, dancing with a tambourine.... It didn't work until I changed the names of the parameters to RangeStart and RangeEnd. It's just awesome:) So much searching and such a stupid solution.....
Great explanation. Thank you
Thank you, Persian John Lovitz
will this work for end users with viewing access on the workspace, and free license only?
Great video! Any idea how do I make this with a schedule cloud flow and not a click button? Im not able to get the CSV in the format of a table (only as a one-line output inside the CSV file) .In my case, it is sending an email but I want to send the output table as a CSV file... thanks!