Skip to main content

Introduction to Power BI

 

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Microsoft Excel workbook, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what's important, and share that with anyone or everyone.


Data Connectors in Power BI

  1. Excel Sheet
  2. Text or CSV file
  3. XML or Json File
  4. SQL Server Database
  5. MySQL Database
  6. IBM Database
  7. Azure Database
  8. Google Big Query
  9. Google Analytics
  10. AWS Redshift ... etc.

The Parts of Power BI

Power BI consists of a Microsoft Windows desktop application called Power BI Desktop, an online SaaS (Software as a Service) service called the Power BI service, and mobile Power BI apps that are available on any device, with native mobile BI apps for Windows, iOS, and Android.
  • Power BI Desktop
  • Power BI Service
  • Power BI Apps (Windows, Android and iOS)

Flow of Work in Power BI

The flow of work in Power BI begins in Power BI Desktop, where a report is created. That report is then published to the Power BI service and finally shared, so that users of Power BI Mobile apps can consume the information.

You can't create a report in Power BI Service because you can't connect data sources to your report.
You can edit the report in Power BI Service but can't create a report.

So the very first thing, Create a report in Power BI Desktop and then you will publish your report to power BI service where you can change/edit the report.

You can also access the report in Microsoft Mobile Apps but still can't edit the report.

Flow : Power BI Desktop > Power BI Service > Power BI Mobile



Download Power BI Desktop

You can download Power BI Desktop from the official website or the Microsoft Store
  1. Official Website  Link
  2. Microsoft Store  Link
Labels:

Comments

  1. Vivek KhatorMay 19, 2021 at 10:56 PM

    Very Nice!!!

    ReplyDelete
    Replies
    1. MeticluxMay 23, 2021 at 3:33 PM

      Thanks for your valuable review. Keep learning !!!

      Delete
  2. Kiran JameelDecember 16, 2021 at 11:48 PM

    Many thanks for sharing such incredible knowledge. It's really good for your Website.
    The info on your website inspires me greatly. This website I'm bookmarked. Maintain it and thanks again.
    I'm really impressed with your writing skills, as smart as the structure of your weblog.

    Microsoft Excel Crack
    iSkysoft Data Recovery Crack
    Proteus Crack

    ReplyDelete
  3. Malik Muzzamil Wadd BhiraJanuary 2, 2022 at 1:25 AM

    Thanks For Sharing Such a Nice Post.
    ISkysoft Data Recovery Crack
    Simplify3D 5.0 Crack
    DVDFab Passkey Crack
    Express VPN Crack

    ReplyDelete
  4. HusnainJanuary 2, 2022 at 3:17 AM

    Thanks for sharing Such a Nice Post.
    AnyTrans for iOS Crack
    Onesafe PC Cleaner Pro Crack
    VideoProc Crack
    ISkysoft Data Recovery Crack
    Autodesk AUTOCAD Crack

    ReplyDelete
  5. Nanfor IbéricaJanuary 2, 2022 at 4:11 PM

    Nice and interesting information and informative too.
    MB-800: Dynamics 365 Business Central Functional Consultant Associate

    ReplyDelete
  6. MalaJanuary 19, 2022 at 11:04 AM

    My response on my own website. Appreciation is a wonderful thing...thanks for sharing keep it up. Quick Heal Total Security Crack
    AnyTrans Crack
    Renee Undeleter Crack
    Internet Explorer Crack
    <a

    ReplyDelete
  7. softeirJanuary 26, 2022 at 6:55 PM

    Appreciation is a wonderful thing...thanks for sharing kepp it up.
    clamwin-antivirus
    dvdfab-passkey
    syncios-pro-ultimate

    ReplyDelete
  8. KANJU KINGFebruary 6, 2022 at 2:57 AM

    Such a Nice post. Thanks for Awesome tips Keep it up .
    Quick Heal Antivirus Crack
    windowsup.net

    ReplyDelete
  9. HarryApril 5, 2022 at 4:37 PM

    I guess I am the only one who came here to share my very own experience. Guess what!? I am using my laptop for almost the past 6 years, but I had no idea of solving some basic issues. I do not know how to Download Cracked Pro Softwares But thankfully, I recently visited a website named PCexe.org
    All Pro Cracked Softwares Download
    Minitab Crack
    AviDemux Crack
    Windows 7 Manager Crack
    JixiPix Photo Formation Crack
    OneSafe Data Recovery Pro Crack

    ReplyDelete

Post a Comment

Popular posts from this blog

ETL Process in Power BI

 We can make a data analysis process easy using the ETL process in Power BI Desktop.  What is ETL in Power BI Desktop ? ETL (Extract, Transform and Load) data is a process by which we can change the shape of our dataset. You can perform several operations in Power Query editor.  During the ETL process, data is extracted from a data source (raw data), then transformed, corrected and then loaded for the next step. You can do this process manually in Excel but it is time consuming process and at the end of the day, we don't want to do the same process for upcoming new data. It should be done by automation. If you have not read my last blog on Power BI then please go through the link  Blog We will start the ETL process step by step A. Extract Data  B. Transform Data C. Load Data A. Extract Data from a data source To extract data from a data source, click on Get Data. We will extract raw data from Excel sheet and then will connect the sheet with Power BI. You can ext...
9 comments
Read more

Excel for Data Analysis

 Most important functions of Excel for data analysis Excel and google sheets are powerful tools for managing the raw data. There are many functions that can make your task easier.  As a Data Analyst, you use many functions like VLOOKUP, Pivot Tables, Conditional formatting, etc., So here, I have listed some most important functions of excel for data analysis : - 1. Pivot Table Pivot tables are a way to aggregate data to look at smaller subsets without using manual filters. Without it, you would use the manual filters on every column, check to see if they work, and then use [SUM] functions. All of that is built for you with a pivot table and pivot chart. You can set rows, columns, values and filters at the same at your level. You can use any aggregate function while creating a Pivot table.  In short, Pivot table gives you the summary of your data. We will see more detail in next blog. 2. VLOOKUP VLOOKUP stands for "Vertical Lookup", this means the act of looking up da...
1 comment
Read more

Get started with Power BI Desktop

The very first question comes in mind is Should I use Power BI Desktop or Power BI Service to create a dashboard ? You should get started with Power BI Desktop. As I have already told in the first blog ( Blog 1 ) that the flow of creating a report is    Power BI Desktop > Power BI Service > Power BI Mobile
5 comments
Read more