Sunday January 21st 2018

Categories

Insider

Archives

‘Business Intelligence’ Archives

Will Tableau be a verb in years to come? | #RMWisdom16

Will Tableau be a verb in years to come? | #RMWisdom16

Great information Tableau functionality and growing popularity. Tableau is growing tentacles and expanding outside of business analytics, according to Paul Lilford, senior director of technology and market intelligence at Tableau Software, Inc. Lilford spoke to Dave Vellante and Jeff Frick, cohosts of theCUBE, from the SiliconANGLE Media team, [...]

Canned Reports

Canned Reports

I worked with clients from variety of industries where they bought Standardized ERP and Accounting Soft wares like Med ACT for Healthcare and Pharmacies, Microsoft Dynamics for global financial and business management application, ITrac for Security and Surveillance and many other manufacturing software. These software meet their basic reporting [...]

Tableau an amazing Data Visualization Software

Tableau an amazing Data Visualization Software

I would like to discuss my experience in using Tableau Public a Data Visualization Software. That’s an amazing software with excellent capabilities of Data Visualizations. We can create dashboards and Data Story, these are areas which I have explored so far. I have worked in SAP Dashboard also but when comparing it with Tableau, there is no [...]

Why Management Dashboards And Analytics Will Never Be The Same Again

Why Management Dashboards And Analytics Will Never Be The Same Again

A picture can paint a thousand words, the saying goes. But unless we know how to decode its message, a picture can also be difficult to read. Words, on the other hand, usually have a very direct meaning and are simple to understand. But critical messages can be lost if they are not used in an efficient way, and structuring them efficiently [...]

A Better Way to Model Data

A Better Way to Model Data

Over the last three decades ERP, CRM, and Analytical systems have evolved. However the way in which those systems store that data has not. In fact in those 3 decades there has been no change in the way that ERP, CRM, and Analytical systems store data. Generally speaking, modern day ERP and CRM systems are based upon data that has been modeled [...]

Storytelling with Data – Most Sought after Skill to become a great Enterprise Data Scientist

Storytelling with Data – Most Sought after Skill to become a great Enterprise Data Scientist

The target market or audience of a business might find data science boring but all that can gain traction is the analysis packed with a compelling story that can guide them where they need to be. There are not enough people to fill the job role of enterprise data scientists who can tell convincing stories using various data visualization tools. [...]

Mini-glossary: Business intelligence and analytics terms you should know

Mini-glossary: Business intelligence and analytics terms you should know

Ad Hoc Query The ability to create a one-off, "on demand" report from BI or analytics software that answers a specific business question. Anonymization The severing of links between people in a database and their records to prevent the discovery of the source of the records, and to maintain privacy and confidentiality. Behavioral [...]

Open data, SSIS and Excel

Open data, SSIS and Excel

Recently Downloaded the Large dataset from UK Government Open Data Website i.e. Land Registry Price Paid Data from 1995 to 2015 about 24 million definitive records dating back to January 1995. Used the SSIS to get the data into SQL Server from CSV. Initially aggregate the data using the following query, select YEAR(), [...]

SSIS Tutorial Part 10 -How to Redirect Rows From Flat File Source in SSIS Package

SSIS Tutorial Part 10 -How to Redirect Rows From Flat File Source in SSIS Package

In this video we will learn how to read the data from flat file source and then produce Data Conversion Errors by changing source data and Truncation Error by increasing the width of data in our flat file.

Reading data from multiple Excel files dynamically using SSIS

Reading data from multiple Excel files dynamically using SSIS

in this video: demonstates extracting data from excel files dynamically using SSIS. also demonstrates how to make connection managers and other properties dynamic.

 Page 3 of 161 « 1  2  3  4  5 » ...  Last »