Posts

Showing posts with the label PowerBI

Preparing Dashboard Data - March 2021

Preparing Dashboard Data Modules Module 1: Introduction to the Power BI Environment Module 2: Preparing Dashboard Data Module 3: Creating Interactive Visualizations Module 4: Power BI Finishing Touches Module 5: Power BI Advanced Data Modelling Example Learning Outcomes Import data into Power BI Desktop from a wide variety of data sources How to join different data sets together, even if they come from different files, databases or other sources Clean and transform your data so it’s ready for use with Power BI Delve into “Get Data” and an introduction to understanding “M” code (Power Query language) Turn short, wide data tables into long, tall tables and why this is so useful for Power BI Join multiple data tables together and understanding relationships Create efficient data models: merging, appending and structuring your datasets to create the optimal structure Apply your Power Query skills to Excel and when to choose one over the other Use different techniques for creating and utili...

Creating Interactive Visualizations - March 2021

Creating Interactive Visualizations Modules Module 1: Introduction to the Power BI Environment Module 2: Preparing Dashboard Data Module 3: Creating Interactive Visualizations Module 4: Power BI Finishing Touches Module 5: Power BI Advanced Data Modelling Example   Link :  Creating-interactive-visualizations

Power BI Finishing Touches - March 2021

Power BI Finishing Touches Modules: Module 1: Introduction to the Power BI Environment Module 2: Preparing Dashboard Data Module 3: Creating Interactive Visualizations Module 4: Power BI Finishing Touches Module 5: Power BI Advanced Data Modelling Example   Event Link :  Power BI Finishing Touches

Join us! Power BI Instructor Led Training! Data Modeling & Shaping on 24 & 25 March 1:00 PM-5:00PM PDT

Join us! for Power BI instructor led training over two days on the 24th March and 25th March, 2021 from 1:00 PM – 5:00 PM PDT each day. Jeroen (Jay) ter Heerdt, Yana Berkovich, and Alex Powers from the Power BI team at Microsoft, will be hosting an 8 hour training delivered over 2 days (4 hours each) as well as answering your live questions during the sessions!  This fantastic team will walk us through Power BI capabilities to enhance the data model and help shape your data for business users. Reference and event links :  Power BI Instructor Led Training

Power BI February 2021 Feature Summary

Welcome to the first feature summary of 2021! This month, amongst others, we have a couple of updates on ongoing previews, as well as a new color picker that features RGB color selector and a search bar to make discovery of features easier.   Here is the full list of February updates: Reporting DirectQuery for PBI datasets and Azure Analysis Services Updates (preview) Search Bar Model View Updates (preview) New Field List (preview) Small Multiples (preview): gridlines and background colors Color picker Smart guides for aligning objects are now available in the mobile layout view New filter operations: “is empty” and “is not empty” More granular control over certificate revocation check for web connections Analytics Anomaly detection now in ribbon Data connectivity Snowflake: Support for Custom Roles Parquet Files: Connector Available in Power BI Desktop Hive LLAP: Support for Windows Authentication Salesforce: API Update SAP HANA and BW: New Documentation Service Ema...

Power BI December 2020 Feature Summary

  The last update of 2020 is here! We know you are excited for this update, like a kid excited to open their presents. This update is our holiday present to you! So what is in the box? Well, first of all, not one, but two long-awaited features are now available in preview:  Small multiples  and  DirectQuery for Power BI datasets and Azure Analysis Services . We know the wait has been long, but the time is finally here to start using these features. But wait, there are more gifts to unpack! What about data protection sensitivity labels making their appearance in Power BI Desktop? Or a new Home List experience in the Service? Want to set a custom publish message? You got it. Dark mode support for our Android app? Done. To top it off there are a couple of new visuals and template apps this month and updates in the data preparation, data connectivity, developers and embedded space. We even have a couple of pointers to what is coming soon. Enough to keep you busy dur...

Power BI Datasources

Image
The following table shows the data sources that Power BI supports for datasets, including information about DirectQuery and the on-premises data gateway.   File Data Sources: Database Data Sources: Power Platform Data Sources: Azure Data Sources: Online Services Data Sources: Other Data Sources: Microsoft Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Download and Installation of Power BI

Image
Step 1: Open bellow link  https://powerbi.microsoft.com/en-us/ Step 2 : Go to download session and select power BI desktop Step 3 : Click on " See download or language options " Click on download as shown in bellow  Choose the download which you want download  Step 4 : Double click on setup file Click on next  Select installation location  Click on next

What is a Power BI

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. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want. The parts of Power BI Power BI consists of several elements that all work together, starting with these three basics: A Windows desktop application called  Power BI Desktop . An online SaaS ( Software as a Service ) service called the  Power BI service . Power BI  mobile apps  for Windows, iOS, and Android devices. These three elements—Power BI Desktop, the service, and the mobile apps—are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively. Beyond those th...