July, 2013

article thumbnail

How to send SSIS logs (errors) through email

BI Insight

First of all I want to explain the process of sending SSIS Logs through email for better understanding. As you might know you can save SSIS logs in several ways for administration purposes. In this article our focus is on how to send SSIS logs to the administrator whenever an event like a package failure … Continue reading How to send SSIS logs (errors) through email.

article thumbnail

BI for Decision Making

ElegantJ BI

Betsy says: I’m sure you’re sick of hearing me talk about Business intelligence. But, I’m just trying to help you! BI helps you to plan for the future and make confident decisions about products, pricing, competition, markets, financials and other business factors. Today, every business expects its employees to manage results on a daily basis. But, to do that, every employee must have easy access to timely, accurate information.So, how exactly does BI help businesses and employees?

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

What’s New With Tableau User Groups

Tableau

Tiffany Chan. Community Programs Specialist. Anonymous (not verified). July 30, 2013 - 5:14pm. October 3, 2022. Welcome to the Tableau User Group Monthly, where you can find a curated list of highlights and content from a month of User Group events all over the globe. The User Group Monthly highlights content by topic, allowing readers to synthesize all the top meeting learnings.

article thumbnail

How to send more precise SSIS logs (errors) through email

BI Insight

First of all you need to read my previous article called “How to send SSIS logs (errors) through email” as the processes are pretty the same. However, you need to create some changes in the Execute SQL Task (ref.: section “J” number 5 and 12 of “How to send SSIS logs (errors) through email”). As … Continue reading How to send more precise SSIS logs (errors) through email.

article thumbnail

Individual Development Plan Template

There’s no way around it: sometimes employees need your help. Use this free template to clarify expectations, share resources, and set a timeline. Best case scenario, this process helps them improve. Worst case, your great recordkeeping keeps you compliant even if they move on. Download the template today!

article thumbnail

How to store a SQL Server database diagram into a file and share it with others?

BI Insight

Sometimes you might feel you need to store the database diagrams in a file basis. I’ve faced to this feeling specially when I was testing some databases which were under development. I didn’t like to create the whole database diagrams that I’ve created before in a database that a new version of it is newly … Continue reading How to store a SQL Server database diagram into a file and share it with others?

130
130

More Trending

article thumbnail

Installing SQL Server 2014 CTP1

BI Insight

After downloading the SQL Server 2014, mount the media file downloaded and run “setup.exe” In SQL Server Installation Centre click on “Installation” Click on “New SQL Server stand-alone installation or add features to an existing installation” Note that if you have any of previous versions of SQL Server installed on your machine the setup process … Continue reading Installing SQL Server 2014 CTP1.

130
130
article thumbnail

Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013

BI Insight

Reporting services 2012 integrated with SharePoint 2013 In this post I’m going to describe installing SSRS 2012 integrated mode with SharePoint 2013. As some guys are pretty new to SSRS 2012 or SharePoint or even SSRS integrated with SharePoint, I am explaining the situation from scratch. Requirements: SQL Server 2012 Enterprise (or Business Intelligence) edition … Continue reading Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013.

article thumbnail

Business Intelligence for the Conscientious Employee…Or, Why Am I Accountable for Things I Can’t Control?

ElegantJ BI

Every business employee has heard the words, ‘empowerment’ and ‘accountability’. But, how can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? If your business is struggling with these issues, it’s important to understand the role business intelligence tools can play in solving your problems.

article thumbnail

Business Intelligence for the Conscientious Employee…Or, Why Am I Accountable for Things I Can’t Control?

ElegantJ BI

Every business employee has heard the words, ‘empowerment’ and ‘accountability’. But, how can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? If your business is struggling with these issues, it’s important to understand the role business intelligence tools can play in solving your problems.

article thumbnail

Business Valuation Software: Free Guide to Valutico Platform

Explore our free guide to Valutico, the platform that revolutionizes automated report generation, offers access to 1 million M&A transactions, enables quick benchmarking, and streamlines the entire valuation process. With Valutico, you gain access to: 30-Minute Valuations: Rapidly producing accurate results. 3TB of Financial Data: The expansive data you need at your fingertips.

article thumbnail

Business Intelligence for the Conscientious Employee…Or, Why Am I Accountable for Things I Can’t Control?

ElegantJ BI

Every business employee has heard the words, ‘empowerment’ and ‘accountability’. But, how can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? If your business is struggling with these issues, it’s important to understand the role business intelligence tools can play in solving your problems.

article thumbnail

Tell us how BI has helped (or CAN help) with empowerment and accountability

ElegantJ BI

Tell us how BI has helped (or CAN help) with empowerment and accountability Betsy says: How can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? This is a question many businesses are pondering.

article thumbnail

Tell us how BI has helped (or CAN help) with empowerment and accountability

ElegantJ BI

Tell us how BI has helped (or CAN help) with empowerment and accountability Betsy says: How can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? This is a question many businesses are pondering.

article thumbnail

Tell us how BI has helped (or CAN help) with empowerment and accountability

ElegantJ BI

Tell us how BI has helped (or CAN help) with empowerment and accountability. Betsy says: How can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? This is a question many businesses are pondering.

article thumbnail

How to Stay Competitive in the Evolving State of Martech

Marketing technology is essential for B2B marketers to stay competitive in a rapidly changing digital landscape — and with 53% of marketers experiencing legacy technology issues and limitations, they’re researching innovations to expand and refine their technology stacks. To help practitioners keep up with the rapidly evolving martech landscape, this special report will discuss: How practitioners are integrating technologies and systems to encourage information-sharing between departments and pr

article thumbnail

How to send SSIS logs (errors) through email

BI Insight

