Fernando Escobar

167 Flips | 6 Magazines | 312 Likes | 1 Following | @FernandoEsc5asp | Keep up with Fernando Escobar on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Fernando Escobar”

Power BI Waterfall Chart: What’s That All About?

You’ve heard the news about Power BI Desktop release with bunch of new features. If you don’t, read blog post here to understand new features of …

Data Visualization

Epic Introduction to Power BI [video]

<b>Yay, finally our first ever full length Power BI tutorial is up</b>. In this 30 minute video tutorial, learn how to get some data in to Power BI and make …

Power BI

Power BI – Using Functions for repeatability and can easily repeat Applied Steps to your data

In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address<p>What I did forget to elaborate on …

Databases

Differences between Machine Learning, Predictive Analytics and Robotics Process Automation(RPA)

With the emergence of digitization, every organizations is looking for ways to improve some of their business processes and also reimagine some of …

Machine Learning

Data Driven Subscriptions in Power BI

What was that? Did I just say you could create a data driven subscription in Power BI? Like old school SSRS reporting where i can determine that …

Databases

Business Intelligence vs. Business Analytics - The Data Point

When I was first hired at RJMetrics, I was a recent college grad, and the concepts of “business intelligence” and “business analytics” were still a …

Power BI Date Dimension - Creating Dynamically with M-Query

This article will show you in simple steps how to create a Date Dimension in Power BI using Power Query's M Language which can replace your old date …

Power BI

Reading Zip files in PowerQuery / M

Being a fan of PowerBI, I recently looked for a way to read zip files directly into the Data Model, and found this blog which showed a usable …

what is best way to send email SSRS report

what is best way to send email SSRS report [Answered]RSS<p>1 reply<p>Last post Sep 13, 2012 01:30 PM by inquisitive_mind<p>‹ Previous Thread|Next Thread …

Import Tabular Data from PDF using Power Query

<i>Level: Intermediate</i><p>Today I am sharing a process I developed that allows you to <b>import tabular data from a PDF document into Excel (or Power BI) using</b> …

Automated updating of BW data in Excel files (BEX & AO) via VBA/VBscript – Part 2

In my <b>previous blog</b> we used VBscript and VBA macros to update BW workbooks in BEX and Analysis for Office.<p>Its a simple and low cost way to auto-update …

Automated updating of BW data in Excel files (BEX & AO) via VBA/VBscript

For a little while now I’ve been looking for hands-off ways to auto-update Excel files with data from our BW system, without having to use …

Import CSV from zipped Email Attachment to SQL Server

Every day I receive an email from an external 3rd party which has data attached in a zipped CSV format.<p>What I want to do is automate the import of …

Optimize function parameters

<b>Background:</b>I'd like to solve a wide array of optimization problems such as asset weights in a portfolio, and parameters in trading strategies <b>where</b> …

Python Programming

How to Set Up SQL Server Database Mail in One Easy Script

Database Mail in Microsoft SQL Server is a powerful, but under-utilized ally for any Database Administrator. It's been around for years but often …

Configure and Send Database Email in SQL Server 2012 Express Edition

Hello and welcome, lets discuss how to Configure and Send Database Email in SQL Server 2012 Express Edition. One of the main difference in SQL Server …

How to email SQL query results to your smartphone using the sp_send_dbmail stored procedure

Introduction<p>Sometimes there are tasks that require too much time to finish during business hours and we need to leave the office with some still …

Setting up Database Mail for SQL Server

By: Greg Robidoux | Read Comments (14) | Related Tips: 1 | 2 | 3 | More > Database Mail<p>Problem<p>Many things have changed starting with SQL Server 2005 …

Here's How the IRS Calculates Your Income Tax

Your income tax is far more complex than simply applying a tax rate to the money you earn.<p>The U.S. tax code is quite complex, so it's no wonder many …

How to setup SQL Server alerts and email operator notifications

<b>Thursday, December 14, 2017 - 10:16:41 AM - Susan Qi</b><p>Excellent work! Thank you.<p><b>Sunday, October 08, 2017 - 9:37:09 AM - Andrew</b><p>Hello,<p>I have removed …

Database Mail

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database …

Moving Data From Excel to SQL Server - 10 Steps to Follow - Simple Talk

You need to create a package to import data from an Excel workbook into a SQL Server table, using SQL Server Integration Services as a tool. What …

Spoon - Import MHT/MHTML Table Structure

Hi,<p>I have not done this.<p>I recall an old thread on the topic of HTML data extraction.<p>Short explained how I solved my Problem so far:<p>- Load the .mht …

10 techniques and practical examples of data mining in marketing

THE SECRETS OF DATA MINING FOR YOUR MARKETING STRATEGY<p><b>To enhance company data stored in huge databases is one of the best known aims of data mining</b>. …

5 real life applications of Data Mining and Business Intelligence

<i>As the importance of data analytics continues to grow, companies are finding more and more applications for Data Mining and Business Intelligence.</i> …

Search Based Analytics | Business Intelligence Dashboard Tool

Search Based Business Analytics for Humans<p>Take your analysis to the next level by search based data discovery and visualize data across multiple …

Google Automatically Rejects Most Resumes for Common Mistakes You've Probably Made Too

Former HR chief Laszlo Bock says Google gets 50,000 resumes a week. This is how it eliminates many of them.<p>Want to get hired at Google (or any other desirable employer)? Chances are, you won't, because your resume is getting in your way. Not because you didn't phrase things just right, or you …

5 Expert Tips for Selecting the Right Business Intelligence Dashboard Tool

Business Intelligence tools have become the go-to solution when urgent decision-making is required thanks to their ability to provide in-depth data …

Big Data

5 side hustles you can do sitting on your sofa

Netflix is paying people to binge watch their shows, and other ways to make easy money<p>Couch potato? Try cash potato.<p>Netflix announced this month that …