Maintain & Monitor : Power BI Premium Capacities

Khilitchandra's Business Intelligence Blog Posted on by

Hi, Good Saturday to you all.

Microsoft Power BI Team has shared a very good news – Now you can maintain and monitor your Premium capacity Power BI resources & Usages.

Premium Capacity Monitoring App is now available for us. This app supports capacity in monitoring the health of premium capacities and making sound decisions about the best use of them and when to scale them so that your users get the best possible experience.

The app can be installed by searching for “Power BI Premium Capacity Monitoring” in the Power BI apps or click here to get it now (please ensure that you are an admin of at least one capacity before installing the app. Power BI Admin is not enough to see the capacity details).

Some helpful links:
What is Power BI Premium?
How to manage Power BI Premium Capacity?
How to deploy and manage Power BI Premium Capacity for Organization?
Still need more information?

Thanks, Khilit

 

AZURE DATA WEEK – Azure Data Virtual Conference

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

There an upcoming Virtual Conference setup by Pragmatic Works.
Super affordable (29 USD for entire Conference) and interesting. Go for it.

AzureDataWeek

AzureDataWeek

When?
October 8-12, 2018

Where?
Online

Need more information?
azuredataweek@pragmaticworks.com

Highlights of agenda per day:

Monday, October 8th -> Power BI
– The Exciting Future of Power BI
– World-class Power BI Solutions
– Accelerating Development with Power BI Embedded and APIs
– Digital Storytelling with Power BI
– Enterprise Identity and Security in Power BI
– Data Security and Management in Power BI
– Deploying and Managing Enterprise Power BI
– Migrating to Power BI Quickly and Efficiently

Tuesday, October 9th -> Cloud Data Platform
– The Future of Azure Data Platforms
– Choosing the Right Azure Data Platforms
– Optimizing Your Azure Data Platforms
– Performance Tuning SQL Server in Azure
– Choosing Open Source Data Platforms in Azure
– Security Best Practices for Azure Data Platforms
– Managing Cloud Data Platforms in a DevOps World
– Rapid Migration of End of Life SQL Servers to Azure

Wednesday, October 10th -> Cloud Data Warehousing and BI
– Rethinking Data Warehousing in Azure
– Modern Data Warehouse Design Patterns in Azure
– Moving and Managing Data Flow in Azure with Azure Data Factory
– Data Loading and Streaming Patterns in Azure
– Data Security for the Modern Data Warehouse Platform
– Managing and Monitoring Your Azure Data Warehouse Platform
– Migrating to Azure Data Warehouse in Less Time

Thursday, October 11th -> Big Data, Analytics and AI
– The Future of Big Data and Analytics in Azure
– Big Data Design Patterns in Azure
– Using Cosmos DB to Modernize Your Azure Architecture
– AI Solution Patterns in Azure
– Developing Data Bricks in Azure
– Data Science Lifecycle in Azure
– Security and Privacy in Analytics and AI
– Managing and Optimizing Azure Data Lake
– Accelerating Your Big Data Migration to Azure

Friday, October 12th -> Cloud Infrastructure
– Upcoming Innovations in Azure Infrastructure
– Introduction to Using Containers in Azure
– Architecting Connectivity in Azure
– Best Practices for Managing Azure Storage
– Building Your Azure Security Checklist
– Manage and Monitor Your Azure Spending Like a Pro
– Monitoring and Reporting on Your Azure Environment
– Tools and Techniques to Manage Your Azure Environment
– Building Your First Azure Migration Plan

Note: Session details are subject to change. Full session details will be provided soon.

Register and Enjoy.
Thanks, Khilit

SQL Saturday #784, Singapore – Great & Memorable Event – Thanks to All :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

I am very happy to share that we have successfully completed our yearly major event – SQL Saturday #784, Singapore. On behalf of entire Singapore PASS Chapter, we thank to all our prestigious speakers (Amit R S Bansal, Patrick Flynn, Karen Lopez, Dinesh Priyankara, Sanjiv Venkatram, David Alzamendi, Denny Cherry, Kevin Boles, Manohar Punna, Asanka Padmakumara, Naginder Singh Virdi, Senthamil Selvan, Sarbjit Singh Gill, Jason Aw, Dharmendra Keshari) for delivering great sessions and fill the day with knowledge and fun.

Special thanks to PASS and Microsoft for gracious support to make this event great. Thanks to event organizers, mentors and all volunteers. Indeed memorable event.

Stay tuned at this page for event material (FREE) 🙂

SQL Saturday #784, Singapore

Thanks, Khilit

 

Power BI Report Server – August 2018 Updates

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

People who are working on Power BI On-Premise, there are more updates for Power BI Report Server. Major features are related look and feel about the Reports/Dashboards. Plus there are few updates on Modelling and Formulas.

Browse through below links and check out all examples provided by Microsoft Power BI Blog with examples 🙂

REPORTING

  1. Report Theming
  2. Buttons to trigger actions
  3. Combo chart line styles
  4. Improved default sort for visuals
  5. Numeric slicer
  6. Advanced slicer syncing
  7. Log axis improvements
  8. Data label options for funnel chart
  9. Set line stroke width to zero
  10. High contrast support for reports
  11. Donut radius control
  12. Pie and donut detail labels position control
  13. Format data labels separately for each measure in a combo chart
  14. New visual header with more flexibility and formatting
  15. Wallpaper formatting
  16. Tooltips for table & matrix
  17. Turn tooltips off for visuals
  18. Slicer accessibility
  19. Formatting pane improvements
  20. Stepped line support for line and combo charts
  21. Sorting experience improvement
  22. Print reports through Export to PDF (in Power BI Desktop)
  23. Create bookmark groups
  24. Slicer restatement
  25. Report page tooltips