First of all I want to explain the process of sending SSIS Logs through email for better understanding. As you might know you can save SSIS logs in several ways for administration purposes. In this article our focus is on how to send SSIS logs to the administrator whenever an event like a package failure … Continue reading How to send SSIS logs (errors) through email.

article thumbnail

How to send more precise SSIS logs (errors) through email

BI Insight

First of all you need to read my previous article called “How to send SSIS logs (errors) through email” as the processes are pretty the same. However, you need to create some changes in the Execute SQL Task (ref.: section “J” number 5 and 12 of “How to send SSIS logs (errors) through email”). As … Continue reading How to send more precise SSIS logs (errors) through email.

article thumbnail

Count tables’ references and tables’ foreign keys

BI Insight

There are some cases that you do not have any documentations for the database that you are working on and you need to investigate the entity relationships and so on. We can understand the database entity relationships better if we can find the number of references to the table or the number of tables’ dependencies. … Continue reading Count tables’ references and tables’ foreign keys.

article thumbnail

Count tables’ references and tables’ foreign keys

BI Insight

There are some cases that you do not have any documentations for the database that you are working on and you need to investigate the entity relationships and so on. We can understand the database entity relationships better if we can find the number of references to the table or the number of tables’ dependencies. … Continue reading Count tables’ references and tables’ foreign keys.

article thumbnail

Maximize Productivity and Simplify IT Management with Conversational AI

ChatGPT has dominated boardroom conversations for months now. From drafting a stock trading program, to creating a SQL query to model data, there are practically no limits to the applications of the AI language model assistant. At ManageEngine, we have been working on our own AI-assistant, Zia. Zia is a fully-trained analytics assistant that can perform a range of functions such as creating and adding reports to dashboards, providing conversational support to data analysis, insight discovery, bu

article thumbnail

I Like Lists But I LOVE Business Intelligence Tools!

ElegantJ BI

I Like Lists But I LOVE Business Intelligence Tools! I like lists! Lists keep me organized and help me get things done. What lists don’t do is to give me all the information I need to make the right decision, establish the right priority or the make right direction. That’s where business intelligence tools come in! With business intelligence tools and Corporate Performance Management solutions my team can effectively fulfill business obligations, and I can do my part to meet corporate objectives

article thumbnail

I Like Lists But I LOVE Business Intelligence Tools!

ElegantJ BI

I Like Lists But I LOVE Business Intelligence Tools! I like lists! Lists keep me organized and help me get things done. What lists don’t do is to give me all the information I need to make the right decision, establish the right priority or the make right direction. That’s where business intelligence tools come in! With business intelligence tools and Corporate Performance Management solutions my team can effectively fulfill business obligations, and I can do my part to meet corporate objectives

article thumbnail

I Like Lists But I LOVE Business Intelligence Tools!

ElegantJ BI

I Like Lists But I LOVE Business Intelligence Tools! I like lists! Lists keep me organized and help me get things done. What lists don’t do is to give me all the information I need to make the right decision, establish the right priority or the make right direction. That’s where business intelligence tools come in! With business intelligence tools and Corporate Performance Management solutions my team can effectively fulfill business obligations, and I can do my part to meet corporate objectives

article thumbnail

How to store a SQL Server database diagram into a file and share it with others?

BI Insight

Sometimes you might feel you need to store the database diagrams in a file basis. I’ve faced to this feeling specially when I was testing some databases which were under development. I didn’t like to create the whole database diagrams that I’ve created before in a database that a new version of it is newly … Continue reading How to store a SQL Server database diagram into a file and share it with others?

100
100
article thumbnail

Data-Backed Secrets for Minimizing Discounts & Maximizing ROI Post-Holiday

Use data to turn one-off holiday shoppers into repeat buyers and effortlessly drive more sales throughout the year. Our guide will give you an in-depth understanding of what triggers your customers to buy and breaks down campaign examples from leading B2C brands.

article thumbnail

How to hash sensitive data for maximising security in SQL Server 2005 and later versions?

BI Insight

SENSITIVE DATA! It’s an interesting topic! In this post I’m trying to explain how to hash data to increase security during ETL. Assume that we have sensitive data stored in several secured source systems. The source systems are located in different countries and different regions. As the source systems themselves are secured, how we can … Continue reading How to hash sensitive data for maximising security in SQL Server 2005 and later versions?

article thumbnail

How to hash sensitive data for maximising security in SQL Server 2005 and later versions?

BI Insight

SENSITIVE DATA! It’s an interesting topic! In this post I’m trying to explain how to hash data to increase security during ETL. Assume that we have sensitive data stored in several secured source systems. The source systems are located in different countries and different regions. As the source systems themselves are secured, how we can … Continue reading How to hash sensitive data for maximising security in SQL Server 2005 and later versions?

article thumbnail

What is Hekaton?

BI Insight

First of all, I’d like to point to the fact that there is almost always a bottleneck with OLTP database’s performance that is related to disk speed. So in-memory processing can improve the current poor performance with disk-based tables significantly as well as achieving scalability. In a very simple and quick explanation, Hekaton is new … Continue reading What is Hekaton?

100
100
article thumbnail

How to define database owner SQL server wide

BI Insight

What does it actually mean that the database doesn’t have a database owner?! It seems odd, but, it is possible. In some cases that the database is created by an application it really happens that the database doesn’t have any database owner. For instance, the databases generated by CRM Deployment Manager doesn’t have database owner. … Continue reading How to define database owner SQL server wide.

100
100
article thumbnail

The Young BA

This article focuses on my experience starting as a customer service representative and working myself up to become a lead analyst in my organization. I did not start with many special skills or talents but I wanted to reflect on what did help me.