Power BI Family

BizticsCom King
A free video tutorial from BizticsCom King
Passionate data expert in Business Intelligence field.
4.3 instructor rating • 5 courses • 26,050 students

Learn more from the full course

Microsoft Power BI - Business Intelligence for Beginners

Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI

32:20:55 of on-demand video • Updated January 2021

  • Learn to use the easiest Business Intelligence tool to create stunning reports and dashboards.
  • learn how you can visualize that data in a meaningful way to revile insights into your business like never before.
  • learn how, with Power BI, to connect to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services etc....
  • learn how to, with the power of basic DAX, create powerful calculations and comparisons across multiples tables of data.
  • Learn how to create advanced DAX measures and calculated columns for complex calculations.
  • Learn Dataflows (new CDM base, Azure Lake gen2), what it is and how to use and configure databases in it.
  • Learn how to use charts using visuals like column, line, pie, combo, Scatter, Treemap, Funnel, Gauges and KPIs to name a few.
  • Easily clean the messy data, model your data as per your requirement and format your report to make it look beautiful and professional.
  • Learn to create powerful tables and matrix of reporting data.
  • Learn how to use Text Boxes, Shapes, Images, maps, and other visuals.
  • Learn how to turn data into insight and data into interactive visualizations to tell a story.
  • Learn how to use advanced features like Report page tooltips and Bookmarks.
  • Learn to use Custom Visualizations and Themes in Power BI.
  • Learn  and develop data modeling skills.
  • Learn how to automate the cleansing of data.
  • Learn how to  collaboration and sharing of content on Microsoft's Powerful platform.
  • This hands on course will prepare you to start your data analytics career.
  • Learn Dashboard-in-a-day at your own pace at home or at your office.
  • Learn Power BI Best Practices, Tip and Tricks.
English [Auto] In this video, we're going to discuss the power, a product family. There are six products in this family. First one is powered by the service power based services, a self-service cloud hostis business intelligence platform that empowers analysts to build data models, data, exploration's reporting and dashboards. It enables anyone to visualize, analyze data, produce beautiful reports in the minutes, then publish them for your organization to consume on the web or across mobile devices. It is easy, fast and free unless you are using power by a provision which is around nine 95 per month per user. And we are going to discuss this in the later in this video. Next is powered by a desktop, powered by a desktop is totally free available Windows application that allows analysts to design self-service data models you can use powered by a desktop to mash up data from various data sources and then combine it for creating interactive dashboards and reports. Explore your data wherever it is in the cloud or on the premise. It can clean, transfer and mash up data from multiple sources in a few clicks. It also enable business users to dig deeper into the data and find patterns they may have otherwise missed with these features, like quick measures, grouping, forecasting and clustering. This is a tool we're going to use the most in the future in our course, next part of the family is powered by a premium is a very new from Microsoft targeting large organizations, but will be a premium for the dedicated capacity environment, giving your organization more consistent performance without requiring you to purchase per user license. Right now, if you have to buy pro license, it is 1995. So if you are reading the reports on online, probably a dot com, you have to pay 995 per user to Microsoft, to Microsoft created those who has over 2000. There is a calculator online too. I will get you the link. Also on that, beside cost saving power via premium is appealing from the performance standpoint as it offers a dedicated environment just for your organization, your BVA audience is widespread power, a premium less to distribute dashboards, reports and other comments broadly without purchasing individual licenses for each recipient, whether they are inside or outside of your organization. Next in the family is power via mobile. Pottermore via Mobile is freely available mobile application for US Android Windows and e-mail based tablets and smartphones. With its help, users can view the reports and dashboards in power. TV.com also can monitor the business right from the phone. Keep on top of that, KEMPSON reports. Use Natural Language Quarrie to ask questions of your data and or use Cortana by just asking to bring your reports and dashboards to you. As we show in the last video, you can also configure push notifications for personal data through your device, see your data updates in deal time on phones, tablets and Apple Watch. So this is the power of power via mobile. Another new member of the power is power via embedded. It lets developer embed intractable media reports in custom apps or help your customer access the data they need to make better decisions. They can do it right from within the app you have created. You can create use API to do that and embed visuals into apps, portals, SharePoint, team service, etc.. And the last member of the power base is probably a reporter. This gives you a choice to deploy report to work cloud or and on premise. And the trust doesn't have to be exclusive. This is a good option for the organization needs an on premise report portal that hosts only power reports, but also operational SSR reports and Excel reports power by a reporter to give you the user or the users access to the data inside and the enterprise reporting capabilities of the server reporting services in on premise solution. Let people visually explore data and quickly discover patterns to make better and faster decisions. At the same time, you need the precisely formatted reports your business needs. You will also be able to confidently scale to thousands of users because the power of the reporting service is based on the proven enterprise grid platform. You can organize your reports in the folders, manage access and update it as often as you want. So that was a product about the power of the family. So let's check out the pricing also. Let's see how much they cost. So I'm on the website, you can pause this video and go to this by yourself if you need to know more, but I'm going to just go here and you know, this is actually updated on March 2018. So it shows that the power behind the stop is free, totally free. We know that. And perpetual license licensing is also totally free. And they also have those dogs here. You can click on this and go there. I'm going to post this. You are also in the resources so you guys can go if you could not. You know, it's very small for you to look at. It's probably April is nine ninety nine per user. But it also depends on how Microsoft has licensing with your company. If you have an enterprise license, it may be six dollar, five dollar for dollar, depending on what kind of license you have. So this is if you do not have anything to do with Microsoft, we're not doing any business right now with Microsoft. The license course is 995, same day here. So it shows for 99 per month for each quarter. But this, again, depends on your relationship with Microsoft. If you are already giving them a lot of business, this may be very low. Same here. Embedded is six twenty five a month. Bercaw Gateway is totally free, both gateways and personal Gateway and Enterprise Gateway. Microsoft has you can check out again here. They both are free and very easy to configure. We are going to do it here in the course. So mobile is also totally free. You can download from our store or Android store also. You know, I just looked at the bottom and I find out they are competing with with Tableau. Of course, Tableau is expensive. Then, you know, they are one hundred seventy five thousand for eight calls for Tableau server. But premium you can compare with the premium. So premium is still five times twelve is like sixty thousand a year or so is compared to hundred seventy five thousand. And professional is a professional license. User license is seventy dollars instead of 1995, maybe six or seven dollars for you if you are doing business with Microsoft again here also two hundred sixty thousand dollar plus sixty. But yeah it is expensive. So we are not going to get into this. If you want. I'm going to post a URL, you can get a look at it. But yes, Bahbah is pretty cheap as compared to all the other tools available in the market. Thank you for taking the time to watch this video and I will see you in the next lecture.