ANALYTICS

  1. New DAX function: COMBINEVALUES()
  2. Measure drill-through
  3. Conditional formatting by a different field
  4. Conditional formatting by values

MODELING

  1. Filtering and sorting in data view
  2. Improved locale formatting
  3. Data categories for measures
  4. Statistical DAX functions

Stay tuned and keep rocking 🙂

Thanks, Khilit

Interact with Power BI with PowerShell

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

PowerShell is awesome command-line tool. Microsoft Team has recently released couple of Power BI APIs and PowerShell cmdlets – which will allow you to work with workspaces, dashboards, reports, datasets, and so forth in Power BI. But these cmdlets and APIs are not just limited to Administration purposes but also for other Power BI users.

Screen-shot from Microsoft Blog Site

Basically there are 4 general categories of users who can leverage these cmdlets:

  1. Power BI administrators, who must work with resources at the Power BI tenant level, such as to enumerate workspaces, dashboards, reports, and datasets, recover orphaned workspaces, or discover the data sources used in the various datasets across an entire organization.
  2. Power BI users, who want to manage the resources they own in Power BI, such as to create a backup of all published reports across multiple workspaces.
  3. Power BI developers, who need to have a quick and easy way to prototype their solutions, such as by trying out custom REST API calls in the PowerShell console without having to resort to Web-based prototyping tools and copying access tokens.
  4. Power BI community members, who wish to contribute to the benefit of others, such as by joining the PowerShell community for Microsoft Power BI and helping build even more cmdlets.

Find out more on details and usage here (good article by Kay Unkroth):
https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/

Detailed and updated list of cmdlets are available in GitHub:
https://github.com/Microsoft/powerbi-powershell

Enjoy the adventure of Power BI explorations using PowerShell 🙂
Thanks, Khilit

Power BI Report Server – For On-Premise BI Solutions

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

Power BI Report Server is now part of Power BI Premium. Power BI Premium, with Power BI Report Server will get you covered with a complete solution. Power BI Premium provides dedicated capacity in the cloud and enhanced performance – without requiring per-user licenses for those consuming reports. And, it includes Power BI Report Server for on-premises reporting too.

Try this link to get started with Power BI Report Server (Download FREE trial). You just have to fill small form and that will kick the download. And good thing is – you can use any valid email address of yours for this download to work.

What Power BI Report Server comprises of: Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs, along with the tools to create Power BI reports, paginated reports, mobile reports, and KPIs. Look below screen-shot -> How beautiful & well managed it looks 🙂

Power BI Report Server

Power BI Report Server – From Microsoft Site

See the comparison of Power BI Report Server with SQL Server Reporting Services (SSRS)
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#comparing-power-bi-report-server

See the comparison of Power BI Report Server with Power BI Service (i.e. www.powerbi.com)
https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Don’t forget to see the licensing terms
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server

Get yourself familiarized with features of Power BI Report Server
https://docs.microsoft.com/en-us/power-bi/report-server/get-started

If you still want to get a complete glance of it then watch a video presentation from Microsoft Ignite session here.

Post questions of comments if you have about Power BI Report Server. I would be happy to help.
Thank you, Khilit

How to think & plan for Power BI in Hybrid Environment?

Khilitchandra's Business Intelligence Blog Posted on by

Hi, Good Saturday to you all 🙂

Power BI is growing leaps and bounds. It’s becoming more and more advanced and rich in its each release every month. BI folks loved the product since its release. But I still see that many architects/organizations still face challenges in uncovering true values of Power BI usage merely due to their unique organizational/architectural challenges.

I came across a while paper this morning which shows best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. Its written by Joseph D’Antoni, Stacia Misner and released in Aug 2014. Little old but still valuable as it talks about architectural solutions rather than product features.

Have a look at this white paper and say thanks to them 🙂 It’s available for download here.

Provide your feedback and comments below if you still have any special challenges for Power BI.

Enjoy your weekend, Khilit

Power BI Desktop August 2018 Feature Summary

Khilitchandra's Business Intelligence Blog Posted on by

Hello all,

Power BI Desktop August 2018 Feature Summary is out. Find out all features with demonstration at this link: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/

Here’s the complete list of August updates:

Reporting

Analytics

Modeling

Custom visuals

Data connectivity

Learn more about the featured companies including 3AG Systems at https://www.3agsystems.com/

Hope you enjoy all of these like always 🙂 Have a great Saturday.

Khilit

Webinar : Building a KPI Scorecard with Custom Visuals in Power BI

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys,
Good Saturday to you all 🙂

There is an upcoming webinar which you might want to book your calendar for.
It’s “Building a KPI Scorecard with Custom Visuals in Power BI”.

Charles Sterling and Reid Havens will show us that knowing the right visuals or DAX to build out a high-level scorecard report can be challenging. Learn about some great custom visuals in conjunction with DAX calculations to build out a quality scorecard template to use in your business.

Here is the YouTube link which will be live on “16th Aug 2018 10:00 AM PST“.
Please book your calendars according to your local time.

Thanks, Khilit

Streaming Datasets in Power BI

Khilitchandra's Business Intelligence Blog Posted on by

Hi,

It was a great pleasure presenting my session (Streaming Datasets in Power BI) @ DataCamp 2018 on 10th March 2018 in Microsoft.

Thank you all.

Here is my slide deck: Power BI – Streaming Datasets – DataCamp 2018

Thanks, Khilit