We are beginning a new series on SQL – A Magic Series. We will see few of many, yet effective tricks & solutions to make SQL easy in daily use. Let’s begin!! So, the Question we are dealing here is: What does the SQL minus sign (-) mean in ORDER BY -emp_no DESC; ? Before answering that, let’s see, how ORDER […]
Posts Tagged ‘analytics’
JIRA – Views, Dashboards, JIRA Connect
This blog, last, in our series on Atlassian Optimizing JIRA will cover creating Views & Dashboards and Connecting JIRA with other applications to make it best for you. (Read previous post here on Optimizing JIRA by Adjusting Personal Settings). Jira gives you many ways to see your work : boards, backlogs, roadmaps, etc. In this blog, […]
Dashboards in JIRA
Dashboard is a customized screen to give you a high-level snapshot of everything happening in Jira. Dashboards in Jira are made up of small configurable blocks called gadgets (Introduction, Projects, Assigned to Me, and Activity Stream). We can create multiple dashboards for different projects OR one single dashboard that spans all the work we’re involved with. How […]
What is Bravo for Power BI?
What is Bravo for Power BI? Bravo studio is a design before, no code tool which allows you to turn your app designs and prototypes into real publishable mobile apps (both iOS and Android). You can use Bravo to build even complex apps by connecting your design to external tools via APIs. In this blog, […]
What is Supplier 360 and What Does It Look Like
The Challenge in Supply Chain Let’s face it. You and your suppliers are linked together and what they do affects you. So if your supplier data is fragmented across dozens or even hundreds of systems, it’s probably costing you. What is causing these supply chain leaks? Data stored in various places like supply chain management […]
Introduction to “Export to PDF” in Power BI Desktop
Microsoft has released the feature Export to PDF option from Power BI Desktop. This feature has been available in every update of the Power BI desktop since August 2018. Read to explore this option and how to use it. Now, let’s get started. The following screenshot refers to the sample of my report. How To […]
EXPLORE TIME TRAVEL IN SNOWFLAKE
Have you ever wondered if it would ever be possible to time travel like in the old movies with a time machine? If we could go back in time and see the world, would we? If you asked me, I would have said yes! But not in the way that Hollywood portrays science fiction films. […]
How to Create and Use Paginated Reports in Power BI
Paginated Reports are the same as SSRS, which have come to Power BI with advanced features for better reports. Paginated Reports are well designed & formatted reports which are perfectly sized so we can print and share the reports effectively. We can also load images and charts on these reports. We can create highly formatted […]
How Journey Science Works with Analytics and Data Tools
Delivering effective customer experiences requires an omnichannel mindset. Customers want brands to understand their needs and help them on their journey, no matter what part of the organization they are interacting with. Your website or mobile app visitors do not think in terms of channels, product lines, or business units, they just think about their […]
How to implement incremental loading in Snowflake using Stream and Merge
Snowflake is Cloud hosted relational database used to create Datawarehouse on demand. Data in the data warehouse can be loaded as full load or incremental load. The full load is a process of deleting whole existing data and reloading it again. Full loads are time and resource-consuming tasks compared to incremental loads that only load […]
IBM Cloud Pak for Data- Multicloud Data Integration and Data Governance
IBM Cloud Pak for Data- Multicloud Data Integration and Data Governance: As we all know, IBM Cloud Pak for Data is a cloud-native solution that enables you to put your data to work quickly and efficiently. Let’s understand below features of IBM Cloud Pak for Data. I’ll also be discussing what practical experience I have […]