- Видео 12
- Просмотров 4 789
Dragon's Data
Литва
Добавлен 18 сен 2013
Hi, I'm Odeta!
If you're just starting to use analytical tools such as SQL or Power BI, or you're already using them but want to learn more, I'm here to help you.
Here, I'll share the best practices I'm using at work, so if you're keen on improving your skills, you're in the right place.
I hope my videos will be valuable to you!
If you're just starting to use analytical tools such as SQL or Power BI, or you're already using them but want to learn more, I'm here to help you.
Here, I'll share the best practices I'm using at work, so if you're keen on improving your skills, you're in the right place.
I hope my videos will be valuable to you!
Power BI & Git Integration Step-by-Step Tutorial
If you want to revert your changes when your Power BI Desktop file crashes or you made many DAX formula changes and didn't know which one worked, version control is your saviour.
Previously, there were no other options except to create multiple PBIX files. Now, with Git integration, version control can be done automatically. So, in this in-depth tutorial, I'll show you how to set up the integration.
For prerequisites, read my blog post: dragonsdata.com/git-integration-with-power-bi/.
00:00 Intro
0:50 Power BI Desktop Part
3:11 Local Repository (aka Repo) Installation
5:11 Azure DevOps Setup for the Remote Repository
6:54 Connecting Remote & Local Repos
8:50 Connecting Repos with Power BI Service...
Previously, there were no other options except to create multiple PBIX files. Now, with Git integration, version control can be done automatically. So, in this in-depth tutorial, I'll show you how to set up the integration.
For prerequisites, read my blog post: dragonsdata.com/git-integration-with-power-bi/.
00:00 Intro
0:50 Power BI Desktop Part
3:11 Local Repository (aka Repo) Installation
5:11 Azure DevOps Setup for the Remote Repository
6:54 Connecting Remote & Local Repos
8:50 Connecting Repos with Power BI Service...
Просмотров: 1 105
Видео
How to Make Hidden Slicers\\Filters Panel in Power BI?
Просмотров 2,7 тыс.3 года назад
In this video, I'll show you how to create Slicers\Filters Panel which can be hidden or shown by one click in Power BI. Was something unclear? Let me know in the questions section! :) QUESTION - Have a question about Power BI, SQL or anything else? Post in the comments section of this video! Subscribe to my channel Here: ruclips.net/channel/UCCEDiv1XE0gKGR0oE9hJccw 👉 Power BI related videos pla...
How to Import Data From a File to SQL Server
Просмотров 593 года назад
In this short video you'll find out the easiest way to import your data from a file (excel: xlx, xlxs, csv or text file: txt) into a SQL Server. QUESTION - Have a question about Power BI, SQL or anything else? Post in the comments section of this video! Subscribe to my channel Here: ruclips.net/channel/UCCEDiv1XE0gKGR0oE9hJccw 👉 Power BI related videos playlist: hruclips.net/video/c7PJcj4GKqk/в...
Power BI Report and Dashboard Tutorial - My Whole Workflow When Making A Report and Dashboard
Просмотров 703 года назад
In this video I'm showing from the start until the end how to make a report with Power BI using data from Excel. So this includes: - data import - data cleaning - analyzing data - answering questions with graphs / charts - using filters - publishing to web (Power BI Services) - difference between report and dashboard - making a dashboard LINK: My FREE "Power BI First Steps Guide": bit.ly/2XIfq0...
What Are The Most Common SQL Beginners Mistakes?
Просмотров 3264 года назад
In this video, I'll present the Top 5 Mistakes done by SQL beginners. These mistakes I saw during my almost 8 years of working experience and teaching others. So if you want to be better at writing SQL queries and know the best practices, this video is for you! LINK: to practice SQL when you don't want to use a server (you don't have a server or don't want to install free MySQL server): www.w3s...
6 Ways How to Combine Your Data Quickly in Power BI
Просмотров 274 года назад
Learn how to combine your data in additional 6 ways by using JOINs in Power BI. All you need to have is two tables or files and at least one common field/column in all of them. 00:28 - example tables presented 01:33 - tables connection via relationships 03:21 - 1st way - Left Join 06:05 - 2nd way - Right Join 07:02 - 3rd way - Full Outer Join 07:54 - 4th way - Inner Join with result example at ...
Group By Clause - Sql Tutorial
Просмотров 454 года назад
In this tutorial I'll explain when to use GROUP BY and how it works in SQL. It doesn't matter if it is SQL Server, My SQL or other server, it will work. Also, you'll get the answer why you get the error: "Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause", if you watch until the end. Enjoy! 👉 Power BI related videos playlist:...
Combine Multiple Files in Power BI Desktop - Join CSV or Excel Files to One
Просмотров 994 года назад
If you have multiple excel, csv or txt files and want them to combine easily and without copy - paste, this video is for you. In this video you'll learn how to combine these files from one folder with the help of Power BI Desktop and Power Query Editor. Video about joining multiple tables which are already imported in Power BI: ruclips.net/video/OXTUnEnYfwA/видео.html Playlists: Power BI relate...
How to Combine Multiple Tables in Power BI
Просмотров 424 года назад
In this video you'll see how to combine multiple tables with Append Queries in Power BI. Connect with me Facebook: AnalyticsSimplified Instagram: analyticssimplified Music: Silent Partner - Unusual Habitat
SQL101 Into. How Data is Stored? Simple SQL Query
Просмотров 324 года назад
In this video, you will learn more about data storage in SQL databases and how to write the simple SQL query. Contact me: Facebook: AnalyticsSimplified Instagram: analyticssimplified Music: Silent Partner - Drop and Roll
What My Channel is About?
Просмотров 1594 года назад
In this video you can find out what this channel will be about and a little about me. Connect with me Facebook: AnalyticsSimplified Instagram: analyticssimplified Music from RUclips Audio Library [Aka YAL] Music provided by RFM: ruclips.net/video/CCPXfflu0qo/видео.html
How to Get Data from Website with Power BI
Просмотров 1204 года назад
In this video, you'll get a step-by-step tutorial on how to get data from web pages, import it to Power BI and clean it in order to have perfect data for creating a report. You can follow me in: Instagram: analyticssimplified Facebook: AnalyticsSimplified
Such detailed and clear explanations !!! Thanks a lot
Why you stopped making videos?
I didn't stop. I just don't do them often. :)
Is there a way though to enable syncing my PBI workspace with the git repo? Or should I manually hit the Update all button every time I push some changes?
I don't understand your question. If you ask about "My Workspace" that you see in Power BI Service, Git integration isn't supported. If I didn't answered your question, please provide more details.
Will it worked if we are using shared dataset (Semantic mode as connector)?
I don't know if this is what you asked, but.. Suppose, you have a report with a shared semantic model. The report is in a workspace with Git integration (let's call it the Git workspace), and the shared semantic model is in a simple workspace. If you make some changes to the semantic model, they will be seen in the Git workspace, but you won't see "Git status: Uncommitted." But you will see it if you make any changes to the report in the Git workspace.
Wow, amazing tutorial! Thank you so much for the clear and detailed explanation. Keep up the good work!
Good video ..thank you for detailed explaination
hello, great video, thank you. Do you know if it's possible to do the same without needing to press CTLR while clicking ?
Hi! If you mean holding CTRL when opening/closing the slicer panel, then no. You always need to do that in Power BI Desktop, but in Power BI Service, you just click when you or someone else uses the report with this panel.
I've watched a few of these 'how to hide a slicer panel' videos, but yours made everything click and I was able to create a hidable slicer panel! So Cool! Thanks!
Thanks for posting such videos...though u have very few subscribers on this channel but your videos content is too good and spot on. Please don't stop posting such resourceful videos.
Thanks a lot! :)
Video doesn't have a clarity plz upload it once again
Hi Dilip, what do you mean by "clarity"? I can see it well at 1080p or even higher.
The video was blur
@@dragonsdata audio quality option it shows not available
@@dilipkumar-ck1nc I think problem is on your end. :( Because I looked at this video from phone and computer (windows os and used MS Edge and Chrome), and everything worked perfectly, audio and video.
@@dragonsdata k I will try tq and Iam planning for interview on powerbi can u give us any awareness or questions or tips to success in my interview
Thought this was going to be another usless video but was surprised at the end where i got what i needed. I was interested in how to hide the panel and keep the filters and you covered that !! Thank you very much !! Keep it up !
Thanks! I'm glad it was useful! :)
Great video, thanks!
Nice solution..keep it up.. Just a one feedback length of your video is bit long as comparison to other video on same topic..
Thank's for the feedback, Nitin!
Apologies for the echo, but I noticed it when it was too late and couldn't removed it. I hope this video still brings value! :)
Awesome