Power BI Family

BizticsCom King
A free video tutorial from BizticsCom King
Passionate data expert in Business Intelligence field.
4.4 instructor rating • 3 courses • 17,197 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

31:40:25 of on-demand video • Updated May 2020

  • 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 be a product family. There are six products in this family plus one is power be a service power be a services is self-service cloud hosted his business intelligence platform that empowers analysts to build data models data explorations reporting and dashboard it enables anyone to visualize and 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 b a provision which is around ninety five per month per user and we are going to discuss this in the later in this video. Next is power by a desktop power b a desktop is totally free available Windows application that allows analysts to design self-service data models you can use power b 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 product of the family is power b a print is a very new from Microsoft targeting the large organizations power b a premium offers a dedicated capacity environment giving your organization more consistent performance without requiring you to parties per user license right know if you have to buy Pro license it is nine ninety five. So if you are collaborating the reports on online probably a dot com you have to pay in 995 per user to Microsoft. So 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 be a premium is appealing from the performance standpoint as it offers a dedicated environment just for your organization your B.A. audience is wide spread power be a premium less to distribute dashboards reports and other condoms broadly without purchasing individual licenses for each recipient whether they are inside or outside of your organization. Next in the family is power be a mobile father not be a mobile is it freely available mobile application for us and drugs windows and SDM email based tablets and smartphones. With its help users can view the reports and dashboards in power b a dot com also can monitor the business right from the phone keep on top of that KPI then reports use natural language query 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 flows through your device see your data updates in deal time on phones tablets and Apple Watch. So this is the power of power be a mobile. Another new member of the power b is power be embedded it less developer embed interactive power b reports in custom maps or help your customer access and data. The need to make better decisions they can do it right from within the app you have created you can create use EPA to do that and embed visuals into apps orders SharePoint team service etc.. And the last member of the power B.A. is a report sir. This give you a twice to deploy report to work load or and on premise and it trust doesn't have to be exclusive. This is a good option for the organization needs an on premise report portals that host only power B.A. reports but also operational assessment reports and excel reports. Probably a reporter will give you the use or the user's access to the data insights and the enterprise reporting capabilities of the Sequel Server Reporting Services in on premise solution. Let people visually explore data and could discover patterns to make better and faster decisions at the same time near the precisely formatted reports. Your business needs. You will also be able to confidently scale to thousands of users because the power be a reporting service is based on the proven enterprise grade 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 be a family select 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 through this by yourself if you need to know more. But I'm gonna just go here and this is actually updated on March 2018 so it shows that the power b a desktop is free or delivery. We know that and perpetual licenses. Licensing is also totally free and they also have those dogs here you can click on this and go there. I'm gonna 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 power b APR is nine ninety nine per user but data also depends on how Microsoft has licensing with your company. If you have a 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 do not doing any business right now with Microsoft. The license course is nine ninety five. Same here. So it shows for 99 per month for it. Correct. But this again depends. Your relationship with Microsoft. If you are already giving them a lot of business this may be very low. Same way here embedded is 625 a month per core 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 gonna do it here in the course. So mobile is also totally free. You can download from either 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 tabloids is expensive. Then you know they are one hundred seventy five thousand forty eight cores for Tableau Server but premium you can compare with the premium so premium is still high times twelve is like sixty thousand a year or so it is compared to one hundred seventy five thousand and so professionals tableau professional license user licenses Seventy dollar instead of nine ninety five or maybe six or seven dollars for you if you are doing business with Microsoft again. Here also 260000 dollar plus 64. Yeah it is expensive so we're not going to get into this if you want. I'm going to post to you Earl you can get a look at it but yes Barbie 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.