Moving from QlikView (finally)

Some of this is going to be dependent on interpretation but here goes an attempt at this:

Qlik Feature Necessities

o Formalized training for developers and end-users

Yes, this exists as DIAD and DIAH training for both users and developers and there is formal training from Radacad and others out there.

o Allow end users to make their own objects in the dashboard and share them

Yes, you can do this in either the Service or the Desktop

o App refresh scheduling

You can setup automatic refresh in the Service

o Centralized management console

There is a Power BI and Office 365 Admin/Tenant area that serves as a central management area. Failures are tracked in audit logs and ability to schedule other things, not sure what that is but there is native integration with Power Automate so you can pretty much do whatever you want.

§ Track failures

§ Gantt charts to track when apps run

§ Ability to schedule other things on top of power bi apps like batch files

o Ability to link into SAP

Yes, there are 3 different SAP connectors 

o 3 billion rows with efficient speed

§ Curious to see a chart of load speed when comparing input and sql server stream mode

Microsoft demonstrates a trillion row dataset with extremely good performance. For something like this you would want to probably use Direct Query and aggregation tables. I've done tens of millions of rows in an import model but not sure I've ever done a billion plus.

o Access restriction between apps

Is there security? Yes. There are lots of ways to segment this in terms of workspaces, individual security on reports within workspaces and even row level security (RLS) so segmenting security even within the report itself.

o Centralized interface for all applications at once

No idea what this means. The Service surfaces everything you have access to.

o Restrictions between BI and IT since IT would own PowerBI ecosystem

You could do this with separate tenants or separate workspaces, there are tons of different usage models

o Error logging

Office 365 audit logs contain errors

o Variable usage

Assuming this means that you can use variables, yes. If it means there are various ways of using the system, that's also true

o Load scripting?

No clue what this means. You can setup automatic refreshes. There is also the Power BI REST API. Plus native integration with Power Automate so you can pretty much script whatever you want. Not to mention integration with Azure DevOps and Power BI deployment pipelines

o Relationship mapping for apps

Not quite sure what this means but there is functionality for seeing what datasets go with what reports, etc.

· NPrinting Functionality

In a broad sense, there is email and subscription capabilities and printing capabilities. They probably work differently than QlikView but, yes, in general, you can do all these sorts of things.

• o Ability to send emails with specific charts and tables in the body
• o Send attachments
• o Send one email to multiple people rather than multiple emails to multiple people
• o Let users own email distribution list
• o Custom expression modification/filters in objects extracted
• o Scheduling these runs
• o Determining if it is interstitial or third party program

o Explanation of full power of expressions inside PBI

Yes, all this exists in DAX, etc.

§ Nested statements

§ Case statements

§ Set Analysis

§ Bin ranges

o Pivot tables

Called matrix visualizations or you can use the Analyze in Excel to create an actual honest to god pivot table if you so choose

o Straight tables that allow shrinking and expanding columns to hide and auto-update sums and counts etc

Yes, you can do all that in Table visualizations

o Button functionality

Yep, has buttons

o Field groups and cycle between them with buttons in charts/graphs

Yes, you can create groups and hierarchies and there are techniques for making things dynamic like that although the specifics will depend on exactly what you are trying to do and will likely work differently in Power BI than in QlikView but should be able to achieve the same effects using bookmarks, etc.

o Drill downs of hierarchical fields

Yep, multiple, multiple ways of doing this, drill through between pages in reports, inside of visuals and even drill through between reports

o Embedded images

Yes

o Gauges

Yes, native plus additional third party

o Trellis charts

Yes, third party (free and pay) but native soon (small multiples) see roadmap

o Waterfall chart

Yes, native plus additional third party

o Plugins

Yes for just about everything, very extensible, connectors, visuals, etc.

o Color customization

Yes, themes, etc.

o Event triggers

Yes via Power Automate, etc.

o VB/Python/SQL/JS script embedding

Yes, but this is dependent on exactly what is meant here and what you are trying to do, has native integration with things like R, Python, SQL, etc. Very broad requirement

o Geo Mapping

Yes, has many different map visuals, native integration with Bing maps, ArcGIS, etc.

o Conditional formatting

Yes, for almost everything how, even visual titles, etc. Conditional formatting options include background color, font color, data bars, icons, web url

o Current selections visible to remove as a centralized location

No idea what this means. Might be referring to the equivalent of sync slicers?

o Type and text formatting

Yes

o Text boxes with expression

Yes, you use measures and card visuals for this if I understand the requirement.

o Real time update text objects

Yes, you can do real time connectivity via Live connections, Direct Query and streaming but not entirely sure of the specific use case here

o Calendar selections

Yes

o Sliders

Yes, relative date slicers, etc. Between slicers

o Bookmarks to save pre-selected selections

Yes, called bookmarks

o Multiple charts in a single space, visibility determined by tabs or buttons (grouping containers)

Yes, you can overlap visuals and hide them depending on bookmarks and you can group visuals

o Conditional charts that would go invisible if a condition is met

Yes, see above

o Nested expression variables

No idea what this means exactly. Nested IF statements? yes. SWITCH statements? yes In general, DAX can do pretty much anything

§ Front end buttons that house expressions

o Specify object sizes

Yes, you can set page sizes and specific sizes for visuals

o Exporting charts to excel

Yes, there is Export for visuals as well as Analyze in Excel

o Alternate states

This is broad, not well defined but almost certain yes

o Custom sorting

Yes there are various sorting options for visuals, etc.

o General chart animations

Not entirely sure what is meant here but supports SVG animations, etc. Also scatter charts can be animated.

o Object locking by user

Yes, you can lock visuals

o Object hiding by user

Yes, you can hide visuals

o Tab hiding by user

Yes, you can hid tabs

Greg, 

This is perfect.  

I have been going through some UDEMY PBI courses the last few weeks, and I knew PBI could handle whatever QlikView has been doing for our team, but I was all over the place when trying to writeup what you did.  Thank you very much.  I wish you the best in these difficult times.